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';

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';
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 118: X_po_line_ids po_tbl_number,

114: Function RESCHEDULE (
115: X_need_by_dates_old po_tbl_date,
116: X_need_by_dates po_tbl_date,
117: X_po_header_id number,
118: X_po_line_ids po_tbl_number,
119: X_supply_number VARCHAR2,
120: X_shipment_nums po_tbl_number,
121: p_estimated_pickup_dates po_tbl_date,
122: p_ship_methods po_tbl_varchar30

Line 120: X_shipment_nums po_tbl_number,

116: X_need_by_dates po_tbl_date,
117: X_po_header_id number,
118: X_po_line_ids po_tbl_number,
119: X_supply_number VARCHAR2,
120: X_shipment_nums po_tbl_number,
121: p_estimated_pickup_dates po_tbl_date,
122: p_ship_methods po_tbl_varchar30
123: ) Return boolean IS
124:

Line 140: l_line_location_id_tbl PO_TBL_NUMBER;

136: l_original_org_context VARCHAR2(10) := null;
137: l_document_org_id NUMBER;
138: l_changes PO_CHANGES_REC_TYPE;
139: l_shipment_changes PO_SHIPMENTS_REC_TYPE;
140: l_line_location_id_tbl PO_TBL_NUMBER;
141: l_need_by_date_tbl PO_TBL_DATE;
142: l_nbd_validate_tbl PO_TBL_VARCHAR2000:=NULL;
143: l_return_status VARCHAR2(1);
144: l_api_errors PO_API_ERRORS_REC_TYPE;

Line 599: p_line_location_id_tbl IN po_tbl_number,

595: -- Indicates API return status as 'S' or 'U'.
596: --End of Comments
597: -------------------------------------------------------------------------------
598: PROCEDURE PO_RESCHEDULE_REQ (
599: p_line_location_id_tbl IN po_tbl_number,
600: p_estimated_pickup_dates IN po_tbl_date,
601: p_ship_methods IN po_tbl_varchar30,
602: x_return_status OUT NOCOPY VARCHAR2
603: ) IS