DBA Data[Home] [Help]

APPS.OKC_ADOPTIONS_GRP dependencies on FND_LOOKUP_VALUES

Line 802: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

798: l_adoption_type OKC_ARTICLE_ADOPTIONS.ADOPTION_TYPE%TYPE;
799: l_adoption_status OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE;
800: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
801: TYPE l_org_id_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
802: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
803: TYPE l_notifier_list IS TABLE OF HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE INDEX BY BINARY_INTEGER;
804: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
805: TYPE l_adp_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
806: TYPE l_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;

Line 1197: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

1193: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
1194:
1195: l_prev_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
1196: l_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
1197: TYPE l_adoption_type_list IS TABLE OF FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
1198: TYPE l_adoption_status_list IS TABLE OF OKC_ARTICLE_ADOPTIONS.ADOPTION_STATUS%TYPE INDEX BY BINARY_INTEGER;
1199: TYPE l_adp_record_status_list IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
1200: TYPE l_article_version_id_list IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
1201: TYPE l_article_id_list IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;