APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_SUP_DEM_ENTRIES_S

Line 2053: msc_sup_dem_entries_s.nextval,

2049: planner_code,
2050: version,
2051: designator
2052: ) values (
2053: msc_sup_dem_entries_s.nextval,
2054: -1,
2055: -1,
2056: t_pub(j),
2057: t_pub_id(j),

Line 2198: msc_sup_dem_entries_s.nextval,

2194: planner_code,
2195: version,
2196: designator
2197: ) values (
2198: msc_sup_dem_entries_s.nextval,
2199: -1,
2200: -1,
2201: t_pub(j),
2202: t_pub_id(j),

Line 2322: msc_sup_dem_entries_s.nextval,

2318: planner_code,
2319: version,
2320: designator
2321: ) values (
2322: msc_sup_dem_entries_s.nextval,
2323: -1,
2324: -1,
2325: t_pub(j-1),
2326: t_pub_id(j-1),

Line 2441: msc_sup_dem_entries_s.nextval,

2437: planner_code,
2438: version,
2439: designator
2440: ) values (
2441: msc_sup_dem_entries_s.nextval,
2442: -1,
2443: -1,
2444: t_pub(j),
2445: t_pub_id(j),

Line 2588: msc_sup_dem_entries_s.nextval,

2584: planner_code,
2585: version,
2586: designator
2587: ) values (
2588: msc_sup_dem_entries_s.nextval,
2589: -1,
2590: -1,
2591: t_pub(j),
2592: t_pub_id(j),

Line 2750: msc_sup_dem_entries_s.nextval,

2746: planner_code,
2747: version,
2748: designator
2749: ) values (
2750: msc_sup_dem_entries_s.nextval,
2751: -1,
2752: -1,
2753: t_pub(j),
2754: t_pub_id(j),

Line 2859: msc_sup_dem_entries_s.nextval,

2855: planner_code,
2856: version,
2857: designator
2858: ) values (
2859: msc_sup_dem_entries_s.nextval,
2860: -1,
2861: -1,
2862: t_pub(j),
2863: t_pub_id(j),

Line 2978: msc_sup_dem_entries_s.nextval,

2974: planner_code,
2975: version,
2976: designator
2977: ) values (
2978: msc_sup_dem_entries_s.nextval,
2979: -1,
2980: -1,
2981: t_pub(j),
2982: t_pub_id(j),

Line 3104: msc_sup_dem_entries_s.nextval,

3100: planner_code,
3101: version,
3102: designator
3103: ) values (
3104: msc_sup_dem_entries_s.nextval,
3105: -1,
3106: -1,
3107: t_pub(j-1),
3108: t_pub_id(j-1),

Line 3232: msc_sup_dem_entries_s.nextval,

3228: planner_code,
3229: version,
3230: designator
3231: ) values (
3232: msc_sup_dem_entries_s.nextval,
3233: -1,
3234: -1,
3235: t_pub(j),
3236: t_pub_id(j),

Line 3321: delete from msc_sup_dem_entries sd

3317: --dbms_output.put_line('In delete_old_safety stock');
3318:
3319:
3320: IF ( p_overwrite = 1) THEN --delete all
3321: delete from msc_sup_dem_entries sd
3322: where sd.publisher_order_type in (SAFETY_STOCK, PROJECTED_AVAILABLE_BALANCE) and
3323: sd.plan_id = -1 and
3324: sd.publisher_id = 1 and
3325: exists (select cs.company_site_id

Line 3351: delete from msc_sup_dem_entries sd

3347: l_row := SQL%ROWCOUNT;
3348: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
3349: --dbms_output.put_line('Deleted number records: ' || l_row);
3350: ELSIF ( p_overwrite = 2) THEN --delete by overwritten
3351: delete from msc_sup_dem_entries sd
3352: where sd.publisher_order_type in (SAFETY_STOCK, PROJECTED_AVAILABLE_BALANCE) and
3353: sd.plan_id = -1 and
3354: sd.publisher_id = 1 and
3355: exists (select cs.company_site_id