DBA Data[Home] [Help]

APPS.HR_TEMPLATE_ITEM_TAB_PAGES_PKG dependencies on HR_TEMPLATE_ITEM_TAB_PAGES_S

Line 130: update HR_TEMPLATE_ITEM_TAB_PAGES set

126: X_LAST_UPDATED_BY in NUMBER,
127: X_LAST_UPDATE_LOGIN in NUMBER
128: ) is
129: begin
130: update HR_TEMPLATE_ITEM_TAB_PAGES set
131: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
132: TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID,
133: TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
134: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 277: select hr_template_item_tab_pages_s.nextval

273: where template_tab_page_id = x_template_tab_page_id
274: and template_item_id = x_template_item_id;
275: exception
276: when no_data_found then
277: select hr_template_item_tab_pages_s.nextval
278: into x_template_item_tab_page_id
279: from dual;
280: end;
281: