APPS.PA_FP_CALC_PLAN_PKG dependencies on PA_FP_ROLLUP_TMP

Line 128: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE

124: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
125: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
126: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
127: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
128: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
129: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
130: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE

Line 129: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE

125: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
126: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
127: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
128: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
129: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
130: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE

Line 130: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE

126: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
127: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
128: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
129: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
130: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE

Line 131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE

127: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
128: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
129: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
130: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE

Line 132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE

128: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
129: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
130: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE

Line 133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE

129: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
130: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE

Line 134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE

130: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
138: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE

Line 135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE

131: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
138: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
139: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE

Line 136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE

132: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
138: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
139: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
140: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE

Line 137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE

133: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
138: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
139: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
140: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE
141: ,x_return_status OUT NOCOPY VARCHAR2

Line 138: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE

134: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
138: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
139: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
140: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE
141: ,x_return_status OUT NOCOPY VARCHAR2
142: ,x_msg_count OUT NOCOPY NUMBER

Line 139: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE

135: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
138: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
139: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
140: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE
141: ,x_return_status OUT NOCOPY VARCHAR2
142: ,x_msg_count OUT NOCOPY NUMBER
143: ,x_msg_data OUT NOCOPY VARCHAR2);

Line 140: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE

136: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
137: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
138: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
139: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
140: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE
141: ,x_return_status OUT NOCOPY VARCHAR2
142: ,x_msg_count OUT NOCOPY NUMBER
143: ,x_msg_data OUT NOCOPY VARCHAR2);
144:

Line 268: * Note: Before calling this API, pa_fp_rollup_tmp should be populated

264:
265:
266: /* This API calls the main wrapper RATE api and converts the amounts from txn to txn currency if
267: * cost rate and revenue rate currencies are different
268: * Note: Before calling this API, pa_fp_rollup_tmp should be populated
269: */
270: PROCEDURE Get_Res_RATEs
271: (p_calling_module IN varchar2
272: ,p_activity_code IN varchar2