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.OKC_ARTICLES_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 611: FROM HR_ORGANIZATION_INFORMATION OI1,

607:
608:
609: CURSOR l_get_sob_csr (cp_org_id IN NUMBER ) IS
610: SELECT OI2.ORG_INFORMATION3 SET_OF_BOOKS_ID
611: FROM HR_ORGANIZATION_INFORMATION OI1,
612: HR_ORGANIZATION_INFORMATION OI2,
613: HR_ALL_ORGANIZATION_UNITS OU
614: WHERE OI1.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
615: OI2.ORGANIZATION_ID = OU.ORGANIZATION_ID AND

Line 612: HR_ORGANIZATION_INFORMATION OI2,

608:
609: CURSOR l_get_sob_csr (cp_org_id IN NUMBER ) IS
610: SELECT OI2.ORG_INFORMATION3 SET_OF_BOOKS_ID
611: FROM HR_ORGANIZATION_INFORMATION OI1,
612: HR_ORGANIZATION_INFORMATION OI2,
613: HR_ALL_ORGANIZATION_UNITS OU
614: WHERE OI1.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
615: OI2.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
616: OI1.ORG_INFORMATION_CONTEXT = 'CLASS' AND

Line 634: FROM HR_ORGANIZATION_INFORMATION

630: -- Need to get the Seq Category from EIT instead from Profile
631: CURSOR l_clause_seq_csr (cp_org_id IN NUMBER) IS
632: SELECT ORG_INFORMATION8 CLAUSE_SEQ
633: --nvl(ORG_INFORMATION8,'-99') CLAUSE_SEQ
634: FROM HR_ORGANIZATION_INFORMATION
635: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
636: AND ORGANIZATION_ID = cp_org_id
637: ;
638:

Line 3876: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

3872: i NUMBER := 0;
3873: j NUMBER := 0;
3874: l_return_status VARCHAR2(1);
3875: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
3876: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3877: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
3878: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
3879: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3880: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 3877: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;

3873: j NUMBER := 0;
3874: l_return_status VARCHAR2(1);
3875: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
3876: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3877: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
3878: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
3879: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3880: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
3881: TYPE l_adoption_type_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 3898: FROM HR_ORGANIZATION_INFORMATION

3894: SELECT ORGANIZATION_ID,
3895: decode(nvl(ORG_INFORMATION1,'N'),'N','AVAILABLE','Y','ADOPTED') ADOPTION_TYPE ,
3896: ORG_INFORMATION2
3897:
3898: FROM HR_ORGANIZATION_INFORMATION
3899: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
3900: AND ORGANIZATION_ID <> G_GLOBAL_ORG_ID
3901: AND NOT EXISTS
3902: (

Line 4279: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

4275: l_api_version CONSTANT NUMBER := 1;
4276: l_api_name CONSTANT VARCHAR2(30) := 'g_auto_adoption';
4277: j NUMBER := 0;
4278: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4279: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4280: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4281: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4282: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4283:

Line 4299: FROM HR_ORGANIZATION_INFORMATION

4295: AND target_article_id = cp_target_global_article_id;
4296: /*
4297: AND exists
4298: ( SELECT '1'
4299: FROM HR_ORGANIZATION_INFORMATION
4300: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
4301: AND ORGANIZATION_ID = rel.org_id
4302: AND ORG_INFORMATION1 = 'Y');
4303: */