APPS.PER_PEOPLE_V15_PKG dependencies on PER_PEOPLE_F

Line 204: UPDATE PER_PEOPLE_F

200: p_local_name => l_local_name,
201: p_duplicate_flag => l_dup_name
202: );
203: -- << 3889584
204: UPDATE PER_PEOPLE_F
205: SET
206: person_id = X_Person_Id,
207: effective_start_date = X_Effective_Start_Date,
208: effective_end_date = X_Effective_End_Date,

Line 297: DELETE FROM PER_PEOPLE_F

293: END Update_Row;
294: --
295: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
296: BEGIN
297: DELETE FROM PER_PEOPLE_F
298: WHERE rowid = X_Rowid;
299: if (SQL%NOTFOUND) then
300: RAISE NO_DATA_FOUND;
301: end if;

Line 341: from per_people_f

337: and pst.system_person_type = 'EX_EMP';
338: cursor person
339: is
340: select *
341: from per_people_f
342: where rowid = chartorowid(X_Rowid);
343: --
344: per_rec person%ROWTYPE;
345: l_person_type_id number;

Line 584: from per_people_f

580: ,X_s_termination_date DATE )
581: IS
582: cursor person
583: is select person_id
584: from per_people_f
585: where person_id = X_Person_Id
586: for update of Person_Id;
587: --
588: cursor assignment

Line 646: delete from per_people_f

642: --
643: -- Reverse Date-track change by deleting current row
644: -- and updating Previous row.
645: --
646: delete from per_people_f
647: where effective_start_date = X_s_termination_date + 1
648: and person_id = X_person_id;
649: --
650: update per_people_f

Line 650: update per_people_f

646: delete from per_people_f
647: where effective_start_date = X_s_termination_date + 1
648: and person_id = X_person_id;
649: --
650: update per_people_f
651: set effective_end_date = to_date ('31-12-4712','DD-MM-YYYY')
652: where effective_end_date = X_s_termination_date
653: and person_id = X_person_id;
654: end cancel_termination;

Line 664: from per_people_f

660: ,X_Hire_Date DATE)
661: IS
662: cursor person
663: is select *
664: from per_people_f
665: where person_id = X_Person_Id
666: and X_Hire_date between
667: effective_start_Date and effective_end_date
668: for update of effective_end_date;

Line 712: update per_people_f

708: --
709: begin
710: open person;
711: fetch person into per_rec;
712: update per_people_f
713: set effective_end_date = X_Hire_date - 1
714: where current of person;
715: close person;
716: --

Line 922: from per_people_f ppf

918: IS
919: cursor future_exists
920: IS
921: select 'Y'
922: from per_people_f ppf
923: ,per_person_types ppt
924: ,per_startup_person_types pst
925: where ppf.person_type_id = ppt.person_type_id
926: and ppf.person_id = p_person_id

Line 954: from per_people_f p

950: IS
951: cursor get_future_changes
952: is
953: select 'Y'
954: from per_people_f p
955: where p.effective_start_date > p_hire_date
956: and p.person_id = p_person_id;
957: --
958: cursor check_person

Line 961: from per_people_f p

957: --
958: cursor check_person
959: is
960: select 'Y'
961: from per_people_f p
962: where p.effective_start_date > p_hire_date - 1
963: and p.effective_start_date <> p_s_hire_date
964: and p.person_id = p_person_id;
965: --