1 PACKAGE pon_auction_interface_pkg AUTHID CURRENT_USER AS
2 /* $Header: PONAUCIS.pls 120.12 2011/12/19 09:41:05 vinnaray ship $ */
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_FAIR_OPP_NOTICE_FLAG IN VARCHAR2 DEFAULT NULL
27 P_DOCUMENT_NUMBER IN OUT Created Document number
28 P_DOCUMENT_URL OUT Additional parameters to PON_AUC_EDIT_DRAFT_B
29 form function for editing draft
30 P_RESULT OUT One of (error, success)
31 P_ERROR_CODE OUT Internal code for error
32 P_ERROR_MESSAGE OUT Displayable error
33 COMMENT : Creates a draft auction
34 ======================================================================*/
35 PROCEDURE Create_Draft_Negotiation(
36 P_DOCUMENT_TITLE IN VARCHAR2,
37 P_DOCUMENT_TYPE IN VARCHAR2,
38 P_CONTRACT_TYPE IN VARCHAR2,
39 P_ORIGINATION_CODE IN VARCHAR2,
40 P_ORG_ID IN NUMBER,
41 P_BUYER_ID IN NUMBER,
42 P_NEG_STYLE_ID IN NUMBER,
43 P_PO_STYLE_ID IN NUMBER,
44 P_FAIR_OPP_NOTICE_FLAG IN VARCHAR2 DEFAULT NULL,
45 P_DOCUMENT_NUMBER IN OUT NOCOPY NUMBER,
46 P_DOCUMENT_URL OUT NOCOPY VARCHAR2,
47 P_RESULT OUT NOCOPY NUMBER,
48 P_ERROR_CODE OUT NOCOPY VARCHAR2,
49 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
50
51 /*======================================================================
52 PROCEDURE : Add_Negotiation_Line
53 PARAMETERS:
54 P_DOCUMENT_NUMBER IN Document number to add line
55 P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
56 P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
57 P_ORG_ID IN Organization id of creator
58 P_BUYER_ID IN FND_USER_ID of creator
59 P_GROUPING_TYPE IN 'DEFAULT' or 'NONE' grouping
60 P_REQUISITION_HEADER_ID IN Requisition header
61 P_REQUISITION_NUMBER IN Requisition header formatted for display
62 P_REQUISITION_LINE_ID IN Requisition line
63 P_LINE_TYPE_ID IN Line type
64 P_CATEGORY_ID IN Line category
65 P_ITEM_DESCRIPTION IN Item Desription
66 P_ITEM_ID IN Item Id
67 P_ITEM_NUMBER IN Item Number formatted for display
68 P_ITEM_REVISION IN Item Revision
69 P_UOM_CODE IN UOM_CODE from MTL_UNITS_OF_MEASURE
70 P_QUANTITY IN Quantity
71 P_NEED_BY_DATE IN Item Need-By
72 P_SHIP_TO_LOCATION_ID IN Ship To
73 P_NOTE_TO_VENDOR IN Note to Supplier
74 P_PRICE IN Start price for line
75 P_JOB_ID IN Job_id for the services job
76 P_JOB_DETAILS IN job details if any
77 P_PO_AGREED_AMOUNT IN PO Agreed Amount
78 P_HAS_PRICE_DIFF_FLAG IN If the line has any price differentials flag
79 P_LINE_NUMBER IN OUT Line number to which the demand was added
80 P_RESULT OUT One of (error, success)
81 P_ERROR_CODE OUT Internal Error Code
82 P_ERROR_MESSAGE OUT Displayable error
83 COMMENT : Creates a line in a draft auction
84 ======================================================================*/
85 PROCEDURE Add_Negotiation_Line(
86 P_DOCUMENT_NUMBER IN NUMBER,
87 P_CONTRACT_TYPE IN VARCHAR2,
88 P_ORIGINATION_CODE IN VARCHAR2,
89 P_ORG_ID IN NUMBER,
90 P_BUYER_ID IN NUMBER,
91 P_GROUPING_TYPE IN VARCHAR2,
92 P_REQUISITION_HEADER_ID IN NUMBER,
93 P_REQUISITION_NUMBER IN VARCHAR2,
94 P_REQUISITION_LINE_ID IN NUMBER,
95 P_LINE_TYPE_ID IN NUMBER,
96 P_CATEGORY_ID IN NUMBER,
97 P_ITEM_DESCRIPTION IN VARCHAR2,
98 P_ITEM_ID IN NUMBER,
99 P_ITEM_NUMBER IN VARCHAR2,
100 P_ITEM_REVISION IN VARCHAR2,
101 P_UOM_CODE IN VARCHAR2,
102 P_QUANTITY IN NUMBER,
103 P_NEED_BY_DATE IN DATE,
104 P_SHIP_TO_LOCATION_ID IN NUMBER,
105 P_NOTE_TO_VENDOR IN VARCHAR2,
106 P_PRICE IN NUMBER,
107 P_JOB_ID IN NUMBER, -- ADDED FOR SERVICES PROCUREMENT PROJECT
108 P_JOB_DETAILS IN VARCHAR2,-- ADDED FOR SERVICES PROCUREMENT PROJECT
109 P_PO_AGREED_AMOUNT IN NUMBER,-- ADDED FOR SERVICES PROCUREMENT PROJECT
110 P_HAS_PRICE_DIFF_FLAG IN VARCHAR2,-- ADDED FOR SERVICES PROCUREMENT PROJECT
111 P_LINE_NUMBER IN OUT NOCOPY NUMBER,
112 P_RESULT OUT NOCOPY NUMBER,
113 P_ERROR_CODE OUT NOCOPY VARCHAR2,
114 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
115
116
117 /*======================================================================
118 PROCEDURE : Add_Negotiation_Line (OverLoaded for CLIN SLIN PROJECT)
119 PARAMETERS:
120 P_DOCUMENT_NUMBER IN Document number to add line
121 P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
122 P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
123 P_ORG_ID IN Organization id of creator
124 P_BUYER_ID IN FND_USER_ID of creator
125 P_GROUPING_TYPE IN 'DEFAULT' or 'NONE' grouping
126 P_REQUISITION_HEADER_ID IN Requisition header
127 P_REQUISITION_NUMBER IN Requisition header formatted for display
128 P_REQUISITION_LINE_ID IN Requisition line
129 P_LINE_TYPE_ID IN Line type
130 P_CATEGORY_ID IN Line category
131 P_ITEM_DESCRIPTION IN Item Desription
132 P_ITEM_ID IN Item Id
133 P_ITEM_NUMBER IN Item Number formatted for display
134 P_ITEM_REVISION IN Item Revision
135 P_UOM_CODE IN UOM_CODE from MTL_UNITS_OF_MEASURE
136 P_QUANTITY IN Quantity
137 P_NEED_BY_DATE IN Item Need-By
138 P_SHIP_TO_LOCATION_ID IN Ship To
139 P_NOTE_TO_VENDOR IN Note to Supplier
140 P_PRICE IN Start price for line
141 P_JOB_ID IN Job_id for the services job
142 P_JOB_DETAILS IN job details if any
143 P_PO_AGREED_AMOUNT IN PO Agreed Amount
144 P_HAS_PRICE_DIFF_FLAG IN If the line has any price differentials flag
145
146 P_LINE_NUM_DISPLAY IN CLM line number
147 P_GROUP_LINE_ID IN Parent Clin Number
148 P_CLM_INFO_FLAG in Is info Line
149 P_CLM_OPTION_INDICATOR In Option indicator
150 P_CLM_OPTION_NUM In option number
151 P_CLM_OPTION_FROM_DATE IN Option frm date
152 P_CLM_OPTION_TO_DATE in Option to date
153 P_CLM_FUNDED_FLAG in is funded line
154 P_CLM_BASE_LINE_NUM in option base line number
155 P_CLM_CONTRACT_TYPE IN complex pricing contract type
156 P_CLM_COST_CONSTRAINT IN complex pricing cost constraint
157 P_CLM_IDC_TYPE IN complex pricing idc type
158 P_UDA_TEMPLATE_ID IN Solicitation Line UDA Template Id
159 P_REQ_LINE_TEMP_ID IN Requisition Line UDA Template Id
160 P_LINE_NUMBER IN OUT Line number to which the demand was added
161 P_RESULT OUT One of (error, success)
162 P_ERROR_CODE OUT Internal Error Code
163 P_ERROR_MESSAGE OUT Displayable error
164 COMMENT : Creates a line in a draft auction
165 ======================================================================*/
166 PROCEDURE Add_Negotiation_Line(
167 P_DOCUMENT_NUMBER IN NUMBER,
168 P_CONTRACT_TYPE IN VARCHAR2,
169 P_ORIGINATION_CODE IN VARCHAR2,
170 P_ORG_ID IN NUMBER,
171 P_BUYER_ID IN NUMBER,
172 P_GROUPING_TYPE IN VARCHAR2,
173 P_REQUISITION_HEADER_ID IN NUMBER,
174 P_REQUISITION_NUMBER IN VARCHAR2,
175 P_REQUISITION_LINE_ID IN NUMBER,
176 P_LINE_TYPE_ID IN NUMBER,
177 P_CATEGORY_ID IN NUMBER,
178 P_ITEM_DESCRIPTION IN VARCHAR2,
179 P_ITEM_ID IN NUMBER,
180 P_ITEM_NUMBER IN VARCHAR2,
181 P_ITEM_REVISION IN VARCHAR2,
182 P_UOM_CODE IN VARCHAR2,
183 P_QUANTITY IN NUMBER,
184 P_NEED_BY_DATE IN DATE,
185 P_SHIP_TO_LOCATION_ID IN NUMBER,
186 P_NOTE_TO_VENDOR IN VARCHAR2,
187 P_PRICE IN NUMBER,
188 P_JOB_ID IN NUMBER, -- ADDED FOR SERVICES PROCUREMENT PROJECT
189 P_JOB_DETAILS IN VARCHAR2,-- ADDED FOR SERVICES PROCUREMENT PROJECT
190 P_PO_AGREED_AMOUNT IN NUMBER,-- ADDED FOR SERVICES PROCUREMENT PROJECT
191 P_HAS_PRICE_DIFF_FLAG IN VARCHAR2,-- ADDED FOR SERVICES PROCUREMENT PROJECT
192 P_LINE_NUM_DISPLAY IN VARCHAR2,
193 P_GROUP_LINE_ID IN NUMBER,
194 P_CLM_INFO_FLAG IN VARCHAR2,
195 P_CLM_OPTION_INDICATOR IN VARCHAR2,
196 P_CLM_OPTION_NUM IN NUMBER,
197 P_CLM_OPTION_FROM_DATE IN DATE,
198 P_CLM_OPTION_TO_DATE IN DATE,
199 P_CLM_FUNDED_FLAG IN VARCHAR2,
200 P_CLM_BASE_LINE_NUM IN NUMBER,
201 P_CLM_CONTRACT_TYPE IN VARCHAR2,
202 P_CLM_COST_CONSTRAINT IN VARCHAR2,
203 P_CLM_IDC_TYPE IN VARCHAR2,
204 P_UDA_TEMPLATE_ID IN NUMBER, --<Sol Project>
205 P_REQ_LINE_TEMP_ID IN NUMBER, --<Sol Project>
206 P_LINE_NUMBER IN OUT NOCOPY NUMBER,
207 P_NEG_LINE_NUM_DISP IN VARCHAR2 DEFAULT NULL,
208 P_RESULT OUT NOCOPY NUMBER,
209 P_ERROR_CODE OUT NOCOPY VARCHAR2,
210 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
211
212
213 /*============ADDED FOR UNIFIED CATALOG PROJECT=====================
214 PROCEDURE : Add_Catalog_Descriptors
215 PARAMETERS:
216 P_API_VERSION IN NUMBER
217 P_DOCUMENT_NUMBER IN NUMBER
218 X_RETURN_STATUS OUT NOCOPY VARCHAR2
219 X_MSG_COUNT OUT NOCOPY NUMBER
220 X_MSG_DATA OUT NOCOPY VARCHAR2
221 COMMENT : Adds ip descriptors to a draft auction
222 ======================================================================*/
223
224 PROCEDURE Add_Catalog_Descriptors (
225 P_API_VERSION IN NUMBER,
226 P_DOCUMENT_NUMBER IN NUMBER,
227 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
228 X_MSG_COUNT OUT NOCOPY NUMBER,
229 X_MSG_DATA OUT NOCOPY VARCHAR2);
230
231 /*============ADDED FOR SERVICES PROCUREMENT PROJECT=====================
232 PROCEDURE : Add_Price_Differential
233 PARAMETERS:
234 P_DOCUMENT_NUMBER IN Document number to add line
235 P_LINE_NUMBER IN Line number
236 P_SHIPMENT_NUMBER IN Shipment number
237 P_PRICE_TYPE IN Price Type
238 P_MULTIPLIER IN Multiplier
239 P_BUYER_ID IN FND_USER_ID of the creator
240 P_PRICE_DIFFERENTIAL_NUMBER OUT Price Differential Number
241
242 P_RESULT OUT One of (error, success)
243 P_ERROR_CODE OUT Internal Error Code
244 P_ERROR_MESSAGE OUT Displayable error
245 COMMENT : Creates a price differential in a draft auction
246 ======================================================================*/
247
248 PROCEDURE Add_Price_Differential (
249 P_DOCUMENT_NUMBER IN NUMBER,
250 P_LINE_NUMBER IN NUMBER,
251 P_SHIPMENT_NUMBER IN NUMBER,
252 P_PRICE_TYPE IN VARCHAR2,
253 P_MULTIPLIER IN NUMBER,
254 P_BUYER_ID IN NUMBER,
255 P_PRICE_DIFFERENTIAL_NUMBER OUT NOCOPY NUMBER,
256 P_RESULT OUT NOCOPY NUMBER,
257 P_ERROR_CODE OUT NOCOPY VARCHAR2,
258 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
259
260 /*========================================================================
261 PROCEDURE : Get_Negotiation_Owner
262 PARAMETERS:
263 P_DOCUMENT_NUMBER IN Document Id
264 P_OWNER_NAME OUT FND_USER.USER_NAME of document owner
265 P_RESULT OUT One of (error, success)
266 P_ERROR_CODE OUT Internal Error Code
267 P_ERROR_MESSAGE OUT Displayable error
268 COMMENT : Returns the owner name for a negotiation document
269 ======================================================================*/
270 PROCEDURE Get_Negotiation_Owner(
271 P_DOCUMENT_NUMBER IN NUMBER,
272 P_OWNER_NAME OUT NOCOPY VARCHAR2,
273 P_RESULT OUT NOCOPY NUMBER,
274 P_ERROR_CODE OUT NOCOPY VARCHAR2,
275 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
276
277 /*========================================================================
278 PROCEDURE : Get_PO_Negotiation_Link PUBLIC
279 PARAMETERS:
280 P_PO_HEADER_ID IN PO Header Id
281 P_ROLE IN User is one of ('BUYER', 'SUPPLIER')
282 P_DOCUMENT_NUMBER OUT Negotiation Document number display
283 P_DOCUMENT_URL OUT URL to view negotiation document
284 P_RESULT OUT One of (error, success)
285 P_ERROR_CODE OUT Internal code for error
286 P_ERROR_MESSAGE OUT Displayable error message
287 COMMENT : Returns the Negotiation Document number and Sourcing URL
288 for viewing the Negotiation Document. The Negotiation Document number
289 returned is formatted for display and may not be the same as the
290 pon_auction_headers.auction_header_id. The Document Number should not
291 be used in subsequent calls to this API.
292 ======================================================================*/
293 PROCEDURE Get_PO_Negotiation_Link(
294 P_PO_HEADER_ID IN NUMBER,
295 P_DOCUMENT_ID OUT NOCOPY NUMBER,
296 P_DOCUMENT_NUMBER OUT NOCOPY VARCHAR2,
297 P_DOCUMENT_URL OUT NOCOPY VARCHAR2,
298 P_RESULT OUT NOCOPY NUMBER,
299 P_ERROR_CODE OUT NOCOPY VARCHAR2,
300 P_ERROR_MESSAGE OUT NOCOPY VARCHAR2);
301
302 /*===================================================================
303 PROCEDURE: add_negotiation_invitees PUBLIC
304 PARAMETERS:
305 p_api_version version of the api
306 x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR
307 x_msg_count OUT Internal code for error
308 x_msg_data OUT Displayable error message
309 P_DOCUMENT_NUMBER IN Negotiation Document number
310 P_BUYER_ID IN FND_USER_ID of the creator
311 COMMENT: Gets distinct vendor_ids and vendor sites
312 across all the requisition lines that are part of the
313 negotiation and adds (bulk inserts ) them as invitees. We do not check
314 for inactive suppliers/ sites in the autocreate process; these
315 will be validated at publish time.
316 =====================================================================*/
320 x_msg_count OUT NOCOPY NUMBER,
317 PROCEDURE add_negotiation_invitees(
318 p_api_version IN NUMBER,
319 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_data OUT NOCOPY VARCHAR2,
322 P_DOCUMENT_NUMBER IN NUMBER,
323 P_BUYER_ID IN NUMBER);
324
325 PROCEDURE get_default_negotiation_style(
326 x_style_id OUT NOCOPY NUMBER,
327 x_style_name OUT NOCOPY VARCHAR2);
328
329 --
330 /*===================================================================
331 PROCEDURE: maintain_clm_relations PUBLIC
332 PARAMETERS:
333 p_api_version version of the api
334 x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR
335 x_msg_count OUT Internal code for error
336 x_msg_data OUT Displayable error message
337 P_DOCUMENT_NUMBER IN Negotiation Document number
338 COMMENT: -- After the lines have been autocreated. Set the CLM clin slin and option relations appropriately.
339 -- Currently the reqline ids have been copied over as it is.
340 -- Now map the correct reqlineids with the neg line numbers and store
341 -- in the negotiation lines table.
342
343 =====================================================================*/
344 PROCEDURE maintain_clm_relations(
345 p_api_version IN NUMBER,
346 x_return_status OUT NOCOPY VARCHAR2,
347 x_msg_count OUT NOCOPY NUMBER,
348 x_msg_data OUT NOCOPY VARCHAR2,
349 P_DOCUMENT_NUMBER IN NUMBER);
350
351
352
353 PROCEDURE maintain_clm_relations(
354 p_api_version IN NUMBER,
355 x_return_status OUT NOCOPY VARCHAR2,
356 x_msg_count OUT NOCOPY NUMBER,
357 x_msg_data OUT NOCOPY VARCHAR2,
358 P_DOCUMENT_NUMBER IN NUMBER,
359 P_line_number IN NUMBER,
360 p_req_line_clin IN NUMBER,
361 p_req_line_opt IN NUMBER);
362
363
364 END PON_AUCTION_INTERFACE_PKG;