[Home] [Help]
20: --
21: l_proc VARCHAR2(72) := g_package||'set_base_key_value';
22: --
23: BEGIN
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_pyr_ins.g_rate_id_i := p_rate_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_pyr_ins.g_rate_id_i := p_rate_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: END set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
78: --
79: l_proc VARCHAR2(72) := g_package||'insert_dml';
80: --
81: BEGIN
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: pay_pyr_shd.g_api_dml := TRUE; -- Set the api dml status
86: --
162: );
163: --
164: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: EXCEPTION
168: WHEN hr_api.check_integrity_violated THEN
169: -- A check constraint has been violated
170: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
237: l_proc VARCHAR2(72) := g_package||'pre_insert';
238: l_exists VARCHAR2(1);
239: --
240: BEGIN
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: IF (pay_pyr_ins.g_rate_id_i IS not NULL) THEN
244: --
245: -- Verify registered primary key values not already IN use
273: FETCH C_Sel1 INTO p_rec.rate_id;
274: CLOSE C_Sel1;
275: END IF;
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 10);
278: END pre_insert;
279: --
280: -- ----------------------------------------------------------------------------
281: -- |-----------------------------< post_insert >------------------------------|
316: --
317: l_proc VARCHAR2(72) := g_package||'post_insert';
318: --
319: BEGIN
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: BEGIN
322: --
323: pay_pyr_rki.after_insert
324: (p_effective_date => p_effective_date
403: ,p_hook_type => 'AI');
404: --
405: END;
406: --
407: hr_utility.set_location(' Leaving:'||l_proc, 10);
408: END post_insert;
409: --
410: -- ----------------------------------------------------------------------------
411: -- |---------------------------------< ins >----------------------------------|
417: --
418: l_proc VARCHAR2(72) := g_package||'ins';
419: --
420: BEGIN
421: hr_utility.set_location('Entering:'||l_proc, 5);
422: --
423: -- Call the supporting insert validate operations
424: --
425: pay_pyr_bus.insert_validate
447: --
448: -- Call to raise any errors on multi-message list
449: hr_multi_message.end_validation_set;
450: --
451: hr_utility.set_location('Leaving:'||l_proc, 20);
452: END ins;
453: --
454: -- ----------------------------------------------------------------------------
455: -- |---------------------------------< ins >----------------------------------|
496: l_rec pay_pyr_shd.g_rec_type;
497: l_proc VARCHAR2(72) := g_package||'ins';
498: --
499: BEGIN
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Call conversion function to turn arguments INTO the
503: -- p_rec structure.
504: --
550: --
551: p_rate_id := l_rec.rate_id;
552: p_object_version_number := l_rec.object_version_number;
553: --
554: hr_utility.set_location(' Leaving:'||l_proc, 10);
555: END ins;
556: --
557: END pay_pyr_ins;