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 103: ,p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE

99: X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
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:

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

107:
108: FUNCTION get_selected_flag RETURN VARCHAR2;
109: pragma RESTRICT_REFERENCES (get_selected_flag, WNDS, WNPS );
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 );

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

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

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

740: -- of an employee/contingent worker as 'V' or 'I'
741: -- HISTORY
742: -- 05-MAR-207 kjai Created for Bug 5683340
743: --
744: FUNCTION get_term_type( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE )
745: RETURN VARCHAR2;
746:
747: --
748: -- PROCEDURE

Line 758: p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

754: -- HISTORY
755: -- 05-MAR-207 kjai Created for Bug 5683340
756: --
757: PROCEDURE Init_FTE_Sync_WF(
758: p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
759: x_invol_term OUT NOCOPY VARCHAR2,
760: x_return_status OUT NOCOPY VARCHAR2,
761: x_msg_data OUT NOCOPY VARCHAR2,
762: x_msg_count OUT NOCOPY NUMBER);

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

769: -- in table pa_resources for the passed person_id
770: -- HISTORY
771: -- 05-MAR-207 kjai Created for Bug 5683340
772: --
773: PROCEDURE Set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
774: p_future_term_wf_flag IN PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
775: x_return_status OUT NOCOPY VARCHAR2,
776: x_msg_data OUT NOCOPY VARCHAR2,
777: x_msg_count OUT NOCOPY NUMBER);

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

783: -- in table pa_resources for the passed person_id
784: -- HISTORY
785: -- 05-MAR-207 kjai Created for Bug 5683340
786: --
787: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
788: x_future_term_wf_flag OUT NOCOPY PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
789: x_return_status OUT NOCOPY VARCHAR2,
790: x_msg_data OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER);

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

798: -- If he is, then returns the actual term date , wait days.
799: -- HISTORY
800: -- 05-MAR-207 kjai Created for Bug 5683340
801: --
802: PROCEDURE Is_fte( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,
803: x_return_end_date OUT NOCOPY DATE ,
804: x_wait_days OUT NOCOPY NUMBER ,
805: x_invol_term OUT NOCOPY VARCHAR2,
806: x_return_status OUT NOCOPY VARCHAR2,

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

815: --
816: -- HISTORY
817: -- 05-MAR-207 kjai Created for Bug 5683340
818: --
819: PROCEDURE get_valid_enddate(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,
820: p_actual_term_date IN DATE ,
821: x_valid_end_date OUT NOCOPY DATE,
822: x_return_status OUT NOCOPY VARCHAR2,
823: x_msg_data OUT NOCOPY VARCHAR2,