DBA Data[Home] [Help]

APPS.PAY_SID_INS dependencies on HR_UTILITY

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

79: l_last_updated_by pay_ie_prsi_details_f.last_updated_by%TYPE;
80: l_last_update_login pay_ie_prsi_details_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 190: hr_utility.set_location(' Leaving:'||l_proc, 15);

186: ,l_last_update_login
187: );
188: --
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 15);
191: --
192: Exception
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated

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

218: --
219: l_proc varchar2(72) := g_package||'insert_dml';
220: --
221: Begin
222: hr_utility.set_location('Entering:'||l_proc, 5);
223: --
224: pay_sid_ins.dt_insert_dml
225: (p_rec => p_rec
226: ,p_effective_date => p_effective_date

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

228: ,p_validation_start_date => p_validation_start_date
229: ,p_validation_end_date => p_validation_end_date
230: );
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 10);
233: End insert_dml;
234: --
235: -- ----------------------------------------------------------------------------
236: -- |------------------------------< pre_insert >------------------------------|

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

283: --
284: Cursor C_Sel1 is select pay_ie_prsi_details_s.nextval from sys.dual;
285: --
286: Begin
287: hr_utility.set_location('Entering:'||l_proc, 5);
288: --
289: --
290: -- Select the next sequence number
291: --

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

293: Fetch C_Sel1 Into p_rec.prsi_details_id;
294: Close C_Sel1;
295: --
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 10);
298: End pre_insert;
299: --
300: -- ----------------------------------------------------------------------------
301: -- |----------------------------< post_insert >-------------------------------|

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

339: --
340: l_proc varchar2(72) := g_package||'post_insert';
341: --
342: Begin
343: hr_utility.set_location('Entering:'||l_proc, 5);
344: begin
345: --
346: pay_sid_rki.after_insert
347: (p_effective_date

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

401: ,p_hook_type => 'AI');
402: --
403: end;
404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: End post_insert;
407: --
408: -- ----------------------------------------------------------------------------
409: -- |-------------------------------< ins_lck >--------------------------------|

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

453: l_validation_start_date date;
454: l_validation_end_date date;
455: --
456: Begin
457: hr_utility.set_location('Entering:'||l_proc, 5);
458: --
459: -- Validate the datetrack mode mode getting the validation start
460: -- and end dates for the specified datetrack operation.
461: --

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

477: --
478: p_validation_start_date := l_validation_start_date;
479: p_validation_end_date := l_validation_end_date;
480: --
481: hr_utility.set_location(' Leaving:'||l_proc, 10);
482: --
483: End ins_lck;
484: --
485: -- ----------------------------------------------------------------------------

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

495: l_validation_start_date date;
496: l_validation_end_date date;
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- Call the lock operation
502: --
503: pay_sid_ins.ins_lck

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

547: ,p_validation_start_date => l_validation_start_date
548: ,p_validation_end_date => l_validation_end_date
549: );
550: --
551: hr_utility.set_location('Leaving:'||l_proc,10);
552: end ins;
553: --
554: -- ----------------------------------------------------------------------------
555: -- |---------------------------------< ins >----------------------------------|

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

581: l_rec pay_sid_shd.g_rec_type;
582: l_proc varchar2(72) := g_package||'ins';
583: --
584: Begin
585: hr_utility.set_location('Entering:'||l_proc, 5);
586: --
587: -- Call conversion function to turn arguments into the
588: -- p_rec structure.
589: --

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

627: p_effective_end_date := l_rec.effective_end_date;
628: p_object_version_number := l_rec.object_version_number;
629: --
630: --
631: hr_utility.set_location(' Leaving:'||l_proc, 10);
632: End ins;
633: --
634: end pay_sid_ins;