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.

[Home] [Help]

APPS.HR_FORM_WINDOWS_PKG dependencies on HR_FORM_WINDOWS_TL

Line 73: p_entity_name => 'HR_FORM_WINDOWS_TL',

69: --
70:
71: BEGIN
72: PER_RIC_PKG.chk_integrity (
73: p_entity_name => 'HR_FORM_WINDOWS_TL',
74: p_ref_entity => 'HR_FORM_WINDOWS_B',
75: p_ref_column_name => 'FORM_WINDOW_ID',
76: p_ref_col_value_number => X_FORM_WINDOW_ID,
77: p_ref_col_value_varchar => NULL,

Line 86: insert into HR_FORM_WINDOWS_TL (

82: --
83: -- Code Ends Here.
84: --
85:
86: insert into HR_FORM_WINDOWS_TL (
87: FORM_WINDOW_ID,
88: USER_WINDOW_NAME,
89: DESCRIPTION,
90: LAST_UPDATE_DATE,

Line 112: from HR_FORM_WINDOWS_TL T

108: from FND_LANGUAGES L
109: where L.INSTALLED_FLAG in ('I', 'B')
110: and not exists
111: (select NULL
112: from HR_FORM_WINDOWS_TL T
113: where T.FORM_WINDOW_ID = X_FORM_WINDOW_ID
114: and T.LANGUAGE = L.LANGUAGE_CODE);
115:
116: open c;

Line 149: from HR_FORM_WINDOWS_TL

145: cursor c1 is select
146: USER_WINDOW_NAME,
147: DESCRIPTION,
148: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
149: from HR_FORM_WINDOWS_TL
150: where FORM_WINDOW_ID = X_FORM_WINDOW_ID
151: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
152: for update of FORM_WINDOW_ID nowait;
153: begin

Line 216: update HR_FORM_WINDOWS_TL set

212: if (sql%notfound) then
213: raise no_data_found;
214: end if;
215:
216: update HR_FORM_WINDOWS_TL set
217: USER_WINDOW_NAME = X_USER_WINDOW_NAME,
218: DESCRIPTION = X_DESCRIPTION,
219: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
220: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 235: delete from HR_FORM_WINDOWS_TL

231: procedure DELETE_ROW (
232: X_FORM_WINDOW_ID in NUMBER
233: ) is
234: begin
235: delete from HR_FORM_WINDOWS_TL
236: where FORM_WINDOW_ID = X_FORM_WINDOW_ID;
237:
238: if (sql%notfound) then
239: raise no_data_found;

Line 253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(

249: p_entity_name => 'HR_FORM_WINDOWS_B',
250: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
251: PER_RIC_PKG.ref_info_rec('HR_FORM_CANVASES_B', PER_RIC_PKG.column_info_tbl(
252: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
253: PER_RIC_PKG.ref_info_rec('HR_FORM_WINDOWS_TL', PER_RIC_PKG.column_info_tbl(
254: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
255: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_WINDOWS_B', PER_RIC_PKG.column_info_tbl(
256: PER_RIC_PKG.col_info_rec('FORM_WINDOW_ID',NULL,X_FORM_WINDOW_ID,NULL))),
257: PER_RIC_PKG.ref_info_rec('HR_WINDOW_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(

Line 278: delete from HR_FORM_WINDOWS_TL T

274:
275: procedure ADD_LANGUAGE
276: is
277: begin
278: delete from HR_FORM_WINDOWS_TL T
279: where not exists
280: (select NULL
281: from HR_FORM_WINDOWS_B B
282: where B.FORM_WINDOW_ID = T.FORM_WINDOW_ID

Line 285: update HR_FORM_WINDOWS_TL T set (

281: from HR_FORM_WINDOWS_B B
282: where B.FORM_WINDOW_ID = T.FORM_WINDOW_ID
283: );
284:
285: update HR_FORM_WINDOWS_TL T set (
286: USER_WINDOW_NAME,
287: DESCRIPTION
288: ) = (select
289: B.USER_WINDOW_NAME,

Line 291: from HR_FORM_WINDOWS_TL B

287: DESCRIPTION
288: ) = (select
289: B.USER_WINDOW_NAME,
290: B.DESCRIPTION
291: from HR_FORM_WINDOWS_TL B
292: where B.FORM_WINDOW_ID = T.FORM_WINDOW_ID
293: and B.LANGUAGE = T.SOURCE_LANG)
294: where (
295: T.FORM_WINDOW_ID,

Line 300: from HR_FORM_WINDOWS_TL SUBB, HR_FORM_WINDOWS_TL SUBT

296: T.LANGUAGE
297: ) in (select
298: SUBT.FORM_WINDOW_ID,
299: SUBT.LANGUAGE
300: from HR_FORM_WINDOWS_TL SUBB, HR_FORM_WINDOWS_TL SUBT
301: where SUBB.FORM_WINDOW_ID = SUBT.FORM_WINDOW_ID
302: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
303: and (SUBB.USER_WINDOW_NAME <> SUBT.USER_WINDOW_NAME
304: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 309: insert into HR_FORM_WINDOWS_TL (

305: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
306: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
307: ));
308:
309: insert into HR_FORM_WINDOWS_TL (
310: FORM_WINDOW_ID,
311: USER_WINDOW_NAME,
312: DESCRIPTION,
313: LAST_UPDATE_DATE,

Line 331: from HR_FORM_WINDOWS_TL B, FND_LANGUAGES L

327: B.CREATED_BY,
328: B.CREATION_DATE,
329: L.LANGUAGE_CODE,
330: B.SOURCE_LANG
331: from HR_FORM_WINDOWS_TL B, FND_LANGUAGES L
332: where L.INSTALLED_FLAG in ('I', 'B')
333: and B.LANGUAGE = userenv('LANG')
334: and not exists
335: (select NULL

Line 336: from HR_FORM_WINDOWS_TL T

332: where L.INSTALLED_FLAG in ('I', 'B')
333: and B.LANGUAGE = userenv('LANG')
334: and not exists
335: (select NULL
336: from HR_FORM_WINDOWS_TL T
337: where T.FORM_WINDOW_ID = B.FORM_WINDOW_ID
338: and T.LANGUAGE = L.LANGUAGE_CODE);
339: end ADD_LANGUAGE;
340: procedure TRANSLATE_ROW (

Line 385: update HR_FORM_WINDOWS_TL set

381: where window_name = x_window_name
382: and application_id = x_application_id
383: and form_id = x_form_id;
384:
385: update HR_FORM_WINDOWS_TL set
386: DESCRIPTION = X_DESCRIPTION,
387: USER_WINDOW_NAME = X_USER_WINDOW_NAME,
388: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
389: LAST_UPDATED_BY = X_LAST_UPDATED_BY,