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 798: FROM per_people_f

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

Line 926: INSERT INTO PER_PEOPLE_F(

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

Line 1241: UPDATE per_people_f

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

Line 1321: -- be created in PER_PEOPLE_F

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