DBA Data[Home] [Help]

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_SUP_DEM_ENTRIES_S

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