eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 81: ,concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type

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

Line 1455: return hr_soft_coding_keyflex%rowtype is

1451: -- =============================================================================
1452: -- Default_Scflx_Rec:
1453: -- =============================================================================
1454: function Default_Scflx_Rec
1455: return hr_soft_coding_keyflex%rowtype is
1456: l_proc_name constant varchar2(150) := g_pkg||'Default_Scflx_Rec';
1457: l_scl_rec hr_soft_coding_keyflex%rowtype;
1458: begin
1459: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);

Line 1457: l_scl_rec hr_soft_coding_keyflex%rowtype;

1453: -- =============================================================================
1454: function Default_Scflx_Rec
1455: return hr_soft_coding_keyflex%rowtype is
1456: l_proc_name constant varchar2(150) := g_pkg||'Default_Scflx_Rec';
1457: l_scl_rec hr_soft_coding_keyflex%rowtype;
1458: begin
1459: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1460: /*
1461: ======================================================================

Line 1515: return hr_soft_coding_keyflex%rowtype is

1511: -- Get_ScflxRecord_Values:
1512: -- =============================================================================
1513: function Get_ScflxRecord_Values
1514: (p_interface_code in varchar2 default null)
1515: return hr_soft_coding_keyflex%rowtype is
1516:
1517: cursor bne_cols(c_interface_code in varchar2) is
1518: select lower(bic.interface_col_name) interface_col_name
1519: from bne_interface_cols_b bic

Line 1529: l_scl_rec hr_soft_coding_keyflex%rowtype;

1525: -- $ Commented this as segments value is not passed due to this flag
1526: and bic.display_flag ='Y'; --Select only those segments that the user has selected while function creation
1527:
1528: l_proc_name constant varchar2(150) := g_pkg||'Get_ScflxRecord_Values';
1529: l_scl_rec hr_soft_coding_keyflex%rowtype;
1530: col_name varchar2(150);
1531:
1532: begin
1533: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

Line 2378: from hr_soft_coding_keyflex

2374:
2375: -- Cursor to get Soft coding flexfield details
2376: cursor csr_scl (c_scl_kff_id in number) is
2377: select *
2378: from hr_soft_coding_keyflex
2379: where soft_coding_keyflex_id = c_scl_kff_id;
2380:
2381: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2382:

Line 2381: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;

2377: select *
2378: from hr_soft_coding_keyflex
2379: where soft_coding_keyflex_id = c_scl_kff_id;
2380:
2381: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2382:
2383: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Applicant_Asg';
2384: l_error_msg varchar2(2000);
2385: l_datetrack_update_mode varchar2(50);

Line 2394: l_scl_rec hr_soft_coding_keyflex%rowtype;

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:
2398: begin

Line 2865: from hr_soft_coding_keyflex

2861:
2862: -- Cursor to get Soft coding flexfield details
2863: cursor csr_scl (c_scl_kff_id in number) is
2864: select *
2865: from hr_soft_coding_keyflex
2866: where soft_coding_keyflex_id = c_scl_kff_id;
2867:
2868: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2869:

Line 2868: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;

2864: select *
2865: from hr_soft_coding_keyflex
2866: where soft_coding_keyflex_id = c_scl_kff_id;
2867:
2868: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
2869:
2870: l_proc_name constant varchar2(150):= g_pkg ||'Upd_Contingent_Asg';
2871: l_error_msg varchar2(2000);
2872: l_datetrack_update_mode varchar2(50);

Line 2881: l_scl_rec hr_soft_coding_keyflex%rowtype;

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

Line 3229: from hr_soft_coding_keyflex

3225:
3226: -- Cursor to get Soft coding flexfield details
3227: cursor csr_scl (c_scl_kff_id in number) is
3228: select *
3229: from hr_soft_coding_keyflex
3230: where soft_coding_keyflex_id = c_scl_kff_id;
3231:
3232: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
3233:

Line 3232: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;

3228: select *
3229: from hr_soft_coding_keyflex
3230: where soft_coding_keyflex_id = c_scl_kff_id;
3231:
3232: l_cur_scl_rec hr_soft_coding_keyflex%rowtype;
3233:
3234: l_proc_name constant varchar2(150):= g_pkg ||'Update_Employee_Asg';
3235: l_error_msg varchar2(2000);
3236: l_datetrack_update_mode varchar2(50);

Line 3245: l_scl_rec hr_soft_coding_keyflex%rowtype;

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

Line 3474: -- Hr Soft Coding KeyFlex segments

3470: ,p_ass_attribute27 => l_asg_rec.ass_attribute27
3471: ,p_ass_attribute28 => l_asg_rec.ass_attribute28
3472: ,p_ass_attribute29 => l_asg_rec.ass_attribute29
3473: ,p_ass_attribute30 => l_asg_rec.ass_attribute30
3474: -- Hr Soft Coding KeyFlex segments
3475: ,p_segment1 => l_scl_rec.segment1
3476: ,p_segment2 => l_scl_rec.segment2
3477: ,p_segment3 => l_scl_rec.segment3
3478: ,p_segment4 => l_scl_rec.segment4

Line 8920: l_scl_rec hr_soft_coding_keyflex%rowtype;

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;
8924: l_concat_segments varchar2(2000);

Line 9116: -- Hr Soft Coding KeyFlex segments

9112: ,p_ass_attribute27 => l_asg_rec1.ass_attribute27
9113: ,p_ass_attribute28 => l_asg_rec1.ass_attribute28
9114: ,p_ass_attribute29 => l_asg_rec1.ass_attribute29
9115: ,p_ass_attribute30 => l_asg_rec1.ass_attribute30
9116: -- Hr Soft Coding KeyFlex segments
9117: ,p_scl_segment1 => l_scl_rec.segment1
9118: ,p_scl_segment2 => l_scl_rec.segment2
9119: ,p_scl_segment3 => l_scl_rec.segment3
9120: ,p_scl_segment4 => l_scl_rec.segment4

Line 9299: -- Hr Soft Coding KeyFlex segments

9295: ,p_pgp_segment28 => l_grp_rec.segment28
9296: ,p_pgp_segment29 => l_grp_rec.segment29
9297: ,p_pgp_segment30 => l_grp_rec.segment30
9298: ,p_pgp_concat_segments => l_grp_rec.group_name
9299: -- Hr Soft Coding KeyFlex segments
9300: ,p_scl_segment1 => l_scl_rec.segment1
9301: ,p_scl_segment2 => l_scl_rec.segment2
9302: ,p_scl_segment3 => l_scl_rec.segment3
9303: ,p_scl_segment4 => l_scl_rec.segment4