APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 1589: FROM gmd_recipe_orgn_resources

1585: vOprn_line_id NUMBER,
1586: vResources VARCHAR2,
1587: vOrgn_id NUMBER) IS
1588: SELECT rowid
1589: FROM gmd_recipe_orgn_resources
1590: where recipe_id = NVL(vRecipe_id,-1) AND
1591: RoutingStep_id = NVL(vRoutingStep_id,-1) AND
1592: oprn_line_id = NVL(vOprn_line_id,-1) AND
1593: resources = vResources AND

Line 1598: /* gmd_recipe_orgn_resources table */

1594: organization_id = vOrgn_id;
1595:
1596: BEGIN
1597: /* Updating recipe orgn resources for forst time infact insert a new record in */
1598: /* gmd_recipe_orgn_resources table */
1599:
1600: /* Initialization of all status */
1601: x_return_status := FND_API.G_RET_STS_SUCCESS;
1602:

Line 1619: INSERT INTO GMD_RECIPE_ORGN_RESOURCES (

1615: CLOSE recipe_resources_cur;
1616:
1617: /* ++++++++++++++++INSERTs+++++++++++++++++++++++++ */
1618: IF (l_dml_type = 'I') THEN
1619: INSERT INTO GMD_RECIPE_ORGN_RESOURCES (
1620: RECIPE_ID ,
1621: ORGANIZATION_ID ,
1622: ROUTINGSTEP_ID ,
1623: OPRN_LINE_ID ,

Line 1733: UPDATE GMD_RECIPE_ORGN_RESOURCES

1729: END IF; /* end of dml type */
1730:
1731: /* +++++++++++++++UPDATE+++++++++++++++++++++++++++ */
1732: IF (l_dml_type = 'U') THEN
1733: UPDATE GMD_RECIPE_ORGN_RESOURCES
1734: SET MIN_CAPACITY = p_recipe_detail_rec.min_capacity,
1735: MAX_CAPACITY = p_recipe_detail_rec.max_capacity,
1736: PROCESS_PARAMETER_5 = p_recipe_detail_rec.PROCESS_PARAMETER_5,
1737: PROCESS_PARAMETER_4 = p_recipe_detail_rec.PROCESS_PARAMETER_4,