eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_FP_MULTI_CURRENCY_PKG

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

86: l_revenue_rejection_code VARCHAR2(30);
87: l_cost_ind_compiled_set_id NUMBER;
88: /* end */
89:
90: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
91: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
92: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */

Line 91: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;

87: l_cost_ind_compiled_set_id NUMBER;
88: /* end */
89:
90: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
91: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
92: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711

Line 92: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

88: /* end */
89:
90: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
91: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
92: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711
96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;

89:
90: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
91: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
92: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711
96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */

90: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
91: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
92: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711
96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711

91: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
92: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711
96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

92: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711
96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

93: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711
96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

94: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711
96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;

95: l_cbs_id_tab pa_fp_multi_currency_pkg.number_type_tab; --bug#16791711
96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

96: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

97: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

98: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

99: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

100: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

101: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

102: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

103: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

104: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

105: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

106: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

107: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

108: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

109: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

110: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

111: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

112: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
120: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

113: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
120: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
121: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

114: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
120: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
121: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
122: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

115: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
120: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
121: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
122: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
123: /* end */

Line 120: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

116: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
120: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
121: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
122: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
123: /* end */
124:

Line 121: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

117: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
120: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
121: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
122: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
123: /* end */
124:
125: l_count NUMBER;

Line 122: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

118: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
119: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
120: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
121: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
122: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
123: /* end */
124:
125: l_count NUMBER;
126: l_msg_count NUMBER;

Line 155: l_ins_pfc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

151: l_ins_burd_cost_rej_code VARCHAR2(30);
152: l_ins_rev_rej_code VARCHAR2(30);
153: l_ins_cost_ind_com_set_id NUMBER;
154:
155: l_ins_pfc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
156: l_ins_pfc_burd_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
157: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 156: l_ins_pfc_burd_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

152: l_ins_rev_rej_code VARCHAR2(30);
153: l_ins_cost_ind_com_set_id NUMBER;
154:
155: l_ins_pfc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
156: l_ins_pfc_burd_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
157: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
160: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 157: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

153: l_ins_cost_ind_com_set_id NUMBER;
154:
155: l_ins_pfc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
156: l_ins_pfc_burd_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
157: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
160: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
161: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

154:
155: l_ins_pfc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
156: l_ins_pfc_burd_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
157: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
160: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
161: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
162: l_ins_pc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

155: l_ins_pfc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
156: l_ins_pfc_burd_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
157: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
160: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
161: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
162: l_ins_pc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
163:

Line 160: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

156: l_ins_pfc_burd_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
157: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
160: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
161: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
162: l_ins_pc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
163:
164: l_source_bv_id number;

Line 161: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

157: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
160: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
161: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
162: l_ins_pc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
163:
164: l_source_bv_id number;
165: l_txn_src_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;

Line 162: l_ins_pc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

158: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
159: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
160: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
161: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
162: l_ins_pc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
163:
164: l_source_bv_id number;
165: l_txn_src_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;
166: BEGIN

Line 1086: pa_fp_multi_currency_pkg.conv_mc_bulk',

1082: IF p_pa_debug_mode = 'Y' THEN
1083: pa_fp_gen_amount_utils.fp_debug
1084: (p_called_mode => p_calling_context,
1085: p_msg => 'Before calling
1086: pa_fp_multi_currency_pkg.conv_mc_bulk',
1087: p_module_name => l_module_name,
1088: p_log_level => 5);
1089: END IF;
1090:

Line 1122: PA_FP_MULTI_CURRENCY_PKG.CONV_MC_BULK(

1118: l_proj_rev_rate_tab.delete;
1119: l_proj_rev_rate_date_tab.delete;
1120: l_user_validate_flag_tab.delete;
1121:
1122: PA_FP_MULTI_CURRENCY_PKG.CONV_MC_BULK(
1123: p_resource_assignment_id_tab => l_res_asn_id_tab
1124: ,p_start_date_tab => l_start_date_tab
1125: ,p_end_date_tab => l_end_date_tab
1126: ,p_txn_currency_code_tab => l_txn_currency_code_tab

Line 1164: pa_fp_multi_currency_pkg.conv_mc_bulk: '

1160: IF p_pa_debug_mode = 'Y' THEN
1161: pa_fp_gen_amount_utils.fp_debug
1162: (p_called_mode => p_calling_context,
1163: p_msg => 'Status after calling
1164: pa_fp_multi_currency_pkg.conv_mc_bulk: '
1165: ||x_return_status,
1166: p_module_name => l_module_name,
1167: p_log_level => 5);
1168: END IF;