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_PROJECTS_ALL

Line 111: (p_project_id IN pa_projects_all.project_id%TYPE)

107: This function will return the approved cost budget current baselined version.
108: If version is not available then it will return null value.
109: ==============================================================================*/
110: FUNCTION Get_app_budget_cost_cb_ver
111: (p_project_id IN pa_projects_all.project_id%TYPE)
112: RETURN NUMBER;
113:
114:
115: PROCEDURE Get_Appr_Cost_Plan_Type_Info(

Line 116: p_project_id IN pa_projects_all.project_id%TYPE

112: RETURN NUMBER;
113:
114:
115: PROCEDURE Get_Appr_Cost_Plan_Type_Info(
116: p_project_id IN pa_projects_all.project_id%TYPE
117: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
118: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
119: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
120: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 123: p_project_id IN pa_projects_all.project_id%TYPE

119: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
120: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
121:
122: PROCEDURE Get_Appr_Rev_Plan_Type_Info(
123: p_project_id IN pa_projects_all.project_id%TYPE
124: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
125: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
126: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
127: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 130: p_project_id IN pa_projects_all.project_id%TYPE

126: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
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

Line 156: p_project_id IN pa_projects_all.project_id%TYPE

152:
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

Line 233: (p_project_id IN pa_projects_all.project_id%TYPE

229: (p_person_id IN NUMBER) return VARCHAR2;
230:
231: /*This is due to bug 2607945*/
232: FUNCTION is_plan_type_addition_allowed
233: (p_project_id IN pa_projects_all.project_id%TYPE
234: ,P_FIN_PLAN_TYPE_ID IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
235: ) RETURN VARCHAR2 ;
236:
237:

Line 365: (p_project_id IN pa_projects_all.project_id%TYPE)

361: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
362: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
363:
364: FUNCTION check_budget_trans_exists
365: (p_project_id IN pa_projects_all.project_id%TYPE)
366: return VARCHAR2;
367:
368: FUNCTION enable_auto_baseline
369: (p_project_id IN pa_projects_all.project_id%TYPE)

Line 369: (p_project_id IN pa_projects_all.project_id%TYPE)

365: (p_project_id IN pa_projects_all.project_id%TYPE)
366: return VARCHAR2;
367:
368: FUNCTION enable_auto_baseline
369: (p_project_id IN pa_projects_all.project_id%TYPE)
370: return VARCHAR2;
371:
372: PROCEDURE Get_Resource_List_Info
373: (p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE

Line 411: p_project_id IN pa_projects_all.project_id%TYPE

407: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
408: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
409:
410: PROCEDURE Is_AC_PT_Attached_After_UPG(
411: p_project_id IN pa_projects_all.project_id%TYPE
412: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
413: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
414: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
415: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 418: p_project_id IN pa_projects_all.project_id%TYPE

414: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
415: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
416:
417: PROCEDURE Is_AR_PT_Attached_After_UPG(
418: p_project_id IN pa_projects_all.project_id%TYPE
419: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
420: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
421: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
422: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 488: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE

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
492: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895

Line 489: ,p_project_currency_code IN pa_projects_all.project_currency_code%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
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

Line 490: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%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
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

Line 571: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
570: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
571: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
572: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
573: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE DEFAULT NULL
574: ,p_context IN VARCHAR2
575: ,p_attrs_to_be_validated IN VARCHAR2 -- valid values are COST, REVENUE , BOTH

Line 572: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
570: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
571: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
572: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
573: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE DEFAULT NULL
574: ,p_context IN VARCHAR2
575: ,p_attrs_to_be_validated IN VARCHAR2 -- valid values are COST, REVENUE , BOTH
576: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 573: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE DEFAULT NULL

569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
570: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
571: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
572: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
573: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE DEFAULT NULL
574: ,p_context IN VARCHAR2
575: ,p_attrs_to_be_validated IN VARCHAR2 -- valid values are COST, REVENUE , BOTH
576: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
577: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 606: ( p_project_id IN pa_projects_all.project_id%TYPE

602: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
603: );
604:
605: PROCEDURE Get_Project_Curr_Attributes
606: ( p_project_id IN pa_projects_all.project_id%TYPE
607: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
608: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895

Line 607: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895

603: );
604:
605: PROCEDURE Get_Project_Curr_Attributes
606: ( p_project_id IN pa_projects_all.project_id%TYPE
607: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
608: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
611: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

Line 608: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895

604:
605: PROCEDURE Get_Project_Curr_Attributes
606: ( p_project_id IN pa_projects_all.project_id%TYPE
607: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
608: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
611: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
612: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895

Line 609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895

605: PROCEDURE Get_Project_Curr_Attributes
606: ( p_project_id IN pa_projects_all.project_id%TYPE
607: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
608: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
611: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
612: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
613: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895

Line 610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895

606: ( p_project_id IN pa_projects_all.project_id%TYPE
607: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
608: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
611: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
612: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
613: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
614: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 611: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

607: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
608: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
611: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
612: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
613: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
614: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
615: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 612: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895

608: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
611: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
612: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
613: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
614: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
615: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
616: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 613: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895

609: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
610: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
611: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
612: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
613: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
614: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
615: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
616: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
617:

Line 619: ( p_project_id IN pa_projects_all.project_id%TYPE

615: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
616: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
617:
618: PROCEDURE IsRevVersionCreationAllowed
619: ( p_project_id IN pa_projects_all.project_id%TYPE
620: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
621: ,x_creation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
622: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
623: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 643: ( p_project_id IN pa_projects_all.project_id%TYPE

639:
640: -- This procedure is used to derive the version type given the project id and
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

Line 652: ( p_project_id IN pa_projects_all.project_id%TYPE

648: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
649: );
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

Line 758: p_project_id IN pa_projects_all.project_id%TYPE

754:
755:
756: FUNCTION Get_Budgeted_Amount
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

Line 788: p_project_id IN pa_projects_all.project_id%TYPE

784: project id and version 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

Line 853: p_project_id IN pa_projects_all.project_id%TYPE

849: would be returned
850: ==============================================================================*/
851:
852: PROCEDURE IS_PRI_FCST_COST_PT_ATTACHED(
853: p_project_id IN pa_projects_all.project_id%TYPE
854: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
855: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
856: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
857: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 866: p_project_id IN pa_projects_all.project_id%TYPE

862: would be returned
863: ==============================================================================*/
864:
865: PROCEDURE IS_PRI_FCST_REV_PT_ATTACHED(
866: p_project_id IN pa_projects_all.project_id%TYPE
867: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
868: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
869: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
870: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 875: (p_project_id IN pa_projects_all.project_id%TYPE

871:
872:
873: /* Used by Resource foundation team to know the resource lists used in WP */
874: FUNCTION is_wp_resource_list
875: (p_project_id IN pa_projects_all.project_id%TYPE
876: ,p_resource_list_id IN
877: pa_resource_lists_all_bg.resource_list_id%TYPE)
878: RETURN VARCHAR2;
879:

Line 882: (p_project_id IN pa_projects_all.project_id%TYPE

878: RETURN VARCHAR2;
879:
880: /* Used by Resource foundation team to know the resource lists used in FP */
881: FUNCTION is_fp_resource_list
882: (p_project_id IN pa_projects_all.project_id%TYPE
883: ,p_resource_list_id IN
884: pa_resource_lists_all_bg.resource_list_id%TYPE)
885: RETURN VARCHAR2;
886:

Line 905: ,P_project_id IN Pa_projects_all.project_id%TYPE -- Id of the project .

901: -- in separate out params, p_version parameter is no longer required.
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

Line 986: p_project_id IN pa_projects_all.project_id%TYPE,

982: * p_budget_version_id would be null. The api returns 'Y' if the event is valid and allowed
983: * and returns 'N' otherwise.
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:

Line 1007: p_project_id IN pa_projects_all.project_id%TYPE

1003: 3. option is a version and amounts exist against the currency
1004: ==============================================================================*/
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;

Line 1019: p_project_id IN pa_projects_all.project_id%TYPE

1015: of the project in budgets data model.
1016: ==============================================================================*/
1017:
1018: FUNCTION check_if_amounts_exist_for_wp(
1019: p_project_id IN pa_projects_all.project_id%TYPE
1020: ) RETURN VARCHAR2;
1021:
1022: /*=============================================================================
1023: This api is called to check if task assignments exist for any of the workplan

Line 1028: p_project_id IN pa_projects_all.project_id%TYPE

1024: versions of the given project
1025: ==============================================================================*/
1026:
1027: FUNCTION check_if_task_asgmts_exist(
1028: p_project_id IN pa_projects_all.project_id%TYPE
1029: ) RETURN VARCHAR2;
1030:
1031: /*=============================================================================
1032: This api is called to check if amounts exist for any of the budget versions

Line 1038: p_project_id IN pa_projects_all.project_id%TYPE

1034: RBS change at plan type level.
1035: ==============================================================================*/
1036:
1037: FUNCTION check_if_amounts_exist_for_fp(
1038: p_project_id IN pa_projects_all.project_id%TYPE
1039: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id %TYPE
1040: ) RETURN VARCHAR2;
1041:
1042: /*===================================================================================

Line 1067: (p_project_id IN pa_projects_all.project_id%TYPE

1063: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1064: );
1065:
1066: FUNCTION Is_source_for_gen_options
1067: (p_project_id IN pa_projects_all.project_id%TYPE
1068: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
1069: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
1070: ) RETURN VARCHAR2;
1071:

Line 1093: ( p_project_id IN pa_projects_all.project_id%TYPE,

1089: in the view pa_fp_webadi_periodic_v.
1090: */
1091:
1092: FUNCTION get_physical_pc_complete
1093: ( p_project_id IN pa_projects_all.project_id%TYPE,
1094: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE)
1095:
1096: RETURN NUMBER;
1097: