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_budgets
114: p_rec.dflt_budget_set_id
115: );
116: --
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: pqh_bgt_shd.constraint_error
178: --
179: Cursor C_Sel1 is select pqh_budgets_s.nextval from sys.dual;
180: --
181: Begin
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: --
185: -- Select the next sequence number
186: --
193: THEN
194: p_rec.transfer_to_gl_flag :='Y';
195: END IF;
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: End pre_insert;
199: --
200: -- ----------------------------------------------------------------------------
201: -- |-----------------------------< post_insert >------------------------------|
234: --
235: l_proc varchar2(72) := g_package||'post_insert';
236: --
237: Begin
238: hr_utility.set_location('Entering:'||l_proc, 5);
239: --
240: --
241: -- Start of API User Hook for post_insert.
242: --
286: --
287: -- End of API User Hook for post_insert.
288: --
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
291: End post_insert;
292: --
293: -- ----------------------------------------------------------------------------
294: -- |---------------------------------< ins >----------------------------------|
301: --
302: l_proc varchar2(72) := g_package||'ins';
303: --
304: Begin
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: -- Call the supporting insert validate operations
308: --
309: pqh_bgt_bus.insert_validate(p_rec
361: l_rec pqh_bgt_shd.g_rec_type;
362: l_proc varchar2(72) := g_package||'ins';
363: --
364: Begin
365: hr_utility.set_location('Entering:'||l_proc, 5);
366: --
367: -- Call conversion function to turn arguments into the
368: -- p_rec structure.
369: --
410: --
411: p_budget_id := l_rec.budget_id;
412: p_object_version_number := l_rec.object_version_number;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: End ins;
416: --
417: end pqh_bgt_ins;