50:
51: l_module_name VARCHAR2(200) :=
52: 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC';
53:
54: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
55: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
56: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
57: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
51: l_module_name VARCHAR2(200) :=
52: 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC';
53:
54: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
55: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
56: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
57: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
52: 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.CONVERT_TXN_AMT_TO_PC_PFC';
53:
54: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
55: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
56: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
57: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
53:
54: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
55: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
56: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
57: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
54: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
55: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
56: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
57: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
55: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
56: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
57: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
56: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
57: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
57: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
60: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
61: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
63: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
65: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
67: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
69: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
70: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
71: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
81: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
74: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
81: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
82: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
75: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
81: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
82: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
83: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
81: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
82: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
83: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
84: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
81: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
82: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
83: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
84: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
85: /* end */
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
81: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
82: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
83: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
84: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
85: /* end */
86:
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
81: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
82: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
83: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
84: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
85: /* end */
86:
87: l_count NUMBER;
80: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
81: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
82: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
83: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
84: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
85: /* end */
86:
87: l_count NUMBER;
88: l_msg_count NUMBER;
146: --Calling the conv_mc_bulk api
147: IF p_pa_debug_mode = 'Y' THEN
148: pa_fp_gen_amount_utils.fp_debug
149: (p_msg => 'Before calling
150: pa_fp_multi_currency_pkg.conv_mc_bulk',
151: p_module_name => l_module_name,
152: p_log_level => 5);
153: END IF;
154:
254: l_projfunc_cost_rate_date_tab(1) := null;
255:
256: l_user_validate_flag_tab(1) := null;
257:
258: PA_FP_MULTI_CURRENCY_PKG.CONV_MC_BULK(
259: p_resource_assignment_id_tab => l_res_asn_id_tab
260: ,p_start_date_tab => l_start_date_tab
261: ,p_end_date_tab => l_end_date_tab
262: ,p_txn_currency_code_tab => l_txn_currency_code_tab
295: END IF;
296: IF p_pa_debug_mode = 'Y' THEN
297: pa_fp_gen_amount_utils.fp_debug
298: (p_msg => 'Status after calling
299: pa_fp_multi_currency_pkg.conv_mc_bulk: '
300: ||x_return_status,
301: p_module_name => l_module_name,
302: p_log_level => 5);
303: END IF;