[Home] [Help]
14:
15: g_per_rec per_all_people_f%rowtype;
16: g_scl_rec hr_soft_coding_keyflex%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);
68: (asg_object_version_number per_all_assignments_f.object_version_number%type
69: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type
70: ,people_group_id per_all_assignments_f.people_group_id%type
71: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type
72: ,group_name pay_people_groups.group_name%type
73: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
74: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
75: ,org_now_no_manager_warning boolean
76: ,other_manager_warning boolean
1278: -- =============================================================================
1279: -- Default_PpgFlx_Rec:
1280: -- =============================================================================
1281: function Default_PpgFlx_Rec
1282: return pay_people_groups%rowtype is
1283: l_proc_name constant varchar2(150) := g_pkg||'Default_PpgFlx_Rec';
1284: l_grp_rec pay_people_groups%rowtype;
1285: begin
1286: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1280: -- =============================================================================
1281: function Default_PpgFlx_Rec
1282: return pay_people_groups%rowtype is
1283: l_proc_name constant varchar2(150) := g_pkg||'Default_PpgFlx_Rec';
1284: l_grp_rec pay_people_groups%rowtype;
1285: begin
1286: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1287: /*
1288: ======================================================================
1344: -- Get_GrpRecord_Values:
1345: -- =============================================================================
1346: function Get_GrpRecord_Values
1347: (p_interface_code in varchar2 default null)
1348: return pay_people_groups%rowtype is
1349:
1350: cursor bne_cols(c_interface_code in varchar2) is
1351: select lower(bic.interface_col_name) interface_col_name
1352: from bne_interface_cols_b bic
1355: --$ Commented this as segments value is not passed due to this flag
1356: -- and bic.display_flag ='Y';
1357:
1358: l_proc_name constant varchar2(150) := g_pkg||'Get_GrpRecord_Values';
1359: l_grp_rec pay_people_groups%rowtype;
1360: col_name varchar2(150);
1361:
1362: begin
1363: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2263:
2264: -- Cursor to get people group flexfield details
2265: cursor csr_ppg (c_people_grp_id in number) is
2266: select *
2267: from pay_people_groups
2268: where people_group_id = c_people_grp_id;
2269:
2270: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2271:
2266: select *
2267: from pay_people_groups
2268: where people_group_id = c_people_grp_id;
2269:
2270: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2271:
2272: -- Cursor to get Soft coding flexfield details
2273: cursor csr_scl (c_scl_kff_id in number) is
2274: select *
2286: l_upd_chg_ins boolean;
2287: e_empasg_notfound exception;
2288: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
2289: l_asg_rec per_all_assignments_f%rowtype;
2290: l_grp_rec pay_people_groups%rowtype;
2291: l_scl_rec hr_soft_coding_keyflex%rowtype;
2292:
2293: begin
2294: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2597:
2598: -- Cursor to get people group flexfield details
2599: cursor csr_ppg (c_people_grp_id in number) is
2600: select *
2601: from pay_people_groups
2602: where people_group_id = c_people_grp_id;
2603:
2604: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2605:
2600: select *
2601: from pay_people_groups
2602: where people_group_id = c_people_grp_id;
2603:
2604: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2605:
2606: -- Cursor to get Soft coding flexfield details
2607: cursor csr_scl (c_scl_kff_id in number) is
2608: select *
2620: l_upd_chg_ins boolean;
2621: e_empasg_notfound exception;
2622: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
2623: l_asg_rec per_all_assignments_f%rowtype;
2624: l_grp_rec pay_people_groups%rowtype;
2625: l_scl_rec hr_soft_coding_keyflex%rowtype;
2626:
2627: begin
2628: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2961:
2962: -- Cursor to get people group flexfield details
2963: cursor csr_ppg (c_people_grp_id in number) is
2964: select *
2965: from pay_people_groups
2966: where people_group_id = c_people_grp_id;
2967:
2968: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2969:
2964: select *
2965: from pay_people_groups
2966: where people_group_id = c_people_grp_id;
2967:
2968: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2969:
2970: -- Cursor to get Soft coding flexfield details
2971: cursor csr_scl (c_scl_kff_id in number) is
2972: select *
2984: l_upd_chg_ins boolean;
2985: e_empasg_notfound exception;
2986: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
2987: l_asg_rec per_all_assignments_f%rowtype;
2988: l_grp_rec pay_people_groups%rowtype;
2989: l_scl_rec hr_soft_coding_keyflex%rowtype;
2990: begin
2991: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2992:
8498: -- Added by dbansal
8499: l_hrEmpApi_out t_hrEmpApi;
8500: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
8501: l_asg_rec1 per_all_assignments_f%rowtype;
8502: l_grp_rec pay_people_groups%rowtype;
8503: l_scl_rec hr_soft_coding_keyflex%rowtype;
8504: l_pty_rec csr_type%rowtype;
8505: l_apl_asg_rec per_all_assignments_f%rowtype;
8506: begin