APPS.HR_SOURCE_FORM_TEMPLATES_PKG dependencies on HR_SOURCE_FORM_TEMPLATES_S

Line 102: update HR_SOURCE_FORM_TEMPLATES set

98: X_LAST_UPDATED_BY in NUMBER,
99: X_LAST_UPDATE_LOGIN in NUMBER
100: ) is
101: begin
102: update HR_SOURCE_FORM_TEMPLATES set
103: FORM_TEMPLATE_ID_FROM = X_FORM_TEMPLATE_ID_FROM,
104: FORM_TEMPLATE_ID_TO = X_FORM_TEMPLATE_ID_TO,
105: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
106: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 219: select hr_source_form_templates_s.nextval

215: and nvl(form_template_id_from,hr_api.g_number) = nvl(x_form_template_id_from,hr_api.g_number);
216:
217: exception
218: when no_data_found then
219: select hr_source_form_templates_s.nextval
220: into x_source_form_template_id
221: from dual;
222: end;
223: