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 1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;

1392: p_ref_article_id IN NUMBER,
1393: p_ref_article_version_id IN NUMBER,
1394: p_object_version_number IN NUMBER
1395: ) IS
1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

Line 1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

1396: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
1397: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

Line 1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;

1398: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
1399: l_cle_id OKC_K_ARTICLES_B.CLE_ID%TYPE;
1400: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
1401: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
1402: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
1403: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
1404: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1405: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1406: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;

Line 1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;

1425: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
1426: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
1427: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
1428: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
1429: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
1430: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
1431: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
1432: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
1433: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;

Line 2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;

2397: p_last_amendment_date IN DATE
2398:
2399: ) IS
2400:
2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

Line 2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;

2401: l_sav_sae_id OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
2402: l_document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE;
2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

Line 2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;

2403: l_document_id OKC_K_ARTICLES_B.DOCUMENT_ID%TYPE;
2404: l_cle_id OKC_K_ARTICLES_B.cle_id%TYPE;
2405: l_source_flag OKC_K_ARTICLES_B.SOURCE_FLAG%TYPE;
2406: l_mandatory_yn OKC_K_ARTICLES_B.MANDATORY_YN%TYPE;
2407: l_scn_id OKC_K_ARTICLES_B.SCN_ID%TYPE;
2408: l_label OKC_K_ARTICLES_B.LABEL%TYPE;
2409: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
2410: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
2411: l_article_version_id OKC_K_ARTICLES_B.ARTICLE_VERSION_ID%TYPE;

Line 2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;

2430: l_attribute13 OKC_K_ARTICLES_B.ATTRIBUTE13%TYPE;
2431: l_attribute14 OKC_K_ARTICLES_B.ATTRIBUTE14%TYPE;
2432: l_attribute15 OKC_K_ARTICLES_B.ATTRIBUTE15%TYPE;
2433: l_print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE;
2434: l_summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE;
2435: l_ref_article_id OKC_K_ARTICLES_B.ref_article_id%TYPE;
2436: l_ref_article_version_id OKC_K_ARTICLES_B.ref_article_version_id%TYPE;
2437: l_object_version_number OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
2438: l_created_by OKC_K_ARTICLES_B.CREATED_BY%TYPE;