DBA Data[Home] [Help]

APPS.BEN_CPI_INS dependencies on BEN_CPI_INS

Line 1: Package Body ben_cpi_ins as

1: Package Body ben_cpi_ins as
2: /* $Header: becpirhi.pkb 120.0 2005/05/28 01:13 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 29: ben_cpi_ins.g_group_per_in_ler_id_i := p_group_per_in_ler_id;

25: if g_debug then
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: end if;
28: --
29: ben_cpi_ins.g_group_per_in_ler_id_i := p_group_per_in_ler_id;
30: --
31: if g_debug then
32: hr_utility.set_location(' Leaving:'||l_proc, 20);
33: end if;

Line 524: ben_cpi_ins.g_group_per_in_ler_id_i;

520: Cursor C_Sel2 is
521: Select null
522: from ben_cwb_person_info
523: where group_per_in_ler_id =
524: ben_cpi_ins.g_group_per_in_ler_id_i;
525: --
526: l_proc varchar2(72) := g_package||'pre_insert';
527: l_exists varchar2(1);
528: --

Line 534: If (ben_cpi_ins.g_group_per_in_ler_id_i is not null) Then

530: if g_debug then
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: end if;
533: --
534: If (ben_cpi_ins.g_group_per_in_ler_id_i is not null) Then
535: --
536: -- Verify registered primary key values not already in use
537: --
538: Open C_Sel2;

Line 554: ben_cpi_ins.g_group_per_in_ler_id_i;

550: --
551: -- Use registered key values and clear globals
552: --
553: p_rec.group_per_in_ler_id :=
554: ben_cpi_ins.g_group_per_in_ler_id_i;
555: ben_cpi_ins.g_group_per_in_ler_id_i := null;
556: Else
557: null;
558: /* --

Line 555: ben_cpi_ins.g_group_per_in_ler_id_i := null;

551: -- Use registered key values and clear globals
552: --
553: p_rec.group_per_in_ler_id :=
554: ben_cpi_ins.g_group_per_in_ler_id_i;
555: ben_cpi_ins.g_group_per_in_ler_id_i := null;
556: Else
557: null;
558: /* --
559: -- No registerd key values, so select the next sequence number

Line 971: ben_cpi_ins.pre_insert(p_rec);

967: hr_multi_message.end_validation_set;
968: --
969: -- Call the supporting pre-insert operation
970: --
971: ben_cpi_ins.pre_insert(p_rec);
972: --
973: -- Insert the row
974: --
975: ben_cpi_ins.insert_dml(p_rec);

Line 975: ben_cpi_ins.insert_dml(p_rec);

971: ben_cpi_ins.pre_insert(p_rec);
972: --
973: -- Insert the row
974: --
975: ben_cpi_ins.insert_dml(p_rec);
976: --
977: -- Call the supporting post-insert operation
978: --
979: ben_cpi_ins.post_insert

Line 979: ben_cpi_ins.post_insert

975: ben_cpi_ins.insert_dml(p_rec);
976: --
977: -- Call the supporting post-insert operation
978: --
979: ben_cpi_ins.post_insert
980: (p_rec
981: );
982: --
983: -- Call to raise any errors on multi-message list

Line 1319: ben_cpi_ins.ins

1315: --
1316: -- Having converted the arguments into the ben_cpi_rec
1317: -- plsql record structure we call the corresponding record business process.
1318: --
1319: ben_cpi_ins.ins
1320: (l_rec
1321: );
1322: --
1323: p_object_version_number := l_rec.object_version_number;

Line 1330: end ben_cpi_ins;

1326: hr_utility.set_location(' Leaving:'||l_proc, 10);
1327: end if;
1328: End ins;
1329: --
1330: end ben_cpi_ins;