434: X_last_updated_by number,
435: X_last_update_login number)
436: IS
437: l_sys_date DATE := SYSDATE;
438: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
439: BEGIN
440: if (X_event = 'INSERT') then
441:
442: select mtl_item_revisions_b_s.nextval
438: l_revision_id mtl_item_revisions_b.revision_id%TYPE;
439: BEGIN
440: if (X_event = 'INSERT') then
441:
442: select mtl_item_revisions_b_s.nextval
443: into l_revision_id from dual;
444:
445: insert into mtl_item_revisions_b
446: (inventory_item_id,
441:
442: select mtl_item_revisions_b_s.nextval
443: into l_revision_id from dual;
444:
445: insert into mtl_item_revisions_b
446: (inventory_item_id,
447: organization_id,
448: last_update_date,
449: last_updated_by,
505: AND T.LANGUAGE = L.LANGUAGE_CODE);
506:
507: elsif (X_event = 'ORG_ASSIGN') then
508:
509: select mtl_item_revisions_b_s.nextval
510: into l_revision_id from dual;
511:
512: insert into mtl_item_revisions_b
513: (inventory_item_id,
508:
509: select mtl_item_revisions_b_s.nextval
510: into l_revision_id from dual;
511:
512: insert into mtl_item_revisions_b
513: (inventory_item_id,
514: organization_id,
515: last_update_date,
516: last_updated_by,