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

Line 27: x_ci_ver_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895

23: x_no_of_ci_plan_versions OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
24: x_ci_est_qty OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_ci_planned_qty OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
26: x_baselined_planned_qty OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
27: x_ci_ver_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
28: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE); --File.Sql.39 bug 4440895
29:
30: FUNCTION Is_Financial_Planning_Allowed(p_project_id NUMBER) RETURN VARCHAR2;
31:

Line 28: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE); --File.Sql.39 bug 4440895

24: x_ci_est_qty OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_ci_planned_qty OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
26: x_baselined_planned_qty OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
27: x_ci_ver_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
28: x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE); --File.Sql.39 bug 4440895
29:
30: FUNCTION Is_Financial_Planning_Allowed(p_project_id NUMBER) RETURN VARCHAR2;
31:
32: PROCEDURE get_finplan_ci_type_name

Line 57: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

53:
54: PROCEDURE FP_CI_GET_VERSION_DETAILS
55: (
56: p_project_id IN NUMBER,
57: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
58: x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
59: x_multi_curr_flag OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE, --File.Sql.39 bug 4440895
60: x_fin_plan_level_code OUT NOCOPY pa_proj_fp_options.all_fin_plan_level_code%TYPE, --File.Sql.39 bug 4440895
61: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 65: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895

61: x_resource_list_id OUT NOCOPY pa_proj_fp_options.all_resource_list_id%TYPE, --File.Sql.39 bug 4440895
62: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
63: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
64: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
65: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895
66: x_ci_id OUT NOCOPY pa_budget_versions.ci_id%TYPE, --File.Sql.39 bug 4440895
67: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 66: x_ci_id OUT NOCOPY pa_budget_versions.ci_id%TYPE, --File.Sql.39 bug 4440895

62: x_time_phased_code OUT NOCOPY pa_proj_fp_options.all_time_phased_code%TYPE, --File.Sql.39 bug 4440895
63: x_uncategorized_flag OUT NOCOPY pa_resource_lists_all_bg.uncategorized_flag%TYPE, --File.Sql.39 bug 4440895
64: x_group_res_type_id OUT NOCOPY pa_resource_lists_all_bg.group_resource_type_id%TYPE, --File.Sql.39 bug 4440895
65: x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE, --File.Sql.39 bug 4440895
66: x_ci_id OUT NOCOPY pa_budget_versions.ci_id%TYPE, --File.Sql.39 bug 4440895
67: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
70: ) ;

Line 107: ( p_project_id IN pa_budget_versions.project_id%TYPE

103: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
104: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
105:
106: PROCEDURE Is_Create_CI_Version_Allowed
107: ( p_project_id IN pa_budget_versions.project_id%TYPE
108: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
109: ,p_version_type IN pa_budget_versions.version_type%TYPE
110: ,p_impacted_task_id IN pa_tasks.task_id%TYPE
111: ,x_version_allowed_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 109: ,p_version_type IN pa_budget_versions.version_type%TYPE

105:
106: PROCEDURE Is_Create_CI_Version_Allowed
107: ( p_project_id IN pa_budget_versions.project_id%TYPE
108: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
109: ,p_version_type IN pa_budget_versions.version_type%TYPE
110: ,p_impacted_task_id IN pa_tasks.task_id%TYPE
111: ,x_version_allowed_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
113: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 153: ,p_version_type IN pa_budget_versions.version_type%TYPE

149:
150: PROCEDURE CHK_APRV_CUR_WORKING_BV_EXISTS
151: ( p_project_id IN pa_projects_all.project_id%TYPE
152: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
153: ,p_version_type IN pa_budget_versions.version_type%TYPE
154: ,x_cur_work_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
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: ,x_cur_work_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

150: PROCEDURE CHK_APRV_CUR_WORKING_BV_EXISTS
151: ( p_project_id IN pa_projects_all.project_id%TYPE
152: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
153: ,p_version_type IN pa_budget_versions.version_type%TYPE
154: ,x_cur_work_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
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_source_bv_id IN pa_budget_versions.budget_version_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 COMPARE_SOURCE_TARGET_VER_ATTR
160: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE
161: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE
162: ,x_attributes_same_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 161: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE

157: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
158:
159: PROCEDURE COMPARE_SOURCE_TARGET_VER_ATTR
160: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE
161: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE
162: ,x_attributes_same_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
165: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 185: ,p_source_version_type IN pa_budget_versions.version_type%TYPE

181: (
182: p_source_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE
183: ,p_source_time_phased_code IN pa_proj_fp_options.all_time_phased_code%TYPE
184: ,p_source_resource_list_id IN pa_proj_fp_options.all_resource_list_id%TYPE
185: ,p_source_version_type IN pa_budget_versions.version_type%TYPE
186: ,p_project_id IN pa_budget_versions.project_id%TYPE
187: ,p_s_ci_id IN pa_budget_versions.ci_id%TYPE
188: ,p_multiple_plan_types_flag IN VARCHAR2 DEFAULT 'N'
189: ,x_copy_possible_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 186: ,p_project_id IN pa_budget_versions.project_id%TYPE

182: p_source_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE
183: ,p_source_time_phased_code IN pa_proj_fp_options.all_time_phased_code%TYPE
184: ,p_source_resource_list_id IN pa_proj_fp_options.all_resource_list_id%TYPE
185: ,p_source_version_type IN pa_budget_versions.version_type%TYPE
186: ,p_project_id IN pa_budget_versions.project_id%TYPE
187: ,p_s_ci_id IN pa_budget_versions.ci_id%TYPE
188: ,p_multiple_plan_types_flag IN VARCHAR2 DEFAULT 'N'
189: ,x_copy_possible_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
190: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 187: ,p_s_ci_id IN pa_budget_versions.ci_id%TYPE

183: ,p_source_time_phased_code IN pa_proj_fp_options.all_time_phased_code%TYPE
184: ,p_source_resource_list_id IN pa_proj_fp_options.all_resource_list_id%TYPE
185: ,p_source_version_type IN pa_budget_versions.version_type%TYPE
186: ,p_project_id IN pa_budget_versions.project_id%TYPE
187: ,p_s_ci_id IN pa_budget_versions.ci_id%TYPE
188: ,p_multiple_plan_types_flag IN VARCHAR2 DEFAULT 'N'
189: ,x_copy_possible_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
190: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
191: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 209: ( p_project_id IN pa_budget_versions.project_id%TYPE

205: /* Added the following procedure for bug #2651851. This procedure is used for Review
206: and Submit of Control Items. */
207:
208: PROCEDURE FP_CI_IMPACT_SUBMIT_CHK
209: ( p_project_id IN pa_budget_versions.project_id%TYPE
210: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
211: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
212: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
213: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 210: ,p_ci_id IN pa_budget_versions.ci_id%TYPE

206: and Submit of Control Items. */
207:
208: PROCEDURE FP_CI_IMPACT_SUBMIT_CHK
209: ( p_project_id IN pa_budget_versions.project_id%TYPE
210: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
211: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
212: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
213: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
214:

Line 222: p_project_id IN pa_budget_versions.project_id%TYPE,

218: */
219: --Bug 3550073. Included x_upd_cost_impact_allowed and x_upd_rev_impact_allowed
220: PROCEDURE FP_CI_VALIDATE_UPDATE_IMPACT
221: (
222: p_project_id IN pa_budget_versions.project_id%TYPE,
223: p_ci_id IN pa_control_items.ci_id%TYPE,
224: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
225: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
226: x_upd_cost_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 224: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

220: PROCEDURE FP_CI_VALIDATE_UPDATE_IMPACT
221: (
222: p_project_id IN pa_budget_versions.project_id%TYPE,
223: p_ci_id IN pa_control_items.ci_id%TYPE,
224: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
225: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
226: x_upd_cost_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
227: x_upd_rev_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
228: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 225: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,

221: (
222: p_project_id IN pa_budget_versions.project_id%TYPE,
223: p_ci_id IN pa_control_items.ci_id%TYPE,
224: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
225: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
226: x_upd_cost_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
227: x_upd_rev_impact_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
228: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
229: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 235: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

231: );
232:
233: procedure chk_res_resgrp_mismatch(
234: p_project_id in number,
235: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
236: p_s_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,
237: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
238: p_t_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,
239: p_calling_mode in varchar2,

Line 237: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

233: procedure chk_res_resgrp_mismatch(
234: p_project_id in number,
235: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
236: p_s_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,
237: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
238: p_t_fin_plan_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE,
239: p_calling_mode in varchar2,
240: x_res_resgr_mismatch_flag OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
241: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 247: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

243: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
244:
245: procedure chk_tsk_plan_level_mismatch(
246: p_project_id in number,
247: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
248: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
249: p_calling_mode in varchar2,
250: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
251: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 248: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

244:
245: procedure chk_tsk_plan_level_mismatch(
246: p_project_id in number,
247: p_s_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
248: p_t_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
249: p_calling_mode in varchar2,
250: x_tsk_plan_level_mismatch OUT NOCOPY varchar2, --File.Sql.39 bug 4440895
251: x_s_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
252: x_t_task_id_tbl OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 275: ,p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

271:
272: -- This procedure will reutrn data for populating Plan Summary Region
273: PROCEDURE get_summary_data
274: ( p_project_id IN NUMBER
275: ,p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
276: ,p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
277: ,p_page_context IN VARCHAR2
278: ,p_calling_mode IN VARCHAR2 DEFAULT 'APPROVED' --Bug 5278200 kchaitan
279: ,x_context OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 276: ,p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

272: -- This procedure will reutrn data for populating Plan Summary Region
273: PROCEDURE get_summary_data
274: ( p_project_id IN NUMBER
275: ,p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
276: ,p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
277: ,p_page_context IN VARCHAR2
278: ,p_calling_mode IN VARCHAR2 DEFAULT 'APPROVED' --Bug 5278200 kchaitan
279: ,x_context OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
280: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895

Line 298: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type

294: );
295:
296: -- This procedure will return the revenue amount,
297: FUNCTION get_labor_qty_partial(
298: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
300: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
301: p_labor_qty IN pa_budget_versions.labor_quantity%TYPE DEFAULT NULL, -- CI qty
302: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL

Line 299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

295:
296: -- This procedure will return the revenue amount,
297: FUNCTION get_labor_qty_partial(
298: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
300: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
301: p_labor_qty IN pa_budget_versions.labor_quantity%TYPE DEFAULT NULL, -- CI qty
302: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
303: )

Line 300: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,

296: -- This procedure will return the revenue amount,
297: FUNCTION get_labor_qty_partial(
298: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
300: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
301: p_labor_qty IN pa_budget_versions.labor_quantity%TYPE DEFAULT NULL, -- CI qty
302: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
303: )
304: RETURN NUMBER;

Line 301: p_labor_qty IN pa_budget_versions.labor_quantity%TYPE DEFAULT NULL, -- CI qty

297: FUNCTION get_labor_qty_partial(
298: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
299: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
300: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
301: p_labor_qty IN pa_budget_versions.labor_quantity%TYPE DEFAULT NULL, -- CI qty
302: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
303: )
304: RETURN NUMBER;
305:

Line 307: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type

303: )
304: RETURN NUMBER;
305:
306: FUNCTION get_equip_qty_partial(
307: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
308: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
309: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
310: p_equip_qty IN pa_budget_versions.equipment_quantity%TYPE DEFAULT NULL, -- CI qty
311: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL

Line 308: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

304: RETURN NUMBER;
305:
306: FUNCTION get_equip_qty_partial(
307: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
308: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
309: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
310: p_equip_qty IN pa_budget_versions.equipment_quantity%TYPE DEFAULT NULL, -- CI qty
311: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
312: )

Line 309: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,

305:
306: FUNCTION get_equip_qty_partial(
307: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
308: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
309: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
310: p_equip_qty IN pa_budget_versions.equipment_quantity%TYPE DEFAULT NULL, -- CI qty
311: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
312: )
313: RETURN NUMBER;

Line 310: p_equip_qty IN pa_budget_versions.equipment_quantity%TYPE DEFAULT NULL, -- CI qty

306: FUNCTION get_equip_qty_partial(
307: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
308: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
309: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
310: p_equip_qty IN pa_budget_versions.equipment_quantity%TYPE DEFAULT NULL, -- CI qty
311: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
312: )
313: RETURN NUMBER;
314:

Line 316: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type

312: )
313: RETURN NUMBER;
314:
315: FUNCTION get_pc_revenue_partial (
316: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
317: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
318: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
319: p_revenue IN pa_budget_versions.total_project_revenue%TYPE DEFAULT NULL,
320: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL

Line 317: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

313: RETURN NUMBER;
314:
315: FUNCTION get_pc_revenue_partial (
316: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
317: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
318: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
319: p_revenue IN pa_budget_versions.total_project_revenue%TYPE DEFAULT NULL,
320: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
321: )

Line 318: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,

314:
315: FUNCTION get_pc_revenue_partial (
316: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
317: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
318: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
319: p_revenue IN pa_budget_versions.total_project_revenue%TYPE DEFAULT NULL,
320: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
321: )
322: RETURN NUMBER;

Line 319: p_revenue IN pa_budget_versions.total_project_revenue%TYPE DEFAULT NULL,

315: FUNCTION get_pc_revenue_partial (
316: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
317: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
318: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
319: p_revenue IN pa_budget_versions.total_project_revenue%TYPE DEFAULT NULL,
320: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
321: )
322: RETURN NUMBER;
323:

Line 325: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type

321: )
322: RETURN NUMBER;
323:
324: FUNCTION get_pc_cost (
325: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
326: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
327: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
328: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL ,
329: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,

Line 326: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

322: RETURN NUMBER;
323:
324: FUNCTION get_pc_cost (
325: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
326: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
327: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
328: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL ,
329: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,
330: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL

Line 327: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,

323:
324: FUNCTION get_pc_cost (
325: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
326: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
327: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
328: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL ,
329: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,
330: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
331: )

Line 328: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL ,

324: FUNCTION get_pc_cost (
325: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
326: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
327: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
328: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL ,
329: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,
330: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
331: )
332: RETURN NUMBER;

Line 329: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,

325: p_version_type IN pa_budget_versions.version_type%TYPE, -- This is the CI version type
326: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
327: p_ci_version_id IN pa_budget_versions.budget_version_id%TYPE,
328: p_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE DEFAULT NULL ,
329: p_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE DEFAULT NULL,
330: p_pt_ct_version_type IN pa_pt_co_impl_statuses.version_type%TYPE DEFAULT NULL
331: )
332: RETURN NUMBER;
333:

Line 336: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

332: RETURN NUMBER;
333:
334: PROCEDURE get_not_included
335: ( p_project_id IN NUMBER
336: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
337: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
338: ,p_version_type IN pa_budget_versions.version_type%TYPE
339: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
340: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 337: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

333:
334: PROCEDURE get_not_included
335: ( p_project_id IN NUMBER
336: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
337: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
338: ,p_version_type IN pa_budget_versions.version_type%TYPE
339: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
340: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
341: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 338: ,p_version_type IN pa_budget_versions.version_type%TYPE

334: PROCEDURE get_not_included
335: ( p_project_id IN NUMBER
336: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
337: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
338: ,p_version_type IN pa_budget_versions.version_type%TYPE
339: ,x_summary_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_150_TBL_TYPE --File.Sql.39 bug 4440895
340: ,x_equipment_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
341: ,x_labor_hours_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
342: ,x_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 363: P_project_id IN Pa_budget_versions.project_id%TYPE, -- Id of the Project

359: /* Returns the plan types into which a change order can be implemented along with other information */
360: -- Added New Params for Quantity in GET_PLAN_TYPES_FOR_IMPL - Bug 3902176
361: PROCEDURE GET_PLAN_TYPES_FOR_IMPL
362: (P_ci_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE, -- Id of the Change Document
363: P_project_id IN Pa_budget_versions.project_id%TYPE, -- Id of the Project
364: X_pt_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for fin plan type ids --File.Sql.39 bug 4440895
365: X_pt_name_tbl OUT NOCOPY SYSTEM.pa_varchar2_150_tbl_type, -- Plsql table for fin plan type names --File.Sql.39 bug 4440895
366: x_cost_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895
367: x_rev_impact_impl_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, --File.Sql.39 bug 4440895

Line 387: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895

383: X_all_bv_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, -- Plsql table for all bv id --File.Sql.39 bug 4440895
384: X_select_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- The flag which indicates whether the select flag can be checked by default or not --File.Sql.39 bug 4440895
385: X_agreement_num OUT NOCOPY Pa_agreements_all.agreement_num%TYPE, -- Agreement number of the agreement --File.Sql.39 bug 4440895
386: X_partially_impl_flag OUT NOCOPY VARCHAR2, -- A flag that indicates whether a partially implemented CO exists for the plan type or not. Possible values are Y/N --File.Sql.39 bug 4440895
387: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
388: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895
389: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895
390: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895
391: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895

Line 388: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895

384: X_select_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- The flag which indicates whether the select flag can be checked by default or not --File.Sql.39 bug 4440895
385: X_agreement_num OUT NOCOPY Pa_agreements_all.agreement_num%TYPE, -- Agreement number of the agreement --File.Sql.39 bug 4440895
386: X_partially_impl_flag OUT NOCOPY VARCHAR2, -- A flag that indicates whether a partially implemented CO exists for the plan type or not. Possible values are Y/N --File.Sql.39 bug 4440895
387: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
388: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895
389: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895
390: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895
391: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895
392: x_rem_equip_qty OUT NOCOPY pa_budget_versions.equipment_quantity%TYPE, --File.Sql.39 bug 4440895

Line 389: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895

385: X_agreement_num OUT NOCOPY Pa_agreements_all.agreement_num%TYPE, -- Agreement number of the agreement --File.Sql.39 bug 4440895
386: X_partially_impl_flag OUT NOCOPY VARCHAR2, -- A flag that indicates whether a partially implemented CO exists for the plan type or not. Possible values are Y/N --File.Sql.39 bug 4440895
387: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
388: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895
389: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895
390: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895
391: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895
392: x_rem_equip_qty OUT NOCOPY pa_budget_versions.equipment_quantity%TYPE, --File.Sql.39 bug 4440895
393: X_autobaseline_project OUT NOCOPY VARCHAR2, -- This flag will be set to Y if the project is enabled for autobaseline --File.Sql.39 bug 4440895

Line 390: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895

386: X_partially_impl_flag OUT NOCOPY VARCHAR2, -- A flag that indicates whether a partially implemented CO exists for the plan type or not. Possible values are Y/N --File.Sql.39 bug 4440895
387: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
388: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895
389: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895
390: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895
391: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895
392: x_rem_equip_qty OUT NOCOPY pa_budget_versions.equipment_quantity%TYPE, --File.Sql.39 bug 4440895
393: X_autobaseline_project OUT NOCOPY VARCHAR2, -- This flag will be set to Y if the project is enabled for autobaseline --File.Sql.39 bug 4440895
394: X_disable_baseline_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Disable Baseline Checkbox Flag --File.Sql.39 bug 4440895

Line 391: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895

387: X_cost_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci cost Budget version id --File.Sql.39 bug 4440895
388: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895
389: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895
390: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895
391: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895
392: x_rem_equip_qty OUT NOCOPY pa_budget_versions.equipment_quantity%TYPE, --File.Sql.39 bug 4440895
393: X_autobaseline_project OUT NOCOPY VARCHAR2, -- This flag will be set to Y if the project is enabled for autobaseline --File.Sql.39 bug 4440895
394: X_disable_baseline_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Disable Baseline Checkbox Flag --File.Sql.39 bug 4440895
395: x_return_status OUT NOCOPY VARCHAR2, -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 392: x_rem_equip_qty OUT NOCOPY pa_budget_versions.equipment_quantity%TYPE, --File.Sql.39 bug 4440895

388: X_rev_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci rev Budget version id --File.Sql.39 bug 4440895
389: X_all_ci_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE, -- Ci all Budget version id --File.Sql.39 bug 4440895
390: x_rem_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE, -- Remaining revenue amount to be implemented --File.Sql.39 bug 4440895
391: x_rem_labor_qty OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE, --File.Sql.39 bug 4440895
392: x_rem_equip_qty OUT NOCOPY pa_budget_versions.equipment_quantity%TYPE, --File.Sql.39 bug 4440895
393: X_autobaseline_project OUT NOCOPY VARCHAR2, -- This flag will be set to Y if the project is enabled for autobaseline --File.Sql.39 bug 4440895
394: X_disable_baseline_flag_tbl OUT NOCOPY SYSTEM.pa_varchar2_1_tbl_type, -- Plsql table for Disable Baseline Checkbox Flag --File.Sql.39 bug 4440895
395: x_return_status OUT NOCOPY VARCHAR2, -- Indicates the exit status of the API --File.Sql.39 bug 4440895
396: x_msg_data OUT NOCOPY VARCHAR2, -- Indicates the error occurred --File.Sql.39 bug 4440895

Line 402: PROCEDURE GET_CI_VERSIONS(P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Controm item id of the change document

398:
399:
400: /* Returns the Ids of the versions created for this Change Document. The ID will be -1 if the version can never be there */
401:
402: PROCEDURE GET_CI_VERSIONS(P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Controm item id of the change document
403: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
404: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
405: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 403: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895

399:
400: /* Returns the Ids of the versions created for this Change Document. The ID will be -1 if the version can never be there */
401:
402: PROCEDURE GET_CI_VERSIONS(P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Controm item id of the change document
403: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
404: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
405: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
407: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895

Line 404: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895

400: /* Returns the Ids of the versions created for this Change Document. The ID will be -1 if the version can never be there */
401:
402: PROCEDURE GET_CI_VERSIONS(P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Controm item id of the change document
403: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
404: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
405: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
407: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
408: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895

Line 405: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895

401:
402: PROCEDURE GET_CI_VERSIONS(P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Controm item id of the change document
403: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
404: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
405: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895
406: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
407: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
408: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895
409:

Line 411: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project

407: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
408: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895
409:
410: PROCEDURE GET_IMPL_DETAILS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan type
411: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
412: ,P_app_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE DEFAULT NULL -- Indicates whether the plan type passed is approved rev_plan_type or not. If the value is NULL the value will be derived
413: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order

Line 412: ,P_app_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE DEFAULT NULL -- Indicates whether the plan type passed is approved rev_plan_type or not. If the value is NULL the value will be derived

408: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895
409:
410: PROCEDURE GET_IMPL_DETAILS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan type
411: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
412: ,P_app_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE DEFAULT NULL -- Indicates whether the plan type passed is approved rev_plan_type or not. If the value is NULL the value will be derived
413: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version

Line 413: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order

409:
410: PROCEDURE GET_IMPL_DETAILS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan type
411: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
412: ,P_app_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE DEFAULT NULL -- Indicates whether the plan type passed is approved rev_plan_type or not. If the value is NULL the value will be derived
413: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
417: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version

Line 416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version

412: ,P_app_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE DEFAULT NULL -- Indicates whether the plan type passed is approved rev_plan_type or not. If the value is NULL the value will be derived
413: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
417: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
418: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version
419: ,p_targ_bv_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the target budget version. Bug 3745163
420: ,x_cost_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the cost impact can be implemented --File.Sql.39 bug 4440895

Line 417: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version

413: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE -- Id of the Change Order
414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
417: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
418: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version
419: ,p_targ_bv_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the target budget version. Bug 3745163
420: ,x_cost_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the cost impact can be implemented --File.Sql.39 bug 4440895
421: ,x_rev_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the rev impact can be implemented --File.Sql.39 bug 4440895

Line 418: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version

414: ,p_ci_type_id IN pa_control_items.ci_type_id%TYPE DEFAULT NULL
415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
417: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
418: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version
419: ,p_targ_bv_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the target budget version. Bug 3745163
420: ,x_cost_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the cost impact can be implemented --File.Sql.39 bug 4440895
421: ,x_rev_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the rev impact can be implemented --File.Sql.39 bug 4440895
422: ,X_cost_impact_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the impact is completely implemented --File.Sql.39 bug 4440895

Line 419: ,p_targ_bv_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the target budget version. Bug 3745163

415: ,P_ci_status IN Pa_control_items.status_code%TYPE DEFAULT NULL -- Status of the Change Order
416: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Cost ci version
417: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the Revenue ci version
418: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the All ci version
419: ,p_targ_bv_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- Id of the target budget version. Bug 3745163
420: ,x_cost_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the cost impact can be implemented --File.Sql.39 bug 4440895
421: ,x_rev_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the rev impact can be implemented --File.Sql.39 bug 4440895
422: ,X_cost_impact_impl_flag OUT NOCOPY VARCHAR2 -- Contains 'Y' if the impact is completely implemented --File.Sql.39 bug 4440895
423: ,x_rev_impact_impl_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

439: --populated in both x_app_cost_cw_ver_id and x_app_rev_cw_ver_id
440: --If the current working versions do not exist then null will be returned
441: PROCEDURE get_app_cw_ver_ids_for_proj
442: (p_project_id IN pa_projects_all.project_id%TYPE,
443: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
444: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
445: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
446: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
447: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

440: --If the current working versions do not exist then null will be returned
441: PROCEDURE get_app_cw_ver_ids_for_proj
442: (p_project_id IN pa_projects_all.project_id%TYPE,
443: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
444: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
445: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
446: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
447: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
448:

Line 456: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

452: --is available its not required to fetch the approved cost/rev current working ids.
453: PROCEDURE get_dtls_for_view_fin_imp_pg
454: (p_project_id IN pa_projects_all.project_id%TYPE,
455: p_ci_id IN pa_control_items.ci_id%TYPE,
456: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
457: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
460: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 457: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

453: PROCEDURE get_dtls_for_view_fin_imp_pg
454: (p_project_id IN pa_projects_all.project_id%TYPE,
455: p_ci_id IN pa_control_items.ci_id%TYPE,
456: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
457: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
460: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
461: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,

454: (p_project_id IN pa_projects_all.project_id%TYPE,
455: p_ci_id IN pa_control_items.ci_id%TYPE,
456: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
457: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
460: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
461: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
462: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895

Line 459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

455: p_ci_id IN pa_control_items.ci_id%TYPE,
456: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
457: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
460: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
461: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
462: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
463: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895

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

456: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
457: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
460: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
461: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
462: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
463: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
464: x_impact_in_mc_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

457: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
458: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,
459: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
460: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
461: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
462: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
463: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
464: x_impact_in_mc_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
465: x_targ_version_type OUT NOCOPY pa_budget_Versions.version_type%TYPE, --File.Sql.39 bug 4440895

Line 465: x_targ_version_type OUT NOCOPY pa_budget_Versions.version_type%TYPE, --File.Sql.39 bug 4440895

461: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
462: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
463: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
464: x_impact_in_mc_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
465: x_targ_version_type OUT NOCOPY pa_budget_Versions.version_type%TYPE, --File.Sql.39 bug 4440895
466: x_show_resources_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
467: x_plan_class_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
468: x_report_cost_using OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
469: x_cost_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 493: ,p_ci_id IN pa_budget_versions.ci_id%TYPE

489: All the lines of a revenue change order version will be in a single currency
490: */
491: PROCEDURE get_txn_curr_code_of_ci_ver(
492: p_project_id IN pa_projects_all.project_id%TYPE
493: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
494: ,x_txn_currency_code OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
495: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
496: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
497: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

491: PROCEDURE get_txn_curr_code_of_ci_ver(
492: p_project_id IN pa_projects_all.project_id%TYPE
493: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
494: ,x_txn_currency_code OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
495: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
496: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
497: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
498: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
499: ) ;