APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on PER_PEOPLE_F

Line 19: effective_start_date from per_people_f to set

15: THIRD_PARTY_PAY_FLAG + NATIONAL_IDENTIFIER.
16: SSDesai 05-Aug-95 70.8 Added Dependent and Beneficiary to
17: Delete_Validation.
18: JAlloun 08-OCT-96 70.10 366749 Added contact_only foreign key ch was picking up minimum
19: effective_start_date from per_people_f to set
20: the contacts effective_start_date !!!. Fixed the
21: problem by setting the constacts
22: effective_start_date to be the session date.
23: 13-FEB-97 FSHOJAAS 70.12 436371 Tow parameter were added to insert and update

Line 797: FROM per_people_f

793: l_dup_name VARCHAR2(1);
794: --
795: CURSOR C IS
796: SELECT ROWID
797: FROM per_people_f
798: WHERE person_id = X_Person_Id;
799: --
800: CURSOR C2 IS
801: SELECT per_people_s.NEXTVAL

Line 925: INSERT INTO PER_PEOPLE_F(

921: ,p_effective_date => l_effective_start_date
922: ,p_object_version_number => NULL);
923: END IF;
924:
925: INSERT INTO PER_PEOPLE_F(
926: person_id,
927: effective_start_date,
928: effective_end_date,
929: business_group_id,

Line 1240: UPDATE per_people_f

1236: --
1237: -- Now assign the resulting party id back to the record.
1238: --
1239: IF x_party_id IS NULL THEN
1240: UPDATE per_people_f
1241: SET party_id = l_person.party_id
1242: WHERE person_id = l_person_id;
1243: END IF;
1244: --

Line 1320: -- be created in PER_PEOPLE_F

1316: close csr_per_exists;
1317: end if;
1318: --
1319: -- If the Contact Person is null then this is a new person and a row must
1320: -- be created in PER_PEOPLE_F
1321: --
1322: IF X_Contact_Person_Id IS NULL THEN
1323: -- Need re-entrant code to be able to warn user that a potentially duplicate
1324: -- person may be created