DBA Data[Home] [Help]

APPS.WIP_EAM_UTILS dependencies on BOM_OPERATION_SEQUENCES

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

577:
578: -- baroy - instead of the ref cursor, use collections for bulk binding.
579: -- TYPE CUR_TYP is ref cursor;
580: -- c_op_cur CUR_TYP;
581: TYPE op_rec_type is record (operation_sequence_id bom_operation_sequences.operation_sequence_id%type,
582: operation_seq_num bom_operation_sequences.operation_seq_num%type);
583:
584: op_rec op_rec_type;
585: cursor op_table is select operation_sequence_id, operation_seq_num

Line 582: operation_seq_num bom_operation_sequences.operation_seq_num%type);

578: -- baroy - instead of the ref cursor, use collections for bulk binding.
579: -- TYPE CUR_TYP is ref cursor;
580: -- c_op_cur CUR_TYP;
581: TYPE op_rec_type is record (operation_sequence_id bom_operation_sequences.operation_sequence_id%type,
582: operation_seq_num bom_operation_sequences.operation_seq_num%type);
583:
584: op_rec op_rec_type;
585: cursor op_table is select operation_sequence_id, operation_seq_num
586: from bom_operation_sequences

Line 586: from bom_operation_sequences

582: operation_seq_num bom_operation_sequences.operation_seq_num%type);
583:
584: op_rec op_rec_type;
585: cursor op_table is select operation_sequence_id, operation_seq_num
586: from bom_operation_sequences
587: where routing_sequence_id = p_common_routing_sequence_id ;
588:
589: begin
590:

Line 722: -- 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 ;

718: -- X_request_id => ''
719: );
720:
721: -- Copy Attachments from Activity Routing
722: -- 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 ;
723:
724: -- l_stmt_num := 75;
725:
726: LOOP FETCH op_table into op_rec;

Line 736: X_from_entity_name => 'BOM_OPERATION_SEQUENCES',

732:
733: if l_operation_sequence_id is not null then
734:
735: fnd_attached_documents2_pkg.copy_attachments(
736: X_from_entity_name => 'BOM_OPERATION_SEQUENCES',
737: X_from_pk1_value => to_char(l_operation_sequence_id),
738: X_from_pk2_value => '',
739: X_from_pk3_value => '',
740: X_from_pk4_value => '',