APPS.PER_STT_DEL dependencies on PER_STT_SHD

Line 48: Procedure delete_dml(p_rec in per_stt_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure delete_dml(p_rec in per_stt_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'delete_dml';
51: --
52: Begin

Line 68: per_stt_shd.constraint_error

64: --
65: Exception
66: When hr_api.child_integrity_violated then
67: -- Child integrity has been violated
68: per_stt_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 per_stt_shd.g_rec_type) is

102: -- Internal Row Handler Use Only.
103: --
104: -- {End Of Comments}
105: -- ----------------------------------------------------------------------------
106: Procedure pre_delete(p_rec in per_stt_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 per_stt_shd.g_rec_type) is

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

Line 163: ,p_language_o =>per_stt_shd.g_old_rec.language

159: --
160: per_stt_rkd.after_delete
161: (
162: p_shared_type_id =>p_rec.shared_type_id
163: ,p_language_o =>per_stt_shd.g_old_rec.language
164: ,p_source_lang_o =>per_stt_shd.g_old_rec.source_lang
165: ,p_shared_type_name_o =>per_stt_shd.g_old_rec.shared_type_name
166: );
167: --

Line 164: ,p_source_lang_o =>per_stt_shd.g_old_rec.source_lang

160: per_stt_rkd.after_delete
161: (
162: p_shared_type_id =>p_rec.shared_type_id
163: ,p_language_o =>per_stt_shd.g_old_rec.language
164: ,p_source_lang_o =>per_stt_shd.g_old_rec.source_lang
165: ,p_shared_type_name_o =>per_stt_shd.g_old_rec.shared_type_name
166: );
167: --
168: exception

Line 165: ,p_shared_type_name_o =>per_stt_shd.g_old_rec.shared_type_name

161: (
162: p_shared_type_id =>p_rec.shared_type_id
163: ,p_language_o =>per_stt_shd.g_old_rec.language
164: ,p_source_lang_o =>per_stt_shd.g_old_rec.source_lang
165: ,p_shared_type_name_o =>per_stt_shd.g_old_rec.shared_type_name
166: );
167: --
168: exception
169: --

Line 189: p_rec in per_stt_shd.g_rec_type

185: -- |---------------------------------< del >----------------------------------|
186: -- ----------------------------------------------------------------------------
187: Procedure del
188: (
189: p_rec in per_stt_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'del';
193: --

Line 199: per_stt_shd.lck

195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: -- We must lock the row which we need to delete.
198: --
199: per_stt_shd.lck
200: (
201: p_rec.shared_type_id,
202: p_rec.language
203: );

Line 231: l_rec per_stt_shd.g_rec_type;

227: p_shared_type_id in number,
228: p_language in varchar2
229: ) is
230: --
231: l_rec per_stt_shd.g_rec_type;
232: l_proc varchar2(72) := g_package||'del';
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);