DBA Data[Home] [Help]

APPS.GR_MIGRATE_TO_12 dependencies on DUAL

Line 925: from sys.dual;

921:
922: --Bug# 5293938 Attached Document Id has to be populated from the sequence.
923: select fnd_attached_documents_s.nextval
924: into l_attached_doc_id
925: from sys.dual;
926:
927: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(
928: X_Rowid => l_rowid,
929: X_attached_document_id => l_attached_doc_id,

Line 1347: FROM SYS.DUAL;

1343:
1344: /* Cursor used to retrieve next formula_id value */
1345: CURSOR c_get_formula_id IS
1346: SELECT gem5_formula_id_s.NEXTVAL
1347: FROM SYS.DUAL;
1348:
1349: /* Cursor used to retrieve next formulaline_id value */
1350: CURSOR c_get_formulaline_id IS
1351: SELECT gem5_formulaline_id_s.NEXTVAL

Line 1352: FROM SYS.DUAL;

1348:
1349: /* Cursor used to retrieve next formulaline_id value */
1350: CURSOR c_get_formulaline_id IS
1351: SELECT gem5_formulaline_id_s.NEXTVAL
1352: FROM SYS.DUAL;
1353:
1354: /* Cursor used to retrieve next recipe_id value */
1355: CURSOR c_get_recipe_id IS
1356: SELECT gmd_recipe_id_s.NEXTVAL

Line 1357: FROM SYS.DUAL;

1353:
1354: /* Cursor used to retrieve next recipe_id value */
1355: CURSOR c_get_recipe_id IS
1356: SELECT gmd_recipe_id_s.NEXTVAL
1357: FROM SYS.DUAL;
1358:
1359: /* Cursor used to retrieve next recipe_vr_id value */
1360: CURSOR c_get_recipe_vr_id IS
1361: SELECT gmd_recipe_validity_id_s.NEXTVAL

Line 1362: FROM SYS.DUAL;

1358:
1359: /* Cursor used to retrieve next recipe_vr_id value */
1360: CURSOR c_get_recipe_vr_id IS
1361: SELECT gmd_recipe_validity_id_s.NEXTVAL
1362: FROM SYS.DUAL;
1363:
1364: /* ------------------- EXCEPTIONS -------------------- */
1365: PROC_CALL_ERROR EXCEPTION;
1366: ORGN_NOT_MIGRATED EXCEPTION;