APPS.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_OPERATION_RESOURCES

Line 629: TYPE operation_sequence_id IS TABLE OF msc_st_operation_resources.operation_sequence_id%TYPE

625: INDEX BY BINARY_INTEGER;
626: bomc_component_sequence_id component_sequence_id;
627: oc_component_sequence_id component_sequence_id;
628:
629: TYPE operation_sequence_id IS TABLE OF msc_st_operation_resources.operation_sequence_id%TYPE
630: INDEX BY BINARY_INTEGER;
631: or_operation_sequence_id operation_sequence_id ;
632: opr_operation_sequence_id operation_sequence_id ;
633: rs_operation_sequence_id operation_sequence_id ;

Line 636: TYPE resource_seq_num IS TABLE OF msc_st_operation_resources.resource_seq_num%TYPE

632: opr_operation_sequence_id operation_sequence_id ;
633: rs_operation_sequence_id operation_sequence_id ;
634: oc_operation_sequence_id operation_sequence_id ;
635:
636: TYPE resource_seq_num IS TABLE OF msc_st_operation_resources.resource_seq_num%TYPE
637: INDEX BY BINARY_INTEGER;
638: or_resource_seq_num resource_seq_num ;
639: rs_resource_seq_num resource_seq_num ;
640: /* SGIDUGU - Seq Dep */

Line 789: TYPE resource_id IS TABLE OF msc_st_operation_resources.resource_id%TYPE

785:
786: rtg_index INTEGER := 0 ; /* Routing Global counter */
787:
788: /* -------------------------- Routng operations declarations ------------------------ */
789: TYPE resource_id IS TABLE OF msc_st_operation_resources.resource_id%TYPE
790: INDEX BY BINARY_INTEGER;
791: or_resource_id resource_id ;
792: gt_resource_id resource_id ;
793:

Line 794: TYPE alternate_number IS TABLE OF msc_st_operation_resources.alternate_number%TYPE

790: INDEX BY BINARY_INTEGER;
791: or_resource_id resource_id ;
792: gt_resource_id resource_id ;
793:
794: TYPE alternate_number IS TABLE OF msc_st_operation_resources.alternate_number%TYPE
795: INDEX BY BINARY_INTEGER;
796: or_alternate_number alternate_number ;
797:
798: TYPE principal_flag IS TABLE OF msc_st_operation_resources.principal_flag%TYPE

Line 798: TYPE principal_flag IS TABLE OF msc_st_operation_resources.principal_flag%TYPE

794: TYPE alternate_number IS TABLE OF msc_st_operation_resources.alternate_number%TYPE
795: INDEX BY BINARY_INTEGER;
796: or_alternate_number alternate_number ;
797:
798: TYPE principal_flag IS TABLE OF msc_st_operation_resources.principal_flag%TYPE
799: INDEX BY BINARY_INTEGER;
800: or_principal_flag principal_flag ;
801:
802: TYPE basis_type IS TABLE OF msc_st_operation_resources.basis_type%TYPE

Line 802: TYPE basis_type IS TABLE OF msc_st_operation_resources.basis_type%TYPE

798: TYPE principal_flag IS TABLE OF msc_st_operation_resources.principal_flag%TYPE
799: INDEX BY BINARY_INTEGER;
800: or_principal_flag principal_flag ;
801:
802: TYPE basis_type IS TABLE OF msc_st_operation_resources.basis_type%TYPE
803: INDEX BY BINARY_INTEGER;
804: or_basis_type basis_type ;
805:
806: TYPE resource_usage IS TABLE OF msc_st_operation_resources.resource_usage%TYPE

Line 806: TYPE resource_usage IS TABLE OF msc_st_operation_resources.resource_usage%TYPE

802: TYPE basis_type IS TABLE OF msc_st_operation_resources.basis_type%TYPE
803: INDEX BY BINARY_INTEGER;
804: or_basis_type basis_type ;
805:
806: TYPE resource_usage IS TABLE OF msc_st_operation_resources.resource_usage%TYPE
807: INDEX BY BINARY_INTEGER;
808: or_resource_usage resource_usage ;
809:
810: TYPE max_resource_units IS TABLE OF msc_st_operation_resources.max_resource_units%TYPE

Line 810: TYPE max_resource_units IS TABLE OF msc_st_operation_resources.max_resource_units%TYPE

806: TYPE resource_usage IS TABLE OF msc_st_operation_resources.resource_usage%TYPE
807: INDEX BY BINARY_INTEGER;
808: or_resource_usage resource_usage ;
809:
810: TYPE max_resource_units IS TABLE OF msc_st_operation_resources.max_resource_units%TYPE
811: INDEX BY BINARY_INTEGER;
812: or_max_resource_units max_resource_units ;
813:
814: TYPE resource_units IS TABLE OF msc_st_operation_resources.resource_units%TYPE

Line 814: TYPE resource_units IS TABLE OF msc_st_operation_resources.resource_units%TYPE

810: TYPE max_resource_units IS TABLE OF msc_st_operation_resources.max_resource_units%TYPE
811: INDEX BY BINARY_INTEGER;
812: or_max_resource_units max_resource_units ;
813:
814: TYPE resource_units IS TABLE OF msc_st_operation_resources.resource_units%TYPE
815: INDEX BY BINARY_INTEGER;
816: or_resource_units resource_units ;
817:
818: TYPE or_orig_rs_seq_num_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

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

4973:
4974: /*
4975: Now the check if the above resource inserted is a Primary. If it is
4976: Primary then find its Alternates if existing, and then insert its rows
4977: into msc_st_operation_resources table. Also keep track of number of
4978: times alternates are inserted. 1319610
4979: */
4980:
4981: statement_no := 120 ;

Line 6306: INSERT INTO msc_st_operation_resources (

6302:
6303: --
6304: IF or_operation_sequence_id.FIRST > 0 THEN
6305: FORALL i IN or_operation_sequence_id.FIRST..or_operation_sequence_id.LAST
6306: INSERT INTO msc_st_operation_resources (
6307: operation_sequence_id,
6308: resource_seq_num,
6309: resource_id,
6310: alternate_number,

Line 6851: ||' from MSC_ST_OPERATION_RESOURCES '

6847: ||' b.deleted_flag '
6848: ||' FROM gmp_sequence_dependencies'||at_apps_link||' a, '
6849: ||' (select unique RESOURCE_ID, ORGANIZATION_ID,'
6850: ||' SETUP_ID , deleted_flag, sr_instance_id, UOM_CODE '
6851: ||' from MSC_ST_OPERATION_RESOURCES '
6852: ||' WHERE sr_instance_id = :instance1 '
6853: ||' and setup_id is not null ) b '
6854: ||' WHERE ( b.setup_id = a.from_seq_dep_id OR '
6855: ||' b.setup_id = a.to_seq_dep_id ) ' ;