APPS.HR_TEMPLATE_ITEM_CONTEXTS_PKG dependencies on HR_TEMPLATE_ITEM_CONTEXTS_B_S

Line 137: update HR_TEMPLATE_ITEM_CONTEXTS_B set

133: X_LAST_UPDATED_BY in NUMBER,
134: X_LAST_UPDATE_LOGIN in NUMBER
135: ) is
136: begin
137: update HR_TEMPLATE_ITEM_CONTEXTS_B set
138: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
139: TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID,
140: CONTEXT_TYPE = X_CONTEXT_TYPE,
141: ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID,

Line 330: select hr_template_item_contexts_b_s.nextval

326: where ticb.template_item_id = x_template_item_id
327: and ticb.item_context_id = x_item_context_id;
328: exception
329: when no_data_found then
330: select hr_template_item_contexts_b_s.nextval
331: into x_template_item_context_id
332: from dual;
333: end;
334: