eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_FTS_DEL dependencies on OTA_FTS_SHD

Line 52: (p_rec in ota_fts_shd.g_rec_type

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

Line 75: ota_fts_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ota_fts_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in ota_fts_shd.g_rec_type) is

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

Line 156: Procedure post_delete(p_rec in ota_fts_shd.g_rec_type) is

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

Line 168: => ota_fts_shd.g_old_rec.forum_id

164: ota_fts_rkd.after_delete
165: (p_forum_thread_id
166: => p_rec.forum_thread_id
167: ,p_forum_id_o
168: => ota_fts_shd.g_old_rec.forum_id
169: ,p_business_group_id_o
170: => ota_fts_shd.g_old_rec.business_group_id
171: ,p_subject_o
172: => ota_fts_shd.g_old_rec.subject

Line 170: => ota_fts_shd.g_old_rec.business_group_id

166: => p_rec.forum_thread_id
167: ,p_forum_id_o
168: => ota_fts_shd.g_old_rec.forum_id
169: ,p_business_group_id_o
170: => ota_fts_shd.g_old_rec.business_group_id
171: ,p_subject_o
172: => ota_fts_shd.g_old_rec.subject
173: ,p_last_post_date_o
174: => ota_fts_shd.g_old_rec.last_post_date

Line 172: => ota_fts_shd.g_old_rec.subject

168: => ota_fts_shd.g_old_rec.forum_id
169: ,p_business_group_id_o
170: => ota_fts_shd.g_old_rec.business_group_id
171: ,p_subject_o
172: => ota_fts_shd.g_old_rec.subject
173: ,p_last_post_date_o
174: => ota_fts_shd.g_old_rec.last_post_date
175: ,p_reply_count_o
176: => ota_fts_shd.g_old_rec.reply_count

Line 174: => ota_fts_shd.g_old_rec.last_post_date

170: => ota_fts_shd.g_old_rec.business_group_id
171: ,p_subject_o
172: => ota_fts_shd.g_old_rec.subject
173: ,p_last_post_date_o
174: => ota_fts_shd.g_old_rec.last_post_date
175: ,p_reply_count_o
176: => ota_fts_shd.g_old_rec.reply_count
177: ,p_private_thread_flag_o
178: => ota_fts_shd.g_old_rec.private_thread_flag

Line 176: => ota_fts_shd.g_old_rec.reply_count

172: => ota_fts_shd.g_old_rec.subject
173: ,p_last_post_date_o
174: => ota_fts_shd.g_old_rec.last_post_date
175: ,p_reply_count_o
176: => ota_fts_shd.g_old_rec.reply_count
177: ,p_private_thread_flag_o
178: => ota_fts_shd.g_old_rec.private_thread_flag
179: ,p_object_version_number_o
180: => ota_fts_shd.g_old_rec.object_version_number

Line 178: => ota_fts_shd.g_old_rec.private_thread_flag

174: => ota_fts_shd.g_old_rec.last_post_date
175: ,p_reply_count_o
176: => ota_fts_shd.g_old_rec.reply_count
177: ,p_private_thread_flag_o
178: => ota_fts_shd.g_old_rec.private_thread_flag
179: ,p_object_version_number_o
180: => ota_fts_shd.g_old_rec.object_version_number
181: );
182: --

Line 180: => ota_fts_shd.g_old_rec.object_version_number

176: => ota_fts_shd.g_old_rec.reply_count
177: ,p_private_thread_flag_o
178: => ota_fts_shd.g_old_rec.private_thread_flag
179: ,p_object_version_number_o
180: => ota_fts_shd.g_old_rec.object_version_number
181: );
182: --
183: exception
184: --

Line 200: (p_rec in ota_fts_shd.g_rec_type

196: -- ----------------------------------------------------------------------------
197: -- |---------------------------------< del >----------------------------------|
198: -- ----------------------------------------------------------------------------
199: Procedure del
200: (p_rec in ota_fts_shd.g_rec_type
201: ) is
202: --
203: l_proc varchar2(72) := g_package||'del';
204: --

Line 210: ota_fts_shd.lck

206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: -- We must lock the row which we need to delete.
209: --
210: ota_fts_shd.lck
211: (p_rec.forum_thread_id
212: ,p_rec.object_version_number
213: );
214: --

Line 247: l_rec ota_fts_shd.g_rec_type;

243: (p_forum_thread_id in number
244: ,p_object_version_number in number
245: ) is
246: --
247: l_rec ota_fts_shd.g_rec_type;
248: l_proc varchar2(72) := g_package||'del';
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);