APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 611: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS

607: FROM csi_item_instances
608: WHERE instance_id = p_csi_item_instance_id;
609:
610: -- To validate unit.
611: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS
612: SELECT name, csi_item_instance_id, master_config_id, unit_config_status_code
613: FROM ahl_unit_config_headers
614: WHERE unit_config_header_id = p_uc_header_id;
615:

Line 613: FROM ahl_unit_config_headers

609:
610: -- To validate unit.
611: CURSOR ahl_unit_config_headers_csr (p_uc_header_id IN NUMBER) IS
612: SELECT name, csi_item_instance_id, master_config_id, unit_config_status_code
613: FROM ahl_unit_config_headers
614: WHERE unit_config_header_id = p_uc_header_id;
615:
616: -- To get unit config id.
617: CURSOR ahl_unit_config_header_csr (p_item_instance_id IN NUMBER) IS

Line 619: FROM ahl_unit_config_headers

615:
616: -- To get unit config id.
617: CURSOR ahl_unit_config_header_csr (p_item_instance_id IN NUMBER) IS
618: SELECT name, master_config_id, unit_config_status_code
619: FROM ahl_unit_config_headers
620: WHERE csi_item_instance_id = p_item_instance_id
621: AND parent_uc_header_id IS NULL;
622:
623: -- get mr_route and route_id for a mr_header.

Line 657: l_name ahl_unit_config_headers.name%TYPE;

653:
654: l_debug_module VARCHAR2(400) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Mat_Forecast_Stream';
655:
656: l_csi_item_instance_id NUMBER;
657: l_name ahl_unit_config_headers.name%TYPE;
658: l_instance_number csi_item_instances.instance_number%TYPE;
659: l_active_end_date DATE;
660:
661: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;

Line 748: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);

744: END IF; -- p_item_instance_id
745:
746: IF (p_unit_config_hdr_id IS NOT NULL) THEN
747: -- Validate unit config id.
748: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);
749: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,
750: l_config_status_code ;
751: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
752: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');

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

745:
746: IF (p_unit_config_hdr_id IS NOT NULL) THEN
747: -- Validate unit config id.
748: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);
749: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,
750: l_config_status_code ;
751: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
752: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
753: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_hdr_id);

Line 751: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN

747: -- Validate unit config id.
748: OPEN ahl_unit_config_headers_csr (p_unit_config_hdr_id);
749: FETCH ahl_unit_config_headers_csr INTO l_name, l_csi_item_instance_id, l_master_config_id,
750: l_config_status_code ;
751: IF (ahl_unit_config_headers_csr%NOTFOUND) THEN
752: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_NOTFOUND');
753: FND_MESSAGE.Set_Token('UNIT_ID',p_unit_config_hdr_id);
754: FND_MSG_PUB.ADD;
755: errbuf := FND_MSG_PUB.GET;

Line 763: CLOSE ahl_unit_config_headers_csr;

759: IF (l_config_status_code = 'DRAFT') THEN
760: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_STATUS_INVALID');
761: FND_MESSAGE.Set_Token('NAME',l_name);
762: FND_MSG_PUB.ADD;
763: CLOSE ahl_unit_config_headers_csr;
764:
765: errbuf := FND_MSG_PUB.GET;
766: retcode := 2;
767: END IF;