APPS.MSC_UPDATE_RESOURCE dependencies on MSC_SUPPLIES

Line 1935: update msc_supplies

1931: --dbms_output.put_line('new due date='||to_char(p_new_end,'MM/DD/RRRR HH24:MI'));
1932:
1933: a := nvl(p_trans_id.last,0);
1934: if a > 0 then
1935: update msc_supplies
1936: set status = 0,
1937: applied =2,
1938: firm_planned_type = 1,
1939: firm_date = p_end_time(a),

Line 2081: msc_supplies ms

2077: p_disable_date out nocopy date) IS
2078: CURSOR eff_c IS
2079: select mpe.effectivity_date, mpe.disable_date
2080: from msc_process_effectivity mpe,
2081: msc_supplies ms
2082: where ms.plan_id = p_plan_id
2083: and ms.transaction_id = p_supply_id
2084: and mpe.plan_id = ms.plan_id
2085: and mpe.process_sequence_id = ms.process_seq_id;