eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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 123: ,p_version_id IN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE

119: X_ERROR_MESSAGE_CODE OUT NOCOPY VARCHAR2);
120:
121: PROCEDURE set_global_variables( p_selected_flag IN VARCHAR2
122: ,p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
123: ,p_version_id IN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE
124: ,p_start_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
125: );
126:
127: FUNCTION get_selected_flag RETURN VARCHAR2;

Line 124: ,p_start_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE

120:
121: PROCEDURE set_global_variables( p_selected_flag IN VARCHAR2
122: ,p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
123: ,p_version_id IN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE
124: ,p_start_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
125: );
126:
127: FUNCTION get_selected_flag RETURN VARCHAR2;
128: pragma RESTRICT_REFERENCES (get_selected_flag, WNDS, WNPS );

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

129:
130: FUNCTION get_person_id RETURN PA_EMPLOYEES.PERSON_ID%TYPE;
131: pragma RESTRICT_REFERENCES (get_person_id, WNDS, WNPS );
132:
133: FUNCTION get_version_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE;
134: pragma RESTRICT_REFERENCES (get_version_id, WNDS, WNPS );
135:
136: FUNCTION get_start_org_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE;
137: pragma RESTRICT_REFERENCES (get_start_org_id, WNDS, WNPS );

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

132:
133: FUNCTION get_version_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE;
134: pragma RESTRICT_REFERENCES (get_version_id, WNDS, WNPS );
135:
136: FUNCTION get_start_org_id RETURN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE;
137: pragma RESTRICT_REFERENCES (get_start_org_id, WNDS, WNPS );
138:
139: FUNCTION get_projected_end_date(p_person_id IN NUMBER) RETURN DATE;
140: pragma RESTRICT_REFERENCES (get_projected_end_date, WNDS, WNPS);

Line 146: ,p_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE

142: FUNCTION get_period_date RETURN DATE;
143: pragma RESTRICT_REFERENCES (get_period_date, WNDS, WNPS );
144:
145: PROCEDURE populate_role_flags( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
146: ,p_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
147: ,x_res_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
148: ,x_proj_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149: ,x_prim_ctct_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
150: ,x_frcst_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895