APPS.MSC_CL_GMP_UTILITY dependencies on MSC_ST_OPERATION_RESOURCES

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

5384: -- ---------------------------------------------
5385: /*
5386: Now the check if the above resource inserted is a Primary. If it is
5387: Primary then find its Alternates if existing, and then insert its rows
5388: into msc_st_operation_resources table. Also keep track of number of
5389: times alternates are inserted. 1319610
5390: */
5391:
5392: statement_no := 120 ;

Line 7079: INSERT INTO msc_st_operation_resources (

7075:
7076: --
7077: IF or_operation_sequence_id.FIRST > 0 THEN
7078: FORALL i IN or_operation_sequence_id.FIRST..or_operation_sequence_id.LAST
7079: INSERT INTO msc_st_operation_resources (
7080: operation_sequence_id,
7081: resource_seq_num,
7082: resource_id,
7083: alternate_number,

Line 7828: ||' from msc_st_operation_resources '

7824: ||' b.deleted_flag '
7825: ||' FROM gmp_sequence_dependencies'||at_apps_link||' a, '
7826: ||' (select unique RESOURCE_ID, ORGANIZATION_ID,'
7827: ||' setup_id , deleted_flag, sr_instance_id, uom_code '
7828: ||' from msc_st_operation_resources '
7829: ||' WHERE sr_instance_id = :instance1 '
7830: ||' and setup_id is not null ) b '
7831: ||' WHERE ( b.setup_id = a.from_seq_dep_id OR '
7832: ||' b.setup_id = a.to_seq_dep_id ) ' ;

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

9462: /* NAVIN :- START - Logic To Handle Alternate Resources */
9463: /*
9464: Now check if the above resource inserted is a Primary. If it is
9465: Primary then find its Alternates if existing, and then insert its rows
9466: into msc_st_operation_resources table. Also keep track of number of
9467: times alternates are inserted.
9468: */
9469:
9470: IF rsrc_tab(r).prim_rsrc_ind = 1 THEN