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:
24: --$ Added by Dbansal to upload comments
25: g_per_comments varchar2(150);

Line 135: (contact_relationship_id per_contact_relationships.contact_relationship_id%type

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

Line 136: ,ctr_object_version_number per_contact_relationships.object_version_number%type

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

Line 137: ,per_person_id per_contact_relationships.contact_person_id%type

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

Line 138: ,per_object_version_number per_contact_relationships.object_version_number%type

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

Line 139: ,per_effective_start_date per_contact_relationships.date_start%type

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

Line 140: ,per_effective_end_date per_contact_relationships.date_start%type

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

Line 469: from per_contact_relationships

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