APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CASE_FOLDERS_S

Line 1418: l_site_use_id ar_cmgt_case_folders.site_use_id%type;

1414: l_earnings_per_share ar_cmgt_financial_data.earnings_per_share%type;
1415: l_financial_data_id ar_cmgt_financial_data.financial_data_id%type;
1416: l_party_id ar_cmgt_case_folders.party_id%type;
1417: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;
1418: l_site_use_id ar_cmgt_case_folders.site_use_id%type;
1419: l_limit_currency ar_cmgt_case_folders.limit_currency%type;
1420:
1421: BEGIN
1422: IF pg_wf_debug = 'Y'

Line 2665: SELECT ar_cmgt_case_folders_s.nextval

2661: BEGIN
2662: p_resultout := 0;
2663: g_data_case_folder_exists := 'N';
2664: -- Get id from sequence
2665: SELECT ar_cmgt_case_folders_s.nextval
2666: INTO p_case_folder_id
2667: FROM dual;
2668:
2669: IF pg_wf_debug = 'Y'

Line 2743: SELECT ar_cmgt_case_folders_s.nextval

2739: g_data_case_folder_exists := 'Y';
2740: EXCEPTION
2741: WHEN NO_DATA_FOUND THEN
2742: BEGIN
2743: SELECT ar_cmgt_case_folders_s.nextval
2744: INTO g_data_case_folder_id
2745: FROM dual;
2746: g_data_case_folder_exists := 'N';
2747: AR_CMGT_CONTROLS.populate_case_folder (