DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 26: G_ORGANIZATION_ID HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE; -- 4882876

22: G_ASSIGNMENT_ID NUMBER;
23: G_RESOURCE_ID NUMBER;
24: /*Bug 3737529 : Code addtion ends*/
25: G_START_DATE DATE; -- For bug 4443604
26: G_ORGANIZATION_ID HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE; -- 4882876
27: G_ORGANIZATION_NAME HR_ORGANIZATION_UNITS.NAME%TYPE; -- 4882876
28:
29: G_TERM_PERSON_ID PA_EMPLOYEES.PERSON_ID%TYPE; -- Bug 5683340
30: G_FTE_DATE DATE; -- Bug 5683340

Line 27: G_ORGANIZATION_NAME HR_ORGANIZATION_UNITS.NAME%TYPE; -- 4882876

23: G_RESOURCE_ID NUMBER;
24: /*Bug 3737529 : Code addtion ends*/
25: G_START_DATE DATE; -- For bug 4443604
26: G_ORGANIZATION_ID HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE; -- 4882876
27: G_ORGANIZATION_NAME HR_ORGANIZATION_UNITS.NAME%TYPE; -- 4882876
28:
29: G_TERM_PERSON_ID PA_EMPLOYEES.PERSON_ID%TYPE; -- Bug 5683340
30: G_FTE_DATE DATE; -- Bug 5683340
31: G_FTE_FLAG VARCHAR2(1); -- Bug 5683340

Line 137: FUNCTION get_organization_name ( p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ) RETURN HR_ORGANIZATION_UNITS.NAME%TYPE;

133: ,x_utl_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134: ) ;
135:
136: -- 4882876 : Removed WNPS restriction from get_organization_name
137: FUNCTION get_organization_name ( p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ) RETURN HR_ORGANIZATION_UNITS.NAME%TYPE;
138: pragma RESTRICT_REFERENCES (get_organization_name, WNDS);
139:
140: PROCEDURE delete_grant( p_person_id IN NUMBER
141: ,p_org_id IN NUMBER