APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CF_DTLS

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

135:
136: EXCEPTION
137: WHEN OTHERS THEN
138: p_resultout := 1;
139: p_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;
140: ar_cmgt_util.wf_debug(p_case_folder_id, p_error_msg);
141: END build_case_folder_details;
142:
143: PROCEDURE build_case_folder_adp_details(

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

218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN
221: x_resultout := 1;
222: x_error_msg := 'Unable to create/Update records in AR_CMGT_CF_DTLS for Data Point Id: '||p_data_point_id;
223: ar_cmgt_util.wf_debug(p_case_folder_id, x_error_msg);
224: END build_case_folder_adp_details;
225:
226: PROCEDURE GetDeductionDataPoints ( -- bug 3691676

Line 1237: FROM ar_cmgt_cf_dtls

1233: l_limit_currency_code ar_cmgt_credit_requests.limit_currency%type;
1234:
1235: CURSOR RecBalC IS
1236: SELECT data_point_value
1237: FROM ar_cmgt_cf_dtls
1238: WHERE case_folder_id = p_case_folder_id
1239: AND data_point_id = 34; -- receivable balance
1240: BEGIN
1241: IF pg_wf_debug = 'Y'

Line 2008: FROM ar_cmgt_case_folders a, ar_cmgt_cf_dtls b

2004: AND type = 'DATA';
2005:
2006: CURSOR c_case_folder_score IS
2007: SELECT SUM(b.score) score
2008: FROM ar_cmgt_case_folders a, ar_cmgt_cf_dtls b
2009: WHERE a.party_id = p_party_id
2010: AND a.cust_account_id = p_cust_account_id
2011: AND a.site_use_id = p_site_use_id
2012: AND a.type = 'DATA'

Line 4717: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;

4713: l_case_folder_id NUMBER;
4714: l_error_msg VARCHAR2(4000);
4715: l_resultout VARCHAR2(2000);
4716: l_period ar_cmgt_setup_options.period%type;
4717: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
4718: l_start_pos NUMBER;
4719: l_end_pos NUMBER;
4720: l_combo_string VARCHAR2(100);
4721: l_data_point_id_end_pos NUMBER;

Line 6655: UPDATE ar_cmgt_cf_dtls

6651: IF p_resultout <> 0
6652: THEN
6653: -- error in generating the score, so update the score to null
6654: p_resultout := 0;
6655: UPDATE ar_cmgt_cf_dtls
6656: SET score = null,
6657: last_updated_by = fnd_global.user_id,
6658: last_update_date = sysdate,
6659: last_update_login = fnd_global.login_id

Line 6678: UPDATE ar_cmgt_cf_dtls

6674: -- update all data points value in case folder details which is included in
6675: -- checklist for type 'CASE'.
6676: IF ( p_check_list_id IS NOT NULL )
6677: THEN
6678: UPDATE ar_cmgt_cf_dtls
6679: set included_in_checklist = 'Y'
6680: WHERE case_folder_id = p_case_folder_id
6681: AND data_point_id in (
6682: SELECT data_point_id