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_TAB_PAGE_PROPERTIES_PKG dependencies on HR_TAB_PAGE_PROPERTIES_TL

Line 121: update HR_TAB_PAGE_PROPERTIES_TL set

117: where TAB_PAGE_PROPERTY_ID = l_copy.TAB_PAGE_PROPERTY_ID;
118: if (sql%notfound) then
119: raise no_data_found;
120: end if;
121: update HR_TAB_PAGE_PROPERTIES_TL set
122: LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),
123: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
124: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
125: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 294: insert into HR_TAB_PAGE_PROPERTIES_TL (

290: X_LAST_UPDATED_BY,
291: X_LAST_UPDATE_LOGIN
292: );
293:
294: insert into HR_TAB_PAGE_PROPERTIES_TL (
295: TAB_PAGE_PROPERTY_ID,
296: LABEL,
297: LAST_UPDATE_DATE,
298: LAST_UPDATED_BY,

Line 318: from HR_TAB_PAGE_PROPERTIES_TL T

314: from FND_LANGUAGES L
315: where L.INSTALLED_FLAG in ('I', 'B')
316: and not exists
317: (select NULL
318: from HR_TAB_PAGE_PROPERTIES_TL T
319: where T.TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
320: and T.LANGUAGE = L.LANGUAGE_CODE);
321:
322: open c;

Line 415: from HR_TAB_PAGE_PROPERTIES_TL

411:
412: cursor c1 is select
413: LABEL,
414: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
415: from HR_TAB_PAGE_PROPERTIES_TL
416: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
417: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
418: for update of TAB_PAGE_PROPERTY_ID nowait;
419: begin

Line 608: update HR_TAB_PAGE_PROPERTIES_TL set

604: if (sql%notfound) then
605: raise no_data_found;
606: end if;
607:
608: update HR_TAB_PAGE_PROPERTIES_TL set
609: LABEL = X_LABEL,
610: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
611: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
612: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 626: delete from HR_TAB_PAGE_PROPERTIES_TL

622: procedure DELETE_ROW (
623: X_TAB_PAGE_PROPERTY_ID in NUMBER
624: ) is
625: begin
626: delete from HR_TAB_PAGE_PROPERTIES_TL
627: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
628:
629: if (sql%notfound) then
630: raise no_data_found;

Line 644: delete from HR_TAB_PAGE_PROPERTIES_TL T

640:
641: procedure ADD_LANGUAGE
642: is
643: begin
644: delete from HR_TAB_PAGE_PROPERTIES_TL T
645: where not exists
646: (select NULL
647: from HR_TAB_PAGE_PROPERTIES_B B
648: where B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID

Line 651: update HR_TAB_PAGE_PROPERTIES_TL T set (

647: from HR_TAB_PAGE_PROPERTIES_B B
648: where B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID
649: );
650:
651: update HR_TAB_PAGE_PROPERTIES_TL T set (
652: LABEL
653: ) = (select
654: B.LABEL
655: from HR_TAB_PAGE_PROPERTIES_TL B

Line 655: from HR_TAB_PAGE_PROPERTIES_TL B

651: update HR_TAB_PAGE_PROPERTIES_TL T set (
652: LABEL
653: ) = (select
654: B.LABEL
655: from HR_TAB_PAGE_PROPERTIES_TL B
656: where B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID
657: and B.LANGUAGE = T.SOURCE_LANG)
658: where (
659: T.TAB_PAGE_PROPERTY_ID,

Line 664: from HR_TAB_PAGE_PROPERTIES_TL SUBB, HR_TAB_PAGE_PROPERTIES_TL SUBT

660: T.LANGUAGE
661: ) in (select
662: SUBT.TAB_PAGE_PROPERTY_ID,
663: SUBT.LANGUAGE
664: from HR_TAB_PAGE_PROPERTIES_TL SUBB, HR_TAB_PAGE_PROPERTIES_TL SUBT
665: where SUBB.TAB_PAGE_PROPERTY_ID = SUBT.TAB_PAGE_PROPERTY_ID
666: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
667: and (SUBB.LABEL <> SUBT.LABEL
668: or (SUBB.LABEL is null and SUBT.LABEL is not null)

Line 672: insert into HR_TAB_PAGE_PROPERTIES_TL (

668: or (SUBB.LABEL is null and SUBT.LABEL is not null)
669: or (SUBB.LABEL is not null and SUBT.LABEL is null)
670: ));
671:
672: insert into HR_TAB_PAGE_PROPERTIES_TL (
673: TAB_PAGE_PROPERTY_ID,
674: LABEL,
675: LAST_UPDATE_DATE,
676: LAST_UPDATED_BY,

Line 692: from HR_TAB_PAGE_PROPERTIES_TL B, FND_LANGUAGES L

688: B.CREATED_BY,
689: B.CREATION_DATE,
690: L.LANGUAGE_CODE,
691: B.SOURCE_LANG
692: from HR_TAB_PAGE_PROPERTIES_TL B, FND_LANGUAGES L
693: where L.INSTALLED_FLAG in ('I', 'B')
694: and B.LANGUAGE = userenv('LANG')
695: and not exists
696: (select NULL

Line 697: from HR_TAB_PAGE_PROPERTIES_TL T

693: where L.INSTALLED_FLAG in ('I', 'B')
694: and B.LANGUAGE = userenv('LANG')
695: and not exists
696: (select NULL
697: from HR_TAB_PAGE_PROPERTIES_TL T
698: where T.TAB_PAGE_PROPERTY_ID = B.TAB_PAGE_PROPERTY_ID
699: and T.LANGUAGE = L.LANGUAGE_CODE);
700: end ADD_LANGUAGE;
701:

Line 816: from HR_TAB_PAGE_PROPERTIES_TL

812: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
813:
814: select LAST_UPDATED_BY, LAST_UPDATE_DATE
815: into db_luby, db_ludate
816: from HR_TAB_PAGE_PROPERTIES_TL
817: where tab_page_property_id = x_tab_page_property_id
818: and LANGUAGE=userenv('LANG');
819:
820: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 823: update HR_TAB_PAGE_PROPERTIES_TL set

819:
820: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
821: db_ludate,X_CUSTOM_MODE)) then
822:
823: update HR_TAB_PAGE_PROPERTIES_TL set
824: LABEL = X_LABEL,
825: LAST_UPDATE_DATE = f_ludate,
826: LAST_UPDATED_BY = f_luby,
827: LAST_UPDATE_LOGIN = 0,

Line 994: from HR_TAB_PAGE_PROPERTIES_TL

990: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
991:
992: select LAST_UPDATED_BY, LAST_UPDATE_DATE
993: into db_luby, db_ludate
994: from HR_TAB_PAGE_PROPERTIES_TL
995: where tab_page_property_id = x_tab_page_property_id
996: and LANGUAGE=userenv('LANG');
997:
998: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,