DBA Data[Home] [Help]

APPS.PQH_RHA_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 102: hr_utility.set_location(' Leaving:'||l_proc, 10);

98: );
99: --
100: --
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: --

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

166: --
167: Cursor C_Sel1 is select pqh_routing_hist_attribs_s.nextval from sys.dual;
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: --
173: -- Select the next sequence number
174: --

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

175: Open C_Sel1;
176: Fetch C_Sel1 Into p_rec.routing_hist_attrib_id;
177: Close C_Sel1;
178: --
179: hr_utility.set_location(' Leaving:'||l_proc, 10);
180: End pre_insert;
181: --
182: -- ----------------------------------------------------------------------------
183: -- |-----------------------------< post_insert >------------------------------|

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

218: --
219: l_proc varchar2(72) := g_package||'post_insert';
220: --
221: Begin
222: hr_utility.set_location('Entering:'||l_proc, 5);
223: begin
224: --
225: pqh_rha_rki.after_insert
226: (p_effective_date => p_effective_date

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

263: ,p_hook_type => 'AI');
264: --
265: end;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: End post_insert;
269: --
270: -- ----------------------------------------------------------------------------
271: -- |---------------------------------< ins >----------------------------------|

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

277: --
278: l_proc varchar2(72) := g_package||'ins';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- Call the supporting insert validate operations
284: --
285: pqh_rha_bus.insert_validate

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

301: (p_effective_date
302: ,p_rec
303: );
304: --
305: hr_utility.set_location('Leaving:'||l_proc, 20);
306: end ins;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |---------------------------------< ins >----------------------------------|

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

329: l_rec pqh_rha_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --

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

366: --
367: p_routing_hist_attrib_id := l_rec.routing_hist_attrib_id;
368: p_object_version_number := l_rec.object_version_number;
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 10);
371: End ins;
372: --
373: end pqh_rha_ins;