APPS.GMD_ERES_UTILS dependencies on GMD_RECIPES_B

Line 163: FROM gmd_recipes_b

159: --===================================================================== */
160: PROCEDURE get_recipe_no(P_recipe_id IN NUMBER, P_recipe_no OUT NOCOPY VARCHAR2) IS
161: CURSOR Cur_get_recipe IS
162: SELECT recipe_no
163: FROM gmd_recipes_b
164: WHERE recipe_id = P_recipe_id;
165: BEGIN
166: OPEN Cur_get_recipe;
167: FETCH Cur_get_recipe INTO P_recipe_no;

Line 188: FROM gmd_recipes_b

184: --===================================================================== */
185: PROCEDURE get_recipe_version (P_recipe_id IN NUMBER,P_recipe_version OUT NOCOPY NUMBER) IS
186: CURSOR Cur_get_recipe IS
187: SELECT recipe_version
188: FROM gmd_recipes_b
189: WHERE recipe_id = P_recipe_id;
190: BEGIN
191: OPEN Cur_get_recipe;
192: FETCH Cur_get_recipe INTO P_recipe_version;

Line 671: FROM gmd_recipes_b r, fm_form_mst_b f

667: l_rework_status gmd_status.status_code%TYPE;
668:
669: CURSOR Cur_get_formula_details IS
670: SELECT r.owner_organization_id, r.formula_id, r.recipe_no, r.recipe_version
671: FROM gmd_recipes_b r, fm_form_mst_b f
672: WHERE r.recipe_id = p_recipe_id
673: AND r.formula_id = f.formula_id;
674: LocalFormRecord Cur_get_formula_details%ROWTYPE;
675:

Line 686: UPDATE gmd_recipes_b

682: LocalEnableRecord Cur_auto_recipe_enable%ROWTYPE;
683: l_return_status VARCHAR2(1);
684: BEGIN
685: IF p_signature_status = 'SUCCESS' THEN
686: UPDATE gmd_recipes_b
687: SET recipe_status = p_to_status
688: WHERE recipe_id = p_recipe_id;
689:
690: /* If validity rule has to be created based on the recipe approval and recipe generation setup */

Line 718: UPDATE gmd_recipes_b

714: ELSIF p_signature_status = 'PENDING' THEN
715: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
716: ,p_to_status => p_to_status);
717: IF l_pending_status IS NOT NULL THEN
718: UPDATE gmd_recipes_b
719: SET recipe_status = l_pending_status
720: WHERE recipe_id = p_recipe_id;
721: END IF;
722: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN

Line 726: UPDATE gmd_recipes_b

722: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
723: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
724: ,p_to_status => p_to_status);
725: IF l_rework_status IS NOT NULL THEN
726: UPDATE gmd_recipes_b
727: SET recipe_status = l_rework_status
728: WHERE recipe_id = p_recipe_id;
729: END IF;
730: END IF;

Line 1647: FROM gmd_recipes_b

1643: END IF;
1644:
1645: SELECT 'x'
1646: INTO l_text
1647: FROM gmd_recipes_b
1648: WHERE recipe_id = p_recipe_id
1649: FOR UPDATE OF recipe_status nowait;
1650:
1651: IF (l_debug= 'Y') THEN

Line 1656: UPDATE gmd_recipes_b

1652: gmd_debug.put_line('In GMD_ERES_UTILS.update_receip_status : '||
1653: 'About to update recipe with status = '||p_to_status);
1654: END IF;
1655:
1656: UPDATE gmd_recipes_b
1657: SET recipe_status = p_to_status,
1658: last_update_date = sysdate,
1659: last_updated_by = l_user_id
1660: WHERE recipe_id = p_recipe_id;

Line 1743: UPDATE gmd_recipes_b

1739: END IF;
1740:
1741: IF l_esig_reqd THEN
1742: X_return_status := 'P';
1743: UPDATE gmd_recipes_b
1744: SET recipe_status = p_pending_status
1745: WHERE recipe_id = p_recipe_id;
1746: IF p_called_from_form = 'F' THEN
1747: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

Line 1803: 'GMD_RECIPES_B',

1799: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1800: END IF;
1801: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1802: 'TABLE_NAME',
1803: 'GMD_RECIPES_B',
1804: 'RECORD',
1805: 'RECIPE_NO : RECIPE_VERSION = ',
1806: 'KEY',
1807: p_object_name||':'||p_object_version

Line 1857: FROM gmd_recipes_b a, gmd_recipe_validity_rules b

1853: WHERE status_code = pstatus;
1854:
1855: CURSOR Cur_get_recipe_info(vVR_id NUMBER) IS
1856: SELECT a.recipe_no, a.recipe_version, b.recipe_use
1857: FROM gmd_recipes_b a, gmd_recipe_validity_rules b
1858: WHERE a.recipe_id = b.recipe_id
1859: AND b.recipe_validity_rule_id = vVr_id;
1860:
1861: /* Get the recipe use lookup meaning */

Line 1880: l_recipe_no gmd_recipes_b.recipe_no%TYPE;

1876: l_status VARCHAR2(2000);
1877: l_esig_reqd BOOLEAN;
1878: l_erec_reqd BOOLEAN;
1879:
1880: l_recipe_no gmd_recipes_b.recipe_no%TYPE;
1881: l_recipe_version gmd_recipes_b.recipe_version%TYPE;
1882: l_recipe_use_code NUMBER;
1883: l_recipe_use_meaning VARCHAR2(100);
1884:

Line 1881: l_recipe_version gmd_recipes_b.recipe_version%TYPE;

1877: l_esig_reqd BOOLEAN;
1878: l_erec_reqd BOOLEAN;
1879:
1880: l_recipe_no gmd_recipes_b.recipe_no%TYPE;
1881: l_recipe_version gmd_recipes_b.recipe_version%TYPE;
1882: l_recipe_use_code NUMBER;
1883: l_recipe_use_meaning VARCHAR2(100);
1884:
1885: l_user_key_value VARCHAR2(2000) := '';