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_SECTIONS_B

Line 97: l_orig_system_reference_code OKC_SECTIONS_B.orig_system_reference_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: l_orig_system_reference_code OKC_SECTIONS_B.orig_system_reference_code%type;
98: l_orig_system_reference_id1 OKC_SECTIONS_B.orig_system_reference_id1%type;
99:
100: CURSOR l_article_var_csr(b_article_version_id NUMBER) IS
101: SELECT VAR.VARIABLE_CODE, BUSVAR.VARIABLE_TYPE, BUSVAR.EXTERNAL_YN, BUSVAR.VALUE_SET_ID

Line 98: l_orig_system_reference_id1 OKC_SECTIONS_B.orig_system_reference_id1%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: l_orig_system_reference_code OKC_SECTIONS_B.orig_system_reference_code%type;
98: l_orig_system_reference_id1 OKC_SECTIONS_B.orig_system_reference_id1%type;
99:
100: CURSOR l_article_var_csr(b_article_version_id NUMBER) IS
101: SELECT VAR.VARIABLE_CODE, BUSVAR.VARIABLE_TYPE, BUSVAR.EXTERNAL_YN, BUSVAR.VALUE_SET_ID
102: FROM OKC_ARTICLE_VARIABLES VAR,

Line 190: FROM okc_sections_b

186: IF p_mode='AMEND' AND SubStr(p_document_type,-3,3) = 'MOD' AND p_scn_id IS NOT NULL THEN
187:
188: SELECT orig_system_reference_code, orig_system_reference_id1
189: INTO l_orig_system_reference_code, l_orig_system_reference_id1
190: FROM okc_sections_b
191: WHERE id=p_scn_id;
192:
193: IF l_orig_system_reference_code = 'COPY' THEN
194: okc_k_entity_locks_grp.lock_entity (

Line 673: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

669: l_standard_yn VARCHAR2(1);
670: l_sync_variable VARCHAR2(1) := FND_API.G_FALSE;
671: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
672: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
673: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
674: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
675: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
676: x_cat_id okc_k_art_variables.cat_id%type;
677: x_variable_code okc_k_art_variables.variable_code%type;

Line 674: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

670: l_sync_variable VARCHAR2(1) := FND_API.G_FALSE;
671: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
672: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
673: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
674: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
675: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
676: x_cat_id okc_k_art_variables.cat_id%type;
677: x_variable_code okc_k_art_variables.variable_code%type;
678: l_orig_system_reference_id1 NUMBER;

Line 1164: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

1160: l_standard_yn VARCHAR2(1);
1161: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1162: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1163:
1164: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1165: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1166: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1167: l_delete_rec BOOLEAN := FALSE;
1168: l_orig_system_reference_id1 NUMBER;

Line 1165: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

1161: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1162: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1163:
1164: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1165: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1166: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1167: l_delete_rec BOOLEAN := FALSE;
1168: l_orig_system_reference_id1 NUMBER;
1169:

Line 1166: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

1162: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1163:
1164: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1165: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1166: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1167: l_delete_rec BOOLEAN := FALSE;
1168: l_orig_system_reference_id1 NUMBER;
1169:
1170: CURSOR l_document_id_csr IS