APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UF_DETAILS

Line 1919: CURSOR ahl_uf_details_csr(p_uf_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
1921: FROM ahl_uf_details
1922: WHERE uf_header_id = p_uf_header_id
1923: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)

Line 1921: FROM ahl_uf_details

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
1921: FROM ahl_uf_details
1922: WHERE uf_header_id = p_uf_header_id
1923: AND trunc(nvl(end_date, sysdate)) >= trunc(sysdate)
1924: order by uom_code, start_date;
1925:

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 2017: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP

2013: --dbms_output.put_line('Found uf header and use_unit_flag' || l_uf_header_id);
2014:
2015: -- initialize.
2016: l_index := 1;
2017: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP
2018: l_forecast_details_tbl(l_index).uom_code := l_forecast_detail_rec.uom_code;
2019: l_forecast_details_tbl(l_index).start_date := trunc(l_forecast_detail_rec.start_date);
2020: l_forecast_details_tbl(l_index).end_date := trunc(l_forecast_detail_rec.end_date);
2021: l_forecast_details_tbl(l_index).usage_per_day := l_forecast_detail_rec.usage_per_day;

Line 2098: FOR l_forecast_detail_rec IN ahl_uf_details_csr(l_uf_header_id) LOOP

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);
2102: l_forecast_details_pc_tbl(l_index).usage_per_day := l_forecast_detail_rec.usage_per_day;