DBA Data[Home] [Help]

APPS.GMDRPLAP_WF_PKG dependencies on GMD_ROUTINGS

Line 30: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;

26: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
27: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
28: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
29: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
30: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
31: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
32: /* Mercy Thomas Bug 3173515 End of the changes */
33:
34: /* make sure that process runs with background engine

Line 31: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;

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

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

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