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.AME_CFV_INS dependencies on AME_CFV_INS

Line 1: Package Body ame_cfv_ins as

1: Package Body ame_cfv_ins as
2: /* $Header: amcfvrhi.pkb 120.2 2005/11/22 03:15 santosin noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ame_cfv_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: ame_cfv_ins.g_application_id_i := p_application_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_cfv_ins.g_application_id_i := p_application_id;
29: ame_cfv_ins.g_variable_name_i := p_variable_name;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: ame_cfv_ins.g_variable_name_i := p_variable_name;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_cfv_ins.g_application_id_i := p_application_id;
29: ame_cfv_ins.g_variable_name_i := p_variable_name;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 260: ame_cfv_ins.dt_insert_dml

256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: ame_cfv_ins.dt_insert_dml
261: (p_rec => p_rec
262: ,p_effective_date => p_effective_date
263: ,p_datetrack_mode => p_datetrack_mode
264: ,p_validation_start_date => p_validation_start_date

Line 327: ame_cfv_ins.g_application_id_i

323: Cursor C_Sel2 is
324: Select null
325: from ame_config_vars
326: where application_id =
327: ame_cfv_ins.g_application_id_i
328: and variable_name =
329: ame_cfv_ins.g_variable_name_i
330: and p_effective_date between start_date
331: and nvl(end_date - ame_util.oneSecond , p_effective_date);

Line 329: ame_cfv_ins.g_variable_name_i

325: from ame_config_vars
326: where application_id =
327: ame_cfv_ins.g_application_id_i
328: and variable_name =
329: ame_cfv_ins.g_variable_name_i
330: and p_effective_date between start_date
331: and nvl(end_date - ame_util.oneSecond , p_effective_date);
332: --
333: l_proc varchar2(72) := g_package||'pre_insert';

Line 339: If (ame_cfv_ins.g_application_id_i is not null or

335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: If (ame_cfv_ins.g_application_id_i is not null or
340: ame_cfv_ins.g_variable_name_i is not null) Then
341: --
342: -- Verify registered primary key values not already in use
343: --

Line 340: ame_cfv_ins.g_variable_name_i is not null) Then

336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: If (ame_cfv_ins.g_application_id_i is not null or
340: ame_cfv_ins.g_variable_name_i is not null) Then
341: --
342: -- Verify registered primary key values not already in use
343: --
344: Open C_Sel2;

Line 360: ame_cfv_ins.g_application_id_i;

356: --
357: -- Use registered key values and clear globals
358: --
359: p_rec.application_id :=
360: ame_cfv_ins.g_application_id_i;
361: ame_cfv_ins.g_application_id_i := null;
362: p_rec.variable_name :=
363: ame_cfv_ins.g_variable_name_i;
364: ame_cfv_ins.g_variable_name_i := null;

Line 361: ame_cfv_ins.g_application_id_i := null;

357: -- Use registered key values and clear globals
358: --
359: p_rec.application_id :=
360: ame_cfv_ins.g_application_id_i;
361: ame_cfv_ins.g_application_id_i := null;
362: p_rec.variable_name :=
363: ame_cfv_ins.g_variable_name_i;
364: ame_cfv_ins.g_variable_name_i := null;
365: End If;

Line 363: ame_cfv_ins.g_variable_name_i;

359: p_rec.application_id :=
360: ame_cfv_ins.g_application_id_i;
361: ame_cfv_ins.g_application_id_i := null;
362: p_rec.variable_name :=
363: ame_cfv_ins.g_variable_name_i;
364: ame_cfv_ins.g_variable_name_i := null;
365: End If;
366: --
367: -- Set Description of the Config Variable. The 'ins' procedure does not

Line 364: ame_cfv_ins.g_variable_name_i := null;

360: ame_cfv_ins.g_application_id_i;
361: ame_cfv_ins.g_application_id_i := null;
362: p_rec.variable_name :=
363: ame_cfv_ins.g_variable_name_i;
364: ame_cfv_ins.g_variable_name_i := null;
365: End If;
366: --
367: -- Set Description of the Config Variable. The 'ins' procedure does not
368: -- contain any p_description parameter, and hence it is populated here, from

Line 548: ame_cfv_ins.ins_lck

544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Call the lock operation
547: --
548: ame_cfv_ins.ins_lck
549: (p_effective_date => p_effective_date
550: ,p_datetrack_mode => l_datetrack_mode
551: ,p_rec => p_rec
552: ,p_validation_start_date => l_validation_start_date

Line 571: ame_cfv_ins.pre_insert

567: hr_multi_message.end_validation_set;
568: --
569: -- Call the supporting pre-insert operation
570: --
571: ame_cfv_ins.pre_insert
572: (p_rec => p_rec
573: ,p_effective_date => p_effective_date
574: ,p_datetrack_mode => l_datetrack_mode
575: ,p_validation_start_date => l_validation_start_date

Line 581: ame_cfv_ins.insert_dml

577: );
578: --
579: -- Insert the row
580: --
581: ame_cfv_ins.insert_dml
582: (p_rec => p_rec
583: ,p_effective_date => p_effective_date
584: ,p_datetrack_mode => l_datetrack_mode
585: ,p_validation_start_date => l_validation_start_date

Line 591: ame_cfv_ins.post_insert

587: );
588: --
589: -- Call the supporting post-insert operation
590: --
591: ame_cfv_ins.post_insert
592: (p_rec => p_rec
593: ,p_effective_date => p_effective_date
594: ,p_datetrack_mode => l_datetrack_mode
595: ,p_validation_start_date => l_validation_start_date

Line 644: ame_cfv_ins.ins

640: -- Having converted the arguments into the ame_cfv_rec
641: -- plsql record structure we call the corresponding record
642: -- business process.
643: --
644: ame_cfv_ins.ins
645: (p_effective_date
646: ,l_rec
647: );
648: --

Line 659: end ame_cfv_ins;

655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 10);
657: End ins;
658: --
659: end ame_cfv_ins;