APPS.ENG_REVISED_ITEMS_PKG dependencies on DUAL

Line 34: from DUAL;

30: seq_id NUMBER;
31: BEGIN
32: select BOM_LISTS_S.nextval
33: into seq_id
34: from DUAL;
35: return(seq_id);
36: END Get_BOM_Lists_Seq_Id;
37:
38:

Line 257: from sys.dual;

253: x_schedule_id NUMBER;
254: BEGIN
255: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
256: into x_schedule_id
257: from sys.dual;
258: insert into ENG_CURRENT_SCHEDULED_DATES (
259: change_notice,
260: organization_id,
261: revised_item_id,

Line 433: SELECT userenv('LANG') INTO l_language_code FROM dual;

429: decode(x_revision_description,FND_API.G_MISS_CHAR,NULL,x_revision_description),
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,

Line 561: SELECT userenv('LANG') INTO l_language_code FROM dual;

557: and inventory_item_id = x_inventory_item_id
558: and revised_item_sequence_id = x_revised_item_sequence_id
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

Line 694: FROM dual;

690: WHERE revision_id = p_revision_id;
691:
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