APPS.PQP_HROSS_INTEGRATION dependencies on PER_CONTACT_RELATIONSHIPS

Line 14: l_cntct_rec per_contact_relationships%ROWTYPE;

10: g_debug_on Boolean;
11: l_per_rec per_all_people_f%ROWTYPE;
12: l_asg_rec per_all_assignments_f%ROWTYPE;
13: l_add_rec per_addresses%ROWTYPE;
14: l_cntct_rec per_contact_relationships%ROWTYPE;
15: l_phones_rec per_phones%ROWTYPE;
16: l_hr_soft_rec hr_soft_coding_keyflex%ROWTYPE;
17: l_ppl_grp_rec pay_people_groups%ROWTYPE;
18:

Line 103: (contact_relationship_id per_contact_relationships.contact_relationship_id%TYPE

99: ,oversubscribed_vacancy_id Number
100: );
101:
102: TYPE t_CreateContact_Api IS RECORD
103: (contact_relationship_id per_contact_relationships.contact_relationship_id%TYPE
104: ,ctr_object_version_number per_contact_relationships.object_version_number%TYPE
105: ,per_person_id per_contact_relationships.contact_person_id%TYPE
106: ,per_object_version_number
107: per_contact_relationships.object_version_number%TYPE

Line 104: ,ctr_object_version_number per_contact_relationships.object_version_number%TYPE

100: );
101:
102: TYPE t_CreateContact_Api IS RECORD
103: (contact_relationship_id per_contact_relationships.contact_relationship_id%TYPE
104: ,ctr_object_version_number per_contact_relationships.object_version_number%TYPE
105: ,per_person_id per_contact_relationships.contact_person_id%TYPE
106: ,per_object_version_number
107: per_contact_relationships.object_version_number%TYPE
108: ,per_effective_start_date per_contact_relationships.date_start%TYPE

Line 105: ,per_person_id per_contact_relationships.contact_person_id%TYPE

101:
102: TYPE t_CreateContact_Api IS RECORD
103: (contact_relationship_id per_contact_relationships.contact_relationship_id%TYPE
104: ,ctr_object_version_number per_contact_relationships.object_version_number%TYPE
105: ,per_person_id per_contact_relationships.contact_person_id%TYPE
106: ,per_object_version_number
107: per_contact_relationships.object_version_number%TYPE
108: ,per_effective_start_date per_contact_relationships.date_start%TYPE
109: ,per_effective_end_date per_contact_relationships.date_start%TYPE

Line 107: per_contact_relationships.object_version_number%TYPE

103: (contact_relationship_id per_contact_relationships.contact_relationship_id%TYPE
104: ,ctr_object_version_number per_contact_relationships.object_version_number%TYPE
105: ,per_person_id per_contact_relationships.contact_person_id%TYPE
106: ,per_object_version_number
107: per_contact_relationships.object_version_number%TYPE
108: ,per_effective_start_date per_contact_relationships.date_start%TYPE
109: ,per_effective_end_date per_contact_relationships.date_start%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,per_comment_id per_all_people_f.comment_id%TYPE

Line 108: ,per_effective_start_date per_contact_relationships.date_start%TYPE

104: ,ctr_object_version_number per_contact_relationships.object_version_number%TYPE
105: ,per_person_id per_contact_relationships.contact_person_id%TYPE
106: ,per_object_version_number
107: per_contact_relationships.object_version_number%TYPE
108: ,per_effective_start_date per_contact_relationships.date_start%TYPE
109: ,per_effective_end_date per_contact_relationships.date_start%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,per_comment_id per_all_people_f.comment_id%TYPE
112: ,name_combination_warning Boolean

Line 109: ,per_effective_end_date per_contact_relationships.date_start%TYPE

105: ,per_person_id per_contact_relationships.contact_person_id%TYPE
106: ,per_object_version_number
107: per_contact_relationships.object_version_number%TYPE
108: ,per_effective_start_date per_contact_relationships.date_start%TYPE
109: ,per_effective_end_date per_contact_relationships.date_start%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,per_comment_id per_all_people_f.comment_id%TYPE
112: ,name_combination_warning Boolean
113: ,orig_hire_warning Boolean

Line 398: FROM per_contact_relationships

394: CURSOR csr_ck_cont_xsts(c_person_id IN Number
395: ,c_business_group_id IN Number
396: ,c_effective_date IN Date) IS
397: SELECT object_version_number
398: FROM per_contact_relationships
399: WHERE person_id = c_person_id
400: AND business_group_id = c_business_group_id
401: AND c_effective_date BETWEEN date_start
402: AND NVL(date_end, c_effective_date);

Line 2713: FROM per_contact_relationships

2709: CURSOR csr_get_cont_dtls(c_person_id IN Number
2710: ,c_business_group_id IN Number
2711: ,c_effective_date IN Date) IS
2712: SELECT *
2713: FROM per_contact_relationships
2714: WHERE person_id = c_person_id
2715: AND business_group_id = c_business_group_id
2716: AND c_effective_date BETWEEN date_start
2717: AND NVL(date_end, c_effective_date);

Line 2736: per_contact_relationships.object_version_number%TYPE;

2732: l_dt_upd_override Boolean;
2733: l_upd_chg_ins Boolean;
2734:
2735: l_cont_object_version_num
2736: per_contact_relationships.object_version_number%TYPE;
2737: l_cur_add_rec per_addresses%ROWTYPE;
2738: l_cont_rec per_contact_relationships%ROWTYPE;
2739: l_pay_basis_name per_pay_bases.NAME%TYPE;
2740: l_organization_name hr_all_organization_units.NAME%TYPE;

Line 2738: l_cont_rec per_contact_relationships%ROWTYPE;

2734:
2735: l_cont_object_version_num
2736: per_contact_relationships.object_version_number%TYPE;
2737: l_cur_add_rec per_addresses%ROWTYPE;
2738: l_cont_rec per_contact_relationships%ROWTYPE;
2739: l_pay_basis_name per_pay_bases.NAME%TYPE;
2740: l_organization_name hr_all_organization_units.NAME%TYPE;
2741: l_location_code hr_locations_all.location_code%TYPE;
2742: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

Line 6936: -- Person Contact: Per_Contact_Relationships

6932: ,p_phone_type IN Varchar2
6933: ,p_phone_number IN Varchar2
6934: ,p_phone_date_from IN Date
6935: ,p_phone_date_to IN Date
6936: -- Person Contact: Per_Contact_Relationships
6937: ,p_contact_type IN Varchar2
6938: ,p_contact_name IN Varchar2
6939: ,p_primary_contact IN Varchar2
6940: ,p_primary_relationship IN Varchar2