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_ARTICLES_ALL

Line 39: G_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;

35: G_EXC_PREREQ_SETUP_ERROR EXCEPTION;
36: G_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
37: G_CURRENT_ORG_ID NUMBER := -99;
38: G_FETCHSIZE_LIMIT NUMBER := 300;
39: G_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
40: G_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
41: G_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
42: G_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
43: G_context VARCHAR2(50) := NULL;

Line 40: G_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;

36: G_GLOBAL_ORG_ID NUMBER := NVL(FND_PROFILE.VALUE('OKC_GLOBAL_ORG_ID'),-99);
37: G_CURRENT_ORG_ID NUMBER := -99;
38: G_FETCHSIZE_LIMIT NUMBER := 300;
39: G_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
40: G_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
41: G_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
42: G_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
43: G_context VARCHAR2(50) := NULL;
44: G_user_id NUMBER;

Line 41: G_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;

37: G_CURRENT_ORG_ID NUMBER := -99;
38: G_FETCHSIZE_LIMIT NUMBER := 300;
39: G_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
40: G_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
41: G_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
42: G_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
43: G_context VARCHAR2(50) := NULL;
44: G_user_id NUMBER;
45: G_login_id NUMBER;

Line 42: G_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;

38: G_FETCHSIZE_LIMIT NUMBER := 300;
39: G_program_id OKC_ARTICLES_ALL.PROGRAM_ID%TYPE;
40: G_program_login_id OKC_ARTICLES_ALL.PROGRAM_LOGIN_ID%TYPE;
41: G_program_appl_id OKC_ARTICLES_ALL.PROGRAM_APPLICATION_ID%TYPE;
42: G_request_id OKC_ARTICLES_ALL.REQUEST_ID%TYPE;
43: G_context VARCHAR2(50) := NULL;
44: G_user_id NUMBER;
45: G_login_id NUMBER;
46:

Line 192: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;

188: p_object_type IN VARCHAR2,
189: x_object_id OUT NOCOPY NUMBER
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

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 353: (SELECT 1 FROM OKC_ARTICLES_ALL SRC, OKC_ARTICLES_ALL TAR

349: sysdate
350: FROM OKC_ARTICLE_RELATNS_ALL REL
351: WHERE ORG_ID = G_GLOBAL_ORG_ID
352: AND EXISTS
353: (SELECT 1 FROM OKC_ARTICLES_ALL SRC, OKC_ARTICLES_ALL TAR
354: WHERE SRC.orig_system_reference_code like 'OKCMIG%'
355: AND SRC.article_id = REL.source_article_id
356: AND SRC.org_id = G_GLOBAL_ORG_ID
357: AND TAR.org_id = G_GLOBAL_ORG_ID

Line 444: 1 FROM OKC_ARTICLES_ALL

440: WHERE
441: ARTL.LANGUAGE = ARTL.SOURCE_LANG
442: AND NOT EXISTS
443: (SELECT /*+ NO_UNNEST */
444: 1 FROM OKC_ARTICLES_ALL
445: WHERE ORIG_SYSTEM_REFERENCE_ID1 = TO_CHAR(ARTL.ID)
446: AND ORIG_SYSTEM_REFERENCE_CODE in ('OKCMIGORIG', 'OKCMIGNEW')
447: AND ARTICLE_LANGUAGE = ARTL.LANGUAGE)
448: UNION ALL -- translated versions only but not articles - results in new article -- distinct is needed as there may be multiple translated versions.

Line 464: 1 FROM OKC_ARTICLES_ALL

460: AND ARTVL.LANGUAGE <> cp_base_language
461: AND ARTVL.SAE_ID = ARTL.ID
462: AND NOT EXISTS
463: (SELECT /*+ NO_UNNEST */
464: 1 FROM OKC_ARTICLES_ALL
465: WHERE ORIG_SYSTEM_REFERENCE_ID1 = TO_CHAR(ARTL.ID)
466: AND ORIG_SYSTEM_REFERENCE_CODE in ('OKCMIGORIG', 'OKCMIGNEW')
467: AND ARTICLE_LANGUAGE = ARTVL.LANGUAGE)
468: AND NOT EXISTS

Line 540: SELECT '1' FROM OKC_ARTICLES_ALL

536: FROM OKC_K_HEADERS_B;
537:
538: -- Cursor to check if same article title already exists in global org for 11.5.10
539: CURSOR l_unq_csr(p_article_title IN VARCHAR2) is
540: SELECT '1' FROM OKC_ARTICLES_ALL
541: WHERE article_title = p_article_title
542: AND org_id = G_GLOBAL_ORG_ID
543: AND standard_yn = 'Y'
544: AND rownum < 2;

Line 551: TYPE list_system_reference_code IS TABLE OF OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE INDEX BY BINARY_INTEGER;

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 ;
555: TYPE list_article_version_id IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE INDEX BY BINARY_INTEGER ;

Line 552: TYPE list_article_title IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE INDEX BY BINARY_INTEGER ;

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 ;
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 ;

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

Line 554: TYPE list_article_number IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_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 ;
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 ;

Line 556: TYPE list_article_language IS TABLE OF OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%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 ;
560: TYPE list_sav_release IS TABLE OF OKC_ARTICLE_VERSIONS.SAV_RELEASE%TYPE INDEX BY BINARY_INTEGER ;

Line 557: TYPE list_art_system_reference_id1 IS TABLE OF OKC_ARTICLES_ALL.ORIG_SYSTEM_REFERENCE_ID1%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 ;
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 ;

Line 597: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

593:
594: I NUMBER := 0;
595: j NUMBER := 0;
596: k NUMBER := 0;
597: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
598: l_return_status VARCHAR2(1);
599: l_doc_sequence_type CHAR(1);
600: l_language VARCHAR2(12);
601: l_migrated BOOLEAN :=FALSE;

Line 1188: INSERT INTO OKC_ARTICLES_ALL(

1184: BEGIN
1185: i := 0;
1186: G_context := 'ART';
1187: FORALL i in article_id_tbl.FIRST ..article_id_tbl.LAST
1188: INSERT INTO OKC_ARTICLES_ALL(
1189: ARTICLE_ID,
1190: ARTICLE_TITLE,
1191: ORG_ID,
1192: ARTICLE_NUMBER,

Line 1291: -- End of Insert into OKC_ARTICLES_ALL

1287: RAISE FND_API.G_EXC_ERROR;
1288: END;
1289:
1290: --
1291: -- End of Insert into OKC_ARTICLES_ALL
1292: --
1293: --
1294:
1295:

Line 1419: (SELECT 1 FROM OKC_ARTICLES_ALL ART WHERE

1415: AND T.LANGUAGE = t_ver_language_tbl(i)
1416: AND T.SAE_ID = B.SAE_ID
1417: AND T.SAV_RELEASE = B.SAV_RELEASE
1418: AND EXISTS
1419: (SELECT 1 FROM OKC_ARTICLES_ALL ART WHERE
1420: ART.ARTICLE_ID = t_article_id_tbl(i) AND
1421: ART.ORIG_SYSTEM_REFERENCE_ID1 = TO_CHAR(B.SAE_ID) AND
1422: ART.ORIG_SYSTEM_REFERENCE_ID1 = t_ver_system_reference_id1_tbl(i));
1423:

Line 1475: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,

1471: INC.creation_date,
1472: INC.last_updated_by,
1473: INC.last_update_login,
1474: INC.last_update_date
1475: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,
1476: HR_ORGANIZATION_INFORMATION ORG
1477: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1478: AND SRC.orig_system_reference_id1 = INC.SAE_ID
1479: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')

Line 1537: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,

1533: INC.creation_date,
1534: INC.last_updated_by,
1535: INC.last_update_login,
1536: INC.last_update_date
1537: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,
1538: HR_ORGANIZATION_INFORMATION ORG
1539: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1540: AND SRC.orig_system_reference_id1 = TO_CHAR(INC.SAE_ID)
1541: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')

Line 1599: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,

1595: INC.creation_date,
1596: INC.last_updated_by,
1597: INC.last_update_login,
1598: INC.last_update_date
1599: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,
1600: HR_ORGANIZATION_INFORMATION ORG
1601: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1602: AND SRC.orig_system_reference_id1 = INC.SAE_ID
1603: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')

Line 1661: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,

1657: INC.creation_date,
1658: INC.last_updated_by,
1659: INC.last_update_login,
1660: INC.last_update_date
1661: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,
1662: HR_ORGANIZATION_INFORMATION ORG
1663: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1664: AND SRC.orig_system_reference_id1 = TO_CHAR(INC.SAE_ID)
1665: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')

Line 1921: (SELECT 1 FROM OKC_ARTICLES_ALL ART WHERE

1917: WHERE ENTITY_NAME = 'OKC_STD_ARTICLES_B'
1918: AND PK1_VALUE = t_ver_system_reference_id1_tbl(i)
1919: AND PK2_VALUE = t_artv_sav_release_tbl(i)
1920: AND EXISTS
1921: (SELECT 1 FROM OKC_ARTICLES_ALL ART WHERE
1922: ART.ARTICLE_ID = t_article_id_tbl(i) AND
1923: ART.ORIG_SYSTEM_REFERENCE_ID1 = t_ver_system_reference_id1_tbl(i));
1924: EXCEPTION
1925: WHEN OTHERS THEN