APPS.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_ROUTING_OPERATIONS

Line 664: TYPE operation_leadtime_per IS TABLE OF msc_st_routing_operations.operation_lead_time_percent%TYPE

660: rs_operation_sequence_id operation_sequence_id ;
661: oc_operation_sequence_id operation_sequence_id ;
662:
663: -- Bug 7391495 Vpedarla
664: TYPE operation_leadtime_per IS TABLE OF msc_st_routing_operations.operation_lead_time_percent%TYPE
665: INDEX BY BINARY_INTEGER;
666: opr_lead_time_percent operation_leadtime_per ;
667:
668: TYPE resource_seq_num IS TABLE OF msc_st_operation_resources.resource_seq_num%TYPE

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

856:
857: or_index PLS_INTEGER := 0 ; /* Operation Resource Global counter */
858:
859: /* -------------------------- Operations declarations ------------------------ */
860: TYPE operation_seq_num IS TABLE OF msc_st_routing_operations.operation_seq_num%TYPE
861: INDEX BY BINARY_INTEGER;
862: opr_operation_seq_num operation_seq_num ;
863:
864: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE

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

860: TYPE operation_seq_num IS TABLE OF msc_st_routing_operations.operation_seq_num%TYPE
861: INDEX BY BINARY_INTEGER;
862: opr_operation_seq_num operation_seq_num ;
863:
864: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE
865: INDEX BY BINARY_INTEGER;
866: opr_operation_description operation_description ;
867:
868: TYPE mtransfer_quantity IS TABLE OF msc_st_routing_operations.minimum_transfer_quantity%TYPE

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

864: TYPE operation_description IS TABLE OF msc_st_routing_operations.operation_description%TYPE
865: INDEX BY BINARY_INTEGER;
866: opr_operation_description operation_description ;
867:
868: TYPE mtransfer_quantity IS TABLE OF msc_st_routing_operations.minimum_transfer_quantity%TYPE
869: INDEX BY BINARY_INTEGER;
870: opr_mtransfer_quantity mtransfer_quantity ;
871:
872: TYPE department_id IS TABLE OF msc_st_routing_operations.department_id%TYPE

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

868: TYPE mtransfer_quantity IS TABLE OF msc_st_routing_operations.minimum_transfer_quantity%TYPE
869: INDEX BY BINARY_INTEGER;
870: opr_mtransfer_quantity mtransfer_quantity ;
871:
872: TYPE department_id IS TABLE OF msc_st_routing_operations.department_id%TYPE
873: INDEX BY BINARY_INTEGER;
874: opr_department_id department_id ;
875: rs_department_id department_id ;
876:

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

873: INDEX BY BINARY_INTEGER;
874: opr_department_id department_id ;
875: rs_department_id department_id ;
876:
877: TYPE department_code IS TABLE OF msc_st_routing_operations.department_code%TYPE
878: INDEX BY BINARY_INTEGER;
879: opr_department_code department_code ;
880:
881: TYPE activity_group_id IS TABLE OF msc_st_operation_resource_seqs.activity_group_id%TYPE

Line 6904: INSERT INTO msc_st_routing_operations (

6900: stmt_no := 906 ;
6901: i := 1 ;
6902: IF opr_operation_sequence_id.FIRST > 0 THEN
6903: FORALL i IN opr_operation_sequence_id.FIRST..opr_operation_sequence_id.LAST
6904: INSERT INTO msc_st_routing_operations (
6905: operation_sequence_id,
6906: routing_sequence_id,
6907: operation_seq_num,
6908: sr_instance_id,