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.

APPS.AHL_UTIL_UC_PKG dependencies on AHL_UNIT_CONFIG_HEADERS

Line 1351: FROM ahl_unit_config_headers uc, csi_item_instances csi, ahl_mc_relationships mc

1347: CURSOR chk_top_node_csr(c_relationship_id IN NUMBER,
1348: c_inventory_item_id IN NUMBER,
1349: c_inventory_org_id IN NUMBER) IS
1350: SELECT uc.csi_item_instance_id, uc.unit_config_header_id, uc.parent_uc_header_id, uc.unit_config_status_code
1351: FROM ahl_unit_config_headers uc, csi_item_instances csi, ahl_mc_relationships mc
1352: WHERE uc.csi_item_instance_id = csi.instance_id
1353: AND uc.master_config_id = mc.mc_header_id
1354: AND mc.relationship_id = c_relationship_id
1355: AND TRUNC(SYSDATE) < TRUNC(NVL(uc.active_end_date, SYSDATE+1))

Line 1363: FROM ahl_unit_config_headers uc

1359: --
1360: -- Get UC header info
1361: CURSOR get_uc_header_info_csr(p_csi_item_instance_id IN NUMBER) IS
1362: SELECT uc.unit_config_header_id, uc.unit_config_status_code
1363: FROM ahl_unit_config_headers uc
1364: WHERE csi_item_instance_id in
1365: ( SELECT object_id
1366: FROM csi_ii_relationships
1367: START WITH subject_id = p_csi_item_instance_id

Line 1383: l_unit_config_header_id ahl_unit_config_headers.unit_config_header_id%TYPE;

1379: l_api_version CONSTANT NUMBER := 1.0;
1380: l_api_name CONSTANT VARCHAR2(30) := 'Invalidate_Instance';
1381:
1382: l_instance_tbl Instance_Tbl_Type := p_instance_tbl;
1383: l_unit_config_header_id ahl_unit_config_headers.unit_config_header_id%TYPE;
1384: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1385: l_unitname ahl_unit_config_headers.name%TYPE;
1386:
1387: l_chk_top_node_csr chk_top_node_csr%ROWTYPE;

Line 1384: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;

1380: l_api_name CONSTANT VARCHAR2(30) := 'Invalidate_Instance';
1381:
1382: l_instance_tbl Instance_Tbl_Type := p_instance_tbl;
1383: l_unit_config_header_id ahl_unit_config_headers.unit_config_header_id%TYPE;
1384: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1385: l_unitname ahl_unit_config_headers.name%TYPE;
1386:
1387: l_chk_top_node_csr chk_top_node_csr%ROWTYPE;
1388: l_check_item_group_csr check_item_group_csr%ROWTYPE;

Line 1385: l_unitname ahl_unit_config_headers.name%TYPE;

1381:
1382: l_instance_tbl Instance_Tbl_Type := p_instance_tbl;
1383: l_unit_config_header_id ahl_unit_config_headers.unit_config_header_id%TYPE;
1384: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1385: l_unitname ahl_unit_config_headers.name%TYPE;
1386:
1387: l_chk_top_node_csr chk_top_node_csr%ROWTYPE;
1388: l_check_item_group_csr check_item_group_csr%ROWTYPE;
1389: l_return_status varchar2(1);

Line 1438: update ahl_unit_config_headers

1434: FETCH chk_top_node_csr INTO l_chk_top_node_csr;
1435: IF (chk_top_node_csr%FOUND) THEN
1436:
1437: -- updating active_end_date and incrementing object version number
1438: update ahl_unit_config_headers
1439: set active_end_date = sysdate,
1440: object_version_number=object_version_number+1
1441: where unit_config_header_id = l_chk_top_node_csr.unit_config_header_id;
1442:

Line 1482: update ahl_unit_config_headers

1478:
1479: --update status and object_version_number
1480: IF ( l_unit_config_status_code = 'APPROVAL_PENDING' ) THEN
1481: --modify UC status to APPROVAL_REJECTED
1482: update ahl_unit_config_headers
1483: set unit_config_status_code = 'APPROVAL_REJECTED',
1484: object_version_number=object_version_number+1
1485: where unit_config_header_id = l_unit_config_header_id;
1486:

Line 1489: update ahl_unit_config_headers

1485: where unit_config_header_id = l_unit_config_header_id;
1486:
1487: ELSIF ( l_unit_config_status_code = 'COMPLETE' ) THEN
1488: --modify UC status to INCOMPLETE
1489: update ahl_unit_config_headers
1490: set unit_config_status_code = 'INCOMPLETE',
1491: object_version_number=object_version_number+1
1492: where unit_config_header_id = l_unit_config_header_id;
1493:

Line 1646: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,

1642: FL.MEANING,
1643: FLA.MEANING,
1644: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1645: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1646: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1647: FND_LOOKUP_VALUES_VL FL, FND_LOOKUP_VALUES_VL FLA,
1648: CSI_ITEM_INSTANCES CSI
1649: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1650: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND

Line 1665: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

1661: WHERE LOOKUP_TYPE = 'AHL_CONFIG_STATUS' AND
1662: LOOKUP_CODE = G_STATUS_EXPIRED;
1663:
1664: l_root_uc_header_id NUMBER;
1665: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

Line 1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

1664: l_root_uc_header_id NUMBER;
1665: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1672: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;

Line 1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

1666: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1672: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1673: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1674: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

Line 1673: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

1669: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1671: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1672: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1673: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1674: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1675: l_return_value VARCHAR2(100) := null;
1676: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status';
1677:

Line 1707: FROM ahl_unit_config_headers

1703: BEGIN
1704:
1705: SELECT unit_config_header_id
1706: INTO l_root_uc_header_id
1707: FROM ahl_unit_config_headers
1708: WHERE parent_uc_header_id IS NULL
1709: START WITH unit_config_header_id = p_uc_header_id
1710: -- Commented out by jaramana on August 23, 2006 to show the status of Expired units correctly
1711: -- AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 1732: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1728: l_uc_status,
1729: l_uc_active_status,
1730: l_uc_end_date,
1731: l_uc_inst_end_date
1732: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1733: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1734: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1735: AND UC.csi_item_instance_id = CSI.instance_id
1736: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1761: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1757: l_root_status,
1758: l_root_active_status,
1759: l_root_end_date,
1760: l_root_inst_end_date
1761: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1762: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1763: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1764: AND UC.csi_item_instance_id = CSI.instance_id
1765: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1843: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,

1839: ROOT_UC.UNIT_CONFIG_STATUS_CODE,
1840: FL.meaning,
1841: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1842: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1843: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1844: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL
1845: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1846: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1847: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND

Line 1853: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

1849: FL.LOOKUP_TYPE = 'AHL_CONFIG_STATUS';
1850: */
1851:
1852: l_root_uc_header_id NUMBER;
1853: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1854: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1855: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

Line 1855: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

1851:
1852: l_root_uc_header_id NUMBER;
1853: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1854: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1855: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1858: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1859: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

Line 1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

1853: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1854: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1855: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1858: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1859: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1860: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1861: l_return_value VARCHAR2(100) := null;

Line 1859: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

1855: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1856: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1857: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1858: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1859: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1860: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1861: l_return_value VARCHAR2(100) := null;
1862: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status_code';
1863:

Line 1892: FROM ahl_unit_config_headers

1888: BEGIN
1889:
1890: SELECT unit_config_header_id
1891: INTO l_root_uc_header_id
1892: FROM ahl_unit_config_headers
1893: WHERE parent_uc_header_id IS NULL
1894: START WITH unit_config_header_id = p_uc_header_id
1895: -- Commented out by jaramana on August 23, 2006 to show the status of Expired units correctly
1896: -- AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 1915: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1911: INTO l_uc_status_code,
1912: l_uc_status,
1913: l_uc_end_date,
1914: l_uc_inst_end_date
1915: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1916: CSI_ITEM_INSTANCES CSI
1917: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1918: AND UC.csi_item_instance_id = CSI.instance_id
1919: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1939: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1935: INTO l_root_status_code,
1936: l_root_status,
1937: l_root_end_date,
1938: l_root_inst_end_date
1939: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1940: CSI_ITEM_INSTANCES CSI
1941: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1942: AND UC.csi_item_instance_id = CSI.instance_id
1943: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1992: FROM ahl_unit_config_headers

1988: ) IS
1989: l_version_no NUMBER;
1990: CURSOR get_uc_header IS
1991: SELECT *
1992: FROM ahl_unit_config_headers
1993: WHERE unit_config_header_id = p_uc_header_id;
1994: --AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1995: --For expiration operation, when copying to history, the record has already been expired.
1996: l_uc_header_rec get_uc_header%ROWTYPE;

Line 2004: -- Insert into the exactly same record into ahl_unit_config_headers_h

2000: SELECT nvl(max(version_no), 0) INTO l_version_no
2001: FROM ahl_uc_headers_h
2002: WHERE unit_config_header_id = p_uc_header_id;
2003:
2004: -- Insert into the exactly same record into ahl_unit_config_headers_h
2005: OPEN get_uc_header;
2006: FETCH get_uc_header INTO l_uc_header_rec;
2007: IF get_uc_header%NOTFOUND THEN
2008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2102: FROM ahl_unit_config_headers

2098: csi_item_instance_id,
2099: unit_config_status_code,
2100: active_uc_status_code,
2101: object_version_number
2102: FROM ahl_unit_config_headers
2103: WHERE parent_uc_header_id IS NULL
2104: START WITH unit_config_header_id = c_uc_header_id
2105: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2106: CONNECT BY unit_config_header_id = PRIOR parent_uc_header_id

Line 2272: FROM ahl_unit_config_headers

2268: CURSOR get_parent_uc IS
2269: SELECT object_id
2270: FROM csi_ii_relationships
2271: WHERE object_id IN (SELECT csi_item_instance_id
2272: FROM ahl_unit_config_headers
2273: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2274: START WITH subject_id = p_instance_id
2275: AND relationship_type_code = 'COMPONENT-OF'
2276: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2285: FROM ahl_unit_config_headers

2281: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2282:
2283: CURSOR get_uc_header_id(c_instance_id NUMBER) IS
2284: SELECT unit_config_header_id
2285: FROM ahl_unit_config_headers
2286: WHERE csi_item_instance_id = c_instance_id
2287: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2288:
2289: BEGIN

Line 2321: AHL_UNIT_CONFIG_HEADERS uch

2317: CURSOR get_top_rel_id (csi_id IN NUMBER)
2318: IS
2319: SELECT rel.relationship_id
2320: FROM AHL_MC_RELATIONSHIPS rel,
2321: AHL_UNIT_CONFIG_HEADERS uch
2322: WHERE rel.mc_header_id = uch.master_config_id
2323: AND rel.parent_relationship_id IS NULL
2324: AND uch.csi_item_instance_id = csi_id;
2325: --

Line 2362: FROM ahl_unit_config_headers

2358: CURSOR get_uc_instance_id IS
2359: SELECT object_id
2360: FROM csi_ii_relationships
2361: WHERE object_id IN (SELECT csi_item_instance_id
2362: FROM ahl_unit_config_headers
2363: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2364: START WITH subject_id = p_instance_id
2365: AND relationship_type_code = 'COMPONENT-OF'
2366: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2375: FROM ahl_unit_config_headers

2371: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2372:
2373: CURSOR get_uc_header_name(c_instance_id NUMBER) IS
2374: SELECT name
2375: FROM ahl_unit_config_headers
2376: WHERE csi_item_instance_id = c_instance_id
2377: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2378:
2379: BEGIN

Line 2408: FROM ahl_unit_config_headers

2404: CURSOR get_uc_instance_id IS
2405: SELECT object_id
2406: FROM csi_ii_relationships
2407: WHERE object_id IN (SELECT csi_item_instance_id
2408: FROM ahl_unit_config_headers
2409: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2410: START WITH subject_id = p_instance_id
2411: AND relationship_type_code = 'COMPONENT-OF'
2412: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2421: FROM ahl_unit_config_headers

2417: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2418:
2419: CURSOR get_uc_header_id(c_instance_id NUMBER) IS
2420: SELECT unit_config_header_id
2421: FROM ahl_unit_config_headers
2422: WHERE csi_item_instance_id = c_instance_id
2423: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2424:
2425: BEGIN

Line 2454: FROM ahl_unit_config_headers

2450: CURSOR get_uc_instance_id IS
2451: SELECT object_id
2452: FROM csi_ii_relationships
2453: WHERE object_id IN (SELECT csi_item_instance_id
2454: FROM ahl_unit_config_headers
2455: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2456: START WITH subject_id = p_instance_id
2457: AND relationship_type_code = 'COMPONENT-OF'
2458: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2467: FROM ahl_unit_config_headers

2463: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2464:
2465: CURSOR get_uc_header_name(c_instance_id NUMBER) IS
2466: SELECT name
2467: FROM ahl_unit_config_headers
2468: WHERE csi_item_instance_id = c_instance_id
2469: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2470:
2471: BEGIN

Line 2503: FROM ahl_unit_config_headers

2499: CURSOR get_uc_instance_id IS
2500: SELECT object_id
2501: FROM csi_ii_relationships
2502: WHERE object_id IN (SELECT csi_item_instance_id
2503: FROM ahl_unit_config_headers
2504: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2505: START WITH subject_id = p_instance_id
2506: AND relationship_type_code = 'COMPONENT-OF'
2507: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2516: FROM ahl_unit_config_headers

2512: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2513:
2514: CURSOR get_uc_header_id(c_instance_id NUMBER) IS
2515: SELECT unit_config_header_id
2516: FROM ahl_unit_config_headers
2517: WHERE csi_item_instance_id = c_instance_id
2518: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2519:
2520: BEGIN

Line 2666: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI,

2662: c_inventory_item_id NUMBER,
2663: c_inventory_org_id NUMBER) IS
2664: SELECT UC.name,
2665: UC.unit_config_header_id
2666: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI,
2667: AHL_MC_RELATIONSHIPS MC
2668: WHERE UC.csi_item_instance_id = CSI.instance_id AND
2669: UC.master_config_id = MC.mc_header_id AND
2670: UC.parent_uc_header_id IS NULL AND

Line 2683: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI

2679: -- Get UC header info
2680: CURSOR c_get_uc_header_info_csr(p_csi_item_instance_id NUMBER) IS
2681: SELECT UC.name,
2682: UC.unit_config_header_id
2683: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI
2684: WHERE UC.csi_item_instance_id IN
2685: (SELECT object_id
2686: FROM CSI_II_RELATIONSHIPS
2687: START WITH

Line 2709: l_unitname ahl_unit_config_headers.name%TYPE;

2705: l_api_name CONSTANT VARCHAR2(30) := 'Check_Invalidate_Instance';
2706: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2707:
2708: l_instance_tbl Instance_Tbl_Type2 := p_instance_tbl;
2709: l_unitname ahl_unit_config_headers.name%TYPE;
2710: l_unitid ahl_unit_config_headers.unit_config_header_id%TYPE;
2711:
2712: l_check_item_group_rec c_check_item_group_csr%ROWTYPE;
2713: l_valid_UC_lst VARCHAR2(2000) := NULL;

Line 2710: l_unitid ahl_unit_config_headers.unit_config_header_id%TYPE;

2706: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2707:
2708: l_instance_tbl Instance_Tbl_Type2 := p_instance_tbl;
2709: l_unitname ahl_unit_config_headers.name%TYPE;
2710: l_unitid ahl_unit_config_headers.unit_config_header_id%TYPE;
2711:
2712: l_check_item_group_rec c_check_item_group_csr%ROWTYPE;
2713: l_valid_UC_lst VARCHAR2(2000) := NULL;
2714:

Line 2889: FROM ahl_unit_config_headers

2885: x_matches_flag OUT NOCOPY VARCHAR2) IS
2886:
2887: CURSOR get_uc_header_id_csr IS
2888: SELECT unit_config_header_id, master_config_id
2889: FROM ahl_unit_config_headers
2890: WHERE csi_item_instance_id = p_instance_id
2891: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2892:
2893: CURSOR get_root_mc_ig_csr (c_mc_header_id IN NUMBER) IS