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 3493: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

3489: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE
3490: := p_soft_coding_keyflex_id; -- bug 2359997 added initialization
3491: l_people_group_id per_all_assignments_f.people_group_id%TYPE
3492: := p_people_group_id; -- bug 2359997 added initialization
3493: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
3494: := p_cagr_grade_def_id; -- bug 2359997, added this local variable
3495: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
3496: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
3497: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

Line 3953: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

3949: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
3950: l_proc varchar2(72) := g_package||
3951: 'create_secondary_emp_asg';
3952: l_session_id number;
3953: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
3954: := p_cagr_grade_def_id;
3955: l_cagr_concatenated_segments varchar2(2000);
3956:
3957: l_gsp_post_process_warning varchar2(2000); -- bug 2999562

Line 4402: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

4398: l_period_of_service_id per_all_assignments_f.period_of_service_id%TYPE;
4399: l_proc varchar2(72) := g_package||
4400: 'create_secondary_emp_asg';
4401: l_session_id number;
4402: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
4403: := p_cagr_grade_def_id;
4404: l_cagr_concatenated_segments varchar2(2000);
4405:
4406: l_gsp_post_process_warning varchar2(2000); -- bug 2999562

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

4632: segment30
4633: from hr_soft_coding_keyflex
4634: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
4635: --
4636: -- bug 2359997 get per_cagr_grades_def segment values where
4637: -- cagr_grade_def_id is known
4638: --
4639: cursor c_cag_segments is
4640: select segment1,

Line 4660: from per_cagr_grades_def

4656: segment17,
4657: segment18,
4658: segment19,
4659: segment20
4660: from per_cagr_grades_def
4661: where cagr_grade_def_id = l_cagr_grade_def_id;
4662: --
4663: begin
4664: --

Line 4691: -- per_cagr_grades_def

4687: --
4688: -- Bug 2359997 - if p_people_group_id enters with
4689: -- a value then get segment values from pay_people_groups.
4690: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
4691: -- per_cagr_grades_def
4692: --
4693: --
4694: if g_debug then
4695: hr_utility.set_location(l_proc, 20);

Line 8968: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;

8964: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
8965: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
8966: l_organization_id per_all_assignments_f.organization_id%type;
8967: l_location_id per_all_assignments_f.location_id%type;
8968: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
8969: l_cagr_concatenated_segments varchar2(2000);
8970: l_proc varchar2(72);
8971: --
8972: begin

Line 9291: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

9287: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9288: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9289: l_organization_id per_all_assignments_f.organization_id%type;
9290: l_location_id per_all_assignments_f.location_id%type;
9291: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9292: := p_cagr_grade_def_id; -- bug 2359997
9293: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9294: l_cagr_concatenated_segments varchar2(2000);
9295: l_proc varchar2(72);

Line 9293: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

9289: l_organization_id per_all_assignments_f.organization_id%type;
9290: l_location_id per_all_assignments_f.location_id%type;
9291: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9292: := p_cagr_grade_def_id; -- bug 2359997
9293: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9294: l_cagr_concatenated_segments varchar2(2000);
9295: l_proc varchar2(72);
9296:
9297: begin

Line 9626: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

9622: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9623: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9624: l_organization_id per_all_assignments_f.organization_id%type;
9625: l_location_id per_all_assignments_f.location_id%type;
9626: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9627: := p_cagr_grade_def_id; -- bug 2359997
9628: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9629: l_cagr_concatenated_segments varchar2(2000);
9630: l_hourly_salaried_warning boolean;

Line 9628: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

9624: l_organization_id per_all_assignments_f.organization_id%type;
9625: l_location_id per_all_assignments_f.location_id%type;
9626: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9627: := p_cagr_grade_def_id; -- bug 2359997
9628: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9629: l_cagr_concatenated_segments varchar2(2000);
9630: l_hourly_salaried_warning boolean;
9631: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
9632: --

Line 9982: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE

9978: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
9979: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
9980: l_organization_id per_all_assignments_f.organization_id%type;
9981: l_location_id per_all_assignments_f.location_id%type;
9982: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9983: := p_cagr_grade_def_id; -- bug 2359997
9984: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9985: l_cagr_concatenated_segments varchar2(2000);
9986: l_hourly_salaried_warning boolean;

Line 9984: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

9980: l_organization_id per_all_assignments_f.organization_id%type;
9981: l_location_id per_all_assignments_f.location_id%type;
9982: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE
9983: := p_cagr_grade_def_id; -- bug 2359997
9984: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
9985: l_cagr_concatenated_segments varchar2(2000);
9986: l_hourly_salaried_warning boolean;
9987: l_gsp_post_process_warning varchar2(2000); -- bug 2999562
9988: --

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

10159: from hr_soft_coding_keyflex
10160: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
10161: END */
10162: --
10163: -- bug 2359997 get per_cagr_grades_def segment values where
10164: -- cagr_grade_def_id is known
10165: --
10166: cursor c_cag_segments is
10167: select segment1,

Line 10187: from per_cagr_grades_def

10183: segment17,
10184: segment18,
10185: segment19,
10186: segment20
10187: from per_cagr_grades_def
10188: where cagr_grade_def_id = l_cagr_grade_def_id;
10189: --
10190: --
10191: begin

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

16707: l_date_probation_end date;
16708: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
16709: l_organization_id per_all_assignments_f.organization_id%type;
16710: l_location_id per_all_assignments_f.location_id%type;
16711: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
16712: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
16713: l_unused_start_date date;
16714: l_unused_end_date date;
16715: l_cagr_concatenated_segments varchar2(2000);

Line 16712: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;

16708: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
16709: l_organization_id per_all_assignments_f.organization_id%type;
16710: l_location_id per_all_assignments_f.location_id%type;
16711: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
16712: l_cagr_id_flex_num per_cagr_grades_def.id_flex_num%TYPE;
16713: l_unused_start_date date;
16714: l_unused_end_date date;
16715: l_cagr_concatenated_segments varchar2(2000);
16716: --

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

16964: segment30
16965: from hr_soft_coding_keyflex
16966: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
16967: --
16968: -- bug 2230915 get per_cagr_grades_def segment values where
16969: -- cagr_grade_def_id is known
16970: --
16971: cursor c_cag_segments is
16972: select segment1,

Line 16992: from per_cagr_grades_def

16988: segment17,
16989: segment18,
16990: segment19,
16991: segment20
16992: from per_cagr_grades_def
16993: where cagr_grade_def_id = l_cagr_grade_def_id;
16994: --
16995: -- fix for bug 5938120 starts here.
16996: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 17091: -- per_cagr_grades_def

17087: -- 2230915 only populate l_people_group_id from g_old_rec
17088: -- if p_people_group_id did not enter with a value. If it did enter with
17089: -- a value then get segment values from pay_people_groups.
17090: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
17091: -- per_cagr_grades_def
17092: --
17093: l_business_group_id := per_asg_shd.g_old_rec.business_group_id;
17094: --
17095: if g_debug then

Line 18375: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;

18371: l_date_probation_end date;
18372: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
18373: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
18374: l_cagr_concatenated_segments varchar2(2000);
18375: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE;
18376: --
18377:
18378: -- Bug 944911
18379: -- added an new var to handle in and out

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

19106: l_scl_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE ;
19107: l_old_scl_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
19108: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
19109: l_session_id number;
19110: l_cagr_grade_def_id per_cagr_grades_def.cagr_grade_def_id%TYPE := p_cagr_grade_def_id;
19111: l_cagr_concatenated_segments varchar2(2000);
19112: l_appl_date_end per_applications.date_end%TYPE;
19113: --
19114: -- bug 2230915 new variables to indicate whether key flex id parameters

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

19344: segment30
19345: from hr_soft_coding_keyflex
19346: where soft_coding_keyflex_id = l_soft_coding_keyflex_id;
19347: --
19348: -- bug 2230915 get per_cagr_grades_def segment values where
19349: -- cagr_grade_def_id is known
19350: --
19351: cursor c_cag_segments is
19352: select segment1,

Line 19372: from per_cagr_grades_def

19368: segment17,
19369: segment18,
19370: segment19,
19371: segment20
19372: from per_cagr_grades_def
19373: where cagr_grade_def_id = l_cagr_grade_def_id;
19374: --
19375: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
19376: --

Line 19446: -- per_cagr_grades_def

19442: --
19443: -- Bug 2230915 - if p_people_group_id enters with
19444: -- a value then get segment values from pay_people_groups.
19445: -- Do the same with the key flex ids for hr_soft_coding_keyflex and
19446: -- per_cagr_grades_def
19447: --
19448: --
19449: if g_debug then
19450: hr_utility.set_location(l_proc, 20);