APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_OPERATION_RESOURCES

Line 5026: into msc_st_operation_resources table. Also keep track of number of

5022: -- ---------------------------------------------
5023: /*
5024: Now the check if the above resource inserted is a Primary. If it is
5025: Primary then find its Alternates if existing, and then insert its rows
5026: into msc_st_operation_resources table. Also keep track of number of
5027: times alternates are inserted. 1319610
5028: */
5029:
5030: statement_no := 120 ;

Line 6659: INSERT INTO msc_st_operation_resources (

6655:
6656: --
6657: IF or_operation_sequence_id.FIRST > 0 THEN
6658: FORALL i IN or_operation_sequence_id.FIRST..or_operation_sequence_id.LAST
6659: INSERT INTO msc_st_operation_resources (
6660: operation_sequence_id,
6661: resource_seq_num,
6662: resource_id,
6663: alternate_number,

Line 7350: ||' from msc_st_operation_resources '

7346: ||' b.deleted_flag '
7347: ||' FROM gmp_sequence_dependencies'||at_apps_link||' a, '
7348: ||' (select unique RESOURCE_ID, ORGANIZATION_ID,'
7349: ||' setup_id , deleted_flag, sr_instance_id, uom_code '
7350: ||' from msc_st_operation_resources '
7351: ||' WHERE sr_instance_id = :instance1 '
7352: ||' and setup_id is not null ) b '
7353: ||' WHERE ( b.setup_id = a.from_seq_dep_id OR '
7354: ||' b.setup_id = a.to_seq_dep_id ) ' ;

Line 8869: into msc_st_operation_resources table. Also keep track of number of

8865: /* NAVIN :- START - Logic To Handle Alternate Resources */
8866: /*
8867: Now check if the above resource inserted is a Primary. If it is
8868: Primary then find its Alternates if existing, and then insert its rows
8869: into msc_st_operation_resources table. Also keep track of number of
8870: times alternates are inserted.
8871: */
8872:
8873: IF rsrc_tab(r).prim_rsrc_ind = 1 THEN