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.

[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PA_REQUEST_EI_SHADOW

Line 39: l_org_rec ghr_pa_request_ei_shadow%rowtype;

35: --End Bug 5923620
36:
37: l_pei_id per_people_extra_info.person_extra_info_id%type;
38: l_rei_rec ghr_pa_request_extra_info%rowtype ;
39: l_org_rec ghr_pa_request_ei_shadow%rowtype;
40: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;
41: l_noa_code ghr_nature_of_actions.code%type;
42: l_first_noa_code ghr_nature_of_actions.code%type;
43: l_second_noa_code ghr_nature_of_actions.code%type;

Line 273: -- Delete from ghr_pa_request_ei_shadow

269: 'GHR_US_PAR_TERM_RG_PROMO',
270: 'GHR_US_PAR_TERM_RG_POSN_CHG')
271: AND PA_REQUEST_ID = p_pa_request_id;
272:
273: -- Delete from ghr_pa_request_ei_shadow
274: DELETE ghr_pa_request_ei_shadow
275: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
276: 'GHR_US_PAR_TERM_RG_PROMO',
277: 'GHR_US_PAR_TERM_RG_POSN_CHG')

Line 274: DELETE ghr_pa_request_ei_shadow

270: 'GHR_US_PAR_TERM_RG_POSN_CHG')
271: AND PA_REQUEST_ID = p_pa_request_id;
272:
273: -- Delete from ghr_pa_request_ei_shadow
274: DELETE ghr_pa_request_ei_shadow
275: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
276: 'GHR_US_PAR_TERM_RG_PROMO',
277: 'GHR_US_PAR_TERM_RG_POSN_CHG')
278: AND PA_REQUEST_ID = p_pa_request_id;

Line 288: -- Delete from ghr_pa_request_ei_shadow

284: DELETE ghr_pa_request_extra_info
285: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
286: AND PA_REQUEST_ID = p_pa_request_id;
287:
288: -- Delete from ghr_pa_request_ei_shadow
289: DELETE ghr_pa_request_ei_shadow
290: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
291: AND PA_REQUEST_ID = p_pa_request_id;
292: --8288066 Added the below or condition for dual actions

Line 289: DELETE ghr_pa_request_ei_shadow

285: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
286: AND PA_REQUEST_ID = p_pa_request_id;
287:
288: -- Delete from ghr_pa_request_ei_shadow
289: DELETE ghr_pa_request_ei_shadow
290: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RET_GRADE'
291: AND PA_REQUEST_ID = p_pa_request_id;
292: --8288066 Added the below or condition for dual actions
293: ELSIF l_noa_code = '702' or (l_noa_code not in ('001','002') and l_second_noa_code = '702') THEN

Line 301: -- Delete from ghr_pa_request_ei_shadow

297: DELETE ghr_pa_request_extra_info
298: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
299: AND PA_REQUEST_ID = p_pa_request_id;
300:
301: -- Delete from ghr_pa_request_ei_shadow
302: DELETE ghr_pa_request_ei_shadow
303: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
304: AND PA_REQUEST_ID = p_pa_request_id;
305: EXIT;

Line 302: DELETE ghr_pa_request_ei_shadow

298: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
299: AND PA_REQUEST_ID = p_pa_request_id;
300:
301: -- Delete from ghr_pa_request_ei_shadow
302: DELETE ghr_pa_request_ei_shadow
303: WHERE INFORMATION_TYPE = 'GHR_US_PAR_TERM_RG_PROMO'
304: AND PA_REQUEST_ID = p_pa_request_id;
305: EXIT;
306: END LOOP;

Line 526: l_org_rec ghr_pa_request_ei_shadow%rowtype;

522: l_information_type ghr_pa_request_extra_info.information_type%type;
523: l_dum_information_type ghr_pa_request_extra_info.information_type%type;
524: l_flag varchar2(1);
525: l_rei_rec ghr_pa_request_extra_info%rowtype;
526: l_org_rec ghr_pa_request_ei_shadow%rowtype;
527: l_new_rei_rec ghr_pa_request_extra_info%rowtype;
528: l_refresh_flag varchar2(1);
529:
530: cursor c_rei_rec is

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

705: l_update_rei varchar2(1) := 'N';
706: l_exists boolean := FALSE;
707: l_value varchar2(30);
708: l_rei_rec ghr_pa_request_extra_info%rowtype; -- as in the ddf and then subsequently overwrittwn with data to be updated
709: l_org_rec ghr_pa_request_ei_shadow%rowtype; -- original from the duplicate table
710: l_old_rei_rec ghr_pa_request_extra_info%rowtype;
711: l_flag varchar2(1);
712: l_refresh_flag varchar2(1);
713: l_rei_rec_exists varchar2(1);

Line 818: from ghr_pa_request_ei_shadow

814: rei_information27,
815: rei_information28,
816: rei_information29,
817: rei_information30
818: from ghr_pa_request_ei_shadow
819: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
820:
821: -- Bug#3941541 Added effective date condition to the cursor.
822: Cursor c_info_types(c_application_id fnd_application.application_id%type,c_resp_id fnd_responsibility.responsibility_id%type) is

Line 4217: l_org_rec ghr_pa_request_ei_shadow%rowtype;

4213: l_update_rei varchar2(1) := 'N';
4214: l_exists boolean := FALSE;
4215: l_flag varchar2(1) := null;
4216: l_rei_rec ghr_pa_request_extra_info%rowtype;
4217: l_org_rec ghr_pa_request_ei_shadow%rowtype;
4218: l_person_id per_people_f.person_id%type;
4219: l_assignment_id per_assignments_f.assignment_id%type;
4220: l_per_refresh_flag varchar2(1);
4221: l_asg_refresh_flag varchar2(1);

Line 4305: from ghr_pa_request_ei_shadow

4301: rei_information27,
4302: rei_information28,
4303: rei_information29,
4304: rei_information30
4305: from ghr_pa_request_ei_shadow
4306: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
4307:
4308: cursor c_payroll is
4309: select payroll_id

Line 4951: p_org_rec in ghr_pa_request_ei_shadow%rowtype,

4947: End determine_operation;
4948:
4949: Procedure generic_populate_extra_info
4950: (p_rei_rec in ghr_pa_request_extra_info%rowtype,
4951: p_org_rec in ghr_pa_request_ei_shadow%rowtype,
4952: p_flag in varchar2
4953: )
4954: is
4955:

Line 4958: l_org_rec ghr_pa_request_ei_shadow%rowtype;

4954: is
4955:
4956: l_flag varchar2(1) := p_flag;
4957: l_rei_rec ghr_pa_request_extra_info%rowtype := p_rei_rec;
4958: l_org_rec ghr_pa_request_ei_shadow%rowtype;
4959: l_proc varchar2(72) := 'generic_populate_extra_info';
4960:
4961: Begin
4962: hr_utility.set_location('Entering ' || l_proc,10);

Line 5014: insert into ghr_pa_request_ei_shadow

5010: P_PA_REQUEST_EXTRA_INFO_ID => l_rei_rec.pa_request_extra_info_id,
5011: P_OBJECT_VERSION_NUMBER => l_rei_rec.object_version_number
5012: );
5013:
5014: insert into ghr_pa_request_ei_shadow
5015: (
5016: pa_request_extra_info_id ,
5017: pa_request_id ,
5018: information_type,

Line 5124: update ghr_pa_request_ei_shadow set

5120: p_rei_information30 => l_rei_rec.rei_information30
5121: );
5122: hr_utility.set_location('bef upd of shad ' || 'ovn ' || l_rei_rec.object_version_number,2);
5123:
5124: update ghr_pa_request_ei_shadow set
5125: rei_information1 = p_org_rec.rei_information1,
5126: rei_information2 = p_org_rec.rei_information2,
5127: rei_information3 = p_org_rec.rei_information3,
5128: rei_information4 = p_org_rec.rei_information4,

Line 5166: delete from ghr_pa_request_ei_shadow

5162: ghr_par_extra_info_api.delete_pa_request_extra_info
5163: (p_pa_request_extra_info_id => l_rei_rec.pa_request_extra_info_id,
5164: p_object_version_number => l_rei_rec.object_version_number
5165: );
5166: delete from ghr_pa_request_ei_shadow
5167: where pa_request_extra_info_id = l_rei_rec.pa_request_extra_info_id;
5168: End if;
5169: End if;
5170: hr_utility.set_location('Leaving ' || l_proc,40);

Line 5215: from ghr_pa_request_ei_shadow

5211: cursor c_shadow_extra_info(p_pa_request_id in number,
5212: p_information_type in varchar2)
5213: is
5214: select *
5215: from ghr_pa_request_ei_shadow
5216: where pa_request_id = p_pa_request_id
5217: and information_type = p_information_type;
5218:
5219: cursor get_ord_of_eit(p_information_type1 in varchar2,

Line 5233: l_org_sc_rec ghr_pa_request_ei_shadow%rowtype;

5229:
5230: l_rei_rec ghr_pa_request_extra_info%rowtype;
5231: sc_rei_rec ghr_pa_request_extra_info%rowtype;
5232: fc_rei_rec ghr_pa_request_extra_info%rowtype;
5233: l_org_sc_rec ghr_pa_request_ei_shadow%rowtype;
5234: l_org_fc_rec ghr_pa_request_ei_shadow%rowtype;
5235: l_information_type1 ghr_pa_request_extra_info.information_type%type;
5236: l_information_type2 ghr_pa_request_extra_info.information_type%type;
5237:

Line 5234: l_org_fc_rec ghr_pa_request_ei_shadow%rowtype;

5230: l_rei_rec ghr_pa_request_extra_info%rowtype;
5231: sc_rei_rec ghr_pa_request_extra_info%rowtype;
5232: fc_rei_rec ghr_pa_request_extra_info%rowtype;
5233: l_org_sc_rec ghr_pa_request_ei_shadow%rowtype;
5234: l_org_fc_rec ghr_pa_request_ei_shadow%rowtype;
5235: l_information_type1 ghr_pa_request_extra_info.information_type%type;
5236: l_information_type2 ghr_pa_request_extra_info.information_type%type;
5237:
5238:

Line 5851: delete from ghr_pa_request_ei_shadow

5847: ghr_par_extra_info_api.delete_pa_request_extra_info
5848: (p_pa_request_extra_info_id => c_rec.pa_request_extra_info_id,
5849: p_object_version_number => c_rec.object_version_number
5850: );
5851: delete from ghr_pa_request_ei_shadow
5852: where pa_request_extra_info_id = c_rec.pa_request_extra_info_id;
5853:
5854: end loop;
5855: end delete_extra_info_rec;