DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 7: -- p_organization_id IN hr_organization_units.organization_id%TYPE Required

3: -- API name : check_org_name_or_id
4: -- Type : Public
5: -- Pre-reqs : None.
6: -- Parameters :
7: -- p_organization_id IN hr_organization_units.organization_id%TYPE Required
8: -- p_name IN hr_organization_units.name%TYPE Required
9: -- p_check_id_flag IN VARCHAR2 Required
10: -- x_organization_id OUT hr_organization_units.organization_id%TYPE Required
11: -- x_return_status OUT VARCHAR2 Required

Line 8: -- p_name IN hr_organization_units.name%TYPE Required

4: -- Type : Public
5: -- Pre-reqs : None.
6: -- Parameters :
7: -- p_organization_id IN hr_organization_units.organization_id%TYPE Required
8: -- p_name IN hr_organization_units.name%TYPE Required
9: -- p_check_id_flag IN VARCHAR2 Required
10: -- x_organization_id OUT hr_organization_units.organization_id%TYPE Required
11: -- x_return_status OUT VARCHAR2 Required
12: -- x_error_msg_code OUT VARCHAR2 Required

Line 10: -- x_organization_id OUT hr_organization_units.organization_id%TYPE Required

6: -- Parameters :
7: -- p_organization_id IN hr_organization_units.organization_id%TYPE Required
8: -- p_name IN hr_organization_units.name%TYPE Required
9: -- p_check_id_flag IN VARCHAR2 Required
10: -- x_organization_id OUT hr_organization_units.organization_id%TYPE Required
11: -- x_return_status OUT VARCHAR2 Required
12: -- x_error_msg_code OUT VARCHAR2 Required
13: --
14: -- History

Line 19: (p_organization_id IN hr_organization_units.organization_id%TYPE

15: --
16: -- 18-AUG-2000 -- Sakthi/William - Created.
17: --
18: PROCEDURE CHECK_ORG_NAME_OR_ID
19: (p_organization_id IN hr_organization_units.organization_id%TYPE
20: ,p_name IN hr_organization_units.name%TYPE
21: ,p_check_id_flag IN VARCHAR2
22: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
23: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 20: ,p_name IN hr_organization_units.name%TYPE

16: -- 18-AUG-2000 -- Sakthi/William - Created.
17: --
18: PROCEDURE CHECK_ORG_NAME_OR_ID
19: (p_organization_id IN hr_organization_units.organization_id%TYPE
20: ,p_name IN hr_organization_units.name%TYPE
21: ,p_check_id_flag IN VARCHAR2
22: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
23: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895

Line 22: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895

18: PROCEDURE CHECK_ORG_NAME_OR_ID
19: (p_organization_id IN hr_organization_units.organization_id%TYPE
20: ,p_name IN hr_organization_units.name%TYPE
21: ,p_check_id_flag IN VARCHAR2
22: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
23: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24: ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
25:
26: -- API name : check_check_project_status_or_id