DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_COLL_PARAMETERS

Line 2994: FROM msc_coll_parameters

2990: -- Legacy Net Change Perf L flow changes
2991:
2992: SELECT count(*)
2993: INTO lv_param_rec_count
2994: FROM msc_coll_parameters
2995: WHERE instance_id = v_instance_id;
2996:
2997: IF lv_param_rec_count > 0 THEN
2998: DELETE FROM msc_coll_parameters

Line 2998: DELETE FROM msc_coll_parameters

2994: FROM msc_coll_parameters
2995: WHERE instance_id = v_instance_id;
2996:
2997: IF lv_param_rec_count > 0 THEN
2998: DELETE FROM msc_coll_parameters
2999: WHERE instance_id = v_instance_id;
3000: END IF;
3001:
3002: INSERT INTO msc_coll_parameters

Line 3002: INSERT INTO msc_coll_parameters

2998: DELETE FROM msc_coll_parameters
2999: WHERE instance_id = v_instance_id;
3000: END IF;
3001:
3002: INSERT INTO msc_coll_parameters
3003: (INSTANCE_ID, delete_ods_data, supplier_capacity, atp_rules,
3004: bom, bor, calendar_check, demand_class, forecast, item,
3005: kpi_targets_bis, mds, mps, oh, parameter, planners,
3006: item_substitutes, projects, po, reservations, nra, safety_stock,