APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ITEM_SUPPLIERS

Line 3618: /* MSC_ITEM_SUPPLIERS */

3614: END LOAD_UOM;
3615:
3616: /* This procedure has been introduced for Liability Project */
3617: /* This procedure removes the ASL's from the MSC_ASL_AUTH_DETAILS if they do not exist in */
3618: /* MSC_ITEM_SUPPLIERS */
3619: PROCEDURE CLEAN_LIAB_AGREEMENT
3620:
3621: IS
3622:

Line 3645: /* This deletes the agreements form MSC_ASL_AUTH_DETAILS that dont have parent records in msc_item_suppliers*/

3641:
3642:
3643: BEGIN
3644:
3645: /* This deletes the agreements form MSC_ASL_AUTH_DETAILS that dont have parent records in msc_item_suppliers*/
3646: delete msc_asl_auth_details a
3647: where not exists (select 1 from msc_item_suppliers p
3648: where p.PLAN_ID = a.PLAN_ID and
3649: p.SUPPLIER_ID = a. SUPPLIER_ID and

Line 3647: where not exists (select 1 from msc_item_suppliers p

3643: BEGIN
3644:
3645: /* This deletes the agreements form MSC_ASL_AUTH_DETAILS that dont have parent records in msc_item_suppliers*/
3646: delete msc_asl_auth_details a
3647: where not exists (select 1 from msc_item_suppliers p
3648: where p.PLAN_ID = a.PLAN_ID and
3649: p.SUPPLIER_ID = a. SUPPLIER_ID and
3650: p.SUPPLIER_SITE_ID = a.SUPPLIER_SITE_ID and
3651: p.ORGANIZATION_ID = a.ORGANIZATION_ID and

Line 3673: UPDATE msc_item_suppliers

3669:
3670: LOOP
3671:
3672:
3673: UPDATE msc_item_suppliers
3674: set INCLUDE_LIABILITY_AGREEMENT = x_sup_item_org.INCLUDE_LIABILITY_AGREEMENT ,
3675: ASL_LIABILITY_AGREEMENT_BASIS = x_sup_item_org.ASL_LIABILITY_AGREEMENT_BASIS
3676: where
3677: SUPPLIER_ID = x_sup_item_org.SUPPLIER_ID and