DBA Data[Home] [Help]

APPS.PQH_SAT_INS dependencies on HR_UTILITY

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

51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin
55: hr_utility.set_location('Entering:'||l_proc, 5);
56: p_rec.object_version_number := 1; -- Initialise the object version
57: --
58: --
59: -- Added the following code as a part of Zero Downtime Patching Project.

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

98: p_rec.context
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: pqh_sat_shd.constraint_error

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

160: --
161: Cursor C_Sel1 is select pqh_special_attributes_s.nextval from sys.dual;
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: --
167: -- Select the next sequence number
168: --

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

169: Open C_Sel1;
170: Fetch C_Sel1 Into p_rec.special_attribute_id;
171: Close C_Sel1;
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: End pre_insert;
175: --
176: -- ----------------------------------------------------------------------------
177: -- |-----------------------------< post_insert >------------------------------|

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

210: --
211: l_proc varchar2(72) := g_package||'post_insert';
212: --
213: Begin
214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: --
217: -- Start of API User Hook for post_insert.
218: --

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

245: --
246: -- End of API User Hook for post_insert.
247: --
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 10);
250: End post_insert;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |---------------------------------< ins >----------------------------------|

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

260: --
261: l_proc varchar2(72) := g_package||'ins';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: -- Call the supporting insert validate operations
267: --
268: pqh_sat_bus.insert_validate(p_rec

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

303: l_rec pqh_sat_shd.g_rec_type;
304: l_proc varchar2(72) := g_package||'ins';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- Call conversion function to turn arguments into the
310: -- p_rec structure.
311: --

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

335: --
336: p_special_attribute_id := l_rec.special_attribute_id;
337: p_object_version_number := l_rec.object_version_number;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End ins;
341: --
342: end pqh_sat_ins;