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****---------
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();
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();
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;
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;
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;
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;