APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 1009: FROM msc_sup_dem_entries

1005: BEGIN
1006: SELECT 1 INTO l_records_exist
1007: FROM dual
1008: WHERE exists ( SELECT 1
1009: FROM msc_sup_dem_entries
1010: WHERE plan_id = -1
1011: AND publisher_order_type = 3
1012: AND publisher_id = 1
1013: AND designator = p_designator

Line 1282: insert into msc_sup_dem_entries (

1278: l_order_type_desc := 'Supply commit';
1279: END;
1280:
1281: FORALL j in t_pub.FIRST..t_pub.LAST
1282: insert into msc_sup_dem_entries (
1283: transaction_id,
1284: plan_id,
1285: sr_instance_id,
1286: publisher_name,

Line 1347: msc_sup_dem_entries_s.nextval,

1343: planner_code,
1344: version,
1345: designator
1346: ) values (
1347: msc_sup_dem_entries_s.nextval,
1348: -1,
1349: -1,
1350: t_pub(j),
1351: t_pub_id(j),

Line 1494: delete from msc_sup_dem_entries sd

1490:
1491: --print_debug_info('l_customer_site_id := ' || l_customer_site_id);
1492:
1493: IF (p_overwrite = 1) THEN -- delete all
1494: delete from msc_sup_dem_entries sd
1495: where sd.publisher_order_type = 3 and
1496: sd.plan_id = -1 and
1497: sd.publisher_id = 1 and
1498: sd.publisher_site_id IN (select cs.company_site_id

Line 1537: delete from msc_sup_dem_entries sd

1533: l_row := SQL%ROWCOUNT;
1534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
1535:
1536: ELSIF p_overwrite = 2 THEN
1537: delete from msc_sup_dem_entries sd
1538: where sd.publisher_order_type = 3 and
1539: sd.plan_id = -1 and
1540: sd.publisher_id = 1 and
1541: sd.publisher_site_id IN (select cs.company_site_id