DBA Data[Home] [Help]

APPS.PQH_WDT_INS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: pqh_worksheet_details

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

120: p_rec.propagation_method
121: );
122: --
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: pqh_wdt_shd.constraint_error

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

182: --
183: Cursor C_Sel1 is select pqh_worksheet_details_s.nextval from sys.dual;
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: --
189: -- Select the next sequence number
190: --

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

191: Open C_Sel1;
192: Fetch C_Sel1 Into p_rec.worksheet_detail_id;
193: Close C_Sel1;
194: --
195: hr_utility.set_location(' Leaving:'||l_proc, 10);
196: End pre_insert;
197: --
198: -- ----------------------------------------------------------------------------
199: -- |-----------------------------< post_insert >------------------------------|

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

232: --
233: l_proc varchar2(72) := g_package||'post_insert';
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: --
239: -- Start of API User Hook for post_insert.
240: --

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

287: --
288: -- End of API User Hook for post_insert.
289: --
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 10);
292: End post_insert;
293: --
294: -- ----------------------------------------------------------------------------
295: -- |---------------------------------< ins >----------------------------------|

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

302: --
303: l_proc varchar2(72) := g_package||'ins';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: -- Call the supporting insert validate operations
309: --
310: pqh_wdt_bus.insert_validate(p_rec

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

365: l_rec pqh_wdt_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'ins';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- Call conversion function to turn arguments into the
372: -- p_rec structure.
373: --

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

417: --
418: p_worksheet_detail_id := l_rec.worksheet_detail_id;
419: p_object_version_number := l_rec.object_version_number;
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 10);
422: End ins;
423: --
424: end pqh_wdt_ins;