APPS.PQH_ACC_INS dependencies on PQH_ACC_INS

Line 1: Package Body pqh_acc_ins as

1: Package Body pqh_acc_ins as
2: /* $Header: pqaccrhi.pkb 115.4 2004/03/15 23:54:54 svorugan noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_acc_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 26: pqh_acc_ins.g_accommodation_id_i := p_accommodation_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqh_acc_ins.g_accommodation_id_i := p_accommodation_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 394: pqh_acc_ins.dt_insert_dml

390: --
391: Begin
392: hr_utility.set_location('Entering:'||l_proc, 5);
393: --
394: pqh_acc_ins.dt_insert_dml
395: (p_rec => p_rec
396: ,p_effective_date => p_effective_date
397: ,p_datetrack_mode => p_datetrack_mode
398: ,p_validation_start_date => p_validation_start_date

Line 458: pqh_acc_ins.g_accommodation_id_i;

454: Cursor C_Sel2 is
455: Select null
456: from pqh_accommodations_f
457: where accommodation_id =
458: pqh_acc_ins.g_accommodation_id_i;
459: --
460: l_proc varchar2(72) := g_package||'pre_insert';
461: l_exists varchar2(1);
462: --

Line 466: If (pqh_acc_ins.g_accommodation_id_i is not null) Then

462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: If (pqh_acc_ins.g_accommodation_id_i is not null) Then
467: --
468: -- Verify registered primary key values not already in use
469: --
470: Open C_Sel2;

Line 486: pqh_acc_ins.g_accommodation_id_i;

482: --
483: -- Use registered key values and clear globals
484: --
485: p_rec.accommodation_id :=
486: pqh_acc_ins.g_accommodation_id_i;
487: pqh_acc_ins.g_accommodation_id_i := null;
488: Else
489: --
490: -- No registerd key values, so select the next sequence number

Line 487: pqh_acc_ins.g_accommodation_id_i := null;

483: -- Use registered key values and clear globals
484: --
485: p_rec.accommodation_id :=
486: pqh_acc_ins.g_accommodation_id_i;
487: pqh_acc_ins.g_accommodation_id_i := null;
488: Else
489: --
490: -- No registerd key values, so select the next sequence number
491: --

Line 852: pqh_acc_ins.ins_lck

848: hr_utility.set_location('Entering:'||l_proc, 5);
849: --
850: -- Call the lock operation
851: --
852: pqh_acc_ins.ins_lck
853: (p_effective_date => p_effective_date
854: ,p_datetrack_mode => l_datetrack_mode
855: ,p_rec => p_rec
856: ,p_validation_start_date => l_validation_start_date

Line 875: pqh_acc_ins.pre_insert

871: hr_multi_message.end_validation_set;
872: --
873: -- Call the supporting pre-insert operation
874: --
875: pqh_acc_ins.pre_insert
876: (p_rec => p_rec
877: ,p_effective_date => p_effective_date
878: ,p_datetrack_mode => l_datetrack_mode
879: ,p_validation_start_date => l_validation_start_date

Line 885: pqh_acc_ins.insert_dml

881: );
882: --
883: -- Insert the row
884: --
885: pqh_acc_ins.insert_dml
886: (p_rec => p_rec
887: ,p_effective_date => p_effective_date
888: ,p_datetrack_mode => l_datetrack_mode
889: ,p_validation_start_date => l_validation_start_date

Line 895: pqh_acc_ins.post_insert

891: );
892: --
893: -- Call the supporting post-insert operation
894: --
895: pqh_acc_ins.post_insert
896: (p_rec => p_rec
897: ,p_effective_date => p_effective_date
898: ,p_datetrack_mode => l_datetrack_mode
899: ,p_validation_start_date => l_validation_start_date

Line 1121: pqh_acc_ins.ins

1117: -- Having converted the arguments into the pqh_acc_rec
1118: -- plsql record structure we call the corresponding record
1119: -- business process.
1120: --
1121: pqh_acc_ins.ins
1122: (p_effective_date
1123: ,l_rec
1124: );
1125: --

Line 1137: end pqh_acc_ins;

1133: --
1134: hr_utility.set_location(' Leaving:'||l_proc, 10);
1135: End ins;
1136: --
1137: end pqh_acc_ins;