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_put_ins.g_user_table_id_i := p_user_table_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_put_ins.g_user_table_id_i := p_user_table_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: pay_put_shd.g_api_dml := true; -- Set the api dml status
134: --
156: );
157: --
158: pay_put_shd.g_api_dml := false; -- Unset the api dml status
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: pay_put_shd.g_api_dml := false; -- Unset the api dml status
231: l_proc varchar2(72) := g_package||'pre_insert';
232: l_exists varchar2(1);
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: If (pay_put_ins.g_user_table_id_i is not null) Then
238: --
239: -- Verify registered primary key values not already in use
267: Fetch C_Sel1 Into p_rec.user_table_id;
268: Close C_Sel1;
269: End If;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: End pre_insert;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |-----------------------------< post_insert >------------------------------|
310: --
311: l_proc varchar2(72) := g_package||'post_insert';
312: --
313: Begin
314: hr_utility.set_location('Entering:'||l_proc, 5);
315: begin
316: --
317: -- insert ownerships if applicable
318: create_app_ownerships
350: ,p_hook_type => 'AI');
351: --
352: end;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: End post_insert;
356: --
357: -- ----------------------------------------------------------------------------
358: -- |---------------------------------< ins >----------------------------------|
364: --
365: l_proc varchar2(72) := g_package||'ins';
366: --
367: Begin
368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: -- Call the supporting insert validate operations
371: --
372: pay_put_bus.insert_validate
394: --
395: -- Call to raise any errors on multi-message list
396: hr_multi_message.end_validation_set;
397: --
398: hr_utility.set_location('Leaving:'||l_proc, 20);
399: end ins;
400: --
401: -- ----------------------------------------------------------------------------
402: -- |---------------------------------< ins >----------------------------------|
416: l_rec pay_put_shd.g_rec_type;
417: l_proc varchar2(72) := g_package||'ins';
418: --
419: Begin
420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: -- Call conversion function to turn arguments into the
423: -- p_rec structure.
424: --
447: --
448: p_user_table_id := l_rec.user_table_id;
449: p_object_version_number := l_rec.object_version_number;
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: End ins;
453: --
454: end pay_put_ins;