[Home] [Help]
706: --
707: -- This procedure is called from form PAXRESSC
708: --
709: PROCEDURE set_global_variables( p_selected_flag IN VARCHAR2
710: ,p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
711: ,p_version_id IN PER_ORG_STRUCTURE_ELEMENTS.ORG_STRUCTURE_VERSION_ID%TYPE
712: ,p_start_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
713: )
714: IS
732:
733: --
734: -- This Function is used by the view pa_org_authority_v.
735: --
736: FUNCTION get_person_id RETURN PA_EMPLOYEES.PERSON_ID%TYPE
737: IS
738: BEGIN
739: RETURN G_PERSON_ID;
740: END get_person_id;
766: -- This Procedure, receives person_id, org_id and populates the flags corresponding the
767: -- check-boxes in the form. (Used in PAXRESSC)
768: --
769:
770: PROCEDURE populate_role_flags( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE
771: ,p_org_id IN PER_ORG_STRUCTURE_ELEMENTS.ORGANIZATION_ID_PARENT%TYPE
772: ,x_res_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
773: ,x_proj_aut_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
774: ,x_prim_ctct_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4710: l_manager_start_date := trunc(sysdate);
4711: ELSE
4712:
4713: BEGIN
4714: select effective_start_date into l_manager_start_date from pa_employees
4715: where person_id=x_ManagerId
4716: and active='*';
4717: EXCEPTION
4718: WHEN NO_DATA_FOUND then
4789: -- of an employee/contingent worker as 'V' or 'I'
4790: -- HISTORY
4791: -- 05-MAR-207 kjai Created for Bug 5683340
4792: --
4793: FUNCTION get_term_type( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE )
4794: RETURN VARCHAR2
4795: IS
4796:
4797: l_formula_id NUMBER;
4811: AND formula_name = 'HR_PA_MOVE'
4812: AND formula_type_id
4813: = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
4814:
4815: CURSOR c_leav_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4816: IS
4817: SELECT leaving_reason
4818: FROM (SELECT leaving_reason
4819: FROM per_periods_of_service
4821: AND actual_termination_date IS NOT NULL
4822: ORDER BY actual_termination_date DESC)
4823: WHERE ROWNUM = 1;
4824:
4825: CURSOR c_term_reas (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4826: IS
4827: SELECT termination_reason
4828: FROM (SELECT termination_reason
4829: FROM per_periods_of_placement
4832: ORDER BY actual_termination_date DESC)
4833: WHERE ROWNUM = 1;
4834:
4835: -- Bug 7588937
4836: CURSOR c_res_person_type (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
4837: IS
4838: SELECT distinct(resource_person_type)
4839: FROM pa_resources_denorm
4840: WHERE person_id = c_person_id;
4918: -- workflow for future termination of employee.
4919: -- HISTORY
4920: -- 05-MAR-207 kjai Created for Bug 5683340
4921: --
4922: PROCEDURE Init_FTE_Sync_WF( p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
4923: x_invol_term OUT NOCOPY VARCHAR2,
4924: x_return_status OUT NOCOPY VARCHAR2,
4925: x_msg_data OUT NOCOPY VARCHAR2,
4926: x_msg_count OUT NOCOPY NUMBER
5072: -- in table pa_resources for the passed person_id
5073: -- HISTORY
5074: -- 05-MAR-207 kjai Created for Bug 5683340
5075: --
5076: PROCEDURE set_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
5077: p_future_term_wf_flag IN PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
5078: x_return_status OUT NOCOPY VARCHAR2,
5079: x_msg_data OUT NOCOPY VARCHAR2,
5080: x_msg_count OUT NOCOPY NUMBER)
5137: -- in table pa_resources for the passed person_id
5138: -- HISTORY
5139: -- 05-MAR-207 kjai Created for Bug 5683340
5140: --
5141: PROCEDURE Get_fte_flag(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE,
5142: x_future_term_wf_flag OUT NOCOPY PA_RESOURCES.FUTURE_TERM_WF_FLAG%TYPE,
5143: x_return_status OUT NOCOPY VARCHAR2,
5144: x_msg_data OUT NOCOPY VARCHAR2,
5145: x_msg_count OUT NOCOPY NUMBER)
5205: -- If he is, then returns the actual term date , wait days.
5206: -- HISTORY
5207: -- 05-MAR-207 kjai Created for Bug 5683340
5208: --
5209: PROCEDURE is_fte(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,
5210: x_return_end_date OUT NOCOPY DATE ,
5211: x_wait_days OUT NOCOPY NUMBER ,
5212: x_invol_term OUT NOCOPY VARCHAR2,
5213: x_return_status OUT NOCOPY VARCHAR2,
5303: --
5304: -- HISTORY
5305: -- 05-MAR-207 kjai Created for Bug 5683340
5306: --
5307: PROCEDURE get_valid_enddate(p_person_id IN PA_EMPLOYEES.PERSON_ID%TYPE ,
5308: p_actual_term_date IN DATE ,
5309: x_valid_end_date OUT NOCOPY DATE,
5310: x_return_status OUT NOCOPY VARCHAR2,
5311: x_msg_data OUT NOCOPY VARCHAR2,
5377: , funcmode IN VARCHAR2
5378: , resultout OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5379: IS
5380:
5381: CURSOR c_act_term_date (c_person_id PA_EMPLOYEES.PERSON_ID%TYPE)
5382: IS
5383: SELECT TRUNC (NVL (ACT_TERM_DATE, sysdate))
5384: FROM
5385: (SELECT MAX(actual_termination_date)"ACT_TERM_DATE"
5393: AND actual_termination_date IS NOT NULL )
5394: WHERE ACT_TERM_DATE IS NOT NULL ;
5395:
5396:
5397: l_person_id PA_EMPLOYEES.PERSON_ID%TYPE;
5398: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE ;
5399: l_end_date DATE ;
5400:
5401: l_msg_count NUMBER;