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_CPDF_EHRIS dependencies on GHR_PROCESS_LOG

Line 1300: l_log_text ghr_process_log.log_text%type;

1296: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
1297: )
1298: IS
1299: l_proc varchar2(30) := 'get_from_history_dutsta';
1300: l_log_text ghr_process_log.log_text%type;
1301: l_message_name ghr_process_log.message_name%type;
1302: l_log_date ghr_process_log.log_date%type;
1303:
1304: CURSOR DUTSTACUR IS

Line 1301: l_message_name ghr_process_log.message_name%type;

1297: )
1298: IS
1299: l_proc varchar2(30) := 'get_from_history_dutsta';
1300: l_log_text ghr_process_log.log_text%type;
1301: l_message_name ghr_process_log.message_name%type;
1302: l_log_date ghr_process_log.log_date%type;
1303:
1304: CURSOR DUTSTACUR IS
1305: SELECT DUTY_STATION_CODE, DUTY_STATION_ID

Line 1302: l_log_date ghr_process_log.log_date%type;

1298: IS
1299: l_proc varchar2(30) := 'get_from_history_dutsta';
1300: l_log_text ghr_process_log.log_text%type;
1301: l_message_name ghr_process_log.message_name%type;
1302: l_log_date ghr_process_log.log_date%type;
1303:
1304: CURSOR DUTSTACUR IS
1305: SELECT DUTY_STATION_CODE, DUTY_STATION_ID
1306: FROM GHR_DUTY_STATIONS_F

Line 1739: l_log_text ghr_process_log.log_text%type;

1735: ( p_report_date in date
1736: )
1737: IS
1738: l_proc varchar2(30) := 'calc_is_foreign_duty_station';
1739: l_log_text ghr_process_log.log_text%type;
1740: l_message_name ghr_process_log.message_name%type;
1741: l_log_date ghr_process_log.log_date%type;
1742:
1743: CURSOR CALCDUTSTA_CUR IS

Line 1740: l_message_name ghr_process_log.message_name%type;

1736: )
1737: IS
1738: l_proc varchar2(30) := 'calc_is_foreign_duty_station';
1739: l_log_text ghr_process_log.log_text%type;
1740: l_message_name ghr_process_log.message_name%type;
1741: l_log_date ghr_process_log.log_date%type;
1742:
1743: CURSOR CALCDUTSTA_CUR IS
1744: SELECT STATE_OR_COUNTRY_CODE

Line 1741: l_log_date ghr_process_log.log_date%type;

1737: IS
1738: l_proc varchar2(30) := 'calc_is_foreign_duty_station';
1739: l_log_text ghr_process_log.log_text%type;
1740: l_message_name ghr_process_log.message_name%type;
1741: l_log_date ghr_process_log.log_date%type;
1742:
1743: CURSOR CALCDUTSTA_CUR IS
1744: SELECT STATE_OR_COUNTRY_CODE
1745: FROM GHR_DUTY_STATIONS_F

Line 1789: l_log_text ghr_process_log.log_text%type;

1785:
1786: PROCEDURE insert_row
1787: IS
1788: l_proc varchar2(30) := 'insert_row';
1789: l_log_text ghr_process_log.log_text%type;
1790: l_message_name ghr_process_log.message_name%type;
1791:
1792: BEGIN
1793: hr_utility.set_location('Entering:'||l_proc,5);

Line 1790: l_message_name ghr_process_log.message_name%type;

1786: PROCEDURE insert_row
1787: IS
1788: l_proc varchar2(30) := 'insert_row';
1789: l_log_text ghr_process_log.log_text%type;
1790: l_message_name ghr_process_log.message_name%type;
1791:
1792: BEGIN
1793: hr_utility.set_location('Entering:'||l_proc,5);
1794:

Line 3259: l_log_text ghr_process_log.log_text%type;

3255: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
3256:
3257: l_all_assignments_rec all_assignments_cur%ROWTYPE;
3258: --- 3671043 Bug fix
3259: l_log_text ghr_process_log.log_text%type;
3260: l_message_name ghr_process_log.message_name%type;
3261: l_log_date ghr_process_log.log_date%type;
3262:
3263: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)

Line 3260: l_message_name ghr_process_log.message_name%type;

3256:
3257: l_all_assignments_rec all_assignments_cur%ROWTYPE;
3258: --- 3671043 Bug fix
3259: l_log_text ghr_process_log.log_text%type;
3260: l_message_name ghr_process_log.message_name%type;
3261: l_log_date ghr_process_log.log_date%type;
3262:
3263: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)
3264: IS

Line 3261: l_log_date ghr_process_log.log_date%type;

3257: l_all_assignments_rec all_assignments_cur%ROWTYPE;
3258: --- 3671043 Bug fix
3259: l_log_text ghr_process_log.log_text%type;
3260: l_message_name ghr_process_log.message_name%type;
3261: l_log_date ghr_process_log.log_date%type;
3262:
3263: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)
3264: IS
3265: SELECT pap.full_name name ,pap.national_identifier ssn,pap.last_name,pap.first_name

Line 3657: l_log_text ghr_process_log.log_text%type;

3653: l_report_date DATE;
3654: l_ret_code NUMBER;
3655: l_invalid_filename EXCEPTION;
3656: l_report_name VARCHAR2(500);
3657: l_log_text ghr_process_log.log_text%type;
3658: l_message_name ghr_process_log.message_name%type;
3659: l_agency_subelement VARCHAR2(30);
3660: --l_sue_date varchar2(50);
3661:

Line 3658: l_message_name ghr_process_log.message_name%type;

3654: l_ret_code NUMBER;
3655: l_invalid_filename EXCEPTION;
3656: l_report_name VARCHAR2(500);
3657: l_log_text ghr_process_log.log_text%type;
3658: l_message_name ghr_process_log.message_name%type;
3659: l_agency_subelement VARCHAR2(30);
3660: --l_sue_date varchar2(50);
3661:
3662: --