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: -- Insert the row into: pqh_template_attributes

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

74: p_rec.object_version_number
75: );
76: --
77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: pqh_tat_shd.constraint_error

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

136: --
137: Cursor C_Sel1 is select pqh_template_attributes_s.nextval from sys.dual;
138: --
139: Begin
140: hr_utility.set_location('Entering:'||l_proc, 5);
141: --
142: --
143: -- Select the next sequence number
144: --

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

145: Open C_Sel1;
146: Fetch C_Sel1 Into p_rec.template_attribute_id;
147: Close C_Sel1;
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_insert;
151: --
152: -- ----------------------------------------------------------------------------
153: -- |-----------------------------< post_insert >------------------------------|

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

186: --
187: l_proc varchar2(72) := g_package||'post_insert';
188: --
189: Begin
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: --
193: -- Start of API User Hook for post_insert.
194: --

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

218: --
219: -- End of API User Hook for post_insert.
220: --
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 10);
223: End post_insert;
224: --
225: -- ----------------------------------------------------------------------------
226: -- |---------------------------------< ins >----------------------------------|

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

233: --
234: l_proc varchar2(72) := g_package||'ins';
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: -- Call the supporting insert validate operations
240: --
241: pqh_tat_bus.insert_validate(p_rec

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

273: l_rec pqh_tat_shd.g_rec_type;
274: l_proc varchar2(72) := g_package||'ins';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- Call conversion function to turn arguments into the
280: -- p_rec structure.
281: --

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

302: --
303: p_template_attribute_id := l_rec.template_attribute_id;
304: p_object_version_number := l_rec.object_version_number;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: End ins;
308: --
309: end pqh_tat_ins;