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.

APPS.PA_RESOURCE_UTILS dependencies on PA_EMPLOYEES

Line 11: G_PERSON_ID PA_EMPLOYEES.PERSON_ID%TYPE;

7: G_SELECTED_FLAG VARCHAR2(1);
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;

Line 29: G_TERM_PERSON_ID PA_EMPLOYEES.PERSON_ID%TYPE; -- Bug 5683340

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
32:
33: --

Line 122: ,p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE

118: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
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:

Line 130: FUNCTION get_person_id RETURN PA_EMPLOYEES.PERSON_ID%TYPE;

126:
127: FUNCTION get_selected_flag RETURN VARCHAR2;
128: pragma RESTRICT_REFERENCES (get_selected_flag, WNDS, WNPS );
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 );

Line 145: PROCEDURE populate_role_flags( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE

141:
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

Line 814: FUNCTION get_term_type( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE )

810: -- of an employee/contingent worker as 'V' or 'I'
811: -- HISTORY
812: -- 05-MAR-207 kjai Created for Bug 5683340
813: --
814: FUNCTION get_term_type( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE )
815: RETURN VARCHAR2;
816:
817: --
818: -- PROCEDURE

Line 828: p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

824: -- HISTORY
825: -- 05-MAR-207 kjai Created for Bug 5683340
826: --
827: PROCEDURE Init_FTE_Sync_WF(
828: p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
829: x_invol_term OUT NOCOPY VARCHAR2,
830: x_return_status OUT NOCOPY VARCHAR2,
831: x_msg_data OUT NOCOPY VARCHAR2,
832: x_msg_count OUT NOCOPY NUMBER);

Line 843: PROCEDURE Set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

839: -- in table pa_resources for the passed person_id
840: -- HISTORY
841: -- 05-MAR-207 kjai Created for Bug 5683340
842: --
843: PROCEDURE Set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
844: p_future_term_wf_flag IN PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_msg_data OUT NOCOPY VARCHAR2,
847: x_msg_count OUT NOCOPY NUMBER);

Line 857: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

853: -- in table pa_resources for the passed person_id
854: -- HISTORY
855: -- 05-MAR-207 kjai Created for Bug 5683340
856: --
857: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
858: x_future_term_wf_flag OUT NOCOPY PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
859: x_return_status OUT NOCOPY VARCHAR2,
860: x_msg_data OUT NOCOPY VARCHAR2,
861: x_msg_count OUT NOCOPY NUMBER);

Line 872: PROCEDURE Is_fte( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,

868: -- If he is, then returns the actual term date , wait days.
869: -- HISTORY
870: -- 05-MAR-207 kjai Created for Bug 5683340
871: --
872: PROCEDURE Is_fte( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,
873: x_return_end_date OUT NOCOPY DATE ,
874: x_wait_days OUT NOCOPY NUMBER ,
875: x_invol_term OUT NOCOPY VARCHAR2,
876: x_return_status OUT NOCOPY VARCHAR2,

Line 889: PROCEDURE get_valid_enddate(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,

885: --
886: -- HISTORY
887: -- 05-MAR-207 kjai Created for Bug 5683340
888: --
889: PROCEDURE get_valid_enddate(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,
890: p_actual_term_date IN DATE ,
891: x_valid_end_date OUT NOCOPY DATE,
892: x_return_status OUT NOCOPY VARCHAR2,
893: x_msg_data OUT NOCOPY VARCHAR2,