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