101: ------------------------------------------------------------------------------
102:
103: PROCEDURE Create_Document
104: ( p_api_version IN NUMBER
105: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
106: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
107: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
108: , x_return_status OUT NOCOPY VARCHAR2
109: , x_msg_count OUT NOCOPY NUMBER
102:
103: PROCEDURE Create_Document
104: ( p_api_version IN NUMBER
105: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
106: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
107: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
108: , x_return_status OUT NOCOPY VARCHAR2
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
103: PROCEDURE Create_Document
104: ( p_api_version IN NUMBER
105: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
106: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
107: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
108: , x_return_status OUT NOCOPY VARCHAR2
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: , p_entity_name IN VARCHAR2 DEFAULT NULL
227:
228:
229: PROCEDURE Update_Document
230: ( p_api_version IN NUMBER
231: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
232: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
233: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
234: , x_return_status OUT NOCOPY VARCHAR2
235: , x_msg_count OUT NOCOPY NUMBER
228:
229: PROCEDURE Update_Document
230: ( p_api_version IN NUMBER
231: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
232: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
233: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
234: , x_return_status OUT NOCOPY VARCHAR2
235: , x_msg_count OUT NOCOPY NUMBER
236: , x_msg_data OUT NOCOPY VARCHAR2
229: PROCEDURE Update_Document
230: ( p_api_version IN NUMBER
231: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
232: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
233: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
234: , x_return_status OUT NOCOPY VARCHAR2
235: , x_msg_count OUT NOCOPY NUMBER
236: , x_msg_data OUT NOCOPY VARCHAR2
237: , p_entity_name IN VARCHAR2 DEFAULT NULL
237: , p_entity_name IN VARCHAR2 DEFAULT NULL
238: , p_entity_id IN NUMBER
239: , p_document_type IN VARCHAR2
240: /* Commented for Shipping Data Model Changes Bug#1918342*/
241: /*, p_pod_flag IN VARCHAR2 DEFAULT FND_API.g_miss_char
242: , p_pod_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
243: , p_pod_date IN DATE DEFAULT FND_API.g_miss_date
244: , p_reason_of_transport IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
238: , p_entity_id IN NUMBER
239: , p_document_type IN VARCHAR2
240: /* Commented for Shipping Data Model Changes Bug#1918342*/
241: /*, p_pod_flag IN VARCHAR2 DEFAULT FND_API.g_miss_char
242: , p_pod_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
243: , p_pod_date IN DATE DEFAULT FND_API.g_miss_date
244: , p_reason_of_transport IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
239: , p_document_type IN VARCHAR2
240: /* Commented for Shipping Data Model Changes Bug#1918342*/
241: /*, p_pod_flag IN VARCHAR2 DEFAULT FND_API.g_miss_char
242: , p_pod_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
243: , p_pod_date IN DATE DEFAULT FND_API.g_miss_date
244: , p_reason_of_transport IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
240: /* Commented for Shipping Data Model Changes Bug#1918342*/
241: /*, p_pod_flag IN VARCHAR2 DEFAULT FND_API.g_miss_char
242: , p_pod_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
243: , p_pod_date IN DATE DEFAULT FND_API.g_miss_date
244: , p_reason_of_transport IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
241: /*, p_pod_flag IN VARCHAR2 DEFAULT FND_API.g_miss_char
242: , p_pod_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
243: , p_pod_date IN DATE DEFAULT FND_API.g_miss_date
244: , p_reason_of_transport IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
242: , p_pod_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
243: , p_pod_date IN DATE DEFAULT FND_API.g_miss_date
244: , p_reason_of_transport IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
243: , p_pod_date IN DATE DEFAULT FND_API.g_miss_date
244: , p_reason_of_transport IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
244: , p_reason_of_transport IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
245: , p_description IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
246: , p_cod_amount IN NUMBER DEFAULT FND_API.g_miss_num
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
247: , p_cod_currency_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
248: , p_cod_remit_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
249: , p_cod_charge_paid_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
250: , p_problem_contact_reference IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
251: , p_bill_freight_to IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
252: , p_carried_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
253: , p_port_of_loading IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
254: , p_port_of_discharge IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
255: , p_booking_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
256: , p_booking_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
257: , p_service_contract IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
258: , p_shipper_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
259: , p_carrier_export_ref IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
260: , p_bol_notify_party IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
261: , p_supplier_code IN VARCHAR2 DEFAULT FND_API.g_miss_char
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
262: , p_aetc_number IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
270: , p_shipper_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
263: , p_shipper_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
270: , p_shipper_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
271: , p_shipper_hm_date IN DATE DEFAULT FND_API.g_miss_date
264: , p_shipper_date IN DATE DEFAULT FND_API.g_miss_date
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
270: , p_shipper_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
271: , p_shipper_hm_date IN DATE DEFAULT FND_API.g_miss_date
272: , p_carrier_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
265: , p_carrier_signed_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
270: , p_shipper_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
271: , p_shipper_hm_date IN DATE DEFAULT FND_API.g_miss_date
272: , p_carrier_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
273: , p_carrier_hm_date IN DATE DEFAULT FND_API.g_miss_date*/
266: , p_carrier_date IN DATE DEFAULT FND_API.g_miss_date
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
270: , p_shipper_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
271: , p_shipper_hm_date IN DATE DEFAULT FND_API.g_miss_date
272: , p_carrier_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
273: , p_carrier_hm_date IN DATE DEFAULT FND_API.g_miss_date*/
274: , p_ledger_id IN NUMBER -- LE Uptake
267: , p_bol_issue_office IN VARCHAR2 DEFAULT FND_API.g_miss_char
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
270: , p_shipper_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
271: , p_shipper_hm_date IN DATE DEFAULT FND_API.g_miss_date
272: , p_carrier_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
273: , p_carrier_hm_date IN DATE DEFAULT FND_API.g_miss_date*/
274: , p_ledger_id IN NUMBER -- LE Uptake
275: , p_consolidate_option IN VARCHAR2 DEFAULT 'BOTH'
268: , p_bol_issued_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
270: , p_shipper_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
271: , p_shipper_hm_date IN DATE DEFAULT FND_API.g_miss_date
272: , p_carrier_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
273: , p_carrier_hm_date IN DATE DEFAULT FND_API.g_miss_date*/
274: , p_ledger_id IN NUMBER -- LE Uptake
275: , p_consolidate_option IN VARCHAR2 DEFAULT 'BOTH'
276: );
269: , p_bol_date_issued IN DATE DEFAULT FND_API.g_miss_date
270: , p_shipper_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
271: , p_shipper_hm_date IN DATE DEFAULT FND_API.g_miss_date
272: , p_carrier_hm_by IN VARCHAR2 DEFAULT FND_API.g_miss_char
273: , p_carrier_hm_date IN DATE DEFAULT FND_API.g_miss_date*/
274: , p_ledger_id IN NUMBER -- LE Uptake
275: , p_consolidate_option IN VARCHAR2 DEFAULT 'BOTH'
276: );
277:
311: ------------------------------------------------------------------------------
312:
313: PROCEDURE Cancel_Document
314: ( p_api_version IN NUMBER
315: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
316: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
317: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
318: , x_return_status OUT NOCOPY VARCHAR2
319: , x_msg_count OUT NOCOPY NUMBER
312:
313: PROCEDURE Cancel_Document
314: ( p_api_version IN NUMBER
315: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
316: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
317: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
318: , x_return_status OUT NOCOPY VARCHAR2
319: , x_msg_count OUT NOCOPY NUMBER
320: , x_msg_data OUT NOCOPY VARCHAR2
313: PROCEDURE Cancel_Document
314: ( p_api_version IN NUMBER
315: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
316: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
317: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
318: , x_return_status OUT NOCOPY VARCHAR2
319: , x_msg_count OUT NOCOPY NUMBER
320: , x_msg_data OUT NOCOPY VARCHAR2
321: , p_entity_name IN VARCHAR2 DEFAULT NULL
359: ------------------------------------------------------------------------------
360:
361: PROCEDURE Open_Document
362: ( p_api_version IN NUMBER
363: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
364: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
365: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
366: , x_return_status OUT NOCOPY VARCHAR2
367: , x_msg_count OUT NOCOPY NUMBER
360:
361: PROCEDURE Open_Document
362: ( p_api_version IN NUMBER
363: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
364: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
365: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
366: , x_return_status OUT NOCOPY VARCHAR2
367: , x_msg_count OUT NOCOPY NUMBER
368: , x_msg_data OUT NOCOPY VARCHAR2
361: PROCEDURE Open_Document
362: ( p_api_version IN NUMBER
363: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
364: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
365: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
366: , x_return_status OUT NOCOPY VARCHAR2
367: , x_msg_count OUT NOCOPY NUMBER
368: , x_msg_data OUT NOCOPY VARCHAR2
369: , p_entity_name IN VARCHAR2 DEFAULT NULL
407: ------------------------------------------------------------------------------
408:
409: PROCEDURE Complete_Document
410: ( p_api_version IN NUMBER
411: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
412: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
413: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
414: , x_return_status OUT NOCOPY VARCHAR2
415: , x_msg_count OUT NOCOPY NUMBER
408:
409: PROCEDURE Complete_Document
410: ( p_api_version IN NUMBER
411: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
412: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
413: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
414: , x_return_status OUT NOCOPY VARCHAR2
415: , x_msg_count OUT NOCOPY NUMBER
416: , x_msg_data OUT NOCOPY VARCHAR2
409: PROCEDURE Complete_Document
410: ( p_api_version IN NUMBER
411: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
412: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
413: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
414: , x_return_status OUT NOCOPY VARCHAR2
415: , x_msg_count OUT NOCOPY NUMBER
416: , x_msg_data OUT NOCOPY VARCHAR2
417: , p_entity_name IN VARCHAR2 DEFAULT NULL
455: ------------------------------------------------------------------------------
456:
457: FUNCTION Get_Sequence_Type
458: ( p_api_version IN NUMBER
459: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
460: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
461: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
462: , x_return_status OUT NOCOPY VARCHAR2
463: , x_msg_count OUT NOCOPY NUMBER
456:
457: FUNCTION Get_Sequence_Type
458: ( p_api_version IN NUMBER
459: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
460: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
461: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
462: , x_return_status OUT NOCOPY VARCHAR2
463: , x_msg_count OUT NOCOPY NUMBER
464: , x_msg_data OUT NOCOPY VARCHAR2
457: FUNCTION Get_Sequence_Type
458: ( p_api_version IN NUMBER
459: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
460: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
461: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
462: , x_return_status OUT NOCOPY VARCHAR2
463: , x_msg_count OUT NOCOPY NUMBER
464: , x_msg_data OUT NOCOPY VARCHAR2
465: , p_application_id IN NUMBER
504: ------------------------------------------------------------------------------
505:
506: FUNCTION Is_Final
507: ( p_api_version IN NUMBER
508: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
509: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
510: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
511: , x_return_status OUT NOCOPY VARCHAR2
512: , x_msg_count OUT NOCOPY NUMBER
505:
506: FUNCTION Is_Final
507: ( p_api_version IN NUMBER
508: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
509: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
510: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
511: , x_return_status OUT NOCOPY VARCHAR2
512: , x_msg_count OUT NOCOPY NUMBER
513: , x_msg_data OUT NOCOPY VARCHAR2
506: FUNCTION Is_Final
507: ( p_api_version IN NUMBER
508: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
509: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
510: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
511: , x_return_status OUT NOCOPY VARCHAR2
512: , x_msg_count OUT NOCOPY NUMBER
513: , x_msg_data OUT NOCOPY VARCHAR2
514: , p_delivery_id IN NUMBER
551: ------------------------------------------------------------------------------
552:
553: PROCEDURE Set_Final_Print_Date
554: ( p_api_version IN NUMBER
555: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
556: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
557: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
558: , x_return_status OUT NOCOPY VARCHAR2
559: , x_msg_count OUT NOCOPY NUMBER
552:
553: PROCEDURE Set_Final_Print_Date
554: ( p_api_version IN NUMBER
555: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
556: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
557: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
558: , x_return_status OUT NOCOPY VARCHAR2
559: , x_msg_count OUT NOCOPY NUMBER
560: , x_msg_data OUT NOCOPY VARCHAR2
553: PROCEDURE Set_Final_Print_Date
554: ( p_api_version IN NUMBER
555: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
556: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
557: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
558: , x_return_status OUT NOCOPY VARCHAR2
559: , x_msg_count OUT NOCOPY NUMBER
560: , x_msg_data OUT NOCOPY VARCHAR2
561: , p_delivery_id IN NUMBER
605: ------------------------------------------------------------------------------
606:
607: PROCEDURE Print_Document
608: ( p_api_version IN NUMBER
609: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
610: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
611: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
612: , x_return_status OUT NOCOPY VARCHAR2
613: , x_msg_count OUT NOCOPY NUMBER
606:
607: PROCEDURE Print_Document
608: ( p_api_version IN NUMBER
609: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
610: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
611: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
612: , x_return_status OUT NOCOPY VARCHAR2
613: , x_msg_count OUT NOCOPY NUMBER
614: , x_msg_data OUT NOCOPY VARCHAR2
607: PROCEDURE Print_Document
608: ( p_api_version IN NUMBER
609: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
610: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
611: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
612: , x_return_status OUT NOCOPY VARCHAR2
613: , x_msg_count OUT NOCOPY NUMBER
614: , x_msg_data OUT NOCOPY VARCHAR2
615: , p_delivery_id IN NUMBER
659: ------------------------------------------------------------------------------
660:
661: FUNCTION Get_CumQty
662: ( p_api_version IN NUMBER
663: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
664: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
665: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
666: , x_return_status OUT NOCOPY VARCHAR2
667: , x_msg_count OUT NOCOPY NUMBER
660:
661: FUNCTION Get_CumQty
662: ( p_api_version IN NUMBER
663: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
664: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
665: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
666: , x_return_status OUT NOCOPY VARCHAR2
667: , x_msg_count OUT NOCOPY NUMBER
668: , x_msg_data OUT NOCOPY VARCHAR2
661: FUNCTION Get_CumQty
662: ( p_api_version IN NUMBER
663: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
664: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
665: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
666: , x_return_status OUT NOCOPY VARCHAR2
667: , x_msg_count OUT NOCOPY NUMBER
668: , x_msg_data OUT NOCOPY VARCHAR2
669: , p_customer_id IN NUMBER
706: ------------------------------------------------------------------------------
707:
708: PROCEDURE Cancel_All_Documents
709: ( p_api_version IN NUMBER
710: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
711: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
712: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
713: , x_return_status OUT NOCOPY VARCHAR2
714: , x_msg_count OUT NOCOPY NUMBER
707:
708: PROCEDURE Cancel_All_Documents
709: ( p_api_version IN NUMBER
710: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
711: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
712: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
713: , x_return_status OUT NOCOPY VARCHAR2
714: , x_msg_count OUT NOCOPY NUMBER
715: , x_msg_data OUT NOCOPY VARCHAR2
708: PROCEDURE Cancel_All_Documents
709: ( p_api_version IN NUMBER
710: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
711: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
712: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
713: , x_return_status OUT NOCOPY VARCHAR2
714: , x_msg_count OUT NOCOPY NUMBER
715: , x_msg_data OUT NOCOPY VARCHAR2
716: , p_entity_name IN VARCHAR2
750: ------------------------------------------------------------------------------
751:
752: PROCEDURE Get_All_Documents
753: ( p_api_version IN NUMBER
754: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
755: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
756: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
757: , x_return_status OUT NOCOPY VARCHAR2
758: , x_msg_count OUT NOCOPY NUMBER
751:
752: PROCEDURE Get_All_Documents
753: ( p_api_version IN NUMBER
754: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
755: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
756: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
757: , x_return_status OUT NOCOPY VARCHAR2
758: , x_msg_count OUT NOCOPY NUMBER
759: , x_msg_data OUT NOCOPY VARCHAR2
752: PROCEDURE Get_All_Documents
753: ( p_api_version IN NUMBER
754: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false
755: , p_commit IN VARCHAR2 DEFAULT FND_API.g_false
756: , p_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full
757: , x_return_status OUT NOCOPY VARCHAR2
758: , x_msg_count OUT NOCOPY NUMBER
759: , x_msg_data OUT NOCOPY VARCHAR2
760: , p_entity_name IN VARCHAR2