APPS.HR_FORM_ITEMS_PKG dependencies on HR_FORM_ITEMS_TL

Line 117: p_entity_name => 'HR_FORM_ITEMS_TL',

113: --
114:
115: BEGIN
116: PER_RIC_PKG.chk_integrity (
117: p_entity_name => 'HR_FORM_ITEMS_TL',
118: p_ref_entity => 'HR_FORM_ITEMS_B',
119: p_ref_column_name => 'FORM_ITEM_ID',
120: p_ref_col_value_number => X_FORM_ITEM_ID,
121: p_ref_col_value_varchar => NULL,

Line 129: insert into HR_FORM_ITEMS_TL (

125: END;
126: --
127: -- Code Ends Here.
128: --
129: insert into HR_FORM_ITEMS_TL (
130: LAST_UPDATE_LOGIN,
131: CREATED_BY,
132: CREATION_DATE,
133: LAST_UPDATE_DATE,

Line 155: from HR_FORM_ITEMS_TL T

151: from FND_LANGUAGES L
152: where L.INSTALLED_FLAG in ('I', 'B')
153: and not exists
154: (select NULL
155: from HR_FORM_ITEMS_TL T
156: where T.FORM_ITEM_ID = X_FORM_ITEM_ID
157: and T.LANGUAGE = L.LANGUAGE_CODE);
158:
159: open c;

Line 206: from HR_FORM_ITEMS_TL

202: cursor c1 is select
203: USER_ITEM_NAME,
204: DESCRIPTION,
205: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
206: from HR_FORM_ITEMS_TL
207: where FORM_ITEM_ID = X_FORM_ITEM_ID
208: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
209: for update of FORM_ITEM_ID nowait;
210: begin

Line 299: update HR_FORM_ITEMS_TL set

295: if (sql%notfound) then
296: raise no_data_found;
297: end if;
298:
299: update HR_FORM_ITEMS_TL set
300: USER_ITEM_NAME = X_USER_ITEM_NAME,
301: DESCRIPTION = X_DESCRIPTION,
302: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
303: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 318: delete from HR_FORM_ITEMS_TL

314: procedure DELETE_ROW (
315: X_FORM_ITEM_ID in NUMBER
316: ) is
317: begin
318: delete from HR_FORM_ITEMS_TL
319: where FORM_ITEM_ID = X_FORM_ITEM_ID;
320:
321: if (sql%notfound) then
322: raise no_data_found;

Line 335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_TL', PER_RIC_PKG.column_info_tbl(

331: p_entity_name => 'HR_FORM_ITEMS_B',
332: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
333: PER_RIC_PKG.ref_info_rec('HR_FORM_DATA_GROUP_ITEMS', PER_RIC_PKG.column_info_tbl(
334: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
335: PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_TL', PER_RIC_PKG.column_info_tbl(
336: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
337: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('FORM_ITEM_ID',NULL,X_FORM_ITEM_ID,NULL))),
339: PER_RIC_PKG.ref_info_rec('HR_ITEM_PROPERTIES_B', PER_RIC_PKG.column_info_tbl(

Line 384: delete from HR_FORM_ITEMS_TL T

380:
381: procedure ADD_LANGUAGE
382: is
383: begin
384: delete from HR_FORM_ITEMS_TL T
385: where not exists
386: (select NULL
387: from HR_FORM_ITEMS_B B
388: where B.FORM_ITEM_ID = T.FORM_ITEM_ID

Line 391: update HR_FORM_ITEMS_TL T set (

387: from HR_FORM_ITEMS_B B
388: where B.FORM_ITEM_ID = T.FORM_ITEM_ID
389: );
390:
391: update HR_FORM_ITEMS_TL T set (
392: USER_ITEM_NAME,
393: DESCRIPTION
394: ) = (select
395: B.USER_ITEM_NAME,

Line 397: from HR_FORM_ITEMS_TL B

393: DESCRIPTION
394: ) = (select
395: B.USER_ITEM_NAME,
396: B.DESCRIPTION
397: from HR_FORM_ITEMS_TL B
398: where B.FORM_ITEM_ID = T.FORM_ITEM_ID
399: and B.LANGUAGE = T.SOURCE_LANG)
400: where (
401: T.FORM_ITEM_ID,

Line 406: from HR_FORM_ITEMS_TL SUBB, HR_FORM_ITEMS_TL SUBT

402: T.LANGUAGE
403: ) in (select
404: SUBT.FORM_ITEM_ID,
405: SUBT.LANGUAGE
406: from HR_FORM_ITEMS_TL SUBB, HR_FORM_ITEMS_TL SUBT
407: where SUBB.FORM_ITEM_ID = SUBT.FORM_ITEM_ID
408: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
409: and (SUBB.USER_ITEM_NAME <> SUBT.USER_ITEM_NAME
410: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 415: insert into HR_FORM_ITEMS_TL (

411: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
412: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
413: ));
414:
415: insert into HR_FORM_ITEMS_TL (
416: LAST_UPDATE_LOGIN,
417: CREATED_BY,
418: CREATION_DATE,
419: LAST_UPDATE_DATE,

Line 437: from HR_FORM_ITEMS_TL B, FND_LANGUAGES L

433: B.USER_ITEM_NAME,
434: B.DESCRIPTION,
435: L.LANGUAGE_CODE,
436: B.SOURCE_LANG
437: from HR_FORM_ITEMS_TL B, FND_LANGUAGES L
438: where L.INSTALLED_FLAG in ('I', 'B')
439: and B.LANGUAGE = userenv('LANG')
440: and not exists
441: (select NULL

Line 442: from HR_FORM_ITEMS_TL T

438: where L.INSTALLED_FLAG in ('I', 'B')
439: and B.LANGUAGE = userenv('LANG')
440: and not exists
441: (select NULL
442: from HR_FORM_ITEMS_TL T
443: where T.FORM_ITEM_ID = B.FORM_ITEM_ID
444: and T.LANGUAGE = L.LANGUAGE_CODE);
445: end ADD_LANGUAGE;
446: procedure TRANSLATE_ROW (

Line 498: update HR_FORM_ITEMS_TL set

494: and form_id = x_form_id
495: and ( radio_button_name = x_radio_button_name
496: or (radio_button_name is null and x_radio_button_name is null) );
497:
498: update HR_FORM_ITEMS_TL set
499: DESCRIPTION = X_DESCRIPTION,
500: USER_ITEM_NAME = X_USER_ITEM_NAME,
501: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
502: LAST_UPDATED_BY = X_LAST_UPDATED_BY,