DBA Data[Home] [Help]

APPS.PER_SLT_DEL dependencies on PER_SLT_SHD

Line 52: (p_rec in per_slt_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in per_slt_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 91: per_slt_shd.constraint_error

87: Exception
88: When hr_api.child_integrity_violated then
89: -- Child integrity has been violated
90: --
91: per_slt_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: --
95: Raise;

Line 130: Procedure pre_delete(p_rec in per_slt_shd.g_rec_type) is

126: -- Internal Row Handler Use Only.
127: --
128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130: Procedure pre_delete(p_rec in per_slt_shd.g_rec_type) is
131: --
132: l_proc varchar2(72) := g_package||'pre_delete';
133: --
134: Begin

Line 172: Procedure post_delete(p_rec in per_slt_shd.g_rec_type) is

168: -- Internal Row Handler Use Only.
169: --
170: -- {End Of Comments}
171: -- -----------------------------------------------------------------------------
172: Procedure post_delete(p_rec in per_slt_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'post_delete';
175: --
176: Begin

Line 184: => per_slt_shd.g_old_rec.solution_category

180: per_slt_rkd.after_delete
181: (p_solution_type_name
182: => p_rec.solution_type_name
183: ,p_solution_category_o
184: => per_slt_shd.g_old_rec.solution_category
185: ,p_updateable_o
186: => per_slt_shd.g_old_rec.updateable
187: ,p_object_version_number_o
188: => per_slt_shd.g_old_rec.object_version_number

Line 186: => per_slt_shd.g_old_rec.updateable

182: => p_rec.solution_type_name
183: ,p_solution_category_o
184: => per_slt_shd.g_old_rec.solution_category
185: ,p_updateable_o
186: => per_slt_shd.g_old_rec.updateable
187: ,p_object_version_number_o
188: => per_slt_shd.g_old_rec.object_version_number
189: );
190: --

Line 188: => per_slt_shd.g_old_rec.object_version_number

184: => per_slt_shd.g_old_rec.solution_category
185: ,p_updateable_o
186: => per_slt_shd.g_old_rec.updateable
187: ,p_object_version_number_o
188: => per_slt_shd.g_old_rec.object_version_number
189: );
190: --
191: exception
192: --

Line 208: (p_rec in per_slt_shd.g_rec_type

204: -- ----------------------------------------------------------------------------
205: -- |---------------------------------< del >----------------------------------|
206: -- ----------------------------------------------------------------------------
207: Procedure del
208: (p_rec in per_slt_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'del';
212: --

Line 218: per_slt_shd.lck

214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: -- We must lock the row which we need to delete.
217: --
218: per_slt_shd.lck
219: (p_rec.solution_type_name
220: ,p_rec.object_version_number
221: );
222: --

Line 255: l_rec per_slt_shd.g_rec_type;

251: (p_solution_type_name in varchar2
252: ,p_object_version_number in number
253: ) is
254: --
255: l_rec per_slt_shd.g_rec_type;
256: l_proc varchar2(72) := g_package||'del';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);