APPS.MRP_RESCHEDULE_PO dependencies on PO_TBL_DATE

Line 61: X_need_by_dates_old po_tbl_date := po_tbl_date();

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

Line 62: X_need_by_dates po_tbl_date := po_tbl_date();

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

Line 65: X_estimated_pickup_dates po_tbl_date := po_tbl_date();

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

Line 345: FUNCTION reschedule_po( X_old_need_by_dates po_tbl_date,

341:
342:
343:
344:
345: FUNCTION reschedule_po( X_old_need_by_dates po_tbl_date,
346: X_new_need_by_dates po_tbl_date,
347: X_po_header_id number,
348: X_po_line_ids po_tbl_number,
349: X_po_number varchar2,

Line 346: X_new_need_by_dates po_tbl_date,

342:
343:
344:
345: FUNCTION reschedule_po( X_old_need_by_dates po_tbl_date,
346: X_new_need_by_dates po_tbl_date,
347: X_po_header_id number,
348: X_po_line_ids po_tbl_number,
349: X_po_number varchar2,
350: X_shipment_nums po_tbl_number,

Line 351: X_estimated_pickup_dates po_tbl_date,

347: X_po_header_id number,
348: X_po_line_ids po_tbl_number,
349: X_po_number varchar2,
350: X_shipment_nums po_tbl_number,
351: X_estimated_pickup_dates po_tbl_date,
352: X_ship_methods po_tbl_varchar30,
353: l_derived_status IN OUT NOCOPY number)
354: return boolean IS
355:

Line 371: v_old_need_by_dates po_tbl_date := po_tbl_date();

367: from po_line_locations_all poll
368: where poll.po_line_id = v_line_id
369: and poll.po_header_id = v_header_id
370: and poll.shipment_num = nvl(v_ship_num,poll.shipment_num);
371: v_old_need_by_dates po_tbl_date := po_tbl_date();
372:
373: CURSOR cur_org(p_po_header_id IN number) IS
374: SELECT org_id
375: FROM po_headers_all