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 20: (p_organization_id IN hr_organization_units.organization_id%TYPE

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

Line 21: ,p_name IN hr_organization_units.name%TYPE

17: --
18: --
19: procedure Check_org_name_Or_Id
20: (p_organization_id IN hr_organization_units.organization_id%TYPE
21: ,p_name IN hr_organization_units.name%TYPE
22: ,p_check_id_flag IN VARCHAR2
23: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
24: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: ,x_error_msg_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

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

19: procedure Check_org_name_Or_Id
20: (p_organization_id IN hr_organization_units.organization_id%TYPE
21: ,p_name IN hr_organization_units.name%TYPE
22: ,p_check_id_flag IN VARCHAR2
23: ,x_organization_id OUT NOCOPY hr_organization_units.organization_id%TYPE --File.Sql.39 bug 4440895
24: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: ,x_error_msg_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
26: BEGIN
27: IF (p_organization_id IS NOT NULL) THEN

Line 31: FROM hr_organization_units

27: IF (p_organization_id IS NOT NULL) THEN
28: IF (p_check_id_flag = 'Y') THEN
29: SELECT organization_id
30: INTO x_organization_id
31: FROM hr_organization_units
32: WHERE organization_id = p_organization_id;
33: ELSE
34: x_organization_id := p_organization_id;
35: END IF;

Line 39: FROM hr_organization_units

35: END IF;
36: ELSE
37: SELECT organization_id
38: INTO x_organization_id
39: FROM hr_organization_units
40: WHERE name = p_name;
41: END IF;
42: x_return_status:= FND_API.G_RET_STS_SUCCESS;
43: EXCEPTION