APPS.PQH_REI_INS dependencies on PQH_REI_INS

Line 1: Package Body pqh_rei_ins as

1: Package Body pqh_rei_ins as
2: /* $Header: pqreirhi.pkb 115.3 2002/12/03 20:42:51 rpasapul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_rei_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_rei_ins.g_role_extra_info_id_i := p_role_extra_info_id;

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

Line 306: pqh_rei_ins.g_role_extra_info_id_i;

302: Cursor C_Sel2 is
303: Select null
304: from pqh_role_extra_info
305: where role_extra_info_id =
306: pqh_rei_ins.g_role_extra_info_id_i;
307: --
308: l_proc varchar2(72) := g_package||'pre_insert';
309: l_exists varchar2(1);
310: --

Line 314: If (pqh_rei_ins.g_role_extra_info_id_i is not null) Then

310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: If (pqh_rei_ins.g_role_extra_info_id_i is not null) Then
315: --
316: -- Verify registered primary key values not already in use
317: --
318: Open C_Sel2;

Line 334: pqh_rei_ins.g_role_extra_info_id_i;

330: --
331: -- Use registered key values and clear globals
332: --
333: p_rec.role_extra_info_id :=
334: pqh_rei_ins.g_role_extra_info_id_i;
335: pqh_rei_ins.g_role_extra_info_id_i := null;
336: Else
337: --
338: -- No registerd key values, so select the next sequence number

Line 335: pqh_rei_ins.g_role_extra_info_id_i := null;

331: -- Use registered key values and clear globals
332: --
333: p_rec.role_extra_info_id :=
334: pqh_rei_ins.g_role_extra_info_id_i;
335: pqh_rei_ins.g_role_extra_info_id_i := null;
336: Else
337: --
338: -- No registerd key values, so select the next sequence number
339: --

Line 512: pqh_rei_ins.pre_insert(p_rec);

508: );
509:
510: -- Call the supporting pre-insert operation
511: --
512: pqh_rei_ins.pre_insert(p_rec);
513: --
514: -- Insert the row
515: --
516: pqh_rei_ins.insert_dml(p_rec);

Line 516: pqh_rei_ins.insert_dml(p_rec);

512: pqh_rei_ins.pre_insert(p_rec);
513: --
514: -- Insert the row
515: --
516: pqh_rei_ins.insert_dml(p_rec);
517: --
518: -- Call the supporting post-insert operation
519: --
520: pqh_rei_ins.post_insert

Line 520: pqh_rei_ins.post_insert

516: pqh_rei_ins.insert_dml(p_rec);
517: --
518: -- Call the supporting post-insert operation
519: --
520: pqh_rei_ins.post_insert
521: (p_rec
522: );
523: --
524: --

Line 708: pqh_rei_ins.ins

704: --
705: -- Having converted the arguments into the pqh_rei_rec
706: -- plsql record structure we call the corresponding record business process.
707: --
708: pqh_rei_ins.ins
709: (l_rec
710: ,p_validate
711: );
712: --

Line 722: end pqh_rei_ins;

718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 10);
720: End ins;
721: --
722: end pqh_rei_ins;