APPS.ENG_REVISED_ITEM_UTIL dependencies on DUAL

Line 159: From dual

155: l_token_tbl Error_Handler.Token_Tbl_Type;
156: X_EcoStatus number;
157: Cursor CheckEco is
158: Select 'x' dummy
159: From dual
160: Where not exists (
161: Select null
162: From eng_revised_items eri
163: Where eri.change_notice = p_change_notice

Line 169: From dual

165: And eri.status_type not in (6, 5));
166:
167: Cursor CheckStatusEco is
168: Select 'x' dummy
169: From dual
170: Where exists (
171: Select null
172: From eng_revised_items eri
173: Where eri.change_notice = p_change_notice

Line 553: from sys.dual;

549: x_schedule_id NUMBER;
550: BEGIN
551: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
552: into x_schedule_id
553: from sys.dual;
554: insert into ENG_CURRENT_SCHEDULED_DATES (
555: change_notice,
556: organization_id,
557: revised_item_id,

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

1099: AND revision = nvl( p_revised_item_rec.new_revised_item_revision,'NULL')
1100: RETURNING revision_id INTO l_revision_id;
1101:
1102:
1103: SELECT userenv('LANG') INTO l_language_code FROM dual;
1104: update MTL_ITEM_REVISIONS_TL
1105: set
1106: last_update_date = SYSDATE, --who column
1107: last_update_login = l_login_id, --who column

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

1201: p_rev_item_unexp_rec.revised_item_sequence_id
1202: AND revision = nvl( p_revised_item_rec.new_revised_item_revision,'NULL')
1203: RETURNING revision_id INTO l_revision_id;
1204:
1205: SELECT userenv('LANG') INTO l_language_code FROM dual;
1206: update MTL_ITEM_REVISIONS_TL
1207: set
1208: last_update_date = SYSDATE, --who column
1209: last_update_login = l_login_id, --who column

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

1453: RETURNING revision_id INTO l_revision_id;
1454:
1455: /* Item revision description support Bug: 1667419*/
1456:
1457: SELECT userenv('LANG') INTO l_language_code FROM dual;
1458: update MTL_ITEM_REVISIONS_TL
1459: set
1460: last_update_date = SYSDATE, --who column
1461: last_update_login = l_login_id, --who column

Line 2681: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;

2677: --
2678: -- Generate a sequence_number for the new revised item
2679: -- Copy only attributes required for creation of revised item context
2680: --
2681: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;
2682: l_revised_item_rec.eco_name := l_old_revised_item_rec.change_notice;
2683: l_rev_item_unexp_rec.organization_id := l_old_revised_item_rec.organization_id;
2684: l_rev_item_unexp_rec.revised_item_id := l_old_revised_item_rec.revised_item_id;
2685: l_revised_item_rec.disposition_type := l_old_revised_item_rec.disposition_type;