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 156: FUNCTION get_organization_name ( p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ) RETURN HR_ORGANIZATION_UNITS.NAME%TYPE;

152: ,x_utl_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
153: ) ;
154:
155: -- 4882876 : Removed WNPS restriction from get_organization_name
156: FUNCTION get_organization_name ( p_org_id IN HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ) RETURN HR_ORGANIZATION_UNITS.NAME%TYPE;
157: pragma RESTRICT_REFERENCES (get_organization_name, WNDS);
158:
159: PROCEDURE delete_grant( p_person_id IN NUMBER
160: ,p_org_id IN NUMBER