DBA Data[Home] [Help]

APPS.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_OPERATION_RESOURCE_SEQS

Line 881: TYPE activity_group_id IS TABLE OF msc_st_operation_resource_seqs.activity_group_id%TYPE

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
882: INDEX BY BINARY_INTEGER;
883: rs_activity_group_id activity_group_id ;
884:
885: TYPE schedule_flag IS TABLE OF msc_st_operation_resource_seqs.activity_group_id%TYPE

Line 885: TYPE schedule_flag IS TABLE OF msc_st_operation_resource_seqs.activity_group_id%TYPE

881: TYPE activity_group_id IS TABLE OF msc_st_operation_resource_seqs.activity_group_id%TYPE
882: INDEX BY BINARY_INTEGER;
883: rs_activity_group_id activity_group_id ;
884:
885: TYPE schedule_flag IS TABLE OF msc_st_operation_resource_seqs.activity_group_id%TYPE
886: INDEX BY BINARY_INTEGER;
887: rs_schedule_flag schedule_flag ;
888:
889: /* NAMIT_MTQ */

Line 6978: INSERT INTO msc_st_operation_resource_seqs (

6974: stmt_no := 907 ;
6975: i := 1 ;
6976: IF rs_operation_sequence_id.FIRST > 0 THEN
6977: FORALL i IN rs_operation_sequence_id.FIRST..rs_operation_sequence_id.LAST
6978: INSERT INTO msc_st_operation_resource_seqs (
6979: operation_sequence_id,
6980: resource_seq_num,
6981: sr_instance_id,
6982: department_id,