DBA Data[Home] [Help]

APPS.PO_RESCHEDULE_PKG dependencies on PO_TBL_NUMBER

Line 23: p_line_location_id_tbl IN po_tbl_number,

19: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
20:
21: -- Forward declare private procedure po_reschedule_req
22: PROCEDURE PO_RESCHEDULE_REQ (
23: p_line_location_id_tbl IN po_tbl_number,
24: p_estimated_pickup_dates IN po_tbl_date,
25: p_ship_methods IN po_tbl_varchar30,
26: x_return_status OUT NOCOPY VARCHAR2
27: ); -- Bug 5255550

Line 44: l_po_line_ids po_tbl_number;

40: ) Return boolean IS
41:
42: l_need_by_dates_old po_tbl_date;
43: l_need_by_dates po_tbl_date;
44: l_po_line_ids po_tbl_number;
45: l_shipment_nums po_tbl_number;
46: l_estimated_pickup_dates po_tbl_date;
47: l_ship_methods po_tbl_varchar30;
48: l_api_name CONSTANT VARCHAR2(30) := 'RESCHEDULE-1';

Line 45: l_shipment_nums po_tbl_number;

41:
42: l_need_by_dates_old po_tbl_date;
43: l_need_by_dates po_tbl_date;
44: l_po_line_ids po_tbl_number;
45: l_shipment_nums po_tbl_number;
46: l_estimated_pickup_dates po_tbl_date;
47: l_ship_methods po_tbl_varchar30;
48: l_api_name CONSTANT VARCHAR2(30) := 'RESCHEDULE-1';
49: l_result BOOLEAN;

Line 72: l_shipment_nums := po_tbl_number(X_shipment_num);

68: FROM DUAL;
69:
70: IF X_shipment_num IS NOT NULL THEN
71: -- 5610714 Initialize the Collection with the parameter value
72: l_shipment_nums := po_tbl_number(X_shipment_num);
73: END IF;
74:
75: IF p_estimated_pickup_date IS NOT NULL THEN
76: -- 5610714 Initialize the Collection with the parameter value

Line 108: X_po_line_ids po_tbl_number,

104: --bug9693292
105: Function RESCHEDULE ( X_need_by_dates_old po_tbl_date,
106: X_need_by_dates po_tbl_date,
107: X_po_header_id number,
108: X_po_line_ids po_tbl_number,
109: X_supply_number varchar2,
110: X_shipment_nums po_tbl_number,
111: p_estimated_pickup_dates po_tbl_date,
112: p_ship_methods po_tbl_varchar30

Line 110: X_shipment_nums po_tbl_number,

106: X_need_by_dates po_tbl_date,
107: X_po_header_id number,
108: X_po_line_ids po_tbl_number,
109: X_supply_number varchar2,
110: X_shipment_nums po_tbl_number,
111: p_estimated_pickup_dates po_tbl_date,
112: p_ship_methods po_tbl_varchar30
113: ) Return boolean IS
114: l_result BOOLEAN;

Line 151: X_po_line_ids po_tbl_number,

147: Function RESCHEDULE (
148: X_need_by_dates_old po_tbl_date,
149: X_need_by_dates po_tbl_date,
150: X_po_header_id number,
151: X_po_line_ids po_tbl_number,
152: X_supply_number VARCHAR2,
153: X_shipment_nums po_tbl_number,
154: p_estimated_pickup_dates po_tbl_date,
155: p_ship_methods po_tbl_varchar30,

Line 153: X_shipment_nums po_tbl_number,

149: X_need_by_dates po_tbl_date,
150: X_po_header_id number,
151: X_po_line_ids po_tbl_number,
152: X_supply_number VARCHAR2,
153: X_shipment_nums po_tbl_number,
154: p_estimated_pickup_dates po_tbl_date,
155: p_ship_methods po_tbl_varchar30,
156: x_error_message OUT NOCOPY po_tbl_varchar2000 --bug9693292
157: ) Return boolean IS

Line 174: l_line_location_id_tbl PO_TBL_NUMBER;

170: l_original_org_context VARCHAR2(10) := null;
171: l_document_org_id NUMBER;
172: l_changes PO_CHANGES_REC_TYPE;
173: l_shipment_changes PO_SHIPMENTS_REC_TYPE;
174: l_line_location_id_tbl PO_TBL_NUMBER;
175: l_need_by_date_tbl PO_TBL_DATE;
176: l_nbd_validate_tbl PO_TBL_VARCHAR2000:=NULL;
177: l_return_status VARCHAR2(1);
178: l_api_errors PO_API_ERRORS_REC_TYPE;

Line 191: line_number_tbl po_tbl_number ;

187:
188: --Bug9693292
189: x_error_count NUMBER;
190: supply_number_tbl po_tbl_varchar30 ; --bug9787555/9830560
191: line_number_tbl po_tbl_number ;
192: shipment_number_tbl po_tbl_number;
193: ascp_date_tbl po_tbl_varchar30;
194: po_date_tbl po_tbl_varchar30;
195: --Bug9693292

Line 192: shipment_number_tbl po_tbl_number;

188: --Bug9693292
189: x_error_count NUMBER;
190: supply_number_tbl po_tbl_varchar30 ; --bug9787555/9830560
191: line_number_tbl po_tbl_number ;
192: shipment_number_tbl po_tbl_number;
193: ascp_date_tbl po_tbl_varchar30;
194: po_date_tbl po_tbl_varchar30;
195: --Bug9693292
196:

Line 681: p_line_location_id_tbl IN po_tbl_number,

677: -- Indicates API return status as 'S' or 'U'.
678: --End of Comments
679: -------------------------------------------------------------------------------
680: PROCEDURE PO_RESCHEDULE_REQ (
681: p_line_location_id_tbl IN po_tbl_number,
682: p_estimated_pickup_dates IN po_tbl_date,
683: p_ship_methods IN po_tbl_varchar30,
684: x_return_status OUT NOCOPY VARCHAR2
685: ) IS