APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ASL_AUTH_DETAILS

Line 3617: /* This procedure removes the ASL's from the MSC_ASL_AUTH_DETAILS if they do not exist in */

3613:
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

Line 3624: /* This cursor gives the set of ASL that are there in MSC_ASL_AUTH_DETAILS */

3620:
3621: IS
3622:
3623:
3624: /* This cursor gives the set of ASL that are there in MSC_ASL_AUTH_DETAILS */
3625: CURSOR c_sup_item_org is
3626: select distinct
3627: SUPPLIER_ID,
3628: SUPPLIER_SITE_ID ,

Line 3635: msc_asl_auth_details

3631: INVENTORY_ITEM_ID,
3632: INCLUDE_LIABILITY_AGREEMENT,
3633: ASL_LIABILITY_AGREEMENT_BASIS,USING_ORGANIZATION_ID
3634: from
3635: msc_asl_auth_details
3636: where
3637: plan_id = -1 and
3638: sr_instance_id = MSC_CL_COLLECTION.v_instance_id ;
3639:

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 3646: delete msc_asl_auth_details a

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
3650: p.SUPPLIER_SITE_ID = a.SUPPLIER_SITE_ID and