APPS.ENG_REVISED_ITEM_UTIL dependencies on DUAL

Line 176: From dual

172: l_token_tbl Error_Handler.Token_Tbl_Type;
173: X_EcoStatus number;
174: Cursor CheckEco is
175: Select 'x' dummy
176: From dual
177: Where not exists (
178: Select null
179: From eng_revised_items eri
180: Where eri.change_notice = p_change_notice

Line 186: From dual

182: And eri.status_type not in (6, 5));
183:
184: Cursor CheckStatusEco is
185: Select 'x' dummy
186: From dual
187: Where exists (
188: Select null
189: From eng_revised_items eri
190: Where eri.change_notice = p_change_notice

Line 570: from sys.dual;

566: x_schedule_id NUMBER;
567: BEGIN
568: select ENG_CURRENT_SCHEDULED_DATES_S.nextval
569: into x_schedule_id
570: from sys.dual;
571: insert into ENG_CURRENT_SCHEDULED_DATES (
572: change_notice,
573: organization_id,
574: revised_item_id,

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

1116: AND revision = nvl( p_revised_item_rec.new_revised_item_revision,'NULL')
1117: RETURNING revision_id INTO l_revision_id;
1118:
1119:
1120: SELECT userenv('LANG') INTO l_language_code FROM dual;
1121: update MTL_ITEM_REVISIONS_TL
1122: set
1123: last_update_date = SYSDATE, --who column
1124: last_update_login = l_login_id, --who column

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

1218: p_rev_item_unexp_rec.revised_item_sequence_id
1219: AND revision = nvl( p_revised_item_rec.new_revised_item_revision,'NULL')
1220: RETURNING revision_id INTO l_revision_id;
1221:
1222: SELECT userenv('LANG') INTO l_language_code FROM dual;
1223: update MTL_ITEM_REVISIONS_TL
1224: set
1225: last_update_date = SYSDATE, --who column
1226: last_update_login = l_login_id, --who column

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

1471: RETURNING revision_id INTO l_revision_id;
1472:
1473: /* Item revision description support Bug: 1667419*/
1474:
1475: SELECT userenv('LANG') INTO l_language_code FROM dual;
1476: update MTL_ITEM_REVISIONS_TL
1477: set
1478: last_update_date = SYSDATE, --who column
1479: last_update_login = l_login_id, --who column

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

2701: --
2702: -- Generate a sequence_number for the new revised item
2703: -- Copy only attributes required for creation of revised item context
2704: --
2705: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;
2706: l_revised_item_rec.eco_name := l_old_revised_item_rec.change_notice;
2707: l_rev_item_unexp_rec.organization_id := l_old_revised_item_rec.organization_id;
2708: l_rev_item_unexp_rec.revised_item_id := l_old_revised_item_rec.revised_item_id;
2709: l_revised_item_rec.disposition_type := l_old_revised_item_rec.disposition_type;