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 38: l_rei_rec ghr_pa_request_extra_info%rowtype ;

34: l_session1 ghr_history_api.g_session_var_type;
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;

Line 40: l_ret_grade1 ghr_pa_request_extra_info.rei_information4%type;

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;
44: l_existed BOOLEAN := FALSE;

Line 83: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,

79: pei_information7,
80: pei_information8,
81: pei_information9,
82: person_extra_info_id
83: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
84: pay_user_tables put
85: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
86: AND rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
87: AND pei2.person_extra_info_id

Line 149: FROM ghr_pa_request_extra_info

145: person_extra_info_id
146: FROM per_people_extra_info pei
147: WHERE pei.person_extra_info_id in (
148: SELECT rei_information3
149: FROM ghr_pa_request_extra_info
150: WHERE pa_request_id = l_altered_pa_request_id
151: AND information_type = 'GHR_US_PAR_TERM_RET_GRADE');
152:
153:

Line 187: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,

183: pei_information9,
184: person_extra_info_id,
185: rei_information5 terminate_flag,
186: 'Original RPA' origianl_rpa
187: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
188: pay_user_tables put
189: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
190: AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
191: AND pei2.person_extra_info_id

Line 201: from ghr_pa_request_extra_info

197: order by 1;
198:
199: cursor c_740_rei is
200: select rei_information3,rei_information4
201: from ghr_pa_request_extra_info
202: where pa_request_id = p_pa_request_id
203: and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG';
204:
205: cursor c_702_rei is

Line 207: from ghr_pa_request_extra_info

203: and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG';
204:
205: cursor c_702_rei is
206: select rei_information3,rei_information4
207: from ghr_pa_request_extra_info
208: where pa_request_id = p_pa_request_id
209: and information_type = 'GHR_US_PAR_TERM_RG_PROMO';
210:
211: cursor c_altered_par_rec is

Line 266: -- Delete from ghr_pa_request_extra_info

262: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
263: (nvl(p_person_id,hr_api.g_number)
264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
265: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
266: -- Delete from ghr_pa_request_extra_info
267: DELETE ghr_pa_request_extra_info
268: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
269: 'GHR_US_PAR_TERM_RG_PROMO',
270: 'GHR_US_PAR_TERM_RG_POSN_CHG')

Line 267: DELETE ghr_pa_request_extra_info

263: (nvl(p_person_id,hr_api.g_number)
264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
265: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
266: -- Delete from ghr_pa_request_extra_info
267: DELETE ghr_pa_request_extra_info
268: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',
269: 'GHR_US_PAR_TERM_RG_PROMO',
270: 'GHR_US_PAR_TERM_RG_POSN_CHG')
271: AND PA_REQUEST_ID = p_pa_request_id;

Line 283: -- Delete from ghr_pa_request_extra_info

279: END IF;
280: END IF;
281: IF l_noa_code IN ( '866' ,'890') THEN
282: hr_utility.set_location('Inside the c_866 loop'||l_noa_code, 3);
283: -- Delete from ghr_pa_request_extra_info
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:

Line 284: DELETE ghr_pa_request_extra_info

280: END IF;
281: IF l_noa_code IN ( '866' ,'890') THEN
282: hr_utility.set_location('Inside the c_866 loop'||l_noa_code, 3);
283: -- Delete from ghr_pa_request_extra_info
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

Line 296: -- Delete from ghr_pa_request_extra_info

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
294: FOR pei_id IN c_702_rei LOOP
295: hr_utility.set_location('Inside the c_702_rei loop'||l_noa_code, 3);
296: -- Delete from ghr_pa_request_extra_info
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:

Line 297: DELETE ghr_pa_request_extra_info

293: ELSIF l_noa_code = '702' or (l_noa_code not in ('001','002') and l_second_noa_code = '702') THEN
294: FOR pei_id IN c_702_rei LOOP
295: hr_utility.set_location('Inside the c_702_rei loop'||l_noa_code, 3);
296: -- Delete from ghr_pa_request_extra_info
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

Line 522: l_information_type ghr_pa_request_extra_info.information_type%type;

518: p_refresh_flag in varchar2 default 'Y'
519: )
520: is
521: l_proc varchar2(72) := g_package || 'populate_noa_spec_extra_info';
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;

Line 523: l_dum_information_type ghr_pa_request_extra_info.information_type%type;

519: )
520: is
521: l_proc varchar2(72) := g_package || 'populate_noa_spec_extra_info';
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;

Line 525: l_rei_rec ghr_pa_request_extra_info%rowtype;

521: l_proc varchar2(72) := g_package || 'populate_noa_spec_extra_info';
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:

Line 527: l_new_rei_rec ghr_pa_request_extra_info%rowtype;

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
531: select rei.pa_request_extra_info_id,

Line 533: from ghr_pa_request_extra_info rei

529:
530: cursor c_rei_rec is
531: select rei.pa_request_extra_info_id,
532: rei.object_version_number
533: from ghr_pa_request_extra_info rei
534: where rei.pa_request_id = p_pa_request_id
535: and rei.information_type NOT IN ('GHR_US_PAR_PAYROLL_TYPE',
536: 'GHR_US_PAR_PERF_APPRAISAL',
537: 'GHR_US_PAR_GEN_AGENCY_DATA',

Line 565: from ghr_pa_request_extra_info a

561: l_altered_pa_request_id ghr_pa_requests.pa_request_id%type;
562:
563: cursor c_orig_rei_rec is
564: select *
565: from ghr_pa_request_extra_info a
566: where a.pa_request_id = l_altered_pa_request_id
567: and a.information_type like 'GHR_US%'
568: and a.information_type not in (
569: select information_type from

Line 570: ghr_pa_request_extra_info b

566: where a.pa_request_id = l_altered_pa_request_id
567: and a.information_type like 'GHR_US%'
568: and a.information_type not in (
569: select information_type from
570: ghr_pa_request_extra_info b
571: where b.pa_request_id = p_pa_request_id );
572:
573: Begin
574: hr_utility.set_location('Entering ' || l_proc,5);

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

704: l_information_type ghr_pa_request_info_types.information_type%type;
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);

Line 710: l_old_rei_rec ghr_pa_request_extra_info%rowtype;

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);
714: l_person_id per_people_f.person_id%type;

Line 782: from ghr_pa_request_extra_info

778: rei_information28,
779: rei_information29,
780: rei_information30,
781: object_version_number
782: from ghr_pa_request_extra_info
783: where pa_request_id = p_pa_request_id
784: and information_type = l_information_type;
785:
786: cursor c_org_rei_rec is

Line 1216: FROM ghr_pa_request_extra_info

1212: WHERE pa_request_id = p_pa_request_id;
1213:
1214: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
1215: SELECT rei_information3 payroll_id
1216: FROM ghr_pa_request_extra_info
1217: WHERE pa_request_id = c_pa_request_id
1218: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
1219:
1220: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS

Line 4216: l_rei_rec ghr_pa_request_extra_info%rowtype;

4212: l_perf_appraisal ghr_api.special_information_type;
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);

Line 4226: l_information_type ghr_pa_request_extra_info.information_type%type;

4222: l_business_group_id per_assignments_f.business_group_id%type;
4223: l_noa_family_code ghr_noa_families.noa_family_code%type;
4224:
4225: l_proc varchar2(72) := g_package || 'fetch_generic_extra_info';
4226: l_information_type ghr_pa_request_extra_info.information_type%type;
4227: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
4228:
4229: cursor c_bus_gp is
4230: select business_group_id

Line 4269: from ghr_pa_request_extra_info

4265: rei_information28,
4266: rei_information29,
4267: rei_information30,
4268: object_version_number
4269: from ghr_pa_request_extra_info
4270: where pa_request_id = p_pa_request_id
4271: and information_type = l_information_type;
4272:
4273: cursor c_org_rei_rec is

Line 4799: p_rei_rec in ghr_pa_request_extra_info%rowtype,

4795: Procedure determine_operation
4796: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
4797: p_information_type in ghr_pa_request_info_types.information_type%type,
4798: p_update_rei in varchar2,
4799: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4800: p_operation_flag out NOCOPY varchar2,
4801: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,
4802: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
4803: ) is

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

4797: p_information_type in ghr_pa_request_info_types.information_type%type,
4798: p_update_rei in varchar2,
4799: p_rei_rec in ghr_pa_request_extra_info%rowtype,
4800: p_operation_flag out NOCOPY varchar2,
4801: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,
4802: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
4803: ) is
4804:
4805: l_proc varchar2(72) := 'determine_operation';

Line 4807: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;

4803: ) is
4804:
4805: l_proc varchar2(72) := 'determine_operation';
4806: l_object_version_number ghr_pa_requests.object_version_number%type;
4807: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
4808: l_exists boolean := FALSE;
4809: l_dummy ghr_pa_request_extra_info%rowtype;
4810: l_rei_rec ghr_pa_request_extra_info%rowtype;
4811: cursor c_rei_rec is

Line 4809: l_dummy ghr_pa_request_extra_info%rowtype;

4805: l_proc varchar2(72) := 'determine_operation';
4806: l_object_version_number ghr_pa_requests.object_version_number%type;
4807: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
4808: l_exists boolean := FALSE;
4809: l_dummy ghr_pa_request_extra_info%rowtype;
4810: l_rei_rec ghr_pa_request_extra_info%rowtype;
4811: cursor c_rei_rec is
4812: select rei.pa_request_extra_info_id,
4813: rei.object_version_number,

Line 4810: l_rei_rec ghr_pa_request_extra_info%rowtype;

4806: l_object_version_number ghr_pa_requests.object_version_number%type;
4807: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
4808: l_exists boolean := FALSE;
4809: l_dummy ghr_pa_request_extra_info%rowtype;
4810: l_rei_rec ghr_pa_request_extra_info%rowtype;
4811: cursor c_rei_rec is
4812: select rei.pa_request_extra_info_id,
4813: rei.object_version_number,
4814: rei.rei_information1,

Line 4844: from ghr_pa_request_extra_info rei

4840: rei.rei_information27,
4841: rei.rei_information28,
4842: rei.rei_information29,
4843: rei.rei_information30
4844: from ghr_pa_request_extra_info rei
4845: where rei.pa_request_id = p_pa_request_id
4846: and rei.information_type = p_information_type;
4847:
4848: Begin

Line 4950: (p_rei_rec in ghr_pa_request_extra_info%rowtype,

4946: End if;
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

Line 4957: l_rei_rec ghr_pa_request_extra_info%rowtype := p_rei_rec;

4953: )
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

Line 5207: from ghr_pa_request_extra_info

5203: cursor c_get_extra_info_details(p_pa_request_id in number,
5204: p_information_type in varchar2)
5205: is
5206: select *
5207: from ghr_pa_request_extra_info
5208: where pa_request_id = p_pa_request_id
5209: and information_type = p_information_type;
5210:
5211: cursor c_shadow_extra_info(p_pa_request_id in number,

Line 5230: l_rei_rec ghr_pa_request_extra_info%rowtype;

5226: and c.code in (p_first_noa_code,p_second_noa_code)
5227: and a.information_type in (p_information_type1,p_information_type2)
5228: order by a.noa_family_code;
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;

Line 5231: sc_rei_rec ghr_pa_request_extra_info%rowtype;

5227: and a.information_type in (p_information_type1,p_information_type2)
5228: order by a.noa_family_code;
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;

Line 5232: fc_rei_rec ghr_pa_request_extra_info%rowtype;

5228: order by a.noa_family_code;
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;

Line 5235: l_information_type1 ghr_pa_request_extra_info.information_type%type;

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:
5239: begin

Line 5236: l_information_type2 ghr_pa_request_extra_info.information_type%type;

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:
5239: begin
5240: -- Handling common segments between Conversion to Appointment and Change in Work Schedule

Line 5840: from ghr_pa_request_extra_info

5836:
5837: cursor c_rei_rec
5838: is
5839: select pa_request_extra_info_id, object_version_number
5840: from ghr_pa_request_extra_info
5841: where pa_request_id = p_pa_request_id
5842: and information_type = p_info_type;
5843:
5844: begin