APPS.HR_SOURCE_FORM_TEMPLATES_PKG dependencies on HR_SOURCE_FORM_TEMPLATES_S

Line 123: update HR_SOURCE_FORM_TEMPLATES set

119: X_LAST_UPDATED_BY in NUMBER,
120: X_LAST_UPDATE_LOGIN in NUMBER
121: ) is
122: begin
123: update HR_SOURCE_FORM_TEMPLATES set
124: FORM_TEMPLATE_ID_FROM = X_FORM_TEMPLATE_ID_FROM,
125: FORM_TEMPLATE_ID_TO = X_FORM_TEMPLATE_ID_TO,
126: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
127: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 240: select hr_source_form_templates_s.nextval

236: and nvl(form_template_id_from,hr_api.g_number) = nvl(x_form_template_id_from,hr_api.g_number);
237:
238: exception
239: when no_data_found then
240: select hr_source_form_templates_s.nextval
241: into x_source_form_template_id
242: from dual;
243: end;
244: