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.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CASE_FOLDERS

Line 1564: l_party_id ar_cmgt_case_folders.party_id%type;

1560: l_income_taxes ar_cmgt_financial_data.income_taxes%type;
1561: l_net_income ar_cmgt_financial_data.net_income%type;
1562: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1563: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1564: l_party_id ar_cmgt_case_folders.party_id%type;
1565: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;
1566: l_site_use_id ar_cmgt_case_folders.site_use_id%type;
1567: l_limit_currency ar_cmgt_case_folders.limit_currency%type;
1568:

Line 1565: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;

1561: l_net_income ar_cmgt_financial_data.net_income%type;
1562: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1563: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1564: l_party_id ar_cmgt_case_folders.party_id%type;
1565: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;
1566: l_site_use_id ar_cmgt_case_folders.site_use_id%type;
1567: l_limit_currency ar_cmgt_case_folders.limit_currency%type;
1568:
1569: BEGIN

Line 1566: l_site_use_id ar_cmgt_case_folders.site_use_id%type;

1562: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1563: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1564: l_party_id ar_cmgt_case_folders.party_id%type;
1565: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;
1566: l_site_use_id ar_cmgt_case_folders.site_use_id%type;
1567: l_limit_currency ar_cmgt_case_folders.limit_currency%type;
1568:
1569: BEGIN
1570: IF pg_wf_debug = 'Y'

Line 1567: l_limit_currency ar_cmgt_case_folders.limit_currency%type;

1563: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1564: l_party_id ar_cmgt_case_folders.party_id%type;
1565: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;
1566: l_site_use_id ar_cmgt_case_folders.site_use_id%type;
1567: l_limit_currency ar_cmgt_case_folders.limit_currency%type;
1568:
1569: BEGIN
1570: IF pg_wf_debug = 'Y'
1571: THEN

Line 1586: FROM ar_cmgt_case_folders cmcf,

1582: cmcf.cust_account_id,
1583: nvl(hzs.cust_acct_site_id,cmcf.site_use_id),
1584: cmcf.limit_currency
1585: INTO l_party_id, l_cust_account_id, l_site_use_id, l_limit_currency
1586: FROM ar_cmgt_case_folders cmcf,
1587: hz_cust_site_uses_all hzs
1588: WHERE cmcf.case_folder_id = p_case_folder_id
1589: AND cmcf.site_use_id = hzs.site_use_id (+);
1590:

Line 1594: p_errmsg := 'Error while getting party information from ar_cmgt_case_folders'||

1590:
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: p_resultout := 1;
1594: p_errmsg := 'Error while getting party information from ar_cmgt_case_folders'||
1595: ' SqlError '|| sqlerrm;
1596: ar_cmgt_util.wf_debug(p_case_folder_id, p_errmsg);
1597: return;
1598: END;

Line 2000: FROM ar_cmgt_case_folders

1996: SELECT last_updated, -- last_credit_review_date
1997: case_folder_number,
1998: status,
1999: check_list_id
2000: FROM ar_cmgt_case_folders
2001: WHERE party_id = p_party_id
2002: AND cust_account_id = p_cust_account_id
2003: AND site_use_id = p_site_use_id
2004: AND type = 'DATA';

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 2272: FROM ar_cmgt_case_folders

2268: l_cust_account_id,
2269: l_customer_site_use_id,
2270: l_currency_code,
2271: l_credit_request_id
2272: FROM ar_cmgt_case_folders
2273: WHERE case_folder_id = p_case_folder_id;
2274: EXCEPTION
2275: WHEN others THEN
2276: l_check_flag := 'N';

Line 2807: l_case_folder_number ar_cmgt_case_folders.case_folder_number%TYPE;

2803: p_case_folder_id OUT nocopy NUMBER,
2804: p_error_msg OUT nocopy VARCHAR2,
2805: p_resultout OUT nocopy VARCHAR2) AS
2806:
2807: l_case_folder_number ar_cmgt_case_folders.case_folder_number%TYPE;
2808: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
2809: BEGIN
2810: p_resultout := 0;
2811: g_data_case_folder_exists := 'N';

Line 2808: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;

2804: p_error_msg OUT nocopy VARCHAR2,
2805: p_resultout OUT nocopy VARCHAR2) AS
2806:
2807: l_case_folder_number ar_cmgt_case_folders.case_folder_number%TYPE;
2808: l_case_folder_id ar_cmgt_case_folders.case_folder_id%TYPE;
2809: BEGIN
2810: p_resultout := 0;
2811: g_data_case_folder_exists := 'N';
2812: -- Get id from sequence

Line 2813: SELECT ar_cmgt_case_folders_s.nextval

2809: BEGIN
2810: p_resultout := 0;
2811: g_data_case_folder_exists := 'N';
2812: -- Get id from sequence
2813: SELECT ar_cmgt_case_folders_s.nextval
2814: INTO p_case_folder_id
2815: FROM dual;
2816:
2817: IF pg_wf_debug = 'Y'

Line 2860: FROM ar_cmgt_case_folders

2856:
2857: BEGIN
2858: SELECT case_folder_id
2859: INTO g_data_case_folder_id
2860: FROM ar_cmgt_case_folders
2861: WHERE party_id = p_party_id
2862: AND cust_account_id = p_cust_account_id
2863: AND site_use_id = p_cust_acct_site_id
2864: AND credit_request_id = p_credit_request_id -- Fix for bug 12613103

Line 2871: UPDATE ar_cmgt_case_folders

2867:
2868: g_data_case_folder_exists := 'Y';
2869: -- update case folder number in case data exists
2870:
2871: UPDATE ar_cmgt_case_folders
2872: set case_folder_number = l_case_folder_number,
2873: check_list_id = p_check_list_id,
2874: score_model_id = p_score_model_id,
2875: limit_currency = p_limit_currency,

Line 2892: SELECT ar_cmgt_case_folders_s.nextval

2888: g_data_case_folder_exists := 'Y';
2889: EXCEPTION
2890: WHEN NO_DATA_FOUND THEN
2891: BEGIN
2892: SELECT ar_cmgt_case_folders_s.nextval
2893: INTO g_data_case_folder_id
2894: FROM dual;
2895: g_data_case_folder_exists := 'N';
2896: AR_CMGT_CONTROLS.populate_case_folder (

Line 5962: UPDATE ar_cmgt_case_folders

5958: END IF;
5959: ELSIF p_mode = 'REFRESH'
5960: THEN
5961: -- Referesh case
5962: UPDATE ar_cmgt_case_folders
5963: set last_updated = SYSDATE,
5964: last_update_date = SYSDATE,
5965: last_updated_by = fnd_global.user_id,
5966: last_update_login = fnd_global.login_id

Line 6662: UPDATE ar_cmgt_case_folders

6658: last_update_date = sysdate,
6659: last_update_login = fnd_global.login_id
6660: WHERE case_folder_id = p_case_folder_id;
6661: END IF;
6662: UPDATE ar_cmgt_case_folders
6663: SET status = 'SAVED',
6664: last_updated = SYSDATE,
6665: last_update_date = SYSDATE,
6666: last_updated_by = fnd_global.user_id,