APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 982: FROM msc_sup_dem_entries

978: BEGIN
979: SELECT 1 INTO l_records_exist
980: FROM dual
981: WHERE exists ( SELECT 1
982: FROM msc_sup_dem_entries
983: WHERE plan_id = -1
984: AND publisher_order_type = 3
985: AND publisher_id = 1
986: AND designator = p_designator

Line 1247: insert into msc_sup_dem_entries (

1243: l_order_type_desc := 'Supply commit';
1244: END;
1245:
1246: FORALL j in t_pub.FIRST..t_pub.LAST
1247: insert into msc_sup_dem_entries (
1248: transaction_id,
1249: plan_id,
1250: sr_instance_id,
1251: publisher_name,

Line 1312: msc_sup_dem_entries_s.nextval,

1308: planner_code,
1309: version,
1310: designator
1311: ) values (
1312: msc_sup_dem_entries_s.nextval,
1313: -1,
1314: -1,
1315: t_pub(j),
1316: t_pub_id(j),

Line 1458: delete from msc_sup_dem_entries sd

1454:
1455: --print_debug_info('l_customer_site_id := ' || l_customer_site_id);
1456:
1457: IF (p_overwrite = 1) THEN -- delete all
1458: delete from msc_sup_dem_entries sd
1459: where sd.publisher_order_type = 3 and
1460: sd.plan_id = -1 and
1461: sd.publisher_id = 1 and
1462: sd.publisher_site_id IN (select cs.company_site_id

Line 1501: delete from msc_sup_dem_entries sd

1497: l_row := SQL%ROWCOUNT;
1498: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
1499:
1500: ELSIF p_overwrite = 2 THEN
1501: delete from msc_sup_dem_entries sd
1502: where sd.publisher_order_type = 3 and
1503: sd.plan_id = -1 and
1504: sd.publisher_id = 1 and
1505: sd.publisher_site_id IN (select cs.company_site_id