[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_tdf_ins.g_time_definition_id_i := p_time_definition_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_tdf_ins.g_time_definition_id_i := p_time_definition_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_tdf_shd.g_api_dml := true; -- Set the api dml status
134: --
172: );
173: --
174: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 10);
177: Exception
178: When hr_api.check_integrity_violated Then
179: -- A check constraint has been violated
180: pay_tdf_shd.g_api_dml := false; -- Unset the api dml status
247: l_proc varchar2(72) := g_package||'pre_insert';
248: l_exists varchar2(1);
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: If (pay_tdf_ins.g_time_definition_id_i is not null) Then
254: --
255: -- Verify registered primary key values not already in use
283: Fetch C_Sel1 Into p_rec.time_definition_id;
284: Close C_Sel1;
285: End If;
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: End pre_insert;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |-----------------------------< post_insert >------------------------------|
326: --
327: l_proc varchar2(72) := g_package||'post_insert';
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: begin
332: --
333: -- insert ownerships if applicable
334: create_app_ownerships
381: ,p_hook_type => 'AI');
382: --
383: end;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: End post_insert;
387: --
388: -- ----------------------------------------------------------------------------
389: -- |---------------------------------< ins >----------------------------------|
395: --
396: l_proc varchar2(72) := g_package||'ins';
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Call the supporting insert validate operations
402: --
403: pay_tdf_bus.insert_validate
425: --
426: -- Call to raise any errors on multi-message list
427: hr_multi_message.end_validation_set;
428: --
429: hr_utility.set_location('Leaving:'||l_proc, 20);
430: end ins;
431: --
432: -- ----------------------------------------------------------------------------
433: -- |---------------------------------< ins >----------------------------------|
455: l_rec pay_tdf_shd.g_rec_type;
456: l_proc varchar2(72) := g_package||'ins';
457: --
458: Begin
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: -- Call conversion function to turn arguments into the
462: -- p_rec structure.
463: --
494: --
495: p_time_definition_id := l_rec.time_definition_id;
496: p_object_version_number := l_rec.object_version_number;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc, 10);
499: End ins;
500: --
501: end pay_tdf_ins;