DBA Data[Home] [Help]

APPS.PAY_ETP_INS dependencies on PAY_ETP_INS

Line 1: Package Body pay_etp_ins as

1: Package Body pay_etp_ins as
2: /* $Header: pyetprhi.pkb 120.6.12010000.6 2009/07/30 11:56:55 npannamp ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_etp_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: pay_etp_ins.g_element_type_id_i := p_element_type_id;

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

Line 438: pay_etp_ins.dt_insert_dml

434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: pay_etp_ins.dt_insert_dml
439: (p_rec => p_rec
440: ,p_effective_date => p_effective_date
441: ,p_datetrack_mode => p_datetrack_mode
442: ,p_validation_start_date => p_validation_start_date

Line 502: pay_etp_ins.g_element_type_id_i;

498: Cursor C_Sel2 is
499: Select null
500: from pay_element_types_f
501: where element_type_id =
502: pay_etp_ins.g_element_type_id_i;
503: --
504: l_proc varchar2(72) := g_package||'pre_insert';
505: l_exists varchar2(1);
506: --

Line 510: If (pay_etp_ins.g_element_type_id_i is not null) Then

506: --
507: Begin
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: If (pay_etp_ins.g_element_type_id_i is not null) Then
511: --
512: -- Verify registered primary key values not already in use
513: --
514: Open C_Sel2;

Line 530: pay_etp_ins.g_element_type_id_i;

526: --
527: -- Use registered key values and clear globals
528: --
529: p_rec.element_type_id :=
530: pay_etp_ins.g_element_type_id_i;
531: pay_etp_ins.g_element_type_id_i := null;
532: Else
533: --
534: -- No registerd key values, so select the next sequence number

Line 531: pay_etp_ins.g_element_type_id_i := null;

527: -- Use registered key values and clear globals
528: --
529: p_rec.element_type_id :=
530: pay_etp_ins.g_element_type_id_i;
531: pay_etp_ins.g_element_type_id_i := null;
532: Else
533: --
534: -- No registerd key values, so select the next sequence number
535: --

Line 911: pay_etp_ins.ins_lck

907: hr_utility.set_location('Entering:'||l_proc, 5);
908: --
909: -- Call the lock operation
910: --
911: pay_etp_ins.ins_lck
912: (p_effective_date => p_effective_date
913: ,p_datetrack_mode => l_datetrack_mode
914: ,p_rec => p_rec
915: ,p_validation_start_date => l_validation_start_date

Line 937: pay_etp_ins.pre_insert

933: hr_multi_message.end_validation_set;
934: --
935: -- Call the supporting pre-insert operation
936: --
937: pay_etp_ins.pre_insert
938: (p_rec => p_rec
939: ,p_effective_date => p_effective_date
940: ,p_datetrack_mode => l_datetrack_mode
941: ,p_validation_start_date => l_validation_start_date

Line 947: pay_etp_ins.insert_dml

943: );
944: --
945: -- Insert the row
946: --
947: pay_etp_ins.insert_dml
948: (p_rec => p_rec
949: ,p_effective_date => p_effective_date
950: ,p_datetrack_mode => l_datetrack_mode
951: ,p_validation_start_date => l_validation_start_date

Line 957: pay_etp_ins.post_insert

953: );
954: --
955: -- Call the supporting post-insert operation
956: --
957: pay_etp_ins.post_insert
958: (p_rec => p_rec
959: ,p_effective_date => p_effective_date
960: ,p_datetrack_mode => l_datetrack_mode
961: ,p_validation_start_date => l_validation_start_date

Line 1183: pay_etp_ins.ins

1179: -- Having converted the arguments into the pay_etp_rec
1180: -- plsql record structure we call the corresponding record
1181: -- business process.
1182: --
1183: pay_etp_ins.ins
1184: (p_effective_date
1185: ,l_rec
1186: ,l_processing_priority_warning
1187: );

Line 1201: end pay_etp_ins;

1197: --
1198: hr_utility.set_location(' Leaving:'||l_proc, 10);
1199: End ins;
1200: --
1201: end pay_etp_ins;