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_FORM_TAB_PAGES_PKG dependencies on HR_FORM_TAB_PAGES_TL

Line 96: p_entity_name => 'HR_FORM_TAB_PAGES_TL',

92: --
93:
94: BEGIN
95: PER_RIC_PKG.chk_integrity (
96: p_entity_name => 'HR_FORM_TAB_PAGES_TL',
97: p_ref_entity => 'HR_FORM_TAB_PAGES_B',
98: p_ref_column_name => 'FORM_TAB_PAGE_ID',
99: p_ref_col_value_number => X_FORM_TAB_PAGE_ID,
100: p_ref_col_value_varchar => NULL,

Line 109: insert into HR_FORM_TAB_PAGES_TL (

105: --
106: -- Code Ends Here.
107: --
108:
109: insert into HR_FORM_TAB_PAGES_TL (
110: USER_TAB_PAGE_NAME,
111: DESCRIPTION,
112: LAST_UPDATE_DATE,
113: LAST_UPDATED_BY,

Line 135: from HR_FORM_TAB_PAGES_TL T

131: from FND_LANGUAGES L
132: where L.INSTALLED_FLAG in ('I', 'B')
133: and not exists
134: (select NULL
135: from HR_FORM_TAB_PAGES_TL T
136: where T.FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID
137: and T.LANGUAGE = L.LANGUAGE_CODE);
138:
139: open c;

Line 174: from HR_FORM_TAB_PAGES_TL

170: cursor c1 is select
171: USER_TAB_PAGE_NAME,
172: DESCRIPTION,
173: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
174: from HR_FORM_TAB_PAGES_TL
175: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID
176: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
177: for update of FORM_TAB_PAGE_ID nowait;
178: begin

Line 245: update HR_FORM_TAB_PAGES_TL set

241: if (sql%notfound) then
242: raise no_data_found;
243: end if;
244:
245: update HR_FORM_TAB_PAGES_TL set
246: USER_TAB_PAGE_NAME = X_USER_TAB_PAGE_NAME,
247: DESCRIPTION = X_DESCRIPTION,
248: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
249: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 264: delete from HR_FORM_TAB_PAGES_TL

260: procedure DELETE_ROW (
261: X_FORM_TAB_PAGE_ID in NUMBER
262: ) is
263: begin
264: delete from HR_FORM_TAB_PAGES_TL
265: where FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID;
266:
267: if (sql%notfound) then
268: raise no_data_found;

Line 283: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_TL', PER_RIC_PKG.column_info_tbl(

279: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
280: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
281: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B', PER_RIC_PKG.column_info_tbl(
282: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID_OVERRIDE',NULL,X_FORM_TAB_PAGE_ID,NULL))),
283: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_TL', PER_RIC_PKG.column_info_tbl(
284: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
285: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_STACKED_CANVASES', PER_RIC_PKG.column_info_tbl(
286: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
287: PER_RIC_PKG.ref_info_rec('HR_TAB_PAGE_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(

Line 309: delete from HR_FORM_TAB_PAGES_TL T

305:
306: procedure ADD_LANGUAGE
307: is
308: begin
309: delete from HR_FORM_TAB_PAGES_TL T
310: where not exists
311: (select NULL
312: from HR_FORM_TAB_PAGES_B B
313: where B.FORM_TAB_PAGE_ID = T.FORM_TAB_PAGE_ID

Line 316: update HR_FORM_TAB_PAGES_TL T set (

312: from HR_FORM_TAB_PAGES_B B
313: where B.FORM_TAB_PAGE_ID = T.FORM_TAB_PAGE_ID
314: );
315:
316: update HR_FORM_TAB_PAGES_TL T set (
317: USER_TAB_PAGE_NAME,
318: DESCRIPTION
319: ) = (select
320: B.USER_TAB_PAGE_NAME,

Line 322: from HR_FORM_TAB_PAGES_TL B

318: DESCRIPTION
319: ) = (select
320: B.USER_TAB_PAGE_NAME,
321: B.DESCRIPTION
322: from HR_FORM_TAB_PAGES_TL B
323: where B.FORM_TAB_PAGE_ID = T.FORM_TAB_PAGE_ID
324: and B.LANGUAGE = T.SOURCE_LANG)
325: where (
326: T.FORM_TAB_PAGE_ID,

Line 331: from HR_FORM_TAB_PAGES_TL SUBB, HR_FORM_TAB_PAGES_TL SUBT

327: T.LANGUAGE
328: ) in (select
329: SUBT.FORM_TAB_PAGE_ID,
330: SUBT.LANGUAGE
331: from HR_FORM_TAB_PAGES_TL SUBB, HR_FORM_TAB_PAGES_TL SUBT
332: where SUBB.FORM_TAB_PAGE_ID = SUBT.FORM_TAB_PAGE_ID
333: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
334: and (SUBB.USER_TAB_PAGE_NAME <> SUBT.USER_TAB_PAGE_NAME
335: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 340: insert into HR_FORM_TAB_PAGES_TL (

336: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
337: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
338: ));
339:
340: insert into HR_FORM_TAB_PAGES_TL (
341: USER_TAB_PAGE_NAME,
342: DESCRIPTION,
343: LAST_UPDATE_DATE,
344: LAST_UPDATED_BY,

Line 362: from HR_FORM_TAB_PAGES_TL B, FND_LANGUAGES L

358: B.CREATION_DATE,
359: B.FORM_TAB_PAGE_ID,
360: L.LANGUAGE_CODE,
361: B.SOURCE_LANG
362: from HR_FORM_TAB_PAGES_TL B, FND_LANGUAGES L
363: where L.INSTALLED_FLAG in ('I', 'B')
364: and B.LANGUAGE = userenv('LANG')
365: and not exists
366: (select NULL

Line 367: from HR_FORM_TAB_PAGES_TL T

363: where L.INSTALLED_FLAG in ('I', 'B')
364: and B.LANGUAGE = userenv('LANG')
365: and not exists
366: (select NULL
367: from HR_FORM_TAB_PAGES_TL T
368: where T.FORM_TAB_PAGE_ID = B.FORM_TAB_PAGE_ID
369: and T.LANGUAGE = L.LANGUAGE_CODE);
370: end ADD_LANGUAGE;
371: procedure TRANSLATE_ROW (

Line 426: update HR_FORM_TAB_PAGES_TL set

422: and hfc.form_canvas_id = ftp.form_canvas_id
423: and ftp.tab_page_name = x_tab_page_name
424: and hfw.window_name = x_window_name;
425:
426: update HR_FORM_TAB_PAGES_TL set
427: DESCRIPTION = X_DESCRIPTION,
428: USER_TAB_PAGE_NAME = X_USER_TAB_PAGE_NAME,
429: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
430: LAST_UPDATED_BY = X_LAST_UPDATED_BY,