DBA Data[Home] [Help]

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';
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 122: p_ship_methods po_tbl_varchar30

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:
125: l_po_release_id number;
126: X_po_type varchar2(25) := 'RELEASE';

Line 601: p_ship_methods IN po_tbl_varchar30,

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