22: --
23: Begin
24: l_proc := g_package||'set_base_key_value';
25: --
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pay_amo_ins.g_module_id_i := p_module_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pay_amo_ins.g_module_id_i := p_module_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);
31: End set_base_key_value;
32: --
33: --
34: -- ----------------------------------------------------------------------------
130: --
131: Begin
132: l_proc := g_package||'insert_dml';
133: --
134: hr_utility.set_location('Entering:'||l_proc, 5);
135: p_rec.object_version_number := 1; -- Initialise the object version
136: --
137: pay_amo_shd.g_api_dml := true; -- Set the api dml status
138: --
166: );
167: --
168: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: Exception
172: When hr_api.check_integrity_violated Then
173: -- A check constraint has been violated
174: pay_amo_shd.g_api_dml := false; -- Unset the api dml status
243: --
244: Begin
245: l_proc := g_package||'pre_insert';
246: --
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: If (pay_amo_ins.g_module_id_i is not null) Then
250: --
251: -- Verify registered primary key values not already in use
279: Fetch C_Sel1 Into p_rec.module_id;
280: Close C_Sel1;
281: End If;
282: --
283: hr_utility.set_location(' Leaving:'||l_proc, 10);
284: End pre_insert;
285: --
286: -- ----------------------------------------------------------------------------
287: -- |-----------------------------< post_insert >------------------------------|
323: --
324: Begin
325: l_proc := g_package||'post_insert';
326: --
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: begin
329: --
330: -- insert ownerships if applicable
331: create_app_ownerships
334: --
335: --
336: end;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 10);
339: End post_insert;
340: --
341: -- ----------------------------------------------------------------------------
342: -- |---------------------------------< ins >----------------------------------|
349: --
350: Begin
351: l_proc := g_package||'ins';
352: --
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: --
355: -- Call the supporting insert validate operations
356: --
357: pay_amo_bus.insert_validate
377: --
378: -- Call to raise any errors on multi-message list
379: hr_multi_message.end_validation_set;
380: --
381: hr_utility.set_location('Leaving:'||l_proc, 20);
382: end ins;
383: --
384: -- ----------------------------------------------------------------------------
385: -- |---------------------------------< ins >----------------------------------|
403: --
404: Begin
405: l_proc := g_package||'ins';
406: --
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- Call conversion function to turn arguments into the
410: -- p_rec structure.
411: --
436: --
437: p_module_id := l_rec.module_id;
438: p_object_version_number := l_rec.object_version_number;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: End ins;
442: --
443: begin
444: g_package := ' pay_amo_ins.'; -- Global package name