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_periods
94: p_rec.budget_unit1_available
95: );
96: --
97: --
98: hr_utility.set_location(' Leaving:'||l_proc, 10);
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
102: pqh_wpr_shd.constraint_error
156: --
157: Cursor C_Sel1 is select pqh_worksheet_periods_s.nextval from sys.dual;
158: --
159: Begin
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: --
162: --
163: -- Select the next sequence number
164: --
165: Open C_Sel1;
166: Fetch C_Sel1 Into p_rec.worksheet_period_id;
167: Close C_Sel1;
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: End pre_insert;
171: --
172: -- ----------------------------------------------------------------------------
173: -- |-----------------------------< post_insert >------------------------------|
206: --
207: l_proc varchar2(72) := g_package||'post_insert';
208: --
209: Begin
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: --
213: -- Start of API User Hook for post_insert.
214: --
248: --
249: -- End of API User Hook for post_insert.
250: --
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: End post_insert;
254: --
255: -- ----------------------------------------------------------------------------
256: -- |---------------------------------< ins >----------------------------------|
263: --
264: l_proc varchar2(72) := g_package||'ins';
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269: -- Call the supporting insert validate operations
270: --
271: pqh_wpr_bus.insert_validate(p_rec
313: l_rec pqh_wpr_shd.g_rec_type;
314: l_proc varchar2(72) := g_package||'ins';
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: -- Call conversion function to turn arguments into the
320: -- p_rec structure.
321: --
352: --
353: p_worksheet_period_id := l_rec.worksheet_period_id;
354: p_object_version_number := l_rec.object_version_number;
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: End ins;
358: --
359: end pqh_wpr_ins;