APPS.GMD_ROUTINGS_PUB dependencies on GMD_OPERATIONS

Line 58: l_oprn_no gmd_operations.oprn_no%TYPE;

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

Line 59: l_oprn_vers gmd_operations.oprn_vers%TYPE;

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

Line 84: From gmd_operations_b

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