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 89: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */

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

Line 90: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 91: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

87: /* end */
88:
89: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
90: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
91: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
92: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
94: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
95: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 92: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;

88:
89: /* Local variables pa_fp_multi_currency_pkg.conv_mc_bulk */
90: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
91: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
92: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
94: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
95: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
96: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

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

Line 94: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

90: l_res_asn_id_tab pa_fp_multi_currency_pkg.number_type_tab;
91: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
92: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
94: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
95: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
96: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
97: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 95: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

91: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
92: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
94: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
95: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
96: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
97: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
99: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 96: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

92: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
93: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
94: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
95: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
96: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
97: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
99: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
100: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 97: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;

93: l_res_list_member_id_tab pa_fp_multi_currency_pkg.number_type_tab; /* Bug 4070849 */
94: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
95: l_txn_rw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
96: l_txn_burdend_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
97: l_txn_rev_tab pa_fp_multi_currency_pkg.number_type_tab;
98: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
99: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
100: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
101: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 98: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

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

Line 99: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

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

Line 100: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 101: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

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

Line 102: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

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

Line 103: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 104: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

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

Line 105: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 106: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 107: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 108: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

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

Line 109: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 110: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 111: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 112: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

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

Line 113: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

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

Line 114: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

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

Line 115: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 116: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

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

Line 117: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

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

Line 118: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 119: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

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

Line 120: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

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

Line 153: l_ins_pfc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 154: l_ins_pfc_burd_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 155: l_ins_pfc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 156: l_ins_pfc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

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

Line 157: l_ins_pc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 158: l_ins_pc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 159: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

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

Line 160: l_ins_pc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

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

Line 1073: pa_fp_multi_currency_pkg.conv_mc_bulk',

1069: IF p_pa_debug_mode = 'Y' THEN
1070: pa_fp_gen_amount_utils.fp_debug
1071: (p_called_mode => p_calling_context,
1072: p_msg => 'Before calling
1073: pa_fp_multi_currency_pkg.conv_mc_bulk',
1074: p_module_name => l_module_name,
1075: p_log_level => 5);
1076: END IF;
1077:

Line 1109: PA_FP_MULTI_CURRENCY_PKG.CONV_MC_BULK(

1105: l_proj_rev_rate_tab.delete;
1106: l_proj_rev_rate_date_tab.delete;
1107: l_user_validate_flag_tab.delete;
1108:
1109: PA_FP_MULTI_CURRENCY_PKG.CONV_MC_BULK(
1110: p_resource_assignment_id_tab => l_res_asn_id_tab
1111: ,p_start_date_tab => l_start_date_tab
1112: ,p_end_date_tab => l_end_date_tab
1113: ,p_txn_currency_code_tab => l_txn_currency_code_tab

Line 1151: pa_fp_multi_currency_pkg.conv_mc_bulk: '

1147: IF p_pa_debug_mode = 'Y' THEN
1148: pa_fp_gen_amount_utils.fp_debug
1149: (p_called_mode => p_calling_context,
1150: p_msg => 'Status after calling
1151: pa_fp_multi_currency_pkg.conv_mc_bulk: '
1152: ||x_return_status,
1153: p_module_name => l_module_name,
1154: p_log_level => 5);
1155: END IF;