DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_STATUSES

Line 30: -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required

26: -- API name : check_check_project_status_or_id
27: -- Type : Public
28: -- Pre-reqs : None.
29: -- Parameters :
30: -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required
31: -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required
32: -- p_check_id_flag IN VARCHAR2 Required
33: -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required
34: -- x_return_status OUT VARCHAR2 Required

Line 31: -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required

27: -- Type : Public
28: -- Pre-reqs : None.
29: -- Parameters :
30: -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required
31: -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required
32: -- p_check_id_flag IN VARCHAR2 Required
33: -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required
34: -- x_return_status OUT VARCHAR2 Required
35: -- x_error_msg_code OUT VARCHAR2 Required

Line 33: -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required

29: -- Parameters :
30: -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required
31: -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required
32: -- p_check_id_flag IN VARCHAR2 Required
33: -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required
34: -- x_return_status OUT VARCHAR2 Required
35: -- x_error_msg_code OUT VARCHAR2 Required
36: --
37: -- History

Line 43: (p_project_status_code IN pa_project_statuses.project_status_code%TYPE

39: -- 18-AUG-2000 -- Sakthi/William - Created.
40: --
41: --
42: PROCEDURE CHECK_PROJECT_STATUS_OR_ID
43: (p_project_status_code IN pa_project_statuses.project_status_code%TYPE
44: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE
45: ,p_check_id_flag IN VARCHAR2
46: ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
47: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 44: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE

40: --
41: --
42: PROCEDURE CHECK_PROJECT_STATUS_OR_ID
43: (p_project_status_code IN pa_project_statuses.project_status_code%TYPE
44: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE
45: ,p_check_id_flag IN VARCHAR2
46: ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
47: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895

Line 46: ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895

42: PROCEDURE CHECK_PROJECT_STATUS_OR_ID
43: (p_project_status_code IN pa_project_statuses.project_status_code%TYPE
44: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE
45: ,p_check_id_flag IN VARCHAR2
46: ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
47: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
49:
50: -- API name : check_customer_name_or_id