APPS.MRP_RESCHEDULE_PO dependencies on PO_TBL_DATE

Line 60: X_need_by_dates_old po_tbl_date := po_tbl_date();

56: from MRP_AP_APPS_INSTANCES_ALL
57: where instance_id = p_instance_id
58: and nvl(A2M_DBLINK, '-1') = p_dblink;
59:
60: X_need_by_dates_old po_tbl_date := po_tbl_date();
61: X_need_by_dates po_tbl_date := po_tbl_date();
62: X_po_line_ids po_tbl_number := po_tbl_number();
63: X_shipment_nums po_tbl_number := po_tbl_number();
64: X_estimated_pickup_dates po_tbl_date := po_tbl_date();

Line 61: X_need_by_dates po_tbl_date := po_tbl_date();

57: where instance_id = p_instance_id
58: and nvl(A2M_DBLINK, '-1') = p_dblink;
59:
60: X_need_by_dates_old po_tbl_date := po_tbl_date();
61: X_need_by_dates po_tbl_date := po_tbl_date();
62: X_po_line_ids po_tbl_number := po_tbl_number();
63: X_shipment_nums po_tbl_number := po_tbl_number();
64: X_estimated_pickup_dates po_tbl_date := po_tbl_date();
65: X_ship_methods po_tbl_varchar30 := po_tbl_varchar30();

Line 64: X_estimated_pickup_dates po_tbl_date := po_tbl_date();

60: X_need_by_dates_old po_tbl_date := po_tbl_date();
61: X_need_by_dates po_tbl_date := po_tbl_date();
62: X_po_line_ids po_tbl_number := po_tbl_number();
63: X_shipment_nums po_tbl_number := po_tbl_number();
64: X_estimated_pickup_dates po_tbl_date := po_tbl_date();
65: X_ship_methods po_tbl_varchar30 := po_tbl_varchar30();
66: a number :=0;
67:
68: last_po_number varchar2(250);

Line 263: FUNCTION reschedule_po( X_old_need_by_dates po_tbl_date,

259: retcode :=2;
260: raise;
261: END reschedule_po_program;
262:
263: FUNCTION reschedule_po( X_old_need_by_dates po_tbl_date,
264: X_new_need_by_dates po_tbl_date,
265: X_po_header_id number,
266: X_po_line_ids po_tbl_number,
267: X_po_number varchar2,

Line 264: X_new_need_by_dates po_tbl_date,

260: raise;
261: END reschedule_po_program;
262:
263: FUNCTION reschedule_po( X_old_need_by_dates po_tbl_date,
264: X_new_need_by_dates po_tbl_date,
265: X_po_header_id number,
266: X_po_line_ids po_tbl_number,
267: X_po_number varchar2,
268: X_shipment_nums po_tbl_number,

Line 269: X_estimated_pickup_dates po_tbl_date,

265: X_po_header_id number,
266: X_po_line_ids po_tbl_number,
267: X_po_number varchar2,
268: X_shipment_nums po_tbl_number,
269: X_estimated_pickup_dates po_tbl_date,
270: X_ship_methods po_tbl_varchar30)
271: return boolean IS
272:
273: p_result boolean;

Line 287: v_old_need_by_dates po_tbl_date := po_tbl_date();

283: from po_line_locations_all poll
284: where poll.po_line_id = v_line_id
285: and poll.po_header_id = v_header_id
286: and poll.shipment_num = nvl(v_ship_num,poll.shipment_num);
287: v_old_need_by_dates po_tbl_date := po_tbl_date();
288:
289: CURSOR cur_org(p_po_header_id IN number) IS
290: SELECT org_id
291: FROM po_headers_all