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

Line 36: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

32: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
33: x_error_msg_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
34:
35: function Retrieve_Record_Version_Number
36: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
37: return number;
38:
39: FUNCTION Plan_Amount_Exists
40: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

Line 40: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

36: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
37: return number;
38:
39: FUNCTION Plan_Amount_Exists
40: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
41: RETURN VARCHAR2;
42: --PRAGMA RESTRICT_REFERENCES ( Plan_Amount_Exists, WNDS, WNPS);
43:
44: /*

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

49: API Creation Date : 15-MAR-2004
50: */
51:
52: FUNCTION Plan_Amount_Exists_Task_Res
53: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE ,
54: p_task_id IN pa_tasks.task_id%TYPE Default Null,
55: p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE Default Null
56: ) RETURN VARCHAR2;
57:

Line 85: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)

81: RETURN pa_proj_fp_options.all_amount_set_id%TYPE;
82: --PRAGMA RESTRICT_REFERENCES ( Get_Amount_Set_Id, WNDS, WNPS);
83:
84: FUNCTION Get_Period_Profile_Start_Date
85: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
86: return pa_proj_period_profiles.period_name1%TYPE;
87:
88: FUNCTION Get_Period_Profile_End_Date
89: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)

Line 89: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)

85: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
86: return pa_proj_period_profiles.period_name1%TYPE;
87:
88: FUNCTION Get_Period_Profile_End_Date
89: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
90: return pa_proj_period_profiles.profile_end_period_name%TYPE;
91:
92: /* This fuction will return workplan budget version res_list_id */
93: FUNCTION Get_wp_bv_res_list_id

Line 103: (p_wp_structure_version_id IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE)

99: of the budget_version_id for a given wp_structure_version_id.
100: P->PA, G->Gl, N->None
101: ==============================================================================*/
102: FUNCTION Get_wp_bv_time_phase
103: (p_wp_structure_version_id IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE)
104: RETURN VARCHAR2;
105:
106: /*=============================================================================
107: This function will return the approved cost budget current baselined version.

Line 131: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

127: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
128:
129: PROCEDURE Get_Baselined_Version_Info(
130: p_project_id IN pa_projects_all.project_id%TYPE
131: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
132: ,p_version_type IN pa_budget_versions.version_type%TYPE
133: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 132: ,p_version_type IN pa_budget_versions.version_type%TYPE

128:
129: PROCEDURE Get_Baselined_Version_Info(
130: p_project_id IN pa_projects_all.project_id%TYPE
131: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
132: ,p_version_type IN pa_budget_versions.version_type%TYPE
133: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 157: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

153:
154:
155: PROCEDURE Get_Curr_Working_Version_Info(
156: p_project_id IN pa_projects_all.project_id%TYPE
157: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
158: ,p_version_type IN pa_budget_versions.version_type%TYPE
159: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
160: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 158: ,p_version_type IN pa_budget_versions.version_type%TYPE

154:
155: PROCEDURE Get_Curr_Working_Version_Info(
156: p_project_id IN pa_projects_all.project_id%TYPE
157: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
158: ,p_version_type IN pa_budget_versions.version_type%TYPE
159: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
160: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 209: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

205: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
206: x_message_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
207:
208: FUNCTION is_orgforecast_plan
209: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
210: return VARCHAR2;
211:
212:
213: /* Changes for FP.M, Tracking Bug No - 3354518

Line 224: P_ELEMENT_TYPE IN pa_budget_versions.version_type%TYPE)

220: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
221: */
222: FUNCTION GET_OPTION_PLANNING_LEVEL(
223: P_PROJ_FP_OPTIONS_ID IN pa_proj_fp_options.proj_fp_options_id%TYPE,
224: P_ELEMENT_TYPE IN pa_budget_versions.version_type%TYPE)
225: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE;
226:
227:
228: FUNCTION get_person_name

Line 268: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE

264: );
265:
266: PROCEDURE Check_Version_Name_Or_id
267: (
268: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE
269: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562
270: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE
271: ,p_check_id_flag IN VARCHAR2
272: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895

Line 269: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562

265:
266: PROCEDURE Check_Version_Name_Or_id
267: (
268: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE
269: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562
270: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE
271: ,p_check_id_flag IN VARCHAR2
272: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895
273: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 270: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE

266: PROCEDURE Check_Version_Name_Or_id
267: (
268: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE
269: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562
270: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE
271: ,p_check_id_flag IN VARCHAR2
272: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895
273: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
274: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

268: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE
269: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562
270: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE
271: ,p_check_id_flag IN VARCHAR2
272: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895
273: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
274: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
275: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
276: );

Line 348: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

344: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER;
345:
346: PROCEDURE Check_Locked_By_User
347: (p_user_id IN NUMBER,
348: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
349: x_is_locked_by_userid OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
350: x_locked_by_person_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
351: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
352: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 357: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,

353: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
354:
355: PROCEDURE Check_Both_Locked_By_User
356: (p_user_id IN NUMBER,
357: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
358: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
359: x_is_locked_by_userid OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
360: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
361: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 358: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,

354:
355: PROCEDURE Check_Both_Locked_By_User
356: (p_user_id IN NUMBER,
357: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
358: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
359: x_is_locked_by_userid OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
360: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
361: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
362: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 425: (p_project_id IN pa_budget_versions.project_id%TYPE

421: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
422: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
423:
424: PROCEDURE Get_Max_Budget_Version_Number
425: (p_project_id IN pa_budget_versions.project_id%TYPE
426: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
427: ,p_version_type IN pa_budget_versions.version_type%TYPE
428: ,p_copy_mode IN VARCHAR2
429: ,p_ci_id IN NUMBER

Line 426: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

422: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
423:
424: PROCEDURE Get_Max_Budget_Version_Number
425: (p_project_id IN pa_budget_versions.project_id%TYPE
426: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
427: ,p_version_type IN pa_budget_versions.version_type%TYPE
428: ,p_copy_mode IN VARCHAR2
429: ,p_ci_id IN NUMBER
430: ,p_lock_required_flag IN VARCHAR2

Line 427: ,p_version_type IN pa_budget_versions.version_type%TYPE

423:
424: PROCEDURE Get_Max_Budget_Version_Number
425: (p_project_id IN pa_budget_versions.project_id%TYPE
426: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
427: ,p_version_type IN pa_budget_versions.version_type%TYPE
428: ,p_copy_mode IN VARCHAR2
429: ,p_ci_id IN NUMBER
430: ,p_lock_required_flag IN VARCHAR2
431: ,x_version_number OUT NOCOPY pa_budget_versions.version_number%TYPE --File.Sql.39 bug 4440895

Line 431: ,x_version_number OUT NOCOPY pa_budget_versions.version_number%TYPE --File.Sql.39 bug 4440895

427: ,p_version_type IN pa_budget_versions.version_type%TYPE
428: ,p_copy_mode IN VARCHAR2
429: ,p_ci_id IN NUMBER
430: ,p_lock_required_flag IN VARCHAR2
431: ,x_version_number OUT NOCOPY pa_budget_versions.version_number%TYPE --File.Sql.39 bug 4440895
432: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
433: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
434: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
435:

Line 449: ( p_project_id IN pa_budget_versions.project_id%TYPE

445: 2)If it is REVENUE_ONLY or COST_AND_REV_SEP then it returns 'REVENUE' version
446: ===============================================================================*/
447:
448: PROCEDURE GET_REV_BASE_VERSION_INFO
449: ( p_project_id IN pa_budget_versions.project_id%TYPE
450: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
451: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
452: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
453: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 450: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE

446: ===============================================================================*/
447:
448: PROCEDURE GET_REV_BASE_VERSION_INFO
449: ( p_project_id IN pa_budget_versions.project_id%TYPE
450: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
451: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
452: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
453: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
454: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 451: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

447:
448: PROCEDURE GET_REV_BASE_VERSION_INFO
449: ( p_project_id IN pa_budget_versions.project_id%TYPE
450: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
451: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
452: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
453: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
454: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
455: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

448: PROCEDURE GET_REV_BASE_VERSION_INFO
449: ( p_project_id IN pa_budget_versions.project_id%TYPE
450: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
451: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
452: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
453: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
454: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
455: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
456:

Line 466: ( p_project_id IN pa_budget_versions.project_id%TYPE

462: 2)If it is COST_ONLY or COST_AND_REV_SEP then it returns 'COST' version
463: ===============================================================================*/
464:
465: PROCEDURE GET_COST_BASE_VERSION_INFO
466: ( p_project_id IN pa_budget_versions.project_id%TYPE
467: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
468: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
469: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
470: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 467: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE

463: ===============================================================================*/
464:
465: PROCEDURE GET_COST_BASE_VERSION_INFO
466: ( p_project_id IN pa_budget_versions.project_id%TYPE
467: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
468: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
469: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
470: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
471: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 468: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

464:
465: PROCEDURE GET_COST_BASE_VERSION_INFO
466: ( p_project_id IN pa_budget_versions.project_id%TYPE
467: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
468: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
469: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
470: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
471: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
472: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

465: PROCEDURE GET_COST_BASE_VERSION_INFO
466: ( p_project_id IN pa_budget_versions.project_id%TYPE
467: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
468: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
469: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
470: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
471: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
472: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
473:

Line 484: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

480: ( X_LOCK_NAME IN VARCHAR2 )
481: RETURN NUMBER ;
482:
483: PROCEDURE get_converted_amounts
484: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
485: ,p_txn_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
486: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
487: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE
488: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE

Line 485: ,p_txn_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE

481: RETURN NUMBER ;
482:
483: PROCEDURE get_converted_amounts
484: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
485: ,p_txn_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
486: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
487: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE
488: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE
489: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

Line 486: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE

482:
483: PROCEDURE get_converted_amounts
484: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
485: ,p_txn_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
486: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
487: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE
488: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE
489: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
490: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

Line 487: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE

483: PROCEDURE get_converted_amounts
484: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
485: ,p_txn_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
486: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
487: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE
488: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE
489: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
490: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
491: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895

Line 491: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895

487: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE
488: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE
489: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
490: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
491: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
492: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
493: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
494: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
495: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895

Line 492: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895

488: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE
489: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
490: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
491: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
492: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
493: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
494: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
495: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
496: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895

Line 493: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895

489: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
490: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
491: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
492: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
493: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
494: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
495: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
496: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
497: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 494: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895

490: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
491: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
492: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
493: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
494: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
495: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
496: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
497: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
498: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

491: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
492: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
493: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
494: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
495: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
496: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
497: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
498: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
499: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 496: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895

492: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
493: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
494: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
495: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
496: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
497: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
498: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
499: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
500:

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

595: (
596: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
597: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
598: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
599: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
600: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
601: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
602: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
603: );

Line 637: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

633: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
634: );
635:
636: FUNCTION HAS_PLANNABLE_ELEMENTS
637: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
638: RETURN VARCHAR2;
639:
640: -- This procedure is used to derive the version type given the project id and
641: -- fin plan type id

Line 645: ,px_version_type IN OUT NOCOPY pa_budget_Versions.version_type%TYPE --File.Sql.39 bug 4440895

641: -- fin plan type id
642: PROCEDURE get_version_type
643: ( p_project_id IN pa_projects_all.project_id%TYPE
644: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
645: ,px_version_type IN OUT NOCOPY pa_budget_Versions.version_type%TYPE --File.Sql.39 bug 4440895
646: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
647: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
648: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
649: );

Line 654: ,p_version_type IN pa_budget_Versions.version_type%TYPE

650:
651: PROCEDURE get_version_id
652: ( p_project_id IN pa_projects_all.project_id%TYPE
653: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
654: ,p_version_type IN pa_budget_Versions.version_type%TYPE
655: ,p_version_number IN pa_budget_Versions.version_number%TYPE
656: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
657: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895
658: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 655: ,p_version_number IN pa_budget_Versions.version_number%TYPE

651: PROCEDURE get_version_id
652: ( p_project_id IN pa_projects_all.project_id%TYPE
653: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
654: ,p_version_type IN pa_budget_Versions.version_type%TYPE
655: ,p_version_number IN pa_budget_Versions.version_number%TYPE
656: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
657: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895
658: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
659: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

652: ( p_project_id IN pa_projects_all.project_id%TYPE
653: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
654: ,p_version_type IN pa_budget_Versions.version_type%TYPE
655: ,p_version_number IN pa_budget_Versions.version_number%TYPE
656: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
657: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895
658: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
659: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
660: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

653: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
654: ,p_version_type IN pa_budget_Versions.version_type%TYPE
655: ,p_version_number IN pa_budget_Versions.version_number%TYPE
656: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
657: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895
658: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
659: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
660: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
661: );

Line 665: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

661: );
662:
663:
664: PROCEDURE perform_autobasline_checks
665: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
666: ,x_result OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
667: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
668: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
669: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 672: ( p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

668: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
669: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
670:
671: PROCEDURE get_version_type_for_bdgt_type
672: ( p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
673: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
674: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
675: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
676: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

669: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
670:
671: PROCEDURE get_version_type_for_bdgt_type
672: ( p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
673: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
674: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
675: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
676: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
677:

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

675: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
676: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
677:
678: PROCEDURE validate_editable_bv
679: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
680: p_user_id IN NUMBER,
681:
682: --Bug 3986129: FP.M Web ADI Dev changes, a new parameter added
683: p_context IN VARCHAR2 DEFAULT 'ATTACHMENTS',

Line 685: x_locked_by_person_id OUT NOCOPY pa_budget_versions.locked_by_person_id%TYPE, --File.Sql.39 bug 4440895

681:
682: --Bug 3986129: FP.M Web ADI Dev changes, a new parameter added
683: p_context IN VARCHAR2 DEFAULT 'ATTACHMENTS',
684: p_excel_calling_mode IN VARCHAR2 DEFAULT NULL,
685: x_locked_by_person_id OUT NOCOPY pa_budget_versions.locked_by_person_id%TYPE, --File.Sql.39 bug 4440895
686: x_err_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
687: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
688: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
689: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 761: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

757: (
758: p_project_id IN pa_projects_all.project_id%TYPE
759: , p_task_id IN pa_tasks.task_id%TYPE
760: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
761: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
762: , p_amount_type IN VARCHAR2
763: )
764: RETURN NUMBER ;
765:

Line 789: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

785: ==============================================================================*/
786:
787: PROCEDURE Get_Curr_Original_Version_Info(
788: p_project_id IN pa_projects_all.project_id%TYPE
789: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
790: ,p_version_type IN pa_budget_versions.version_type%TYPE
791: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
792: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
793: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 790: ,p_version_type IN pa_budget_versions.version_type%TYPE

786:
787: PROCEDURE Get_Curr_Original_Version_Info(
788: p_project_id IN pa_projects_all.project_id%TYPE
789: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
790: ,p_version_type IN pa_budget_versions.version_type%TYPE
791: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
792: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895
793: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
794: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 804: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

800: from plan setting pages to maintain Include unspent amount through period lov.
801: ==============================================================================*/
802:
803: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
804: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
805: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
806: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
807: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
808: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895

Line 805: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895

801: ==============================================================================*/
802:
803: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
804: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
805: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
806: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
807: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
808: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
809: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 806: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895

802:
803: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
804: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
805: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
806: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
807: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
808: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
809: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
810: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 816: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

812:
813: /* To determine if a task is a planning element or not */
814: -- Modified for Bug 3840993 --sagarwal
815: FUNCTION IS_TASK_A_PLANNING_ELEMENT(
816: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
817: ,p_task_id IN pa_tasks.task_id%TYPE)
818: RETURN VARCHAR2;
819:
820: /* To determine if a task has resources attached to it as planning element */

Line 822: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

818: RETURN VARCHAR2;
819:
820: /* To determine if a task has resources attached to it as planning element */
821: FUNCTION IS_RESOURCE_ATTACHED_TO_TASK(
822: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
823: ,p_task_id IN pa_resource_assignments.task_id%TYPE)
824: --,p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE)
825: RETURN VARCHAR2;
826:

Line 838: p_project_id IN pa_budget_versions.project_id%TYPE

834: updated, then only if task assignments data exists then a warning
835: message would be shown to the user.
836: =============================================================================*/
837: PROCEDURE IS_WP_RL_UPDATEABLE(
838: p_project_id IN pa_budget_versions.project_id%TYPE
839: ,x_wp_rl_update_allowed_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
840: ,x_reason_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
841: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
842: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

884: pa_resource_lists_all_bg.resource_list_id%TYPE)
885: RETURN VARCHAR2;
886:
887: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
888: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
889: ,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
890: ,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
891: ,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
892: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 889: ,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

885: RETURN VARCHAR2;
886:
887: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
888: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
889: ,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
890: ,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
891: ,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
892: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
893: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895

Line 890: ,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

886:
887: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
888: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
889: ,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
890: ,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
891: ,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
892: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
893: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
894: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895

Line 891: ,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

887: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
888: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
889: ,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
890: ,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
891: ,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
892: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
893: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
894: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895
895:

Line 906: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document

902: -- Commenting out references of p_version_type_below - Bug 3902176
903:
904: PROCEDURE GET_SUMMARY_AMOUNTS(p_context IN VARCHAR2
905: ,P_project_id IN Pa_projects_all.project_id%TYPE -- Id of the project .
906: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document
907: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL -- Name of default staffing owner.
908: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
909: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
910: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895

Line 908: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176

904: PROCEDURE GET_SUMMARY_AMOUNTS(p_context IN VARCHAR2
905: ,P_project_id IN Pa_projects_all.project_id%TYPE -- Id of the project .
906: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document
907: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL -- Name of default staffing owner.
908: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
909: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
910: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
911: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
912: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895

Line 909: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895

905: ,P_project_id IN Pa_projects_all.project_id%TYPE -- Id of the project .
906: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document
907: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL -- Name of default staffing owner.
908: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
909: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
910: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
911: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
912: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
913: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895

Line 910: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895

906: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document
907: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL -- Name of default staffing owner.
908: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
909: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
910: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
911: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
912: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
913: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
914: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895

Line 911: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895

907: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL -- Name of default staffing owner.
908: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
909: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
910: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
911: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
912: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
913: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
914: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
915: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895

Line 914: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895

910: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
911: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
912: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
913: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
914: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
915: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
916: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895

Line 915: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895

911: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
912: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
913: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
914: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
915: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
916: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
919: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895

Line 916: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895

912: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
913: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
914: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
915: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
916: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
919: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
920: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895

Line 917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895

913: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
914: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
915: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
916: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
919: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
920: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
921: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895

Line 918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895

914: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
915: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
916: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
919: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
920: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
921: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895
922: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 919: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895

915: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
916: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
919: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
920: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
921: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895
922: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
923: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895

Line 920: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895

916: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
917: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
918: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
919: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
920: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
921: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895
922: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
923: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
924: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895

Line 935: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI

931: -- Since cost and revenue quantity figures are now both alreayd being retrieved and are passed
932: -- in separate out params, p_version parameter is no longer required.
933: -- Commenting out references of p_version_type_below - Bug 3902176
934:
935: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
936: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
937: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895

Line 936: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI

932: -- in separate out params, p_version parameter is no longer required.
933: -- Commenting out references of p_version_type_below - Bug 3902176
934:
935: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
936: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
937: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895

Line 937: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI

933: -- Commenting out references of p_version_type_below - Bug 3902176
934:
935: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
936: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
937: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895

Line 938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176

934:
935: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
936: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
937: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895

Line 939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895

935: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
936: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
937: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
943: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895

Line 940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895

936: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
937: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
943: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
944: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895

Line 941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895

937: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
943: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
944: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
945: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895

Line 942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895

938: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
943: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
944: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
945: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
946: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895

Line 943: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895

939: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
943: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
944: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
945: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
946: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
947: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895

Line 944: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895

940: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
943: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
944: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
945: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
946: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
947: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895
948: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code - Bug 3734840 --File.Sql.39 bug 4440895

Line 945: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895

941: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
942: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
943: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
944: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
945: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
946: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
947: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895
948: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code - Bug 3734840 --File.Sql.39 bug 4440895
949: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 955: FUNCTION does_bv_have_rej_lines(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

951: ,X_msg_count OUT NOCOPY NUMBER); -- Indicates the number of error messages --File.Sql.39 bug 4440895
952:
953:
954: /* Function returns 'Y' if budget version has budget lines with rejection code. */
955: FUNCTION does_bv_have_rej_lines(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
956: RETURN VARCHAR2;
957:
958: --------------------------------------------------------------------------------
959: -- This API is called during deleting a Rate Sch to check if the Rate

Line 988: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

984: *--------------------------------------------------------------------------------------------*/
985: FUNCTION Validate_Uncheck_MC_Flag (
986: p_project_id IN pa_projects_all.project_id%TYPE,
987: p_context IN VARCHAR2,
988: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
989: RETURN VARCHAR2;
990:
991: /*=============================================================================
992: This api is called to check if a txn currency can be deleted for an fp option.

Line 1009: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

1005:
1006: FUNCTION Check_delete_txn_cur_ok(
1007: p_project_id IN pa_projects_all.project_id%TYPE
1008: ,p_context IN VARCHAR2 -- FINPLAN or WORKPLAN
1009: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
1010: ,p_txn_currency_code IN fnd_currencies.currency_code%TYPE
1011: ) RETURN VARCHAR2;
1012:
1013: /*=============================================================================

Line 1055: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL

1051: PROCEDURE return_and_vldt_plan_prc_code
1052: (
1053: p_add_msg_to_stack IN VARCHAR2 DEFAULT 'Y'
1054: ,p_calling_context IN VARCHAR2 DEFAULT 'BUDGET'
1055: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1056: ,p_source_ci_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
1057: ,p_target_ci_id IN pa_control_items.ci_id%TYPE DEFAULT NULL
1058: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE DEFAULT NULL
1059: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895

Line 1058: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE DEFAULT NULL

1054: ,p_calling_context IN VARCHAR2 DEFAULT 'BUDGET'
1055: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1056: ,p_source_ci_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
1057: ,p_target_ci_id IN pa_control_items.ci_id%TYPE DEFAULT NULL
1058: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE DEFAULT NULL
1059: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895
1060: ,x_targ_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE --File.Sql.39 bug 4440895
1061: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1062: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

1055: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1056: ,p_source_ci_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
1057: ,p_target_ci_id IN pa_control_items.ci_id%TYPE DEFAULT NULL
1058: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE DEFAULT NULL
1059: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895
1060: ,x_targ_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE --File.Sql.39 bug 4440895
1061: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1062: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1063: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1060: ,x_targ_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE --File.Sql.39 bug 4440895

1056: ,p_source_ci_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.pa_num_tbl_type()
1057: ,p_target_ci_id IN pa_control_items.ci_id%TYPE DEFAULT NULL
1058: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE DEFAULT NULL
1059: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895
1060: ,x_targ_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE --File.Sql.39 bug 4440895
1061: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1062: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1063: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1064: );

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

1111: /* This procedure is called from FPWebadiAMImpl.java to get the structure version id
1112: * and the structure version status flag to be used as URL parameter for BNE URL
1113: */
1114: PROCEDURE return_struct_ver_info
1115: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1116: x_struct_version_id OUT NOCOPY pa_proj_element_versions.parent_structure_version_id%TYPE,
1117: x_struct_status_flag OUT NOCOPY VARCHAR2,
1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_msg_count OUT NOCOPY NUMBER,

Line 1122: FUNCTION get_cached_time_phased_code (bv_id IN pa_budget_versions.budget_version_id%TYPE)

1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_msg_count OUT NOCOPY NUMBER,
1120: x_msg_data OUT NOCOPY VARCHAR2);
1121:
1122: FUNCTION get_cached_time_phased_code (bv_id IN pa_budget_versions.budget_version_id%TYPE)
1123: RETURN VARCHAR2;
1124: -- bug 4494740: ends
1125:
1126: /*=============================================================================

Line 1170: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

1166:
1167: /*Parameters due fin plan model */
1168: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1169: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1170: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1173: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1174: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR