1 PACKAGE pa_hr_org_utils AS
2 -- $Header: PAORUTLS.pls 120.1 2005/08/19 16:37:20 mwasowic noship $
3
4 --
5 -- PROCEDURE
6 -- Check_OrgHierName_Or_Id
7 -- PURPOSE
8 -- This procedure does the following
9 -- If Org Hierarchy name is passed converts it to the id
10 -- If Org Hierachy Id is passed,
11 -- based on the check_id_flag validates it
12 -- HISTORY
13 -- 23-JUN-2000 R. Krishnamurthy Created
14 --
15 procedure Check_OrgHierName_Or_Id
16 ( p_org_hierarchy_version_id IN NUMBER
17 ,p_org_hierarchy_name IN VARCHAR2
18 ,p_check_id_flag IN VARCHAR2
19 ,x_org_hierarchy_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
20 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21 ,x_error_msg_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
22 PROCEDURE Check_OrgName_Or_Id
23 ( p_organization_id IN NUMBER
24 ,p_organization_name IN VARCHAR2
25 ,p_check_id_flag IN VARCHAR2
26 ,x_organization_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28 ,x_error_msg_code OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
29 end pa_hr_org_utils ;