APPS.INVIDIT2 dependencies on MTL_ITEM_REVISIONS_B

Line 438: l_revision_id mtl_item_revisions_b.revision_id%TYPE;

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

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

Line 445: insert into mtl_item_revisions_b

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,

Line 509: select mtl_item_revisions_b_s.nextval

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,

Line 512: insert into mtl_item_revisions_b

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,