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_bld_ins.g_balance_dimension_id_i := p_balance_dimension_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_bld_ins.g_balance_dimension_id_i := p_balance_dimension_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: --
132: --
133: --
134: --
180: );
181: --
182: --
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 10);
185: Exception
186: When hr_api.check_integrity_violated Then
187: -- A check constraint has been violated
188: --
255: l_proc varchar2(72) := g_package||'pre_insert';
256: l_exists varchar2(1);
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: If (pay_bld_ins.g_balance_dimension_id_i is not null) Then
262: --
263: -- Verify registered primary key values not already in use
291: Fetch C_Sel1 Into p_rec.balance_dimension_id;
292: Close C_Sel1;
293: End If;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End pre_insert;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |-----------------------------< post_insert >------------------------------|
333: --
334: l_proc varchar2(72) := g_package||'post_insert';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: begin
339: --
340: -- insert ownerships if applicable
341: create_app_ownerships
395: ,p_hook_type => 'AI');
396: --
397: end;
398: --
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: End post_insert;
401: --
402: -- ----------------------------------------------------------------------------
403: -- |---------------------------------< ins >----------------------------------|
408: --
409: l_proc varchar2(72) := g_package||'ins';
410: --
411: Begin
412: hr_utility.set_location('Entering:'||l_proc, 5);
413: --
414: -- Call the supporting insert validate operations
415: --
416: pay_bld_bus.insert_validate
436: --
437: -- Call to raise any errors on multi-message list
438: hr_multi_message.end_validation_set;
439: --
440: hr_utility.set_location('Leaving:'||l_proc, 20);
441: end ins;
442: --
443: -- ----------------------------------------------------------------------------
444: -- |---------------------------------< ins >----------------------------------|
469: l_rec pay_bld_shd.g_rec_type;
470: l_proc varchar2(72) := g_package||'ins';
471: --
472: Begin
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- Call conversion function to turn arguments into the
476: -- p_rec structure.
477: --
511: --
512: p_balance_dimension_id := l_rec.balance_dimension_id;
513: --
514: --
515: hr_utility.set_location(' Leaving:'||l_proc, 10);
516: End ins;
517: --
518: end pay_bld_ins;