APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CF_DTLS

Line 80: p_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;

76:
77: EXCEPTION
78: WHEN OTHERS THEN
79: p_resultout := 1;
80: p_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;
81: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
82: END build_case_folder_details;
83:
84: PROCEDURE build_case_folder_adp_details(

Line 163: x_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;

159: END IF;
160: EXCEPTION
161: WHEN OTHERS THEN
162: x_resultout := 1;
163: x_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;
164: ar_cmgt_util.wf_debug(p_case_folder_id, x_error_msg);
165: END build_case_folder_adp_details;
166:
167: PROCEDURE GetDeductionDataPoints ( -- bug 3691676

Line 1174: FROM ar_cmgt_cf_dtls

1170: l_rec_bal NUMBER;
1171:
1172: CURSOR RecBalC IS
1173: SELECT data_point_value
1174: FROM ar_cmgt_cf_dtls
1175: WHERE case_folder_id = p_case_folder_id
1176: AND data_point_id = 34; -- receivable balance
1177: BEGIN
1178: IF pg_wf_debug = 'Y'

Line 1860: FROM ar_cmgt_case_folders a, ar_cmgt_cf_dtls b

1856: AND type = 'DATA';
1857:
1858: CURSOR c_case_folder_score IS
1859: SELECT SUM(b.score) score
1860: FROM ar_cmgt_case_folders a, ar_cmgt_cf_dtls b
1861: WHERE a.party_id = p_party_id
1862: AND a.cust_account_id = p_cust_account_id
1863: AND a.site_use_id = p_site_use_id
1864: AND a.type = 'DATA'

Line 4623: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;

4619: l_case_folder_id NUMBER;
4620: l_error_msg VARCHAR2(4000);
4621: l_resultout VARCHAR2(2000);
4622: l_period ar_cmgt_setup_options.period%type;
4623: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
4624: l_start_pos NUMBER;
4625: l_end_pos NUMBER;
4626: l_combo_string VARCHAR2(100);
4627: l_data_point_id_end_pos NUMBER;

Line 6385: UPDATE ar_cmgt_cf_dtls

6381: IF p_resultout <> 0
6382: THEN
6383: -- error in generating the score, so update the score to null
6384: p_resultout := 0;
6385: UPDATE ar_cmgt_cf_dtls
6386: SET score = null,
6387: last_updated_by = fnd_global.user_id,
6388: last_update_date = sysdate,
6389: last_update_login = fnd_global.login_id

Line 6408: UPDATE ar_cmgt_cf_dtls

6404: -- update all data points value in case folder details which is included in
6405: -- checklist for type 'CASE'.
6406: IF ( p_check_list_id IS NOT NULL )
6407: THEN
6408: UPDATE ar_cmgt_cf_dtls
6409: set included_in_checklist = 'Y'
6410: WHERE case_folder_id = p_case_folder_id
6411: AND data_point_id in (
6412: SELECT data_point_id