DBA Data[Home] [Help]

APPS.HR_TAB_PAGE_PROPERTIES_PKG dependencies on HR_TAB_PAGE_PROPERTIES_B_S

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