DBA Data[Home] [Help]

PACKAGE: APPS.PA_HR_ORG_UTILS

Source


1 PACKAGE pa_hr_org_utils AUTHID CURRENT_USER 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 ;