APPS.PER_PEOPLE_V14_PKG dependencies on PER_ALL_PEOPLE_F

Line 467: CURSOR C IS SELECT ROWID FROM PER_ALL_PEOPLE_F

463: X_fast_path_employee VARCHAR2 default NULL,
464: X_fte_capacity VARCHAR2 default NULL
465: ) IS
466: l_period_of_service_id NUMBER;
467: CURSOR C IS SELECT ROWID FROM PER_ALL_PEOPLE_F
468: WHERE person_id = X_Person_Id;
469: CURSOR C2 IS SELECT per_people_s.NEXTVAL FROM sys.dual;
470: --
471: CURSOR c_person IS

Line 473: FROM per_all_people_f

469: CURSOR C2 IS SELECT per_people_s.NEXTVAL FROM sys.dual;
470: --
471: CURSOR c_person IS
472: SELECT *
473: FROM per_all_people_f
474: WHERE person_id = x_person_id
475: AND x_effective_start_date
476: BETWEEN effective_start_date
477: AND effective_end_date;

Line 479: l_person per_all_people_f%ROWTYPE;

475: AND x_effective_start_date
476: BETWEEN effective_start_date
477: AND effective_end_date;
478: --
479: l_person per_all_people_f%ROWTYPE;
480: --
481: l_phone_ovn NUMBER := NULL ;
482: l_phone_id NUMBER := NULL ;
483: l_proc VARCHAR2(72):='per_people_v14_pkg.insert_row';

Line 503: INSERT INTO PER_ALL_PEOPLE_F(

499: ,p_effective_date => X_effective_start_date
500: ,p_object_version_number => NULL);
501: END IF;
502: hr_utility.set_location(l_proc,20);
503: INSERT INTO PER_ALL_PEOPLE_F(
504: person_id,
505: effective_start_date,
506: effective_end_date,
507: business_group_id,

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

764: --
765: -- Now assign the resulting party id back to the record.
766: --
767: --Bug fix 4861893
768: --update statement modified ,per_All_people_f used instead of per_people_f.
769: IF x_party_id IS NULL THEN
770: UPDATE per_all_people_f
771: SET party_id = l_person.party_id
772: WHERE person_id = x_person_id;

Line 770: UPDATE per_all_people_f

766: --
767: --Bug fix 4861893
768: --update statement modified ,per_All_people_f used instead of per_people_f.
769: IF x_party_id IS NULL THEN
770: UPDATE per_all_people_f
771: SET party_id = l_person.party_id
772: WHERE person_id = x_person_id;
773: END IF;
774: --

Line 796: ,p_parent_table => 'PER_ALL_PEOPLE_F'

792: ,p_date_to => NULL
793: ,p_phone_type => 'W1'
794: ,p_phone_number => x_work_telephone
795: ,p_parent_id => x_person_id
796: ,p_parent_table => 'PER_ALL_PEOPLE_F'
797: ,p_validate => FALSE
798: ,p_effective_date => x_start_date
799: ,p_object_version_number => l_phone_ovn --out
800: ,p_phone_id => l_phone_id --out

Line 942: FROM PER_ALL_PEOPLE_F

938: X_Per_Information30 VARCHAR2) IS
939:
940: CURSOR C IS
941: SELECT *
942: FROM PER_ALL_PEOPLE_F
943: WHERE ROWID = X_Rowid
944: FOR UPDATE OF Person_Id NOWAIT;
945: Recinfo C%ROWTYPE;
946: