APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UF_HEADERS

Line 1914: CURSOR ahl_uf_headers_csr(p_uc_header_id IN NUMBER) IS

1910: p_inventory_org_id IN NUMBER,
1911: x_forecast_details_tbl OUT NOCOPY forecast_details_tbl_type)
1912: IS
1913:
1914: CURSOR ahl_uf_headers_csr(p_uc_header_id IN NUMBER) IS
1915: SELECT uf_header_id, use_unit_flag
1916: FROM ahl_uf_headers
1917: WHERE unit_config_header_id = p_uc_header_id;
1918:

Line 1916: FROM ahl_uf_headers

1912: IS
1913:
1914: CURSOR ahl_uf_headers_csr(p_uc_header_id IN NUMBER) IS
1915: SELECT uf_header_id, use_unit_flag
1916: FROM ahl_uf_headers
1917: WHERE unit_config_header_id = p_uc_header_id;
1918:
1919: CURSOR ahl_uf_details_csr(p_uf_header_id IN NUMBER) IS
1920: SELECT uom_code, start_date, end_date, usage_per_day

Line 1928: FROM ahl_uf_headers

1924: order by uom_code, start_date;
1925:
1926: CURSOR ahl_pm_uf_headers_csr(p_csi_item_instance_id IN NUMBER) IS
1927: SELECT uf_header_id, use_unit_flag
1928: FROM ahl_uf_headers
1929: WHERE csi_item_instance_id = p_csi_item_instance_id;
1930:
1931: CURSOR ahl_pm_item_uf_csr (p_csi_item_instance_id IN NUMBER) IS
1932: SELECT uom_code, start_date, end_date, usage_per_day

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

1929: WHERE csi_item_instance_id = p_csi_item_instance_id;
1930:
1931: CURSOR ahl_pm_item_uf_csr (p_csi_item_instance_id IN NUMBER) IS
1932: SELECT uom_code, start_date, end_date, usage_per_day
1933: FROM ahl_uf_headers uh, ahl_uf_details ud, csi_item_instances csi
1934: WHERE uh.uf_header_id = ud.uf_header_id
1935: AND csi.instance_id = p_csi_item_instance_id
1936: AND csi.inventory_item_id = uh.inventory_item_id
1937: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)

Line 1978: l_use_unit_flag AHL_UF_HEADERS.USE_UNIT_FLAG%TYPE;

1974: l_flt_uom_code VARCHAR2(3);
1975: l_pc_uom_code VARCHAR2(3);
1976:
1977: l_uf_header_id NUMBER;
1978: l_use_unit_flag AHL_UF_HEADERS.USE_UNIT_FLAG%TYPE;
1979: l_uf_details_tbl AHL_UMP_UF_PVT.uf_details_tbl_type;
1980:
1981: l_index NUMBER := 1;
1982: l_forecast_details_tbl forecast_details_tbl_type;

Line 2095: OPEN ahl_uf_headers_csr (p_uc_header_id);

2091: CLOSE ahl_fleet_uf_header_csr;
2092:
2093: -- JKJain, NR Analysis and Forecasting
2094: l_index :=1;
2095: OPEN ahl_uf_headers_csr (p_uc_header_id);
2096: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;
2097: IF (ahl_uf_headers_csr%FOUND) AND (l_use_unit_flag = 'Y') THEN
2098: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
2099: l_forecast_details_pc_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;

Line 2096: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;

2092:
2093: -- JKJain, NR Analysis and Forecasting
2094: l_index :=1;
2095: OPEN ahl_uf_headers_csr (p_uc_header_id);
2096: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;
2097: IF (ahl_uf_headers_csr%FOUND) AND (l_use_unit_flag = 'Y') THEN
2098: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
2099: l_forecast_details_pc_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;
2100: l_forecast_details_pc_tbl(l_index).start_date := trunc(l_forecast_detail_rec.start_date);

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

2093: -- JKJain, NR Analysis and Forecasting
2094: l_index :=1;
2095: OPEN ahl_uf_headers_csr (p_uc_header_id);
2096: FETCH ahl_uf_headers_csr INTO l_uf_header_id, l_use_unit_flag;
2097: IF (ahl_uf_headers_csr%FOUND) AND (l_use_unit_flag = 'Y') THEN
2098: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
2099: l_forecast_details_pc_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;
2100: l_forecast_details_pc_tbl(l_index).start_date := trunc(l_forecast_detail_rec.start_date);
2101: l_forecast_details_pc_tbl(l_index).end_date := trunc(l_forecast_detail_rec.end_date);

Line 2146: CLOSE ahl_uf_headers_csr;

2142:
2143: END IF; /* count > 0 */
2144:
2145: END IF; -- %found.
2146: CLOSE ahl_uf_headers_csr;
2147: ELSE
2148: IF G_DEBUG = 'Y' THEN
2149: AHL_DEBUG_PUB.debug('AHL PC forecast for ITEM');
2150: END IF;