APPS.HR_QSV_DEL dependencies on HR_QSV_SHD

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

Line 68: hr_qsv_shd.constraint_error

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

Line 106: Procedure pre_delete(p_rec in hr_qsv_shd.g_rec_type) is

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

Line 148: Procedure post_delete(p_rec in hr_qsv_shd.g_rec_type) is

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

Line 159: => hr_qsv_shd.g_old_rec.questionnaire_answer_id

155: begin
156: hr_qsv_rkd.after_delete
157: (p_quest_answer_val_id => p_rec.quest_answer_val_id
158: ,p_questionnaire_answer_id_o
159: => hr_qsv_shd.g_old_rec.questionnaire_answer_id
160: ,p_field_id_o
161: => hr_qsv_shd.g_old_rec.field_id
162: ,p_object_version_number_o
163: => hr_qsv_shd.g_old_rec.object_version_number

Line 161: => hr_qsv_shd.g_old_rec.field_id

157: (p_quest_answer_val_id => p_rec.quest_answer_val_id
158: ,p_questionnaire_answer_id_o
159: => hr_qsv_shd.g_old_rec.questionnaire_answer_id
160: ,p_field_id_o
161: => hr_qsv_shd.g_old_rec.field_id
162: ,p_object_version_number_o
163: => hr_qsv_shd.g_old_rec.object_version_number
164: ,p_value_o
165: => hr_qsv_shd.g_old_rec.value

Line 163: => hr_qsv_shd.g_old_rec.object_version_number

159: => hr_qsv_shd.g_old_rec.questionnaire_answer_id
160: ,p_field_id_o
161: => hr_qsv_shd.g_old_rec.field_id
162: ,p_object_version_number_o
163: => hr_qsv_shd.g_old_rec.object_version_number
164: ,p_value_o
165: => hr_qsv_shd.g_old_rec.value
166: );
167: exception

Line 165: => hr_qsv_shd.g_old_rec.value

161: => hr_qsv_shd.g_old_rec.field_id
162: ,p_object_version_number_o
163: => hr_qsv_shd.g_old_rec.object_version_number
164: ,p_value_o
165: => hr_qsv_shd.g_old_rec.value
166: );
167: exception
168: when hr_api.cannot_find_prog_unit then
169: hr_api.cannot_find_prog_unit_error

Line 183: p_rec in hr_qsv_shd.g_rec_type

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

Line 193: hr_qsv_shd.lck

189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: -- We must lock the row which we need to delete.
192: --
193: hr_qsv_shd.lck
194: (
195: p_rec.quest_answer_val_id,
196: p_rec.object_version_number
197: );

Line 225: l_rec hr_qsv_shd.g_rec_type;

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