eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_UMP_UF_PVT dependencies on AHL_UF_DETAILS

Line 1257: AHL_UF_DETAILS_PKG.delete_row(p_x_uf_details_tbl(i).uf_detail_id);

1253: default_unchanged_uf_details(p_x_uf_details_tbl => p_x_uf_details_tbl);
1254: --save details now
1255: FOR i IN p_x_uf_details_tbl.FIRST..p_x_uf_details_tbl.LAST LOOP
1256: IF(p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_DELETE) THEN
1257: AHL_UF_DETAILS_PKG.delete_row(p_x_uf_details_tbl(i).uf_detail_id);
1258: END IF;
1259: END LOOP;
1260:
1261: FOR i IN p_x_uf_details_tbl.FIRST..p_x_uf_details_tbl.LAST LOOP

Line 1271: AHL_UF_DETAILS_PKG.update_row(

1267: p_x_uf_details_tbl(i).last_updated_by := fnd_global.user_id;
1268: p_x_uf_details_tbl(i).last_update_date := SYSDATE;
1269: p_x_uf_details_tbl(i).last_update_login := fnd_global.user_id;
1270:
1271: AHL_UF_DETAILS_PKG.update_row(
1272: x_uf_detail_id => p_x_uf_details_tbl(i).uf_detail_id,
1273: x_object_version_number => p_x_uf_details_tbl(i).object_version_number,
1274: x_last_updated_by => p_x_uf_details_tbl(i).last_updated_by,
1275: x_last_update_date => p_x_uf_details_tbl(i).last_update_date,

Line 1314: AHL_UF_DETAILS_PKG.insert_row(

1310: p_x_uf_details_tbl(i).last_update_login := fnd_global.user_id;
1311:
1312: p_x_uf_details_tbl(i).uf_header_id := p_uf_header_rec.uf_header_id;
1313:
1314: AHL_UF_DETAILS_PKG.insert_row(
1315: x_uf_detail_id => p_x_uf_details_tbl(i).uf_detail_id,
1316: x_object_version_number => p_x_uf_details_tbl(i).object_version_number,
1317: x_created_by => p_x_uf_details_tbl(i).created_by,
1318: x_creation_date => p_x_uf_details_tbl(i).creation_date,

Line 1382: FROM ahl_uf_details

1378: ) IS
1379:
1380: CURSOR uf_details_csr (p_uf_detail_id IN NUMBER) IS
1381: SELECT object_version_number, uf_header_id,uom_code,start_date,end_date,usage_per_day
1382: FROM ahl_uf_details
1383: WHERE uf_detail_id = p_uf_detail_id;
1384:
1385: l_object_version_number NUMBER;
1386: l_uf_header_id NUMBER;

Line 1387: l_uom_code ahl_uf_details.uom_code%TYPE;

1383: WHERE uf_detail_id = p_uf_detail_id;
1384:
1385: l_object_version_number NUMBER;
1386: l_uf_header_id NUMBER;
1387: l_uom_code ahl_uf_details.uom_code%TYPE;
1388: l_start_date DATE;
1389: l_end_date DATE;
1390: l_usage_per_day NUMBER;
1391:

Line 1646: FROM ahl_uf_details

1642: ) IS
1643:
1644: CURSOR uf_sorted_details_csr (p_uf_header_id IN NUMBER) IS
1645: SELECT object_version_number, uf_detail_id, uf_header_id,uom_code,start_date,end_date,usage_per_day
1646: FROM ahl_uf_details
1647: WHERE uf_header_id = p_uf_header_id
1648: AND (end_date IS NULL OR TRUNC(end_date) >= TRUNC(SYSDATE))
1649: ORDER BY uom_code,start_date;
1650:

Line 1723: FROM ahl_uf_details

1719: CURSOR uf_details_csr(p_uf_detail_id IN NUMBER, p_object_version_number IN NUMBER) IS
1720: SELECT uf_header_id,end_date,attribute_category, attribute1,attribute2, attribute3, attribute4,
1721: attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11,
1722: attribute12, attribute13, attribute14, attribute15
1723: FROM ahl_uf_details
1724: WHERE object_version_number= p_object_version_number
1725: AND uf_detail_id = p_uf_detail_id;
1726:
1727: l_uf_details_rec AHL_UMP_UF_PVT.uf_details_rec_type;

Line 1922: FROM ahl_uf_details WHERE uf_header_id = p_uf_header_id;

1918: ) IS
1919:
1920: CURSOR uf_details_csr (p_uf_header_id IN NUMBER) IS
1921: SELECT 'x'
1922: FROM ahl_uf_details WHERE uf_header_id = p_uf_header_id;
1923:
1924: l_exist VARCHAR2(1);
1925:
1926:

Line 2006: FROM ahl_uf_details a, ahl_uf_headers b

2002: CONNECT BY pc_node_id = PRIOR parent_node_id;
2003: --
2004: CURSOR ahl_uf_uom_nodes_csr (c_pc_id IN NUMBER) IS
2005: SELECT distinct a.uom_code
2006: FROM ahl_uf_details a, ahl_uf_headers b
2007: WHERE a.uf_header_id = b.uf_header_id
2008: AND b.pc_node_id = c_pc_id;
2009: --
2010: CURSOR ahl_uf_details_csr (c_pc_id IN NUMBER, p_uom_code IN VARCHAR2) IS

Line 2010: CURSOR ahl_uf_details_csr (c_pc_id IN NUMBER, p_uom_code IN VARCHAR2) IS

2006: FROM ahl_uf_details a, ahl_uf_headers b
2007: WHERE a.uf_header_id = b.uf_header_id
2008: AND b.pc_node_id = c_pc_id;
2009: --
2010: CURSOR ahl_uf_details_csr (c_pc_id IN NUMBER, p_uom_code IN VARCHAR2) IS
2011: SELECT a.UF_DETAIL_ID,
2012: a.OBJECT_VERSION_NUMBER,
2013: a.LAST_UPDATE_DATE ,
2014: a.LAST_UPDATED_BY ,

Line 2039: FROM ahl_uf_details a, ahl_uf_headers b

2035: a.ATTRIBUTE12 ,
2036: a.ATTRIBUTE13 ,
2037: a.ATTRIBUTE14 ,
2038: a.ATTRIBUTE15
2039: FROM ahl_uf_details a, ahl_uf_headers b
2040: WHERE a.uom_code = p_uom_code
2041: AND b.pc_node_id = c_pc_id
2042: AND a.uf_header_id = b.uf_header_id;
2043: --

Line 2044: CURSOR ahl_uf_details_date_csr (p_pc_id IN NUMBER, p_uom_code IN VARCHAR2,p_onward_end_date IN DATE) IS

2040: WHERE a.uom_code = p_uom_code
2041: AND b.pc_node_id = c_pc_id
2042: AND a.uf_header_id = b.uf_header_id;
2043: --
2044: CURSOR ahl_uf_details_date_csr (p_pc_id IN NUMBER, p_uom_code IN VARCHAR2,p_onward_end_date IN DATE) IS
2045: SELECT a.UF_DETAIL_ID,
2046: a.OBJECT_VERSION_NUMBER,
2047: a.LAST_UPDATE_DATE ,
2048: a.LAST_UPDATED_BY ,

Line 2073: FROM ahl_uf_details a, ahl_uf_headers b

2069: a.ATTRIBUTE12 ,
2070: a.ATTRIBUTE13 ,
2071: a.ATTRIBUTE14 ,
2072: a.ATTRIBUTE15
2073: FROM ahl_uf_details a, ahl_uf_headers b
2074: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2075: AND a.uf_header_id = b.uf_header_id
2076: AND a.uom_code = p_uom_code
2077: AND b.pc_node_id = p_pc_id;

Line 2082: FROM ahl_uf_details a, ahl_uf_headers b

2078:
2079: -- added to fix bug# 6749351
2080: CURSOR ahl_uf_uom_item_csr (p_inventory_item_id IN NUMBER) IS
2081: SELECT distinct a.uom_code
2082: FROM ahl_uf_details a, ahl_uf_headers b
2083: WHERE a.uf_header_id = b.uf_header_id
2084: AND b.inventory_item_id = p_inventory_item_id;
2085:
2086: -- get uf details for item for all dates.

Line 2117: FROM ahl_uf_details a, ahl_uf_headers b

2113: a.ATTRIBUTE12 ,
2114: a.ATTRIBUTE13 ,
2115: a.ATTRIBUTE14 ,
2116: a.ATTRIBUTE15
2117: FROM ahl_uf_details a, ahl_uf_headers b
2118: WHERE a.uf_header_id = b.uf_header_id
2119: AND a.uom_code = p_uom_code
2120: AND b.inventory_item_id = p_inventory_item_id;
2121:

Line 2154: FROM ahl_uf_details a, ahl_uf_headers b

2150: a.ATTRIBUTE12 ,
2151: a.ATTRIBUTE13 ,
2152: a.ATTRIBUTE14 ,
2153: a.ATTRIBUTE15
2154: FROM ahl_uf_details a, ahl_uf_headers b
2155: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2156: AND a.uf_header_id = b.uf_header_id
2157: AND a.uom_code = p_uom_code
2158: AND b.inventory_item_id = p_inventory_item_id;

Line 2163: FROM ahl_uf_details a, ahl_uf_headers b

2159:
2160: -- added to fix bug# 6749351
2161: CURSOR ahl_uf_uom_unit_csr (p_unit_config_id IN NUMBER) IS
2162: SELECT distinct a.uom_code
2163: FROM ahl_uf_details a, ahl_uf_headers b
2164: WHERE a.uf_header_id = b.uf_header_id
2165: AND b.unit_config_header_id = p_unit_config_id;
2166:
2167: -- get uf details for item for all dates.

Line 2198: FROM ahl_uf_details a, ahl_uf_headers b

2194: a.ATTRIBUTE12 ,
2195: a.ATTRIBUTE13 ,
2196: a.ATTRIBUTE14 ,
2197: a.ATTRIBUTE15
2198: FROM ahl_uf_details a, ahl_uf_headers b
2199: WHERE a.uf_header_id = b.uf_header_id
2200: AND a.uom_code = p_uom_code
2201: AND b.unit_config_header_id = p_unit_config_id;
2202:

Line 2235: FROM ahl_uf_details a, ahl_uf_headers b

2231: a.ATTRIBUTE12 ,
2232: a.ATTRIBUTE13 ,
2233: a.ATTRIBUTE14 ,
2234: a.ATTRIBUTE15
2235: FROM ahl_uf_details a, ahl_uf_headers b
2236: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2237: AND a.uf_header_id = b.uf_header_id
2238: AND a.uom_code = p_uom_code
2239: AND b.unit_config_header_id = p_unit_config_id;

Line 2243: l_temp_details_rec ahl_uf_details_csr%ROWTYPE;

2239: AND b.unit_config_header_id = p_unit_config_id;
2240: --
2241: l_UF_details_tbl AHL_UMP_UF_PVT.uf_details_tbl_type;
2242: l_UF_details_rec AHL_UMP_UF_PVT.uf_details_rec_type;
2243: l_temp_details_rec ahl_uf_details_csr%ROWTYPE;
2244: l_unit_config_header_id NUMBER DEFAULT p_unit_config_header_id;
2245: l_inventory_item_id NUMBER DEFAULT p_inventory_item_id;
2246: l_pc_node_id NUMBER DEFAULT p_PC_node_id;
2247: l_pc_id NUMBER;

Line 2248: l_uom_code AHL_UF_DETAILS.UOM_CODE%TYPE;

2244: l_unit_config_header_id NUMBER DEFAULT p_unit_config_header_id;
2245: l_inventory_item_id NUMBER DEFAULT p_inventory_item_id;
2246: l_pc_node_id NUMBER DEFAULT p_PC_node_id;
2247: l_pc_id NUMBER;
2248: l_uom_code AHL_UF_DETAILS.UOM_CODE%TYPE;
2249: l_msg_count NUMBER;
2250: l_duplicate VARCHAR2(1);
2251: l_junk VARCHAR2(1);
2252: j NUMBER;

Line 2564: OPEN ahl_uf_details_csr(l_pc_id, l_uom_code);

2560:
2561: -- If no duplicates are found for given uom, add to table all dates
2562: IF (l_duplicate = 'N') THEN
2563: IF(p_onward_end_date IS NULL) THEN
2564: OPEN ahl_uf_details_csr(l_pc_id, l_uom_code);
2565: LOOP
2566: FETCH ahl_uf_details_csr INTO l_temp_details_rec;
2567: EXIT WHEN ahl_uf_details_csr%NOTFOUND;
2568:

Line 2566: FETCH ahl_uf_details_csr INTO l_temp_details_rec;

2562: IF (l_duplicate = 'N') THEN
2563: IF(p_onward_end_date IS NULL) THEN
2564: OPEN ahl_uf_details_csr(l_pc_id, l_uom_code);
2565: LOOP
2566: FETCH ahl_uf_details_csr INTO l_temp_details_rec;
2567: EXIT WHEN ahl_uf_details_csr%NOTFOUND;
2568:
2569: l_UF_details_rec.UF_DETAIL_ID := l_temp_details_rec.UF_DETAIL_ID;
2570: l_UF_details_rec.OBJECT_VERSION_NUMBER := l_temp_details_rec.OBJECT_VERSION_NUMBER ;

Line 2567: EXIT WHEN ahl_uf_details_csr%NOTFOUND;

2563: IF(p_onward_end_date IS NULL) THEN
2564: OPEN ahl_uf_details_csr(l_pc_id, l_uom_code);
2565: LOOP
2566: FETCH ahl_uf_details_csr INTO l_temp_details_rec;
2567: EXIT WHEN ahl_uf_details_csr%NOTFOUND;
2568:
2569: l_UF_details_rec.UF_DETAIL_ID := l_temp_details_rec.UF_DETAIL_ID;
2570: l_UF_details_rec.OBJECT_VERSION_NUMBER := l_temp_details_rec.OBJECT_VERSION_NUMBER ;
2571: l_UF_details_rec.LAST_UPDATE_DATE := l_temp_details_rec.LAST_UPDATE_DATE ;

Line 2600: CLOSE ahl_uf_details_csr;

2596: l_UF_details_rec.ATTRIBUTE15 := l_temp_details_rec.ATTRIBUTE15 ;
2597: l_UF_details_tbl(j) := l_UF_details_rec;
2598: j := j+1;
2599: END LOOP;
2600: CLOSE ahl_uf_details_csr;
2601: ELSE
2602: OPEN ahl_uf_details_date_csr(l_pc_id, l_uom_code, p_onward_end_date);
2603: LOOP
2604: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;

Line 2602: OPEN ahl_uf_details_date_csr(l_pc_id, l_uom_code, p_onward_end_date);

2598: j := j+1;
2599: END LOOP;
2600: CLOSE ahl_uf_details_csr;
2601: ELSE
2602: OPEN ahl_uf_details_date_csr(l_pc_id, l_uom_code, p_onward_end_date);
2603: LOOP
2604: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;
2605: EXIT WHEN ahl_uf_details_date_csr%NOTFOUND;
2606:

Line 2604: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;

2600: CLOSE ahl_uf_details_csr;
2601: ELSE
2602: OPEN ahl_uf_details_date_csr(l_pc_id, l_uom_code, p_onward_end_date);
2603: LOOP
2604: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;
2605: EXIT WHEN ahl_uf_details_date_csr%NOTFOUND;
2606:
2607: l_UF_details_rec.UF_DETAIL_ID := l_temp_details_rec.UF_DETAIL_ID;
2608: l_UF_details_rec.OBJECT_VERSION_NUMBER := l_temp_details_rec.OBJECT_VERSION_NUMBER ;

Line 2605: EXIT WHEN ahl_uf_details_date_csr%NOTFOUND;

2601: ELSE
2602: OPEN ahl_uf_details_date_csr(l_pc_id, l_uom_code, p_onward_end_date);
2603: LOOP
2604: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;
2605: EXIT WHEN ahl_uf_details_date_csr%NOTFOUND;
2606:
2607: l_UF_details_rec.UF_DETAIL_ID := l_temp_details_rec.UF_DETAIL_ID;
2608: l_UF_details_rec.OBJECT_VERSION_NUMBER := l_temp_details_rec.OBJECT_VERSION_NUMBER ;
2609: l_UF_details_rec.LAST_UPDATE_DATE := l_temp_details_rec.LAST_UPDATE_DATE ;

Line 2638: CLOSE ahl_uf_details_date_csr;

2634: l_UF_details_rec.ATTRIBUTE15 := l_temp_details_rec.ATTRIBUTE15 ;
2635: l_UF_details_tbl(j) := l_UF_details_rec;
2636: j := j+1;
2637: END LOOP;
2638: CLOSE ahl_uf_details_date_csr;
2639: END IF;
2640: END IF;
2641:
2642: END LOOP;

Line 2663: CURSOR ahl_uf_details_csr (p_csi_item_instance_id IN NUMBER) IS

2659: x_return_status OUT NOCOPY VARCHAR2)
2660: IS
2661:
2662: --
2663: CURSOR ahl_uf_details_csr (p_csi_item_instance_id IN NUMBER) IS
2664: SELECT a.UF_DETAIL_ID,
2665: a.OBJECT_VERSION_NUMBER,
2666: a.LAST_UPDATE_DATE ,
2667: a.LAST_UPDATED_BY ,

Line 2692: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c

2688: a.ATTRIBUTE12 ,
2689: a.ATTRIBUTE13 ,
2690: a.ATTRIBUTE14 ,
2691: a.ATTRIBUTE15
2692: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
2693: WHERE a.uf_header_id = b.uf_header_id
2694: AND b.inventory_item_id = c.inventory_item_id
2695: AND c.instance_id = p_csi_item_instance_id;
2696:

Line 2697: CURSOR ahl_uf_details_date_csr (p_csi_item_instance_id IN NUMBER, p_onward_end_date IN DATE) IS

2693: WHERE a.uf_header_id = b.uf_header_id
2694: AND b.inventory_item_id = c.inventory_item_id
2695: AND c.instance_id = p_csi_item_instance_id;
2696:
2697: CURSOR ahl_uf_details_date_csr (p_csi_item_instance_id IN NUMBER, p_onward_end_date IN DATE) IS
2698: SELECT a.UF_DETAIL_ID,
2699: a.OBJECT_VERSION_NUMBER,
2700: a.LAST_UPDATE_DATE ,
2701: a.LAST_UPDATED_BY ,

Line 2726: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c

2722: a.ATTRIBUTE12 ,
2723: a.ATTRIBUTE13 ,
2724: a.ATTRIBUTE14 ,
2725: a.ATTRIBUTE15
2726: FROM ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
2727: WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
2728: AND a.uf_header_id = b.uf_header_id
2729: AND b.inventory_item_id = c.inventory_item_id
2730: AND c.instance_id = p_csi_item_instance_id;

Line 2735: l_temp_details_rec ahl_uf_details_csr%ROWTYPE;

2731:
2732:
2733: l_UF_details_tbl AHL_UMP_UF_PVT.uf_details_tbl_type;
2734: l_UF_details_rec AHL_UMP_UF_PVT.uf_details_rec_type;
2735: l_temp_details_rec ahl_uf_details_csr%ROWTYPE;
2736: j NUMBER;
2737:
2738:
2739: BEGIN

Line 2750: OPEN ahl_uf_details_csr(p_csi_item_instance_id);

2746: -- Initialize API return status to success
2747: x_return_status := FND_API.G_RET_STS_SUCCESS;
2748: j := 0;
2749: IF(p_onward_end_date IS NULL) THEN
2750: OPEN ahl_uf_details_csr(p_csi_item_instance_id);
2751: LOOP
2752: FETCH ahl_uf_details_csr INTO l_temp_details_rec;
2753: EXIT WHEN ahl_uf_details_csr%NOTFOUND;
2754:

Line 2752: FETCH ahl_uf_details_csr INTO l_temp_details_rec;

2748: j := 0;
2749: IF(p_onward_end_date IS NULL) THEN
2750: OPEN ahl_uf_details_csr(p_csi_item_instance_id);
2751: LOOP
2752: FETCH ahl_uf_details_csr INTO l_temp_details_rec;
2753: EXIT WHEN ahl_uf_details_csr%NOTFOUND;
2754:
2755: l_UF_details_rec.UF_DETAIL_ID := l_temp_details_rec.UF_DETAIL_ID;
2756: l_UF_details_rec.OBJECT_VERSION_NUMBER := l_temp_details_rec.OBJECT_VERSION_NUMBER ;

Line 2753: EXIT WHEN ahl_uf_details_csr%NOTFOUND;

2749: IF(p_onward_end_date IS NULL) THEN
2750: OPEN ahl_uf_details_csr(p_csi_item_instance_id);
2751: LOOP
2752: FETCH ahl_uf_details_csr INTO l_temp_details_rec;
2753: EXIT WHEN ahl_uf_details_csr%NOTFOUND;
2754:
2755: l_UF_details_rec.UF_DETAIL_ID := l_temp_details_rec.UF_DETAIL_ID;
2756: l_UF_details_rec.OBJECT_VERSION_NUMBER := l_temp_details_rec.OBJECT_VERSION_NUMBER ;
2757: l_UF_details_rec.LAST_UPDATE_DATE := l_temp_details_rec.LAST_UPDATE_DATE ;

Line 2786: CLOSE ahl_uf_details_csr;

2782: l_UF_details_rec.ATTRIBUTE15 := l_temp_details_rec.ATTRIBUTE15 ;
2783: l_UF_details_tbl(j) := l_UF_details_rec;
2784: j := j+1;
2785: END LOOP;
2786: CLOSE ahl_uf_details_csr;
2787: ELSE
2788: OPEN ahl_uf_details_date_csr(p_csi_item_instance_id, p_onward_end_date);
2789: LOOP
2790: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;

Line 2788: OPEN ahl_uf_details_date_csr(p_csi_item_instance_id, p_onward_end_date);

2784: j := j+1;
2785: END LOOP;
2786: CLOSE ahl_uf_details_csr;
2787: ELSE
2788: OPEN ahl_uf_details_date_csr(p_csi_item_instance_id, p_onward_end_date);
2789: LOOP
2790: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;
2791: EXIT WHEN ahl_uf_details_date_csr%NOTFOUND;
2792:

Line 2790: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;

2786: CLOSE ahl_uf_details_csr;
2787: ELSE
2788: OPEN ahl_uf_details_date_csr(p_csi_item_instance_id, p_onward_end_date);
2789: LOOP
2790: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;
2791: EXIT WHEN ahl_uf_details_date_csr%NOTFOUND;
2792:
2793: l_UF_details_rec.UF_DETAIL_ID := l_temp_details_rec.UF_DETAIL_ID;
2794: l_UF_details_rec.OBJECT_VERSION_NUMBER := l_temp_details_rec.OBJECT_VERSION_NUMBER ;

Line 2791: EXIT WHEN ahl_uf_details_date_csr%NOTFOUND;

2787: ELSE
2788: OPEN ahl_uf_details_date_csr(p_csi_item_instance_id, p_onward_end_date);
2789: LOOP
2790: FETCH ahl_uf_details_date_csr INTO l_temp_details_rec;
2791: EXIT WHEN ahl_uf_details_date_csr%NOTFOUND;
2792:
2793: l_UF_details_rec.UF_DETAIL_ID := l_temp_details_rec.UF_DETAIL_ID;
2794: l_UF_details_rec.OBJECT_VERSION_NUMBER := l_temp_details_rec.OBJECT_VERSION_NUMBER ;
2795: l_UF_details_rec.LAST_UPDATE_DATE := l_temp_details_rec.LAST_UPDATE_DATE ;

Line 2824: CLOSE ahl_uf_details_date_csr;

2820: l_UF_details_rec.ATTRIBUTE15 := l_temp_details_rec.ATTRIBUTE15 ;
2821: l_UF_details_tbl(j) := l_UF_details_rec;
2822: j := j+1;
2823: END LOOP;
2824: CLOSE ahl_uf_details_date_csr;
2825: END IF;
2826:
2827: x_UF_details_tbl := l_UF_details_tbl;
2828: