APPS.PA_FIN_PLAN_UTILS dependencies on PA_PROJ_PERIOD_PROFILES

Line 86: return pa_proj_period_profiles.period_name1%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)
90: return pa_proj_period_profiles.profile_end_period_name%TYPE;

Line 90: return pa_proj_period_profiles.profile_end_period_name%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
94: ( p_proj_structure_version_id NUMBER)

Line 522: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */

518: Modifying the datatype of parameter p_plan_period_type below to varchar2
519: and x_shifted_period_start_date and x_shifted_period_end_date as date*/
520: PROCEDURE Get_Period_Details
521: ( p_period_name IN pa_periods.period_name%TYPE
522: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
523: ,p_plan_period_type IN VARCHAR2
524: ,x_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
525: ,x_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
526: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 535: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */

531: Modifying the datatype of parameter p_plan_period_type below to varchar2
532: and x_shifted_period_start_date and x_shifted_period_end_date as date*/
533: PROCEDURE Get_Shifted_Period (
534: p_period_name IN pa_periods.period_name%TYPE
535: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
536: ,p_plan_period_type IN VARCHAR2
537: ,p_number_of_periods IN NUMBER
538: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895
539: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE

Line 539: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE

535: /* ,p_plan_period_type IN pa_proj_period_profiles.plan_period_type%TYPE */
536: ,p_plan_period_type IN VARCHAR2
537: ,p_number_of_periods IN NUMBER
538: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895
539: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE
540: ,x_shifted_period_end_date OUT pa_proj_period_profiles.period1_end_date%TYPE */
541: ,x_shifted_period_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
542: ,x_shifted_period_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
543: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 540: ,x_shifted_period_end_date OUT pa_proj_period_profiles.period1_end_date%TYPE */

536: ,p_plan_period_type IN VARCHAR2
537: ,p_number_of_periods IN NUMBER
538: ,x_shifted_period OUT NOCOPY pa_periods.period_name%TYPE --File.Sql.39 bug 4440895
539: /* ,x_shifted_period_start_date OUT pa_proj_period_profiles.period1_start_date%TYPE
540: ,x_shifted_period_end_date OUT pa_proj_period_profiles.period1_end_date%TYPE */
541: ,x_shifted_period_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
542: ,x_shifted_period_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
543: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
544: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895