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_FIN_PLAN_PVT dependencies on PA_BUDGET_VERSIONS

Line 13: ci_plan_version_id pa_budget_versions.budget_version_id%TYPE,

9: */
10:
11: TYPE ci_rec IS RECORD (
12: ci_id pa_control_items.ci_id%TYPE,
13: ci_plan_version_id pa_budget_versions.budget_version_id%TYPE,
14: ci_impact_id pa_ci_impacts.ci_impact_id%TYPE,
15: record_version_number pa_ci_impacts.record_version_number%TYPE,
16: version_type pa_fp_merged_ctrl_items.version_type%TYPE,
17: impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,

Line 28: rev_partially_impl_flag pa_budget_versions.rev_partially_impl_flag%TYPE);

24: impl_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
25: impl_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE,
26: impl_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
27: impl_agr_revenue pa_fp_merged_ctrl_items.impl_agr_revenue%TYPE,
28: rev_partially_impl_flag pa_budget_versions.rev_partially_impl_flag%TYPE);
29:
30:
31: /* Table definition for constituents of the budget_lines_tab starts */
32:

Line 112: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

108: --g_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab; Commented for bug 2672654
109:
110:
111: PROCEDURE lock_unlock_version
112: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
113: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
114: p_action IN VARCHAR2, -- 'L' for lock, 'U' for unlock
115: p_user_id IN NUMBER,
116: p_person_id IN NUMBER, -- can be null

Line 113: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

109:
110:
111: PROCEDURE lock_unlock_version
112: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
113: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
114: p_action IN VARCHAR2, -- 'L' for lock, 'U' for unlock
115: p_user_id IN NUMBER,
116: p_person_id IN NUMBER, -- can be null
117: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 124: (p_project_id IN pa_budget_versions.project_id%TYPE,

120: p_unlock_locked_ver_flag IN VARCHAR2 DEFAULT NULL);
121:
122:
123: PROCEDURE Baseline_FinPlan
124: (p_project_id IN pa_budget_versions.project_id%TYPE,
125: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
126: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
127: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE default null,
128: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE default null,

Line 125: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

121:
122:
123: PROCEDURE Baseline_FinPlan
124: (p_project_id IN pa_budget_versions.project_id%TYPE,
125: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
126: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
127: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE default null,
128: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE default null,
129: p_verify_budget_rules IN VARCHAR2 DEFAULT 'Y',

Line 126: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

122:
123: PROCEDURE Baseline_FinPlan
124: (p_project_id IN pa_budget_versions.project_id%TYPE,
125: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
126: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
127: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE default null,
128: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE default null,
129: p_verify_budget_rules IN VARCHAR2 DEFAULT 'Y',
130: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 127: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE default null,

123: PROCEDURE Baseline_FinPlan
124: (p_project_id IN pa_budget_versions.project_id%TYPE,
125: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
126: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
127: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE default null,
128: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE default null,
129: p_verify_budget_rules IN VARCHAR2 DEFAULT 'Y',
130: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
131: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 128: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE default null,

124: (p_project_id IN pa_budget_versions.project_id%TYPE,
125: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
126: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
127: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE default null,
128: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE default null,
129: p_verify_budget_rules IN VARCHAR2 DEFAULT 'Y',
130: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
131: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
132: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 136: (p_project_id IN pa_budget_versions.project_id%TYPE,

132: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
133: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
134:
135: PROCEDURE Submit_Current_Working_FinPlan
136: (p_project_id IN pa_budget_versions.project_id%TYPE,
137: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
138: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
139: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 137: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

133: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
134:
135: PROCEDURE Submit_Current_Working_FinPlan
136: (p_project_id IN pa_budget_versions.project_id%TYPE,
137: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
138: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
139: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 138: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

134:
135: PROCEDURE Submit_Current_Working_FinPlan
136: (p_project_id IN pa_budget_versions.project_id%TYPE,
137: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
138: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
139: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
142:

Line 144: ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE

140: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
142:
143: PROCEDURE Get_Included_Ci
144: ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE
145: ,p_to_bv_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
146: ,p_impact_status IN pa_ci_impacts.status_code%TYPE DEFAULT NULL
147: ,x_ci_rec_tab OUT NOCOPY pa_fin_plan_pvt.ci_rec_tab
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 145: ,p_to_bv_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

141: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
142:
143: PROCEDURE Get_Included_Ci
144: ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE
145: ,p_to_bv_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
146: ,p_impact_status IN pa_ci_impacts.status_code%TYPE DEFAULT NULL
147: ,x_ci_rec_tab OUT NOCOPY pa_fin_plan_pvt.ci_rec_tab
148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 153: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE

149: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
150: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
151:
152: PROCEDURE handle_ci_links
153: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE
154: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE
155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
157: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 154: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE

150: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
151:
152: PROCEDURE handle_ci_links
153: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE
154: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE
155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
157: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
158:

Line 160: ( p_project_id IN pa_budget_versions.project_id%TYPE

156: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
157: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
158:
159: PROCEDURE CREATE_DRAFT
160: ( p_project_id IN pa_budget_versions.project_id%TYPE
161: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
162: ,p_version_type IN pa_budget_versions.version_type%TYPE
163: -- Bug Fix: 4569365. Removed MRC code.
164: --,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE

Line 161: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

157: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
158:
159: PROCEDURE CREATE_DRAFT
160: ( p_project_id IN pa_budget_versions.project_id%TYPE
161: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
162: ,p_version_type IN pa_budget_versions.version_type%TYPE
163: -- Bug Fix: 4569365. Removed MRC code.
164: --,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
165: ,p_calling_context IN VARCHAR2

Line 162: ,p_version_type IN pa_budget_versions.version_type%TYPE

158:
159: PROCEDURE CREATE_DRAFT
160: ( p_project_id IN pa_budget_versions.project_id%TYPE
161: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
162: ,p_version_type IN pa_budget_versions.version_type%TYPE
163: -- Bug Fix: 4569365. Removed MRC code.
164: --,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
165: ,p_calling_context IN VARCHAR2
166: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

Line 167: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

163: -- Bug Fix: 4569365. Removed MRC code.
164: --,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
165: ,p_calling_context IN VARCHAR2
166: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
167: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
168: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
169: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
170: ,p_version_name IN pa_budget_versions.version_name%TYPE
171: ,p_description IN pa_budget_versions.description%TYPE

Line 170: ,p_version_name IN pa_budget_versions.version_name%TYPE

166: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
167: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
168: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
169: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
170: ,p_version_name IN pa_budget_versions.version_name%TYPE
171: ,p_description IN pa_budget_versions.description%TYPE
172: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
173: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE
174: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE

Line 171: ,p_description IN pa_budget_versions.description%TYPE

167: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
168: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
169: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
170: ,p_version_name IN pa_budget_versions.version_name%TYPE
171: ,p_description IN pa_budget_versions.description%TYPE
172: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
173: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE
174: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE
175: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE

Line 172: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

168: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
169: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
170: ,p_version_name IN pa_budget_versions.version_name%TYPE
171: ,p_description IN pa_budget_versions.description%TYPE
172: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
173: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE
174: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE
175: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE
176: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE

Line 179: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

175: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE
176: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE
177: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE
178: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
179: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
180: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
181: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

Line 180: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

176: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE
177: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE
178: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
179: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
180: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
181: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

Line 181: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

177: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE
178: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
179: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
180: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
181: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

Line 182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

178: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
179: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
180: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
181: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

Line 183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

179: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
180: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
181: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

Line 184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

180: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
181: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

Line 185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

181: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

Line 186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

182: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

Line 187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

183: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

Line 188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

184: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

Line 189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

185: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

Line 190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

186: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

Line 191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

187: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

Line 192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

188: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

Line 193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

189: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

190: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
191: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
192: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
193: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
194: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
195: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
196: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
197: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
198: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 207: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

203: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
206: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
207: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
208: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
209: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
210: -- Start of additional columns for Bug :- 2634900
211: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL

Line 208: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

204: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
205: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
206: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
207: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
208: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
209: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
210: -- Start of additional columns for Bug :- 2634900
211: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
212: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL

Line 211: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL

207: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
208: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
209: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
210: -- Start of additional columns for Bug :- 2634900
211: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
212: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
213: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
214: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
215: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL

Line 212: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL

208: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
209: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
210: -- Start of additional columns for Bug :- 2634900
211: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
212: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
213: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
214: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
215: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
216: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL

Line 213: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL

209: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
210: -- Start of additional columns for Bug :- 2634900
211: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
212: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
213: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
214: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
215: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
216: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
217: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL

Line 214: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL

210: -- Start of additional columns for Bug :- 2634900
211: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
212: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
213: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
214: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
215: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
216: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
217: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
218: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL

Line 215: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL

211: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
212: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
213: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
214: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
215: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
216: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
217: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
218: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
219: -- End of additional columns for Bug :- 2634900

Line 216: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL

212: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
213: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
214: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
215: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
216: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
217: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
218: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
219: -- End of additional columns for Bug :- 2634900
220: --Added the two flags below as part of changes to AMG for finplan model

Line 218: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL

214: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
215: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
216: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
217: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
218: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
219: -- End of additional columns for Bug :- 2634900
220: --Added the two flags below as part of changes to AMG for finplan model
221: ,p_create_new_curr_working_flag IN VARCHAR2
222: ,p_replace_current_working_flag IN VARCHAR2

Line 223: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

219: -- End of additional columns for Bug :- 2634900
220: --Added the two flags below as part of changes to AMG for finplan model
221: ,p_create_new_curr_working_flag IN VARCHAR2
222: ,p_replace_current_working_flag IN VARCHAR2
223: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
224: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
225: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
226: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
227: );

Line 235: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

231: PROCEDURE CREATE_FINPLAN_LINES
232: ( -- Bug Fix: 4569365. Removed MRC code.
233: -- p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
234: p_calling_context IN VARCHAR2
235: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
236: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
237: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
238: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
239: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 303: 2)p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

299: 2) PA_FP_CALC_PLAN_PKG.CALCULATE
300: 3) PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE
301: Parameters:
302: IN 1)p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
303: 2)p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
304: 3)p_finplan_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
305: =======================================================================*/
306: PROCEDURE ADD_FIN_PLAN_LINES
307: ( -- Bug Fix: 4569365. Removed MRC code.

Line 310: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

306: PROCEDURE ADD_FIN_PLAN_LINES
307: ( -- Bug Fix: 4569365. Removed MRC code.
308: -- p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
309: p_calling_context IN VARCHAR2
310: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
311: ,p_finplan_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
312: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
313: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
314: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895