APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_CHANGE_LINES

Line 330: l_nir_line_sequence ENG_CHANGE_LINES.SEQUENCE_NUMBER%TYPE;

326: l_prev_org_id NUMBER;
327: l_org_code VARCHAR2(80);
328: --count number;
329: temp_change_line_id number;
330: l_nir_line_sequence ENG_CHANGE_LINES.SEQUENCE_NUMBER%TYPE;
331:
332: CURSOR cur_change_lines IS
333: select
334: change_line_id,

Line 606: set change_line_id = ENG_CHANGE_LINES_S.nextval

602:
603: END IF;
604:
605: update mtl_system_items_interface msii
606: set change_line_id = ENG_CHANGE_LINES_S.nextval
607: where msii.set_process_id = p_batch_id
608: and msii.process_flag= l_process_flag
609: -- and msii.transaction_type=L_TRANSACTION_TYPE
610: and change_id is not null;

Line 613: insert into eng_change_lines

609: -- and msii.transaction_type=L_TRANSACTION_TYPE
610: and change_id is not null;
611:
612: /* -- Commented for bug 6189094 because sequence number is hardcoded, for multiple items in NIr sequence number should be differnent
613: insert into eng_change_lines
614: ( change_line_id ,
615: change_id ,
616: created_by ,
617: creation_date ,

Line 649: INSERT INTO eng_change_lines

645: */
646: l_nir_line_sequence := 10;
647: FOR cur_chg_line IN cur_change_lines
648: LOOP
649: INSERT INTO eng_change_lines
650: ( change_line_id ,
651: change_id ,
652: created_by ,
653: creation_date ,

Line 679: insert into eng_change_lines_tl

675: );
676: l_nir_line_sequence := l_nir_line_sequence + 10;
677: END LOOP;
678:
679: insert into eng_change_lines_tl
680: ( change_line_id ,
681: created_by ,
682: creation_date ,
683: last_updated_by ,