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: insert into HR_TAB_PAGE_PROPERTIES_B (

Line 208: insert into HR_TAB_PAGE_PROPERTIES_B (

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: insert into HR_TAB_PAGE_PROPERTIES_B (
209: TAB_PAGE_PROPERTY_ID,
210: FORM_TAB_PAGE_ID,
211: TEMPLATE_TAB_PAGE_ID,
212: NAVIGATION_DIRECTION,

Line 407: from HR_TAB_PAGE_PROPERTIES_B

403: INFORMATION25,
404: INFORMATION26,
405: INFORMATION27,
406: INFORMATION28
407: from HR_TAB_PAGE_PROPERTIES_B
408: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
409: for update of TAB_PAGE_PROPERTY_ID nowait;
410: recinfo c%rowtype;
411:

Line 563: update HR_TAB_PAGE_PROPERTIES_B set

559: X_LAST_UPDATED_BY in NUMBER,
560: X_LAST_UPDATE_LOGIN in NUMBER
561: ) is
562: begin
563: update HR_TAB_PAGE_PROPERTIES_B set
564: FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID,
565: TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
566: NAVIGATION_DIRECTION = X_NAVIGATION_DIRECTION,
567: VISIBLE = X_VISIBLE,

Line 633: delete from HR_TAB_PAGE_PROPERTIES_B

629: if (sql%notfound) then
630: raise no_data_found;
631: end if;
632:
633: delete from HR_TAB_PAGE_PROPERTIES_B
634: where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
635:
636: if (sql%notfound) then
637: raise no_data_found;

Line 647: from HR_TAB_PAGE_PROPERTIES_B B

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
649: );
650:
651: update HR_TAB_PAGE_PROPERTIES_TL T set (

Line 804: from hr_tab_page_properties_b

800:
801: begin
802: select tab_page_property_id
803: into x_tab_page_property_id
804: from hr_tab_page_properties_b
805: where nvl(form_tab_page_id,hr_api.g_number) = nvl(x_form_tab_page_id,hr_api.g_number)
806: and nvl(template_tab_page_id,hr_api.g_number) = nvl(x_template_tab_page_id,hr_api.g_number);
807: end;
808:

Line 976: from hr_tab_page_properties_b

972:
973: begin
974: select tab_page_property_id
975: into x_tab_page_property_id
976: from hr_tab_page_properties_b
977: where nvl(form_tab_page_id,hr_api.g_number) = nvl(x_form_tab_page_id,hr_api.g_number)
978: and nvl(template_tab_page_id,hr_api.g_number) = nvl(x_template_tab_page_id,hr_api.g_number);
979: exception
980: when no_data_found then

Line 981: select hr_tab_page_properties_b_s.nextval

977: where nvl(form_tab_page_id,hr_api.g_number) = nvl(x_form_tab_page_id,hr_api.g_number)
978: and nvl(template_tab_page_id,hr_api.g_number) = nvl(x_template_tab_page_id,hr_api.g_number);
979: exception
980: when no_data_found then
981: select hr_tab_page_properties_b_s.nextval
982: into x_tab_page_property_id
983: from dual;
984: end;
985: