DBA Data[Home] [Help]

APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_CHANGE_LINES_S

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;