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.GMDRPGAP_WF_PKG dependencies on GMD_ROUTINGS

Line 28: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;

24: /* Krishna Prasad , Modified added orgn_id for WF Convergence */
25: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
26: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
27: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
28: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
29: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
30: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
31: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
32: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;

Line 31: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;

27: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
28: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
29: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
30: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
31: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
32: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
33: /* Mercy Thomas Bug 3173515 End of the changes */
34:
35: /* make sure that process runs with background engine

Line 32: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;

28: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
29: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
30: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
31: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
32: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
33: /* Mercy Thomas Bug 3173515 End of the changes */
34:
35: /* make sure that process runs with background engine
36: to prevent SAVEPOINT/ROLLBACK error (see Workflow FAQ)

Line 102: FROM GMD_RECIPES A, GMD_ROUTINGS B, FM_FORM_MST C

98:
99: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
100: SELECT A.RECIPE_DESCRIPTION, A.OWNER_ID, A.CREATION_ORGANIZATION_ID, C.FORMULA_NO, C.FORMULA_VERS, B.ROUTING_NO, B.ROUTING_VERS
101: INTO l_recipe_description, l_owner_id, l_creation_orgn_id, l_formula_no, l_formula_vers, l_routing_no, l_routing_vers
102: FROM GMD_RECIPES A, GMD_ROUTINGS B, FM_FORM_MST C
103: WHERE A.RECIPE_ID = P_RECIPE_ID
104: AND A.ROUTING_ID = B.ROUTING_ID (+)
105: AND A.FORMULA_ID = C.FORMULA_ID;
106: