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 113: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

Line 114: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

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

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

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

Line 126: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

Line 127: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

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

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

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

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

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

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

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

Line 138: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

Line 139: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

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

Line 145: ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE

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

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

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

Line 154: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE

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

Line 155: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE

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

Line 161: ( p_project_id IN pa_budget_versions.project_id%TYPE

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

Line 162: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

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

Line 163: ,p_version_type IN pa_budget_versions.version_type%TYPE

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

Line 168: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

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

Line 171: ,p_version_name IN pa_budget_versions.version_name%TYPE

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

Line 172: ,p_description IN pa_budget_versions.description%TYPE

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

Line 173: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

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

Line 180: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

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

Line 181: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

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

Line 182: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

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

Line 183: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

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

Line 184: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

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

Line 185: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

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

Line 186: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

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

Line 187: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

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

Line 188: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

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

Line 189: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

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

Line 190: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

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

Line 191: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

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

Line 192: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

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

Line 193: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

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

Line 194: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

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

Line 195: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

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

Line 208: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

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

Line 209: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 236: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

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

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

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

Line 311: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

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