DBA Data[Home] [Help]

APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_CHANGE_LINES_S

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;