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_FRM_DEL dependencies on OTA_FRM_SHD

Line 52: (p_rec in ota_frm_shd.g_rec_type

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

Line 75: ota_frm_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ota_frm_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_frm_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_frm_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_frm_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_frm_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => ota_frm_shd.g_old_rec.business_group_id

164: ota_frm_rkd.after_delete
165: (p_forum_id
166: => p_rec.forum_id
167: ,p_business_group_id_o
168: => ota_frm_shd.g_old_rec.business_group_id
169: ,p_start_date_active_o
170: => ota_frm_shd.g_old_rec.start_date_active
171: ,p_end_date_active_o
172: => ota_frm_shd.g_old_rec.end_date_active

Line 170: => ota_frm_shd.g_old_rec.start_date_active

166: => p_rec.forum_id
167: ,p_business_group_id_o
168: => ota_frm_shd.g_old_rec.business_group_id
169: ,p_start_date_active_o
170: => ota_frm_shd.g_old_rec.start_date_active
171: ,p_end_date_active_o
172: => ota_frm_shd.g_old_rec.end_date_active
173: ,p_message_type_flag_o
174: => ota_frm_shd.g_old_rec.message_type_flag

Line 172: => ota_frm_shd.g_old_rec.end_date_active

168: => ota_frm_shd.g_old_rec.business_group_id
169: ,p_start_date_active_o
170: => ota_frm_shd.g_old_rec.start_date_active
171: ,p_end_date_active_o
172: => ota_frm_shd.g_old_rec.end_date_active
173: ,p_message_type_flag_o
174: => ota_frm_shd.g_old_rec.message_type_flag
175: ,p_allow_html_flag_o
176: => ota_frm_shd.g_old_rec.allow_html_flag

Line 174: => ota_frm_shd.g_old_rec.message_type_flag

170: => ota_frm_shd.g_old_rec.start_date_active
171: ,p_end_date_active_o
172: => ota_frm_shd.g_old_rec.end_date_active
173: ,p_message_type_flag_o
174: => ota_frm_shd.g_old_rec.message_type_flag
175: ,p_allow_html_flag_o
176: => ota_frm_shd.g_old_rec.allow_html_flag
177: ,p_allow_attachment_flag_o
178: => ota_frm_shd.g_old_rec.allow_attachment_flag

Line 176: => ota_frm_shd.g_old_rec.allow_html_flag

172: => ota_frm_shd.g_old_rec.end_date_active
173: ,p_message_type_flag_o
174: => ota_frm_shd.g_old_rec.message_type_flag
175: ,p_allow_html_flag_o
176: => ota_frm_shd.g_old_rec.allow_html_flag
177: ,p_allow_attachment_flag_o
178: => ota_frm_shd.g_old_rec.allow_attachment_flag
179: ,p_auto_notification_flag_o
180: => ota_frm_shd.g_old_rec.auto_notification_flag

Line 178: => ota_frm_shd.g_old_rec.allow_attachment_flag

174: => ota_frm_shd.g_old_rec.message_type_flag
175: ,p_allow_html_flag_o
176: => ota_frm_shd.g_old_rec.allow_html_flag
177: ,p_allow_attachment_flag_o
178: => ota_frm_shd.g_old_rec.allow_attachment_flag
179: ,p_auto_notification_flag_o
180: => ota_frm_shd.g_old_rec.auto_notification_flag
181: ,p_public_flag_o
182: => ota_frm_shd.g_old_rec.public_flag

Line 180: => ota_frm_shd.g_old_rec.auto_notification_flag

176: => ota_frm_shd.g_old_rec.allow_html_flag
177: ,p_allow_attachment_flag_o
178: => ota_frm_shd.g_old_rec.allow_attachment_flag
179: ,p_auto_notification_flag_o
180: => ota_frm_shd.g_old_rec.auto_notification_flag
181: ,p_public_flag_o
182: => ota_frm_shd.g_old_rec.public_flag
183: ,p_object_version_number_o
184: => ota_frm_shd.g_old_rec.object_version_number

Line 182: => ota_frm_shd.g_old_rec.public_flag

178: => ota_frm_shd.g_old_rec.allow_attachment_flag
179: ,p_auto_notification_flag_o
180: => ota_frm_shd.g_old_rec.auto_notification_flag
181: ,p_public_flag_o
182: => ota_frm_shd.g_old_rec.public_flag
183: ,p_object_version_number_o
184: => ota_frm_shd.g_old_rec.object_version_number
185: );
186: --

Line 184: => ota_frm_shd.g_old_rec.object_version_number

180: => ota_frm_shd.g_old_rec.auto_notification_flag
181: ,p_public_flag_o
182: => ota_frm_shd.g_old_rec.public_flag
183: ,p_object_version_number_o
184: => ota_frm_shd.g_old_rec.object_version_number
185: );
186: --
187: exception
188: --

Line 204: (p_rec in ota_frm_shd.g_rec_type

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

Line 214: ota_frm_shd.lck

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

Line 251: l_rec ota_frm_shd.g_rec_type;

247: (p_forum_id in number
248: ,p_object_version_number in number
249: ) is
250: --
251: l_rec ota_frm_shd.g_rec_type;
252: l_proc varchar2(72) := g_package||'del';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);