DBA Data[Home] [Help]

APPS.PAY_AMT_INS dependencies on PAY_AMT_INS

Line 1: Package Body pay_amt_ins as

1: Package Body pay_amt_ins as
2: /* $Header: pyamtrhi.pkb 120.0.12000000.1 2007/01/17 15:30:47 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 28: pay_amt_ins.g_module_type_id_i := p_module_type_id;

24: l_proc := g_package||'set_base_key_value';
25: --
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pay_amt_ins.g_module_type_id_i := p_module_type_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);
31: End set_base_key_value;
32: --

Line 179: pay_amt_ins.g_module_type_id_i;

175: Cursor C_Sel2 is
176: Select null
177: from pay_au_module_types
178: where module_type_id =
179: pay_amt_ins.g_module_type_id_i;
180: --
181: l_proc varchar2(72);
182: l_exists varchar2(1);
183: --

Line 189: If (pay_amt_ins.g_module_type_id_i is not null) Then

185: l_proc := g_package||'pre_insert';
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: If (pay_amt_ins.g_module_type_id_i is not null) Then
190: --
191: -- Verify registered primary key values not already in use
192: --
193: Open C_Sel2;

Line 209: pay_amt_ins.g_module_type_id_i;

205: --
206: -- Use registered key values and clear globals
207: --
208: p_rec.module_type_id :=
209: pay_amt_ins.g_module_type_id_i;
210: pay_amt_ins.g_module_type_id_i := null;
211: Else
212: --
213: -- No registerd key values, so select the next sequence number

Line 210: pay_amt_ins.g_module_type_id_i := null;

206: -- Use registered key values and clear globals
207: --
208: p_rec.module_type_id :=
209: pay_amt_ins.g_module_type_id_i;
210: pay_amt_ins.g_module_type_id_i := null;
211: Else
212: --
213: -- No registerd key values, so select the next sequence number
214: --

Line 297: pay_amt_ins.pre_insert(p_rec);

293: hr_multi_message.end_validation_set;
294: --
295: -- Call the supporting pre-insert operation
296: --
297: pay_amt_ins.pre_insert(p_rec);
298: --
299: -- Insert the row
300: --
301: pay_amt_ins.insert_dml(p_rec);

Line 301: pay_amt_ins.insert_dml(p_rec);

297: pay_amt_ins.pre_insert(p_rec);
298: --
299: -- Insert the row
300: --
301: pay_amt_ins.insert_dml(p_rec);
302: --
303: -- Call the supporting post-insert operation
304: --
305: pay_amt_ins.post_insert

Line 305: pay_amt_ins.post_insert

301: pay_amt_ins.insert_dml(p_rec);
302: --
303: -- Call the supporting post-insert operation
304: --
305: pay_amt_ins.post_insert
306: (p_rec
307: );
308: --
309: -- Call to raise any errors on multi-message list

Line 349: pay_amt_ins.ins

345: --
346: -- Having converted the arguments into the pay_amt_rec
347: -- plsql record structure we call the corresponding record business process.
348: --
349: pay_amt_ins.ins
350: (l_rec
351: );
352: --
353: -- As the primary key argument(s)

Line 363: g_package := ' pay_amt_ins.'; -- Global package name

359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: End ins;
361: --
362: begin
363: g_package := ' pay_amt_ins.'; -- Global package name
364: end pay_amt_ins;

Line 364: end pay_amt_ins;

360: End ins;
361: --
362: begin
363: g_package := ' pay_amt_ins.'; -- Global package name
364: end pay_amt_ins;