eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_ERES_UTILS dependencies on GMD_RECIPE_VALIDITY_RULES

Line 757: UPDATE gmd_recipe_validity_rules

753: l_pending_status gmd_status.status_code%TYPE;
754: l_rework_status gmd_status.status_code%TYPE;
755: BEGIN
756: IF p_signature_status = 'SUCCESS' THEN
757: UPDATE gmd_recipe_validity_rules
758: SET validity_rule_status = p_to_status
759: WHERE recipe_validity_rule_id = p_validity_rule_id;
760: ELSIF p_signature_status = 'PENDING' THEN
761: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

Line 764: UPDATE gmd_recipe_validity_rules

760: ELSIF p_signature_status = 'PENDING' THEN
761: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
762: ,p_to_status => p_to_status);
763: IF l_pending_status IS NOT NULL THEN
764: UPDATE gmd_recipe_validity_rules
765: SET validity_rule_status = l_pending_status
766: WHERE recipe_validity_rule_id = p_validity_rule_id;
767: END IF;
768: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN

Line 772: UPDATE gmd_recipe_validity_rules

768: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
769: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
770: ,p_to_status => p_to_status);
771: IF l_rework_status IS NOT NULL THEN
772: UPDATE gmd_recipe_validity_rules
773: SET validity_rule_status = l_rework_status
774: WHERE recipe_validity_rule_id = p_validity_rule_id;
775: END IF;
776: END IF;

Line 854: FROM gmd_recipe_validity_rules

850: p_to_status IN VARCHAR2)
851: RETURN BOOLEAN IS
852: CURSOR Cur_get_validity IS
853: SELECT recipe_validity_rule_id
854: FROM gmd_recipe_validity_rules
855: WHERE recipe_id = p_recipe_id
856: AND validity_rule_status < p_to_status;
857: l_recipe_validity_rule_id NUMBER;
858: l_status BOOLEAN;

Line 864: UPDATE gmd_recipe_validity_rules

860: Savepoint check_vr_required;
861: OPEN Cur_get_validity;
862: FETCH Cur_get_validity INTO l_recipe_validity_rule_id;
863: WHILE Cur_get_validity%FOUND LOOP
864: UPDATE gmd_recipe_validity_rules
865: SET validity_rule_status = p_to_status
866: WHERE recipe_validity_rule_id = l_recipe_validity_rule_id;
867: GMA_STANDARD.psig_required (p_event => 'oracle.apps.gmd.validity.sts'
868: ,p_event_key => l_recipe_validity_rule_id

Line 1621: UPDATE gmd_recipe_validity_rules

1617: ELSE
1618: /* Based on the recipe status condition - update the Vr status */
1619: IF l_status_type = '800' THEN
1620: -- Change status to ON-HOLD for less than ON-HOLD
1621: UPDATE gmd_recipe_validity_rules
1622: SET validity_rule_status = p_to_status
1623: WHERE recipe_id = p_recipe_id
1624: AND (to_number(validity_rule_status) < to_number('800') OR
1625: to_number(validity_rule_status) between 900 and 999);

Line 1627: UPDATE gmd_recipe_validity_rules

1623: WHERE recipe_id = p_recipe_id
1624: AND (to_number(validity_rule_status) < to_number('800') OR
1625: to_number(validity_rule_status) between 900 and 999);
1626: ELSIF l_status_type = '900' THEN
1627: UPDATE gmd_recipe_validity_rules
1628: SET validity_rule_status = p_to_status
1629: WHERE recipe_id = p_recipe_id
1630: AND to_number(validity_rule_status) < to_number('800') ;
1631: ELSIF l_status_type = '1000' THEN

Line 1632: UPDATE gmd_recipe_validity_rules

1628: SET validity_rule_status = p_to_status
1629: WHERE recipe_id = p_recipe_id
1630: AND to_number(validity_rule_status) < to_number('800') ;
1631: ELSIF l_status_type = '1000' THEN
1632: UPDATE gmd_recipe_validity_rules
1633: SET validity_rule_status = p_to_status
1634: WHERE recipe_id = p_recipe_id
1635: AND to_number(validity_rule_status) < to_number('1000') ;
1636: END IF;

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 1900: FROM gmd_recipe_validity_rules

1896: l_object_type := FND_MESSAGE.GET;
1897:
1898: SELECT 'x'
1899: INTO l_text
1900: FROM gmd_recipe_validity_rules
1901: WHERE recipe_validity_rule_id = P_validity_rule_id
1902: FOR UPDATE OF validity_rule_status nowait;
1903:
1904: UPDATE gmd_recipe_validity_rules

Line 1904: UPDATE gmd_recipe_validity_rules

1900: FROM gmd_recipe_validity_rules
1901: WHERE recipe_validity_rule_id = P_validity_rule_id
1902: FOR UPDATE OF validity_rule_status nowait;
1903:
1904: UPDATE gmd_recipe_validity_rules
1905: SET validity_rule_status = p_to_status,
1906: last_update_date = sysdate,
1907: last_updated_by = l_user_id
1908: WHERE recipe_validity_rule_id = P_validity_rule_id;

Line 1981: UPDATE gmd_recipe_validity_rules

1977: ,p_parameter_name7 =>'PSIG_TRANSACTION_AUDIT_ID'
1978: ,p_parameter_value7=>-1);
1979: IF l_esig_reqd THEN
1980: X_return_status := 'P';
1981: UPDATE gmd_recipe_validity_rules
1982: SET validity_rule_status = p_pending_status
1983: WHERE recipe_validity_rule_id = P_validity_rule_id;
1984:
1985: IF p_called_from_form = 'F' THEN

Line 2017: 'GMD_RECIPE_VALIDITY_RULES',

2013: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2014: END IF;
2015: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
2016: 'TABLE_NAME',
2017: 'GMD_RECIPE_VALIDITY_RULES',
2018: 'RECORD',
2019: 'RECIPE_VALIDITY_RULE_ID = ',
2020: 'KEY',
2021: P_validity_rule_id