APPS.ENG_REVISED_ITEMS_PKG dependencies on DUAL

Line 32: from DUAL;

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

Line 255: from sys.dual;

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

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

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

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

555: and inventory_item_id = x_inventory_item_id
556: and revised_item_sequence_id = x_revised_item_sequence_id
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

Line 671: FROM dual;

667: WHERE revision_id = p_revision_id;
668:
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