DBA Data[Home] [Help]

APPS.WIP_EAM_UTILS dependencies on BOM_OPERATION_SEQUENCES

Line 594: TYPE op_rec_type is record (operation_sequence_id bom_operation_sequences.operation_sequence_id%type,

590:
591: -- baroy - instead of the ref cursor, use collections for bulk binding.
592: -- TYPE CUR_TYP is ref cursor;
593: -- c_op_cur CUR_TYP;
594: TYPE op_rec_type is record (operation_sequence_id bom_operation_sequences.operation_sequence_id%type,
595: operation_seq_num bom_operation_sequences.operation_seq_num%type);
596:
597: op_rec op_rec_type;
598: cursor op_table is select operation_sequence_id, operation_seq_num

Line 595: operation_seq_num bom_operation_sequences.operation_seq_num%type);

591: -- baroy - instead of the ref cursor, use collections for bulk binding.
592: -- TYPE CUR_TYP is ref cursor;
593: -- c_op_cur CUR_TYP;
594: TYPE op_rec_type is record (operation_sequence_id bom_operation_sequences.operation_sequence_id%type,
595: operation_seq_num bom_operation_sequences.operation_seq_num%type);
596:
597: op_rec op_rec_type;
598: cursor op_table is select operation_sequence_id, operation_seq_num
599: from bom_operation_sequences

Line 599: from bom_operation_sequences

595: operation_seq_num bom_operation_sequences.operation_seq_num%type);
596:
597: op_rec op_rec_type;
598: cursor op_table is select operation_sequence_id, operation_seq_num
599: from bom_operation_sequences
600: where routing_sequence_id = p_common_routing_sequence_id ;
601:
602: begin
603:

Line 735: -- open c_op_cur for 'select operation_sequence_id, operation_seq_num from bom_operation_sequences where routing_sequence_id = ' || p_common_routing_sequence_id ;

731: -- X_request_id => ''
732: );
733:
734: -- Copy Attachments from Activity Routing
735: -- open c_op_cur for 'select operation_sequence_id, operation_seq_num from bom_operation_sequences where routing_sequence_id = ' || p_common_routing_sequence_id ;
736:
737: -- l_stmt_num := 75;
738:
739: LOOP FETCH op_table into op_rec;

Line 749: X_from_entity_name => 'BOM_OPERATION_SEQUENCES',

745:
746: if l_operation_sequence_id is not null then
747:
748: fnd_attached_documents2_pkg.copy_attachments(
749: X_from_entity_name => 'BOM_OPERATION_SEQUENCES',
750: X_from_pk1_value => to_char(l_operation_sequence_id),
751: X_from_pk2_value => '',
752: X_from_pk3_value => '',
753: X_from_pk4_value => '',