APPS.HR_TEMPLATE_ITEM_CONTEXTS_PKG dependencies on HR_TEMPLATE_ITEM_CONTEXTS_B_S

Line 115: update HR_TEMPLATE_ITEM_CONTEXTS_B set

111: X_LAST_UPDATED_BY in NUMBER,
112: X_LAST_UPDATE_LOGIN in NUMBER
113: ) is
114: begin
115: update HR_TEMPLATE_ITEM_CONTEXTS_B set
116: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
117: TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID,
118: CONTEXT_TYPE = X_CONTEXT_TYPE,
119: ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID,

Line 287: select hr_template_item_contexts_b_s.nextval

283: where ticb.template_item_id = x_template_item_id
284: and ticb.item_context_id = x_item_context_id;
285: exception
286: when no_data_found then
287: select hr_template_item_contexts_b_s.nextval
288: into x_template_item_context_id
289: from dual;
290: end;
291: