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 1346: l_log_text ghr_process_log.log_text%type;

1342: ,p_sr_ghr_cpdf_temp IN OUT NOCOPY ghr_cpdf_temp%ROWTYPE
1343: )
1344: IS
1345: l_proc varchar2(30) := 'get_from_history_dutsta';
1346: l_log_text ghr_process_log.log_text%type;
1347: l_message_name ghr_process_log.message_name%type;
1348: l_log_date ghr_process_log.log_date%type;
1349:
1350: CURSOR DUTSTACUR IS

Line 1347: l_message_name ghr_process_log.message_name%type;

1343: )
1344: IS
1345: l_proc varchar2(30) := 'get_from_history_dutsta';
1346: l_log_text ghr_process_log.log_text%type;
1347: l_message_name ghr_process_log.message_name%type;
1348: l_log_date ghr_process_log.log_date%type;
1349:
1350: CURSOR DUTSTACUR IS
1351: SELECT DUTY_STATION_CODE, DUTY_STATION_ID

Line 1348: l_log_date ghr_process_log.log_date%type;

1344: IS
1345: l_proc varchar2(30) := 'get_from_history_dutsta';
1346: l_log_text ghr_process_log.log_text%type;
1347: l_message_name ghr_process_log.message_name%type;
1348: l_log_date ghr_process_log.log_date%type;
1349:
1350: CURSOR DUTSTACUR IS
1351: SELECT DUTY_STATION_CODE, DUTY_STATION_ID
1352: FROM GHR_DUTY_STATIONS_F

Line 1816: l_log_text ghr_process_log.log_text%type;

1812: ( p_report_date in date
1813: )
1814: IS
1815: l_proc varchar2(30) := 'calc_is_foreign_duty_station';
1816: l_log_text ghr_process_log.log_text%type;
1817: l_message_name ghr_process_log.message_name%type;
1818: l_log_date ghr_process_log.log_date%type;
1819:
1820: CURSOR CALCDUTSTA_CUR IS

Line 1817: l_message_name ghr_process_log.message_name%type;

1813: )
1814: IS
1815: l_proc varchar2(30) := 'calc_is_foreign_duty_station';
1816: l_log_text ghr_process_log.log_text%type;
1817: l_message_name ghr_process_log.message_name%type;
1818: l_log_date ghr_process_log.log_date%type;
1819:
1820: CURSOR CALCDUTSTA_CUR IS
1821: SELECT STATE_OR_COUNTRY_CODE

Line 1818: l_log_date ghr_process_log.log_date%type;

1814: IS
1815: l_proc varchar2(30) := 'calc_is_foreign_duty_station';
1816: l_log_text ghr_process_log.log_text%type;
1817: l_message_name ghr_process_log.message_name%type;
1818: l_log_date ghr_process_log.log_date%type;
1819:
1820: CURSOR CALCDUTSTA_CUR IS
1821: SELECT STATE_OR_COUNTRY_CODE
1822: FROM GHR_DUTY_STATIONS_F

Line 1866: l_log_text ghr_process_log.log_text%type;

1862:
1863: PROCEDURE insert_row
1864: IS
1865: l_proc varchar2(30) := 'insert_row';
1866: l_log_text ghr_process_log.log_text%type;
1867: l_message_name ghr_process_log.message_name%type;
1868:
1869: BEGIN
1870: hr_utility.set_location('Entering:'||l_proc,5);

Line 1867: l_message_name ghr_process_log.message_name%type;

1863: PROCEDURE insert_row
1864: IS
1865: l_proc varchar2(30) := 'insert_row';
1866: l_log_text ghr_process_log.log_text%type;
1867: l_message_name ghr_process_log.message_name%type;
1868:
1869: BEGIN
1870: hr_utility.set_location('Entering:'||l_proc,5);
1871:

Line 3399: l_log_text ghr_process_log.log_text%type;

3395: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
3396:
3397: l_all_assignments_rec all_assignments_cur%ROWTYPE;
3398: --- 3671043 Bug fix
3399: l_log_text ghr_process_log.log_text%type;
3400: l_message_name ghr_process_log.message_name%type;
3401: l_log_date ghr_process_log.log_date%type;
3402:
3403: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)

Line 3400: l_message_name ghr_process_log.message_name%type;

3396:
3397: l_all_assignments_rec all_assignments_cur%ROWTYPE;
3398: --- 3671043 Bug fix
3399: l_log_text ghr_process_log.log_text%type;
3400: l_message_name ghr_process_log.message_name%type;
3401: l_log_date ghr_process_log.log_date%type;
3402:
3403: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)
3404: IS

Line 3401: l_log_date ghr_process_log.log_date%type;

3397: l_all_assignments_rec all_assignments_cur%ROWTYPE;
3398: --- 3671043 Bug fix
3399: l_log_text ghr_process_log.log_text%type;
3400: l_message_name ghr_process_log.message_name%type;
3401: l_log_date ghr_process_log.log_date%type;
3402:
3403: CURSOR cur_per_details(p_person_id per_all_people.person_id%type)
3404: IS
3405: --bug # 9329643 added employee number

Line 3815: l_log_text ghr_process_log.log_text%type;

3811: l_report_date DATE;
3812: l_ret_code NUMBER;
3813: l_invalid_filename EXCEPTION;
3814: l_report_name VARCHAR2(500);
3815: l_log_text ghr_process_log.log_text%type;
3816: l_message_name ghr_process_log.message_name%type;
3817: l_agency_subelement VARCHAR2(30);
3818: --l_sue_date varchar2(50);
3819:

Line 3816: l_message_name ghr_process_log.message_name%type;

3812: l_ret_code NUMBER;
3813: l_invalid_filename EXCEPTION;
3814: l_report_name VARCHAR2(500);
3815: l_log_text ghr_process_log.log_text%type;
3816: l_message_name ghr_process_log.message_name%type;
3817: l_agency_subelement VARCHAR2(30);
3818: --l_sue_date varchar2(50);
3819:
3820: --