DBA Data[Home] [Help]

APPS.HR_QSN_DEL dependencies on HR_QSN_SHD

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

Line 68: hr_qsn_shd.constraint_error

64:
65: Exception
66: When hr_api.child_integrity_violated then
67: --Child integrity has been violated
68: hr_qsn_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_qsn_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_qsn_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_qsn_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_qsn_shd.g_rec_type) is
149:
150: l_proc varchar2(72) := g_package||'post_delete';
151:
152: Begin

Line 162: (p_rec in hr_qsn_shd.g_rec_type) is

158: -- ----------------------------------------------------------------------------
159: -- |---------------------------------< del >----------------------------------|
160: -- ----------------------------------------------------------------------------
161: Procedure del
162: (p_rec in hr_qsn_shd.g_rec_type) is
163:
164: l_proc varchar2(72) := g_package||'del';
165:
166: Begin

Line 171: hr_qsn_shd.lck

167: hr_utility.set_location('Entering:'||l_proc, 5);
168:
169: --We must lock the row which we need to delete.
170:
171: hr_qsn_shd.lck
172: (
173: p_rec.questionnaire_template_id,
174: p_rec.object_version_number
175: );

Line 209: l_rec hr_qsn_shd.g_rec_type;

205: p_questionnaire_template_id in number,
206: p_object_version_number in number
207: ) is
208:
209: l_rec hr_qsn_shd.g_rec_type;
210: l_proc varchar2(72) := g_package||'del';
211:
212: Begin
213: hr_utility.set_location('Entering:'||l_proc, 5);