DBA Data[Home] [Help]

APPS.PQP_AAT_INS dependencies on HR_UTILITY

Line 83: hr_utility.set_location('Entering:'||l_proc, 5);

79: l_last_updated_by pqp_assignment_attributes_f.last_updated_by%TYPE;
80: l_last_update_login pqp_assignment_attributes_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=

Line 104: hr_utility.set_location(l_proc, 10);

100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> hr_api.g_insert) then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --
108: Open C_Sel1;

Line 314: hr_utility.set_location(' Leaving:'||l_proc, 15);

310: ,l_last_update_login
311: );
312: --
313: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
314: hr_utility.set_location(' Leaving:'||l_proc, 15);
315: --
316: Exception
317: When hr_api.check_integrity_violated Then
318: -- A check constraint has been violated

Line 346: hr_utility.set_location('Entering:'||l_proc, 5);

342: --
343: l_proc varchar2(72) := g_package||'insert_dml';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: pqp_aat_ins.dt_insert_dml
349: (p_rec => p_rec
350: ,p_effective_date => p_effective_date

Line 356: hr_utility.set_location(' Leaving:'||l_proc, 10);

352: ,p_validation_start_date => p_validation_start_date
353: ,p_validation_end_date => p_validation_end_date
354: );
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: End insert_dml;
358: --
359: -- ---------------------------------------------------------------------------+
360: -- |------------------------------< pre_insert >------------------------------|

Line 411: hr_utility.set_location('Entering:'||l_proc, 5);

407: --
408: Cursor C_Sel1 is select pqp_assignment_attributes_s.nextval from sys.dual;
409: --
410: Begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: --
414: -- Select the next sequence number
415: --

Line 421: hr_utility.set_location(' Leaving:'||l_proc, 10);

417: Fetch C_Sel1 Into p_rec.assignment_attribute_id;
418: Close C_Sel1;
419: --
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 10);
422: End pre_insert;
423: --
424: -- ---------------------------------------------------------------------------+
425: -- |----------------------------< post_insert >-------------------------------|

Line 467: hr_utility.set_location('Entering:'||l_proc, 5);

463: --
464: l_proc varchar2(72) := g_package||'post_insert';
465: --
466: Begin
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: begin
469: --
470: pqp_aat_rki.after_insert
471: (p_effective_date

Line 653: hr_utility.set_location(' Leaving:'||l_proc, 10);

649: ,p_hook_type => 'AI');
650: --
651: end;
652: --
653: hr_utility.set_location(' Leaving:'||l_proc, 10);
654: End post_insert;
655: --
656: -- ---------------------------------------------------------------------------+
657: -- |-------------------------------< ins_lck >--------------------------------|

Line 705: hr_utility.set_location('Entering:'||l_proc, 5);

701: l_validation_start_date date;
702: l_validation_end_date date;
703: --
704: Begin
705: hr_utility.set_location('Entering:'||l_proc, 5);
706: --
707: -- Validate the datetrack mode mode getting the validation start
708: -- and end dates for the specified datetrack operation.
709: --

Line 726: hr_utility.set_location(' Leaving:'||l_proc, 10);

722: --
723: p_validation_start_date := l_validation_start_date;
724: p_validation_end_date := l_validation_end_date;
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);
727: --
728: End ins_lck;
729: --
730: -- ---------------------------------------------------------------------------+

Line 744: hr_utility.set_location('Entering:'||l_proc, 5);

740: l_validation_start_date date;
741: l_validation_end_date date;
742: --
743: Begin
744: hr_utility.set_location('Entering:'||l_proc, 5);
745: --
746: -- Call the lock operation
747: --
748: pqp_aat_ins.ins_lck

Line 796: hr_utility.set_location('Leaving:'||l_proc,10);

792: ,p_validation_start_date => l_validation_start_date
793: ,p_validation_end_date => l_validation_end_date
794: );
795: --
796: hr_utility.set_location('Leaving:'||l_proc,10);
797: end ins;
798: --
799: -- ---------------------------------------------------------------------------+
800: -- |---------------------------------< ins >----------------------------------|

Line 892: hr_utility.set_location('Entering:'||l_proc, 5);

888: l_rec pqp_aat_shd.g_rec_type;
889: l_proc varchar2(72) := g_package||'ins';
890: --
891: Begin
892: hr_utility.set_location('Entering:'||l_proc, 5);
893: --
894: -- Call conversion function to turn arguments into the
895: -- p_rec structure.
896: --

Line 1000: hr_utility.set_location(' Leaving:'||l_proc, 10);

996: p_effective_end_date := l_rec.effective_end_date;
997: p_object_version_number := l_rec.object_version_number;
998: --
999: --
1000: hr_utility.set_location(' Leaving:'||l_proc, 10);
1001: End ins;
1002: --
1003: end pqp_aat_ins;