APPS.ENG_REVISED_ITEMS_PKG dependencies on MTL_ITEM_REVISIONS_TL

Line 66: delete from MTL_ITEM_REVISIONS_TL

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

Line 317: delete from MTL_ITEM_REVISIONS_TL

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

Line 432: -- description is stored in MTL_ITEM_REVISIONS_TL

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

Line 433: insert into MTL_ITEM_REVISIONS_TL (

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

Line 461: from MTL_ITEM_REVISIONS_TL T

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

Line 561: update MTL_ITEM_REVISIONS_TL

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

Line 673: UPDATE MTL_ITEM_REVISIONS_TL

669: SELECT userenv('LANG')
670: INTO l_language_code
671: FROM dual;
672:
673: UPDATE MTL_ITEM_REVISIONS_TL
674: SET last_update_date = SYSDATE, --who column
675: last_update_login = l_login_id, --who column
676: last_updated_by = l_user_id, --who column
677: source_lang = l_language_code