APPS.HR_QSF_DEL dependencies on HR_QSF_SHD

Line 51: Procedure delete_dml(p_rec in hr_qsf_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in hr_qsf_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 70: hr_qsf_shd.constraint_error

66:
67: Exception
68: When hr_api.child_integrity_violated then
69: -- Child integrity has been violated
70: hr_qsf_shd.constraint_error
71: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
72: When Others Then
73: Raise;
74: End delete_dml;

Line 108: Procedure pre_delete(p_rec in hr_qsf_shd.g_rec_type) is

104: -- Internal Row Handler Use Only.
105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure pre_delete(p_rec in hr_qsf_shd.g_rec_type) is
109:
110: l_proc varchar2(72) := g_package||'pre_delete';
111:
112: Begin

Line 150: Procedure post_delete(p_rec in hr_qsf_shd.g_rec_type) is

146: -- Internal table Handler Use Only.
147: --
148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: Procedure post_delete(p_rec in hr_qsf_shd.g_rec_type) is
151: --
152: l_proc varchar2(72) := g_package||'post_delete';
153: --
154: Begin

Line 160: => hr_qsf_shd.g_old_rec.questionnaire_template_id

156: hr_qsf_rkd.after_delete
157: (p_field_id
158: => p_rec.field_id
159: ,p_questionnaire_template_id_o
160: => hr_qsf_shd.g_old_rec.questionnaire_template_id
161: ,p_name_o
162: => hr_qsf_shd.g_old_rec.name
163: ,p_type_o
164: => hr_qsf_shd.g_old_rec.type

Line 162: => hr_qsf_shd.g_old_rec.name

158: => p_rec.field_id
159: ,p_questionnaire_template_id_o
160: => hr_qsf_shd.g_old_rec.questionnaire_template_id
161: ,p_name_o
162: => hr_qsf_shd.g_old_rec.name
163: ,p_type_o
164: => hr_qsf_shd.g_old_rec.type
165: ,p_html_text_o
166: => hr_qsf_shd.g_old_rec.html_text

Line 164: => hr_qsf_shd.g_old_rec.type

160: => hr_qsf_shd.g_old_rec.questionnaire_template_id
161: ,p_name_o
162: => hr_qsf_shd.g_old_rec.name
163: ,p_type_o
164: => hr_qsf_shd.g_old_rec.type
165: ,p_html_text_o
166: => hr_qsf_shd.g_old_rec.html_text
167: ,p_sql_required_flag_o
168: => hr_qsf_shd.g_old_rec.sql_required_flag

Line 166: => hr_qsf_shd.g_old_rec.html_text

162: => hr_qsf_shd.g_old_rec.name
163: ,p_type_o
164: => hr_qsf_shd.g_old_rec.type
165: ,p_html_text_o
166: => hr_qsf_shd.g_old_rec.html_text
167: ,p_sql_required_flag_o
168: => hr_qsf_shd.g_old_rec.sql_required_flag
169: ,p_sql_text_o
170: => hr_qsf_shd.g_old_rec.sql_text

Line 168: => hr_qsf_shd.g_old_rec.sql_required_flag

164: => hr_qsf_shd.g_old_rec.type
165: ,p_html_text_o
166: => hr_qsf_shd.g_old_rec.html_text
167: ,p_sql_required_flag_o
168: => hr_qsf_shd.g_old_rec.sql_required_flag
169: ,p_sql_text_o
170: => hr_qsf_shd.g_old_rec.sql_text
171: ,p_object_version_number_o
172: => hr_qsf_shd.g_old_rec.object_version_number

Line 170: => hr_qsf_shd.g_old_rec.sql_text

166: => hr_qsf_shd.g_old_rec.html_text
167: ,p_sql_required_flag_o
168: => hr_qsf_shd.g_old_rec.sql_required_flag
169: ,p_sql_text_o
170: => hr_qsf_shd.g_old_rec.sql_text
171: ,p_object_version_number_o
172: => hr_qsf_shd.g_old_rec.object_version_number
173: );
174: --

Line 172: => hr_qsf_shd.g_old_rec.object_version_number

168: => hr_qsf_shd.g_old_rec.sql_required_flag
169: ,p_sql_text_o
170: => hr_qsf_shd.g_old_rec.sql_text
171: ,p_object_version_number_o
172: => hr_qsf_shd.g_old_rec.object_version_number
173: );
174: --
175: exception
176: --

Line 192: p_rec in hr_qsf_shd.g_rec_type

188: -- |---------------------------------< del >----------------------------------|
189: -- ----------------------------------------------------------------------------
190: Procedure del
191: (
192: p_rec in hr_qsf_shd.g_rec_type
193: ) is
194:
195: l_proc varchar2(72) := g_package||'del';
196: --

Line 202: hr_qsf_shd.lck

198: hr_utility.set_location('Entering:'||l_proc, 5);
199:
200: -- We must lock the row which we need to delete.
201: --
202: hr_qsf_shd.lck
203: (
204: p_rec.field_id,
205: p_rec.object_version_number
206: );

Line 236: l_rec hr_qsf_shd.g_rec_type;

232: p_field_id in number,
233: p_object_version_number in number
234: ) is
235: --
236: l_rec hr_qsf_shd.g_rec_type;
237: l_proc varchar2(72) := g_package||'del';
238: --
239: Begin
240: hr_utility.set_location('Entering:'||l_proc, 5);