APPS.PA_RESOURCE_UTILS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 12: G_VERSION_ID PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE;

8: G_PRIMARY_CONTACT_NAME VARCHAR2(240);
9: G_PRIMARY_CONTACT_ID NUMBER;
10: G_CURRENT_PROJECT_ID PA_PROJECTS_ALL.PROJECT_ID%TYPE;
11: G_PERSON_ID PA_EMPLOYEES.PERSON_ID%TYPE;
12: G_VERSION_ID PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE;
13: G_START_ORG_ID PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE;
14: G_PERIOD_DATE DATE ;
15: type PLSQLTAB_NAMEARRAY is table of varchar2(120) index by binary_integer;
16: type PLSQLTAB_INTARRAY is table of NUMBER index by binary_integer;

Line 13: G_START_ORG_ID PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE;

9: G_PRIMARY_CONTACT_ID NUMBER;
10: G_CURRENT_PROJECT_ID PA_PROJECTS_ALL.PROJECT_ID%TYPE;
11: G_PERSON_ID PA_EMPLOYEES.PERSON_ID%TYPE;
12: G_VERSION_ID PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE;
13: G_START_ORG_ID PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE;
14: G_PERIOD_DATE DATE ;
15: type PLSQLTAB_NAMEARRAY is table of varchar2(120) index by binary_integer;
16: type PLSQLTAB_INTARRAY is table of NUMBER index by binary_integer;
17: g_provisional_hours NUMBER;

Line 104: ,p_version_id IN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE

100: X_ERROR_MESSAGE_CODE OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
101:
102: PROCEDURE set_global_variables( p_selected_flag IN VARCHAR2
103: ,p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
104: ,p_version_id IN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE
105: ,p_start_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
106: );
107:
108: FUNCTION get_selected_flag RETURN VARCHAR2;

Line 105: ,p_start_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE

101:
102: PROCEDURE set_global_variables( p_selected_flag IN VARCHAR2
103: ,p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
104: ,p_version_id IN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE
105: ,p_start_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
106: );
107:
108: FUNCTION get_selected_flag RETURN VARCHAR2;
109: pragma RESTRICT_REFERENCES (get_selected_flag, WNDS, WNPS );

Line 114: FUNCTION get_version_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE;

110:
111: FUNCTION get_person_id RETURN PA_EMPLOYEES.PERSON_ID%TYPE;
112: pragma RESTRICT_REFERENCES (get_person_id, WNDS, WNPS );
113:
114: FUNCTION get_version_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE;
115: pragma RESTRICT_REFERENCES (get_version_id, WNDS, WNPS );
116:
117: FUNCTION get_start_org_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE;
118: pragma RESTRICT_REFERENCES (get_start_org_id, WNDS, WNPS );

Line 117: FUNCTION get_start_org_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE;

113:
114: FUNCTION get_version_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE;
115: pragma RESTRICT_REFERENCES (get_version_id, WNDS, WNPS );
116:
117: FUNCTION get_start_org_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE;
118: pragma RESTRICT_REFERENCES (get_start_org_id, WNDS, WNPS );
119:
120: FUNCTION get_projected_end_date(p_person_id IN NUMBER) RETURN DATE;
121: pragma RESTRICT_REFERENCES (get_projected_end_date, WNDS, WNPS);

Line 127: ,p_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE

123: FUNCTION get_period_date RETURN DATE;
124: pragma RESTRICT_REFERENCES (get_period_date, WNDS, WNPS );
125:
126: PROCEDURE populate_role_flags( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
127: ,p_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
128: ,x_res_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129: ,x_proj_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
130: ,x_prim_ctct_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131: ,x_frcst_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895