DBA Data[Home] [Help]

APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on PA_FP_MULTI_CURRENCY_PKG

Line 54: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */

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;

Line 55: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_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;

Line 56: l_start_date_tab pa_fp_multi_currency_pkg.date_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;

Line 57: l_end_date_tab pa_fp_multi_currency_pkg.date_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;

Line 58: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_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;

Line 59: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_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;

Line 60: l_txn_burdend_cost_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;
64: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 61: l_txn_rev_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;

Line 62: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_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;

Line 63: l_projfunc_cost_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;

Line 64: l_projfunc_cost_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;

Line 65: l_projfunc_cost_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;

Line 66: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_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;

Line 67: l_projfunc_rev_rate_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;

Line 68: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_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;

Line 69: l_projfunc_raw_cost_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;
73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 70: l_projfunc_burdened_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;

Line 71: l_projfunc_revenue_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;

Line 72: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_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;

Line 73: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_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;

Line 74: l_proj_burdened_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;
78: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 75: l_proj_revenue_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;
79: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 76: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_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;

Line 77: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_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;

Line 78: l_proj_cost_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;

Line 79: l_proj_cost_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;

Line 80: l_proj_cost_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;

Line 81: l_proj_rev_rate_type_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 */

Line 82: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_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 */
86:

Line 83: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_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:
87: l_count NUMBER;

Line 84: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_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;
88: l_msg_count NUMBER;

Line 150: pa_fp_multi_currency_pkg.conv_mc_bulk',

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:

Line 258: PA_FP_MULTI_CURRENCY_PKG.CONV_MC_BULK(

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

Line 299: pa_fp_multi_currency_pkg.conv_mc_bulk: '

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;