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 323: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_TL',

319: --
320:
321: BEGIN
322: PER_RIC_PKG.chk_integrity (
323: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_TL',
324: p_ref_entity => 'HR_TAB_PAGE_PROPERTIES_B',
325: p_ref_column_name => 'TAB_PAGE_PROPERTY_ID',
326: p_ref_col_value_number => X_TAB_PAGE_PROPERTY_ID,
327: p_ref_col_value_varchar => NULL,

Line 336: insert into HR_TAB_PAGE_PROPERTIES_TL (

332: --
333: -- Code Ends Here.
334: --
335:
336: insert into HR_TAB_PAGE_PROPERTIES_TL (
337: TAB_PAGE_PROPERTY_ID,
338: LABEL,
339: LAST_UPDATE_DATE,
340: LAST_UPDATED_BY,

Line 360: from HR_TAB_PAGE_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_TAB_PAGE_PROPERTIES_TL T
361: where T.TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
362: and T.LANGUAGE = L.LANGUAGE_CODE);
363:
364: open c;

Line 457: from HR_TAB_PAGE_PROPERTIES_TL

453:
454: cursor c1 is select
455: LABEL,
456: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
457: from HR_TAB_PAGE_PROPERTIES_TL
458: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
459: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
460: for update of TAB_PAGE_PROPERTY_ID nowait;
461: begin

Line 650: update HR_TAB_PAGE_PROPERTIES_TL set

646: if (sql%notfound) then
647: raise no_data_found;
648: end if;
649:
650: update HR_TAB_PAGE_PROPERTIES_TL set
651: LABEL = X_LABEL,
652: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
653: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
654: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 668: delete from HR_TAB_PAGE_PROPERTIES_TL

664: procedure DELETE_ROW (
665: X_TAB_PAGE_PROPERTY_ID in NUMBER
666: ) is
667: begin
668: delete from HR_TAB_PAGE_PROPERTIES_TL
669: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
670:
671: if (sql%notfound) then
672: raise no_data_found;

Line 682: p_ref_entity => 'HR_TAB_PAGE_PROPERTIES_TL',

678:
679: BEGIN
680: PER_RIC_PKG.chk_integrity (
681: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
682: p_ref_entity => 'HR_TAB_PAGE_PROPERTIES_TL',
683: p_ref_column_name => 'TAB_PAGE_PROPERTY_ID',
684: p_ref_col_value_number => X_TAB_PAGE_PROPERTY_ID,
685: p_ref_col_value_varchar => NULL,
686: p_ref_col_value_date => NULL,

Line 704: delete from HR_TAB_PAGE_PROPERTIES_TL T

700:
701: procedure ADD_LANGUAGE
702: is
703: begin
704: delete from HR_TAB_PAGE_PROPERTIES_TL T
705: where not exists
706: (select NULL
707: from HR_TAB_PAGE_PROPERTIES_B B
708: where B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID

Line 711: update HR_TAB_PAGE_PROPERTIES_TL T set (

707: from HR_TAB_PAGE_PROPERTIES_B B
708: where B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID
709: );
710:
711: update HR_TAB_PAGE_PROPERTIES_TL T set (
712: LABEL
713: ) = (select
714: B.LABEL
715: from HR_TAB_PAGE_PROPERTIES_TL B

Line 715: from HR_TAB_PAGE_PROPERTIES_TL B

711: update HR_TAB_PAGE_PROPERTIES_TL T set (
712: LABEL
713: ) = (select
714: B.LABEL
715: from HR_TAB_PAGE_PROPERTIES_TL B
716: where B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID
717: and B.LANGUAGE = T.SOURCE_LANG)
718: where (
719: T.TAB_PAGE_PROPERTY_ID,

Line 724: from HR_TAB_PAGE_PROPERTIES_TL SUBB, HR_TAB_PAGE_PROPERTIES_TL SUBT

720: T.LANGUAGE
721: ) in (select
722: SUBT.TAB_PAGE_PROPERTY_ID,
723: SUBT.LANGUAGE
724: from HR_TAB_PAGE_PROPERTIES_TL SUBB, HR_TAB_PAGE_PROPERTIES_TL SUBT
725: where SUBB.TAB_PAGE_PROPERTY_ID = SUBT.TAB_PAGE_PROPERTY_ID
726: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
727: and (SUBB.LABEL <> SUBT.LABEL
728: or (SUBB.LABEL is null and SUBT.LABEL is not null)

Line 732: insert into HR_TAB_PAGE_PROPERTIES_TL (

728: or (SUBB.LABEL is null and SUBT.LABEL is not null)
729: or (SUBB.LABEL is not null and SUBT.LABEL is null)
730: ));
731:
732: insert into HR_TAB_PAGE_PROPERTIES_TL (
733: TAB_PAGE_PROPERTY_ID,
734: LABEL,
735: LAST_UPDATE_DATE,
736: LAST_UPDATED_BY,

Line 752: from HR_TAB_PAGE_PROPERTIES_TL B, FND_LANGUAGES L

748: B.CREATED_BY,
749: B.CREATION_DATE,
750: L.LANGUAGE_CODE,
751: B.SOURCE_LANG
752: from HR_TAB_PAGE_PROPERTIES_TL B, FND_LANGUAGES L
753: where L.INSTALLED_FLAG in ('I', 'B')
754: and B.LANGUAGE = userenv('LANG')
755: and not exists
756: (select NULL

Line 757: from HR_TAB_PAGE_PROPERTIES_TL T

753: where L.INSTALLED_FLAG in ('I', 'B')
754: and B.LANGUAGE = userenv('LANG')
755: and not exists
756: (select NULL
757: from HR_TAB_PAGE_PROPERTIES_TL T
758: where T.TAB_PAGE_PROPERTY_ID = B.TAB_PAGE_PROPERTY_ID
759: and T.LANGUAGE = L.LANGUAGE_CODE);
760: end ADD_LANGUAGE;
761:

Line 876: from HR_TAB_PAGE_PROPERTIES_TL

872: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
873:
874: select LAST_UPDATED_BY, LAST_UPDATE_DATE
875: into db_luby, db_ludate
876: from HR_TAB_PAGE_PROPERTIES_TL
877: where tab_page_property_id = x_tab_page_property_id
878: and LANGUAGE=userenv('LANG');
879:
880: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 883: update HR_TAB_PAGE_PROPERTIES_TL set

879:
880: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
881: db_ludate,X_CUSTOM_MODE)) then
882:
883: update HR_TAB_PAGE_PROPERTIES_TL set
884: LABEL = X_LABEL,
885: LAST_UPDATE_DATE = f_ludate,
886: LAST_UPDATED_BY = f_luby,
887: LAST_UPDATE_LOGIN = 0,

Line 1054: from HR_TAB_PAGE_PROPERTIES_TL

1050: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
1051:
1052: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1053: into db_luby, db_ludate
1054: from HR_TAB_PAGE_PROPERTIES_TL
1055: where tab_page_property_id = x_tab_page_property_id
1056: and LANGUAGE=userenv('LANG');
1057:
1058: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,