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 669: FROM gmd_recipes_b r, fm_form_mst_b f

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

Line 684: UPDATE gmd_recipes_b

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

Line 716: UPDATE gmd_recipes_b

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

Line 724: UPDATE gmd_recipes_b

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

Line 1645: FROM gmd_recipes_b

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

Line 1654: UPDATE gmd_recipes_b

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

Line 1741: UPDATE gmd_recipes_b

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

Line 1801: 'GMD_RECIPES_B',

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

Line 1855: FROM gmd_recipes_b a, gmd_recipe_validity_rules b

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

Line 1878: l_recipe_no gmd_recipes_b.recipe_no%TYPE;

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

Line 1879: l_recipe_version gmd_recipes_b.recipe_version%TYPE;

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