[Home] [Help]
22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ota_cpr_ins.g_activity_version_id_i := p_activity_version_id;
29: ota_cpr_ins.g_prerequisite_course_id_i := p_prerequisite_course_id;
30: --
27: --
28: ota_cpr_ins.g_activity_version_id_i := p_activity_version_id;
29: ota_cpr_ins.g_prerequisite_course_id_i := p_prerequisite_course_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------
81: --
82: l_proc varchar2(72) := g_package||'insert_dml';
83: --
84: Begin
85: hr_utility.set_location('Entering:'||l_proc, 5);
86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: --
89: --
107: );
108: --
109: --
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
185: l_exists varchar2(1);
186: --
187:
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: /*
191: --
192: If (ota_cpr_ins.g_activity_version_id_i is not null or
193: ota_cpr_ins.g_prerequisite_course_id_i is not null) Then
229:
230: End If;
231: --
232: */
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: End pre_insert;
235: --
236: -- ----------------------------------------------------------------------------
237: -- |-----------------------------< post_insert >------------------------------|
272: --
273: l_proc varchar2(72) := g_package||'post_insert';
274: --
275: Begin
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: begin
278: --
279: ota_cpr_rki.after_insert
280: (p_effective_date => p_effective_date
301: ,p_hook_type => 'AI');
302: --
303: end;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: End post_insert;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |---------------------------------< ins >----------------------------------|
317: l_activity_version_id OTA_COURSE_PREREQUISITES.activity_version_id%TYPE;
318: l_prerequisite_course_id OTA_COURSE_PREREQUISITES.prerequisite_course_id%TYPE;
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --Bug 5586350: Calling set_base_key_value to set global location. Coding standard for elbow tables.
323: ota_cpr_ins.set_base_key_value( p_activity_version_id => p_rec.activity_version_id
324: ,p_prerequisite_course_id => p_rec.prerequisite_course_id
325: );
353: --
354: -- Call to raise any errors on multi-message list
355: hr_multi_message.end_validation_set;
356: --
357: hr_utility.set_location('Leaving:'||l_proc, 20);
358: end ins;
359: --
360: -- ----------------------------------------------------------------------------
361: -- |---------------------------------< ins >----------------------------------|
375: l_rec ota_cpr_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'ins';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: -- Call conversion function to turn arguments into the
382: -- p_rec structure.
383: --
405: -- p_activity_version_id := l_rec.activity_version_id;
406: -- p_prerequisite_course_id := l_rec.prerequisite_course_id;
407: p_object_version_number := l_rec.object_version_number;
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 10);
410: End ins;
411: --
412: end ota_cpr_ins;