DBA Data[Home] [Help]

APPS.GL_EXCH_RATES_SYNC_PKG dependencies on GL_CUR_CONV_RATE_OBJ

Line 12: p_cur_conv_rates OUT NOCOPY GL_CUR_CONV_RATE_OBJ_TBL

8: p_to_currency IN VARCHAR2 DEFAULT NULL,
9: p_from_date IN DATE,
10: p_to_date IN DATE DEFAULT SYSDATE,
11: p_conversion_rate_type IN VARCHAR2 DEFAULT NULL,
12: p_cur_conv_rates OUT NOCOPY GL_CUR_CONV_RATE_OBJ_TBL
13: )
14: IS
15: --------------------------------------------------
16: --------****Declaring Local Variables****---------

Line 18: l_dir_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();

14: IS
15: --------------------------------------------------
16: --------****Declaring Local Variables****---------
17: --------------------------------------------------
18: l_dir_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
19: l_cur_conv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
20: l_cur_conv_inv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
22: l_dir_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();

Line 19: l_cur_conv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();

15: --------------------------------------------------
16: --------****Declaring Local Variables****---------
17: --------------------------------------------------
18: l_dir_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
19: l_cur_conv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
20: l_cur_conv_inv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
22: l_dir_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
23: l_inv_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();

Line 20: l_cur_conv_inv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();

16: --------****Declaring Local Variables****---------
17: --------------------------------------------------
18: l_dir_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
19: l_cur_conv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
20: l_cur_conv_inv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
22: l_dir_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
23: l_inv_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
24: l_pivot_currency gl_cross_rate_rules.pivot_currency%TYPE;

Line 21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();

17: --------------------------------------------------
18: l_dir_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
19: l_cur_conv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
20: l_cur_conv_inv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
22: l_dir_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
23: l_inv_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
24: l_pivot_currency gl_cross_rate_rules.pivot_currency%TYPE;
25: l_description gl_cross_rate_rules.description%TYPE;

Line 22: l_dir_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();

18: l_dir_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
19: l_cur_conv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
20: l_cur_conv_inv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
22: l_dir_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
23: l_inv_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
24: l_pivot_currency gl_cross_rate_rules.pivot_currency%TYPE;
25: l_description gl_cross_rate_rules.description%TYPE;
26: l_contra_currency gl_daily_rates.from_currency%TYPE;

Line 23: l_inv_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();

19: l_cur_conv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
20: l_cur_conv_inv_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
21: l_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
22: l_dir_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
23: l_inv_cr_rates GL_CUR_CONV_RATE_OBJ_TBL := GL_CUR_CONV_RATE_OBJ_TBL();
24: l_pivot_currency gl_cross_rate_rules.pivot_currency%TYPE;
25: l_description gl_cross_rate_rules.description%TYPE;
26: l_contra_currency gl_daily_rates.from_currency%TYPE;
27: l_conversion_type gl_daily_conversion_types.conversion_type%TYPE;

Line 179: l_cur_conv_rates(l_n_dir_cntr) := GL_CUR_CONV_RATE_OBJ(rec_c_get_rates.from_currency, rec_c_get_rates.to_currency,

175: p_conversion_rate_type)
176: LOOP
177: l_cur_conv_rates.EXTEND;
178: l_n_dir_cntr := l_n_dir_cntr+1;
179: l_cur_conv_rates(l_n_dir_cntr) := GL_CUR_CONV_RATE_OBJ(rec_c_get_rates.from_currency, rec_c_get_rates.to_currency,
180: rec_c_get_rates.conversion_date, rec_c_get_rates.conversion_type,
181: rec_c_get_rates.conversion_rate, rec_c_get_rates.inv_conv_rate,
182: rec_c_get_rates.status_code, rec_c_get_rates.rate_source_code,
183: rec_c_get_rates.pivot_currency, rec_c_get_rates.description);

Line 196: l_cur_conv_inv_rates(l_n_inv_cntr) := GL_CUR_CONV_RATE_OBJ(rec_c_get_inv_rates.from_currency, rec_c_get_inv_rates.to_currency,

192: p_conversion_rate_type)
193: LOOP
194: l_cur_conv_inv_rates.EXTEND;
195: l_n_inv_cntr := l_n_inv_cntr+1;
196: l_cur_conv_inv_rates(l_n_inv_cntr) := GL_CUR_CONV_RATE_OBJ(rec_c_get_inv_rates.from_currency, rec_c_get_inv_rates.to_currency,
197: rec_c_get_inv_rates.conversion_date, rec_c_get_inv_rates.conversion_type,
198: rec_c_get_inv_rates.conversion_rate, rec_c_get_inv_rates.inv_conv_rate,
199: rec_c_get_inv_rates.status_code, rec_c_get_inv_rates.rate_source_code,
200: rec_c_get_inv_rates.pivot_currency, rec_c_get_inv_rates.description);

Line 227: l_dir_cr_rates(l_n_dir_cr_cntr) := GL_CUR_CONV_RATE_OBJ(rec_c_cr_rates.from_currency, rec_c_cr_rates.to_currency,

223: l_contra_currency)
224: LOOP
225: l_dir_cr_rates.EXTEND;
226: l_n_dir_cr_cntr := l_n_dir_cr_cntr+1;
227: l_dir_cr_rates(l_n_dir_cr_cntr) := GL_CUR_CONV_RATE_OBJ(rec_c_cr_rates.from_currency, rec_c_cr_rates.to_currency,
228: rec_c_cr_rates.conversion_date, rec_c_cr_rates.conversion_type,
229: rec_c_cr_rates.conversion_rate, rec_c_cr_rates.inv_conv_rate,
230: rec_c_cr_rates.status_code, rec_c_cr_rates.rate_source_code,
231: rec_c_cr_rates.pivot_currency, rec_c_cr_rates.description);

Line 244: l_inv_cr_rates(l_n_inv_cr_cntr) := GL_CUR_CONV_RATE_OBJ(rec_c_inv_cr_rates.from_currency, rec_c_inv_cr_rates.to_currency,

240: l_contra_currency)
241: LOOP
242: l_inv_cr_rates.EXTEND;
243: l_n_inv_cr_cntr := l_n_inv_cr_cntr+1;
244: l_inv_cr_rates(l_n_inv_cr_cntr) := GL_CUR_CONV_RATE_OBJ(rec_c_inv_cr_rates.from_currency, rec_c_inv_cr_rates.to_currency,
245: rec_c_inv_cr_rates.conversion_date, rec_c_inv_cr_rates.conversion_type,
246: rec_c_inv_cr_rates.conversion_rate, rec_c_inv_cr_rates.inv_conv_rate,
247: rec_c_inv_cr_rates.status_code, rec_c_inv_cr_rates.rate_source_code,
248: rec_c_inv_cr_rates.pivot_currency, rec_c_inv_cr_rates.description);