APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_SETUP_OPTIONS

Line 8: g_conversion_type ar_cmgt_setup_options.default_exchange_rate_type%type;

4: pg_wf_debug VARCHAR2(1) := ar_cmgt_util.get_wf_debug_flag;
5:
6: /* 9560367 */
7: g_intended_limit_currency ar_cmgt_credit_requests.limit_currency%type;
8: g_conversion_type ar_cmgt_setup_options.default_exchange_rate_type%type;
9:
10: FUNCTION get_conversion_type( p_credit_request_id IN NUMBER)
11: return VARCHAR2 IS
12:

Line 29: FROM ar_cmgt_setup_options;

25:
26: CURSOR getRateTypeFromSetup
27: IS
28: SELECT default_exchange_rate_type
29: FROM ar_cmgt_setup_options;
30:
31: l_rule_id NUMBER;
32: l_source_name VARCHAR2(50);
33: l_exchange_rate_type VARCHAR2(50);

Line 2206: FROM AR_CMGT_SETUP_OPTIONS sys,

2202: p_resultout OUT NOCOPY VARCHAR2) IS
2203:
2204: CURSOR aging_cur IS
2205: SELECT age.aging_bucket_id,age.aging_bucket_line_id
2206: FROM AR_CMGT_SETUP_OPTIONS sys,
2207: ar_aging_bucket_lines age
2208: WHERE sys.aging_bucket_id = age.aging_bucket_id;
2209:
2210: l_outstanding_balance NUMBER;

Line 2284: FROM AR_CMGT_SETUP_OPTIONS sys,

2280: SELECT age.bucket_name,
2281: default_exchange_rate_type
2282: INTO l_bucket_name,
2283: l_exchange_rate_type
2284: FROM AR_CMGT_SETUP_OPTIONS sys,
2285: ar_aging_buckets age
2286: WHERE sys.aging_bucket_id = age.aging_bucket_id;
2287: EXCEPTION
2288: WHEN others THEN

Line 4710: l_certified_dso_days ar_cmgt_setup_options.cer_dso_days%type;

4706:
4707: l_curr_array_list curr_array_type;
4708: l_check_list_id ar_cmgt_check_lists.check_list_id%type;
4709: summary_rec_str VARCHAR2(4000);
4710: l_certified_dso_days ar_cmgt_setup_options.cer_dso_days%type;
4711: l_data_point_id NUMBER;
4712: l_data_point_name ar_cmgt_data_points_vl.data_point_name%type;
4713: l_case_folder_id NUMBER;
4714: l_error_msg VARCHAR2(4000);

Line 4716: l_period ar_cmgt_setup_options.period%type;

4712: l_data_point_name ar_cmgt_data_points_vl.data_point_name%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);

Line 4729: l_exchange_rate_type ar_cmgt_setup_options.default_exchange_rate_type%type;

4725: l_limit_currency VARCHAR2(30);
4726: l_include_all_flag VARCHAR2(1);
4727: l_curr_tbl HZ_CREDIT_USAGES_PKG.curr_tbl_type;
4728: l_excl_curr_list VARCHAR2(2000);
4729: l_exchange_rate_type ar_cmgt_setup_options.default_exchange_rate_type%type;
4730: l_overall_limit NUMBER;
4731: l_cust_acct_profile_amt_id NUMBER;
4732: l_case_folder_id_1 number;
4733: l_dso number;

Line 5765: FROM ar_cmgt_setup_options;

5761: -- Get values from system parameters
5762: BEGIN
5763: SELECT period, cer_dso_days
5764: INTO l_period, l_certified_dso_days
5765: FROM ar_cmgt_setup_options;
5766:
5767: EXCEPTION
5768: WHEN OTHERS
5769: THEN