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.HR_DE_WORK_INCIDENT_REPORT dependencies on FND_DATE

Line 27: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_BIRTH'),40,' ') DOB, fnd_date.date_to_chardate(wi.DATE_OF_BIRTH) date_of_birth,

23: wi.incident_date INCIDENT_DATE_ORD,
24: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,
25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_BIRTH'),40,' ') DOB, fnd_date.date_to_chardate(wi.DATE_OF_BIRTH) date_of_birth,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,

Line 28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,

24: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERSON_ID'),40,' ') PER, wi.PERSON_ID,
25: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LAST_NAME'),40,' ') LAN, wi.LAST_NAME,
26: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','FIRST_NAME'),40,' ') FAN, wi.FIRST_NAME,
27: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_BIRTH'),40,' ') DOB, fnd_date.date_to_chardate(wi.DATE_OF_BIRTH) date_of_birth,
28: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DATE_OF_INC'),40,' ') IND, fnd_date.date_to_chardate(wi.INCIDENT_DATE) incident_date,
29: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_REF'),40,' ') REF, wi.INCIDENT_REFERENCE,
30: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','GENDER'),40,' ') GEN, hr_general.decode_lookup('SEX',wi.GENDER) gender,
31: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SOC_INS_NO'),40,' ') SIN, wi.SOCIAL_INSURANCE_NUMBER,
32: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MAR_STATUS'),40,' ') MAR, hr_general.decode_lookup('MAR_STATUS', wi.MARITAL_STATUS) marital_status,

Line 56: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB_START_DT'),40,' ') JST, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.JOB_START_DATE)) job_start_date,

52: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','INC_LOC'),40,' ') LOC, wi.LOCATION_OF_INCIDENT,
53: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REM_ACTION'),40,' ') REA, wi.REMEDIAL_HS_ACTION,
54: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','CHILD'),40,' ') NOC, wi.NO_OF_CHILDREN,
55: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB'),40,' ') JOB, wi.JOB_TYPE,
56: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','JOB_START_DT'),40,' ') JST, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.JOB_START_DATE)) job_start_date,
57: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','COMP_PART'),40,' ') CMP, wi.PART_OF_COMPANY,
58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,

Line 62: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DUR_PAY_ENT'),40,' ') DUR, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DUR_OF_PAYMENT_ENT)) dur_of_payment_ent,

58: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','LOANED_EMP'),40,' ') LND, wi.D_LOANED_EMP,
59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DUR_PAY_ENT'),40,' ') DUR, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DUR_OF_PAYMENT_ENT)) dur_of_payment_ent,
63: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_START'),40,' ') DTS, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_STOPPING_WORK)) date_of_stopping_work,
64: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_STOP'),40,' ') DTE, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_RESUMING_WORK)) date_of_resuming_work,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,

Line 63: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_START'),40,' ') DTS, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_STOPPING_WORK)) date_of_stopping_work,

59: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','UNDERAGE'),40,' ') UND, wi.D_UNDERAGE,
60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DUR_PAY_ENT'),40,' ') DUR, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DUR_OF_PAYMENT_ENT)) dur_of_payment_ent,
63: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_START'),40,' ') DTS, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_STOPPING_WORK)) date_of_stopping_work,
64: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_STOP'),40,' ') DTE, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_RESUMING_WORK)) date_of_resuming_work,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,

Line 64: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_STOP'),40,' ') DTE, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_RESUMING_WORK)) date_of_resuming_work,

60: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','SUPER_EMP'),40,' ') SEM, wi.SUPERVISING_EMPLOYEE,
61: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','REL_TO_OWNER'),40,' ') REL, wi.D_RELATION,
62: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DUR_PAY_ENT'),40,' ') DUR, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DUR_OF_PAYMENT_ENT)) dur_of_payment_ent,
63: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_START'),40,' ') DTS, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_STOPPING_WORK)) date_of_stopping_work,
64: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_STOP'),40,' ') DTE, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_RESUMING_WORK)) date_of_resuming_work,
65: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','1_DOC_ADDR'),40,' ') FAD, wi.ADDR_OF_DOC_FIRST_CON,
66: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','ADD_DOC'),40,' ') ADO, wi.ADDR_OF_CURR_DOC,
67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,

Line 71: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_MACH'),40,' ') DTM, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_MACHINE_BUILD)) date_of_machine_build,

67: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_START'),40,' ') WTS, wi.START_OF_WORK_TIME,
68: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','WT_END'),40,' ') WTE, wi.END_OF_WORK_TIME,
69: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','MK_MACH'),40,' ') MKM, wi.MAKE_OF_MACHINE,
70: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TP_MACH'),40,' ') TYM, wi.TYPE_OF_MACHINE,
71: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','DT_MACH'),40,' ') DTM, fnd_date.date_to_chardate(fnd_date.canonical_to_date(wi.DATE_OF_MACHINE_BUILD)) date_of_machine_build,
72: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','TECH_SAFE'),40,' ') TES, wi.TECHNICAL_SAFETY_ADV,
73: rpad(hr_general.decode_lookup('DE_REPORT_LABELS','PERS_SAFE'),40,' ') PES, wi.PERSONAL_SAFETY_ADV
74: FROM hr_de_work_incidents_report wi
75: ,per_people_f per

Line 80: wi.incident_date BETWEEN fnd_date.canonical_to_date(p_from_date)

76: WHERE wi.person_id = per.person_id AND
77: per.business_group_id = p_business_group_id AND
78: wi.incident_date BETWEEN per.effective_start_date
79: AND per.effective_end_date AND
80: wi.incident_date BETWEEN fnd_date.canonical_to_date(p_from_date)
81: AND fnd_date.canonical_to_date(p_to_date)
82: ORDER BY incident_date_ord, wi.person_id;
83: --
84: --

Line 81: AND fnd_date.canonical_to_date(p_to_date)

77: per.business_group_id = p_business_group_id AND
78: wi.incident_date BETWEEN per.effective_start_date
79: AND per.effective_end_date AND
80: wi.incident_date BETWEEN fnd_date.canonical_to_date(p_from_date)
81: AND fnd_date.canonical_to_date(p_to_date)
82: ORDER BY incident_date_ord, wi.person_id;
83: --
84: --
85: -- Local Variables.

Line 107: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_from_date)));

103: fnd_file.put_line(fnd_file.output, '**********************************************************');
104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','WI_REP_TITLE'), 40, ' '));
105: fnd_file.put_line(fnd_file.output, '**********************************************************');
106: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_FROM'), 28, ' ') || ' : '
107: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_from_date)));
108: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_TO'), 28, ' ') || ' : '
109: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_to_date)));
110: fnd_file.new_line(fnd_file.output, 45);
111: --

Line 109: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_to_date)));

105: fnd_file.put_line(fnd_file.output, '**********************************************************');
106: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_FROM'), 28, ' ') || ' : '
107: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_from_date)));
108: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_REPORT_LABELS','DT_TO'), 28, ' ') || ' : '
109: || fnd_date.date_to_chardate(fnd_date.canonical_to_date(p_to_date)));
110: fnd_file.new_line(fnd_file.output, 45);
111: --
112: --
113: -- Loop through all work incidents between the two dates.