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_TERMS_MULTIREC_GRP dependencies on OKC_REVIEW_UPLD_TERMS

Line 2761: l_final_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;

2757: l_dont_move Boolean;
2758: l_article_ibr VARCHAR2(1);
2759: l_article_mandatory VARCHAR2(1);
2760: l_article_text_locked VARCHAR2(1);
2761: l_final_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2762: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2763: l_doc_num_scheme NUMBER;
2764: l_user_access VARCHAR2(30);
2765: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';

Line 2762: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;

2758: l_article_ibr VARCHAR2(1);
2759: l_article_mandatory VARCHAR2(1);
2760: l_article_text_locked VARCHAR2(1);
2761: l_final_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2762: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2763: l_doc_num_scheme NUMBER;
2764: l_user_access VARCHAR2(30);
2765: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2766: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;

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

2761: l_final_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2762: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2763: l_doc_num_scheme NUMBER;
2764: l_user_access VARCHAR2(30);
2765: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2766: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2767: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2768: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2769: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;

Line 2766: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;

2762: l_temp_article_text OKC_REVIEW_UPLD_TERMS.OBJECT_TEXT%TYPE;
2763: l_doc_num_scheme NUMBER;
2764: l_user_access VARCHAR2(30);
2765: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2766: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2767: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2768: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2769: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2770: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;

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

2763: l_doc_num_scheme NUMBER;
2764: l_user_access VARCHAR2(30);
2765: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2766: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2767: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2768: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2769: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2770: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2771:

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

2764: l_user_access VARCHAR2(30);
2765: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2766: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2767: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2768: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2769: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2770: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2771:
2772: CURSOR l_get_article_text_csr(b_review_upld_terms_id NUMBER) is

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

2765: l_new_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE := 'UPDATED';
2766: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2767: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2768: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2769: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2770: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2771:
2772: CURSOR l_get_article_text_csr(b_review_upld_terms_id NUMBER) is
2773: SELECT object_text,

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

2766: l_temp_action OKC_REVIEW_UPLD_TERMS.ACTION%TYPE;
2767: l_final_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2768: l_temp_err_msg_count OKC_REVIEW_UPLD_TERMS.ERROR_MESSAGE_COUNT%TYPE := 0;
2769: l_final_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2770: l_temp_wrn_msg_count OKC_REVIEW_UPLD_TERMS.WARNING_MESSAGE_COUNT%TYPE := 0;
2771:
2772: CURSOR l_get_article_text_csr(b_review_upld_terms_id NUMBER) is
2773: SELECT object_text,
2774: action,

Line 2777: FROM okc_review_upld_terms

2773: SELECT object_text,
2774: action,
2775: NVL(error_message_count,0) error_message_count,
2776: NVL(warning_message_count,0) warning_message_count
2777: FROM okc_review_upld_terms
2778: WHERE review_upld_terms_id = b_review_upld_terms_id;
2779:
2780: --As part of fix for bug# 4779506, added this cursor replacing the previously used cursors
2781: CURSOR article_properties(b_review_upld_terms_id NUMBER) is

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

2781: CURSOR article_properties(b_review_upld_terms_id NUMBER) is
2782: SELECT av.insert_by_reference,
2783: akb.mandatory_yn,
2784: av.lock_text
2785: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb
2786: WHERE av.article_version_id = ar.article_version_id
2787: AND akb.id = ar.object_id
2788: AND ar.review_upld_terms_id = b_review_upld_terms_id;
2789:

Line 2983: UPDATE okc_review_upld_terms

2979: /**********************************************************************
2980: Update the records being merged with ACTION=MERGED (Soft Delete)
2981: ***********************************************************************/
2982: -- Added for Bug 5339759
2983: UPDATE okc_review_upld_terms
2984: SET
2985: old_review_upld_terms_id = review_upld_terms_id
2986: WHERE review_upld_terms_id = p_merge_review_tbl(i).review_upld_terms_id;
2987:

Line 2988: OKC_REVIEW_UPLD_TERMS_PVT.update_row(

2984: SET
2985: old_review_upld_terms_id = review_upld_terms_id
2986: WHERE review_upld_terms_id = p_merge_review_tbl(i).review_upld_terms_id;
2987:
2988: OKC_REVIEW_UPLD_TERMS_PVT.update_row(
2989: x_return_status => x_return_status,
2990: p_review_upld_terms_id => p_merge_review_tbl(i).review_upld_terms_id,
2991: p_action => 'MERGED',
2992: p_object_version_number => p_merge_review_tbl(i).object_version_number,

Line 3012: Update the OKC_REVIEW_UPLD_TERMS table for the first clause

3008: WHERE review_upld_terms_id = p_merge_review_tbl(i).review_upld_terms_id;
3009: END LOOP;
3010:
3011: /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
3012: Update the OKC_REVIEW_UPLD_TERMS table for the first clause
3013: * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
3014: -- Added for bug# 4897442
3015:
3016: IF(l_new_action = 'ADDED') THEN

Line 3039: OKC_REVIEW_UPLD_TERMS_PVT.update_row(

3035: FND_LOG.STRING(G_PROC_LEVEL,
3036: G_PKG_NAME, '500: l_final_wrn_msg_count : '||l_final_wrn_msg_count);
3037: END IF;
3038:
3039: OKC_REVIEW_UPLD_TERMS_PVT.update_row(
3040: x_return_status => x_return_status,
3041: p_review_upld_terms_id => p_merge_review_tbl(1).review_upld_terms_id,
3042: p_action => l_new_action,
3043: p_object_text => l_final_article_text,