APPS.BEN_RTS_INS dependencies on BEN_RTS_INS

Line 1: Package Body ben_rts_ins as

1: Package Body ben_rts_ins as
2: /* $Header: bertsrhi.pkb 120.1 2006/01/09 14:37 maagrawa noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_rts_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_rts_ins.g_person_rate_id_i := p_person_rate_id;

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

Line 278: ben_rts_ins.g_person_rate_id_i;

274: Cursor C_Sel2 is
275: Select null
276: from ben_cwb_person_rates
277: where person_rate_id =
278: ben_rts_ins.g_person_rate_id_i;
279: --
280: l_proc varchar2(72) := g_package||'pre_insert';
281: l_exists varchar2(1);
282: --

Line 288: If (ben_rts_ins.g_person_rate_id_i is not null) Then

284: if g_debug then
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: end if;
287: --
288: If (ben_rts_ins.g_person_rate_id_i is not null) Then
289: --
290: -- Verify registered primary key values not already in use
291: --
292: Open C_Sel2;

Line 308: ben_rts_ins.g_person_rate_id_i;

304: --
305: -- Use registered key values and clear globals
306: --
307: p_rec.person_rate_id :=
308: ben_rts_ins.g_person_rate_id_i;
309: ben_rts_ins.g_person_rate_id_i := null;
310: Else
311: --
312: -- No registerd key values, so select the next sequence number

Line 309: ben_rts_ins.g_person_rate_id_i := null;

305: -- Use registered key values and clear globals
306: --
307: p_rec.person_rate_id :=
308: ben_rts_ins.g_person_rate_id_i;
309: ben_rts_ins.g_person_rate_id_i := null;
310: Else
311: --
312: -- No registerd key values, so select the next sequence number
313: --

Line 518: ben_rts_ins.pre_insert(p_rec);

514: hr_multi_message.end_validation_set;
515: --
516: -- Call the supporting pre-insert operation
517: --
518: ben_rts_ins.pre_insert(p_rec);
519: --
520: -- Insert the row
521: --
522: ben_rts_ins.insert_dml(p_rec);

Line 522: ben_rts_ins.insert_dml(p_rec);

518: ben_rts_ins.pre_insert(p_rec);
519: --
520: -- Insert the row
521: --
522: ben_rts_ins.insert_dml(p_rec);
523: --
524: -- Call the supporting post-insert operation
525: --
526: ben_rts_ins.post_insert

Line 526: ben_rts_ins.post_insert

522: ben_rts_ins.insert_dml(p_rec);
523: --
524: -- Call the supporting post-insert operation
525: --
526: ben_rts_ins.post_insert
527: (p_rec
528: );
529: --
530: -- Call to raise any errors on multi-message list

Line 666: ben_rts_ins.ins

662: --
663: -- Having converted the arguments into the ben_rts_rec
664: -- plsql record structure we call the corresponding record business process.
665: --
666: ben_rts_ins.ins
667: (l_rec
668: );
669: --
670: --

Line 683: end ben_rts_ins;

679: hr_utility.set_location(' Leaving:'||l_proc, 10);
680: end if;
681: End ins;
682: --
683: end ben_rts_ins;