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

630: --
631: -- This procedure is called from form PAXRESSC
632: --
633: PROCEDURE set_global_variables( p_selected_flag IN VARCHAR2
634: ,p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
635: ,p_version_id IN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE
636: ,p_start_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
637: )
638: IS

Line 660: FUNCTION get_person_id RETURN PA_EMPLOYEES.PERSON_ID%TYPE

656:
657: --
658: -- This Function is used by the view pa_org_authority_v.
659: --
660: FUNCTION get_person_id RETURN PA_EMPLOYEES.PERSON_ID%TYPE
661: IS
662: BEGIN
663: RETURN G_PERSON_ID;
664: END get_person_id;

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

690: -- This Procedure, receives person_id, org_id and populates the flags corresponding the
691: -- check-boxes in the form. (Used in PAXRESSC)
692: --
693:
694: PROCEDURE populate_role_flags( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
695: ,p_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
696: ,x_res_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
697: ,x_proj_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
698: ,x_prim_ctct_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4378: select effective_start_date into l_manager_start_date from pa_employees

4374: l_manager_start_date := trunc(sysdate);
4375: ELSE
4376:
4377: BEGIN
4378: select effective_start_date into l_manager_start_date from pa_employees
4379: where person_id=x_ManagerId
4380: and active='*';
4381: EXCEPTION
4382: WHEN NO_DATA_FOUND then

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

4453: -- of an employee/contingent worker as 'V' or 'I'
4454: -- HISTORY
4455: -- 05-MAR-207 kjai Created for Bug 5683340
4456: --
4457: FUNCTION get_term_type( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE )
4458: RETURN VARCHAR2
4459: IS
4460:
4461: l_formula_id NUMBER;

Line 4479: CURSOR c_leav_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)

4475: AND formula_name = 'HR_PA_MOVE'
4476: AND formula_type_id
4477: = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
4478:
4479: CURSOR c_leav_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4480: IS
4481: SELECT leaving_reason
4482: FROM (SELECT leaving_reason
4483: FROM per_periods_of_service

Line 4489: CURSOR c_term_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)

4485: AND actual_termination_date IS NOT NULL
4486: ORDER BY actual_termination_date DESC)
4487: WHERE ROWNUM = 1;
4488:
4489: CURSOR c_term_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4490: IS
4491: SELECT termination_reason
4492: FROM (SELECT termination_reason
4493: FROM per_periods_of_placement

Line 4566: PROCEDURE Init_FTE_Sync_WF( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

4562: -- workflow for future termination of employee.
4563: -- HISTORY
4564: -- 05-MAR-207 kjai Created for Bug 5683340
4565: --
4566: PROCEDURE Init_FTE_Sync_WF( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
4567: x_invol_term OUT NOCOPY VARCHAR2,
4568: x_return_status OUT NOCOPY VARCHAR2,
4569: x_msg_data OUT NOCOPY VARCHAR2,
4570: x_msg_count OUT NOCOPY NUMBER

Line 4720: PROCEDURE set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,

4716: -- in table pa_resources for the passed person_id
4717: -- HISTORY
4718: -- 05-MAR-207 kjai Created for Bug 5683340
4719: --
4720: PROCEDURE set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
4721: p_future_term_wf_flag IN PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
4722: x_return_status OUT NOCOPY VARCHAR2,
4723: x_msg_data OUT NOCOPY VARCHAR2,
4724: x_msg_count OUT NOCOPY NUMBER)

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

4781: -- in table pa_resources for the passed person_id
4782: -- HISTORY
4783: -- 05-MAR-207 kjai Created for Bug 5683340
4784: --
4785: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
4786: x_future_term_wf_flag OUT NOCOPY PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
4787: x_return_status OUT NOCOPY VARCHAR2,
4788: x_msg_data OUT NOCOPY VARCHAR2,
4789: x_msg_count OUT NOCOPY NUMBER)

Line 4853: PROCEDURE is_fte(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,

4849: -- If he is, then returns the actual term date , wait days.
4850: -- HISTORY
4851: -- 05-MAR-207 kjai Created for Bug 5683340
4852: --
4853: PROCEDURE is_fte(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,
4854: x_return_end_date OUT NOCOPY DATE ,
4855: x_wait_days OUT NOCOPY NUMBER ,
4856: x_invol_term OUT NOCOPY VARCHAR2,
4857: x_return_status OUT NOCOPY VARCHAR2,

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

4947: --
4948: -- HISTORY
4949: -- 05-MAR-207 kjai Created for Bug 5683340
4950: --
4951: PROCEDURE get_valid_enddate(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,
4952: p_actual_term_date IN DATE ,
4953: x_valid_end_date OUT NOCOPY DATE,
4954: x_return_status OUT NOCOPY VARCHAR2,
4955: x_msg_data OUT NOCOPY VARCHAR2,

Line 5025: CURSOR c_act_term_date (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)

5021: , funcmode IN VARCHAR2
5022: , resultout OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5023: IS
5024:
5025: CURSOR c_act_term_date (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
5026: IS
5027: SELECT TRUNC (NVL (ACT_TERM_DATE, sysdate))
5028: FROM
5029: (SELECT MAX(actual_termination_date)"ACT_TERM_DATE"

Line 5041: l_person_id PA_EMPLOYEES.PERSON_ID%TYPE;

5037: AND actual_termination_date IS NOT NULL )
5038: WHERE ACT_TERM_DATE IS NOT NULL ;
5039:
5040:
5041: l_person_id PA_EMPLOYEES.PERSON_ID%TYPE;
5042: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE ;
5043: l_end_date DATE ;
5044:
5045: l_msg_count NUMBER;