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.HR_EMPLOYEE_APPLICANT_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 1781: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

1777: l_dummynum1 number;
1778: -- 2788390 ends here
1779: --added as per bug 5102160
1780: l_gsp_post_process_warning varchar2(2000); -- bug2999562
1781: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1782: --
1783: --
1784: cursor csr_future_asg_changes is
1785: select 'x'

Line 1916: from hr_soft_coding_keyflex

1912: l_primary_pgp_rec pay_people_groups%rowtype;
1913: --
1914: cursor get_scl(p_soft_coding_keyflex_id number) is
1915: select *
1916: from hr_soft_coding_keyflex
1917: where soft_coding_keyflex_id=p_soft_coding_keyflex_id;
1918: --
1919: l_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
1920: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;

Line 1919: l_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;

1915: select *
1916: from hr_soft_coding_keyflex
1917: where soft_coding_keyflex_id=p_soft_coding_keyflex_id;
1918: --
1919: l_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
1920: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
1921: --
1922: cursor get_cag(p_cagr_grade_def_id number) is
1923: select *

Line 1920: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;

1916: from hr_soft_coding_keyflex
1917: where soft_coding_keyflex_id=p_soft_coding_keyflex_id;
1918: --
1919: l_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
1920: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
1921: --
1922: cursor get_cag(p_cagr_grade_def_id number) is
1923: select *
1924: from per_cagr_grades_def

Line 4246: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

4242: l_dummynum1 number;
4243: -- 2788390 ends here
4244: --added as per bug 5102160
4245: l_gsp_post_process_warning varchar2(2000); -- bug2999562
4246: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4247: --
4248: L_ASG_STATUS_OVN1 number; --12905192
4249: l_change_reason varchar2(30); --12905192
4250: l_assignment_status_id number; --12905192

Line 4397: from hr_soft_coding_keyflex

4393: l_primary_pgp_rec pay_people_groups%rowtype;
4394: --
4395: cursor get_scl(p_soft_coding_keyflex_id number) is
4396: select *
4397: from hr_soft_coding_keyflex
4398: where soft_coding_keyflex_id=p_soft_coding_keyflex_id;
4399: --
4400: l_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
4401: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;

Line 4400: l_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;

4396: select *
4397: from hr_soft_coding_keyflex
4398: where soft_coding_keyflex_id=p_soft_coding_keyflex_id;
4399: --
4400: l_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
4401: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
4402: --
4403: cursor get_cag(p_cagr_grade_def_id number) is
4404: select *

Line 4401: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;

4397: from hr_soft_coding_keyflex
4398: where soft_coding_keyflex_id=p_soft_coding_keyflex_id;
4399: --
4400: l_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
4401: l_primary_scl_rec hr_soft_coding_keyflex%rowtype :=NULL;
4402: --
4403: cursor get_cag(p_cagr_grade_def_id number) is
4404: select *
4405: from per_cagr_grades_def

Line 4505: from hr_soft_coding_keyflex

4501: --and asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
4502:
4503: cursor get_scl1 is
4504: select soft_coding_keyflex_id
4505: from hr_soft_coding_keyflex
4506: where rownum=1;
4507:
4508: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
4509: l_payroll_id per_all_assignments_f.payroll_id%type;

Line 4508: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

4504: select soft_coding_keyflex_id
4505: from hr_soft_coding_keyflex
4506: where rownum=1;
4507:
4508: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
4509: l_payroll_id per_all_assignments_f.payroll_id%type;
4510: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
4511: --- Fix For Bug # 8844816 Ends ---
4512:

Line 4510: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

4506: where rownum=1;
4507:
4508: l_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
4509: l_payroll_id per_all_assignments_f.payroll_id%type;
4510: l_dummy_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
4511: --- Fix For Bug # 8844816 Ends ---
4512:
4513: -- vb 10376122
4514: cursor csr_get_vacancy(p_asg_id number) is