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_ASSIGNMENT_API dependencies on PER_CAGR_GRADES_DEF

Line 4060: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

4056: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
4057: := p_soft_coding_keyflex_id; -- bug 2359997 added initialization
4058: l_people_group_id per_all_assignments_f.people_group_id%TYPE
4059: := p_people_group_id; -- bug 2359997 added initialization
4060: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
4061: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
4062: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
4063: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
4064: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 4520: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

4516: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4517: l_proc varchar2(72) := g_package||
4518: 'create_secondary_emp_asg';
4519: l_session_id number;
4520: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
4521: := p_cagr_grade_def_id;
4522: l_cagr_concatenated_segments varchar2(2000);
4523:
4524: l_gsp_post_process_warning varchar2(2000); -- bug 2999562

Line 4969: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

4965: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4966: l_proc varchar2(72) := g_package||
4967: 'create_secondary_emp_asg';
4968: l_session_id number;
4969: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
4970: := p_cagr_grade_def_id;
4971: l_cagr_concatenated_segments varchar2(2000);
4972:
4973: l_gsp_post_process_warning varchar2(2000); -- bug 2999562

Line 5203: -- bug 2359997 get per_cagr_grades_def segment values where

5199: segment30
5200: from hr_soft_coding_keyflex
5201: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
5202: --
5203: -- bug 2359997 get per_cagr_grades_def segment values where
5204: -- cagr_grade_def_id is known
5205: --
5206: cursor c_cag_segments is
5207: select segment1,

Line 5227: from per_cagr_grades_def

5223: segment17,
5224: segment18,
5225: segment19,
5226: segment20
5227: from per_cagr_grades_def
5228: where cagr_grade_def_id = l_cagr_grade_def_id;
5229: --
5230: begin
5231: --

Line 5258: -- per_cagr_grades_def

5254: --
5255: -- Bug 2359997 - if p_people_group_id enters with
5256: -- a value then get segment values from pay_people_groups.
5257: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
5258: -- per_cagr_grades_def
5259: --
5260: --
5261: if g_debug then
5262: hr_utility.set_location(l_proc, 20);

Line 9535: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;

9531: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9532: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9533: l_organization_id per_all_assignments_f.organization_id%type;
9534: l_location_id per_all_assignments_f.location_id%type;
9535: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
9536: l_cagr_concatenated_segments varchar2(2000);
9537: l_proc varchar2(72);
9538: --
9539: begin

Line 9858: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

9854: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9855: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9856: l_organization_id per_all_assignments_f.organization_id%type;
9857: l_location_id per_all_assignments_f.location_id%type;
9858: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9859: := p_cagr_grade_def_id; -- bug 2359997
9860: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9861: l_cagr_concatenated_segments varchar2(2000);
9862: l_proc varchar2(72);

Line 9860: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

9856: l_organization_id per_all_assignments_f.organization_id%type;
9857: l_location_id per_all_assignments_f.location_id%type;
9858: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9859: := p_cagr_grade_def_id; -- bug 2359997
9860: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9861: l_cagr_concatenated_segments varchar2(2000);
9862: l_proc varchar2(72);
9863:
9864: begin

Line 10193: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

10189: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
10190: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
10191: l_organization_id per_all_assignments_f.organization_id%type;
10192: l_location_id per_all_assignments_f.location_id%type;
10193: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10194: := p_cagr_grade_def_id; -- bug 2359997
10195: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
10196: l_cagr_concatenated_segments varchar2(2000);
10197: l_hourly_salaried_warning boolean;

Line 10195: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

10191: l_organization_id per_all_assignments_f.organization_id%type;
10192: l_location_id per_all_assignments_f.location_id%type;
10193: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10194: := p_cagr_grade_def_id; -- bug 2359997
10195: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
10196: l_cagr_concatenated_segments varchar2(2000);
10197: l_hourly_salaried_warning boolean;
10198: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
10199: --

Line 10549: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

10545: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
10546: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
10547: l_organization_id per_all_assignments_f.organization_id%type;
10548: l_location_id per_all_assignments_f.location_id%type;
10549: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10550: := p_cagr_grade_def_id; -- bug 2359997
10551: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
10552: l_cagr_concatenated_segments varchar2(2000);
10553: l_hourly_salaried_warning boolean;

Line 10551: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

10547: l_organization_id per_all_assignments_f.organization_id%type;
10548: l_location_id per_all_assignments_f.location_id%type;
10549: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
10550: := p_cagr_grade_def_id; -- bug 2359997
10551: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
10552: l_cagr_concatenated_segments varchar2(2000);
10553: l_hourly_salaried_warning boolean;
10554: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
10555: --

Line 10730: -- bug 2359997 get per_cagr_grades_def segment values where

10726: from hr_soft_coding_keyflex
10727: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
10728: END */
10729: --
10730: -- bug 2359997 get per_cagr_grades_def segment values where
10731: -- cagr_grade_def_id is known
10732: --
10733: cursor c_cag_segments is
10734: select segment1,

Line 10754: from per_cagr_grades_def

10750: segment17,
10751: segment18,
10752: segment19,
10753: segment20
10754: from per_cagr_grades_def
10755: where cagr_grade_def_id = l_cagr_grade_def_id;
10756: --
10757: --
10758: begin

Line 17557: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;

17553: l_date_probation_end date;
17554: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
17555: l_organization_id per_all_assignments_f.organization_id%type;
17556: l_location_id per_all_assignments_f.location_id%type;
17557: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
17558: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
17559: l_unused_start_date date;
17560: l_unused_end_date date;
17561: l_cagr_concatenated_segments varchar2(2000);

Line 17558: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

17554: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
17555: l_organization_id per_all_assignments_f.organization_id%type;
17556: l_location_id per_all_assignments_f.location_id%type;
17557: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
17558: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
17559: l_unused_start_date date;
17560: l_unused_end_date date;
17561: l_cagr_concatenated_segments varchar2(2000);
17562: --

Line 17814: -- bug 2230915 get per_cagr_grades_def segment values where

17810: segment30
17811: from hr_soft_coding_keyflex
17812: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
17813: --
17814: -- bug 2230915 get per_cagr_grades_def segment values where
17815: -- cagr_grade_def_id is known
17816: --
17817: cursor c_cag_segments is
17818: select segment1,

Line 17838: from per_cagr_grades_def

17834: segment17,
17835: segment18,
17836: segment19,
17837: segment20
17838: from per_cagr_grades_def
17839: where cagr_grade_def_id = l_cagr_grade_def_id;
17840: --
17841: -- fix for bug 5938120 starts here.
17842: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 17938: -- per_cagr_grades_def

17934: -- 2230915 only populate l_people_group_id from g_old_rec
17935: -- if p_people_group_id did not enter with a value. If it did enter with
17936: -- a value then get segment values from pay_people_groups.
17937: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
17938: -- per_cagr_grades_def
17939: --
17940: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;
17941: --
17942: if g_debug then

Line 19238: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;

19234: l_date_probation_end date;
19235: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19236: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19237: l_cagr_concatenated_segments varchar2(2000);
19238: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
19239: --
19240:
19241: -- Bug 944911
19242: -- added an new var to handle in and out

Line 19973: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;

19969: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19970: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19971: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19972: l_session_id number;
19973: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19974: l_cagr_concatenated_segments varchar2(2000);
19975: l_appl_date_end per_applications.date_end%TYPE;
19976: --
19977: -- bug 2230915 new variables to indicate whether key flex id parameters

Line 20211: -- bug 2230915 get per_cagr_grades_def segment values where

20207: segment30
20208: from hr_soft_coding_keyflex
20209: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
20210: --
20211: -- bug 2230915 get per_cagr_grades_def segment values where
20212: -- cagr_grade_def_id is known
20213: --
20214: cursor c_cag_segments is
20215: select segment1,

Line 20235: from per_cagr_grades_def

20231: segment17,
20232: segment18,
20233: segment19,
20234: segment20
20235: from per_cagr_grades_def
20236: where cagr_grade_def_id = l_cagr_grade_def_id;
20237: --
20238: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
20239: --

Line 20309: -- per_cagr_grades_def

20305: --
20306: -- Bug 2230915 - if p_people_group_id enters with
20307: -- a value then get segment values from pay_people_groups.
20308: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
20309: -- per_cagr_grades_def
20310: --
20311: --
20312: if g_debug then
20313: hr_utility.set_location(l_proc, 20);