APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_ITEM_SOURCING

Line 2381: -- 7. clear msc_item_sourcing

2377: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001004' || ' : ' || SQLERRM;
2378: -- NULL;
2379: --END;
2380:
2381: -- 7. clear msc_item_sourcing
2382: BEGIN
2383: DELETE from MSC_ITEM_SOURCING
2384: WHERE MSC_ITEM_SOURCING.PLAN_ID = PlanIdVar;
2385: EXCEPTION WHEN others THEN

Line 2383: DELETE from MSC_ITEM_SOURCING

2379: --END;
2380:
2381: -- 7. clear msc_item_sourcing
2382: BEGIN
2383: DELETE from MSC_ITEM_SOURCING
2384: WHERE MSC_ITEM_SOURCING.PLAN_ID = PlanIdVar;
2385: EXCEPTION WHEN others THEN
2386: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001005' || ' : ' || SQLERRM;
2387: NULL;

Line 2384: WHERE MSC_ITEM_SOURCING.PLAN_ID = PlanIdVar;

2380:
2381: -- 7. clear msc_item_sourcing
2382: BEGIN
2383: DELETE from MSC_ITEM_SOURCING
2384: WHERE MSC_ITEM_SOURCING.PLAN_ID = PlanIdVar;
2385: EXCEPTION WHEN others THEN
2386: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001005' || ' : ' || SQLERRM;
2387: NULL;
2388: END;

Line 2585: -- 12. INSERT into MSC_ITEM_SOURCING for item source count

2581: -- g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001009' || ' : ' || SQLERRM;
2582: -- raise;
2583: --END;
2584:
2585: -- 12. INSERT into MSC_ITEM_SOURCING for item source count
2586: BEGIN
2587: INSERT into MSC_ITEM_SOURCING (
2588: PLAN_ID,
2589: SR_INSTANCE_ID,

Line 2587: INSERT into MSC_ITEM_SOURCING (

2583: --END;
2584:
2585: -- 12. INSERT into MSC_ITEM_SOURCING for item source count
2586: BEGIN
2587: INSERT into MSC_ITEM_SOURCING (
2588: PLAN_ID,
2589: SR_INSTANCE_ID,
2590: ORGANIZATION_ID,
2591: SR_INSTANCE_ID2,