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

Line 61: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.CREATION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS PREPARED_DATE,

57: ml.meaning AS PERMIT_TYPE,
58: EWP.DESCRIPTION AS PERMIT_DESC,
59: EPSV.PERMIT_STATUS AS PERMIT_STATUS,
60: ppf.full_name AS PREPARED_BY,
61: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.CREATION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS PREPARED_DATE,
62: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_FROM,
63: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_TO
64: ))"PERMIT_HEADER"
65: FROM EAM_WORK_PERMITS EWP,

Line 62: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_FROM,

58: EWP.DESCRIPTION AS PERMIT_DESC,
59: EPSV.PERMIT_STATUS AS PERMIT_STATUS,
60: ppf.full_name AS PREPARED_BY,
61: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.CREATION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS PREPARED_DATE,
62: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_FROM,
63: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_TO
64: ))"PERMIT_HEADER"
65: FROM EAM_WORK_PERMITS EWP,
66: EAM_PERMIT_STATUSES_VL EPSV,

Line 63: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_TO

59: EPSV.PERMIT_STATUS AS PERMIT_STATUS,
60: ppf.full_name AS PREPARED_BY,
61: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.CREATION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS PREPARED_DATE,
62: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_FROM,
63: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_TO
64: ))"PERMIT_HEADER"
65: FROM EAM_WORK_PERMITS EWP,
66: EAM_PERMIT_STATUSES_VL EPSV,
67: mfg_lookups ml,

Line 114: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_ESTAB_START_DATE,

110: EWC.WORK_CLEARANCE_NAME AS WORK_CLEARANCE_NAME,
111: EWC.DESCRIPTION AS WORK_CLEARANCE_DESCRIPTION,
112: EWCSV.WORK_CLEARANCE_STATUS AS WORK_CLEARANCE_STATUS,
113: ML.MEANING AS ISOLATION_TYPE,
114: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_ESTAB_START_DATE,
115: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE
116: FROM
117: EAM_WORK_CLEARANCES EWC,
118: EAM_SAFETY_ASSOCIATIONS ESA,

Line 115: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE

111: EWC.DESCRIPTION AS WORK_CLEARANCE_DESCRIPTION,
112: EWCSV.WORK_CLEARANCE_STATUS AS WORK_CLEARANCE_STATUS,
113: ML.MEANING AS ISOLATION_TYPE,
114: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_ESTAB_START_DATE,
115: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE
116: FROM
117: EAM_WORK_CLEARANCES EWC,
118: EAM_SAFETY_ASSOCIATIONS ESA,
119: EAM_WORK_CLEARANCE_STATUSES_VL EWCSV,

Line 139: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_ESTAB_START_DATE,

135: EWC.WORK_CLEARANCE_NAME AS WORK_CLEARANCE_NAME,
136: EWC.DESCRIPTION AS WORK_CLEARANCE_DESCRIPTION,
137: EWCSV.WORK_CLEARANCE_STATUS AS WORK_CLEARANCE_STATUS,
138: ML.MEANING AS ISOLATION_TYPE,
139: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_ESTAB_START_DATE,
140: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE
141: FROM
142: EAM_WORK_CLEARANCES EWC,
143: EAM_WORK_PERMITS PERMIT,

Line 140: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE

136: EWC.DESCRIPTION AS WORK_CLEARANCE_DESCRIPTION,
137: EWCSV.WORK_CLEARANCE_STATUS AS WORK_CLEARANCE_STATUS,
138: ML.MEANING AS ISOLATION_TYPE,
139: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_ESTAB_START_DATE,
140: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE
141: FROM
142: EAM_WORK_CLEARANCES EWC,
143: EAM_WORK_PERMITS PERMIT,
144: EAM_SAFETY_ASSOCIATIONS ESA1,

Line 189: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_START_DATE,

185: WEDV.WIP_ENTITY_NAME AS WORK_ORDER_NAME,
186: WEDV.ASSET_NUMBER AS WO_ASSET_NUMBER,
187: ASSET_DESCRIPTION AS WO_ASSET_DESC,
188: WEDV.DESCRIPTION AS WO_DESC,
189: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_START_DATE,
190: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE
191:
192: FROM
193: EAM_WORK_ORDERS_V WEDV,

Line 190: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE

186: WEDV.ASSET_NUMBER AS WO_ASSET_NUMBER,
187: ASSET_DESCRIPTION AS WO_ASSET_DESC,
188: WEDV.DESCRIPTION AS WO_DESC,
189: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_START_DATE,
190: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE
191:
192: FROM
193: EAM_WORK_ORDERS_V WEDV,
194: EAM_SAFETY_ASSOCIATIONS ESA

Line 208: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_START_DATE,

204: WEDV.WIP_ENTITY_NAME AS WORK_ORDER_NAME,
205: WEDV.ASSET_NUMBER AS WO_ASSET_NUMBER,
206: ASSET_DESCRIPTION AS WO_ASSET_DESC,
207: WEDV.DESCRIPTION AS WO_DESC,
208: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_START_DATE,
209: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE
210:
211: FROM
212: EAM_SAFETY_ASSOCIATIONS ESA1,

Line 209: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE

205: WEDV.ASSET_NUMBER AS WO_ASSET_NUMBER,
206: ASSET_DESCRIPTION AS WO_ASSET_DESC,
207: WEDV.DESCRIPTION AS WO_DESC,
208: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_START_DATE,
209: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WEDV.SCHEDULED_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS WO_SCHEDULED_COMPL_DATE
210:
211: FROM
212: EAM_SAFETY_ASSOCIATIONS ESA1,
213: EAM_SAFETY_ASSOCIATIONS ESA2,

Line 428: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_FROM)) AS PERMIT_VALID_FROM,

424: XMLFOREST(EWP.PERMIT_NAME AS PERMIT_NAME,
425: EWP.PERMIT_TYPE AS PERMIT_TYPE,
426: EWP.DESCRIPTION AS PERMIT_DESC,
427: EPSV.PERMIT_STATUS AS PERMIT_STATUS,
428: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_FROM)) AS PERMIT_VALID_FROM,
429: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_TO)) AS PERMIT_VALID_TO,
430: EWP.APPROVED_BY AS approverName),
431: XMLConcat(l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypefileattachment)))AS "RESULT"
432: INTO l_xmlType

Line 429: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_TO)) AS PERMIT_VALID_TO,

425: EWP.PERMIT_TYPE AS PERMIT_TYPE,
426: EWP.DESCRIPTION AS PERMIT_DESC,
427: EPSV.PERMIT_STATUS AS PERMIT_STATUS,
428: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_FROM)) AS PERMIT_VALID_FROM,
429: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_TO)) AS PERMIT_VALID_TO,
430: EWP.APPROVED_BY AS approverName),
431: XMLConcat(l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypefileattachment)))AS "RESULT"
432: INTO l_xmlType
433: FROM EAM_WORK_PERMITS EWP,