APPS.OTA_LPM_DEL dependencies on OTA_LPM_SHD

Line 53: (p_rec in ota_lpm_shd.g_rec_type

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

Line 76: ota_lpm_shd.constraint_error

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

Line 115: Procedure pre_delete(p_rec in ota_lpm_shd.g_rec_type) is

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

Line 157: Procedure post_delete(p_rec in ota_lpm_shd.g_rec_type) is

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

Line 169: => ota_lpm_shd.g_old_rec.learning_path_id

165: ota_lpm_rkd.after_delete
166: (p_learning_path_member_id
167: => p_rec.learning_path_member_id
168: ,p_learning_path_id_o
169: => ota_lpm_shd.g_old_rec.learning_path_id
170: ,p_activity_version_id_o
171: => ota_lpm_shd.g_old_rec.activity_version_id
172: ,p_course_sequence_o
173: => ota_lpm_shd.g_old_rec.course_sequence

Line 171: => ota_lpm_shd.g_old_rec.activity_version_id

167: => p_rec.learning_path_member_id
168: ,p_learning_path_id_o
169: => ota_lpm_shd.g_old_rec.learning_path_id
170: ,p_activity_version_id_o
171: => ota_lpm_shd.g_old_rec.activity_version_id
172: ,p_course_sequence_o
173: => ota_lpm_shd.g_old_rec.course_sequence
174: ,p_business_group_id_o
175: => ota_lpm_shd.g_old_rec.business_group_id

Line 173: => ota_lpm_shd.g_old_rec.course_sequence

169: => ota_lpm_shd.g_old_rec.learning_path_id
170: ,p_activity_version_id_o
171: => ota_lpm_shd.g_old_rec.activity_version_id
172: ,p_course_sequence_o
173: => ota_lpm_shd.g_old_rec.course_sequence
174: ,p_business_group_id_o
175: => ota_lpm_shd.g_old_rec.business_group_id
176: ,p_duration_o
177: => ota_lpm_shd.g_old_rec.duration

Line 175: => ota_lpm_shd.g_old_rec.business_group_id

171: => ota_lpm_shd.g_old_rec.activity_version_id
172: ,p_course_sequence_o
173: => ota_lpm_shd.g_old_rec.course_sequence
174: ,p_business_group_id_o
175: => ota_lpm_shd.g_old_rec.business_group_id
176: ,p_duration_o
177: => ota_lpm_shd.g_old_rec.duration
178: ,p_duration_units_o
179: => ota_lpm_shd.g_old_rec.duration_units

Line 177: => ota_lpm_shd.g_old_rec.duration

173: => ota_lpm_shd.g_old_rec.course_sequence
174: ,p_business_group_id_o
175: => ota_lpm_shd.g_old_rec.business_group_id
176: ,p_duration_o
177: => ota_lpm_shd.g_old_rec.duration
178: ,p_duration_units_o
179: => ota_lpm_shd.g_old_rec.duration_units
180: ,p_object_version_number_o
181: => ota_lpm_shd.g_old_rec.object_version_number

Line 179: => ota_lpm_shd.g_old_rec.duration_units

175: => ota_lpm_shd.g_old_rec.business_group_id
176: ,p_duration_o
177: => ota_lpm_shd.g_old_rec.duration
178: ,p_duration_units_o
179: => ota_lpm_shd.g_old_rec.duration_units
180: ,p_object_version_number_o
181: => ota_lpm_shd.g_old_rec.object_version_number
182: ,p_attribute_category_o
183: => ota_lpm_shd.g_old_rec.attribute_category

Line 181: => ota_lpm_shd.g_old_rec.object_version_number

177: => ota_lpm_shd.g_old_rec.duration
178: ,p_duration_units_o
179: => ota_lpm_shd.g_old_rec.duration_units
180: ,p_object_version_number_o
181: => ota_lpm_shd.g_old_rec.object_version_number
182: ,p_attribute_category_o
183: => ota_lpm_shd.g_old_rec.attribute_category
184: ,p_attribute1_o
185: => ota_lpm_shd.g_old_rec.attribute1

Line 183: => ota_lpm_shd.g_old_rec.attribute_category

179: => ota_lpm_shd.g_old_rec.duration_units
180: ,p_object_version_number_o
181: => ota_lpm_shd.g_old_rec.object_version_number
182: ,p_attribute_category_o
183: => ota_lpm_shd.g_old_rec.attribute_category
184: ,p_attribute1_o
185: => ota_lpm_shd.g_old_rec.attribute1
186: ,p_attribute2_o
187: => ota_lpm_shd.g_old_rec.attribute2

Line 185: => ota_lpm_shd.g_old_rec.attribute1

181: => ota_lpm_shd.g_old_rec.object_version_number
182: ,p_attribute_category_o
183: => ota_lpm_shd.g_old_rec.attribute_category
184: ,p_attribute1_o
185: => ota_lpm_shd.g_old_rec.attribute1
186: ,p_attribute2_o
187: => ota_lpm_shd.g_old_rec.attribute2
188: ,p_attribute3_o
189: => ota_lpm_shd.g_old_rec.attribute3

Line 187: => ota_lpm_shd.g_old_rec.attribute2

183: => ota_lpm_shd.g_old_rec.attribute_category
184: ,p_attribute1_o
185: => ota_lpm_shd.g_old_rec.attribute1
186: ,p_attribute2_o
187: => ota_lpm_shd.g_old_rec.attribute2
188: ,p_attribute3_o
189: => ota_lpm_shd.g_old_rec.attribute3
190: ,p_attribute4_o
191: => ota_lpm_shd.g_old_rec.attribute4

Line 189: => ota_lpm_shd.g_old_rec.attribute3

185: => ota_lpm_shd.g_old_rec.attribute1
186: ,p_attribute2_o
187: => ota_lpm_shd.g_old_rec.attribute2
188: ,p_attribute3_o
189: => ota_lpm_shd.g_old_rec.attribute3
190: ,p_attribute4_o
191: => ota_lpm_shd.g_old_rec.attribute4
192: ,p_attribute5_o
193: => ota_lpm_shd.g_old_rec.attribute5

Line 191: => ota_lpm_shd.g_old_rec.attribute4

187: => ota_lpm_shd.g_old_rec.attribute2
188: ,p_attribute3_o
189: => ota_lpm_shd.g_old_rec.attribute3
190: ,p_attribute4_o
191: => ota_lpm_shd.g_old_rec.attribute4
192: ,p_attribute5_o
193: => ota_lpm_shd.g_old_rec.attribute5
194: ,p_attribute6_o
195: => ota_lpm_shd.g_old_rec.attribute6

Line 193: => ota_lpm_shd.g_old_rec.attribute5

189: => ota_lpm_shd.g_old_rec.attribute3
190: ,p_attribute4_o
191: => ota_lpm_shd.g_old_rec.attribute4
192: ,p_attribute5_o
193: => ota_lpm_shd.g_old_rec.attribute5
194: ,p_attribute6_o
195: => ota_lpm_shd.g_old_rec.attribute6
196: ,p_attribute7_o
197: => ota_lpm_shd.g_old_rec.attribute7

Line 195: => ota_lpm_shd.g_old_rec.attribute6

191: => ota_lpm_shd.g_old_rec.attribute4
192: ,p_attribute5_o
193: => ota_lpm_shd.g_old_rec.attribute5
194: ,p_attribute6_o
195: => ota_lpm_shd.g_old_rec.attribute6
196: ,p_attribute7_o
197: => ota_lpm_shd.g_old_rec.attribute7
198: ,p_attribute8_o
199: => ota_lpm_shd.g_old_rec.attribute8

Line 197: => ota_lpm_shd.g_old_rec.attribute7

193: => ota_lpm_shd.g_old_rec.attribute5
194: ,p_attribute6_o
195: => ota_lpm_shd.g_old_rec.attribute6
196: ,p_attribute7_o
197: => ota_lpm_shd.g_old_rec.attribute7
198: ,p_attribute8_o
199: => ota_lpm_shd.g_old_rec.attribute8
200: ,p_attribute9_o
201: => ota_lpm_shd.g_old_rec.attribute9

Line 199: => ota_lpm_shd.g_old_rec.attribute8

195: => ota_lpm_shd.g_old_rec.attribute6
196: ,p_attribute7_o
197: => ota_lpm_shd.g_old_rec.attribute7
198: ,p_attribute8_o
199: => ota_lpm_shd.g_old_rec.attribute8
200: ,p_attribute9_o
201: => ota_lpm_shd.g_old_rec.attribute9
202: ,p_attribute10_o
203: => ota_lpm_shd.g_old_rec.attribute10

Line 201: => ota_lpm_shd.g_old_rec.attribute9

197: => ota_lpm_shd.g_old_rec.attribute7
198: ,p_attribute8_o
199: => ota_lpm_shd.g_old_rec.attribute8
200: ,p_attribute9_o
201: => ota_lpm_shd.g_old_rec.attribute9
202: ,p_attribute10_o
203: => ota_lpm_shd.g_old_rec.attribute10
204: ,p_attribute11_o
205: => ota_lpm_shd.g_old_rec.attribute11

Line 203: => ota_lpm_shd.g_old_rec.attribute10

199: => ota_lpm_shd.g_old_rec.attribute8
200: ,p_attribute9_o
201: => ota_lpm_shd.g_old_rec.attribute9
202: ,p_attribute10_o
203: => ota_lpm_shd.g_old_rec.attribute10
204: ,p_attribute11_o
205: => ota_lpm_shd.g_old_rec.attribute11
206: ,p_attribute12_o
207: => ota_lpm_shd.g_old_rec.attribute12

Line 205: => ota_lpm_shd.g_old_rec.attribute11

201: => ota_lpm_shd.g_old_rec.attribute9
202: ,p_attribute10_o
203: => ota_lpm_shd.g_old_rec.attribute10
204: ,p_attribute11_o
205: => ota_lpm_shd.g_old_rec.attribute11
206: ,p_attribute12_o
207: => ota_lpm_shd.g_old_rec.attribute12
208: ,p_attribute13_o
209: => ota_lpm_shd.g_old_rec.attribute13

Line 207: => ota_lpm_shd.g_old_rec.attribute12

203: => ota_lpm_shd.g_old_rec.attribute10
204: ,p_attribute11_o
205: => ota_lpm_shd.g_old_rec.attribute11
206: ,p_attribute12_o
207: => ota_lpm_shd.g_old_rec.attribute12
208: ,p_attribute13_o
209: => ota_lpm_shd.g_old_rec.attribute13
210: ,p_attribute14_o
211: => ota_lpm_shd.g_old_rec.attribute14

Line 209: => ota_lpm_shd.g_old_rec.attribute13

205: => ota_lpm_shd.g_old_rec.attribute11
206: ,p_attribute12_o
207: => ota_lpm_shd.g_old_rec.attribute12
208: ,p_attribute13_o
209: => ota_lpm_shd.g_old_rec.attribute13
210: ,p_attribute14_o
211: => ota_lpm_shd.g_old_rec.attribute14
212: ,p_attribute15_o
213: => ota_lpm_shd.g_old_rec.attribute15

Line 211: => ota_lpm_shd.g_old_rec.attribute14

207: => ota_lpm_shd.g_old_rec.attribute12
208: ,p_attribute13_o
209: => ota_lpm_shd.g_old_rec.attribute13
210: ,p_attribute14_o
211: => ota_lpm_shd.g_old_rec.attribute14
212: ,p_attribute15_o
213: => ota_lpm_shd.g_old_rec.attribute15
214: ,p_attribute16_o
215: => ota_lpm_shd.g_old_rec.attribute16

Line 213: => ota_lpm_shd.g_old_rec.attribute15

209: => ota_lpm_shd.g_old_rec.attribute13
210: ,p_attribute14_o
211: => ota_lpm_shd.g_old_rec.attribute14
212: ,p_attribute15_o
213: => ota_lpm_shd.g_old_rec.attribute15
214: ,p_attribute16_o
215: => ota_lpm_shd.g_old_rec.attribute16
216: ,p_attribute17_o
217: => ota_lpm_shd.g_old_rec.attribute17

Line 215: => ota_lpm_shd.g_old_rec.attribute16

211: => ota_lpm_shd.g_old_rec.attribute14
212: ,p_attribute15_o
213: => ota_lpm_shd.g_old_rec.attribute15
214: ,p_attribute16_o
215: => ota_lpm_shd.g_old_rec.attribute16
216: ,p_attribute17_o
217: => ota_lpm_shd.g_old_rec.attribute17
218: ,p_attribute18_o
219: => ota_lpm_shd.g_old_rec.attribute18

Line 217: => ota_lpm_shd.g_old_rec.attribute17

213: => ota_lpm_shd.g_old_rec.attribute15
214: ,p_attribute16_o
215: => ota_lpm_shd.g_old_rec.attribute16
216: ,p_attribute17_o
217: => ota_lpm_shd.g_old_rec.attribute17
218: ,p_attribute18_o
219: => ota_lpm_shd.g_old_rec.attribute18
220: ,p_attribute19_o
221: => ota_lpm_shd.g_old_rec.attribute19

Line 219: => ota_lpm_shd.g_old_rec.attribute18

215: => ota_lpm_shd.g_old_rec.attribute16
216: ,p_attribute17_o
217: => ota_lpm_shd.g_old_rec.attribute17
218: ,p_attribute18_o
219: => ota_lpm_shd.g_old_rec.attribute18
220: ,p_attribute19_o
221: => ota_lpm_shd.g_old_rec.attribute19
222: ,p_attribute20_o
223: => ota_lpm_shd.g_old_rec.attribute20

Line 221: => ota_lpm_shd.g_old_rec.attribute19

217: => ota_lpm_shd.g_old_rec.attribute17
218: ,p_attribute18_o
219: => ota_lpm_shd.g_old_rec.attribute18
220: ,p_attribute19_o
221: => ota_lpm_shd.g_old_rec.attribute19
222: ,p_attribute20_o
223: => ota_lpm_shd.g_old_rec.attribute20
224: ,p_learning_path_section_id_o
225: => ota_lpm_shd.g_old_rec.learning_path_section_id

Line 223: => ota_lpm_shd.g_old_rec.attribute20

219: => ota_lpm_shd.g_old_rec.attribute18
220: ,p_attribute19_o
221: => ota_lpm_shd.g_old_rec.attribute19
222: ,p_attribute20_o
223: => ota_lpm_shd.g_old_rec.attribute20
224: ,p_learning_path_section_id_o
225: => ota_lpm_shd.g_old_rec.learning_path_section_id
226: ,p_notify_days_before_target_o
227: => ota_lpm_shd.g_old_rec.notify_days_before_target

Line 225: => ota_lpm_shd.g_old_rec.learning_path_section_id

221: => ota_lpm_shd.g_old_rec.attribute19
222: ,p_attribute20_o
223: => ota_lpm_shd.g_old_rec.attribute20
224: ,p_learning_path_section_id_o
225: => ota_lpm_shd.g_old_rec.learning_path_section_id
226: ,p_notify_days_before_target_o
227: => ota_lpm_shd.g_old_rec.notify_days_before_target
228: );
229: --

Line 227: => ota_lpm_shd.g_old_rec.notify_days_before_target

223: => ota_lpm_shd.g_old_rec.attribute20
224: ,p_learning_path_section_id_o
225: => ota_lpm_shd.g_old_rec.learning_path_section_id
226: ,p_notify_days_before_target_o
227: => ota_lpm_shd.g_old_rec.notify_days_before_target
228: );
229: --
230: exception
231: --

Line 247: (p_rec in ota_lpm_shd.g_rec_type

243: -- ----------------------------------------------------------------------------
244: -- |---------------------------------< del >----------------------------------|
245: -- ----------------------------------------------------------------------------
246: Procedure del
247: (p_rec in ota_lpm_shd.g_rec_type
248: ) is
249: --
250: l_proc varchar2(72) := g_package||'del';
251: --

Line 257: ota_lpm_shd.lck

253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: -- We must lock the row which we need to delete.
256: --
257: ota_lpm_shd.lck
258: (p_rec.learning_path_member_id
259: ,p_rec.object_version_number
260: );
261: --

Line 294: l_rec ota_lpm_shd.g_rec_type;

290: (p_learning_path_member_id in number
291: ,p_object_version_number in number
292: ) is
293: --
294: l_rec ota_lpm_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'del';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);