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

Line 71: document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE,

67: last_update_date OKC_K_ARTICLES_V.LAST_UPDATE_DATE%TYPE,
68: last_update_login NUMBER,
69: -- new 11i10 columns
70: -- defaulted during insert based on App_Id
71: document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE,
72: document_id NUMBER ,
73:
74: source_flag VARCHAR2(1) ,
75: mandatory_yn OKC_K_ARTICLES_B.mandatory_yn%TYPE ,

Line 75: mandatory_yn OKC_K_ARTICLES_B.mandatory_yn%TYPE ,

71: document_type OKC_K_ARTICLES_B.DOCUMENT_TYPE%TYPE,
72: document_id NUMBER ,
73:
74: source_flag VARCHAR2(1) ,
75: mandatory_yn OKC_K_ARTICLES_B.mandatory_yn%TYPE ,
76: scn_id NUMBER ,
77: label OKC_K_ARTICLES_B.label%TYPE ,
78: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE ,
79: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE ,

Line 77: label OKC_K_ARTICLES_B.label%TYPE ,

73:
74: source_flag VARCHAR2(1) ,
75: mandatory_yn OKC_K_ARTICLES_B.mandatory_yn%TYPE ,
76: scn_id NUMBER ,
77: label OKC_K_ARTICLES_B.label%TYPE ,
78: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE ,
79: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE ,
80: article_version_id NUMBER ,
81: change_nonstd_yn OKC_K_ARTICLES_B.change_nonstd_yn%TYPE ,

Line 78: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE ,

74: source_flag VARCHAR2(1) ,
75: mandatory_yn OKC_K_ARTICLES_B.mandatory_yn%TYPE ,
76: scn_id NUMBER ,
77: label OKC_K_ARTICLES_B.label%TYPE ,
78: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE ,
79: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE ,
80: article_version_id NUMBER ,
81: change_nonstd_yn OKC_K_ARTICLES_B.change_nonstd_yn%TYPE ,
82: orig_system_reference_code OKC_K_ARTICLES_B.orig_system_reference_code%TYPE ,

Line 79: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE ,

75: mandatory_yn OKC_K_ARTICLES_B.mandatory_yn%TYPE ,
76: scn_id NUMBER ,
77: label OKC_K_ARTICLES_B.label%TYPE ,
78: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE ,
79: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE ,
80: article_version_id NUMBER ,
81: change_nonstd_yn OKC_K_ARTICLES_B.change_nonstd_yn%TYPE ,
82: orig_system_reference_code OKC_K_ARTICLES_B.orig_system_reference_code%TYPE ,
83: orig_system_reference_id1 NUMBER ,

Line 81: change_nonstd_yn OKC_K_ARTICLES_B.change_nonstd_yn%TYPE ,

77: label OKC_K_ARTICLES_B.label%TYPE ,
78: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE ,
79: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE ,
80: article_version_id NUMBER ,
81: change_nonstd_yn OKC_K_ARTICLES_B.change_nonstd_yn%TYPE ,
82: orig_system_reference_code OKC_K_ARTICLES_B.orig_system_reference_code%TYPE ,
83: orig_system_reference_id1 NUMBER ,
84: orig_system_reference_id2 NUMBER ,
85: display_sequence NUMBER ,

Line 82: orig_system_reference_code OKC_K_ARTICLES_B.orig_system_reference_code%TYPE ,

78: amendment_description OKC_K_ARTICLES_B.amendment_description%TYPE ,
79: amendment_operation_code OKC_K_ARTICLES_B.amendment_operation_code%TYPE ,
80: article_version_id NUMBER ,
81: change_nonstd_yn OKC_K_ARTICLES_B.change_nonstd_yn%TYPE ,
82: orig_system_reference_code OKC_K_ARTICLES_B.orig_system_reference_code%TYPE ,
83: orig_system_reference_id1 NUMBER ,
84: orig_system_reference_id2 NUMBER ,
85: display_sequence NUMBER ,
86: print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE ,

Line 86: print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE ,

82: orig_system_reference_code OKC_K_ARTICLES_B.orig_system_reference_code%TYPE ,
83: orig_system_reference_id1 NUMBER ,
84: orig_system_reference_id2 NUMBER ,
85: display_sequence NUMBER ,
86: print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE ,
87: summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE ,
88: ref_article_id NUMBER ,
89: ref_article_version_id NUMBER,
90: b_sav_sae_id NUMBER,

Line 87: summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE ,

83: orig_system_reference_id1 NUMBER ,
84: orig_system_reference_id2 NUMBER ,
85: display_sequence NUMBER ,
86: print_text_yn OKC_K_ARTICLES_B.print_text_yn%TYPE ,
87: summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE ,
88: ref_article_id NUMBER ,
89: ref_article_version_id NUMBER,
90: b_sav_sae_id NUMBER,
91: last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE,

Line 91: last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE,

87: summary_amend_operation_code OKC_K_ARTICLES_B.summary_amend_operation_code%TYPE ,
88: ref_article_id NUMBER ,
89: ref_article_version_id NUMBER,
90: b_sav_sae_id NUMBER,
91: last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE,
92: last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE
93: );
94: gi_catv_rec catv_11510_rec_type;
95:

Line 92: last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE

88: ref_article_id NUMBER ,
89: ref_article_version_id NUMBER,
90: b_sav_sae_id NUMBER,
91: last_amended_by OKC_K_ARTICLES_B.LAST_AMENDED_BY%TYPE,
92: last_amendment_date OKC_K_ARTICLES_B.LAST_AMENDMENT_DATE%TYPE
93: );
94: gi_catv_rec catv_11510_rec_type;
95:
96: /*

Line 1259: FROM OKC_K_ARTICLES_B

1255: x_msg_data OUT NOCOPY VARCHAR2
1256: ) IS
1257: Cursor l_get_max_seq_csr(p_doc_type VARCHAR2, p_doc_id NUMBER,p_scn_id NUMBER) IS
1258: SELECT nvl(max(display_sequence),0)+10
1259: FROM OKC_K_ARTICLES_B
1260: WHERE DOCUMENT_TYPE= p_doc_type
1261: AND DOCUMENT_ID = p_doc_id
1262: AND SCN_ID = p_scn_id;
1263: BEGIN