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 1346: FROM ahl_unit_config_headers uc, csi_item_instances csi, ahl_mc_relationships mc

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

Line 1358: FROM ahl_unit_config_headers uc

1354: --
1355: -- Get UC header info
1356: CURSOR get_uc_header_info_csr(p_csi_item_instance_id IN NUMBER) IS
1357: SELECT uc.unit_config_header_id, uc.unit_config_status_code
1358: FROM ahl_unit_config_headers uc
1359: WHERE csi_item_instance_id in
1360: ( SELECT object_id
1361: FROM csi_ii_relationships
1362: START WITH subject_id = p_csi_item_instance_id

Line 1378: l_unit_config_header_id ahl_unit_config_headers.unit_config_header_id%TYPE;

1374: l_api_version CONSTANT NUMBER := 1.0;
1375: l_api_name CONSTANT VARCHAR2(30) := 'Invalidate_Instance';
1376:
1377: l_instance_tbl Instance_Tbl_Type := p_instance_tbl;
1378: l_unit_config_header_id ahl_unit_config_headers.unit_config_header_id%TYPE;
1379: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1380: l_unitname ahl_unit_config_headers.name%TYPE;
1381:
1382: l_chk_top_node_csr chk_top_node_csr%ROWTYPE;

Line 1379: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;

1375: l_api_name CONSTANT VARCHAR2(30) := 'Invalidate_Instance';
1376:
1377: l_instance_tbl Instance_Tbl_Type := p_instance_tbl;
1378: l_unit_config_header_id ahl_unit_config_headers.unit_config_header_id%TYPE;
1379: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1380: l_unitname ahl_unit_config_headers.name%TYPE;
1381:
1382: l_chk_top_node_csr chk_top_node_csr%ROWTYPE;
1383: l_check_item_group_csr check_item_group_csr%ROWTYPE;

Line 1380: l_unitname ahl_unit_config_headers.name%TYPE;

1376:
1377: l_instance_tbl Instance_Tbl_Type := p_instance_tbl;
1378: l_unit_config_header_id ahl_unit_config_headers.unit_config_header_id%TYPE;
1379: l_unit_config_status_code ahl_unit_config_headers.unit_config_status_code%TYPE;
1380: l_unitname ahl_unit_config_headers.name%TYPE;
1381:
1382: l_chk_top_node_csr chk_top_node_csr%ROWTYPE;
1383: l_check_item_group_csr check_item_group_csr%ROWTYPE;
1384: l_return_status varchar2(1);

Line 1433: update ahl_unit_config_headers

1429: FETCH chk_top_node_csr INTO l_chk_top_node_csr;
1430: IF (chk_top_node_csr%FOUND) THEN
1431:
1432: -- updating active_end_date and incrementing object version number
1433: update ahl_unit_config_headers
1434: set active_end_date = sysdate,
1435: object_version_number=object_version_number+1
1436: where unit_config_header_id = l_chk_top_node_csr.unit_config_header_id;
1437:

Line 1477: update ahl_unit_config_headers

1473:
1474: --update status and object_version_number
1475: IF ( l_unit_config_status_code = 'APPROVAL_PENDING' ) THEN
1476: --modify UC status to APPROVAL_REJECTED
1477: update ahl_unit_config_headers
1478: set unit_config_status_code = 'APPROVAL_REJECTED',
1479: object_version_number=object_version_number+1
1480: where unit_config_header_id = l_unit_config_header_id;
1481:

Line 1484: update ahl_unit_config_headers

1480: where unit_config_header_id = l_unit_config_header_id;
1481:
1482: ELSIF ( l_unit_config_status_code = 'COMPLETE' ) THEN
1483: --modify UC status to INCOMPLETE
1484: update ahl_unit_config_headers
1485: set unit_config_status_code = 'INCOMPLETE',
1486: object_version_number=object_version_number+1
1487: where unit_config_header_id = l_unit_config_header_id;
1488:

Line 1641: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,

1637: FL.MEANING,
1638: FLA.MEANING,
1639: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1640: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1641: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1642: FND_LOOKUP_VALUES_VL FL, FND_LOOKUP_VALUES_VL FLA,
1643: CSI_ITEM_INSTANCES CSI
1644: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1645: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND

Line 1660: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

1656: WHERE LOOKUP_TYPE = 'AHL_CONFIG_STATUS' AND
1657: LOOKUP_CODE = G_STATUS_EXPIRED;
1658:
1659: l_root_uc_header_id NUMBER;
1660: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1661: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1662: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

Line 1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

1659: l_root_uc_header_id NUMBER;
1660: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1661: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1662: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;

Line 1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

1661: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1662: l_uc_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1663: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;

Line 1668: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

1664: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1665: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1666: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1667: l_root_active_status FND_LOOKUP_VALUES.MEANING%TYPE;
1668: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1669: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1670: l_return_value VARCHAR2(100) := null;
1671: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status';
1672:

Line 1702: FROM ahl_unit_config_headers

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

Line 1727: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1723: l_uc_status,
1724: l_uc_active_status,
1725: l_uc_end_date,
1726: l_uc_inst_end_date
1727: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1728: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1729: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1730: AND UC.csi_item_instance_id = CSI.instance_id
1731: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1756: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1752: l_root_status,
1753: l_root_active_status,
1754: l_root_end_date,
1755: l_root_inst_end_date
1756: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1757: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES UASC
1758: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1759: AND UC.csi_item_instance_id = CSI.instance_id
1760: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1838: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,

1834: ROOT_UC.UNIT_CONFIG_STATUS_CODE,
1835: FL.meaning,
1836: NVL(ROOT_UC.ACTIVE_END_DATE, SYSDATE + 1),
1837: NVL(CSI.ACTIVE_END_DATE, SYSDATE + 1)
1838: FROM AHL_UNIT_CONFIG_HEADERS_V UC, AHL_UNIT_CONFIG_HEADERS ROOT_UC,
1839: CSI_ITEM_INSTANCES CSI, FND_LOOKUP_VALUES_VL FL
1840: WHERE UC.UC_HEADER_ID = p_uc_header_id AND
1841: ROOT_UC.UNIT_CONFIG_HEADER_ID = UC.ROOT_UC_HEADER_ID AND
1842: ROOT_UC.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND

Line 1848: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

1844: FL.LOOKUP_TYPE = 'AHL_CONFIG_STATUS';
1845: */
1846:
1847: l_root_uc_header_id NUMBER;
1848: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1849: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1850: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

Line 1850: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

1846:
1847: l_root_uc_header_id NUMBER;
1848: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1849: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1850: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1853: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1854: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

Line 1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;

1848: l_uc_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1849: l_uc_status FND_LOOKUP_VALUES.MEANING%TYPE;
1850: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1853: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1854: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1855: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1856: l_return_value VARCHAR2(100) := null;

Line 1854: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;

1850: l_uc_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1851: l_uc_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1852: l_root_status_code AHL_UNIT_CONFIG_HEADERS.UNIT_CONFIG_STATUS_CODE%TYPE;
1853: l_root_status FND_LOOKUP_VALUES.MEANING%TYPE;
1854: l_root_end_date AHL_UNIT_CONFIG_HEADERS.ACTIVE_END_DATE%TYPE;
1855: l_root_inst_end_date CSI_ITEM_INSTANCES.ACTIVE_END_DATE%TYPE;
1856: l_return_value VARCHAR2(100) := null;
1857: L_DEBUG_KEY CONSTANT VARCHAR2(150) := 'ahl.plsql.AHL_UTIL_UC_PKG.Get_UC_Status_code';
1858:

Line 1887: FROM ahl_unit_config_headers

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

Line 1910: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1906: INTO l_uc_status_code,
1907: l_uc_status,
1908: l_uc_end_date,
1909: l_uc_inst_end_date
1910: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1911: CSI_ITEM_INSTANCES CSI
1912: WHERE UC.UNIT_CONFIG_HEADER_ID = p_uc_header_id
1913: AND UC.csi_item_instance_id = CSI.instance_id
1914: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1934: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,

1930: INTO l_root_status_code,
1931: l_root_status,
1932: l_root_end_date,
1933: l_root_inst_end_date
1934: FROM AHL_UNIT_CONFIG_HEADERS UC, FND_LOOKUP_VALUES UCSC,
1935: CSI_ITEM_INSTANCES CSI
1936: WHERE UC.UNIT_CONFIG_HEADER_ID = l_root_uc_header_id
1937: AND UC.csi_item_instance_id = CSI.instance_id
1938: AND UC.unit_config_status_code = UCSC.lookup_code

Line 1987: FROM ahl_unit_config_headers

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

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

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

Line 2097: FROM ahl_unit_config_headers

2093: csi_item_instance_id,
2094: unit_config_status_code,
2095: active_uc_status_code,
2096: object_version_number
2097: FROM ahl_unit_config_headers
2098: WHERE parent_uc_header_id IS NULL
2099: START WITH unit_config_header_id = c_uc_header_id
2100: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2101: CONNECT BY unit_config_header_id = PRIOR parent_uc_header_id

Line 2267: FROM ahl_unit_config_headers

2263: CURSOR get_parent_uc IS
2264: SELECT object_id
2265: FROM csi_ii_relationships
2266: WHERE object_id IN (SELECT csi_item_instance_id
2267: FROM ahl_unit_config_headers
2268: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2269: START WITH subject_id = p_instance_id
2270: AND relationship_type_code = 'COMPONENT-OF'
2271: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2280: FROM ahl_unit_config_headers

2276: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2277:
2278: CURSOR get_uc_header_id(c_instance_id NUMBER) IS
2279: SELECT unit_config_header_id
2280: FROM ahl_unit_config_headers
2281: WHERE csi_item_instance_id = c_instance_id
2282: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2283:
2284: BEGIN

Line 2316: AHL_UNIT_CONFIG_HEADERS uch

2312: CURSOR get_top_rel_id (csi_id IN NUMBER)
2313: IS
2314: SELECT rel.relationship_id
2315: FROM AHL_MC_RELATIONSHIPS rel,
2316: AHL_UNIT_CONFIG_HEADERS uch
2317: WHERE rel.mc_header_id = uch.master_config_id
2318: AND rel.parent_relationship_id IS NULL
2319: AND uch.csi_item_instance_id = csi_id;
2320: --

Line 2357: FROM ahl_unit_config_headers

2353: CURSOR get_uc_instance_id IS
2354: SELECT object_id
2355: FROM csi_ii_relationships
2356: WHERE object_id IN (SELECT csi_item_instance_id
2357: FROM ahl_unit_config_headers
2358: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2359: START WITH subject_id = p_instance_id
2360: AND relationship_type_code = 'COMPONENT-OF'
2361: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2370: FROM ahl_unit_config_headers

2366: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2367:
2368: CURSOR get_uc_header_name(c_instance_id NUMBER) IS
2369: SELECT name
2370: FROM ahl_unit_config_headers
2371: WHERE csi_item_instance_id = c_instance_id
2372: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2373:
2374: BEGIN

Line 2403: FROM ahl_unit_config_headers

2399: CURSOR get_uc_instance_id IS
2400: SELECT object_id
2401: FROM csi_ii_relationships
2402: WHERE object_id IN (SELECT csi_item_instance_id
2403: FROM ahl_unit_config_headers
2404: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2405: START WITH subject_id = p_instance_id
2406: AND relationship_type_code = 'COMPONENT-OF'
2407: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2416: FROM ahl_unit_config_headers

2412: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2413:
2414: CURSOR get_uc_header_id(c_instance_id NUMBER) IS
2415: SELECT unit_config_header_id
2416: FROM ahl_unit_config_headers
2417: WHERE csi_item_instance_id = c_instance_id
2418: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2419:
2420: BEGIN

Line 2449: FROM ahl_unit_config_headers

2445: CURSOR get_uc_instance_id IS
2446: SELECT object_id
2447: FROM csi_ii_relationships
2448: WHERE object_id IN (SELECT csi_item_instance_id
2449: FROM ahl_unit_config_headers
2450: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2451: START WITH subject_id = p_instance_id
2452: AND relationship_type_code = 'COMPONENT-OF'
2453: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2462: FROM ahl_unit_config_headers

2458: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2459:
2460: CURSOR get_uc_header_name(c_instance_id NUMBER) IS
2461: SELECT name
2462: FROM ahl_unit_config_headers
2463: WHERE csi_item_instance_id = c_instance_id
2464: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2465:
2466: BEGIN

Line 2498: FROM ahl_unit_config_headers

2494: CURSOR get_uc_instance_id IS
2495: SELECT object_id
2496: FROM csi_ii_relationships
2497: WHERE object_id IN (SELECT csi_item_instance_id
2498: FROM ahl_unit_config_headers
2499: WHERE trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE))
2500: START WITH subject_id = p_instance_id
2501: AND relationship_type_code = 'COMPONENT-OF'
2502: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)

Line 2511: FROM ahl_unit_config_headers

2507: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2508:
2509: CURSOR get_uc_header_id(c_instance_id NUMBER) IS
2510: SELECT unit_config_header_id
2511: FROM ahl_unit_config_headers
2512: WHERE csi_item_instance_id = c_instance_id
2513: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2514:
2515: BEGIN

Line 2661: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI,

2657: c_inventory_item_id NUMBER,
2658: c_inventory_org_id NUMBER) IS
2659: SELECT UC.name,
2660: UC.unit_config_header_id
2661: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI,
2662: AHL_MC_RELATIONSHIPS MC
2663: WHERE UC.csi_item_instance_id = CSI.instance_id AND
2664: UC.master_config_id = MC.mc_header_id AND
2665: UC.parent_uc_header_id IS NULL AND

Line 2678: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI

2674: -- Get UC header info
2675: CURSOR c_get_uc_header_info_csr(p_csi_item_instance_id NUMBER) IS
2676: SELECT UC.name,
2677: UC.unit_config_header_id
2678: FROM AHL_UNIT_CONFIG_HEADERS UC, CSI_ITEM_INSTANCES CSI
2679: WHERE UC.csi_item_instance_id IN
2680: (SELECT object_id
2681: FROM CSI_II_RELATIONSHIPS
2682: START WITH

Line 2704: l_unitname ahl_unit_config_headers.name%TYPE;

2700: l_api_name CONSTANT VARCHAR2(30) := 'Check_Invalidate_Instance';
2701: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2702:
2703: l_instance_tbl Instance_Tbl_Type2 := p_instance_tbl;
2704: l_unitname ahl_unit_config_headers.name%TYPE;
2705: l_unitid ahl_unit_config_headers.unit_config_header_id%TYPE;
2706:
2707: l_check_item_group_rec c_check_item_group_csr%ROWTYPE;
2708: l_valid_UC_lst VARCHAR2(2000) := NULL;

Line 2705: l_unitid ahl_unit_config_headers.unit_config_header_id%TYPE;

2701: l_full_name CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name;
2702:
2703: l_instance_tbl Instance_Tbl_Type2 := p_instance_tbl;
2704: l_unitname ahl_unit_config_headers.name%TYPE;
2705: l_unitid ahl_unit_config_headers.unit_config_header_id%TYPE;
2706:
2707: l_check_item_group_rec c_check_item_group_csr%ROWTYPE;
2708: l_valid_UC_lst VARCHAR2(2000) := NULL;
2709:

Line 2884: FROM ahl_unit_config_headers

2880: x_matches_flag OUT NOCOPY VARCHAR2) IS
2881:
2882: CURSOR get_uc_header_id_csr IS
2883: SELECT unit_config_header_id, master_config_id
2884: FROM ahl_unit_config_headers
2885: WHERE csi_item_instance_id = p_instance_id
2886: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2887:
2888: CURSOR get_root_mc_ig_csr (c_mc_header_id IN NUMBER) IS