APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UF_HEADERS

Line 1693: CURSOR ahl_uf_headers_csr(p_uc_header_id IN NUMBER) IS

1689: p_inventory_org_id IN NUMBER,
1690: x_forecast_details_tbl OUT NOCOPY forecast_details_tbl_type)
1691: IS
1692:
1693: CURSOR ahl_uf_headers_csr(p_uc_header_id IN NUMBER) IS
1694: SELECT uf_header_id, use_unit_flag
1695: FROM ahl_uf_headers
1696: WHERE unit_config_header_id = p_uc_header_id;
1697:

Line 1695: FROM ahl_uf_headers

1691: IS
1692:
1693: CURSOR ahl_uf_headers_csr(p_uc_header_id IN NUMBER) IS
1694: SELECT uf_header_id, use_unit_flag
1695: FROM ahl_uf_headers
1696: WHERE unit_config_header_id = p_uc_header_id;
1697:
1698: CURSOR ahl_uf_details_csr(p_uf_header_id IN NUMBER) IS
1699: SELECT uom_code, start_date, end_date, usage_per_day

Line 1707: FROM ahl_uf_headers

1703: order by uom_code, start_date;
1704:
1705: CURSOR ahl_pm_uf_headers_csr(p_csi_item_instance_id IN NUMBER) IS
1706: SELECT uf_header_id, use_unit_flag
1707: FROM ahl_uf_headers
1708: WHERE csi_item_instance_id = p_csi_item_instance_id;
1709:
1710: CURSOR ahl_pm_item_uf_csr (p_csi_item_instance_id IN NUMBER) IS
1711: SELECT uom_code, start_date, end_date, usage_per_day

Line 1712: FROM ahl_uf_headers uh, ahl_uf_details ud, csi_item_instances csi

1708: WHERE csi_item_instance_id = p_csi_item_instance_id;
1709:
1710: CURSOR ahl_pm_item_uf_csr (p_csi_item_instance_id IN NUMBER) IS
1711: SELECT uom_code, start_date, end_date, usage_per_day
1712: FROM ahl_uf_headers uh, ahl_uf_details ud, csi_item_instances csi
1713: WHERE uh.uf_header_id = ud.uf_header_id
1714: AND csi.instance_id = p_csi_item_instance_id
1715: AND csi.inventory_item_id = uh.inventory_item_id
1716: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)

Line 1720: l_use_unit_flag AHL_UF_HEADERS.USE_UNIT_FLAG%TYPE;

1716: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)
1717: order by uom_code, start_date;
1718:
1719: l_uf_header_id NUMBER;
1720: l_use_unit_flag AHL_UF_HEADERS.USE_UNIT_FLAG%TYPE;
1721: l_uf_details_tbl AHL_UMP_UF_PVT.uf_details_tbl_type;
1722:
1723: l_index NUMBER := 1;
1724: l_forecast_details_tbl forecast_details_tbl_type;

Line 1791: OPEN ahl_uf_headers_csr (p_uc_header_id);

1787: -- If Utlization forecast defined at unit level
1788: IF (p_uc_header_id IS NOT NULL) THEN
1789: --dbms_output.put_line ('uc header not null');
1790: -- check if forecast defined.
1791: OPEN ahl_uf_headers_csr (p_uc_header_id);
1792: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;
1793: IF (ahl_uf_headers_csr%FOUND) AND (l_use_unit_flag = 'Y') THEN
1794: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
1795: l_forecast_details_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;

Line 1792: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;

1788: IF (p_uc_header_id IS NOT NULL) THEN
1789: --dbms_output.put_line ('uc header not null');
1790: -- check if forecast defined.
1791: OPEN ahl_uf_headers_csr (p_uc_header_id);
1792: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;
1793: IF (ahl_uf_headers_csr%FOUND) AND (l_use_unit_flag = 'Y') THEN
1794: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
1795: l_forecast_details_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;
1796: l_forecast_details_tbl(l_index).start_date := trunc(l_forecast_detail_rec.start_date);

Line 1793: IF (ahl_uf_headers_csr%FOUND) AND (l_use_unit_flag = 'Y') THEN

1789: --dbms_output.put_line ('uc header not null');
1790: -- check if forecast defined.
1791: OPEN ahl_uf_headers_csr (p_uc_header_id);
1792: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;
1793: IF (ahl_uf_headers_csr%FOUND) AND (l_use_unit_flag = 'Y') THEN
1794: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
1795: l_forecast_details_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;
1796: l_forecast_details_tbl(l_index).start_date := trunc(l_forecast_detail_rec.start_date);
1797: l_forecast_details_tbl(l_index).end_date := trunc(l_forecast_detail_rec.end_date);

Line 1839: CLOSE ahl_uf_headers_csr;

1835:
1836: END IF; /* count > 0 */
1837:
1838: END IF; -- %found.
1839: CLOSE ahl_uf_headers_csr;
1840: ELSE
1841: IF G_DEBUG = 'Y' THEN
1842: AHL_DEBUG_PUB.debug('AHL PC forecast for ITEM');
1843: END IF;