DBA Data[Home] [Help]

APPS.GMD_RECIPE_MIGRATION dependencies on GMD_RECIPE_ID_S

Line 276: SELECT gmd_recipe_id_s.NEXTVAL

272: IF ( x_return_status = 'S' )
273: THEN
274:
275: /* Get the recipe id from the sequence */
276: SELECT gmd_recipe_id_s.NEXTVAL
277: INTO l_recipe_id
278: FROM sys.DUAL;
279: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */
280: /* This function return non zero value when the effectivity is locked */

Line 409: SELECT gmd_recipe_id_s.NEXTVAL

405: END IF;
406:
407: /* Get the recipe id from sequence */
408:
409: SELECT gmd_recipe_id_s.NEXTVAL
410: INTO l_recipe_id
411: FROM sys.DUAL;
412: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */
413: /* This function return non zero value when the effectivity is locked */