DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on HR_SOFT_CODING_KEYFLEX

Line 16: g_scl_rec hr_soft_coding_keyflex%rowtype;

12: g_cwk_num_gen varchar2(5);
13: g_business_group_id number(15);
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;

Line 80: ,concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type

76: ,other_manager_warning boolean
77: ,spp_delete_warning boolean
78: ,entries_changed_warning varchar2(50)
79: ,tax_district_changed_warning boolean
80: ,concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type
81: ,gsp_post_process_warning varchar2(2000)
82: ,comment_id per_all_assignments_f.comment_id%type
83: );
84:

Line 1449: return hr_soft_coding_keyflex%rowtype is

1445: -- =============================================================================
1446: -- Default_Scflx_Rec:
1447: -- =============================================================================
1448: function Default_Scflx_Rec
1449: return hr_soft_coding_keyflex%rowtype is
1450: l_proc_name constant varchar2(150) := g_pkg||'Default_Scflx_Rec';
1451: l_scl_rec hr_soft_coding_keyflex%rowtype;
1452: begin
1453: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);

Line 1451: l_scl_rec hr_soft_coding_keyflex%rowtype;

1447: -- =============================================================================
1448: function Default_Scflx_Rec
1449: return hr_soft_coding_keyflex%rowtype is
1450: l_proc_name constant varchar2(150) := g_pkg||'Default_Scflx_Rec';
1451: l_scl_rec hr_soft_coding_keyflex%rowtype;
1452: begin
1453: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1454: /*
1455: ======================================================================

Line 1509: return hr_soft_coding_keyflex%rowtype is

1505: -- Get_ScflxRecord_Values:
1506: -- =============================================================================
1507: function Get_ScflxRecord_Values
1508: (p_interface_code in varchar2 default null)
1509: return hr_soft_coding_keyflex%rowtype is
1510:
1511: cursor bne_cols(c_interface_code in varchar2) is
1512: select lower(bic.interface_col_name) interface_col_name
1513: from bne_interface_cols_b bic

Line 1523: l_scl_rec hr_soft_coding_keyflex%rowtype;

1519: -- $ Commented this as segments value is not passed due to this flag
1520: -- and bic.display_flag ='Y';
1521:
1522: l_proc_name constant varchar2(150) := g_pkg||'Get_ScflxRecord_Values';
1523: l_scl_rec hr_soft_coding_keyflex%rowtype;
1524: col_name varchar2(150);
1525:
1526: begin
1527: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 2275: from hr_soft_coding_keyflex

2271:
2272: -- Cursor to get Soft coding flexfield details
2273: cursor csr_scl (c_scl_kff_id in number) is
2274: select *
2275: from hr_soft_coding_keyflex
2276: where soft_coding_keyflex_id = c_scl_kff_id;
2277:
2278: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2279:

Line 2278: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;

2274: select *
2275: from hr_soft_coding_keyflex
2276: where soft_coding_keyflex_id = c_scl_kff_id;
2277:
2278: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2279:
2280: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Applicant_Asg';
2281: l_error_msg varchar2(2000);
2282: l_datetrack_update_mode varchar2(50);

Line 2291: l_scl_rec hr_soft_coding_keyflex%rowtype;

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);
2295:

Line 2609: from hr_soft_coding_keyflex

2605:
2606: -- Cursor to get Soft coding flexfield details
2607: cursor csr_scl (c_scl_kff_id in number) is
2608: select *
2609: from hr_soft_coding_keyflex
2610: where soft_coding_keyflex_id = c_scl_kff_id;
2611:
2612: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2613:

Line 2612: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;

2608: select *
2609: from hr_soft_coding_keyflex
2610: where soft_coding_keyflex_id = c_scl_kff_id;
2611:
2612: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2613:
2614: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Contingent_Asg';
2615: l_error_msg varchar2(2000);
2616: l_datetrack_update_mode varchar2(50);

Line 2625: l_scl_rec hr_soft_coding_keyflex%rowtype;

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);
2629:

Line 2973: from hr_soft_coding_keyflex

2969:
2970: -- Cursor to get Soft coding flexfield details
2971: cursor csr_scl (c_scl_kff_id in number) is
2972: select *
2973: from hr_soft_coding_keyflex
2974: where soft_coding_keyflex_id = c_scl_kff_id;
2975:
2976: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2977:

Line 2976: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;

2972: select *
2973: from hr_soft_coding_keyflex
2974: where soft_coding_keyflex_id = c_scl_kff_id;
2975:
2976: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2977:
2978: l_proc_name constant varchar2(150):= g_pkg ||'Update_Employee_Asg';
2979: l_error_msg varchar2(2000);
2980: l_datetrack_update_mode varchar2(50);

Line 2989: l_scl_rec hr_soft_coding_keyflex%rowtype;

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:
2993: l_asg_rec := Get_AsgRecord_Values(g_interface_code);

Line 3218: -- Hr Soft Coding KeyFlex segments

3214: ,p_ass_attribute27 => l_asg_rec.ass_attribute27
3215: ,p_ass_attribute28 => l_asg_rec.ass_attribute28
3216: ,p_ass_attribute29 => l_asg_rec.ass_attribute29
3217: ,p_ass_attribute30 => l_asg_rec.ass_attribute30
3218: -- Hr Soft Coding KeyFlex segments
3219: ,p_segment1 => l_scl_rec.segment1
3220: ,p_segment2 => l_scl_rec.segment2
3221: ,p_segment3 => l_scl_rec.segment3
3222: ,p_segment4 => l_scl_rec.segment4

Line 8503: l_scl_rec hr_soft_coding_keyflex%rowtype;

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
8507: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 8622: -- Hr Soft Coding KeyFlex segments

8618: ,p_ass_attribute27 => l_asg_rec1.ass_attribute27
8619: ,p_ass_attribute28 => l_asg_rec1.ass_attribute28
8620: ,p_ass_attribute29 => l_asg_rec1.ass_attribute29
8621: ,p_ass_attribute30 => l_asg_rec1.ass_attribute30
8622: -- Hr Soft Coding KeyFlex segments
8623: ,p_scl_segment1 => l_scl_rec.segment1
8624: ,p_scl_segment2 => l_scl_rec.segment2
8625: ,p_scl_segment3 => l_scl_rec.segment3
8626: ,p_scl_segment4 => l_scl_rec.segment4

Line 8805: -- Hr Soft Coding KeyFlex segments

8801: ,p_pgp_segment28 => l_grp_rec.segment28
8802: ,p_pgp_segment29 => l_grp_rec.segment29
8803: ,p_pgp_segment30 => l_grp_rec.segment30
8804: ,p_pgp_concat_segments => l_grp_rec.group_name
8805: -- Hr Soft Coding KeyFlex segments
8806: ,p_scl_segment1 => l_scl_rec.segment1
8807: ,p_scl_segment2 => l_scl_rec.segment2
8808: ,p_scl_segment3 => l_scl_rec.segment3
8809: ,p_scl_segment4 => l_scl_rec.segment4