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_APPROVED_PA_REQUESTS dependencies on GHR_PA_REQUEST_SHADOW

Line 548: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;

544: L_I_PRH_OBJECT_VERSION_NUMBER number;
545: l_par_object_version_number1 number;
546: l_dummy number;
547: --Begin Bug# 8344672
548: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;
549: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;
550: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;
551: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
552:

Line 549: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;

545: l_par_object_version_number1 number;
546: l_dummy number;
547: --Begin Bug# 8344672
548: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;
549: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;
550: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;
551: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
552:
553: cursor c_lac_shadow is

Line 550: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;

546: l_dummy number;
547: --Begin Bug# 8344672
548: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;
549: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;
550: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;
551: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
552:
553: cursor c_lac_shadow is
554: select first_action_la_code1,first_action_la_code2,second_action_la_code1,second_action_la_code2

Line 551: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;

547: --Begin Bug# 8344672
548: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;
549: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;
550: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;
551: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
552:
553: cursor c_lac_shadow is
554: select first_action_la_code1,first_action_la_code2,second_action_la_code1,second_action_la_code2
555: from ghr_pa_request_shadow

Line 555: from ghr_pa_request_shadow

551: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
552:
553: cursor c_lac_shadow is
554: select first_action_la_code1,first_action_la_code2,second_action_la_code1,second_action_la_code2
555: from ghr_pa_request_shadow
556: where pa_request_id = p_pa_request_id;
557: --End Bug# 8344672
558: --
559: cursor c_pa_req is

Line 907: insert into ghr_pa_request_shadow (

903: --
904: create_pa_request_extra_info(
905: p_new_pa_request_id => l_pa_req_rec.pa_request_id
906: ,p_old_pa_request_id => v_old_pa_request_id);
907: insert into ghr_pa_request_shadow (
908: pa_request_id,
909: academic_discipline,
910: annuitant_indicator,
911: appropriation_code1,

Line 1084: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;

1080: l_I_PRH_OBJECT_VERSION_NUMBER number;
1081: l_par_object_version_number number;
1082: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1083: --Begin Bug# 8344672
1084: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;
1085: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;
1086: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;
1087: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
1088:

Line 1085: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;

1081: l_par_object_version_number number;
1082: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1083: --Begin Bug# 8344672
1084: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;
1085: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;
1086: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;
1087: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
1088:
1089: cursor c_lac_shadow is

Line 1086: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;

1082: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1083: --Begin Bug# 8344672
1084: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;
1085: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;
1086: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;
1087: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
1088:
1089: cursor c_lac_shadow is
1090: select first_action_la_code1,first_action_la_code2,second_action_la_code1,second_action_la_code2

Line 1087: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;

1083: --Begin Bug# 8344672
1084: l_first_action_la_code1 ghr_pa_request_shadow.first_action_la_code1%type;
1085: l_first_action_la_code2 ghr_pa_request_shadow.first_action_la_code2%type;
1086: l_second_action_la_code1 ghr_pa_request_shadow.second_action_la_code1%type;
1087: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
1088:
1089: cursor c_lac_shadow is
1090: select first_action_la_code1,first_action_la_code2,second_action_la_code1,second_action_la_code2
1091: from ghr_pa_request_shadow

Line 1091: from ghr_pa_request_shadow

1087: l_second_action_la_code2 ghr_pa_request_shadow.second_action_la_code2%type;
1088:
1089: cursor c_lac_shadow is
1090: select first_action_la_code1,first_action_la_code2,second_action_la_code1,second_action_la_code2
1091: from ghr_pa_request_shadow
1092: where pa_request_id = l_pa_req_rec.pa_request_id;
1093: --End Bug# 8344672
1094: -- l_U_PRH_OBJECT_VERSION_NUMBER number;
1095: --

Line 1637: insert into ghr_pa_request_shadow (

1633: -- Bug#4486823 RRR Changes
1634:
1635: hr_utility.set_location('Created SF52 - Altered PA Request ID '||to_char(l_pa_req_rec.altered_pa_request_id)|| '-'|| l_proc, 21);
1636: hr_utility.set_location('Created SF52 - PA request ID '||to_char(l_pa_req_rec.pa_request_id)|| '-'|| l_proc, 22);
1637: insert into ghr_pa_request_shadow (
1638: pa_request_id,
1639: academic_discipline,
1640: annuitant_indicator,
1641: appropriation_code1,