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.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 30: l_rei_rec ghr_pa_request_extra_info%rowtype ;

26: l_session1 ghr_history_api.g_session_var_type;
27: --End Bug 5923620
28:
29: l_pei_id per_people_extra_info.person_extra_info_id%type;
30: l_rei_rec ghr_pa_request_extra_info%rowtype ;
31: l_org_rec ghr_pa_request_ei_shadow%rowtype;
32: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
33: l_noa_code ghr_nature_of_actions.code%type;
34: l_first_noa_code ghr_nature_of_actions.code%type;

Line 32: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;

28:
29: l_pei_id per_people_extra_info.person_extra_info_id%type;
30: l_rei_rec ghr_pa_request_extra_info%rowtype ;
31: l_org_rec ghr_pa_request_ei_shadow%rowtype;
32: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
33: l_noa_code ghr_nature_of_actions.code%type;
34: l_first_noa_code ghr_nature_of_actions.code%type;
35: l_second_noa_code ghr_nature_of_actions.code%type;
36: l_existed BOOLEAN := FALSE;

Line 75: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,

71: pei_information7,
72: pei_information8,
73: pei_information9,
74: person_extra_info_id
75: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
76: pay_user_tables put
77: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
78: AND rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
79: AND pei2.person_extra_info_id

Line 116: FROM ghr_pa_request_extra_info

112: person_extra_info_id
113: FROM per_people_extra_info pei
114: WHERE pei.person_extra_info_id in (
115: SELECT rei_information3
116: FROM ghr_pa_request_extra_info
117: WHERE pa_request_id = l_altered_pa_request_id
118: AND information_type = 'GHR_US_PAR_TERM_RET_GRADE');
119:
120:

Line 154: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,

150: pei_information9,
151: person_extra_info_id,
152: rei_information5 terminate_flag,
153: 'Original RPA' origianl_rpa
154: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
155: pay_user_tables put
156: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
157: AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
158: AND pei2.person_extra_info_id

Line 168: from ghr_pa_request_extra_info

164: order by 1;
165:
166: cursor c_740_rei is
167: select rei_information3,rei_information4
168: from ghr_pa_request_extra_info
169: where pa_request_id = p_pa_request_id
170: and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG';
171:
172: cursor c_702_rei is

Line 174: from ghr_pa_request_extra_info

170: and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG';
171:
172: cursor c_702_rei is
173: select rei_information3,rei_information4
174: from ghr_pa_request_extra_info
175: where pa_request_id = p_pa_request_id
176: and information_type = 'GHR_US_PAR_TERM_RG_PROMO';
177:
178: cursor c_altered_par_rec is

Line 232: -- Delete from ghr_pa_request_extra_info

228: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
229: (nvl(p_person_id,hr_api.g_number)
230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
231: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
232: -- Delete from ghr_pa_request_extra_info
233: DELETE ghr_pa_request_extra_info
234: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
235: 'GHR_US_PAR_TERM_RG_PROMO',
236: 'GHR_US_PAR_TERM_RG_POSN_CHG')

Line 233: DELETE ghr_pa_request_extra_info

229: (nvl(p_person_id,hr_api.g_number)
230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
231: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
232: -- Delete from ghr_pa_request_extra_info
233: DELETE ghr_pa_request_extra_info
234: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
235: 'GHR_US_PAR_TERM_RG_PROMO',
236: 'GHR_US_PAR_TERM_RG_POSN_CHG')
237: AND PA_REQUEST_ID = p_pa_request_id;

Line 249: -- Delete from ghr_pa_request_extra_info

245: END IF;
246: END IF;
247: IF l_noa_code IN ( '866' ,'890') THEN
248: hr_utility.set_location('Inside the c_866 loop'||l_noa_code, 3);
249: -- Delete from ghr_pa_request_extra_info
250: DELETE ghr_pa_request_extra_info
251: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
252: AND PA_REQUEST_ID = p_pa_request_id;
253:

Line 250: DELETE ghr_pa_request_extra_info

246: END IF;
247: IF l_noa_code IN ( '866' ,'890') THEN
248: hr_utility.set_location('Inside the c_866 loop'||l_noa_code, 3);
249: -- Delete from ghr_pa_request_extra_info
250: DELETE ghr_pa_request_extra_info
251: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
252: AND PA_REQUEST_ID = p_pa_request_id;
253:
254: -- Delete from ghr_pa_request_ei_shadow

Line 261: -- Delete from ghr_pa_request_extra_info

257: AND PA_REQUEST_ID = p_pa_request_id;
258: ELSIF l_noa_code = '702' THEN
259: FOR pei_id IN c_702_rei LOOP
260: hr_utility.set_location('Inside the c_702_rei loop'||l_noa_code, 3);
261: -- Delete from ghr_pa_request_extra_info
262: DELETE ghr_pa_request_extra_info
263: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
264: AND PA_REQUEST_ID = p_pa_request_id;
265:

Line 262: DELETE ghr_pa_request_extra_info

258: ELSIF l_noa_code = '702' THEN
259: FOR pei_id IN c_702_rei LOOP
260: hr_utility.set_location('Inside the c_702_rei loop'||l_noa_code, 3);
261: -- Delete from ghr_pa_request_extra_info
262: DELETE ghr_pa_request_extra_info
263: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
264: AND PA_REQUEST_ID = p_pa_request_id;
265:
266: -- Delete from ghr_pa_request_ei_shadow

Line 475: l_information_type ghr_pa_request_extra_info.information_type%type;

471: p_refresh_flag in varchar2 default 'Y'
472: )
473: is
474: l_proc varchar2(72) := g_package || 'populate_noa_spec_extra_info';
475: l_information_type ghr_pa_request_extra_info.information_type%type;
476: l_dum_information_type ghr_pa_request_extra_info.information_type%type;
477: l_flag varchar2(1);
478: l_rei_rec ghr_pa_request_extra_info%rowtype;
479: l_org_rec ghr_pa_request_ei_shadow%rowtype;

Line 476: l_dum_information_type ghr_pa_request_extra_info.information_type%type;

472: )
473: is
474: l_proc varchar2(72) := g_package || 'populate_noa_spec_extra_info';
475: l_information_type ghr_pa_request_extra_info.information_type%type;
476: l_dum_information_type ghr_pa_request_extra_info.information_type%type;
477: l_flag varchar2(1);
478: l_rei_rec ghr_pa_request_extra_info%rowtype;
479: l_org_rec ghr_pa_request_ei_shadow%rowtype;
480: l_new_rei_rec ghr_pa_request_extra_info%rowtype;

Line 478: l_rei_rec ghr_pa_request_extra_info%rowtype;

474: l_proc varchar2(72) := g_package || 'populate_noa_spec_extra_info';
475: l_information_type ghr_pa_request_extra_info.information_type%type;
476: l_dum_information_type ghr_pa_request_extra_info.information_type%type;
477: l_flag varchar2(1);
478: l_rei_rec ghr_pa_request_extra_info%rowtype;
479: l_org_rec ghr_pa_request_ei_shadow%rowtype;
480: l_new_rei_rec ghr_pa_request_extra_info%rowtype;
481: l_refresh_flag varchar2(1);
482:

Line 480: l_new_rei_rec ghr_pa_request_extra_info%rowtype;

476: l_dum_information_type ghr_pa_request_extra_info.information_type%type;
477: l_flag varchar2(1);
478: l_rei_rec ghr_pa_request_extra_info%rowtype;
479: l_org_rec ghr_pa_request_ei_shadow%rowtype;
480: l_new_rei_rec ghr_pa_request_extra_info%rowtype;
481: l_refresh_flag varchar2(1);
482:
483: cursor c_rei_rec is
484: select rei.pa_request_extra_info_id,

Line 486: from ghr_pa_request_extra_info rei

482:
483: cursor c_rei_rec is
484: select rei.pa_request_extra_info_id,
485: rei.object_version_number
486: from ghr_pa_request_extra_info rei
487: where rei.pa_request_id = p_pa_request_id
488: and rei.information_type NOT IN ('GHR_US_PAR_PAYROLL_TYPE',
489: 'GHR_US_PAR_PERF_APPRAISAL',
490: 'GHR_US_PAR_GEN_AGENCY_DATA',

Line 518: from ghr_pa_request_extra_info a

514: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
515:
516: cursor c_orig_rei_rec is
517: select *
518: from ghr_pa_request_extra_info a
519: where a.pa_request_id = l_altered_pa_request_id
520: and a.information_type like 'GHR_US%'
521: and a.information_type not in (
522: select information_type from

Line 523: ghr_pa_request_extra_info b

519: where a.pa_request_id = l_altered_pa_request_id
520: and a.information_type like 'GHR_US%'
521: and a.information_type not in (
522: select information_type from
523: ghr_pa_request_extra_info b
524: where b.pa_request_id = p_pa_request_id );
525:
526: Begin
527: hr_utility.set_location('Entering ' || l_proc,5);

Line 649: l_rei_rec ghr_pa_request_extra_info%rowtype; -- as in the ddf and then subsequently overwrittwn with data to be updated

645: l_information_type ghr_pa_request_info_types.information_type%type;
646: l_update_rei varchar2(1) := 'N';
647: l_exists boolean := FALSE;
648: l_value varchar2(30);
649: l_rei_rec ghr_pa_request_extra_info%rowtype; -- as in the ddf and then subsequently overwrittwn with data to be updated
650: l_org_rec ghr_pa_request_ei_shadow%rowtype; -- original from the duplicate table
651: l_old_rei_rec ghr_pa_request_extra_info%rowtype;
652: l_flag varchar2(1);
653: l_refresh_flag varchar2(1);

Line 651: l_old_rei_rec ghr_pa_request_extra_info%rowtype;

647: l_exists boolean := FALSE;
648: l_value varchar2(30);
649: l_rei_rec ghr_pa_request_extra_info%rowtype; -- as in the ddf and then subsequently overwrittwn with data to be updated
650: l_org_rec ghr_pa_request_ei_shadow%rowtype; -- original from the duplicate table
651: l_old_rei_rec ghr_pa_request_extra_info%rowtype;
652: l_flag varchar2(1);
653: l_refresh_flag varchar2(1);
654: l_rei_rec_exists varchar2(1);
655: l_person_id per_people_f.person_id%type;

Line 720: from ghr_pa_request_extra_info

716: rei_information28,
717: rei_information29,
718: rei_information30,
719: object_version_number
720: from ghr_pa_request_extra_info
721: where pa_request_id = p_pa_request_id
722: and information_type = l_information_type;
723:
724: cursor c_org_rei_rec is

Line 1074: FROM ghr_pa_request_extra_info

1070: WHERE pa_request_id = p_pa_request_id;
1071:
1072: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1073: SELECT rei_information3 payroll_id
1074: FROM ghr_pa_request_extra_info
1075: WHERE pa_request_id = c_pa_request_id
1076: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
1077:
1078: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS

Line 3459: l_rei_rec ghr_pa_request_extra_info%rowtype;

3455: l_perf_appraisal ghr_api.special_information_type;
3456: l_update_rei varchar2(1) := 'N';
3457: l_exists boolean := FALSE;
3458: l_flag varchar2(1) := null;
3459: l_rei_rec ghr_pa_request_extra_info%rowtype;
3460: l_org_rec ghr_pa_request_ei_shadow%rowtype;
3461: l_person_id per_people_f.person_id%type;
3462: l_assignment_id per_assignments_f.assignment_id%type;
3463: l_per_refresh_flag varchar2(1);

Line 3469: l_information_type ghr_pa_request_extra_info.information_type%type;

3465: l_business_group_id per_assignments_f.business_group_id%type;
3466: l_noa_family_code ghr_noa_families.noa_family_code%type;
3467:
3468: l_proc varchar2(72) := g_package || 'fetch_gneric_extra_info';
3469: l_information_type ghr_pa_request_extra_info.information_type%type;
3470: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
3471:
3472: cursor c_bus_gp is
3473: select business_group_id

Line 3512: from ghr_pa_request_extra_info

3508: rei_information28,
3509: rei_information29,
3510: rei_information30,
3511: object_version_number
3512: from ghr_pa_request_extra_info
3513: where pa_request_id = p_pa_request_id
3514: and information_type = l_information_type;
3515:
3516: cursor c_org_rei_rec is

Line 4042: p_rei_rec in ghr_pa_request_extra_info%rowtype,

4038: Procedure determine_operation
4039: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4040: p_information_type in ghr_pa_request_info_types.information_type%type,
4041: p_update_rei in varchar2,
4042: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4043: p_operation_flag out NOCOPY varchar2,
4044: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,
4045: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
4046: ) is

Line 4044: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,

4040: p_information_type in ghr_pa_request_info_types.information_type%type,
4041: p_update_rei in varchar2,
4042: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4043: p_operation_flag out NOCOPY varchar2,
4044: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,
4045: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
4046: ) is
4047:
4048: l_proc varchar2(72) := 'determine_operation';

Line 4050: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;

4046: ) is
4047:
4048: l_proc varchar2(72) := 'determine_operation';
4049: l_object_version_number ghr_pa_requests.object_version_number%type;
4050: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
4051: l_exists boolean := FALSE;
4052: l_dummy ghr_pa_request_extra_info%rowtype;
4053: l_rei_rec ghr_pa_request_extra_info%rowtype;
4054: cursor c_rei_rec is

Line 4052: l_dummy ghr_pa_request_extra_info%rowtype;

4048: l_proc varchar2(72) := 'determine_operation';
4049: l_object_version_number ghr_pa_requests.object_version_number%type;
4050: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
4051: l_exists boolean := FALSE;
4052: l_dummy ghr_pa_request_extra_info%rowtype;
4053: l_rei_rec ghr_pa_request_extra_info%rowtype;
4054: cursor c_rei_rec is
4055: select rei.pa_request_extra_info_id,
4056: rei.object_version_number,

Line 4053: l_rei_rec ghr_pa_request_extra_info%rowtype;

4049: l_object_version_number ghr_pa_requests.object_version_number%type;
4050: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
4051: l_exists boolean := FALSE;
4052: l_dummy ghr_pa_request_extra_info%rowtype;
4053: l_rei_rec ghr_pa_request_extra_info%rowtype;
4054: cursor c_rei_rec is
4055: select rei.pa_request_extra_info_id,
4056: rei.object_version_number,
4057: rei.rei_information1,

Line 4087: from ghr_pa_request_extra_info rei

4083: rei.rei_information27,
4084: rei.rei_information28,
4085: rei.rei_information29,
4086: rei.rei_information30
4087: from ghr_pa_request_extra_info rei
4088: where rei.pa_request_id = p_pa_request_id
4089: and rei.information_type = p_information_type;
4090:
4091: Begin

Line 4193: (p_rei_rec in ghr_pa_request_extra_info%rowtype,

4189: End if;
4190: End determine_operation;
4191:
4192: Procedure generic_populate_extra_info
4193: (p_rei_rec in ghr_pa_request_extra_info%rowtype,
4194: p_org_rec in ghr_pa_request_ei_shadow%rowtype,
4195: p_flag in varchar2
4196: )
4197: is

Line 4200: l_rei_rec ghr_pa_request_extra_info%rowtype := p_rei_rec;

4196: )
4197: is
4198:
4199: l_flag varchar2(1) := p_flag;
4200: l_rei_rec ghr_pa_request_extra_info%rowtype := p_rei_rec;
4201: l_org_rec ghr_pa_request_ei_shadow%rowtype;
4202: l_proc varchar2(72) := 'generic_populate_extra_info';
4203:
4204: Begin