APPS.ENG_REVISED_ITEMS_PKG dependencies on MTL_ITEM_REVISIONS_TL

Line 68: delete from MTL_ITEM_REVISIONS_TL

64: x_change_notice VARCHAR2)
65: IS
66: BEGIN
67:
68: delete from MTL_ITEM_REVISIONS_TL
69: where revision_id IN (SELECT revision_id
70: FROM MTL_ITEM_REVISIONS_B
71: WHERE organization_id = x_organization_id
72: and inventory_item_id = x_revised_item_id

Line 319: delete from MTL_ITEM_REVISIONS_TL

315: and implementation_date is null);
316:
317:
318:
319: delete from MTL_ITEM_REVISIONS_TL
320: where revision_id IN (select revision_id
321: from MTL_ITEM_REVISIONS_B
322: where organization_id = x_organization_id
323: and inventory_item_id = x_inventory_item_id

Line 434: -- description is stored in MTL_ITEM_REVISIONS_TL

430: decode(p_new_revision_reason_code, FND_API.G_MISS_CHAR, NULL, p_new_revision_reason_code)
431: )RETURNING revision_id INTO l_revision_id;
432:
433: SELECT userenv('LANG') INTO l_language_code FROM dual;
434: -- description is stored in MTL_ITEM_REVISIONS_TL
435: insert into MTL_ITEM_REVISIONS_TL (
436: inventory_item_id,
437: organization_id,
438: revision_id,

Line 435: insert into MTL_ITEM_REVISIONS_TL (

431: )RETURNING revision_id INTO l_revision_id;
432:
433: SELECT userenv('LANG') INTO l_language_code FROM dual;
434: -- description is stored in MTL_ITEM_REVISIONS_TL
435: insert into MTL_ITEM_REVISIONS_TL (
436: inventory_item_id,
437: organization_id,
438: revision_id,
439: language,

Line 463: from MTL_ITEM_REVISIONS_TL T

459: FROM FND_LANGUAGES lang
460: where lang.INSTALLED_FLAG in ('I', 'B')
461: and not exists
462: (select NULL
463: from MTL_ITEM_REVISIONS_TL T
464: where T.INVENTORY_ITEM_ID = x_inventory_item_id
465: and T.ORGANIZATION_ID = x_organization_id
466: and T.REVISION_ID = l_revision_id
467: and T.LANGUAGE = lang.LANGUAGE_CODE);

Line 563: update MTL_ITEM_REVISIONS_TL

559: RETURNING revision_id INTO l_revision_id;
560:
561: SELECT userenv('LANG') INTO l_language_code FROM dual;
562:
563: update MTL_ITEM_REVISIONS_TL
564: set
565: last_update_date = SYSDATE, --who column
566: last_update_login = l_login_id, --who column
567: last_updated_by = l_user_id, --who column

Line 696: UPDATE MTL_ITEM_REVISIONS_TL

692: SELECT userenv('LANG')
693: INTO l_language_code
694: FROM dual;
695:
696: UPDATE MTL_ITEM_REVISIONS_TL
697: SET last_update_date = SYSDATE, --who column
698: last_update_login = l_login_id, --who column
699: last_updated_by = l_user_id, --who column
700: source_lang = l_language_code