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_TEMPLATES_PKG dependencies on HR_FORM_TEMPLATES_TL

Line 208: p_entity_name => 'HR_FORM_TEMPLATES_TL',

204: --
205:
206: BEGIN
207: PER_RIC_PKG.chk_integrity (
208: p_entity_name => 'HR_FORM_TEMPLATES_TL',
209: p_ref_entity => 'HR_FORM_TEMPLATES_B',
210: p_ref_column_name => 'FORM_TEMPLATE_ID',
211: p_ref_col_value_number => X_FORM_TEMPLATE_ID,
212: p_ref_col_value_varchar => NULL,

Line 221: insert into HR_FORM_TEMPLATES_TL (

217: --
218: -- Code Ends Here.
219: --
220:
221: insert into HR_FORM_TEMPLATES_TL (
222: FORM_TEMPLATE_ID,
223: USER_TEMPLATE_NAME,
224: DESCRIPTION,
225: LAST_UPDATE_DATE,

Line 247: from HR_FORM_TEMPLATES_TL T

243: from FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and not exists
246: (select NULL
247: from HR_FORM_TEMPLATES_TL T
248: where T.FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250:
251: open c;

Line 350: from HR_FORM_TEMPLATES_TL

346: cursor c1 is select
347: USER_TEMPLATE_NAME,
348: DESCRIPTION,
349: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
350: from HR_FORM_TEMPLATES_TL
351: where FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID
352: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
353: for update of FORM_TEMPLATE_ID nowait;
354: begin

Line 548: update HR_FORM_TEMPLATES_TL set

544: if (sql%notfound) then
545: raise no_data_found;
546: end if;
547:
548: update HR_FORM_TEMPLATES_TL set
549: USER_TEMPLATE_NAME = X_USER_TEMPLATE_NAME,
550: DESCRIPTION = X_DESCRIPTION,
551: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
552: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 567: delete from HR_FORM_TEMPLATES_TL

563: procedure DELETE_ROW (
564: X_FORM_TEMPLATE_ID in NUMBER
565: ) is
566: begin
567: delete from HR_FORM_TEMPLATES_TL
568: where FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID;
569:
570: if (sql%notfound) then
571: raise no_data_found;

Line 585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(

581: p_entity_name => 'HR_FORM_TEMPLATES_B',
582: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
583: PER_RIC_PKG.ref_info_rec('HR_FORM_PROPERTIES', PER_RIC_PKG.column_info_tbl(
584: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
585: PER_RIC_PKG.ref_info_rec('HR_FORM_TEMPLATES_TL', PER_RIC_PKG.column_info_tbl(
586: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID,NULL))),
587: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(
588: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID_TO',NULL,X_FORM_TEMPLATE_ID,NULL))),
589: PER_RIC_PKG.ref_info_rec('HR_SOURCE_FORM_TEMPLATES', PER_RIC_PKG.column_info_tbl(

Line 616: delete from HR_FORM_TEMPLATES_TL T

612:
613: procedure ADD_LANGUAGE
614: is
615: begin
616: delete from HR_FORM_TEMPLATES_TL T
617: where not exists
618: (select NULL
619: from HR_FORM_TEMPLATES_B B
620: where B.FORM_TEMPLATE_ID = T.FORM_TEMPLATE_ID

Line 623: update HR_FORM_TEMPLATES_TL T set (

619: from HR_FORM_TEMPLATES_B B
620: where B.FORM_TEMPLATE_ID = T.FORM_TEMPLATE_ID
621: );
622:
623: update HR_FORM_TEMPLATES_TL T set (
624: USER_TEMPLATE_NAME,
625: DESCRIPTION
626: ) = (select
627: B.USER_TEMPLATE_NAME,

Line 629: from HR_FORM_TEMPLATES_TL B

625: DESCRIPTION
626: ) = (select
627: B.USER_TEMPLATE_NAME,
628: B.DESCRIPTION
629: from HR_FORM_TEMPLATES_TL B
630: where B.FORM_TEMPLATE_ID = T.FORM_TEMPLATE_ID
631: and B.LANGUAGE = T.SOURCE_LANG)
632: where (
633: T.FORM_TEMPLATE_ID,

Line 638: from HR_FORM_TEMPLATES_TL SUBB, HR_FORM_TEMPLATES_TL SUBT

634: T.LANGUAGE
635: ) in (select
636: SUBT.FORM_TEMPLATE_ID,
637: SUBT.LANGUAGE
638: from HR_FORM_TEMPLATES_TL SUBB, HR_FORM_TEMPLATES_TL SUBT
639: where SUBB.FORM_TEMPLATE_ID = SUBT.FORM_TEMPLATE_ID
640: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
641: and (SUBB.USER_TEMPLATE_NAME <> SUBT.USER_TEMPLATE_NAME
642: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 647: insert into HR_FORM_TEMPLATES_TL (

643: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
644: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
645: ));
646:
647: insert into HR_FORM_TEMPLATES_TL (
648: FORM_TEMPLATE_ID,
649: USER_TEMPLATE_NAME,
650: DESCRIPTION,
651: LAST_UPDATE_DATE,

Line 669: from HR_FORM_TEMPLATES_TL B, FND_LANGUAGES L

665: B.CREATED_BY,
666: B.CREATION_DATE,
667: L.LANGUAGE_CODE,
668: B.SOURCE_LANG
669: from HR_FORM_TEMPLATES_TL B, FND_LANGUAGES L
670: where L.INSTALLED_FLAG in ('I', 'B')
671: and B.LANGUAGE = userenv('LANG')
672: and not exists
673: (select NULL

Line 674: from HR_FORM_TEMPLATES_TL T

670: where L.INSTALLED_FLAG in ('I', 'B')
671: and B.LANGUAGE = userenv('LANG')
672: and not exists
673: (select NULL
674: from HR_FORM_TEMPLATES_TL T
675: where T.FORM_TEMPLATE_ID = B.FORM_TEMPLATE_ID
676: and T.LANGUAGE = L.LANGUAGE_CODE);
677: end ADD_LANGUAGE;
678:

Line 730: update HR_FORM_TEMPLATES_TL set

726: and application_id = x_application_id
727: and form_id = x_form_id;
728: end;
729:
730: update HR_FORM_TEMPLATES_TL set
731: DESCRIPTION = X_DESCRIPTION,
732: USER_TEMPLATE_NAME = X_USER_TEMPLATE_NAME,
733: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
734: LAST_UPDATED_BY = X_LAST_UPDATED_BY,