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_ANC_DEL dependencies on OTA_ANC_SHD

Line 52: (p_rec in ota_anc_shd.g_rec_type

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

Line 75: ota_anc_shd.constraint_error

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

Line 168: => ota_anc_shd.g_old_rec.business_group_id

164: ota_anc_rkd.after_delete
165: (p_announcement_id
166: => p_rec.announcement_id
167: ,p_business_group_id_o
168: => ota_anc_shd.g_old_rec.business_group_id
169: ,p_object_version_number_o
170: => ota_anc_shd.g_old_rec.object_version_number
171: ,p_start_date_active_o
172: => ota_anc_shd.g_old_rec.start_date_active

Line 170: => ota_anc_shd.g_old_rec.object_version_number

166: => p_rec.announcement_id
167: ,p_business_group_id_o
168: => ota_anc_shd.g_old_rec.business_group_id
169: ,p_object_version_number_o
170: => ota_anc_shd.g_old_rec.object_version_number
171: ,p_start_date_active_o
172: => ota_anc_shd.g_old_rec.start_date_active
173: ,p_end_date_active_o
174: => ota_anc_shd.g_old_rec.end_date_active

Line 172: => ota_anc_shd.g_old_rec.start_date_active

168: => ota_anc_shd.g_old_rec.business_group_id
169: ,p_object_version_number_o
170: => ota_anc_shd.g_old_rec.object_version_number
171: ,p_start_date_active_o
172: => ota_anc_shd.g_old_rec.start_date_active
173: ,p_end_date_active_o
174: => ota_anc_shd.g_old_rec.end_date_active
175: ,p_owner_id_o
176: => ota_anc_shd.g_old_rec.owner_id

Line 174: => ota_anc_shd.g_old_rec.end_date_active

170: => ota_anc_shd.g_old_rec.object_version_number
171: ,p_start_date_active_o
172: => ota_anc_shd.g_old_rec.start_date_active
173: ,p_end_date_active_o
174: => ota_anc_shd.g_old_rec.end_date_active
175: ,p_owner_id_o
176: => ota_anc_shd.g_old_rec.owner_id
177: ,p_attribute_category_o
178: => ota_anc_shd.g_old_rec.attribute_category

Line 176: => ota_anc_shd.g_old_rec.owner_id

172: => ota_anc_shd.g_old_rec.start_date_active
173: ,p_end_date_active_o
174: => ota_anc_shd.g_old_rec.end_date_active
175: ,p_owner_id_o
176: => ota_anc_shd.g_old_rec.owner_id
177: ,p_attribute_category_o
178: => ota_anc_shd.g_old_rec.attribute_category
179: ,p_attribute1_o
180: => ota_anc_shd.g_old_rec.attribute1

Line 178: => ota_anc_shd.g_old_rec.attribute_category

174: => ota_anc_shd.g_old_rec.end_date_active
175: ,p_owner_id_o
176: => ota_anc_shd.g_old_rec.owner_id
177: ,p_attribute_category_o
178: => ota_anc_shd.g_old_rec.attribute_category
179: ,p_attribute1_o
180: => ota_anc_shd.g_old_rec.attribute1
181: ,p_attribute2_o
182: => ota_anc_shd.g_old_rec.attribute2

Line 180: => ota_anc_shd.g_old_rec.attribute1

176: => ota_anc_shd.g_old_rec.owner_id
177: ,p_attribute_category_o
178: => ota_anc_shd.g_old_rec.attribute_category
179: ,p_attribute1_o
180: => ota_anc_shd.g_old_rec.attribute1
181: ,p_attribute2_o
182: => ota_anc_shd.g_old_rec.attribute2
183: ,p_attribute3_o
184: => ota_anc_shd.g_old_rec.attribute3

Line 182: => ota_anc_shd.g_old_rec.attribute2

178: => ota_anc_shd.g_old_rec.attribute_category
179: ,p_attribute1_o
180: => ota_anc_shd.g_old_rec.attribute1
181: ,p_attribute2_o
182: => ota_anc_shd.g_old_rec.attribute2
183: ,p_attribute3_o
184: => ota_anc_shd.g_old_rec.attribute3
185: ,p_attribute4_o
186: => ota_anc_shd.g_old_rec.attribute4

Line 184: => ota_anc_shd.g_old_rec.attribute3

180: => ota_anc_shd.g_old_rec.attribute1
181: ,p_attribute2_o
182: => ota_anc_shd.g_old_rec.attribute2
183: ,p_attribute3_o
184: => ota_anc_shd.g_old_rec.attribute3
185: ,p_attribute4_o
186: => ota_anc_shd.g_old_rec.attribute4
187: ,p_attribute5_o
188: => ota_anc_shd.g_old_rec.attribute5

Line 186: => ota_anc_shd.g_old_rec.attribute4

182: => ota_anc_shd.g_old_rec.attribute2
183: ,p_attribute3_o
184: => ota_anc_shd.g_old_rec.attribute3
185: ,p_attribute4_o
186: => ota_anc_shd.g_old_rec.attribute4
187: ,p_attribute5_o
188: => ota_anc_shd.g_old_rec.attribute5
189: ,p_attribute6_o
190: => ota_anc_shd.g_old_rec.attribute6

Line 188: => ota_anc_shd.g_old_rec.attribute5

184: => ota_anc_shd.g_old_rec.attribute3
185: ,p_attribute4_o
186: => ota_anc_shd.g_old_rec.attribute4
187: ,p_attribute5_o
188: => ota_anc_shd.g_old_rec.attribute5
189: ,p_attribute6_o
190: => ota_anc_shd.g_old_rec.attribute6
191: ,p_attribute7_o
192: => ota_anc_shd.g_old_rec.attribute7

Line 190: => ota_anc_shd.g_old_rec.attribute6

186: => ota_anc_shd.g_old_rec.attribute4
187: ,p_attribute5_o
188: => ota_anc_shd.g_old_rec.attribute5
189: ,p_attribute6_o
190: => ota_anc_shd.g_old_rec.attribute6
191: ,p_attribute7_o
192: => ota_anc_shd.g_old_rec.attribute7
193: ,p_attribute8_o
194: => ota_anc_shd.g_old_rec.attribute8

Line 192: => ota_anc_shd.g_old_rec.attribute7

188: => ota_anc_shd.g_old_rec.attribute5
189: ,p_attribute6_o
190: => ota_anc_shd.g_old_rec.attribute6
191: ,p_attribute7_o
192: => ota_anc_shd.g_old_rec.attribute7
193: ,p_attribute8_o
194: => ota_anc_shd.g_old_rec.attribute8
195: ,p_attribute9_o
196: => ota_anc_shd.g_old_rec.attribute9

Line 194: => ota_anc_shd.g_old_rec.attribute8

190: => ota_anc_shd.g_old_rec.attribute6
191: ,p_attribute7_o
192: => ota_anc_shd.g_old_rec.attribute7
193: ,p_attribute8_o
194: => ota_anc_shd.g_old_rec.attribute8
195: ,p_attribute9_o
196: => ota_anc_shd.g_old_rec.attribute9
197: ,p_attribute10_o
198: => ota_anc_shd.g_old_rec.attribute10

Line 196: => ota_anc_shd.g_old_rec.attribute9

192: => ota_anc_shd.g_old_rec.attribute7
193: ,p_attribute8_o
194: => ota_anc_shd.g_old_rec.attribute8
195: ,p_attribute9_o
196: => ota_anc_shd.g_old_rec.attribute9
197: ,p_attribute10_o
198: => ota_anc_shd.g_old_rec.attribute10
199: ,p_attribute11_o
200: => ota_anc_shd.g_old_rec.attribute11

Line 198: => ota_anc_shd.g_old_rec.attribute10

194: => ota_anc_shd.g_old_rec.attribute8
195: ,p_attribute9_o
196: => ota_anc_shd.g_old_rec.attribute9
197: ,p_attribute10_o
198: => ota_anc_shd.g_old_rec.attribute10
199: ,p_attribute11_o
200: => ota_anc_shd.g_old_rec.attribute11
201: ,p_attribute12_o
202: => ota_anc_shd.g_old_rec.attribute12

Line 200: => ota_anc_shd.g_old_rec.attribute11

196: => ota_anc_shd.g_old_rec.attribute9
197: ,p_attribute10_o
198: => ota_anc_shd.g_old_rec.attribute10
199: ,p_attribute11_o
200: => ota_anc_shd.g_old_rec.attribute11
201: ,p_attribute12_o
202: => ota_anc_shd.g_old_rec.attribute12
203: ,p_attribute13_o
204: => ota_anc_shd.g_old_rec.attribute13

Line 202: => ota_anc_shd.g_old_rec.attribute12

198: => ota_anc_shd.g_old_rec.attribute10
199: ,p_attribute11_o
200: => ota_anc_shd.g_old_rec.attribute11
201: ,p_attribute12_o
202: => ota_anc_shd.g_old_rec.attribute12
203: ,p_attribute13_o
204: => ota_anc_shd.g_old_rec.attribute13
205: ,p_attribute14_o
206: => ota_anc_shd.g_old_rec.attribute14

Line 204: => ota_anc_shd.g_old_rec.attribute13

200: => ota_anc_shd.g_old_rec.attribute11
201: ,p_attribute12_o
202: => ota_anc_shd.g_old_rec.attribute12
203: ,p_attribute13_o
204: => ota_anc_shd.g_old_rec.attribute13
205: ,p_attribute14_o
206: => ota_anc_shd.g_old_rec.attribute14
207: ,p_attribute15_o
208: => ota_anc_shd.g_old_rec.attribute15

Line 206: => ota_anc_shd.g_old_rec.attribute14

202: => ota_anc_shd.g_old_rec.attribute12
203: ,p_attribute13_o
204: => ota_anc_shd.g_old_rec.attribute13
205: ,p_attribute14_o
206: => ota_anc_shd.g_old_rec.attribute14
207: ,p_attribute15_o
208: => ota_anc_shd.g_old_rec.attribute15
209: ,p_attribute16_o
210: => ota_anc_shd.g_old_rec.attribute16

Line 208: => ota_anc_shd.g_old_rec.attribute15

204: => ota_anc_shd.g_old_rec.attribute13
205: ,p_attribute14_o
206: => ota_anc_shd.g_old_rec.attribute14
207: ,p_attribute15_o
208: => ota_anc_shd.g_old_rec.attribute15
209: ,p_attribute16_o
210: => ota_anc_shd.g_old_rec.attribute16
211: ,p_attribute17_o
212: => ota_anc_shd.g_old_rec.attribute17

Line 210: => ota_anc_shd.g_old_rec.attribute16

206: => ota_anc_shd.g_old_rec.attribute14
207: ,p_attribute15_o
208: => ota_anc_shd.g_old_rec.attribute15
209: ,p_attribute16_o
210: => ota_anc_shd.g_old_rec.attribute16
211: ,p_attribute17_o
212: => ota_anc_shd.g_old_rec.attribute17
213: ,p_attribute18_o
214: => ota_anc_shd.g_old_rec.attribute18

Line 212: => ota_anc_shd.g_old_rec.attribute17

208: => ota_anc_shd.g_old_rec.attribute15
209: ,p_attribute16_o
210: => ota_anc_shd.g_old_rec.attribute16
211: ,p_attribute17_o
212: => ota_anc_shd.g_old_rec.attribute17
213: ,p_attribute18_o
214: => ota_anc_shd.g_old_rec.attribute18
215: ,p_attribute19_o
216: => ota_anc_shd.g_old_rec.attribute19

Line 214: => ota_anc_shd.g_old_rec.attribute18

210: => ota_anc_shd.g_old_rec.attribute16
211: ,p_attribute17_o
212: => ota_anc_shd.g_old_rec.attribute17
213: ,p_attribute18_o
214: => ota_anc_shd.g_old_rec.attribute18
215: ,p_attribute19_o
216: => ota_anc_shd.g_old_rec.attribute19
217: ,p_attribute20_o
218: => ota_anc_shd.g_old_rec.attribute20

Line 216: => ota_anc_shd.g_old_rec.attribute19

212: => ota_anc_shd.g_old_rec.attribute17
213: ,p_attribute18_o
214: => ota_anc_shd.g_old_rec.attribute18
215: ,p_attribute19_o
216: => ota_anc_shd.g_old_rec.attribute19
217: ,p_attribute20_o
218: => ota_anc_shd.g_old_rec.attribute20
219: );
220: --

Line 218: => ota_anc_shd.g_old_rec.attribute20

214: => ota_anc_shd.g_old_rec.attribute18
215: ,p_attribute19_o
216: => ota_anc_shd.g_old_rec.attribute19
217: ,p_attribute20_o
218: => ota_anc_shd.g_old_rec.attribute20
219: );
220: --
221: exception
222: --

Line 238: (p_rec in ota_anc_shd.g_rec_type

234: -- ----------------------------------------------------------------------------
235: -- |---------------------------------< del >----------------------------------|
236: -- ----------------------------------------------------------------------------
237: Procedure del
238: (p_rec in ota_anc_shd.g_rec_type
239: ) is
240: --
241: l_proc varchar2(72) := g_package||'del';
242: --

Line 248: ota_anc_shd.lck

244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: -- We must lock the row which we need to delete.
247: --
248: ota_anc_shd.lck
249: (p_rec.announcement_id
250: ,p_rec.object_version_number
251: );
252: --

Line 285: l_rec ota_anc_shd.g_rec_type;

281: (p_announcement_id in number
282: ,p_object_version_number in number
283: ) is
284: --
285: l_rec ota_anc_shd.g_rec_type;
286: l_proc varchar2(72) := g_package||'del';
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);