APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_ORGN_ACTIVITIES

Line 1377: FROM gmd_recipe_orgn_activities

1373: /* This cursor decides whether to insert or update. */
1374: CURSOR recipe_activity_cur(vRecipe_id NUMBER, vRoutingStep_id NUMBER,
1375: vOprn_line_id NUMBER, vOrgn_id NUMBER) IS
1376: SELECT rowid
1377: FROM gmd_recipe_orgn_activities
1378: where recipe_id = NVL(vRecipe_id,-1) AND
1379: RoutingStep_id = NVL(vRoutingStep_id,-1) AND
1380: oprn_line_id = NVL(vOprn_line_id,-1) AND
1381: organization_id = vOrgn_id;

Line 1384: /* gmd_recipe_orgn activities table */

1380: oprn_line_id = NVL(vOprn_line_id,-1) AND
1381: organization_id = vOrgn_id;
1382: BEGIN
1383: /* Updating recipe orgn activity for forst time infact insert a new record in */
1384: /* gmd_recipe_orgn activities table */
1385:
1386: /* Initialization of all status */
1387: x_return_status := FND_API.G_RET_STS_SUCCESS;
1388:

Line 1405: INSERT INTO GMD_RECIPE_ORGN_ACTIVITIES (

1401: CLOSE recipe_activity_cur;
1402:
1403: /* ++++++++++++++++INSERTs+++++++++++++++++++++++++ */
1404: IF (l_dml_type = 'I') THEN
1405: INSERT INTO GMD_RECIPE_ORGN_ACTIVITIES (
1406: RECIPE_ID ,
1407: ROUTINGSTEP_ID ,
1408: OPRN_LINE_ID ,
1409: ACTIVITY_FACTOR ,

Line 1495: UPDATE GMD_RECIPE_ORGN_ACTIVITIES

1491: END IF; /* end of dml type */
1492:
1493: /* +++++++++++++++UPDATE+++++++++++++++++++++++++++ */
1494: IF (l_dml_type = 'U') THEN
1495: UPDATE GMD_RECIPE_ORGN_ACTIVITIES
1496: SET ACTIVITY_FACTOR = p_recipe_detail_rec.activity_factor,
1497: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date,sysdate),
1498: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1499: TEXT_CODE = p_recipe_detail_rec.text_code,