APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_ORGN_ACTIVITIES

Line 1387: FROM gmd_recipe_orgn_activities

1383: /* This cursor decides whether to insert or update. */
1384: CURSOR recipe_activity_cur(vRecipe_id NUMBER, vRoutingStep_id NUMBER,
1385: vOprn_line_id NUMBER, vOrgn_id NUMBER) IS
1386: SELECT rowid
1387: FROM gmd_recipe_orgn_activities
1388: where recipe_id = NVL(vRecipe_id,-1) AND
1389: RoutingStep_id = NVL(vRoutingStep_id,-1) AND
1390: oprn_line_id = NVL(vOprn_line_id,-1) AND
1391: organization_id = vOrgn_id;

Line 1394: /* gmd_recipe_orgn activities table */

1390: oprn_line_id = NVL(vOprn_line_id,-1) AND
1391: organization_id = vOrgn_id;
1392: BEGIN
1393: /* Updating recipe orgn activity for forst time infact insert a new record in */
1394: /* gmd_recipe_orgn activities table */
1395:
1396: /* Initialization of all status */
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398:

Line 1415: INSERT INTO GMD_RECIPE_ORGN_ACTIVITIES (

1411: CLOSE recipe_activity_cur;
1412:
1413: /* ++++++++++++++++INSERTs+++++++++++++++++++++++++ */
1414: IF (l_dml_type = 'I') THEN
1415: INSERT INTO GMD_RECIPE_ORGN_ACTIVITIES (
1416: RECIPE_ID ,
1417: ROUTINGSTEP_ID ,
1418: OPRN_LINE_ID ,
1419: ACTIVITY_FACTOR ,

Line 1505: UPDATE GMD_RECIPE_ORGN_ACTIVITIES

1501: END IF; /* end of dml type */
1502:
1503: /* +++++++++++++++UPDATE+++++++++++++++++++++++++++ */
1504: IF (l_dml_type = 'U') THEN
1505: UPDATE GMD_RECIPE_ORGN_ACTIVITIES
1506: SET ACTIVITY_FACTOR = p_recipe_detail_rec.activity_factor,
1507: LAST_UPDATE_DATE = NVL(p_recipe_detail_rec.last_update_date,sysdate),
1508: LAST_UPDATE_LOGIN = NVL(p_recipe_detail_rec.last_update_login, gmd_api_grp.login_id),
1509: TEXT_CODE = p_recipe_detail_rec.text_code,