APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ITEM_SUPPLIERS

Line 3608: /* MSC_ITEM_SUPPLIERS */

3604: END LOAD_UOM;
3605:
3606: /* This procedure has been introduced for Liability Project */
3607: /* This procedure removes the ASL's from the MSC_ASL_AUTH_DETAILS if they do not exist in */
3608: /* MSC_ITEM_SUPPLIERS */
3609: PROCEDURE CLEAN_LIAB_AGREEMENT
3610:
3611: IS
3612:

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

3631:
3632:
3633: BEGIN
3634:
3635: /* This deletes the agreements form MSC_ASL_AUTH_DETAILS that dont have parent records in msc_item_suppliers*/
3636: delete msc_asl_auth_details a
3637: where not exists (select 1 from msc_item_suppliers p
3638: where p.PLAN_ID = a.PLAN_ID and
3639: p.SUPPLIER_ID = a. SUPPLIER_ID and

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

3633: BEGIN
3634:
3635: /* This deletes the agreements form MSC_ASL_AUTH_DETAILS that dont have parent records in msc_item_suppliers*/
3636: delete msc_asl_auth_details a
3637: where not exists (select 1 from msc_item_suppliers p
3638: where p.PLAN_ID = a.PLAN_ID and
3639: p.SUPPLIER_ID = a. SUPPLIER_ID and
3640: p.SUPPLIER_SITE_ID = a.SUPPLIER_SITE_ID and
3641: p.ORGANIZATION_ID = a.ORGANIZATION_ID and

Line 3663: UPDATE msc_item_suppliers

3659:
3660: LOOP
3661:
3662:
3663: UPDATE msc_item_suppliers
3664: set INCLUDE_LIABILITY_AGREEMENT = x_sup_item_org.INCLUDE_LIABILITY_AGREEMENT ,
3665: ASL_LIABILITY_AGREEMENT_BASIS = x_sup_item_org.ASL_LIABILITY_AGREEMENT_BASIS
3666: where
3667: SUPPLIER_ID = x_sup_item_org.SUPPLIER_ID and