5902: -- name is validated against pa_exp_ovrrde_approver_v view.
5903: --
5904: -- Parameters :
5905: -- IN
5906: -- P_Approver_Id - Per_People_F.Person_Id%TYPE
5907: --
5908: -- OUT
5909: -- X_Approver_Id - Per_People_F.Person_Id%TYPE
5910: -- X_Error_Type - Varchar2
5905: -- IN
5906: -- P_Approver_Id - Per_People_F.Person_Id%TYPE
5907: --
5908: -- OUT
5909: -- X_Approver_Id - Per_People_F.Person_Id%TYPE
5910: -- X_Error_Type - Varchar2
5911: -- X_Error_Code - Varchar2
5912: /* ------------------------------------------------------------------------*/
5913:
5911: -- X_Error_Code - Varchar2
5912: /* ------------------------------------------------------------------------*/
5913:
5914: Procedure Validate_Overriding_Approver(
5915: P_Approver_Id IN Per_People_F.Person_Id%TYPE,
5916: X_Approver_Id OUT NOCOPY Per_People_F.Person_Id%TYPE,
5917: X_Error_Type OUT NOCOPY Varchar2,
5918: X_Error_Code OUT NOCOPY Varchar2) Is
5919:
5912: /* ------------------------------------------------------------------------*/
5913:
5914: Procedure Validate_Overriding_Approver(
5915: P_Approver_Id IN Per_People_F.Person_Id%TYPE,
5916: X_Approver_Id OUT NOCOPY Per_People_F.Person_Id%TYPE,
5917: X_Error_Type OUT NOCOPY Varchar2,
5918: X_Error_Code OUT NOCOPY Varchar2) Is
5919:
5920: Begin
7868: from hxc_recurring_periods hrp
7869: where hrp.recurring_period_id = p_rec_id;
7870: /* Added the cursor for bug 7584432 */
7871: Cursor get_termination_date(p_person_id number, p_stop_date DATE) is
7872: Select max(effective_end_date) from per_people_f
7873: where person_id = p_person_id and
7874: effective_end_date <= p_stop_date and
7875: (current_employee_flag = 'Y' or current_npw_flag = 'Y');
7876:
9496: Decode(Current_Npw_Flag,'Y','CWK','EMP')
9497: Into
9498: X_Person_Type
9499: From
9500: Per_People_F
9501: Where
9502: P_Ei_Date between Effective_Start_Date
9503: and Effective_End_Date
9504: And Person_Id = P_Person_Id;