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 755: UPDATE gmd_recipe_validity_rules

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

Line 762: UPDATE gmd_recipe_validity_rules

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

Line 770: UPDATE gmd_recipe_validity_rules

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

Line 852: FROM gmd_recipe_validity_rules

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

Line 862: UPDATE gmd_recipe_validity_rules

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

Line 1619: UPDATE gmd_recipe_validity_rules

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

Line 1625: UPDATE gmd_recipe_validity_rules

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

Line 1630: UPDATE gmd_recipe_validity_rules

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

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

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

Line 1902: UPDATE gmd_recipe_validity_rules

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

Line 1979: UPDATE gmd_recipe_validity_rules

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

Line 2015: 'GMD_RECIPE_VALIDITY_RULES',

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