DBA Data[Home] [Help]

APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_CUSTOMERS

Line 176: INSERT INTO GMD_RECIPE_CUSTOMERS(

172: FND_MSG_PUB.ADD;
173: END IF;
174:
175: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
176: INSERT INTO GMD_RECIPE_CUSTOMERS(
177: recipe_id ,
178: customer_id ,
179: site_id ,
180: org_id ,

Line 685: UPDATE GMD_RECIPE_CUSTOMERS

681:
682: /* Update the recipe customer table */
683: /* only who columns needs to be updated */
684: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
685: UPDATE GMD_RECIPE_CUSTOMERS
686: SET text_code = p_recipe_detail_rec.text_code,
687: last_updated_by = NVL(p_recipe_detail_rec.last_updated_by,
688: gmd_api_grp.user_id),
689: last_update_date = NVL(p_recipe_detail_rec.last_update_date,