APPS.PQH_CRD_INS dependencies on PQH_CRD_INS

Line 1: Package Body pqh_crd_ins as

1: Package Body pqh_crd_ins as
2: /* $Header: pqcrdrhi.pkb 120.0 2005/05/29 01:45 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_crd_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_crd_ins.g_criteria_rate_defn_id_i := p_criteria_rate_defn_id;

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

Line 311: pqh_crd_ins.g_criteria_rate_defn_id_i;

307: Cursor C_Sel2 is
308: Select null
309: from pqh_criteria_rate_defn
310: where criteria_rate_defn_id =
311: pqh_crd_ins.g_criteria_rate_defn_id_i;
312: --
313: l_proc varchar2(72) := g_package||'pre_insert';
314: l_exists varchar2(1);
315: --

Line 319: If (pqh_crd_ins.g_criteria_rate_defn_id_i is not null) Then

315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: If (pqh_crd_ins.g_criteria_rate_defn_id_i is not null) Then
320: --
321: -- Verify registered primary key values not already in use
322: --
323: Open C_Sel2;

Line 339: pqh_crd_ins.g_criteria_rate_defn_id_i;

335: --
336: -- Use registered key values and clear globals
337: --
338: p_rec.criteria_rate_defn_id :=
339: pqh_crd_ins.g_criteria_rate_defn_id_i;
340: pqh_crd_ins.g_criteria_rate_defn_id_i := null;
341: Else
342: --
343: -- No registerd key values, so select the next sequence number

Line 340: pqh_crd_ins.g_criteria_rate_defn_id_i := null;

336: -- Use registered key values and clear globals
337: --
338: p_rec.criteria_rate_defn_id :=
339: pqh_crd_ins.g_criteria_rate_defn_id_i;
340: pqh_crd_ins.g_criteria_rate_defn_id_i := null;
341: Else
342: --
343: -- No registerd key values, so select the next sequence number
344: --

Line 545: pqh_crd_ins.pre_insert(p_rec);

541: hr_multi_message.end_validation_set;
542: --
543: -- Call the supporting pre-insert operation
544: --
545: pqh_crd_ins.pre_insert(p_rec);
546: --
547: -- Insert the row
548: --
549: pqh_crd_ins.insert_dml(p_rec);

Line 549: pqh_crd_ins.insert_dml(p_rec);

545: pqh_crd_ins.pre_insert(p_rec);
546: --
547: -- Insert the row
548: --
549: pqh_crd_ins.insert_dml(p_rec);
550: --
551: -- Call the supporting post-insert operation
552: --
553: pqh_crd_ins.post_insert

Line 553: pqh_crd_ins.post_insert

549: pqh_crd_ins.insert_dml(p_rec);
550: --
551: -- Call the supporting post-insert operation
552: --
553: pqh_crd_ins.post_insert
554: (p_effective_date
555: ,p_rec
556: );
557: --

Line 685: pqh_crd_ins.ins

681: --
682: -- Having converted the arguments into the pqh_crd_rec
683: -- plsql record structure we call the corresponding record business process.
684: --
685: pqh_crd_ins.ins
686: (p_effective_date
687: ,l_rec
688: );
689: --

Line 699: end pqh_crd_ins;

695: --
696: hr_utility.set_location(' Leaving:'||l_proc, 10);
697: End ins;
698: --
699: end pqh_crd_ins;