APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_CHANGE_LINES

Line 313: l_nir_line_sequence ENG_CHANGE_LINES.SEQUENCE_NUMBER%TYPE;

309: l_prev_org_id NUMBER;
310: l_org_code VARCHAR2(80);
311: --count number;
312: temp_change_line_id number;
313: l_nir_line_sequence ENG_CHANGE_LINES.SEQUENCE_NUMBER%TYPE;
314:
315: CURSOR cur_change_lines IS
316: select
317: change_line_id,

Line 548: set change_line_id = ENG_CHANGE_LINES_S.nextval

544:
545: END IF;
546:
547: update mtl_system_items_interface msii
548: set change_line_id = ENG_CHANGE_LINES_S.nextval
549: where msii.set_process_id = p_batch_id
550: and msii.process_flag= l_process_flag
551: -- and msii.transaction_type=L_TRANSACTION_TYPE
552: and change_id is not null;

Line 555: insert into eng_change_lines

551: -- and msii.transaction_type=L_TRANSACTION_TYPE
552: and change_id is not null;
553:
554: /* -- Commented for bug 6189094 because sequence number is hardcoded, for multiple items in NIr sequence number should be differnent
555: insert into eng_change_lines
556: ( change_line_id ,
557: change_id ,
558: created_by ,
559: creation_date ,

Line 591: INSERT INTO eng_change_lines

587: */
588: l_nir_line_sequence := 10;
589: FOR cur_chg_line IN cur_change_lines
590: LOOP
591: INSERT INTO eng_change_lines
592: ( change_line_id ,
593: change_id ,
594: created_by ,
595: creation_date ,

Line 621: insert into eng_change_lines_tl

617: );
618: l_nir_line_sequence := l_nir_line_sequence + 10;
619: END LOOP;
620:
621: insert into eng_change_lines_tl
622: ( change_line_id ,
623: created_by ,
624: creation_date ,
625: last_updated_by ,