APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_SUP_DEM_ENTRIES_S

Line 2037: msc_sup_dem_entries_s.nextval,

2033: planner_code,
2034: version,
2035: designator
2036: ) values (
2037: msc_sup_dem_entries_s.nextval,
2038: -1,
2039: -1,
2040: t_pub(j),
2041: t_pub_id(j),

Line 2182: msc_sup_dem_entries_s.nextval,

2178: planner_code,
2179: version,
2180: designator
2181: ) values (
2182: msc_sup_dem_entries_s.nextval,
2183: -1,
2184: -1,
2185: t_pub(j),
2186: t_pub_id(j),

Line 2306: msc_sup_dem_entries_s.nextval,

2302: planner_code,
2303: version,
2304: designator
2305: ) values (
2306: msc_sup_dem_entries_s.nextval,
2307: -1,
2308: -1,
2309: t_pub(j-1),
2310: t_pub_id(j-1),

Line 2425: msc_sup_dem_entries_s.nextval,

2421: planner_code,
2422: version,
2423: designator
2424: ) values (
2425: msc_sup_dem_entries_s.nextval,
2426: -1,
2427: -1,
2428: t_pub(j),
2429: t_pub_id(j),

Line 2572: msc_sup_dem_entries_s.nextval,

2568: planner_code,
2569: version,
2570: designator
2571: ) values (
2572: msc_sup_dem_entries_s.nextval,
2573: -1,
2574: -1,
2575: t_pub(j),
2576: t_pub_id(j),

Line 2734: msc_sup_dem_entries_s.nextval,

2730: planner_code,
2731: version,
2732: designator
2733: ) values (
2734: msc_sup_dem_entries_s.nextval,
2735: -1,
2736: -1,
2737: t_pub(j),
2738: t_pub_id(j),

Line 2843: msc_sup_dem_entries_s.nextval,

2839: planner_code,
2840: version,
2841: designator
2842: ) values (
2843: msc_sup_dem_entries_s.nextval,
2844: -1,
2845: -1,
2846: t_pub(j),
2847: t_pub_id(j),

Line 2962: msc_sup_dem_entries_s.nextval,

2958: planner_code,
2959: version,
2960: designator
2961: ) values (
2962: msc_sup_dem_entries_s.nextval,
2963: -1,
2964: -1,
2965: t_pub(j),
2966: t_pub_id(j),

Line 3088: msc_sup_dem_entries_s.nextval,

3084: planner_code,
3085: version,
3086: designator
3087: ) values (
3088: msc_sup_dem_entries_s.nextval,
3089: -1,
3090: -1,
3091: t_pub(j-1),
3092: t_pub_id(j-1),

Line 3216: msc_sup_dem_entries_s.nextval,

3212: planner_code,
3213: version,
3214: designator
3215: ) values (
3216: msc_sup_dem_entries_s.nextval,
3217: -1,
3218: -1,
3219: t_pub(j),
3220: t_pub_id(j),

Line 3305: delete from msc_sup_dem_entries sd

3301: --dbms_output.put_line('In delete_old_safety stock');
3302:
3303:
3304: IF ( p_overwrite = 1) THEN --delete all
3305: delete from msc_sup_dem_entries sd
3306: where sd.publisher_order_type in (SAFETY_STOCK, PROJECTED_AVAILABLE_BALANCE) and
3307: sd.plan_id = -1 and
3308: sd.publisher_id = 1 and
3309: exists (select cs.company_site_id

Line 3335: delete from msc_sup_dem_entries sd

3331: l_row := SQL%ROWCOUNT;
3332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
3333: --dbms_output.put_line('Deleted number records: ' || l_row);
3334: ELSIF ( p_overwrite = 2) THEN --delete by overwritten
3335: delete from msc_sup_dem_entries sd
3336: where sd.publisher_order_type in (SAFETY_STOCK, PROJECTED_AVAILABLE_BALANCE) and
3337: sd.plan_id = -1 and
3338: sd.publisher_id = 1 and
3339: exists (select cs.company_site_id