APPS.PQH_CPD_INS dependencies on PQH_CPD_INS

Line 1: Package Body pqh_cpd_ins as

1: Package Body pqh_cpd_ins as
2: /* $Header: pqcpdrhi.pkb 120.0 2005/05/29 01:44:39 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_cpd_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 31: pqh_cpd_ins.g_corps_definition_id_i := p_corps_definition_id;

27: l_proc := g_package||'set_base_key_value';
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: end if;
30: --
31: pqh_cpd_ins.g_corps_definition_id_i := p_corps_definition_id;
32: --
33: if g_debug then
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: end if;

Line 287: pqh_cpd_ins.g_corps_definition_id_i;

283: Cursor C_Sel2 is
284: Select null
285: from pqh_corps_definitions
286: where corps_definition_id =
287: pqh_cpd_ins.g_corps_definition_id_i;
288: --
289: l_proc varchar2(72);
290: l_exists varchar2(1);
291: --

Line 298: If (pqh_cpd_ins.g_corps_definition_id_i is not null) Then

294: l_proc := g_package||'pre_insert';
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: end if;
297: --
298: If (pqh_cpd_ins.g_corps_definition_id_i is not null) Then
299: --
300: -- Verify registered primary key values not already in use
301: --
302: Open C_Sel2;

Line 318: pqh_cpd_ins.g_corps_definition_id_i;

314: --
315: -- Use registered key values and clear globals
316: --
317: p_rec.corps_definition_id :=
318: pqh_cpd_ins.g_corps_definition_id_i;
319: pqh_cpd_ins.g_corps_definition_id_i := null;
320: Else
321: --
322: -- No registerd key values, so select the next sequence number

Line 319: pqh_cpd_ins.g_corps_definition_id_i := null;

315: -- Use registered key values and clear globals
316: --
317: p_rec.corps_definition_id :=
318: pqh_cpd_ins.g_corps_definition_id_i;
319: pqh_cpd_ins.g_corps_definition_id_i := null;
320: Else
321: --
322: -- No registerd key values, so select the next sequence number
323: --

Line 540: pqh_cpd_ins.pre_insert(p_rec);

536: hr_multi_message.end_validation_set;
537: --
538: -- Call the supporting pre-insert operation
539: --
540: pqh_cpd_ins.pre_insert(p_rec);
541: --
542: -- Insert the row
543: --
544: pqh_cpd_ins.insert_dml(p_rec);

Line 544: pqh_cpd_ins.insert_dml(p_rec);

540: pqh_cpd_ins.pre_insert(p_rec);
541: --
542: -- Insert the row
543: --
544: pqh_cpd_ins.insert_dml(p_rec);
545: --
546: -- Call the supporting post-insert operation
547: --
548: pqh_cpd_ins.post_insert

Line 548: pqh_cpd_ins.post_insert

544: pqh_cpd_ins.insert_dml(p_rec);
545: --
546: -- Call the supporting post-insert operation
547: --
548: pqh_cpd_ins.post_insert
549: (p_effective_date
550: ,p_rec
551: );
552: --

Line 698: pqh_cpd_ins.ins

694: --
695: -- Having converted the arguments into the pqh_cpd_rec
696: -- plsql record structure we call the corresponding record business process.
697: --
698: pqh_cpd_ins.ins
699: (p_effective_date
700: ,l_rec
701: );
702: --

Line 714: end pqh_cpd_ins;

710: hr_utility.set_location(' Leaving:'||l_proc, 10);
711: end if;
712: End ins;
713: --
714: end pqh_cpd_ins;