APPS.HR_SOURCE_FORM_TEMPLATES_PKG dependencies on HR_SOURCE_FORM_TEMPLATES

Line 1: package body HR_SOURCE_FORM_TEMPLATES_PKG as

1: package body HR_SOURCE_FORM_TEMPLATES_PKG as
2: /* $Header: hrsftlct.pkb 115.3 2002/12/11 06:50:42 raranjan noship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATION_DATE out nocopy DATE,

Line 34: cursor C is select ROWID from HR_SOURCE_FORM_TEMPLATES

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from HR_SOURCE_FORM_TEMPLATES
35: where SOURCE_FORM_TEMPLATE_ID = X_SOURCE_FORM_TEMPLATE_ID
36: ;
37: begin
38: insert into HR_SOURCE_FORM_TEMPLATES (

Line 38: insert into HR_SOURCE_FORM_TEMPLATES (

34: cursor C is select ROWID from HR_SOURCE_FORM_TEMPLATES
35: where SOURCE_FORM_TEMPLATE_ID = X_SOURCE_FORM_TEMPLATE_ID
36: ;
37: begin
38: insert into HR_SOURCE_FORM_TEMPLATES (
39: FORM_TEMPLATE_ID_FROM,
40: LAST_UPDATE_DATE,
41: LAST_UPDATED_BY,
42: LAST_UPDATE_LOGIN,

Line 75: from HR_SOURCE_FORM_TEMPLATES

71: ) is
72: cursor c1 is select
73: FORM_TEMPLATE_ID_FROM,
74: FORM_TEMPLATE_ID_TO
75: from HR_SOURCE_FORM_TEMPLATES
76: where SOURCE_FORM_TEMPLATE_ID = X_SOURCE_FORM_TEMPLATE_ID
77: for update of SOURCE_FORM_TEMPLATE_ID nowait;
78: begin
79: for tlinfo in c1 loop

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 119: delete from HR_SOURCE_FORM_TEMPLATES

115: procedure DELETE_ROW (
116: X_SOURCE_FORM_TEMPLATE_ID in NUMBER
117: ) is
118: begin
119: delete from HR_SOURCE_FORM_TEMPLATES
120: where SOURCE_FORM_TEMPLATE_ID = X_SOURCE_FORM_TEMPLATE_ID;
121:
122: if (sql%notfound) then
123: raise no_data_found;

Line 213: from hr_source_form_templates

209: begin
210:
211: select source_form_template_id
212: into x_source_form_template_id
213: from hr_source_form_templates
214: where form_template_id_to = x_form_template_id_to
215: and nvl(form_template_id_from,hr_api.g_number) = nvl(x_form_template_id_from,hr_api.g_number);
216:
217: exception

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:

Line 249: end HR_SOURCE_FORM_TEMPLATES_PKG;

245: X_LAST_UPDATE_LOGIN);
246: end;
247:
248: end LOAD_ROW;
249: end HR_SOURCE_FORM_TEMPLATES_PKG;