DBA Data[Home] [Help]

APPS.PQH_TAT_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: -- Added the following code as a part of Zero Downtime Patching Project.

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

90: p_rec.object_version_number
91: );
92: --
93: --
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: Exception
96: When hr_api.check_integrity_violated Then
97: -- A check constraint has been violated
98: pqh_tat_shd.constraint_error

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

152: --
153: Cursor C_Sel1 is select pqh_template_attributes_s.nextval from sys.dual;
154: --
155: Begin
156: hr_utility.set_location('Entering:'||l_proc, 5);
157: --
158: --
159: -- Select the next sequence number
160: --

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

161: Open C_Sel1;
162: Fetch C_Sel1 Into p_rec.template_attribute_id;
163: Close C_Sel1;
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 10);
166: End pre_insert;
167: --
168: -- ----------------------------------------------------------------------------
169: -- |-----------------------------< post_insert >------------------------------|

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

202: --
203: l_proc varchar2(72) := g_package||'post_insert';
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: --
209: -- Start of API User Hook for post_insert.
210: --

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

234: --
235: -- End of API User Hook for post_insert.
236: --
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: End post_insert;
240: --
241: -- ----------------------------------------------------------------------------
242: -- |---------------------------------< ins >----------------------------------|

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

249: --
250: l_proc varchar2(72) := g_package||'ins';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: -- Call the supporting insert validate operations
256: --
257: pqh_tat_bus.insert_validate(p_rec

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

289: l_rec pqh_tat_shd.g_rec_type;
290: l_proc varchar2(72) := g_package||'ins';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- Call conversion function to turn arguments into the
296: -- p_rec structure.
297: --

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

318: --
319: p_template_attribute_id := l_rec.template_attribute_id;
320: p_object_version_number := l_rec.object_version_number;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 10);
323: End ins;
324: --
325: end pqh_tat_ins;