APPS.GMD_RECIPE_HEADER_PVT dependencies on GMD_RECIPE_ID_S

Line 229: SELECT gmd_recipe_id_s.nextval INTO l_recipe_id

225: /* Sequence generator creator creates a */
226: /* recipe id */
227: /* ===================================== */
228: IF (p_recipe_header_rec.recipe_id IS NULL) THEN
229: SELECT gmd_recipe_id_s.nextval INTO l_recipe_id
230: FROM sys.dual;
231: ELSE
232: l_recipe_id := p_recipe_header_rec.recipe_id;
233: END IF;

Line 807: SELECT gmd_recipe_id_s.nextval

803: RAISE copy_recipe_err;
804: ELSE
805: IF p_recipe_header_rec.recipe_id IS NULL THEN
806: -- Generate Recipe Id from sequence
807: SELECT gmd_recipe_id_s.nextval
808: INTO l_recipe_header_rec.recipe_id
809: FROM sys.dual;
810: ELSE -- Recipe id has been provided
811: -- Chcek if Recipe id is not a negative number