APPS.PER_PPB_INS dependencies on PER_PPB_INS

Line 1: Package Body per_ppb_ins as

1: Package Body per_ppb_ins as
2: /* $Header: peppbrhi.pkb 120.0 2005/05/31 14:56:26 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_ppb_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: per_ppb_ins.g_pay_basis_id_i := p_pay_basis_id;

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

Line 277: per_ppb_ins.g_pay_basis_id_i;

273: Cursor C_Sel2 is
274: Select null
275: from per_pay_bases
276: where pay_basis_id =
277: per_ppb_ins.g_pay_basis_id_i;
278: --
279: l_proc varchar2(72) := g_package||'pre_insert';
280: l_exists varchar2(1);
281: l_rec per_ppb_shd.g_rec_type;

Line 287: If (per_ppb_ins.g_pay_basis_id_i is not null) Then

283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: l_rec := p_rec;
286: --
287: If (per_ppb_ins.g_pay_basis_id_i is not null) Then
288: --
289: -- Verify registered primary key values not already in use
290: --
291: Open C_Sel2;

Line 307: per_ppb_ins.g_pay_basis_id_i;

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

Line 308: per_ppb_ins.g_pay_basis_id_i := null;

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

Line 517: per_ppb_ins.pre_insert(p_rec);

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

Line 521: per_ppb_ins.insert_dml(p_rec);

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

Line 525: per_ppb_ins.post_insert

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

Line 667: per_ppb_ins.ins

663: --
664: -- Having converted the arguments into the per_ppb_rec
665: -- plsql record structure we call the corresponding record business process.
666: --
667: per_ppb_ins.ins
668: (l_rec
669: );
670: --
671: -- As the primary key argument(s)

Line 685: end per_ppb_ins;

681: p_object_version_number := null;
682: Raise;
683: End ins;
684: --
685: end per_ppb_ins;