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_CRT_DEL dependencies on OTA_CRT_SHD

Line 52: (p_rec in ota_crt_shd.g_rec_type

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

Line 75: ota_crt_shd.constraint_error

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

Line 168: => ota_crt_shd.g_old_rec.business_group_id

164: ota_crt_rkd.after_delete
165: (p_certification_id
166: => p_rec.certification_id
167: ,p_business_group_id_o
168: => ota_crt_shd.g_old_rec.business_group_id
169: ,p_public_flag_o
170: => ota_crt_shd.g_old_rec.public_flag
171: ,p_initial_completion_date_o
172: => ota_crt_shd.g_old_rec.initial_completion_date

Line 170: => ota_crt_shd.g_old_rec.public_flag

166: => p_rec.certification_id
167: ,p_business_group_id_o
168: => ota_crt_shd.g_old_rec.business_group_id
169: ,p_public_flag_o
170: => ota_crt_shd.g_old_rec.public_flag
171: ,p_initial_completion_date_o
172: => ota_crt_shd.g_old_rec.initial_completion_date
173: ,p_initial_completion_duratio_o
174: => ota_crt_shd.g_old_rec.initial_completion_duration

Line 172: => ota_crt_shd.g_old_rec.initial_completion_date

168: => ota_crt_shd.g_old_rec.business_group_id
169: ,p_public_flag_o
170: => ota_crt_shd.g_old_rec.public_flag
171: ,p_initial_completion_date_o
172: => ota_crt_shd.g_old_rec.initial_completion_date
173: ,p_initial_completion_duratio_o
174: => ota_crt_shd.g_old_rec.initial_completion_duration
175: ,p_initial_compl_duration_uni_o
176: => ota_crt_shd.g_old_rec.initial_compl_duration_units

Line 174: => ota_crt_shd.g_old_rec.initial_completion_duration

170: => ota_crt_shd.g_old_rec.public_flag
171: ,p_initial_completion_date_o
172: => ota_crt_shd.g_old_rec.initial_completion_date
173: ,p_initial_completion_duratio_o
174: => ota_crt_shd.g_old_rec.initial_completion_duration
175: ,p_initial_compl_duration_uni_o
176: => ota_crt_shd.g_old_rec.initial_compl_duration_units
177: ,p_renewal_duration_o
178: => ota_crt_shd.g_old_rec.renewal_duration

Line 176: => ota_crt_shd.g_old_rec.initial_compl_duration_units

172: => ota_crt_shd.g_old_rec.initial_completion_date
173: ,p_initial_completion_duratio_o
174: => ota_crt_shd.g_old_rec.initial_completion_duration
175: ,p_initial_compl_duration_uni_o
176: => ota_crt_shd.g_old_rec.initial_compl_duration_units
177: ,p_renewal_duration_o
178: => ota_crt_shd.g_old_rec.renewal_duration
179: ,p_renewal_duration_units_o
180: => ota_crt_shd.g_old_rec.renewal_duration_units

Line 178: => ota_crt_shd.g_old_rec.renewal_duration

174: => ota_crt_shd.g_old_rec.initial_completion_duration
175: ,p_initial_compl_duration_uni_o
176: => ota_crt_shd.g_old_rec.initial_compl_duration_units
177: ,p_renewal_duration_o
178: => ota_crt_shd.g_old_rec.renewal_duration
179: ,p_renewal_duration_units_o
180: => ota_crt_shd.g_old_rec.renewal_duration_units
181: ,p_notify_days_before_expire_o
182: => ota_crt_shd.g_old_rec.notify_days_before_expire

Line 180: => ota_crt_shd.g_old_rec.renewal_duration_units

176: => ota_crt_shd.g_old_rec.initial_compl_duration_units
177: ,p_renewal_duration_o
178: => ota_crt_shd.g_old_rec.renewal_duration
179: ,p_renewal_duration_units_o
180: => ota_crt_shd.g_old_rec.renewal_duration_units
181: ,p_notify_days_before_expire_o
182: => ota_crt_shd.g_old_rec.notify_days_before_expire
183: ,p_object_version_number_o
184: => ota_crt_shd.g_old_rec.object_version_number

Line 182: => ota_crt_shd.g_old_rec.notify_days_before_expire

178: => ota_crt_shd.g_old_rec.renewal_duration
179: ,p_renewal_duration_units_o
180: => ota_crt_shd.g_old_rec.renewal_duration_units
181: ,p_notify_days_before_expire_o
182: => ota_crt_shd.g_old_rec.notify_days_before_expire
183: ,p_object_version_number_o
184: => ota_crt_shd.g_old_rec.object_version_number
185: ,p_start_date_active_o
186: => ota_crt_shd.g_old_rec.start_date_active

Line 184: => ota_crt_shd.g_old_rec.object_version_number

180: => ota_crt_shd.g_old_rec.renewal_duration_units
181: ,p_notify_days_before_expire_o
182: => ota_crt_shd.g_old_rec.notify_days_before_expire
183: ,p_object_version_number_o
184: => ota_crt_shd.g_old_rec.object_version_number
185: ,p_start_date_active_o
186: => ota_crt_shd.g_old_rec.start_date_active
187: ,p_end_date_active_o
188: => ota_crt_shd.g_old_rec.end_date_active

Line 186: => ota_crt_shd.g_old_rec.start_date_active

182: => ota_crt_shd.g_old_rec.notify_days_before_expire
183: ,p_object_version_number_o
184: => ota_crt_shd.g_old_rec.object_version_number
185: ,p_start_date_active_o
186: => ota_crt_shd.g_old_rec.start_date_active
187: ,p_end_date_active_o
188: => ota_crt_shd.g_old_rec.end_date_active
189: ,p_attribute_category_o
190: => ota_crt_shd.g_old_rec.attribute_category

Line 188: => ota_crt_shd.g_old_rec.end_date_active

184: => ota_crt_shd.g_old_rec.object_version_number
185: ,p_start_date_active_o
186: => ota_crt_shd.g_old_rec.start_date_active
187: ,p_end_date_active_o
188: => ota_crt_shd.g_old_rec.end_date_active
189: ,p_attribute_category_o
190: => ota_crt_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => ota_crt_shd.g_old_rec.attribute1

Line 190: => ota_crt_shd.g_old_rec.attribute_category

186: => ota_crt_shd.g_old_rec.start_date_active
187: ,p_end_date_active_o
188: => ota_crt_shd.g_old_rec.end_date_active
189: ,p_attribute_category_o
190: => ota_crt_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => ota_crt_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => ota_crt_shd.g_old_rec.attribute2

Line 192: => ota_crt_shd.g_old_rec.attribute1

188: => ota_crt_shd.g_old_rec.end_date_active
189: ,p_attribute_category_o
190: => ota_crt_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => ota_crt_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => ota_crt_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => ota_crt_shd.g_old_rec.attribute3

Line 194: => ota_crt_shd.g_old_rec.attribute2

190: => ota_crt_shd.g_old_rec.attribute_category
191: ,p_attribute1_o
192: => ota_crt_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => ota_crt_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => ota_crt_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => ota_crt_shd.g_old_rec.attribute4

Line 196: => ota_crt_shd.g_old_rec.attribute3

192: => ota_crt_shd.g_old_rec.attribute1
193: ,p_attribute2_o
194: => ota_crt_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => ota_crt_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => ota_crt_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => ota_crt_shd.g_old_rec.attribute5

Line 198: => ota_crt_shd.g_old_rec.attribute4

194: => ota_crt_shd.g_old_rec.attribute2
195: ,p_attribute3_o
196: => ota_crt_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => ota_crt_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => ota_crt_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => ota_crt_shd.g_old_rec.attribute6

Line 200: => ota_crt_shd.g_old_rec.attribute5

196: => ota_crt_shd.g_old_rec.attribute3
197: ,p_attribute4_o
198: => ota_crt_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => ota_crt_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => ota_crt_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => ota_crt_shd.g_old_rec.attribute7

Line 202: => ota_crt_shd.g_old_rec.attribute6

198: => ota_crt_shd.g_old_rec.attribute4
199: ,p_attribute5_o
200: => ota_crt_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => ota_crt_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => ota_crt_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => ota_crt_shd.g_old_rec.attribute8

Line 204: => ota_crt_shd.g_old_rec.attribute7

200: => ota_crt_shd.g_old_rec.attribute5
201: ,p_attribute6_o
202: => ota_crt_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => ota_crt_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => ota_crt_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => ota_crt_shd.g_old_rec.attribute9

Line 206: => ota_crt_shd.g_old_rec.attribute8

202: => ota_crt_shd.g_old_rec.attribute6
203: ,p_attribute7_o
204: => ota_crt_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => ota_crt_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => ota_crt_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => ota_crt_shd.g_old_rec.attribute10

Line 208: => ota_crt_shd.g_old_rec.attribute9

204: => ota_crt_shd.g_old_rec.attribute7
205: ,p_attribute8_o
206: => ota_crt_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => ota_crt_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => ota_crt_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => ota_crt_shd.g_old_rec.attribute11

Line 210: => ota_crt_shd.g_old_rec.attribute10

206: => ota_crt_shd.g_old_rec.attribute8
207: ,p_attribute9_o
208: => ota_crt_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => ota_crt_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => ota_crt_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => ota_crt_shd.g_old_rec.attribute12

Line 212: => ota_crt_shd.g_old_rec.attribute11

208: => ota_crt_shd.g_old_rec.attribute9
209: ,p_attribute10_o
210: => ota_crt_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => ota_crt_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => ota_crt_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => ota_crt_shd.g_old_rec.attribute13

Line 214: => ota_crt_shd.g_old_rec.attribute12

210: => ota_crt_shd.g_old_rec.attribute10
211: ,p_attribute11_o
212: => ota_crt_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => ota_crt_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => ota_crt_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => ota_crt_shd.g_old_rec.attribute14

Line 216: => ota_crt_shd.g_old_rec.attribute13

212: => ota_crt_shd.g_old_rec.attribute11
213: ,p_attribute12_o
214: => ota_crt_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => ota_crt_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => ota_crt_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => ota_crt_shd.g_old_rec.attribute15

Line 218: => ota_crt_shd.g_old_rec.attribute14

214: => ota_crt_shd.g_old_rec.attribute12
215: ,p_attribute13_o
216: => ota_crt_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => ota_crt_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => ota_crt_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => ota_crt_shd.g_old_rec.attribute16

Line 220: => ota_crt_shd.g_old_rec.attribute15

216: => ota_crt_shd.g_old_rec.attribute13
217: ,p_attribute14_o
218: => ota_crt_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => ota_crt_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => ota_crt_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => ota_crt_shd.g_old_rec.attribute17

Line 222: => ota_crt_shd.g_old_rec.attribute16

218: => ota_crt_shd.g_old_rec.attribute14
219: ,p_attribute15_o
220: => ota_crt_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => ota_crt_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => ota_crt_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => ota_crt_shd.g_old_rec.attribute18

Line 224: => ota_crt_shd.g_old_rec.attribute17

220: => ota_crt_shd.g_old_rec.attribute15
221: ,p_attribute16_o
222: => ota_crt_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => ota_crt_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => ota_crt_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => ota_crt_shd.g_old_rec.attribute19

Line 226: => ota_crt_shd.g_old_rec.attribute18

222: => ota_crt_shd.g_old_rec.attribute16
223: ,p_attribute17_o
224: => ota_crt_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => ota_crt_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => ota_crt_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => ota_crt_shd.g_old_rec.attribute20

Line 228: => ota_crt_shd.g_old_rec.attribute19

224: => ota_crt_shd.g_old_rec.attribute17
225: ,p_attribute18_o
226: => ota_crt_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => ota_crt_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => ota_crt_shd.g_old_rec.attribute20
231: ,p_VALIDITY_DURATION_o
232: => ota_crt_shd.g_old_rec.VALIDITY_DURATION

Line 230: => ota_crt_shd.g_old_rec.attribute20

226: => ota_crt_shd.g_old_rec.attribute18
227: ,p_attribute19_o
228: => ota_crt_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => ota_crt_shd.g_old_rec.attribute20
231: ,p_VALIDITY_DURATION_o
232: => ota_crt_shd.g_old_rec.VALIDITY_DURATION
233: ,p_VALIDITY_DURATION_UNITS_o
234: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS

Line 232: => ota_crt_shd.g_old_rec.VALIDITY_DURATION

228: => ota_crt_shd.g_old_rec.attribute19
229: ,p_attribute20_o
230: => ota_crt_shd.g_old_rec.attribute20
231: ,p_VALIDITY_DURATION_o
232: => ota_crt_shd.g_old_rec.VALIDITY_DURATION
233: ,p_VALIDITY_DURATION_UNITS_o
234: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS
235: ,p_RENEWABLE_FLAG_o
236: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG

Line 234: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS

230: => ota_crt_shd.g_old_rec.attribute20
231: ,p_VALIDITY_DURATION_o
232: => ota_crt_shd.g_old_rec.VALIDITY_DURATION
233: ,p_VALIDITY_DURATION_UNITS_o
234: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS
235: ,p_RENEWABLE_FLAG_o
236: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG
237: ,p_VALIDITY_START_TYPE_o
238: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE

Line 236: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG

232: => ota_crt_shd.g_old_rec.VALIDITY_DURATION
233: ,p_VALIDITY_DURATION_UNITS_o
234: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS
235: ,p_RENEWABLE_FLAG_o
236: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG
237: ,p_VALIDITY_START_TYPE_o
238: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE
239: ,p_COMPETENCY_UPDATE_LEVEL_o
240: => ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL

Line 238: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE

234: => ota_crt_shd.g_old_rec.VALIDITY_DURATION_UNITS
235: ,p_RENEWABLE_FLAG_o
236: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG
237: ,p_VALIDITY_START_TYPE_o
238: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE
239: ,p_COMPETENCY_UPDATE_LEVEL_o
240: => ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL
241: );
242: --

Line 240: => ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL

236: => ota_crt_shd.g_old_rec.RENEWABLE_FLAG
237: ,p_VALIDITY_START_TYPE_o
238: => ota_crt_shd.g_old_rec.VALIDITY_START_TYPE
239: ,p_COMPETENCY_UPDATE_LEVEL_o
240: => ota_crt_shd.g_old_rec.COMPETENCY_UPDATE_LEVEL
241: );
242: --
243: exception
244: --

Line 260: (p_rec in ota_crt_shd.g_rec_type

256: -- ----------------------------------------------------------------------------
257: -- |---------------------------------< del >----------------------------------|
258: -- ----------------------------------------------------------------------------
259: Procedure del
260: (p_rec in ota_crt_shd.g_rec_type
261: ) is
262: --
263: l_proc varchar2(72) := g_package||'del';
264: --

Line 270: ota_crt_shd.lck

266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: -- We must lock the row which we need to delete.
269: --
270: ota_crt_shd.lck
271: (p_rec.certification_id
272: ,p_rec.object_version_number
273: );
274: --

Line 307: l_rec ota_crt_shd.g_rec_type;

303: (p_certification_id in number
304: ,p_object_version_number in number
305: ) is
306: --
307: l_rec ota_crt_shd.g_rec_type;
308: l_proc varchar2(72) := g_package||'del';
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);