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 OKC_ARTICLE_VERSIONS

Line 194: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;

190: ) RETURN VARCHAR2 IS
191: CURSOR l_art_csr IS
192: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;
193: CURSOR l_ver_csr IS
194: SELECT OKC_ARTICLE_VERSIONS_S1.NEXTVAL FROM DUAL;
195: BEGIN
196: IF (l_debug = 'Y') THEN
197: okc_debug.Log('100: Entered get_seq_id', 2);
198: END IF;

Line 316: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART

312: sysdate,
313: G_User_Id,
314: G_Login_Id,
315: sysdate
316: FROM OKC_ARTICLE_VERSIONS VER, OKC_ARTICLES_ALL ART
317: WHERE ART.ORIG_SYSTEM_REFERENCE_CODE = 'OKCMIGORIG'
318: AND VER.ORIG_SYSTEM_REFERENCE_CODE = ART.ORIG_SYSTEM_REFERENCE_CODE
319: AND ART.ARTICLE_ID = VER.ARTICLE_ID
320: AND ART.ORG_ID = G_GLOBAL_ORG_ID

Line 549: TYPE list_art_version_number IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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 ;
553: TYPE list_article_id IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 555: TYPE list_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_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 ;
555: TYPE list_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
556: TYPE list_article_language IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
557: TYPE list_art_system_reference_id1 IS TABLE OF OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
558: TYPE list_start_date IS TABLE OF OKC_ARTICLE_VERSIONS.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
559: TYPE list_article_text IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;

Line 558: TYPE list_start_date IS TABLE OF OKC_ARTICLE_VERSIONS.START_DATE%TYPE INDEX BY BINARY_INTEGER ;

554: TYPE list_article_number IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE INDEX BY BINARY_INTEGER ;
555: TYPE list_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
556: TYPE list_article_language IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
557: TYPE list_art_system_reference_id1 IS TABLE OF OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
558: TYPE list_start_date IS TABLE OF OKC_ARTICLE_VERSIONS.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
559: TYPE list_article_text IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
560: TYPE list_sav_release IS TABLE OF OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE INDEX BY BINARY_INTEGER ;
561: TYPE list_process_status IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
562: TYPE list_display_name IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;

Line 559: TYPE list_article_text IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;

555: TYPE list_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;
556: TYPE list_article_language IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
557: TYPE list_art_system_reference_id1 IS TABLE OF OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
558: TYPE list_start_date IS TABLE OF OKC_ARTICLE_VERSIONS.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
559: TYPE list_article_text IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
560: TYPE list_sav_release IS TABLE OF OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE INDEX BY BINARY_INTEGER ;
561: TYPE list_process_status IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
562: TYPE list_display_name IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
563:

Line 560: TYPE list_sav_release IS TABLE OF OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE INDEX BY BINARY_INTEGER ;

556: TYPE list_article_language IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE INDEX BY BINARY_INTEGER ;
557: TYPE list_art_system_reference_id1 IS TABLE OF OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE INDEX BY BINARY_INTEGER ;
558: TYPE list_start_date IS TABLE OF OKC_ARTICLE_VERSIONS.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
559: TYPE list_article_text IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
560: TYPE list_sav_release IS TABLE OF OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE INDEX BY BINARY_INTEGER ;
561: TYPE list_process_status IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
562: TYPE list_display_name IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
563:
564: l_org_id_tbl list_org_id;

Line 562: TYPE list_display_name IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;

558: TYPE list_start_date IS TABLE OF OKC_ARTICLE_VERSIONS.START_DATE%TYPE INDEX BY BINARY_INTEGER ;
559: TYPE list_article_text IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT%TYPE INDEX BY BINARY_INTEGER ;
560: TYPE list_sav_release IS TABLE OF OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE INDEX BY BINARY_INTEGER ;
561: TYPE list_process_status IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER ;
562: TYPE list_display_name IS TABLE of OKC_ARTICLE_VERSIONS.DISPLAY_NAME%TYPE INDEX BY BINARY_INTEGER ;
563:
564: l_org_id_tbl list_org_id;
565: l_org_name_tbl list_org_name;
566: article_title_tbl list_article_title ;

Line 677: -- Update Article Text with ' ' to be migrated to OKC_ARTICLE_VERSIONS

673: get_print_msgs_stack;
674: RAISE FND_API.G_EXC_ERROR ;
675: END IF;
676:
677: -- Update Article Text with ' ' to be migrated to OKC_ARTICLE_VERSIONS
678: UPDATE OKC_STD_ART_VERSIONS_TL
679: SET TEXT = ' '
680: WHERE TEXT IS NULL;
681:

Line 1303: INSERT INTO OKC_ARTICLE_VERSIONS(

1299:
1300: -- Bulk insert New Article Versions
1301:
1302: FORALL i in t_article_version_id_tbl.FIRST ..t_article_version_id_tbl.LAST
1303: INSERT INTO OKC_ARTICLE_VERSIONS(
1304: ARTICLE_VERSION_ID,
1305: ARTICLE_ID,
1306: ARTICLE_VERSION_NUMBER,
1307: ARTICLE_TEXT,

Line 1446: -- End of Insert into OKC_ARTICLE_VERSIONS

1442: RAISE FND_API.G_EXC_ERROR;
1443: END;
1444:
1445: --
1446: -- End of Insert into OKC_ARTICLE_VERSIONS
1447: --
1448: --
1449: -- Bulk insert Article relationships
1450: BEGIN

Line 1911: SET ENTITY_NAME = 'OKC_ARTICLE_VERSIONS',

1907:
1908: -- Update Article Version Attachments
1909: FORALL i in t_article_version_id_tbl.FIRST ..t_article_version_id_tbl.LAST
1910: UPDATE FND_ATTACHED_DOCUMENTS
1911: SET ENTITY_NAME = 'OKC_ARTICLE_VERSIONS',
1912: PK1_VALUE = to_char(t_article_version_id_tbl(i)),
1913: PK2_VALUE = NULL,
1914: LAST_UPDATE_DATE = SYSDATE,
1915: LAST_UPDATE_LOGIN = G_Login_Id,