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_EI_SHADOW

Line 31: l_org_rec ghr_pa_request_ei_shadow%rowtype;

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;
35: l_second_noa_code ghr_nature_of_actions.code%type;

Line 239: -- Delete from ghr_pa_request_ei_shadow

235: 'GHR_US_PAR_TERM_RG_PROMO',
236: 'GHR_US_PAR_TERM_RG_POSN_CHG')
237: AND PA_REQUEST_ID = p_pa_request_id;
238:
239: -- Delete from ghr_pa_request_ei_shadow
240: DELETE ghr_pa_request_ei_shadow
241: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
242: 'GHR_US_PAR_TERM_RG_PROMO',
243: 'GHR_US_PAR_TERM_RG_POSN_CHG')

Line 240: DELETE ghr_pa_request_ei_shadow

236: 'GHR_US_PAR_TERM_RG_POSN_CHG')
237: AND PA_REQUEST_ID = p_pa_request_id;
238:
239: -- Delete from ghr_pa_request_ei_shadow
240: DELETE ghr_pa_request_ei_shadow
241: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
242: 'GHR_US_PAR_TERM_RG_PROMO',
243: 'GHR_US_PAR_TERM_RG_POSN_CHG')
244: AND PA_REQUEST_ID = p_pa_request_id;

Line 254: -- Delete from ghr_pa_request_ei_shadow

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
255: DELETE ghr_pa_request_ei_shadow
256: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
257: AND PA_REQUEST_ID = p_pa_request_id;
258: ELSIF l_noa_code = '702' THEN

Line 255: DELETE ghr_pa_request_ei_shadow

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
255: DELETE ghr_pa_request_ei_shadow
256: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
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

Line 266: -- Delete from ghr_pa_request_ei_shadow

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
267: DELETE ghr_pa_request_ei_shadow
268: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
269: AND PA_REQUEST_ID = p_pa_request_id;
270: EXIT;

Line 267: DELETE ghr_pa_request_ei_shadow

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
267: DELETE ghr_pa_request_ei_shadow
268: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
269: AND PA_REQUEST_ID = p_pa_request_id;
270: EXIT;
271: END LOOP;

Line 479: l_org_rec ghr_pa_request_ei_shadow%rowtype;

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:
483: cursor c_rei_rec is

Line 650: l_org_rec ghr_pa_request_ei_shadow%rowtype; -- original from the duplicate table

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);
654: l_rei_rec_exists varchar2(1);

Line 756: from ghr_pa_request_ei_shadow

752: rei_information27,
753: rei_information28,
754: rei_information29,
755: rei_information30
756: from ghr_pa_request_ei_shadow
757: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
758:
759: -- Bug#3941541 Added effective date condition to the cursor.
760: Cursor c_info_types(c_application_id fnd_application.application_id%type,c_resp_id fnd_responsibility.responsibility_id%type) is

Line 3460: l_org_rec ghr_pa_request_ei_shadow%rowtype;

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);
3464: l_asg_refresh_flag varchar2(1);

Line 3548: from ghr_pa_request_ei_shadow

3544: rei_information27,
3545: rei_information28,
3546: rei_information29,
3547: rei_information30
3548: from ghr_pa_request_ei_shadow
3549: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
3550:
3551: cursor c_payroll is
3552: select payroll_id

Line 4194: p_org_rec in ghr_pa_request_ei_shadow%rowtype,

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
4198:

Line 4201: l_org_rec ghr_pa_request_ei_shadow%rowtype;

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
4205: hr_utility.set_location('Entering ' || l_proc,10);

Line 4257: insert into ghr_pa_request_ei_shadow

4253: P_PA_REQUEST_EXTRA_INFO_ID => l_rei_rec.pa_request_extra_info_id,
4254: P_OBJECT_VERSION_NUMBER => l_rei_rec.object_version_number
4255: );
4256:
4257: insert into ghr_pa_request_ei_shadow
4258: (
4259: pa_request_extra_info_id ,
4260: pa_request_id ,
4261: information_type,

Line 4367: update ghr_pa_request_ei_shadow set

4363: p_rei_information30 => l_rei_rec.rei_information30
4364: );
4365: hr_utility.set_location('bef upd of shad ' || 'ovn ' || l_rei_rec.object_version_number,2);
4366:
4367: update ghr_pa_request_ei_shadow set
4368: rei_information1 = p_org_rec.rei_information1,
4369: rei_information2 = p_org_rec.rei_information2,
4370: rei_information3 = p_org_rec.rei_information3,
4371: rei_information4 = p_org_rec.rei_information4,

Line 4409: delete from ghr_pa_request_ei_shadow

4405: ghr_par_extra_info_api.delete_pa_request_extra_info
4406: (p_pa_request_extra_info_id => l_rei_rec.pa_request_extra_info_id,
4407: p_object_version_number => l_rei_rec.object_version_number
4408: );
4409: delete from ghr_pa_request_ei_shadow
4410: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
4411: End if;
4412: End if;
4413: hr_utility.set_location('Leaving ' || l_proc,40);