40: * @param IN p_bus_doc_date_events_tbl table type for business document date based events
41: */
42: PROCEDURE activateDeliverables (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: p_bus_doc_id IN NUMBER,
47: p_bus_doc_type IN VARCHAR2,
48: p_bus_doc_version IN NUMBER,
41: */
42: PROCEDURE activateDeliverables (
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46: p_bus_doc_id IN NUMBER,
47: p_bus_doc_type IN VARCHAR2,
48: p_bus_doc_version IN NUMBER,
49: p_event_code IN VARCHAR2,
47: p_bus_doc_type IN VARCHAR2,
48: p_bus_doc_version IN NUMBER,
49: p_event_code IN VARCHAR2,
50: p_event_date IN DATE,
51: p_sync_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: p_bus_doc_date_events_tbl IN BUSDOCDATES_TBL_TYPE,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,
55: x_return_status OUT NOCOPY VARCHAR2);
67: * @param IN p_bus_doc_date_events_tbl table type for business document date based events
68: */
69: PROCEDURE cancelDeliverables (
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73: p_bus_doc_id IN NUMBER,
74: p_bus_doc_type IN VARCHAR2,
75: p_bus_doc_version IN NUMBER,
68: */
69: PROCEDURE cancelDeliverables (
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
72: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
73: p_bus_doc_id IN NUMBER,
74: p_bus_doc_type IN VARCHAR2,
75: p_bus_doc_version IN NUMBER,
76: p_event_code IN VARCHAR2,
89: * should pass -99
90: */
91: PROCEDURE cancelDeliverables (
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
94: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: p_bus_doc_id IN NUMBER,
96: p_bus_doc_type IN VARCHAR2,
97: p_bus_doc_version IN NUMBER,
90: */
91: PROCEDURE cancelDeliverables (
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
94: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: p_bus_doc_id IN NUMBER,
96: p_bus_doc_type IN VARCHAR2,
97: p_bus_doc_version IN NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
111: * @param IN p_bus_doc_date_events_tbl table type for business document date based events, should contain only those date based events where corresponding dates are changed
112: */
113: PROCEDURE updateDeliverables (
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117: p_bus_doc_id IN NUMBER,
118: p_bus_doc_type IN VARCHAR2,
119: p_bus_doc_version IN NUMBER,
112: */
113: PROCEDURE updateDeliverables (
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
117: p_bus_doc_id IN NUMBER,
118: p_bus_doc_type IN VARCHAR2,
119: p_bus_doc_version IN NUMBER,
120: p_bus_doc_date_events_tbl IN BUSDOCDATES_TBL_TYPE,
134: * @deprecated this API is deprecated. Use updateIntContactOnDeliverables()
135: */
136: PROCEDURE updateBuyerOnDeliverables (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140: p_bus_doc_id IN NUMBER,
141: p_bus_doc_type IN VARCHAR2,
142: p_bus_doc_version IN NUMBER,
135: */
136: PROCEDURE updateBuyerOnDeliverables (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140: p_bus_doc_id IN NUMBER,
141: p_bus_doc_type IN VARCHAR2,
142: p_bus_doc_version IN NUMBER,
143: p_original_buyer_id IN NUMBER,
155: * @deprecated this API is deprecated. Use updateIntContactOnDeliverables()
156: */
157: PROCEDURE updateBuyerOnDeliverables (
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
160: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
161: p_bus_docs_tbl IN BUSDOCS_TBL_TYPE,
162: p_original_buyer_id IN NUMBER,
163: p_new_buyer_id IN NUMBER,
156: */
157: PROCEDURE updateBuyerOnDeliverables (
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
160: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
161: p_bus_docs_tbl IN BUSDOCS_TBL_TYPE,
162: p_original_buyer_id IN NUMBER,
163: p_new_buyer_id IN NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
179: * if this flag is false, recurring instances are generated from the scratch (this happens when the API is called directly). If this API is called from activateDeliverables() the value is defaulted to TRUE.
180: */
181: PROCEDURE resolveDeliverables (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
184: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185: p_bus_doc_id IN NUMBER,
186: p_bus_doc_type IN VARCHAR2,
187: p_bus_doc_version IN NUMBER,
180: */
181: PROCEDURE resolveDeliverables (
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
184: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185: p_bus_doc_id IN NUMBER,
186: p_bus_doc_type IN VARCHAR2,
187: p_bus_doc_version IN NUMBER,
188: p_event_code IN VARCHAR2,
190: p_bus_doc_date_events_tbl IN BUSDOCDATES_TBL_TYPE,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_return_status OUT NOCOPY VARCHAR2,
194: p_sync_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195: p_sync_recurr_instances_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: p_cancel_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE);
197:
198: /**
191: x_msg_data OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_return_status OUT NOCOPY VARCHAR2,
194: p_sync_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195: p_sync_recurr_instances_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: p_cancel_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE);
197:
198: /**
199: * This procedure enable notifications on deliverables for given business document
192: x_msg_count OUT NOCOPY NUMBER,
193: x_return_status OUT NOCOPY VARCHAR2,
194: p_sync_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
195: p_sync_recurr_instances_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: p_cancel_flag IN VARCHAR2 DEFAULT FND_API.G_FALSE);
197:
198: /**
199: * This procedure enable notifications on deliverables for given business document
200: * version.
204: * should pass -99
205: */
206: PROCEDURE enableNotifications (
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_bus_doc_id IN NUMBER,
211: p_bus_doc_type IN VARCHAR2,
212: p_bus_doc_version IN NUMBER,
205: */
206: PROCEDURE enableNotifications (
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
209: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
210: p_bus_doc_id IN NUMBER,
211: p_bus_doc_type IN VARCHAR2,
212: p_bus_doc_version IN NUMBER,
213: x_msg_data OUT NOCOPY VARCHAR2,
224: * should pass -99
225: */
226: PROCEDURE disableDeliverables (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: p_bus_doc_id IN NUMBER,
231: p_bus_doc_type IN VARCHAR2,
232: p_bus_doc_version IN NUMBER, -- -99 for Sourcing.
225: */
226: PROCEDURE disableDeliverables (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
229: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230: p_bus_doc_id IN NUMBER,
231: p_bus_doc_type IN VARCHAR2,
232: p_bus_doc_version IN NUMBER, -- -99 for Sourcing.
233: x_msg_data OUT NOCOPY VARCHAR2,
245: * @param p_new_internal_contact_id new internal contact
246: */
247: PROCEDURE updateIntContactOnDeliverables (
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
251: p_bus_doc_id IN NUMBER,
252: p_bus_doc_type IN VARCHAR2,
253: p_bus_doc_version IN NUMBER,
246: */
247: PROCEDURE updateIntContactOnDeliverables (
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
251: p_bus_doc_id IN NUMBER,
252: p_bus_doc_type IN VARCHAR2,
253: p_bus_doc_version IN NUMBER,
254: p_original_internal_contact_id IN NUMBER,
265: * @param p_new_internal_contact_id new internal contact
266: */
267: PROCEDURE updateIntContactOnDeliverables (
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
270: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
271: p_bus_docs_tbl IN BUSDOCS_TBL_TYPE,
272: p_original_internal_contact_id IN NUMBER,
273: p_new_internal_contact_id IN NUMBER,
266: */
267: PROCEDURE updateIntContactOnDeliverables (
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
270: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
271: p_bus_docs_tbl IN BUSDOCS_TBL_TYPE,
272: p_original_internal_contact_id IN NUMBER,
273: p_new_internal_contact_id IN NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
280: * on deliverables for given draft version of business document.
281: */
282: PROCEDURE updateExtPartyOnDeliverables (
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
286: p_bus_doc_id IN NUMBER,
287: p_bus_doc_type IN VARCHAR2,
288: p_external_party_id IN NUMBER,
281: */
282: PROCEDURE updateExtPartyOnDeliverables (
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
286: p_bus_doc_id IN NUMBER,
287: p_bus_doc_type IN VARCHAR2,
288: p_external_party_id IN NUMBER,
289: p_external_party_site_id IN NUMBER,
296: * on deliverables for given class of business document.
297: */
298: PROCEDURE updateExtPartyOnDeliverables (
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: p_document_class IN VARCHAR2,
303: p_from_external_party_id IN NUMBER,
304: p_from_external_party_site_id IN NUMBER,
297: */
298: PROCEDURE updateExtPartyOnDeliverables (
299: p_api_version IN NUMBER,
300: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: p_document_class IN VARCHAR2,
303: p_from_external_party_id IN NUMBER,
304: p_from_external_party_site_id IN NUMBER,
305: p_to_external_party_id IN NUMBER,
313: * happens in the middle-tier
314: */
315: PROCEDURE postDelStatusChanges (
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
318: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
319: p_bus_doc_id IN NUMBER,
320: p_bus_doc_type IN VARCHAR2,
321: p_bus_doc_version IN NUMBER,
314: */
315: PROCEDURE postDelStatusChanges (
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
318: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
319: p_bus_doc_id IN NUMBER,
320: p_bus_doc_type IN VARCHAR2,
321: p_bus_doc_version IN NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
335: Returns N or Y, if there is unexpected error then it returns NULL.
336: **/
337: FUNCTION deliverablesForExtPartyExist(
338: p_api_version IN NUMBER,
339: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_data OUT NOCOPY VARCHAR2,
342: x_msg_count OUT NOCOPY NUMBER,
343:
356: Returns N or Y, if there is unexpected error then it returns NULL.
357: **/
358: FUNCTION check_manageable_deliverables(
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY NUMBER,
364:
373: * This API is for HZ party Merge process
374: **/
375: PROCEDURE mergeExtPartyOnDeliverables (
376: p_api_version IN NUMBER,
377: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
378: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
379: p_document_class IN VARCHAR2,
380: p_from_external_party_id IN NUMBER,
381: p_from_external_party_site_id IN NUMBER,
374: **/
375: PROCEDURE mergeExtPartyOnDeliverables (
376: p_api_version IN NUMBER,
377: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
378: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
379: p_document_class IN VARCHAR2,
380: p_from_external_party_id IN NUMBER,
381: p_from_external_party_site_id IN NUMBER,
382: p_to_external_party_id IN NUMBER,
397: * @param IN p_bus_doc_date_events_tbl table type for business document date based events
398: */
399: PROCEDURE activateCloseoutDeliverables (
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
402: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
403: p_bus_doc_id IN NUMBER,
404: p_bus_doc_type IN VARCHAR2,
405: p_bus_doc_version IN NUMBER,
398: */
399: PROCEDURE activateCloseoutDeliverables (
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
402: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
403: p_bus_doc_id IN NUMBER,
404: p_bus_doc_type IN VARCHAR2,
405: p_bus_doc_version IN NUMBER,
406: p_event_code IN VARCHAR2,
421: --Pre-reqs : None.
422: --Parameters :
423: --IN : p_api_version IN NUMBER Required
424: -- : p_init_msg_list IN VARCHAR2 Optional
425: -- Default = FND_API.G_FALSE
426: -- : p_bus_doc_id IN NUMBER Required
427: -- Header ID of the Standard Purchase Order
428: -- : p_bus_doc_version IN NUMBER Required
429: -- Version number of the Standard Purchase Order