APPS.OKC_ARTICLES_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 622: FROM HR_ORGANIZATION_INFORMATION OI1,

618:
619:
620: CURSOR l_get_sob_csr (cp_org_id IN NUMBER ) IS
621: SELECT OI2.ORG_INFORMATION3 SET_OF_BOOKS_ID
622: FROM HR_ORGANIZATION_INFORMATION OI1,
623: HR_ORGANIZATION_INFORMATION OI2,
624: HR_ALL_ORGANIZATION_UNITS OU
625: WHERE OI1.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
626: OI2.ORGANIZATION_ID = OU.ORGANIZATION_ID AND

Line 623: HR_ORGANIZATION_INFORMATION OI2,

619:
620: CURSOR l_get_sob_csr (cp_org_id IN NUMBER ) IS
621: SELECT OI2.ORG_INFORMATION3 SET_OF_BOOKS_ID
622: FROM HR_ORGANIZATION_INFORMATION OI1,
623: HR_ORGANIZATION_INFORMATION OI2,
624: HR_ALL_ORGANIZATION_UNITS OU
625: WHERE OI1.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
626: OI2.ORGANIZATION_ID = OU.ORGANIZATION_ID AND
627: OI1.ORG_INFORMATION_CONTEXT = 'CLASS' AND

Line 645: FROM HR_ORGANIZATION_INFORMATION

641: -- Need to get the Seq Category from EIT instead from Profile
642: CURSOR l_clause_seq_csr (cp_org_id IN NUMBER) IS
643: SELECT ORG_INFORMATION8 CLAUSE_SEQ
644: --nvl(ORG_INFORMATION8,'-99') CLAUSE_SEQ
645: FROM HR_ORGANIZATION_INFORMATION
646: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
647: AND ORGANIZATION_ID = cp_org_id
648: ;
649:

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

4039: i NUMBER := 0;
4040: j NUMBER := 0;
4041: l_return_status VARCHAR2(1);
4042: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4043: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4044: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
4045: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
4046: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4047: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

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

4040: j NUMBER := 0;
4041: l_return_status VARCHAR2(1);
4042: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4043: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4044: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
4045: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
4046: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4047: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4048: TYPE l_adoption_type_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 4065: FROM HR_ORGANIZATION_INFORMATION

4061: SELECT ORGANIZATION_ID,
4062: decode(nvl(ORG_INFORMATION1,'N'),'N','AVAILABLE','Y','ADOPTED') ADOPTION_TYPE ,
4063: ORG_INFORMATION2
4064:
4065: FROM HR_ORGANIZATION_INFORMATION
4066: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
4067: AND ORGANIZATION_ID <> G_GLOBAL_ORG_ID
4068: AND NOT EXISTS
4069: (

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

4442: l_api_version CONSTANT NUMBER := 1;
4443: l_api_name CONSTANT VARCHAR2(30) := 'g_auto_adoption';
4444: j NUMBER := 0;
4445: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
4446: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
4447: TYPE l_article_number_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
4448: TYPE l_source_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.SOURCE_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4449: TYPE l_target_article_id_list IS TABLE OF OKC_ARTICLE_RELATNS_ALL.TARGET_ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
4450:

Line 4466: FROM HR_ORGANIZATION_INFORMATION

4462: AND target_article_id = cp_target_global_article_id;
4463: /*
4464: AND exists
4465: ( SELECT '1'
4466: FROM HR_ORGANIZATION_INFORMATION
4467: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
4468: AND ORGANIZATION_ID = rel.org_id
4469: AND ORG_INFORMATION1 = 'Y');
4470: */