eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_RESCHEDULE_PKG dependencies on PO_TBL_DATE

Line 24: p_estimated_pickup_dates IN po_tbl_date,

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

Line 42: l_need_by_dates_old po_tbl_date;

38: p_estimated_pickup_date DATE,
39: p_ship_method VARCHAR2
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;

Line 43: l_need_by_dates po_tbl_date;

39: p_ship_method VARCHAR2
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;

Line 46: l_estimated_pickup_dates po_tbl_date;

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

Line 77: l_estimated_pickup_dates := po_tbl_date(p_estimated_pickup_date);

73: END IF;
74:
75: IF p_estimated_pickup_date IS NOT NULL THEN
76: -- 5610714 Initialize the Collection with the parameter value
77: l_estimated_pickup_dates := po_tbl_date(p_estimated_pickup_date);
78: END IF;
79:
80: IF p_ship_method IS NOT NULL THEN
81: -- 5610714 Initialize the Collection with the parameter value

Line 105: Function RESCHEDULE ( X_need_by_dates_old po_tbl_date,

101: RAISE FND_API.G_EXC_ERROR;
102: END;
103:
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,

Line 106: X_need_by_dates po_tbl_date,

102: END;
103:
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,

Line 111: p_estimated_pickup_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;
115: l_api_name CONSTANT VARCHAR2(30) := 'RESCHEDULE-2';

Line 148: X_need_by_dates_old po_tbl_date,

144: -- Now APS will pass all the lines/shipments for 1 PO/Release at once.
145:
146: -- 2279541 added new parameter x_shipment_num
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,

Line 149: X_need_by_dates po_tbl_date,

145:
146: -- 2279541 added new parameter x_shipment_num
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,

Line 154: p_estimated_pickup_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
158:

Line 175: l_need_by_date_tbl PO_TBL_DATE;

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;
179: l_release_type PO_RELEASES_ALL.RELEASE_TYPE%TYPE;

Line 184: l_promised_by_date_tbl PO_TBL_DATE; --Bug5633563

180: l_session_gt_key NUMBER;
181: l_api_name CONSTANT VARCHAR2(30) := 'RESCHEDULE-3';
182: l_log_head CONSTANT VARCHAR2(100):= g_module_prefix||l_api_name;
183: l_progress VARCHAR2(3):='000';
184: l_promised_by_date_tbl PO_TBL_DATE; --Bug5633563
185: l_need_by_promise_def_prf VARCHAR2(1); --Bug5633563
186: --
187:
188: --Bug9693292

Line 540: l_promised_by_date_tbl := PO_TBL_DATE();

536: is set then new need_by_date must be copied to promised_by_date
537: */
538: fnd_profile.get('PO_NEED_BY_PROMISE_DEFAULTING', l_need_by_promise_def_prf);
539: IF nvl(l_need_by_promise_def_prf,'N') = 'Y' THEN
540: l_promised_by_date_tbl := PO_TBL_DATE();
541: select date2
542: bulk collect into l_promised_by_date_tbl
543: from po_session_gt SCRATCH
544: WHERE KEY = l_session_gt_key

Line 682: p_estimated_pickup_dates IN po_tbl_date,

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