APPS.HR_QSA_DEL dependencies on HR_QSA_SHD

Line 51: Procedure delete_dml(p_rec in hr_qsa_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_qsa_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 70: hr_qsa_shd.constraint_error

66: --
67: Exception
68: When hr_api.child_integrity_violated then
69: -- Child integrity has been violated
70: hr_qsa_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_qsa_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_qsa_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_qsa_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_qsa_shd.g_rec_type) is
151: --
152: l_proc varchar2(72) := g_package||'post_delete';
153: --
154: Begin

Line 161: => hr_qsa_shd.g_old_rec.questionnaire_template_id

157: begin
158: hr_qsa_rkd.after_delete
159: (p_questionnaire_answer_id => p_rec.questionnaire_answer_id
160: ,p_questionnaire_template_id_o
161: => hr_qsa_shd.g_old_rec.questionnaire_template_id
162: ,p_type_o
163: => hr_qsa_shd.g_old_rec.type
164: ,p_type_object_id_o
165: => hr_qsa_shd.g_old_rec.type_object_id

Line 163: => hr_qsa_shd.g_old_rec.type

159: (p_questionnaire_answer_id => p_rec.questionnaire_answer_id
160: ,p_questionnaire_template_id_o
161: => hr_qsa_shd.g_old_rec.questionnaire_template_id
162: ,p_type_o
163: => hr_qsa_shd.g_old_rec.type
164: ,p_type_object_id_o
165: => hr_qsa_shd.g_old_rec.type_object_id
166: ,p_business_group_id_o
167: => hr_qsa_shd.g_old_rec.business_group_id

Line 165: => hr_qsa_shd.g_old_rec.type_object_id

161: => hr_qsa_shd.g_old_rec.questionnaire_template_id
162: ,p_type_o
163: => hr_qsa_shd.g_old_rec.type
164: ,p_type_object_id_o
165: => hr_qsa_shd.g_old_rec.type_object_id
166: ,p_business_group_id_o
167: => hr_qsa_shd.g_old_rec.business_group_id
168: );
169: exception

Line 167: => hr_qsa_shd.g_old_rec.business_group_id

163: => hr_qsa_shd.g_old_rec.type
164: ,p_type_object_id_o
165: => hr_qsa_shd.g_old_rec.type_object_id
166: ,p_business_group_id_o
167: => hr_qsa_shd.g_old_rec.business_group_id
168: );
169: exception
170: when hr_api.cannot_find_prog_unit then
171: hr_api.cannot_find_prog_unit_error

Line 185: p_rec in hr_qsa_shd.g_rec_type

181: -- |---------------------------------< del >----------------------------------|
182: -- ----------------------------------------------------------------------------
183: Procedure del
184: (
185: p_rec in hr_qsa_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'del';
189: --

Line 195: hr_qsa_shd.lck

191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: -- We must lock the row which we need to delete.
194: --
195: hr_qsa_shd.lck
196: (
197: p_rec.questionnaire_answer_id
198: );
199: --

Line 225: l_rec hr_qsa_shd.g_rec_type;

221: (
222: p_questionnaire_answer_id in number
223: ) is
224: --
225: l_rec hr_qsa_shd.g_rec_type;
226: l_proc varchar2(72) := g_package||'del';
227: --
228: Begin
229: hr_utility.set_location('Entering:'||l_proc, 5);