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,
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;