APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_CASE_FOLDERS_S

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 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 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 (