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_K_ARTICLES_PVT dependencies on OKC_K_ARTICLES_B_S

Line 64: SELECT OKC_K_ARTICLES_B_S.NEXTVAL FROM DUAL;

60: p_id IN NUMBER,
61: x_id OUT NOCOPY NUMBER
62: ) RETURN VARCHAR2 IS
63: CURSOR c_seq IS
64: SELECT OKC_K_ARTICLES_B_S.NEXTVAL FROM DUAL;
65: BEGIN
66: IF (l_debug = 'Y') THEN
67: Okc_Debug.Log('100: Entered get_seq_id', 2);
68: END IF;

Line 1412: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;

1408: p_ref_article_version_id IN NUMBER,
1409: p_object_version_number IN NUMBER,
1410: p_mandatory_rwa IN VARCHAR2
1411: ) IS
1412: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1413: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

Line 1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

1412: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1413: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1414: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;

Line 1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;

1415: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1416: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1417: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1418: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
1419: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1420: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1421: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1422: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1423: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;

Line 1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;

1442: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1443: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1444: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1445: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1446: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1447: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1448: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1449: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1450: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;

Line 2430: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;

2426: p_last_amendment_date IN DATE
2427:
2428: ) IS
2429:
2430: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2431: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

Line 2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

2430: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2431: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2432: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;

Line 2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;

2433: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2434: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2435: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2436: l_mandatory_rwa OKC_K_ARTICLES_B.MANDATORY_RWA%TYPE;
2437: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2438: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2439: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2440: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2441: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;

Line 2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;

2460: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2461: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2462: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2463: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2464: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2465: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2466: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2467: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2468: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;