APPS.PER_PEOPLE_V14_PKG dependencies on PER_ALL_PEOPLE_F

Line 423: CURSOR C IS SELECT ROWID FROM PER_ALL_PEOPLE_F

419: X_fast_path_employee VARCHAR2 default NULL,
420: X_fte_capacity VARCHAR2 default NULL
421: ) IS
422: l_period_of_service_id NUMBER;
423: CURSOR C IS SELECT ROWID FROM PER_ALL_PEOPLE_F
424: WHERE person_id = X_Person_Id;
425: CURSOR C2 IS SELECT per_people_s.NEXTVAL FROM sys.dual;
426: --
427: CURSOR c_person IS

Line 429: FROM per_all_people_f

425: CURSOR C2 IS SELECT per_people_s.NEXTVAL FROM sys.dual;
426: --
427: CURSOR c_person IS
428: SELECT *
429: FROM per_all_people_f
430: WHERE person_id = x_person_id
431: AND x_effective_start_date
432: BETWEEN effective_start_date
433: AND effective_end_date;

Line 435: l_person per_all_people_f%ROWTYPE;

431: AND x_effective_start_date
432: BETWEEN effective_start_date
433: AND effective_end_date;
434: --
435: l_person per_all_people_f%ROWTYPE;
436: --
437: l_phone_ovn NUMBER := NULL ;
438: l_phone_id NUMBER := NULL ;
439: l_proc VARCHAR2(72):='per_people_v14_pkg.insert_row';

Line 459: INSERT INTO PER_ALL_PEOPLE_F(

455: ,p_effective_date => X_effective_start_date
456: ,p_object_version_number => NULL);
457: END IF;
458: hr_utility.set_location(l_proc,20);
459: INSERT INTO PER_ALL_PEOPLE_F(
460: person_id,
461: effective_start_date,
462: effective_end_date,
463: business_group_id,

Line 724: --update statement modified ,per_All_people_f used instead of per_people_f.

720: --
721: -- Now assign the resulting party id back to the record.
722: --
723: --Bug fix 4861893
724: --update statement modified ,per_All_people_f used instead of per_people_f.
725: IF x_party_id IS NULL THEN
726: UPDATE per_all_people_f
727: SET party_id = l_person.party_id
728: WHERE person_id = x_person_id;

Line 726: UPDATE per_all_people_f

722: --
723: --Bug fix 4861893
724: --update statement modified ,per_All_people_f used instead of per_people_f.
725: IF x_party_id IS NULL THEN
726: UPDATE per_all_people_f
727: SET party_id = l_person.party_id
728: WHERE person_id = x_person_id;
729: END IF;
730: --

Line 752: ,p_parent_table => 'PER_ALL_PEOPLE_F'

748: ,p_date_to => NULL
749: ,p_phone_type => 'W1'
750: ,p_phone_number => x_work_telephone
751: ,p_parent_id => x_person_id
752: ,p_parent_table => 'PER_ALL_PEOPLE_F'
753: ,p_validate => FALSE
754: ,p_effective_date => x_start_date
755: ,p_object_version_number => l_phone_ovn --out
756: ,p_phone_id => l_phone_id --out

Line 897: FROM PER_ALL_PEOPLE_F

893: X_Per_Information30 VARCHAR2) IS
894:
895: CURSOR C IS
896: SELECT *
897: FROM PER_ALL_PEOPLE_F
898: WHERE ROWID = X_Rowid
899: FOR UPDATE OF Person_Id NOWAIT;
900: Recinfo C%ROWTYPE;
901: