7311d92835
Documentation/Design/DatabaseItemToFunctionalSpecificationReference.xls - add rule O-M5 Documentation/pldoc - regenerated Modules/mip_helper_special_cases.pck - make reference to Tripartite rule O-M5 (handled by mip_quotation.pck and mip_tripartite.pck Schema - removed DATA_ITEM_ROLES_IMPORT, added views of enquiries and quote statuses git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3354 248e525c-4dfb-0310-94bc-949c084e9493
125 lines
3.3 KiB
HTML
125 lines
3.3 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
|
|
<HTML>
|
|
<HEAD>
|
|
<LINK REL="STYLESHEET" TYPE="text/css" HREF="plsqldoc.css">
|
|
<TITLE>Package mip_enquiry</TITLE>
|
|
<META name="object" content="PACKAGE">
|
|
<META name="name" content="mip_enquiry">
|
|
<META name="description" content="">
|
|
</HEAD>
|
|
<BODY>
|
|
<TABLE WIDTH="100%"><TR>
|
|
<TD><P ALIGN="LEFT"><STRONG><SMALL></SMALL></STRONG></TD>
|
|
<TD><P ALIGN="RIGHT"><STRONG><SMALL><A HREF="index.html">index</A></SMALL></STRONG></TD>
|
|
</TR></TABLE>
|
|
<TABLE CLASS="MAIN_TABLE"><TR><TD CLASS="DESC_TEXT">
|
|
<P CLASS="MAIN_TITLE">Package mip_enquiry</P>
|
|
|
|
<BR>
|
|
</TD></TR></TABLE>
|
|
<HR>
|
|
<A NAME="Program units"></A>
|
|
<TABLE CLASS="SUB_TABLE"><TR><TD CLASS="SUB_TITLE">
|
|
Program units
|
|
</TD></TR></TABLE>
|
|
<TABLE CLASS="SUB_TABLE">
|
|
<TR><TD VALIGN="TOP" CLASS="TYPE_ITEM">
|
|
<A HREF="#get_enquiry_status">get_enquiry_status</A>
|
|
</TD><TD CLASS="DESC_TEXT" WIDTH=95%>
|
|
|
|
</TD></TR>
|
|
<TR><TD VALIGN="TOP" CLASS="TYPE_ITEM">
|
|
<A HREF="#get_enquiry_role">get_enquiry_role</A>
|
|
</TD><TD CLASS="DESC_TEXT" WIDTH=95%>
|
|
|
|
</TD></TR>
|
|
<TR><TD VALIGN="TOP" CLASS="TYPE_ITEM">
|
|
<A HREF="#set_enquiry_role">set_enquiry_role</A>
|
|
</TD><TD CLASS="DESC_TEXT" WIDTH=95%>
|
|
|
|
</TD></TR>
|
|
<TR><TD VALIGN="TOP" CLASS="TYPE_ITEM">
|
|
<A HREF="#set_enquiry_role2">set_enquiry_role</A>
|
|
</TD><TD CLASS="DESC_TEXT" WIDTH=95%>
|
|
|
|
</TD></TR>
|
|
<TR><TD VALIGN="TOP" CLASS="TYPE_ITEM">
|
|
<A HREF="#set_enquiry_event">set_enquiry_event</A>
|
|
</TD><TD CLASS="DESC_TEXT" WIDTH=95%>
|
|
|
|
</TD></TR>
|
|
<TR><TD VALIGN="TOP" CLASS="TYPE_ITEM">
|
|
<A HREF="#copy_enquiry">copy_enquiry</A>
|
|
</TD><TD CLASS="DESC_TEXT" WIDTH=95%>
|
|
|
|
</TD></TR>
|
|
</TABLE>
|
|
<BR>
|
|
<HR>
|
|
<A NAME="get_enquiry_status"></A>
|
|
<P CLASS="TYPE_TITLE">
|
|
get_enquiry_status
|
|
</P>
|
|
<PRE CLASS="DECL_TEXT">
|
|
FUNCTION get_enquiry_status(p_enquiryid IN NUMBER) RETURN VARCHAR2
|
|
|
|
</PRE>
|
|
<HR>
|
|
<A NAME="get_enquiry_role"></A>
|
|
<P CLASS="TYPE_TITLE">
|
|
get_enquiry_role
|
|
</P>
|
|
<PRE CLASS="DECL_TEXT">
|
|
FUNCTION get_enquiry_role(p_enquiryid IN NUMBER
|
|
,p_rolecode IN VARCHAR2) RETURN NUMBER
|
|
|
|
</PRE>
|
|
<HR>
|
|
<A NAME="set_enquiry_role"></A>
|
|
<P CLASS="TYPE_TITLE">
|
|
set_enquiry_role
|
|
</P>
|
|
<PRE CLASS="DECL_TEXT">
|
|
FUNCTION set_enquiry_role(p_enquiryid IN NUMBER
|
|
,p_partyid IN NUMBER
|
|
,p_rolecode IN VARCHAR2) RETURN BOOLEAN
|
|
|
|
</PRE>
|
|
<HR>
|
|
<A NAME="set_enquiry_role2"></A>
|
|
<P CLASS="TYPE_TITLE">
|
|
set_enquiry_role
|
|
</P>
|
|
<PRE CLASS="DECL_TEXT">
|
|
FUNCTION set_enquiry_role(p_enquiryid IN NUMBER
|
|
,p_partyid IN NUMBER
|
|
,p_rolecode IN VARCHAR2
|
|
,p_description IN VARCHAR2) RETURN BOOLEAN
|
|
|
|
</PRE>
|
|
<HR>
|
|
<A NAME="set_enquiry_event"></A>
|
|
<P CLASS="TYPE_TITLE">
|
|
set_enquiry_event
|
|
</P>
|
|
<PRE CLASS="DECL_TEXT">
|
|
FUNCTION set_enquiry_event(p_enquiryid IN NUMBER
|
|
,p_eventcode IN VARCHAR2) RETURN BOOLEAN
|
|
|
|
</PRE>
|
|
<HR>
|
|
<A NAME="copy_enquiry"></A>
|
|
<P CLASS="TYPE_TITLE">
|
|
copy_enquiry
|
|
</P>
|
|
<PRE CLASS="DECL_TEXT">
|
|
FUNCTION copy_enquiry(p_enquiry_id enquiries.id%TYPE
|
|
,p_enqu_owner parties.id%TYPE
|
|
,p_enqu_supp parties.id%TYPE) RETURN VARCHAR2
|
|
|
|
</PRE>
|
|
<P> </P>
|
|
<P> </P>
|
|
</BODY>
|
|
</HTML>
|