[Home] [Help]
884: SELECT d.resource_code,
885: d.description,
886: d.resource_type,
887: m.meaning resource_type_mean
888: FROM bom_resources d, mfg_lookups m
889: WHERE d.resource_id = l_resource_id
890: AND d.resource_type = m.lookup_code
891: AND m.lookup_type = 'BOM_RESOURCE_TYPE';
892:
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);
2407:
2408: CURSOR l_get_bom_resources_csr(c_aso_resource_id IN NUMBER,
2409: c_org_id IN NUMBER) IS
2410: SELECT BOM_RESOURCE_ID
2411: FROM ahl_resource_mappings WHERE
2412: ASO_RESOURCE_ID = c_aso_resource_id
2466: IF (l_qualified) THEN
2467:
2468: Ahl_Debug_Pub.debug('Get_Task_Resources, aso resource id = ' || l_rt_resource_rec.ASO_RESOURCE_ID);
2469: -- Get bom resource id for the corresponding aso resource
2470: OPEN l_get_bom_resources_csr(l_rt_resource_rec.ASO_RESOURCE_ID,l_org_id);
2471: FETCH l_get_bom_resources_csr INTO l_bom_resource_id;
2472: IF l_get_bom_resources_csr%NOTFOUND THEN
2473: Fnd_Message.Set_Name('AHL','AHL_LTP_NO_BOM_RESRC_ID');
2474: Fnd_Msg_Pub.ADD;
2467:
2468: Ahl_Debug_Pub.debug('Get_Task_Resources, aso resource id = ' || l_rt_resource_rec.ASO_RESOURCE_ID);
2469: -- Get bom resource id for the corresponding aso resource
2470: OPEN l_get_bom_resources_csr(l_rt_resource_rec.ASO_RESOURCE_ID,l_org_id);
2471: FETCH l_get_bom_resources_csr INTO l_bom_resource_id;
2472: IF l_get_bom_resources_csr%NOTFOUND THEN
2473: Fnd_Message.Set_Name('AHL','AHL_LTP_NO_BOM_RESRC_ID');
2474: Fnd_Msg_Pub.ADD;
2475: CLOSE l_get_bom_resources_csr;
2468: Ahl_Debug_Pub.debug('Get_Task_Resources, aso resource id = ' || l_rt_resource_rec.ASO_RESOURCE_ID);
2469: -- Get bom resource id for the corresponding aso resource
2470: OPEN l_get_bom_resources_csr(l_rt_resource_rec.ASO_RESOURCE_ID,l_org_id);
2471: FETCH l_get_bom_resources_csr INTO l_bom_resource_id;
2472: IF l_get_bom_resources_csr%NOTFOUND THEN
2473: Fnd_Message.Set_Name('AHL','AHL_LTP_NO_BOM_RESRC_ID');
2474: Fnd_Msg_Pub.ADD;
2475: CLOSE l_get_bom_resources_csr;
2476: RAISE Fnd_Api.G_EXC_ERROR;
2471: FETCH l_get_bom_resources_csr INTO l_bom_resource_id;
2472: IF l_get_bom_resources_csr%NOTFOUND THEN
2473: Fnd_Message.Set_Name('AHL','AHL_LTP_NO_BOM_RESRC_ID');
2474: Fnd_Msg_Pub.ADD;
2475: CLOSE l_get_bom_resources_csr;
2476: RAISE Fnd_Api.G_EXC_ERROR;
2477: -- RETURN;
2478: END IF;
2479: CLOSE l_get_bom_resources_csr;
2475: CLOSE l_get_bom_resources_csr;
2476: RAISE Fnd_Api.G_EXC_ERROR;
2477: -- RETURN;
2478: END IF;
2479: CLOSE l_get_bom_resources_csr;
2480: --
2481: Ahl_Debug_Pub.debug('ROUTE LEVEL, l_bom_resource_id = ' || l_bom_resource_id);
2482: Ahl_Debug_Pub.debug('ROUTE LEVEL, l_bom_org_id = ' || l_org_id);
2483: --
2511: Ahl_Debug_Pub.debug('Get_Task_Resources, aso resource id oper = ' || l_oper_resource_rec.ASO_RESOURCE_ID);
2512: Ahl_Debug_Pub.debug('inside, l_org_id = ' || l_org_id);
2513:
2514: -- Get bom resource id for the corresponding aso resource
2515: OPEN l_get_bom_resources_csr(l_oper_resource_rec.ASO_RESOURCE_ID,l_org_id);
2516: FETCH l_get_bom_resources_csr INTO l_bom_resource_id;
2517:
2518: Ahl_Debug_Pub.debug('OPERATION LEVEL, bom resource id oper = ' || l_bom_resource_id);
2519:
2512: Ahl_Debug_Pub.debug('inside, l_org_id = ' || l_org_id);
2513:
2514: -- Get bom resource id for the corresponding aso resource
2515: OPEN l_get_bom_resources_csr(l_oper_resource_rec.ASO_RESOURCE_ID,l_org_id);
2516: FETCH l_get_bom_resources_csr INTO l_bom_resource_id;
2517:
2518: Ahl_Debug_Pub.debug('OPERATION LEVEL, bom resource id oper = ' || l_bom_resource_id);
2519:
2520: IF l_get_bom_resources_csr%NOTFOUND THEN
2516: FETCH l_get_bom_resources_csr INTO l_bom_resource_id;
2517:
2518: Ahl_Debug_Pub.debug('OPERATION LEVEL, bom resource id oper = ' || l_bom_resource_id);
2519:
2520: IF l_get_bom_resources_csr%NOTFOUND THEN
2521: Fnd_Message.Set_Name('AHL','AHL_LTP_NO_BOM_RESRC_ID');
2522: Fnd_Msg_Pub.ADD;
2523: CLOSE l_get_bom_resources_csr;
2524: RAISE Fnd_Api.G_EXC_ERROR;
2519:
2520: IF l_get_bom_resources_csr%NOTFOUND THEN
2521: Fnd_Message.Set_Name('AHL','AHL_LTP_NO_BOM_RESRC_ID');
2522: Fnd_Msg_Pub.ADD;
2523: CLOSE l_get_bom_resources_csr;
2524: RAISE Fnd_Api.G_EXC_ERROR;
2525: -- RETURN;
2526: END IF;
2527: CLOSE l_get_bom_resources_csr;
2523: CLOSE l_get_bom_resources_csr;
2524: RAISE Fnd_Api.G_EXC_ERROR;
2525: -- RETURN;
2526: END IF;
2527: CLOSE l_get_bom_resources_csr;
2528: --
2529: Get_Resource_Details(
2530: p_required_capacity => p_required_capacity,
2531: p_aso_resource_id => l_rt_resource_Rec.ASO_RESOURCE_ID,
2563: CURSOR l_get_bom_rsrc_dtls_csr(p_bom_resource_id IN NUMBER,
2564: p_bom_department_id IN NUMBER) IS
2565: SELECT a.RESOURCE_TYPE,a.RESOURCE_CODE,a.DESCRIPTION,
2566: B.CAPACITY_UNITS, M.meaning resource_type_mean
2567: FROM bom_resources A,
2568: bom_department_resources B,
2569: mfg_lookups M
2570: WHERE a.resource_id = B.resource_id
2571: AND B.resource_id = p_bom_resource_id
2684: -- yazhou 17Aug2005 starts
2685: -- bug fix #4559462
2686: CURSOR l_get_bom_rsrc_dtls_csr(p_rsrc_id IN NUMBER) IS
2687: SELECT b.RESOURCE_TYPE, b.RESOURCE_CODE, b.DESCRIPTION, m.meaning
2688: FROM bom_resources b, mfg_lookups m
2689: WHERE b.resource_type = m.lookup_code
2690: AND m.lookup_type = 'BOM_RESOURCE_TYPE'
2691: AND resource_id = p_rsrc_id;
2692: -- yazhou 17Aug2005 ends
4659: --
4660: CURSOR l_get_bom_rsrc_dtls_csr(p_bom_resource_id IN NUMBER,
4661: p_bom_department_id IN NUMBER) IS
4662: SELECT B.CAPACITY_UNITS,a.description
4663: FROM bom_resources A,
4664: bom_department_resources B
4665: WHERE a. resource_id = B.resource_id
4666: AND B.resource_id = p_bom_resource_id
4667: AND B.department_id = p_bom_department_id;
4683: -- l_bom_resource_id NUMBER;
4684: l_capacity_units NUMBER;
4685: -- l_shift_num NUMBER;
4686: l_shift_capacity NUMBER;
4687: l_description bom_resources.description%type;
4688:
4689: -- yazhou 24Aug2005 ends
4690:
4691: BEGIN