APPS.PQP_PERASGADD_RIW dependencies on PER_CONTACT_RELATIONSHIPS

Line 21: g_cnt_rec per_contact_relationships%rowtype;

17: g_add_rec per_addresses%rowtype;
18: g_grp_rec pay_people_groups%rowtype;
19: g_asg_rec per_all_assignments_f%rowtype;
20: g_phn_rec per_phones%rowtype;
21: g_cnt_rec per_contact_relationships%rowtype;
22: g_interface_code varchar2(150);
23: g_migration_flag varchar2(5);
24:
25: --$ Added by Dbansal to upload comments

Line 136: (contact_relationship_id per_contact_relationships.contact_relationship_id%type

132: ,oversubscribed_vacancy_id number
133: );
134:
135: type t_createcontact_api is record
136: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
137: ,ctr_object_version_number per_contact_relationships.object_version_number%type
138: ,per_person_id per_contact_relationships.contact_person_id%type
139: ,per_object_version_number per_contact_relationships.object_version_number%type
140: ,per_effective_start_date per_contact_relationships.date_start%type

Line 137: ,ctr_object_version_number per_contact_relationships.object_version_number%type

133: );
134:
135: type t_createcontact_api is record
136: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
137: ,ctr_object_version_number per_contact_relationships.object_version_number%type
138: ,per_person_id per_contact_relationships.contact_person_id%type
139: ,per_object_version_number per_contact_relationships.object_version_number%type
140: ,per_effective_start_date per_contact_relationships.date_start%type
141: ,per_effective_end_date per_contact_relationships.date_start%type

Line 138: ,per_person_id per_contact_relationships.contact_person_id%type

134:
135: type t_createcontact_api is record
136: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
137: ,ctr_object_version_number per_contact_relationships.object_version_number%type
138: ,per_person_id per_contact_relationships.contact_person_id%type
139: ,per_object_version_number per_contact_relationships.object_version_number%type
140: ,per_effective_start_date per_contact_relationships.date_start%type
141: ,per_effective_end_date per_contact_relationships.date_start%type
142: ,full_name per_all_people_f.full_name%type

Line 139: ,per_object_version_number per_contact_relationships.object_version_number%type

135: type t_createcontact_api is record
136: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
137: ,ctr_object_version_number per_contact_relationships.object_version_number%type
138: ,per_person_id per_contact_relationships.contact_person_id%type
139: ,per_object_version_number per_contact_relationships.object_version_number%type
140: ,per_effective_start_date per_contact_relationships.date_start%type
141: ,per_effective_end_date per_contact_relationships.date_start%type
142: ,full_name per_all_people_f.full_name%type
143: ,per_comment_id per_all_people_f.comment_id%type

Line 140: ,per_effective_start_date per_contact_relationships.date_start%type

136: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
137: ,ctr_object_version_number per_contact_relationships.object_version_number%type
138: ,per_person_id per_contact_relationships.contact_person_id%type
139: ,per_object_version_number per_contact_relationships.object_version_number%type
140: ,per_effective_start_date per_contact_relationships.date_start%type
141: ,per_effective_end_date per_contact_relationships.date_start%type
142: ,full_name per_all_people_f.full_name%type
143: ,per_comment_id per_all_people_f.comment_id%type
144: ,name_combination_warning boolean

Line 141: ,per_effective_end_date per_contact_relationships.date_start%type

137: ,ctr_object_version_number per_contact_relationships.object_version_number%type
138: ,per_person_id per_contact_relationships.contact_person_id%type
139: ,per_object_version_number per_contact_relationships.object_version_number%type
140: ,per_effective_start_date per_contact_relationships.date_start%type
141: ,per_effective_end_date per_contact_relationships.date_start%type
142: ,full_name per_all_people_f.full_name%type
143: ,per_comment_id per_all_people_f.comment_id%type
144: ,name_combination_warning boolean
145: ,orig_hire_warning boolean

Line 470: from per_contact_relationships

466: cursor csr_ck_cont_xsts(c_person_id in number
467: ,c_business_group_id in number
468: ,c_effective_date in date) is
469: select object_version_number
470: from per_contact_relationships
471: where person_id = c_person_id
472: and business_group_id = c_business_group_id
473: and c_effective_date between date_start
474: and NVL(date_end, c_effective_date);