APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_ASL_AUTH_DETAILS

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

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

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

3610:
3611: IS
3612:
3613:
3614: /* This cursor gives the set of ASL that are there in MSC_ASL_AUTH_DETAILS */
3615: CURSOR c_sup_item_org is
3616: select distinct
3617: SUPPLIER_ID,
3618: SUPPLIER_SITE_ID ,

Line 3625: msc_asl_auth_details

3621: INVENTORY_ITEM_ID,
3622: INCLUDE_LIABILITY_AGREEMENT,
3623: ASL_LIABILITY_AGREEMENT_BASIS,USING_ORGANIZATION_ID
3624: from
3625: msc_asl_auth_details
3626: where
3627: plan_id = -1 and
3628: sr_instance_id = MSC_CL_COLLECTION.v_instance_id ;
3629:

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

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