DBA Data[Home] [Help]

APPS.PQH_TJR_INS dependencies on HR_UTILITY

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

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --

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

142: );
143: --
144: --
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: Exception
148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: --

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

210: --
211: Cursor C_Sel1 is select pqh_txn_job_requirements_s.nextval from sys.dual;
212: --
213: Begin
214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: --
217: -- Select the next sequence number
218: --

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

219: Open C_Sel1;
220: Fetch C_Sel1 Into p_rec.txn_job_requirement_id;
221: Close C_Sel1;
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: End pre_insert;
225: --
226: -- ----------------------------------------------------------------------------
227: -- |-----------------------------< post_insert >------------------------------|

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

261: --
262: l_proc varchar2(72) := g_package||'post_insert';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: begin
267: --
268: pqh_tjr_rki.after_insert
269: (p_txn_job_requirement_id

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

349: ,p_hook_type => 'AI');
350: --
351: end;
352: --
353: hr_utility.set_location(' Leaving:'||l_proc, 10);
354: End post_insert;
355: --
356: -- ----------------------------------------------------------------------------
357: -- |---------------------------------< ins >----------------------------------|

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

362: --
363: l_proc varchar2(72) := g_package||'ins';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- Call the supporting insert validate operations
369: --
370: pqh_tjr_bus.insert_validate

Line 388: hr_utility.set_location('Leaving:'||l_proc, 20);

384: pqh_tjr_ins.post_insert
385: (p_rec
386: );
387: --
388: hr_utility.set_location('Leaving:'||l_proc, 20);
389: end ins;
390: --
391: -- ----------------------------------------------------------------------------
392: -- |---------------------------------< ins >----------------------------------|

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

433: l_rec pqh_tjr_shd.g_rec_type;
434: l_proc varchar2(72) := g_package||'ins';
435: --
436: Begin
437: hr_utility.set_location('Entering:'||l_proc, 5);
438: --
439: -- Call conversion function to turn arguments into the
440: -- p_rec structure.
441: --

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

491: --
492: p_txn_job_requirement_id := l_rec.txn_job_requirement_id;
493: p_object_version_number := l_rec.object_version_number;
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 10);
496: End ins;
497: --
498: end pqh_tjr_ins;