[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);
69: (asg_object_version_number per_all_assignments_f.object_version_number%type
70: ,special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type
71: ,people_group_id per_all_assignments_f.people_group_id%type
72: ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type
73: ,group_name pay_people_groups.group_name%type
74: ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
75: ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
76: ,org_now_no_manager_warning boolean
77: ,other_manager_warning boolean
1279: -- =============================================================================
1280: -- Default_PpgFlx_Rec:
1281: -- =============================================================================
1282: function Default_PpgFlx_Rec
1283: return pay_people_groups%rowtype is
1284: l_proc_name constant varchar2(150) := g_pkg||'Default_PpgFlx_Rec';
1285: l_grp_rec pay_people_groups%rowtype;
1286: begin
1287: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1281: -- =============================================================================
1282: function Default_PpgFlx_Rec
1283: return pay_people_groups%rowtype is
1284: l_proc_name constant varchar2(150) := g_pkg||'Default_PpgFlx_Rec';
1285: l_grp_rec pay_people_groups%rowtype;
1286: begin
1287: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1288: /*
1289: ======================================================================
1345: -- Get_GrpRecord_Values:
1346: -- =============================================================================
1347: function Get_GrpRecord_Values
1348: (p_interface_code in varchar2 default null)
1349: return pay_people_groups%rowtype is
1350:
1351: cursor bne_cols(c_interface_code in varchar2) is
1352: select lower(bic.interface_col_name) interface_col_name
1353: from bne_interface_cols_b bic
1357: --If the concat segments column is included then each segment value is assigned to the passed value.
1358: --The segments will always have display flag as 'N'
1359:
1360: l_proc_name constant varchar2(150) := g_pkg||'Get_GrpRecord_Values';
1361: l_grp_rec pay_people_groups%rowtype;
1362: col_name varchar2(150);
1363:
1364: begin
1365: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2366:
2367: -- Cursor to get people group flexfield details
2368: cursor csr_ppg (c_people_grp_id in number) is
2369: select *
2370: from pay_people_groups
2371: where people_group_id = c_people_grp_id;
2372:
2373: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2374:
2369: select *
2370: from pay_people_groups
2371: where people_group_id = c_people_grp_id;
2372:
2373: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2374:
2375: -- Cursor to get Soft coding flexfield details
2376: cursor csr_scl (c_scl_kff_id in number) is
2377: select *
2389: l_upd_chg_ins boolean;
2390: e_empasg_notfound exception;
2391: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
2392: l_asg_rec per_all_assignments_f%rowtype;
2393: l_grp_rec pay_people_groups%rowtype;
2394: l_scl_rec hr_soft_coding_keyflex%rowtype;
2395: l_expected_system_status varchar2(20);
2396: l_return_status varchar2(100);
2397:
2853:
2854: -- Cursor to get people group flexfield details
2855: cursor csr_ppg (c_people_grp_id in number) is
2856: select *
2857: from pay_people_groups
2858: where people_group_id = c_people_grp_id;
2859:
2860: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2861:
2856: select *
2857: from pay_people_groups
2858: where people_group_id = c_people_grp_id;
2859:
2860: l_cur_ppl_grp_rec pay_people_groups%rowtype;
2861:
2862: -- Cursor to get Soft coding flexfield details
2863: cursor csr_scl (c_scl_kff_id in number) is
2864: select *
2876: l_upd_chg_ins boolean;
2877: e_empasg_notfound exception;
2878: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
2879: l_asg_rec per_all_assignments_f%rowtype;
2880: l_grp_rec pay_people_groups%rowtype;
2881: l_scl_rec hr_soft_coding_keyflex%rowtype;
2882:
2883: begin
2884: hr_utility.set_location('Entering: ' || l_proc_name, 10);
3217:
3218: -- Cursor to get people group flexfield details
3219: cursor csr_ppg (c_people_grp_id in number) is
3220: select *
3221: from pay_people_groups
3222: where people_group_id = c_people_grp_id;
3223:
3224: l_cur_ppl_grp_rec pay_people_groups%rowtype;
3225:
3220: select *
3221: from pay_people_groups
3222: where people_group_id = c_people_grp_id;
3223:
3224: l_cur_ppl_grp_rec pay_people_groups%rowtype;
3225:
3226: -- Cursor to get Soft coding flexfield details
3227: cursor csr_scl (c_scl_kff_id in number) is
3228: select *
3240: l_upd_chg_ins boolean;
3241: e_empasg_notfound exception;
3242: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
3243: l_asg_rec per_all_assignments_f%rowtype;
3244: l_grp_rec pay_people_groups%rowtype;
3245: l_scl_rec hr_soft_coding_keyflex%rowtype;
3246: begin
3247: hr_utility.set_location('Entering: ' || l_proc_name, 10);
3248:
8915: -- Added by dbansal
8916: l_hrEmpApi_out t_hrEmpApi;
8917: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
8918: l_asg_rec1 per_all_assignments_f%rowtype;
8919: l_grp_rec pay_people_groups%rowtype;
8920: l_scl_rec hr_soft_coding_keyflex%rowtype;
8921: l_pty_rec csr_type%rowtype;
8922: l_apl_asg_rec per_all_assignments_f%rowtype;
8923: l_appl_override_warning boolean;