APPS.MRP_AP_REL_PLAN_PUB dependencies on PO_RESCHEDULE_INTERFACE

Line 2802: PROCEDURE LD_PO_RESCHEDULE_INTERFACE

2798: END;
2799:
2800: END LD_PO_REQUISITIONS_INTERFACE;
2801:
2802: PROCEDURE LD_PO_RESCHEDULE_INTERFACE
2803: ( o_request_id OUT NOCOPY NUMBER)
2804: IS
2805: lv_sqlstmt VARCHAR2(4000);
2806: lv_instance_id NUMBER;

Line 2826: 'INSERT INTO PO_RESCHEDULE_INTERFACE'

2822: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2823: and ALLOW_RELEASE_FLAG=1;
2824:
2825: lv_sqlstmt:=
2826: 'INSERT INTO PO_RESCHEDULE_INTERFACE'
2827: ||' ( LINE_ID,'
2828: ||' QUANTITY,'
2829: ||' NEED_BY_DATE,'
2830: ||' PROCESS_ID,'

Line 2854: ||' FROM MSC_PO_RESCHEDULE_INTERFACE'||lv_dblink

2850: ||' REQUEST_ID,'
2851: ||' PROGRAM_APPLICATION_ID,'
2852: ||' PROGRAM_ID,'
2853: ||' PROGRAM_UPDATE_DATE'
2854: ||' FROM MSC_PO_RESCHEDULE_INTERFACE'||lv_dblink
2855: ||' WHERE SR_INSTANCE_ID= :lv_instance_id';
2856:
2857: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id;
2858:

Line 2863: FROM PO_RESCHEDULE_INTERFACE PRI, PO_REQUISITION_LINES_ALL PRLA

2859: -- Launching the POXRSR in loop for each OU, change for MOAC
2860: DECLARE
2861: CURSOR c1 IS
2862: SELECT DISTINCT prla.org_id
2863: FROM PO_RESCHEDULE_INTERFACE PRI, PO_REQUISITION_LINES_ALL PRLA
2864: WHERE pri.line_id = prla.requisition_line_id;
2865:
2866: BEGIN
2867: FOR C2 IN C1

Line 2885: END LD_PO_RESCHEDULE_INTERFACE;

2881: FALSE); -- sub_request
2882: END LOOP;
2883: END;
2884:
2885: END LD_PO_RESCHEDULE_INTERFACE;
2886:
2887:
2888: PROCEDURE MODIFY_COMPONENT_REQUIREMENT
2889: IS