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_B

Line 55: from HR_TAB_PAGE_PROPERTIES_B tpp

51: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
52: l_original csr_original%rowtype;
53: cursor csr_copies is
54: select tpp.tab_page_property_id
55: from HR_TAB_PAGE_PROPERTIES_B tpp
56: ,HR_TEMPLATE_TAB_PAGES_B ttp
57: ,HR_TEMPLATE_CANVASES_B tcn
58: ,HR_TEMPLATE_WINDOWS_B twn
59: ,HR_TEMPLATE_TAB_PAGES_B tto

Line 80: update HR_TAB_PAGE_PROPERTIES_B set

76: fetch csr_original into l_original;
77: if csr_original%found then
78: close csr_original;
79: for l_copy in csr_copies loop
80: update HR_TAB_PAGE_PROPERTIES_B set
81: NAVIGATION_DIRECTION = decode(nvl(NAVIGATION_DIRECTION,hr_api.g_varchar2),nvl(l_original.NAVIGATION_DIRECTION,hr_api.g_varchar2),X_NAVIGATION_DIRECTION,NAVIGATION_DIRECTION),
82: VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
83: INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
84: INFORMATION1 = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),

Line 204: cursor C is select ROWID from HR_TAB_PAGE_PROPERTIES_B

200: X_LAST_UPDATE_DATE in DATE,
201: X_LAST_UPDATED_BY in NUMBER,
202: X_LAST_UPDATE_LOGIN in NUMBER
203: ) is
204: cursor C is select ROWID from HR_TAB_PAGE_PROPERTIES_B
205: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
206: ;
207: begin
208:

Line 216: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',

212: --
213:
214: BEGIN
215: PER_RIC_PKG.chk_integrity (
216: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',
217: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
218: PER_RIC_PKG.ref_info_rec('HR_FORM_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(
219: PER_RIC_PKG.col_info_rec('FORM_TAB_PAGE_ID',NULL,X_FORM_TAB_PAGE_ID,NULL))),
220: PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_TAB_PAGES_B', PER_RIC_PKG.column_info_tbl(

Line 230: insert into HR_TAB_PAGE_PROPERTIES_B (

226: --
227: -- Code Ends Here.
228: --
229:
230: insert into HR_TAB_PAGE_PROPERTIES_B (
231: TAB_PAGE_PROPERTY_ID,
232: FORM_TAB_PAGE_ID,
233: TEMPLATE_TAB_PAGE_ID,
234: NAVIGATION_DIRECTION,

Line 324: p_ref_entity => 'HR_TAB_PAGE_PROPERTIES_B',

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,
328: p_ref_col_value_date => NULL,

Line 449: from HR_TAB_PAGE_PROPERTIES_B

445: INFORMATION25,
446: INFORMATION26,
447: INFORMATION27,
448: INFORMATION28
449: from HR_TAB_PAGE_PROPERTIES_B
450: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
451: for update of TAB_PAGE_PROPERTY_ID nowait;
452: recinfo c%rowtype;
453:

Line 605: update HR_TAB_PAGE_PROPERTIES_B set

601: X_LAST_UPDATED_BY in NUMBER,
602: X_LAST_UPDATE_LOGIN in NUMBER
603: ) is
604: begin
605: update HR_TAB_PAGE_PROPERTIES_B set
606: FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID,
607: TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
608: NAVIGATION_DIRECTION = X_NAVIGATION_DIRECTION,
609: VISIBLE = X_VISIBLE,

Line 681: p_entity_name => 'HR_TAB_PAGE_PROPERTIES_B',

677: --
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,

Line 693: delete from HR_TAB_PAGE_PROPERTIES_B

689: END;
690: --
691: -- Code Ends Here.
692: --
693: delete from HR_TAB_PAGE_PROPERTIES_B
694: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
695:
696: if (sql%notfound) then
697: raise no_data_found;

Line 707: from HR_TAB_PAGE_PROPERTIES_B B

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
709: );
710:
711: update HR_TAB_PAGE_PROPERTIES_TL T set (

Line 864: from hr_tab_page_properties_b

860:
861: begin
862: select tab_page_property_id
863: into x_tab_page_property_id
864: from hr_tab_page_properties_b
865: where nvl(form_tab_page_id,hr_api.g_number) = nvl(x_form_tab_page_id,hr_api.g_number)
866: and nvl(template_tab_page_id,hr_api.g_number) = nvl(x_template_tab_page_id,hr_api.g_number);
867: end;
868:

Line 1036: from hr_tab_page_properties_b

1032:
1033: begin
1034: select tab_page_property_id
1035: into x_tab_page_property_id
1036: from hr_tab_page_properties_b
1037: where nvl(form_tab_page_id,hr_api.g_number) = nvl(x_form_tab_page_id,hr_api.g_number)
1038: and nvl(template_tab_page_id,hr_api.g_number) = nvl(x_template_tab_page_id,hr_api.g_number);
1039: exception
1040: when no_data_found then

Line 1041: select hr_tab_page_properties_b_s.nextval

1037: where nvl(form_tab_page_id,hr_api.g_number) = nvl(x_form_tab_page_id,hr_api.g_number)
1038: and nvl(template_tab_page_id,hr_api.g_number) = nvl(x_template_tab_page_id,hr_api.g_number);
1039: exception
1040: when no_data_found then
1041: select hr_tab_page_properties_b_s.nextval
1042: into x_tab_page_property_id
1043: from dual;
1044: end;
1045: