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.

[Home] [Help]

APPS.OKC_TERMS_MULTIREC_GRP dependencies on OKC_REVIEW_UPLD_TERMS

Line 2874: l_final_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;

2870: l_dont_move Boolean;
2871: l_article_ibr VARCHAR2(1);
2872: l_article_mandatory VARCHAR2(1);
2873: l_article_text_locked VARCHAR2(1);
2874: l_final_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2875: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2876: l_doc_num_scheme NUMBER;
2877: l_user_access VARCHAR2(30);
2878: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';

Line 2875: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;

2871: l_article_ibr VARCHAR2(1);
2872: l_article_mandatory VARCHAR2(1);
2873: l_article_text_locked VARCHAR2(1);
2874: l_final_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2875: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2876: l_doc_num_scheme NUMBER;
2877: l_user_access VARCHAR2(30);
2878: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2879: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;

Line 2878: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';

2874: l_final_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2875: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2876: l_doc_num_scheme NUMBER;
2877: l_user_access VARCHAR2(30);
2878: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2879: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2880: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2881: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2882: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;

Line 2879: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;

2875: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2876: l_doc_num_scheme NUMBER;
2877: l_user_access VARCHAR2(30);
2878: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2879: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2880: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2881: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2882: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2883: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;

Line 2880: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;

2876: l_doc_num_scheme NUMBER;
2877: l_user_access VARCHAR2(30);
2878: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2879: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2880: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2881: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2882: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2883: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2884:

Line 2881: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;

2877: l_user_access VARCHAR2(30);
2878: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2879: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2880: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2881: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2882: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2883: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2884:
2885: CURSOR l_get_article_text_csr(b_review_upld_terms_id NUMBER) is

Line 2882: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;

2878: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2879: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2880: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2881: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2882: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2883: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2884:
2885: CURSOR l_get_article_text_csr(b_review_upld_terms_id NUMBER) is
2886: SELECT object_text,

Line 2883: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;

2879: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2880: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2881: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2882: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2883: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2884:
2885: CURSOR l_get_article_text_csr(b_review_upld_terms_id NUMBER) is
2886: SELECT object_text,
2887: action,

Line 2890: FROM okc_review_upld_terms

2886: SELECT object_text,
2887: action,
2888: NVL(error_message_count,0) error_message_count,
2889: NVL(warning_message_count,0) warning_message_count
2890: FROM okc_review_upld_terms
2891: WHERE review_upld_terms_id = b_review_upld_terms_id;
2892:
2893: --As part of fix for bug# 4779506, added this cursor replacing the previously used cursors
2894: CURSOR article_properties(b_review_upld_terms_id NUMBER) is

Line 2898: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb

2894: CURSOR article_properties(b_review_upld_terms_id NUMBER) is
2895: SELECT av.insert_by_reference,
2896: akb.mandatory_yn,
2897: av.lock_text
2898: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb
2899: WHERE av.article_version_id = ar.article_version_id
2900: AND akb.id = ar.object_id
2901: AND ar.review_upld_terms_id = b_review_upld_terms_id;
2902:

Line 3096: UPDATE okc_review_upld_terms

3092: /**********************************************************************
3093: Update the records being merged with ACTION=MERGED (Soft Delete)
3094: ***********************************************************************/
3095: -- Added for Bug 5339759
3096: UPDATE okc_review_upld_terms
3097: SET
3098: old_review_upld_terms_id = review_upld_terms_id
3099: WHERE review_upld_terms_id = p_merge_review_tbl(i).review_upld_terms_id;
3100:

Line 3101: OKC_REVIEW_UPLD_TERMS_PVT.update_row(

3097: SET
3098: old_review_upld_terms_id = review_upld_terms_id
3099: WHERE review_upld_terms_id = p_merge_review_tbl(i).review_upld_terms_id;
3100:
3101: OKC_REVIEW_UPLD_TERMS_PVT.update_row(
3102: x_return_status => x_return_status,
3103: p_review_upld_terms_id => p_merge_review_tbl(i).review_upld_terms_id,
3104: p_action => 'MERGED',
3105: p_object_version_number => p_merge_review_tbl(i).object_version_number,

Line 3125: Update the OKC_REVIEW_UPLD_TERMS table for the first clause

3121: WHERE review_upld_terms_id = p_merge_review_tbl(i).review_upld_terms_id;
3122: END LOOP;
3123:
3124: /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
3125: Update the OKC_REVIEW_UPLD_TERMS table for the first clause
3126: * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
3127: -- Added for bug# 4897442
3128:
3129: IF(l_new_action = 'ADDED') THEN

Line 3152: OKC_REVIEW_UPLD_TERMS_PVT.update_row(

3148: FND_LOG.STRING(G_PROC_LEVEL,
3149: G_PKG_NAME, '500: l_final_wrn_msg_count : '||l_final_wrn_msg_count);
3150: END IF;
3151:
3152: OKC_REVIEW_UPLD_TERMS_PVT.update_row(
3153: x_return_status => x_return_status,
3154: p_review_upld_terms_id => p_merge_review_tbl(1).review_upld_terms_id,
3155: p_action => l_new_action,
3156: p_object_text => l_final_article_text,