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_PAR_EXTRA_INFO_API dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 477: l_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;

473: --
474: -- Declare cursors and local variables
475: --
476: l_proc varchar2(72) ;
477: l_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
478: l_obj_version_number ghr_pa_request_extra_info.object_version_number%TYPE; -- NOCOPY changes
479: --
480: CURSOR c_noa_family_code(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
481: SELECT noa_family_code

Line 478: l_obj_version_number ghr_pa_request_extra_info.object_version_number%TYPE; -- NOCOPY changes

474: -- Declare cursors and local variables
475: --
476: l_proc varchar2(72) ;
477: l_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
478: l_obj_version_number ghr_pa_request_extra_info.object_version_number%TYPE; -- NOCOPY changes
479: --
480: CURSOR c_noa_family_code(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
481: SELECT noa_family_code
482: FROM ghr_pa_requests

Line 486: l_information_type ghr_pa_request_extra_info.information_type%type;

482: FROM ghr_pa_requests
483: WHERE pa_request_id = c_pa_request_id;
484: l_noa_family_code ghr_pa_requests.noa_family_code%type;
485: l_pa_req_id ghr_pa_requests.pa_request_id%type;
486: l_information_type ghr_pa_request_extra_info.information_type%type;
487:
488: CURSOR c_pa_req_id (c_pa_req_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type) IS
489: SELECT pa_request_id, information_type
490: FROM ghr_pa_request_extra_info

Line 488: CURSOR c_pa_req_id (c_pa_req_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type) IS

484: l_noa_family_code ghr_pa_requests.noa_family_code%type;
485: l_pa_req_id ghr_pa_requests.pa_request_id%type;
486: l_information_type ghr_pa_request_extra_info.information_type%type;
487:
488: CURSOR c_pa_req_id (c_pa_req_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type) IS
489: SELECT pa_request_id, information_type
490: FROM ghr_pa_request_extra_info
491: WHERE pa_request_extra_info_id = c_pa_req_extra_info_id;
492:

Line 490: FROM ghr_pa_request_extra_info

486: l_information_type ghr_pa_request_extra_info.information_type%type;
487:
488: CURSOR c_pa_req_id (c_pa_req_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%type) IS
489: SELECT pa_request_id, information_type
490: FROM ghr_pa_request_extra_info
491: WHERE pa_request_extra_info_id = c_pa_req_extra_info_id;
492:
493: begin
494: l_proc := g_package||'update_pa_request_extra_info';

Line 928: FROM ghr_pa_request_extra_info

924: WHERE pa_request_id = c_pa_request_id;
925:
926: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
927: SELECT rei_information3 payroll_id
928: FROM ghr_pa_request_extra_info
929: WHERE pa_request_id = c_pa_request_id
930: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
931:
932: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS

Line 949: l_health_plan ghr_pa_request_extra_info.rei_information5%type;

945: l_tenure ghr_pa_requests.tenure%type;
946: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%type;
947: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
948:
949: l_health_plan ghr_pa_request_extra_info.rei_information5%type;
950: l_enrollment_option ghr_pa_request_extra_info.rei_information6%type;
951: l_date_temp_elig date;
952: l_fegli ghr_pa_requests.fegli%type;
953: l_tsp_status ghr_pa_request_extra_info.rei_information15%type;

Line 950: l_enrollment_option ghr_pa_request_extra_info.rei_information6%type;

946: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%type;
947: l_assignment_id ghr_pa_requests.employee_assignment_id%type;
948:
949: l_health_plan ghr_pa_request_extra_info.rei_information5%type;
950: l_enrollment_option ghr_pa_request_extra_info.rei_information6%type;
951: l_date_temp_elig date;
952: l_fegli ghr_pa_requests.fegli%type;
953: l_tsp_status ghr_pa_request_extra_info.rei_information15%type;
954: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;

Line 953: l_tsp_status ghr_pa_request_extra_info.rei_information15%type;

949: l_health_plan ghr_pa_request_extra_info.rei_information5%type;
950: l_enrollment_option ghr_pa_request_extra_info.rei_information6%type;
951: l_date_temp_elig date;
952: l_fegli ghr_pa_requests.fegli%type;
953: l_tsp_status ghr_pa_request_extra_info.rei_information15%type;
954: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;
955: l_noa_family_code ghr_pa_requests.noa_family_code%type;
956: l_st_month VARCHAR2(20);
957: l_end_month VARCHAR2(20);

Line 954: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;

950: l_enrollment_option ghr_pa_request_extra_info.rei_information6%type;
951: l_date_temp_elig date;
952: l_fegli ghr_pa_requests.fegli%type;
953: l_tsp_status ghr_pa_request_extra_info.rei_information15%type;
954: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;
955: l_noa_family_code ghr_pa_requests.noa_family_code%type;
956: l_st_month VARCHAR2(20);
957: l_end_month VARCHAR2(20);
958: l_pay_month VARCHAR2(20);