APPS.PER_STC_DEL dependencies on PER_STC_SHD

Line 52: (p_rec in per_stc_shd.g_rec_type

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

Line 93: per_stc_shd.constraint_error

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

Line 132: Procedure pre_delete(p_rec in per_stc_shd.g_rec_type) is

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

Line 174: Procedure post_delete(p_rec in per_stc_shd.g_rec_type) is

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

Line 190: => per_stc_shd.g_old_rec.api_name

186: => p_rec.solution_type_name
187: ,p_legislation_code
188: => p_rec.legislation_code
189: ,p_api_name_o
190: => per_stc_shd.g_old_rec.api_name
191: ,p_parent_component_name_o
192: => per_stc_shd.g_old_rec.parent_component_name
193: ,p_updateable_o
194: => per_stc_shd.g_old_rec.updateable

Line 192: => per_stc_shd.g_old_rec.parent_component_name

188: => p_rec.legislation_code
189: ,p_api_name_o
190: => per_stc_shd.g_old_rec.api_name
191: ,p_parent_component_name_o
192: => per_stc_shd.g_old_rec.parent_component_name
193: ,p_updateable_o
194: => per_stc_shd.g_old_rec.updateable
195: ,p_extensible_o
196: => per_stc_shd.g_old_rec.extensible

Line 194: => per_stc_shd.g_old_rec.updateable

190: => per_stc_shd.g_old_rec.api_name
191: ,p_parent_component_name_o
192: => per_stc_shd.g_old_rec.parent_component_name
193: ,p_updateable_o
194: => per_stc_shd.g_old_rec.updateable
195: ,p_extensible_o
196: => per_stc_shd.g_old_rec.extensible
197: ,p_object_version_number_o
198: => per_stc_shd.g_old_rec.object_version_number

Line 196: => per_stc_shd.g_old_rec.extensible

192: => per_stc_shd.g_old_rec.parent_component_name
193: ,p_updateable_o
194: => per_stc_shd.g_old_rec.updateable
195: ,p_extensible_o
196: => per_stc_shd.g_old_rec.extensible
197: ,p_object_version_number_o
198: => per_stc_shd.g_old_rec.object_version_number
199: );
200: --

Line 198: => per_stc_shd.g_old_rec.object_version_number

194: => per_stc_shd.g_old_rec.updateable
195: ,p_extensible_o
196: => per_stc_shd.g_old_rec.extensible
197: ,p_object_version_number_o
198: => per_stc_shd.g_old_rec.object_version_number
199: );
200: --
201: exception
202: --

Line 218: (p_rec in per_stc_shd.g_rec_type

214: -- ----------------------------------------------------------------------------
215: -- |---------------------------------< del >----------------------------------|
216: -- ----------------------------------------------------------------------------
217: Procedure del
218: (p_rec in per_stc_shd.g_rec_type
219: ) is
220: --
221: l_proc varchar2(72) := g_package||'del';
222: --

Line 228: per_stc_shd.lck

224: hr_utility.set_location('Entering:'||l_proc, 5);
225: --
226: -- We must lock the row which we need to delete.
227: --
228: per_stc_shd.lck
229: (p_rec.component_name
230: ,p_rec.solution_type_name
231: ,p_rec.legislation_code
232: ,p_rec.object_version_number

Line 269: l_rec per_stc_shd.g_rec_type;

265: ,p_legislation_code in varchar2
266: ,p_object_version_number in number
267: ) is
268: --
269: l_rec per_stc_shd.g_rec_type;
270: l_proc varchar2(72) := g_package||'del';
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);