DBA Data[Home] [Help]

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_SUP_DEM_ENTRIES_S

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