APPS.MSC_REL_PLAN_PUB dependencies on MSC_RP_RELEASED_ORDERS

Line 2515: -- MSC_RP_RELEASED_ORDERS

2511: OR arg_loaded_eam_jobs > 0
2512: OR arg_resched_eam_jobs > 0 THEN
2513:
2514: -- For RP Auto Release populate the table
2515: -- MSC_RP_RELEASED_ORDERS
2516: IF ( v_rp_plan = 1) THEN
2517: BEGIN
2518: FOR c_rec IN c_rp_rel_ord
2519: LOOP

Line 2520: UPDATE msc_rp_released_orders

2516: IF ( v_rp_plan = 1) THEN
2517: BEGIN
2518: FOR c_rec IN c_rp_rel_ord
2519: LOOP
2520: UPDATE msc_rp_released_orders
2521: SET plan_id = c_rec.plan_id,
2522: transaction_id = c_rec.transaction_id,
2523: implemented_quanity = NVL(implemented_quanity, 0) +
2524: c_rec.implement_quantity,

Line 2538: INSERT INTO msc_rp_released_orders

2534: AND transaction_id=c_rec.transaction_id;
2535:
2536: IF SQL%NOTFOUND THEN
2537:
2538: INSERT INTO msc_rp_released_orders
2539: (plan_id,
2540: transaction_id,
2541: implemented_quanity,
2542: implemented_date,