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_LCI_DEL dependencies on OTA_LCI_SHD

Line 52: (p_rec in ota_lci_shd.g_rec_type

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

Line 76: ota_lci_shd.constraint_error

72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: ota_lci_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_lci_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_lci_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_lci_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_lci_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin

Line 171: => ota_lci_shd.g_old_rec.primary_flag

167: => p_rec.learning_path_id
168: ,p_category_usage_id
169: => p_rec.category_usage_id
170: ,p_primary_flag_o
171: => ota_lci_shd.g_old_rec.primary_flag
172: ,p_start_date_active_o
173: => ota_lci_shd.g_old_rec.start_date_active
174: ,p_end_date_active_o
175: => ota_lci_shd.g_old_rec.end_date_active

Line 173: => ota_lci_shd.g_old_rec.start_date_active

169: => p_rec.category_usage_id
170: ,p_primary_flag_o
171: => ota_lci_shd.g_old_rec.primary_flag
172: ,p_start_date_active_o
173: => ota_lci_shd.g_old_rec.start_date_active
174: ,p_end_date_active_o
175: => ota_lci_shd.g_old_rec.end_date_active
176: ,p_object_version_number_o
177: => ota_lci_shd.g_old_rec.object_version_number

Line 175: => ota_lci_shd.g_old_rec.end_date_active

171: => ota_lci_shd.g_old_rec.primary_flag
172: ,p_start_date_active_o
173: => ota_lci_shd.g_old_rec.start_date_active
174: ,p_end_date_active_o
175: => ota_lci_shd.g_old_rec.end_date_active
176: ,p_object_version_number_o
177: => ota_lci_shd.g_old_rec.object_version_number
178: ,p_attribute_category_o
179: => ota_lci_shd.g_old_rec.attribute_category

Line 177: => ota_lci_shd.g_old_rec.object_version_number

173: => ota_lci_shd.g_old_rec.start_date_active
174: ,p_end_date_active_o
175: => ota_lci_shd.g_old_rec.end_date_active
176: ,p_object_version_number_o
177: => ota_lci_shd.g_old_rec.object_version_number
178: ,p_attribute_category_o
179: => ota_lci_shd.g_old_rec.attribute_category
180: ,p_attribute1_o
181: => ota_lci_shd.g_old_rec.attribute1

Line 179: => ota_lci_shd.g_old_rec.attribute_category

175: => ota_lci_shd.g_old_rec.end_date_active
176: ,p_object_version_number_o
177: => ota_lci_shd.g_old_rec.object_version_number
178: ,p_attribute_category_o
179: => ota_lci_shd.g_old_rec.attribute_category
180: ,p_attribute1_o
181: => ota_lci_shd.g_old_rec.attribute1
182: ,p_attribute2_o
183: => ota_lci_shd.g_old_rec.attribute2

Line 181: => ota_lci_shd.g_old_rec.attribute1

177: => ota_lci_shd.g_old_rec.object_version_number
178: ,p_attribute_category_o
179: => ota_lci_shd.g_old_rec.attribute_category
180: ,p_attribute1_o
181: => ota_lci_shd.g_old_rec.attribute1
182: ,p_attribute2_o
183: => ota_lci_shd.g_old_rec.attribute2
184: ,p_attribute3_o
185: => ota_lci_shd.g_old_rec.attribute3

Line 183: => ota_lci_shd.g_old_rec.attribute2

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

Line 185: => ota_lci_shd.g_old_rec.attribute3

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

Line 187: => ota_lci_shd.g_old_rec.attribute4

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

Line 189: => ota_lci_shd.g_old_rec.attribute5

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

Line 191: => ota_lci_shd.g_old_rec.attribute6

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

Line 193: => ota_lci_shd.g_old_rec.attribute7

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

Line 195: => ota_lci_shd.g_old_rec.attribute8

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

Line 197: => ota_lci_shd.g_old_rec.attribute9

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

Line 199: => ota_lci_shd.g_old_rec.attribute10

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

Line 201: => ota_lci_shd.g_old_rec.attribute11

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

Line 203: => ota_lci_shd.g_old_rec.attribute12

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

Line 205: => ota_lci_shd.g_old_rec.attribute13

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

Line 207: => ota_lci_shd.g_old_rec.attribute14

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

Line 209: => ota_lci_shd.g_old_rec.attribute15

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

Line 211: => ota_lci_shd.g_old_rec.attribute16

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

Line 213: => ota_lci_shd.g_old_rec.attribute17

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

Line 215: => ota_lci_shd.g_old_rec.attribute18

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

Line 217: => ota_lci_shd.g_old_rec.attribute19

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

Line 219: => ota_lci_shd.g_old_rec.attribute20

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

Line 239: (p_rec in ota_lci_shd.g_rec_type

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

Line 249: ota_lci_shd.lck

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

Line 288: l_rec ota_lci_shd.g_rec_type;

284: ,p_category_usage_id in number
285: ,p_object_version_number in number
286: ) is
287: --
288: l_rec ota_lci_shd.g_rec_type;
289: l_proc varchar2(72) := g_package||'del';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);