APPS.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_ROUTING_OPERATIONS

Line 825: TYPE operation_seq_num IS TABLE OF msc_st_routing_operations.operation_seq_num%TYPE

821:
822: or_index PLS_INTEGER := 0 ; /* Operation Resource Global counter */
823:
824: /* -------------------------- Operations declarations ------------------------ */
825: TYPE operation_seq_num IS TABLE OF msc_st_routing_operations.operation_seq_num%TYPE
826: INDEX BY BINARY_INTEGER;
827: opr_operation_seq_num operation_seq_num ;
828:
829: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE

Line 829: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE

825: TYPE operation_seq_num IS TABLE OF msc_st_routing_operations.operation_seq_num%TYPE
826: INDEX BY BINARY_INTEGER;
827: opr_operation_seq_num operation_seq_num ;
828:
829: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE
830: INDEX BY BINARY_INTEGER;
831: opr_operation_description operation_description ;
832:
833: TYPE mtransfer_quantity IS TABLE OF msc_st_routing_operations.minimum_transfer_quantity%TYPE

Line 833: TYPE mtransfer_quantity IS TABLE OF msc_st_routing_operations.minimum_transfer_quantity%TYPE

829: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE
830: INDEX BY BINARY_INTEGER;
831: opr_operation_description operation_description ;
832:
833: TYPE mtransfer_quantity IS TABLE OF msc_st_routing_operations.minimum_transfer_quantity%TYPE
834: INDEX BY BINARY_INTEGER;
835: opr_mtransfer_quantity mtransfer_quantity ;
836:
837: TYPE department_id IS TABLE OF msc_st_routing_operations.department_id%TYPE

Line 837: TYPE department_id IS TABLE OF msc_st_routing_operations.department_id%TYPE

833: TYPE mtransfer_quantity IS TABLE OF msc_st_routing_operations.minimum_transfer_quantity%TYPE
834: INDEX BY BINARY_INTEGER;
835: opr_mtransfer_quantity mtransfer_quantity ;
836:
837: TYPE department_id IS TABLE OF msc_st_routing_operations.department_id%TYPE
838: INDEX BY BINARY_INTEGER;
839: opr_department_id department_id ;
840: rs_department_id department_id ;
841:

Line 842: TYPE department_code IS TABLE OF msc_st_routing_operations.department_code%TYPE

838: INDEX BY BINARY_INTEGER;
839: opr_department_id department_id ;
840: rs_department_id department_id ;
841:
842: TYPE department_code IS TABLE OF msc_st_routing_operations.department_code%TYPE
843: INDEX BY BINARY_INTEGER;
844: opr_department_code department_code ;
845:
846: TYPE activity_group_id IS TABLE OF msc_st_operation_resource_seqs.activity_group_id%TYPE

Line 6360: INSERT INTO msc_st_routing_operations (

6356: stmt_no := 906 ;
6357: i := 1 ;
6358: IF opr_operation_sequence_id.FIRST > 0 THEN
6359: FORALL i IN opr_operation_sequence_id.FIRST..opr_operation_sequence_id.LAST
6360: INSERT INTO msc_st_routing_operations (
6361: operation_sequence_id,
6362: routing_sequence_id,
6363: operation_seq_num,
6364: sr_instance_id,