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_STATUSES_PKG dependencies on EAM_SAFETY_USR_DEF_STATUSES_TL

Line 24: --This procedure will insert new rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables

20: -- 24-MAR-2010 vboddapa Initial Creation
21: ***************************************************************************/
22:
23:
24: --This procedure will insert new rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
25: procedure INSERT_ROW (
26: X_ROWID in out NOCOPY VARCHAR2,
27: X_STATUS_ID in out NOCOPY NUMBER,
28: P_SEEDED_FLAG in VARCHAR2,

Line 81: insert into eam_safety_usr_def_statuses_tl (

77:
78: IF( P_USER_DEFINED_STATUS IS NOT NULL) THEN
79: -- user_defined_status will be Null for seeded WIP statuses
80:
81: insert into eam_safety_usr_def_statuses_tl (
82: LAST_UPDATE_LOGIN,
83: CREATION_DATE,
84: STATUS_ID,
85: USER_DEFINED_STATUS,

Line 109: from eam_safety_usr_def_statuses_tl T

105: where
106: L.INSTALLED_FLAG in ('I', 'B')
107: and not exists
108: (select NULL
109: from eam_safety_usr_def_statuses_tl T
110: where T.STATUS_ID = X_STATUS_ID
111: and T.LANGUAGE = L.LANGUAGE_CODE
112: and T.entity_type = P_ENTITY_TYPE);
113:

Line 124: --This procedure will update rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables

120: close c;
121: END IF;
122: end INSERT_ROW;
123:
124: --This procedure will update rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
125: procedure UPDATE_ROW (
126: P_STATUS_ID in NUMBER,
127: P_SEEDED_FLAG in VARCHAR2,
128: P_SYSTEM_STATUS in NUMBER,

Line 160: update eam_safety_usr_def_statuses_tl set

156:
157: IF (P_USER_DEFINED_STATUS IS NOT NULL) THEN
158: -- user_defined_status will be Null for seeded WIP statuses
159:
160: update eam_safety_usr_def_statuses_tl set
161: USER_DEFINED_STATUS = P_USER_DEFINED_STATUS,
162: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
163: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
164: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 197: --This procedure will delete rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables

193: end UPDATE_ROW;
194:
195:
196:
197: --This procedure will delete rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
198: procedure DELETE_ROW (
199: P_STATUS_ID in NUMBER,
200: P_ENTITY_TYPE in NUMBER
201: ) is

Line 204: delete from eam_safety_usr_def_statuses_tl

200: P_ENTITY_TYPE in NUMBER
201: ) is
202: begin
203:
204: delete from eam_safety_usr_def_statuses_tl
205: where STATUS_ID = P_STATUS_ID
206: and ENTITY_TYPE = P_ENTITY_TYPE;
207:
208: delete from eam_safety_usr_def_statuses_b

Line 223: delete from eam_safety_usr_def_statuses_tl T

219: procedure ADD_LANGUAGE
220: is
221: begin
222:
223: delete from eam_safety_usr_def_statuses_tl T
224: where not exists
225: (select NULL
226: from eam_safety_usr_def_statuses_b B
227: where B.STATUS_ID = T.STATUS_ID

Line 231: update eam_safety_usr_def_statuses_tl T set (

227: where B.STATUS_ID = T.STATUS_ID
228: and B.ENTITY_TYPE = T.ENTITY_TYPE
229: );
230:
231: update eam_safety_usr_def_statuses_tl T set (
232: USER_DEFINED_STATUS
233: ) = (select
234: B.USER_DEFINED_STATUS
235: from

Line 236: eam_safety_usr_def_statuses_tl B

232: USER_DEFINED_STATUS
233: ) = (select
234: B.USER_DEFINED_STATUS
235: from
236: eam_safety_usr_def_statuses_tl B
237: where
238: B.STATUS_ID = T.STATUS_ID
239: and B.LANGUAGE = T.SOURCE_LANG
240: and B.ENTITY_TYPE = T.ENTITY_TYPE

Line 250: from eam_safety_usr_def_statuses_tl SUBB, eam_safety_usr_def_statuses_tl SUBT

246: ) in (select
247: SUBT.STATUS_ID,
248: SUBT.LANGUAGE,
249: SUBT.ENTITY_TYPE
250: from eam_safety_usr_def_statuses_tl SUBB, eam_safety_usr_def_statuses_tl SUBT
251: where SUBB.STATUS_ID = SUBT.STATUS_ID
252: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
253: and SUBB.ENTITY_TYPE = SUBT.ENTITY_TYPE
254: and (SUBB.USER_DEFINED_STATUS <> SUBT.USER_DEFINED_STATUS

Line 257: insert into eam_safety_usr_def_statuses_tl (

253: and SUBB.ENTITY_TYPE = SUBT.ENTITY_TYPE
254: and (SUBB.USER_DEFINED_STATUS <> SUBT.USER_DEFINED_STATUS
255: ));
256:
257: insert into eam_safety_usr_def_statuses_tl (
258: LAST_UPDATE_LOGIN,
259: CREATION_DATE,
260: STATUS_ID,
261: USER_DEFINED_STATUS,

Line 279: from eam_safety_usr_def_statuses_tl B, FND_LANGUAGES L

275: B.LAST_UPDATED_BY,
276: B.CREATED_BY,
277: L.LANGUAGE_CODE,
278: B.SOURCE_LANG
279: from eam_safety_usr_def_statuses_tl B, FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL

Line 284: from eam_safety_usr_def_statuses_tl T

280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL
284: from eam_safety_usr_def_statuses_tl T
285: where T.STATUS_ID = B.STATUS_ID
286: and T.LANGUAGE = L.LANGUAGE_CODE
287: and T.ENTITY_TYPE = B.ENTITY_TYPE);
288:

Line 315: from eam_safety_usr_def_statuses_tl

311: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
312:
313: select LAST_UPDATED_BY, LAST_UPDATE_DATE
314: into db_luby, db_ludate
315: from eam_safety_usr_def_statuses_tl
316: where STATUS_ID = P_STATUS_ID
317: and language = userenv('LANG')
318: and ENTITY_TYPE = P_ENTITY_TYPE;
319:

Line 323: update eam_safety_usr_def_statuses_tl set

319:
320: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
321: db_ludate, P_CUSTOM_MODE)) then
322:
323: update eam_safety_usr_def_statuses_tl set
324: user_defined_status = P_USER_DEFINED_STATUS,
325: last_update_date = f_ludate ,
326: last_updated_by = f_luby,
327: last_update_login = 0,