APPS.PO_RESCHEDULE_PKG dependencies on PO_TBL_VARCHAR30

Line 25: p_ship_methods IN po_tbl_varchar30,

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
28: --
29: -- 2279541 added new parameter x_shipment_num

Line 47: l_ship_methods po_tbl_varchar30;

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;
50:
51: BEGIN

Line 82: l_ship_methods := po_tbl_varchar30(p_ship_method);

78: END IF;
79:
80: IF p_ship_method IS NOT NULL THEN
81: -- 5610714 Initialize the Collection with the parameter value
82: l_ship_methods := po_tbl_varchar30(p_ship_method);
83: END IF;
84:
85:
86: l_result:= RESCHEDULE(X_need_by_dates_old => l_need_by_dates_old,

Line 112: p_ship_methods po_tbl_varchar30

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;
115: l_api_name CONSTANT VARCHAR2(30) := 'RESCHEDULE-2';
116: l_error_message po_tbl_varchar2000;

Line 155: p_ship_methods po_tbl_varchar30,

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
158:
159: l_po_release_id number;

Line 190: supply_number_tbl po_tbl_varchar30 ; --bug9787555/9830560

186: --
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;

Line 193: ascp_date_tbl po_tbl_varchar30;

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:
197:

Line 194: po_date_tbl po_tbl_varchar30;

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:
197:
198: BEGIN

Line 683: p_ship_methods IN po_tbl_varchar30,

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
686: l_api_name CONSTANT VARCHAR2(30) := 'PO_RESCHEDULE_REQ';
687: l_log_head CONSTANT VARCHAR2(200) := g_module_prefix || l_api_name;