1 PACKAGE PON_AUCTION_INTERFACE_PKG AS
2 /* $Header: PONAUCIS.pls 120.4 2005/08/10 16:48:54 xtang noship $ */
3 /*
4 ===================
5 CONSTANTS
6 ===================
7 */
8 success NUMBER := 0;
9 error NUMBER := -1;
10
11 /*
12 ===================
13 PROCEDURES
14 ===================
15 ========================================================================
16 PROCEDURE : Create_Draft_Negotiation PUBLIC
17 PARAMETERS:
18 P_DOCUMENT_TITLE IN Title of negotiation
19 P_DOCUMENT_TYPE IN 'BUYER_AUCTION' or 'REQUEST_FOR_QUOTE'
20 P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
21 P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
22 P_ORG_ID IN Organization id of creator
23 P_BUYER_ID IN FND_USER_ID of creator
24 P_NEG_STYLE_ID IN negotiation style id
25 P_PO_STYLE_ID IN po style id
26 P_DOCUMENT_NUMBER OUT Created Document number
27 P_DOCUMENT_URL OUT Additional parameters to PON_AUC_EDIT_DRAFT_B
28 form function for editing draft
29 P_RESULT OUT One of (error, success)
30 P_ERROR_CODE OUT Internal code for error
31 P_ERROR_MESSAGE OUT Displayable error
32 COMMENT : Creates a draft auction
33 ======================================================================*/
34 PROCEDURE Create_Draft_Negotiation(
35 P_DOCUMENT_TITLE IN VARCHAR2,
36 P_DOCUMENT_TYPE IN VARCHAR2,
37 P_CONTRACT_TYPE IN VARCHAR2,
38 P_ORIGINATION_CODE IN VARCHAR2,
39 P_ORG_ID IN NUMBER,
40 P_BUYER_ID IN NUMBER,
41 P_NEG_STYLE_ID IN NUMBER,
42 P_PO_STYLE_ID IN NUMBER,
43 P_DOCUMENT_NUMBER OUT NOCOPY NUMBER,
44 P_DOCUMENT_URL OUT NOCOPY VARCHAR2,
45 P_RESULT OUT NOCOPY NUMBER,
46 P_ERROR_CODE OUT NOCOPY VARCHAR2,
47 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
48
49 /*======================================================================
50 PROCEDURE : Add_Negotiation_Line
51 PARAMETERS:
52 P_DOCUMENT_NUMBER IN Document number to add line
53 P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
54 P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
55 P_ORG_ID IN Organization id of creator
56 P_BUYER_ID IN FND_USER_ID of creator
57 P_GROUPING_TYPE IN 'DEFAULT' or 'NONE' grouping
58 P_REQUISITION_HEADER_ID IN Requisition header
59 P_REQUISITION_NUMBER IN Requisition header formatted for display
60 P_REQUISITION_LINE_ID IN Requisition line
61 P_LINE_TYPE_ID IN Line type
62 P_CATEGORY_ID IN Line category
63 P_ITEM_DESCRIPTION IN Item Desription
64 P_ITEM_ID IN Item Id
65 P_ITEM_NUMBER IN Item Number formatted for display
66 P_ITEM_REVISION IN Item Revision
67 P_UOM_CODE IN UOM_CODE from MTL_UNITS_OF_MEASURE
68 P_QUANTITY IN Quantity
69 P_NEED_BY_DATE IN Item Need-By
70 P_SHIP_TO_LOCATION_ID IN Ship To
71 P_NOTE_TO_VENDOR IN Note to Supplier
72 P_PRICE IN Start price for line
73 P_JOB_ID IN Job_id for the services job
74 P_JOB_DETAILS IN job details if any
75 P_PO_AGREED_AMOUNT IN PO Agreed Amount
76 P_HAS_PRICE_DIFF_FLAG IN If the line has any price differentials flag
77 P_LINE_NUMBER OUT Line number to which the demand was added
78 P_RESULT OUT One of (error, success)
79 P_ERROR_CODE OUT Internal Error Code
80 P_ERROR_MESSAGE OUT Displayable error
81 COMMENT : Creates a line in a draft auction
82 ======================================================================*/
83 PROCEDURE Add_Negotiation_Line(
84 P_DOCUMENT_NUMBER IN NUMBER,
85 P_CONTRACT_TYPE IN VARCHAR2,
86 P_ORIGINATION_CODE IN VARCHAR2,
87 P_ORG_ID IN NUMBER,
88 P_BUYER_ID IN NUMBER,
89 P_GROUPING_TYPE IN VARCHAR2,
90 P_REQUISITION_HEADER_ID IN NUMBER,
91 P_REQUISITION_NUMBER IN VARCHAR2,
92 P_REQUISITION_LINE_ID IN NUMBER,
93 P_LINE_TYPE_ID IN NUMBER,
94 P_CATEGORY_ID IN NUMBER,
95 P_ITEM_DESCRIPTION IN VARCHAR2,
96 P_ITEM_ID IN NUMBER,
97 P_ITEM_NUMBER IN VARCHAR2,
98 P_ITEM_REVISION IN VARCHAR2,
99 P_UOM_CODE IN VARCHAR2,
100 P_QUANTITY IN NUMBER,
101 P_NEED_BY_DATE IN DATE,
102 P_SHIP_TO_LOCATION_ID IN NUMBER,
103 P_NOTE_TO_VENDOR IN VARCHAR2,
104 P_PRICE IN NUMBER,
105 P_JOB_ID IN NUMBER, -- ADDED FOR SERVICES PROCUREMENT PROJECT
106 P_JOB_DETAILS IN VARCHAR2,-- ADDED FOR SERVICES PROCUREMENT PROJECT
107 P_PO_AGREED_AMOUNT IN NUMBER,-- ADDED FOR SERVICES PROCUREMENT PROJECT
108 P_HAS_PRICE_DIFF_FLAG IN VARCHAR2,-- ADDED FOR SERVICES PROCUREMENT PROJECT
109 P_LINE_NUMBER OUT NOCOPY NUMBER,
110 P_RESULT OUT NOCOPY NUMBER,
111 P_ERROR_CODE OUT NOCOPY VARCHAR2,
112 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
113
114 /*============ADDED FOR UNIFIED CATALOG PROJECT=====================
115 PROCEDURE : Add_Catalog_Descriptors
116 PARAMETERS:
117 P_API_VERSION IN NUMBER
118 P_DOCUMENT_NUMBER IN NUMBER
119 X_RETURN_STATUS OUT NOCOPY VARCHAR2
120 X_MSG_COUNT OUT NOCOPY NUMBER
121 X_MSG_DATA OUT NOCOPY VARCHAR2
122 COMMENT : Adds ip descriptors to a draft auction
123 ======================================================================*/
124
125 PROCEDURE Add_Catalog_Descriptors (
126 P_API_VERSION IN NUMBER,
127 P_DOCUMENT_NUMBER IN NUMBER,
128 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
129 X_MSG_COUNT OUT NOCOPY NUMBER,
130 X_MSG_DATA OUT NOCOPY VARCHAR2);
131
132 /*============ADDED FOR SERVICES PROCUREMENT PROJECT=====================
133 PROCEDURE : Add_Price_Differential
134 PARAMETERS:
135 P_DOCUMENT_NUMBER IN Document number to add line
136 P_LINE_NUMBER IN Line number
137 P_SHIPMENT_NUMBER IN Shipment number
138 P_PRICE_TYPE IN Price Type
139 P_MULTIPLIER IN Multiplier
140 P_BUYER_ID IN FND_USER_ID of the creator
141 P_PRICE_DIFFERENTIAL_NUMBER OUT Price Differential Number
142
143 P_RESULT OUT One of (error, success)
144 P_ERROR_CODE OUT Internal Error Code
145 P_ERROR_MESSAGE OUT Displayable error
146 COMMENT : Creates a price differential in a draft auction
147 ======================================================================*/
148
149 PROCEDURE Add_Price_Differential (
150 P_DOCUMENT_NUMBER IN NUMBER,
151 P_LINE_NUMBER IN NUMBER,
152 P_SHIPMENT_NUMBER IN NUMBER,
153 P_PRICE_TYPE IN VARCHAR2,
154 P_MULTIPLIER IN NUMBER,
155 P_BUYER_ID IN NUMBER,
156 P_PRICE_DIFFERENTIAL_NUMBER OUT NOCOPY NUMBER,
157 P_RESULT OUT NOCOPY NUMBER,
158 P_ERROR_CODE OUT NOCOPY VARCHAR2,
159 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
160
161 /*========================================================================
162 PROCEDURE : Get_Negotiation_Owner
163 PARAMETERS:
164 P_DOCUMENT_NUMBER IN Document Id
165 P_OWNER_NAME OUT FND_USER.USER_NAME of document owner
166 P_RESULT OUT One of (error, success)
167 P_ERROR_CODE OUT Internal Error Code
168 P_ERROR_MESSAGE OUT Displayable error
169 COMMENT : Returns the owner name for a negotiation document
170 ======================================================================*/
171 PROCEDURE Get_Negotiation_Owner(
172 P_DOCUMENT_NUMBER IN NUMBER,
173 P_OWNER_NAME OUT NOCOPY VARCHAR2,
174 P_RESULT OUT NOCOPY NUMBER,
175 P_ERROR_CODE OUT NOCOPY VARCHAR2,
176 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
177
178 /*========================================================================
179 PROCEDURE : Get_PO_Negotiation_Link PUBLIC
180 PARAMETERS:
181 P_PO_HEADER_ID IN PO Header Id
182 P_ROLE IN User is one of ('BUYER', 'SUPPLIER')
183 P_DOCUMENT_NUMBER OUT Negotiation Document number display
184 P_DOCUMENT_URL OUT URL to view negotiation document
185 P_RESULT OUT One of (error, success)
186 P_ERROR_CODE OUT Internal code for error
187 P_ERROR_MESSAGE OUT Displayable error message
188 COMMENT : Returns the Negotiation Document number and Sourcing URL
189 for viewing the Negotiation Document. The Negotiation Document number
190 returned is formatted for display and may not be the same as the
191 pon_auction_headers.auction_header_id. The Document Number should not
192 be used in subsequent calls to this API.
193 ======================================================================*/
194 PROCEDURE Get_PO_Negotiation_Link(
195 P_PO_HEADER_ID IN NUMBER,
196 P_DOCUMENT_ID OUT NOCOPY NUMBER,
197 P_DOCUMENT_NUMBER OUT NOCOPY VARCHAR2,
198 P_DOCUMENT_URL OUT NOCOPY VARCHAR2,
199 P_RESULT OUT NOCOPY NUMBER,
200 P_ERROR_CODE OUT NOCOPY VARCHAR2,
201 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
202
203 /*===================================================================
204 PROCEDURE: add_negotiation_invitees PUBLIC
205 PARAMETERS:
206 p_api_version version of the api
207 x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR
208 x_msg_count OUT Internal code for error
209 x_msg_data OUT Displayable error message
210 P_DOCUMENT_NUMBER IN Negotiation Document number
211 P_BUYER_ID IN FND_USER_ID of the creator
212 COMMENT: Gets distinct vendor_ids and vendor sites
213 across all the requisition lines that are part of the
214 negotiation and adds (bulk inserts ) them as invitees. We do not check
215 for inactive suppliers/ sites in the autocreate process; these
216 will be validated at publish time.
217 =====================================================================*/
218 PROCEDURE add_negotiation_invitees(
219 p_api_version IN NUMBER,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 P_DOCUMENT_NUMBER IN NUMBER,
224 P_BUYER_ID IN NUMBER);
225
226 PROCEDURE get_default_negotiation_style(
227 x_style_id OUT NOCOPY NUMBER,
228 x_style_name OUT NOCOPY VARCHAR2);
229
230 --
231 END PON_AUCTION_INTERFACE_PKG;