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_apm_ins.g_process_module_id_i := p_process_module_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pay_apm_ins.g_process_module_id_i := p_process_module_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);
31: End set_base_key_value;
32: --
33: --
34: -- ----------------------------------------------------------------------------
82: --
83: Begin
84: l_proc := g_package||'insert_dml';
85: --
86: hr_utility.set_location('Entering:'||l_proc, 5);
87: p_rec.object_version_number := 1; -- Initialise the object version
88: --
89: pay_apm_shd.g_api_dml := true; -- Set the api dml status
90: --
108: );
109: --
110: pay_apm_shd.g_api_dml := false; -- Unset the api dml status
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 10);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: pay_apm_shd.g_api_dml := false; -- Unset the api dml status
185: --
186: Begin
187: l_proc := g_package||'pre_insert';
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: If (pay_apm_ins.g_process_module_id_i is not null) Then
192: --
193: -- Verify registered primary key values not already in use
221: Fetch C_Sel1 Into p_rec.process_module_id;
222: Close C_Sel1;
223: End If;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: End pre_insert;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |-----------------------------< post_insert >------------------------------|
265: --
266: Begin
267: l_proc := g_package||'post_insert';
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End post_insert;
273: --
267: l_proc := g_package||'post_insert';
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End post_insert;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |---------------------------------< ins >----------------------------------|
282: --
283: Begin
284: l_proc := g_package||'ins';
285: --
286: hr_utility.set_location('Entering:'||l_proc, 5);
287: --
288: -- Call the supporting insert validate operations
289: --
290: pay_apm_bus.insert_validate
310: --
311: -- Call to raise any errors on multi-message list
312: hr_multi_message.end_validation_set;
313: --
314: hr_utility.set_location('Leaving:'||l_proc, 20);
315: end ins;
316: --
317: -- ----------------------------------------------------------------------------
318: -- |---------------------------------< ins >----------------------------------|
331: --
332: Begin
333: l_proc := g_package||'ins';
334: --
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- Call conversion function to turn arguments into the
338: -- p_rec structure.
339: --
359: --
360: p_process_module_id := l_rec.process_module_id;
361: p_object_version_number := l_rec.object_version_number;
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: End ins;
365: --
366: begin
367: g_package := ' pay_apm_ins.'; -- Global package name