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_WINDOW_PROPERTIES_PKG dependencies on HR_WINDOW_PROPERTIES_TL

Line 117: update HR_WINDOW_PROPERTIES_TL set

113: where WINDOW_PROPERTY_ID = l_copy.WINDOW_PROPERTY_ID;
114: if (sql%notfound) then
115: raise no_data_found;
116: end if;
117: update HR_WINDOW_PROPERTIES_TL set
118: TITLE = decode(nvl(TITLE,hr_api.g_varchar2),nvl(l_original.TITLE,hr_api.g_varchar2),X_TITLE,TITLE),
119: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
120: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
121: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 324: p_entity_name => 'HR_WINDOW_PROPERTIES_TL',

320: --
321:
322: BEGIN
323: PER_RIC_PKG.chk_integrity (
324: p_entity_name => 'HR_WINDOW_PROPERTIES_TL',
325: p_ref_entity => 'HR_WINDOW_PROPERTIES_B',
326: p_ref_column_name => 'WINDOW_PROPERTY_ID',
327: p_ref_col_value_number => X_WINDOW_PROPERTY_ID,
328: p_ref_col_value_varchar => NULL,

Line 336: insert into HR_WINDOW_PROPERTIES_TL (

332: END;
333: --
334: -- Code Ends Here.
335: --
336: insert into HR_WINDOW_PROPERTIES_TL (
337: WINDOW_PROPERTY_ID,
338: TITLE,
339: LAST_UPDATE_DATE,
340: LAST_UPDATED_BY,

Line 360: from HR_WINDOW_PROPERTIES_TL T

356: from FND_LANGUAGES L
357: where L.INSTALLED_FLAG in ('I', 'B')
358: and not exists
359: (select NULL
360: from HR_WINDOW_PROPERTIES_TL T
361: where T.WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID
362: and T.LANGUAGE = L.LANGUAGE_CODE);
363:
364: open c;

Line 461: from HR_WINDOW_PROPERTIES_TL

457:
458: cursor c1 is select
459: TITLE,
460: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
461: from HR_WINDOW_PROPERTIES_TL
462: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID
463: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
464: for update of WINDOW_PROPERTY_ID nowait;
465: begin

Line 662: update HR_WINDOW_PROPERTIES_TL set

658: if (sql%notfound) then
659: raise no_data_found;
660: end if;
661:
662: update HR_WINDOW_PROPERTIES_TL set
663: TITLE = X_TITLE,
664: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
665: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
666: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 680: delete from HR_WINDOW_PROPERTIES_TL

676: procedure DELETE_ROW (
677: X_WINDOW_PROPERTY_ID in NUMBER
678: ) is
679: begin
680: delete from HR_WINDOW_PROPERTIES_TL
681: where WINDOW_PROPERTY_ID = X_WINDOW_PROPERTY_ID;
682:
683: if (sql%notfound) then
684: raise no_data_found;

Line 694: p_ref_entity => 'HR_WINDOW_PROPERTIES_TL',

690:
691: BEGIN
692: PER_RIC_PKG.chk_integrity (
693: p_entity_name => 'HR_WINDOW_PROPERTIES_B',
694: p_ref_entity => 'HR_WINDOW_PROPERTIES_TL',
695: p_ref_column_name => 'WINDOW_PROPERTY_ID',
696: p_ref_col_value_number => X_WINDOW_PROPERTY_ID,
697: p_ref_col_value_varchar => NULL,
698: p_ref_col_value_date => NULL,

Line 716: delete from HR_WINDOW_PROPERTIES_TL T

712:
713: procedure ADD_LANGUAGE
714: is
715: begin
716: delete from HR_WINDOW_PROPERTIES_TL T
717: where not exists
718: (select NULL
719: from HR_WINDOW_PROPERTIES_B B
720: where B.WINDOW_PROPERTY_ID = T.WINDOW_PROPERTY_ID

Line 723: update HR_WINDOW_PROPERTIES_TL T set (

719: from HR_WINDOW_PROPERTIES_B B
720: where B.WINDOW_PROPERTY_ID = T.WINDOW_PROPERTY_ID
721: );
722:
723: update HR_WINDOW_PROPERTIES_TL T set (
724: TITLE
725: ) = (select
726: B.TITLE
727: from HR_WINDOW_PROPERTIES_TL B

Line 727: from HR_WINDOW_PROPERTIES_TL B

723: update HR_WINDOW_PROPERTIES_TL T set (
724: TITLE
725: ) = (select
726: B.TITLE
727: from HR_WINDOW_PROPERTIES_TL B
728: where B.WINDOW_PROPERTY_ID = T.WINDOW_PROPERTY_ID
729: and B.LANGUAGE = T.SOURCE_LANG)
730: where (
731: T.WINDOW_PROPERTY_ID,

Line 736: from HR_WINDOW_PROPERTIES_TL SUBB, HR_WINDOW_PROPERTIES_TL SUBT

732: T.LANGUAGE
733: ) in (select
734: SUBT.WINDOW_PROPERTY_ID,
735: SUBT.LANGUAGE
736: from HR_WINDOW_PROPERTIES_TL SUBB, HR_WINDOW_PROPERTIES_TL SUBT
737: where SUBB.WINDOW_PROPERTY_ID = SUBT.WINDOW_PROPERTY_ID
738: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
739: and (SUBB.TITLE <> SUBT.TITLE
740: or (SUBB.TITLE is null and SUBT.TITLE is not null)

Line 744: insert into HR_WINDOW_PROPERTIES_TL (

740: or (SUBB.TITLE is null and SUBT.TITLE is not null)
741: or (SUBB.TITLE is not null and SUBT.TITLE is null)
742: ));
743:
744: insert into HR_WINDOW_PROPERTIES_TL (
745: WINDOW_PROPERTY_ID,
746: TITLE,
747: LAST_UPDATE_DATE,
748: LAST_UPDATED_BY,

Line 764: from HR_WINDOW_PROPERTIES_TL B, FND_LANGUAGES L

760: B.CREATED_BY,
761: B.CREATION_DATE,
762: L.LANGUAGE_CODE,
763: B.SOURCE_LANG
764: from HR_WINDOW_PROPERTIES_TL B, FND_LANGUAGES L
765: where L.INSTALLED_FLAG in ('I', 'B')
766: and B.LANGUAGE = userenv('LANG')
767: and not exists
768: (select NULL

Line 769: from HR_WINDOW_PROPERTIES_TL T

765: where L.INSTALLED_FLAG in ('I', 'B')
766: and B.LANGUAGE = userenv('LANG')
767: and not exists
768: (select NULL
769: from HR_WINDOW_PROPERTIES_TL T
770: where T.WINDOW_PROPERTY_ID = B.WINDOW_PROPERTY_ID
771: and T.LANGUAGE = L.LANGUAGE_CODE);
772: end ADD_LANGUAGE;
773:

Line 848: update HR_WINDOW_PROPERTIES_TL set

844: from hr_window_properties_b
845: where nvl(form_window_id,hr_api.g_number) = nvl(x_form_window_id,hr_api.g_number)
846: and nvl(template_window_id,hr_api.g_number) = nvl(x_template_window_id,hr_api.g_number);
847:
848: update HR_WINDOW_PROPERTIES_TL set
849: TITLE = X_TITLE,
850: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
851: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
852: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,