APPS.PER_CTR_BUS dependencies on PER_CONTACT_RELATIONSHIPS

Line 244: per_contact_relationships.object_version_number%TYPE,

240: --
241: procedure chk_contact_type
242: (p_effective_date in date,
243: p_object_version_number in
244: per_contact_relationships.object_version_number%TYPE,
245: p_contact_type in
246: per_contact_relationships.contact_type%TYPE,
247: p_contact_relationship_id in
248: per_contact_relationships.contact_relationship_id%TYPE

Line 246: per_contact_relationships.contact_type%TYPE,

242: (p_effective_date in date,
243: p_object_version_number in
244: per_contact_relationships.object_version_number%TYPE,
245: p_contact_type in
246: per_contact_relationships.contact_type%TYPE,
247: p_contact_relationship_id in
248: per_contact_relationships.contact_relationship_id%TYPE
249: ) is
250: --

Line 248: per_contact_relationships.contact_relationship_id%TYPE

244: per_contact_relationships.object_version_number%TYPE,
245: p_contact_type in
246: per_contact_relationships.contact_type%TYPE,
247: p_contact_relationship_id in
248: per_contact_relationships.contact_relationship_id%TYPE
249: ) is
250: --
251: l_proc varchar2(72) := g_package||'chk_contact_type';
252: l_api_updating boolean;

Line 356: per_contact_relationships.primary_contact_flag%TYPE,

352: procedure chk_primary_contact(p_contact_relationship_id number,
353: p_person_id NUMBER,
354: p_object_version_number in number,
355: p_primary_contact_flag in
356: per_contact_relationships.primary_contact_flag%TYPE,
357: p_date_start date,
358: p_date_end date) is
359: cursor csr_chk_primary_cnt is
360: select 'Y'

Line 361: from per_contact_relationships

357: p_date_start date,
358: p_date_end date) is
359: cursor csr_chk_primary_cnt is
360: select 'Y'
361: from per_contact_relationships
362: where person_id = p_person_id
363: and primary_contact_flag = 'Y'
364: and (nvl(date_end,hr_general.end_of_time)
365: > nvl(p_date_start,hr_general.start_of_time)

Line 623: -- PER_CONTACT_RELATIONSHIPS on the same effective date.

619: -- ---------------------------------------------------------------------
620: --
621: -- Description:
622: -- Validates that only one relationship of the same type exists in
623: -- PER_CONTACT_RELATIONSHIPS on the same effective date.
624: --
625: -- Pre-Requisites:
626: -- None.
627: --

Line 663: from per_contact_relationships per

659: l_end_of_time date := hr_general.end_of_time;
660:
661: cursor csr_chk_time_validation is
662: select 'X'
663: from per_contact_relationships per
664: where per.person_id = p_person_id
665: and per.contact_person_id = p_contact_person_id
666: and (per.contact_relationship_id <> p_contact_relationship_id
667: or p_contact_relationship_id is null)

Line 756: from per_contact_relationships con

752: l_sequence_other number;
753: --
754: cursor csr_seq is
755: select sequence_number
756: from per_contact_relationships con
757: where con.person_id = p_person_id
758: and con.contact_person_id = p_contact_person_id
759: and con.sequence_number <> p_sequence_number;
760: --

Line 763: from per_contact_relationships con

759: and con.sequence_number <> p_sequence_number;
760: --
761: cursor csr_seq_others is
762: select sequence_number
763: from per_contact_relationships con
764: where con.person_id = p_person_id
765: and con.contact_person_id <> p_contact_person_id
766: and con.sequence_number = p_sequence_number;
767: --

Line 1601: , per_contact_relationships ctr

1597: --
1598: cursor csr_leg_code is
1599: select pbg.legislation_code
1600: from per_business_groups pbg
1601: , per_contact_relationships ctr
1602: where ctr.contact_relationship_id = p_contact_relationship_id
1603: and pbg.business_group_id = ctr.business_group_id;
1604: --
1605: -- Declare local variables