54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: pay_ncr_shd.g_api_dml := true; -- Set the api dml status
62: --
82: );
83: --
84: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: pay_ncr_shd.g_api_dml := false; -- Unset the api dml status
148: --
149: Cursor C_Sel1 is select pay_net_calculation_rules_s.nextval from sys.dual;
150: --
151: Begin
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: --
155: -- Select the next sequence number
156: --
157: Open C_Sel1;
158: Fetch C_Sel1 Into p_rec.net_calculation_rule_id;
159: Close C_Sel1;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: End pre_insert;
163: --
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------< post_insert >------------------------------|
197: --
198: l_proc varchar2(72) := g_package||'post_insert';
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: --
204: -- Start of API User Hook for post_insert.
205: --
228: --
229: -- End of API User Hook for post_insert.
230: --
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 10);
233: End post_insert;
234: --
235: -- ----------------------------------------------------------------------------
236: -- |---------------------------------< ins >----------------------------------|
242: --
243: l_proc varchar2(72) := g_package||'ins';
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: -- Call the supporting insert validate operations
249: --
250: pay_ncr_bus.insert_validate(p_rec);
279: l_rec pay_ncr_shd.g_rec_type;
280: l_proc varchar2(72) := g_package||'ins';
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- Call conversion function to turn arguments into the
286: -- p_rec structure.
287: --
307: --
308: p_net_calculation_rule_id := l_rec.net_calculation_rule_id;
309: p_object_version_number := l_rec.object_version_number;
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: End ins;
313: --
314: end pay_ncr_ins;