APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_RESOURCES

Line 459: FROM AHL_RESOURCES

455: -- Added for bug# 6512803.
456: CURSOR get_res_type_id( c_resource_id In NUMBER)
457: IS
458: SELECT resource_type_id
459: FROM AHL_RESOURCES
460: WHERE resource_id = c_resource_id;
461:
462: l_resource_type_id NUMBER;
463:

Line 900: FROM AHL_RESOURCES

896:
897: CURSOR check_resource_type( c_aso_resource_id NUMBER, c_resource_type_id NUMBER )
898: IS
899: SELECT 'X'
900: FROM AHL_RESOURCES
901: WHERE resource_id = c_aso_resource_id
902: AND resource_type_id = c_resource_type_id;
903:
904: -- Added to fix bug# 6512803.

Line 1105: FROM ahl_resources

1101:
1102: -- Find how bom resources are associated to this cmro resource
1103: SELECT NVL(one_bomres_org, 'Y')
1104: INTO l_dummy
1105: FROM ahl_resources
1106: WHERE resource_id = l_aso_res_id;
1107:
1108: -- Check whether all other cmro resources are of the same bom association type as the first cmro resource
1109: IF l_bom_asso_type IS null THEN

Line 2121: FROM AHL_RT_OPER_RESOURCES RES, AHL_RESOURCES AR

2117: RES.ASSOCIATION_TYPE_CODE,
2118: AR.resource_type_id,
2119: RES.duration,
2120: AR.NAME
2121: FROM AHL_RT_OPER_RESOURCES RES, AHL_RESOURCES AR
2122: WHERE RES.aso_resource_id = AR.resource_id
2123: AND RES.RT_OPER_RESOURCE_ID = C_RT_OPER_RESOURCE_ID;
2124:
2125: cursor get_route_status (p_route_id in number)

Line 2153: l_name ahl_resources.name%TYPE;

2149: -- Added for bug fix# 6512803.
2150: l_resource_type_id NUMBER;
2151: l_max_rt_time_span NUMBER;
2152: l_duration NUMBER;
2153: l_name ahl_resources.name%TYPE;
2154:
2155: BEGIN
2156: -- Initialize API return status to success
2157: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2267: -- default here to avoid query on ahl_resources.

2263: END IF;
2264: END IF;
2265:
2266: ELSIF (p_x_rt_oper_cost_rec.scheduled_type_id = FND_API.G_MISS_NUM) THEN
2267: -- default here to avoid query on ahl_resources.
2268: IF (l_resource_type_id IN (1,2)) THEN
2269: p_x_rt_oper_cost_rec.scheduled_type_id := 1;
2270: ELSE
2271: p_x_rt_oper_cost_rec.scheduled_type_id := 2;

Line 3007: FROM AHL_RESOURCES

3003:
3004: CURSOR check_resource_type2( c_aso_resource_id NUMBER)
3005: IS
3006: SELECT resource_type_id
3007: FROM AHL_RESOURCES
3008: WHERE resource_id = c_aso_resource_id;
3009: BEGIN
3010: x_return_status := FND_API.G_RET_STS_SUCCESS;
3011: OPEN check_resource_type1( p_rt_oper_resource_id);

Line 3185: FROM ahl_resources

3181:
3182: -- MANESING::ER 9014609, 28-Jun-2010, find how bom resources are associated to cmro resource
3183: SELECT NVL(one_bomres_org, 'Y')
3184: INTO l_bom_asso_type
3185: FROM ahl_resources
3186: WHERE resource_id = l_aso_res_id;
3187:
3188: -- MANESING::ER 9014609, 28-Jun-2010
3189: -- Following validation is done only if cmro resources associated have only 1 BOM resource per org