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_ACI_INS dependencies on OTA_ACI_INS

Line 1: Package Body ota_aci_ins as

1: Package Body ota_aci_ins as
2: /* $Header: otacirhi.pkb 120.0 2005/05/29 06:51:07 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_aci_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_aci_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 28: ota_aci_ins.g_activity_version_id_i := p_activity_version_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ota_aci_ins.g_activity_version_id_i := p_activity_version_id;
29: ota_aci_ins.g_category_usage_id_i := p_category_usage_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: ota_aci_ins.g_category_usage_id_i := p_category_usage_id;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ota_aci_ins.g_activity_version_id_i := p_activity_version_id;
29: ota_aci_ins.g_category_usage_id_i := p_category_usage_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 230: ota_aci_ins.g_activity_version_id_i

226: Cursor C_Sel2 is
227: Select null
228: from ota_act_cat_inclusions
229: where activity_version_id =
230: ota_aci_ins.g_activity_version_id_i
231: or category_usage_id =
232: ota_aci_ins.g_category_usage_id_i;
233: --
234: */

Line 232: ota_aci_ins.g_category_usage_id_i;

228: from ota_act_cat_inclusions
229: where activity_version_id =
230: ota_aci_ins.g_activity_version_id_i
231: or category_usage_id =
232: ota_aci_ins.g_category_usage_id_i;
233: --
234: */
235: l_proc varchar2(72) := g_package||'pre_insert';
236: l_exists varchar2(1);

Line 242: If (ota_aci_ins.g_activity_version_id_i is not null or

238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: /*
241: --
242: If (ota_aci_ins.g_activity_version_id_i is not null or
243: ota_aci_ins.g_category_usage_id_i is not null) Then
244: --
245: -- Verify registered primary key values not already in use
246: --

Line 243: ota_aci_ins.g_category_usage_id_i is not null) Then

239: hr_utility.set_location('Entering:'||l_proc, 5);
240: /*
241: --
242: If (ota_aci_ins.g_activity_version_id_i is not null or
243: ota_aci_ins.g_category_usage_id_i is not null) Then
244: --
245: -- Verify registered primary key values not already in use
246: --
247: Open C_Sel2;

Line 263: ota_aci_ins.g_activity_version_id_i;

259: --
260: -- Use registered key values and clear globals
261: --
262: p_rec.activity_version_id :=
263: ota_aci_ins.g_activity_version_id_i;
264: ota_aci_ins.g_activity_version_id_i := null;
265: p_rec.category_usage_id :=
266: ota_aci_ins.g_category_usage_id_i;
267: ota_aci_ins.g_category_usage_id_i := null;

Line 264: ota_aci_ins.g_activity_version_id_i := null;

260: -- Use registered key values and clear globals
261: --
262: p_rec.activity_version_id :=
263: ota_aci_ins.g_activity_version_id_i;
264: ota_aci_ins.g_activity_version_id_i := null;
265: p_rec.category_usage_id :=
266: ota_aci_ins.g_category_usage_id_i;
267: ota_aci_ins.g_category_usage_id_i := null;
268: Else

Line 266: ota_aci_ins.g_category_usage_id_i;

262: p_rec.activity_version_id :=
263: ota_aci_ins.g_activity_version_id_i;
264: ota_aci_ins.g_activity_version_id_i := null;
265: p_rec.category_usage_id :=
266: ota_aci_ins.g_category_usage_id_i;
267: ota_aci_ins.g_category_usage_id_i := null;
268: Else
269: --
270: -- No registerd key values, so select the next sequence number

Line 267: ota_aci_ins.g_category_usage_id_i := null;

263: ota_aci_ins.g_activity_version_id_i;
264: ota_aci_ins.g_activity_version_id_i := null;
265: p_rec.category_usage_id :=
266: ota_aci_ins.g_category_usage_id_i;
267: ota_aci_ins.g_category_usage_id_i := null;
268: Else
269: --
270: -- No registerd key values, so select the next sequence number
271: --

Line 425: ota_aci_ins.set_base_key_value( p_activity_version_id => l_activity_version_id

421:
422: /*p_rec.activity_version_id := null;
423: p_rec.category_usage_id := null;*/
424:
425: ota_aci_ins.set_base_key_value( p_activity_version_id => l_activity_version_id
426: ,p_category_usage_id => l_category_usage_id
427: );
428: --
429: -- Call the supporting insert validate operations

Line 443: ota_aci_ins.pre_insert(p_rec);

439: hr_multi_message.end_validation_set;
440: --
441: -- Call the supporting pre-insert operation
442: --
443: ota_aci_ins.pre_insert(p_rec);
444: --
445: -- Insert the row
446: --
447: ota_aci_ins.insert_dml(p_rec);

Line 447: ota_aci_ins.insert_dml(p_rec);

443: ota_aci_ins.pre_insert(p_rec);
444: --
445: -- Insert the row
446: --
447: ota_aci_ins.insert_dml(p_rec);
448: --
449: -- Call the supporting post-insert operation
450: --
451: ota_aci_ins.post_insert

Line 451: ota_aci_ins.post_insert

447: ota_aci_ins.insert_dml(p_rec);
448: --
449: -- Call the supporting post-insert operation
450: --
451: ota_aci_ins.post_insert
452: (p_effective_date
453: ,p_rec
454: );
455: --

Line 549: ota_aci_ins.ins

545: --
546: -- Having converted the arguments into the ota_aci_rec
547: -- plsql record structure we call the corresponding record business process.
548: --
549: ota_aci_ins.ins
550: (p_effective_date
551: ,l_rec
552: );
553: --

Line 564: end ota_aci_ins;

560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 10);
562: End ins;
563: --
564: end ota_aci_ins;