DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS2 dependencies on PA_PROJECTS_ALL

Line 56: (p_project_id IN pa_projects_all.project_id%TYPE) RETURN NUMBER ;

52: , X_err_code IN OUT NOCOPY number --File.Sql.39 bug 4440895
53: , X_err_stage IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
54: , X_err_stack IN OUT NOCOPY varchar2); --File.Sql.39 bug 4440895
55: FUNCTION Get_project_business_group
56: (p_project_id IN pa_projects_all.project_id%TYPE) RETURN NUMBER ;
57: PRAGMA RESTRICT_REFERENCES (Get_project_business_group , WNPS, WNDS );
58:
59: PROCEDURE Check_Project_Number_Or_Id
60: ( p_project_id IN pa_projects_all.project_id%TYPE

Line 60: ( p_project_id IN pa_projects_all.project_id%TYPE

56: (p_project_id IN pa_projects_all.project_id%TYPE) RETURN NUMBER ;
57: PRAGMA RESTRICT_REFERENCES (Get_project_business_group , WNPS, WNDS );
58:
59: PROCEDURE Check_Project_Number_Or_Id
60: ( p_project_id IN pa_projects_all.project_id%TYPE
61: ,p_project_number IN pa_projects_all.segment1%TYPE
62: ,p_check_id_flag IN VARCHAR2 := 'A'
63: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
64: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 61: ,p_project_number IN pa_projects_all.segment1%TYPE

57: PRAGMA RESTRICT_REFERENCES (Get_project_business_group , WNPS, WNDS );
58:
59: PROCEDURE Check_Project_Number_Or_Id
60: ( p_project_id IN pa_projects_all.project_id%TYPE
61: ,p_project_number IN pa_projects_all.segment1%TYPE
62: ,p_check_id_flag IN VARCHAR2 := 'A'
63: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
64: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 63: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895

59: PROCEDURE Check_Project_Number_Or_Id
60: ( p_project_id IN pa_projects_all.project_id%TYPE
61: ,p_project_number IN pa_projects_all.segment1%TYPE
62: ,p_check_id_flag IN VARCHAR2 := 'A'
63: ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
64: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
66:
67: