APPS.PQP_HROSS_INTEGRATION dependencies on HR_SOFT_CODING_KEYFLEX

Line 16: l_hr_soft_rec hr_soft_coding_keyflex%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:
19: TYPE t_hrEmpApi IS RECORD
20: (person_id per_all_people_f.person_id%TYPE

Line 48: ,concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE

44: ,other_manager_warning Boolean
45: ,spp_delete_warning Boolean
46: ,entries_changed_warning Varchar2(50)
47: ,tax_district_changed_warning Boolean
48: ,concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE
49: ,gsp_post_process_warning Varchar2(2000)
50: ,comment_id per_assignments_f.comment_id%TYPE
51: );
52:

Line 607: FROM hr_soft_coding_keyflex

603:
604: -- Cursor to get Soft coding flexfield details
605: CURSOR csr_scl (c_scl_kff_id IN Number) IS
606: SELECT *
607: FROM hr_soft_coding_keyflex
608: WHERE soft_coding_keyflex_id = c_scl_kff_id;
609:
610: l_cur_scl_rec hr_soft_coding_keyflex%ROWTYPE;
611:

Line 610: l_cur_scl_rec hr_soft_coding_keyflex%ROWTYPE;

606: SELECT *
607: FROM hr_soft_coding_keyflex
608: WHERE soft_coding_keyflex_id = c_scl_kff_id;
609:
610: l_cur_scl_rec hr_soft_coding_keyflex%ROWTYPE;
611:
612: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Update_StuEmpAsg_Criteria';
613: l_error_msg Varchar2(2000);
614: l_datetrack_update_mode Varchar2(50);

Line 858: -- Hr Soft Coding KeyFlex segments

854: ,p_ass_attribute27 => l_asg_rec.ass_attribute27
855: ,p_ass_attribute28 => l_asg_rec.ass_attribute28
856: ,p_ass_attribute29 => l_asg_rec.ass_attribute29
857: ,p_ass_attribute30 => l_asg_rec.ass_attribute30
858: -- Hr Soft Coding KeyFlex segments
859: ,p_segment1 => l_hr_soft_rec.segment1
860: ,p_segment2 => l_hr_soft_rec.segment2
861: ,p_segment3 => l_hr_soft_rec.segment3
862: ,p_segment4 => l_hr_soft_rec.segment4