APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 591: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS

587: FROM csi_item_instances
588: WHERE instance_id = p_csi_item_instance_id;
589:
590: -- To validate unit.
591: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS
592: SELECT name, csi_item_instance_id, master_config_id, unit_config_status_code
593: FROM ahl_unit_config_headers
594: WHERE unit_config_header_id = p_uc_header_id;
595:

Line 593: FROM ahl_unit_config_headers

589:
590: -- To validate unit.
591: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS
592: SELECT name, csi_item_instance_id, master_config_id, unit_config_status_code
593: FROM ahl_unit_config_headers
594: WHERE unit_config_header_id = p_uc_header_id;
595:
596: -- To get unit config id.
597: CURSOR ahl_unit_config_header_csr (p_item_instance_id IN NUMBER) IS

Line 599: FROM ahl_unit_config_headers

595:
596: -- To get unit config id.
597: CURSOR ahl_unit_config_header_csr (p_item_instance_id IN NUMBER) IS
598: SELECT name, master_config_id, unit_config_status_code
599: FROM ahl_unit_config_headers
600: WHERE csi_item_instance_id = p_item_instance_id
601: AND parent_uc_header_id IS NULL;
602:
603: -- get mr_route and route_id for a mr_header.

Line 634: l_name ahl_unit_config_headers.name%TYPE;

630:
631: l_debug_module VARCHAR2(400) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Mat_Forecast_Stream';
632:
633: l_csi_item_instance_id NUMBER;
634: l_name ahl_unit_config_headers.name%TYPE;
635: l_instance_number csi_item_instances.instance_number%TYPE;
636: l_active_end_date DATE;
637:
638: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;

Line 725: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);

721: END IF; -- p_item_instance_id
722:
723: IF (p_unit_config_hdr_id IS NOT NULL) THEN
724: -- Validate unit config id.
725: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);
726: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,
727: l_config_status_code ;
728: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
729: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');

Line 726: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,

722:
723: IF (p_unit_config_hdr_id IS NOT NULL) THEN
724: -- Validate unit config id.
725: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);
726: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,
727: l_config_status_code ;
728: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
729: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
730: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_hdr_id);

Line 728: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN

724: -- Validate unit config id.
725: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);
726: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,
727: l_config_status_code ;
728: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
729: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
730: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_hdr_id);
731: FND_MSG_PUB.ADD;
732: errbuf := FND_MSG_PUB.GET;

Line 740: CLOSE ahl_unit_config_headers_csr;

736: IF (l_config_status_code = 'DRAFT') THEN
737: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');
738: FND_MESSAGE.Set_Token('NAME',l_name);
739: FND_MSG_PUB.ADD;
740: CLOSE ahl_unit_config_headers_csr;
741:
742: errbuf := FND_MSG_PUB.GET;
743: retcode := 2;
744: END IF;