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_DATA_GROUPS_PKG dependencies on HR_FORM_DATA_GROUPS_TL

Line 72: p_entity_name => 'HR_FORM_DATA_GROUPS_TL',

68: -- Code Starts Here.
69: --
70: BEGIN
71: PER_RIC_PKG.chk_integrity (
72: p_entity_name => 'HR_FORM_DATA_GROUPS_TL',
73: p_ref_entity => 'HR_FORM_DATA_GROUPS_B',
74: p_ref_column_name => 'FORM_DATA_GROUP_ID',
75: p_ref_col_value_number => X_FORM_DATA_GROUP_ID,
76: p_ref_col_value_varchar => NULL,

Line 85: insert into HR_FORM_DATA_GROUPS_TL (

81: --
82: -- Code Ends Here.
83: --
84:
85: insert into HR_FORM_DATA_GROUPS_TL (
86: CREATED_BY,
87: CREATION_DATE,
88: USER_DATA_GROUP_NAME,
89: DESCRIPTION,

Line 111: from HR_FORM_DATA_GROUPS_TL T

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

Line 148: from HR_FORM_DATA_GROUPS_TL

144: cursor c1 is select
145: USER_DATA_GROUP_NAME,
146: DESCRIPTION,
147: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
148: from HR_FORM_DATA_GROUPS_TL
149: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID
150: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
151: for update of FORM_DATA_GROUP_ID nowait;
152: begin

Line 215: update HR_FORM_DATA_GROUPS_TL set

211: if (sql%notfound) then
212: raise no_data_found;
213: end if;
214:
215: update HR_FORM_DATA_GROUPS_TL set
216: USER_DATA_GROUP_NAME = X_USER_DATA_GROUP_NAME,
217: DESCRIPTION = X_DESCRIPTION,
218: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
219: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 234: delete from HR_FORM_DATA_GROUPS_TL

230: procedure DELETE_ROW (
231: X_FORM_DATA_GROUP_ID in NUMBER
232: ) is
233: begin
234: delete from HR_FORM_DATA_GROUPS_TL
235: where FORM_DATA_GROUP_ID = X_FORM_DATA_GROUP_ID;
236:
237: if (sql%notfound) then
238: raise no_data_found;

Line 250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(

246: BEGIN
247: PER_RIC_PKG.chk_integrity (
248: p_entity_name => 'HR_FORM_DATA_GROUPS_B',
249: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
250: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUPS_TL', PER_RIC_PKG.column_info_tbl(
251: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
252: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
253: PER_RIC_PKG.col_info_rec('FORM_DATA_GROUP_ID',NULL,X_FORM_DATA_GROUP_ID,NULL))),
254: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_DATA_GROUPS', PER_RIC_PKG.column_info_tbl(

Line 276: delete from HR_FORM_DATA_GROUPS_TL T

272:
273: procedure ADD_LANGUAGE
274: is
275: begin
276: delete from HR_FORM_DATA_GROUPS_TL T
277: where not exists
278: (select NULL
279: from HR_FORM_DATA_GROUPS_B B
280: where B.FORM_DATA_GROUP_ID = T.FORM_DATA_GROUP_ID

Line 283: update HR_FORM_DATA_GROUPS_TL T set (

279: from HR_FORM_DATA_GROUPS_B B
280: where B.FORM_DATA_GROUP_ID = T.FORM_DATA_GROUP_ID
281: );
282:
283: update HR_FORM_DATA_GROUPS_TL T set (
284: USER_DATA_GROUP_NAME,
285: DESCRIPTION
286: ) = (select
287: B.USER_DATA_GROUP_NAME,

Line 289: from HR_FORM_DATA_GROUPS_TL B

285: DESCRIPTION
286: ) = (select
287: B.USER_DATA_GROUP_NAME,
288: B.DESCRIPTION
289: from HR_FORM_DATA_GROUPS_TL B
290: where B.FORM_DATA_GROUP_ID = T.FORM_DATA_GROUP_ID
291: and B.LANGUAGE = T.SOURCE_LANG)
292: where (
293: T.FORM_DATA_GROUP_ID,

Line 298: from HR_FORM_DATA_GROUPS_TL SUBB, HR_FORM_DATA_GROUPS_TL SUBT

294: T.LANGUAGE
295: ) in (select
296: SUBT.FORM_DATA_GROUP_ID,
297: SUBT.LANGUAGE
298: from HR_FORM_DATA_GROUPS_TL SUBB, HR_FORM_DATA_GROUPS_TL SUBT
299: where SUBB.FORM_DATA_GROUP_ID = SUBT.FORM_DATA_GROUP_ID
300: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
301: and (SUBB.USER_DATA_GROUP_NAME <> SUBT.USER_DATA_GROUP_NAME
302: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 308: insert into HR_FORM_DATA_GROUPS_TL (

304: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
305: ));
306:
307:
308: insert into HR_FORM_DATA_GROUPS_TL (
309: CREATED_BY,
310: CREATION_DATE,
311: USER_DATA_GROUP_NAME,
312: DESCRIPTION,

Line 330: from HR_FORM_DATA_GROUPS_TL B, FND_LANGUAGES L

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

Line 335: from HR_FORM_DATA_GROUPS_TL T

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

Line 385: update HR_FORM_DATA_GROUPS_TL set

381: where data_group_name = x_data_group_name
382: and application_id = x_application_id
383: and form_id = x_form_id;
384:
385: update HR_FORM_DATA_GROUPS_TL set
386: DESCRIPTION = X_DESCRIPTION,
387: USER_DATA_GROUP_NAME = X_USER_DATA_GROUP_NAME,
388: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
389: LAST_UPDATED_BY = X_LAST_UPDATED_BY,