DBA Data[Home] [Help]

APPS.GR_MIGRATE_TO_12 dependencies on DUAL

Line 902: from sys.dual;

898:
899: --Bug# 5293938 Attached Document Id has to be populated from the sequence.
900: select fnd_attached_documents_s.nextval
901: into l_attached_doc_id
902: from sys.dual;
903:
904: FND_ATTACHED_DOCUMENTS_PKG.Insert_Row(
905: X_Rowid => l_rowid,
906: X_attached_document_id => l_attached_doc_id,

Line 1323: FROM SYS.DUAL;

1319:
1320: /* Cursor used to retrieve next formula_id value */
1321: CURSOR c_get_formula_id IS
1322: SELECT gem5_formula_id_s.NEXTVAL
1323: FROM SYS.DUAL;
1324:
1325: /* Cursor used to retrieve next formulaline_id value */
1326: CURSOR c_get_formulaline_id IS
1327: SELECT gem5_formulaline_id_s.NEXTVAL

Line 1328: FROM SYS.DUAL;

1324:
1325: /* Cursor used to retrieve next formulaline_id value */
1326: CURSOR c_get_formulaline_id IS
1327: SELECT gem5_formulaline_id_s.NEXTVAL
1328: FROM SYS.DUAL;
1329:
1330: /* Cursor used to retrieve next recipe_id value */
1331: CURSOR c_get_recipe_id IS
1332: SELECT gmd_recipe_id_s.NEXTVAL

Line 1333: FROM SYS.DUAL;

1329:
1330: /* Cursor used to retrieve next recipe_id value */
1331: CURSOR c_get_recipe_id IS
1332: SELECT gmd_recipe_id_s.NEXTVAL
1333: FROM SYS.DUAL;
1334:
1335: /* Cursor used to retrieve next recipe_vr_id value */
1336: CURSOR c_get_recipe_vr_id IS
1337: SELECT gmd_recipe_validity_id_s.NEXTVAL

Line 1338: FROM SYS.DUAL;

1334:
1335: /* Cursor used to retrieve next recipe_vr_id value */
1336: CURSOR c_get_recipe_vr_id IS
1337: SELECT gmd_recipe_validity_id_s.NEXTVAL
1338: FROM SYS.DUAL;
1339:
1340: /* ------------------- EXCEPTIONS -------------------- */
1341: PROC_CALL_ERROR EXCEPTION;
1342: ORGN_NOT_MIGRATED EXCEPTION;