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_GRP dependencies on OKC_K_ARTICLES_B

Line 93: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;

89: l_api_name CONSTANT VARCHAR2(30) := 'g_create_article';
90: l_cat_id NUMBER;
91: l_del_cat_id NUMBER;
92: l_variable_code OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE;
93: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
94: l_summary_amend_operation_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
95: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
96:
97: CURSOR l_article_var_csr(b_article_version_id NUMBER) IS

Line 94: l_summary_amend_operation_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

90: l_cat_id NUMBER;
91: l_del_cat_id NUMBER;
92: l_variable_code OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE;
93: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
94: l_summary_amend_operation_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
95: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
96:
97: CURSOR l_article_var_csr(b_article_version_id NUMBER) IS
98: SELECT VAR.VARIABLE_CODE, BUSVAR.VARIABLE_TYPE, BUSVAR.EXTERNAL_YN, BUSVAR.VALUE_SET_ID

Line 95: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

91: l_del_cat_id NUMBER;
92: l_variable_code OKC_K_ART_VARIABLES.VARIABLE_CODE%TYPE;
93: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
94: l_summary_amend_operation_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
95: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
96:
97: CURSOR l_article_var_csr(b_article_version_id NUMBER) IS
98: SELECT VAR.VARIABLE_CODE, BUSVAR.VARIABLE_TYPE, BUSVAR.EXTERNAL_YN, BUSVAR.VALUE_SET_ID
99: FROM OKC_ARTICLE_VARIABLES VAR,

Line 105: SELECT id FROM okc_k_articles_b

101: WHERE VAR.ARTICLE_VERSION_ID = b_article_version_id
102: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE;
103:
104: CURSOR l_get_deleted_rec_csr IS
105: SELECT id FROM okc_k_articles_b
106: WHERE document_type=p_document_type
107: AND document_id =p_document_id
108: AND ( sav_sae_id = p_sav_sae_id
109: OR sav_sae_id=p_ref_article_id

Line 636: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;

632: l_document_type VARCHAR2(30);
633: l_article_version_id NUMBER;
634: l_standard_yn VARCHAR2(1);
635: l_sync_variable VARCHAR2(1) := FND_API.G_FALSE;
636: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
637: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
638: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
639: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
640: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

Line 637: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;

633: l_article_version_id NUMBER;
634: l_standard_yn VARCHAR2(1);
635: l_sync_variable VARCHAR2(1) := FND_API.G_FALSE;
636: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
637: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
638: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
639: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
640: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
641: x_cat_id okc_k_art_variables.cat_id%type;

Line 640: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

636: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
637: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
638: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
639: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
640: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
641: x_cat_id okc_k_art_variables.cat_id%type;
642: x_variable_code okc_k_art_variables.variable_code%type;
643:
644: CURSOR l_document_id_csr IS

Line 646: FROM OKC_K_ARTIClES_B

642: x_variable_code okc_k_art_variables.variable_code%type;
643:
644: CURSOR l_document_id_csr IS
645: SELECT DOCUMENT_ID,DOCUMENT_TYPE
646: FROM OKC_K_ARTIClES_B
647: WHERE ID=P_ID;
648:
649: CURSOR l_art_version_csr IS
650: SELECT ARTICLE_VERSION_ID,standard_yn

Line 651: FROM OKC_K_ARTIClES_B kart,okc_articles_all art

647: WHERE ID=P_ID;
648:
649: CURSOR l_art_version_csr IS
650: SELECT ARTICLE_VERSION_ID,standard_yn
651: FROM OKC_K_ARTIClES_B kart,okc_articles_all art
652: WHERE ID=P_ID
653: AND art.article_id=kart.sav_sae_id;
654:
655: CURSOR l_create_variable_csr is

Line 664: OKC_K_ARTICLES_B KART,

660: BUSVAR.VALUE_SET_ID,
661: NULL VARIABLE_VALUE,
662: NULL VARIABLE_VALUE_ID
663: FROM OKC_ARTICLE_VARIABLES VAR,
664: OKC_K_ARTICLES_B KART,
665: OKC_BUS_VARIABLES_B BUSVAR
666: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
667: AND KART.ID = P_ID
668: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE AND NOT EXISTS

Line 683: OKC_K_ARTICLES_B KART,

679: ARTVAR.VARIABLE_VALUE,
680: ARTVAR.VARIABLE_VALUE_ID,
681: ARTVAR.OBJECT_VERSION_NUMBER
682: FROM OKC_ARTICLE_VARIABLES VAR,
683: OKC_K_ARTICLES_B KART,
684: OKC_BUS_VARIABLES_B BUSVAR,
685: OKC_K_ART_VARIABLES ARTVAR
686: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
687: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE

Line 698: OKC_K_ARTICLES_B KART

694: SELECT ARTVAR.CAT_ID,
695: ARTVAR.VARIABLE_CODE,
696: ARTVAR.OBJECT_VERSION_NUMBER
697: FROM OKC_K_ART_VARIABLES ARTVAR,
698: OKC_K_ARTICLES_B KART
699: WHERE KART.ID = ARTVAR.CAT_ID
700: AND KART.ID = P_ID
701: AND NOT EXISTS ( SELECT 'X' FROM OKC_ARTICLE_VARIABLES VAR
702: WHERE VAR.ARTICLE_VERSION_ID = KART.ARTICLE_VERSION_ID

Line 707: FROM OKC_K_ARTICLES_B

703: AND VAR.VARIABLE_CODE = ARTVAR.VARIABLE_CODE );
704:
705: CURSOR l_get_summary_code_csr IS
706: SELECT SUMMARY_AMEND_OPERATION_CODE ,amendment_operation_code
707: FROM OKC_K_ARTICLES_B
708: WHERE ID=P_ID;
709:
710:
711: BEGIN

Line 1054: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;

1050: l_cle_id NUMBER;
1051: l_document_type VARCHAR2(30);
1052: l_mandatory_yn VARCHAR2(1);
1053: l_standard_yn VARCHAR2(1);
1054: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1055: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1056:
1057: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1058: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

Line 1055: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;

1051: l_document_type VARCHAR2(30);
1052: l_mandatory_yn VARCHAR2(1);
1053: l_standard_yn VARCHAR2(1);
1054: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1055: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1056:
1057: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1058: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1059: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

Line 1064: FROM OKC_K_ARTIClES_B kart, OKC_ARTICLES_ALL art

1060: l_delete_rec BOOLEAN := FALSE;
1061:
1062: CURSOR l_document_id_csr IS
1063: SELECT kart.DOCUMENT_ID,kart.DOCUMENT_TYPE,kart.mandatory_yn, art.standard_yn
1064: FROM OKC_K_ARTIClES_B kart, OKC_ARTICLES_ALL art
1065: WHERE kart.sav_sae_id = art.article_id
1066: AND ID=P_ID;
1067:
1068: CURSOR l_get_summary_code_csr IS

Line 1070: FROM OKC_K_ARTICLES_B

1066: AND ID=P_ID;
1067:
1068: CURSOR l_get_summary_code_csr IS
1069: SELECT SUMMARY_AMEND_OPERATION_CODE,AMENDMENT_OPERATION_CODE
1070: FROM OKC_K_ARTICLES_B
1071: WHERE ID=P_ID;
1072:
1073:
1074: BEGIN