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_MIGRATE_GRP dependencies on HR_ORGANIZATION_UNITS

Line 266: l_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;

262: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
263: AND INF.ORGANIZATION_ID = UNIT.ORGANIZATION_ID
264: AND INF.ORGANIZATION_ID = G_CURRENT_ORG_ID;
265:
266: l_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;
267: l_org_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
268: l_row_notfound BOOLEAN:=FALSE;
269:
270: BEGIN

Line 548: TYPE list_org_name IS TABLE OF HR_ORGANIZATION_UNITS.NAME%TYPE INDEX BY BINARY_INTEGER;

544: AND rownum < 2;
545:
546: -- All Tables and Datatypes for bulk associations
547:
548: TYPE list_org_name IS TABLE OF HR_ORGANIZATION_UNITS.NAME%TYPE INDEX BY BINARY_INTEGER;
549: TYPE list_art_version_number IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
550: TYPE list_org_id IS TABLE OF HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
551: TYPE list_system_reference_code IS TABLE OF OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
552: TYPE list_article_title IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;

Line 550: TYPE list_org_id IS TABLE OF HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

546: -- All Tables and Datatypes for bulk associations
547:
548: TYPE list_org_name IS TABLE OF HR_ORGANIZATION_UNITS.NAME%TYPE INDEX BY BINARY_INTEGER;
549: TYPE list_art_version_number IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
550: TYPE list_org_id IS TABLE OF HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
551: TYPE list_system_reference_code IS TABLE OF OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;
552: TYPE list_article_title IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;
553: TYPE list_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;
554: TYPE list_article_number IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;