[Home] [Help]
2390: AND v.visit_id = vt.visit_id;
2391:
2392: CURSOR l_get_rt_resources_csr(c_route_id IN NUMBER) IS
2393: SELECT ASO_RESOURCE_ID
2394: FROM ahl_rt_oper_resources WHERE
2395: ASSOCIATION_TYPE_CODE = G_RT_ASSOC_TYPE
2396: /*LTP CHANGES FOR NONSCHEDULED RESOURCE REQUIREMENTS - sowsubra*/
2397: AND NVL(SCHEDULED_TYPE_ID,1) <> 2
2398: AND OBJECT_ID = c_route_id;
2398: AND OBJECT_ID = c_route_id;
2399:
2400: CURSOR l_get_oper_resources_csr(c_route_id IN NUMBER) IS
2401: SELECT ASO_RESOURCE_ID
2402: FROM ahl_rt_oper_resources WHERE
2403: ASSOCIATION_TYPE_CODE = G_OPER_ASSOC_TYPE
2404: /*LTP CHANGES FOR NONSCHEDULED RESOURCE REQUIREMENTS - sowsubra*/
2405: AND NVL(SCHEDULED_TYPE_ID,1) <> 2
2406: AND OBJECT_ID IN (SELECT OPERATION_ID FROM ahl_route_operations WHERE ROUTE_ID = c_route_id);
2778: TRUNC(NVL(OP1.end_date_active,SYSDATE+1))
2779: );
2780:
2781: CURSOR l_get_rt_rsrc_count(p_route_id IN NUMBER) IS
2782: SELECT COUNT(*) FROM ahl_rt_oper_resources
2783: WHERE OBJECT_ID = p_route_id AND
2784: ASSOCIATION_TYPE_CODE = G_RT_ASSOC_TYPE;
2785:
2786: -- get only operations with latest revision
2809: l_org_id IN NUMBER) IS
2810: SELECT a.aso_resource_id,
2811: a.quantity,
2812: b.bom_resource_id
2813: FROM ahl_rt_oper_resources a,
2814: ahl_resource_mappings b,
2815: bom_department_resources c
2816: WHERE a.aso_resource_id = b. aso_resource_id
2817: AND a.object_id = l_route_id
2828: l_org_id IN NUMBER) IS
2829: SELECT a.aso_resource_id,
2830: a.quantity,
2831: b.bom_resource_id
2832: FROM ahl_rt_oper_resources a,
2833: ahl_resource_mappings b,
2834: bom_department_resources c
2835: WHERE a.object_id = l_operation_id
2836: AND a.ASSOCIATION_TYPE_CODE = 'OPERATION'
3309: ) IS
3310: CURSOR l_aso_rsrc_csr(p_aso_rsrc_id IN NUMBER,
3311: p_object_id IN NUMBER,
3312: p_object_type IN VARCHAR2) IS
3313: SELECT QUANTITY FROM ahl_rt_oper_resources WHERE
3314: ASO_RESOURCE_ID = p_aso_rsrc_id AND
3315: OBJECT_ID = p_object_id AND
3316: ASSOCIATION_TYPE_CODE = p_object_type;
3317:
3995: x_duration OUT NOCOPY NUMBER
3996: ) IS
3997:
3998: CURSOR l_oper_rsrc_time_csr(p_operation_id IN NUMBER) IS
3999: SELECT NVL(MAX(duration), 0) FROM ahl_rt_oper_resources
4000: WHERE OBJECT_ID = p_operation_id AND
4001: ASSOCIATION_TYPE_CODE = G_OPER_ASSOC_TYPE;
4002:
4003: l_rsrc_max NUMBER := 0;
4022: x_duration OUT NOCOPY NUMBER
4023: ) IS
4024:
4025: CURSOR l_rt_rsrc_time_csr(p_route_id IN NUMBER) IS
4026: SELECT NVL(MAX(duration), 0) FROM ahl_rt_oper_resources
4027: WHERE OBJECT_ID = p_route_id AND
4028: ASSOCIATION_TYPE_CODE = G_RT_ASSOC_TYPE;
4029:
4030: l_rsrc_max NUMBER := 0;