APPS.GMD_ROUTINGS_PUB dependencies on GMD_OPERATIONS

Line 60: l_oprn_no gmd_operations.oprn_no%TYPE;

56: k NUMBER := 1;
57: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
58: l_routing_id NUMBER;
59: l_owner_id NUMBER;
60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;
62: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
63: l_return_from_routing_hdr VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
64: l_return_from_routing_step VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 61: l_oprn_vers gmd_operations.oprn_vers%TYPE;

57: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
58: l_routing_id NUMBER;
59: l_owner_id NUMBER;
60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;
62: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
63: l_return_from_routing_hdr VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
64: l_return_from_routing_step VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
65: l_routing_qty gmd_routings.routing_qty%TYPE := 0;

Line 86: From gmd_operations_b

82:
83: /* gets the operation no and version associated to the routing detail/Step */
84: Cursor Get_oprn_details(vOprn_id fm_rout_dtl.oprn_id%TYPE) IS
85: Select oprn_no, oprn_vers
86: From gmd_operations_b
87: Where oprn_id = vOprn_id;
88:
89: /* get routing id sequence */
90: CURSOR Get_routing_id_seq IS