APPS.OTA_FTU_DEL dependencies on OTA_FTU_SHD

Line 52: (p_rec in ota_ftu_shd.g_rec_type

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

Line 78: ota_ftu_shd.constraint_error

74: Exception
75: When hr_api.child_integrity_violated then
76: -- Child integrity has been violated
77: --
78: ota_ftu_shd.constraint_error
79: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
80: When Others Then
81: --
82: Raise;

Line 117: Procedure pre_delete(p_rec in ota_ftu_shd.g_rec_type) is

113: -- Internal Row Handler Use Only.
114: --
115: -- {End Of Comments}
116: -- ----------------------------------------------------------------------------
117: Procedure pre_delete(p_rec in ota_ftu_shd.g_rec_type) is
118: --
119: l_proc varchar2(72) := g_package||'pre_delete';
120: --
121: Begin

Line 159: Procedure post_delete(p_rec in ota_ftu_shd.g_rec_type) is

155: -- Internal Row Handler Use Only.
156: --
157: -- {End Of Comments}
158: -- -----------------------------------------------------------------------------
159: Procedure post_delete(p_rec in ota_ftu_shd.g_rec_type) is
160: --
161: l_proc varchar2(72) := g_package||'post_delete';
162: --
163: Begin

Line 177: => ota_ftu_shd.g_old_rec.business_group_id

173: => p_rec.person_id
174: ,p_contact_id
175: => p_rec.contact_id
176: ,p_business_group_id_o
177: => ota_ftu_shd.g_old_rec.business_group_id
178: ,p_author_person_id_o
179: => ota_ftu_shd.g_old_rec.author_person_id
180: ,p_author_contact_id_o
181: => ota_ftu_shd.g_old_rec.author_contact_id

Line 179: => ota_ftu_shd.g_old_rec.author_person_id

175: => p_rec.contact_id
176: ,p_business_group_id_o
177: => ota_ftu_shd.g_old_rec.business_group_id
178: ,p_author_person_id_o
179: => ota_ftu_shd.g_old_rec.author_person_id
180: ,p_author_contact_id_o
181: => ota_ftu_shd.g_old_rec.author_contact_id
182: ,p_object_version_number_o
183: => ota_ftu_shd.g_old_rec.object_version_number

Line 181: => ota_ftu_shd.g_old_rec.author_contact_id

177: => ota_ftu_shd.g_old_rec.business_group_id
178: ,p_author_person_id_o
179: => ota_ftu_shd.g_old_rec.author_person_id
180: ,p_author_contact_id_o
181: => ota_ftu_shd.g_old_rec.author_contact_id
182: ,p_object_version_number_o
183: => ota_ftu_shd.g_old_rec.object_version_number
184: );
185: --

Line 183: => ota_ftu_shd.g_old_rec.object_version_number

179: => ota_ftu_shd.g_old_rec.author_person_id
180: ,p_author_contact_id_o
181: => ota_ftu_shd.g_old_rec.author_contact_id
182: ,p_object_version_number_o
183: => ota_ftu_shd.g_old_rec.object_version_number
184: );
185: --
186: exception
187: --

Line 203: (p_rec in ota_ftu_shd.g_rec_type

199: -- ----------------------------------------------------------------------------
200: -- |---------------------------------< del >----------------------------------|
201: -- ----------------------------------------------------------------------------
202: Procedure del
203: (p_rec in ota_ftu_shd.g_rec_type
204: ) is
205: --
206: l_proc varchar2(72) := g_package||'del';
207: --

Line 213: ota_ftu_shd.lck

209: hr_utility.set_location('Entering:'||l_proc, 5);
210: --
211: -- We must lock the row which we need to delete.
212: --
213: ota_ftu_shd.lck
214: (p_rec.forum_thread_id
215: ,p_rec.forum_id
216: ,p_rec.person_id
217: ,p_rec.contact_id

Line 256: l_rec ota_ftu_shd.g_rec_type;

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