eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_TDU_INS dependencies on PAY_TDU_INS

Line 1: Package Body pay_tdu_ins as

1: Package Body pay_tdu_ins as
2: /* $Header: pytdurhi.pkb 120.2 2005/10/14 07:07 adkumar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pay_tdu_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_tdu_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 28: pay_tdu_ins.g_time_definition_id_i := p_time_definition_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pay_tdu_ins.g_time_definition_id_i := p_time_definition_id;
29: pay_tdu_ins.g_usage_type_i := p_usage_type;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: pay_tdu_ins.g_usage_type_i := p_usage_type;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pay_tdu_ins.g_time_definition_id_i := p_time_definition_id;
29: pay_tdu_ins.g_usage_type_i := p_usage_type;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 172: pay_tdu_ins.g_time_definition_id_i

168: Cursor C_Sel2 is
169: Select null
170: from pay_time_def_usages
171: where time_definition_id =
172: pay_tdu_ins.g_time_definition_id_i
173: and usage_type =
174: pay_tdu_ins.g_usage_type_i;
175: --
176: l_proc varchar2(72) := g_package||'pre_insert';

Line 174: pay_tdu_ins.g_usage_type_i;

170: from pay_time_def_usages
171: where time_definition_id =
172: pay_tdu_ins.g_time_definition_id_i
173: and usage_type =
174: pay_tdu_ins.g_usage_type_i;
175: --
176: l_proc varchar2(72) := g_package||'pre_insert';
177: l_exists varchar2(1);
178: --

Line 182: If (pay_tdu_ins.g_time_definition_id_i is not null or

178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: If (pay_tdu_ins.g_time_definition_id_i is not null or
183: pay_tdu_ins.g_usage_type_i is not null) Then
184: --
185: -- Verify registered primary key values not already in use
186: --

Line 183: pay_tdu_ins.g_usage_type_i is not null) Then

179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: If (pay_tdu_ins.g_time_definition_id_i is not null or
183: pay_tdu_ins.g_usage_type_i is not null) Then
184: --
185: -- Verify registered primary key values not already in use
186: --
187: Open C_Sel2;

Line 203: pay_tdu_ins.g_time_definition_id_i;

199: --
200: -- Use registered key values and clear globals
201: --
202: p_rec.time_definition_id :=
203: pay_tdu_ins.g_time_definition_id_i;
204: pay_tdu_ins.g_time_definition_id_i := null;
205: p_rec.usage_type :=
206: pay_tdu_ins.g_usage_type_i;
207: pay_tdu_ins.g_usage_type_i := null;

Line 204: pay_tdu_ins.g_time_definition_id_i := null;

200: -- Use registered key values and clear globals
201: --
202: p_rec.time_definition_id :=
203: pay_tdu_ins.g_time_definition_id_i;
204: pay_tdu_ins.g_time_definition_id_i := null;
205: p_rec.usage_type :=
206: pay_tdu_ins.g_usage_type_i;
207: pay_tdu_ins.g_usage_type_i := null;
208:

Line 206: pay_tdu_ins.g_usage_type_i;

202: p_rec.time_definition_id :=
203: pay_tdu_ins.g_time_definition_id_i;
204: pay_tdu_ins.g_time_definition_id_i := null;
205: p_rec.usage_type :=
206: pay_tdu_ins.g_usage_type_i;
207: pay_tdu_ins.g_usage_type_i := null;
208:
209: End If;
210: --

Line 207: pay_tdu_ins.g_usage_type_i := null;

203: pay_tdu_ins.g_time_definition_id_i;
204: pay_tdu_ins.g_time_definition_id_i := null;
205: p_rec.usage_type :=
206: pay_tdu_ins.g_usage_type_i;
207: pay_tdu_ins.g_usage_type_i := null;
208:
209: End If;
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 305: pay_tdu_ins.pre_insert(p_rec);

301: hr_multi_message.end_validation_set;
302: --
303: -- Call the supporting pre-insert operation
304: --
305: pay_tdu_ins.pre_insert(p_rec);
306: --
307: -- Insert the row
308: --
309: pay_tdu_ins.insert_dml(p_rec);

Line 309: pay_tdu_ins.insert_dml(p_rec);

305: pay_tdu_ins.pre_insert(p_rec);
306: --
307: -- Insert the row
308: --
309: pay_tdu_ins.insert_dml(p_rec);
310: --
311: -- Call the supporting post-insert operation
312: --
313: pay_tdu_ins.post_insert

Line 313: pay_tdu_ins.post_insert

309: pay_tdu_ins.insert_dml(p_rec);
310: --
311: -- Call the supporting post-insert operation
312: --
313: pay_tdu_ins.post_insert
314: (p_effective_date
315: ,p_rec
316: );
317: --

Line 353: pay_tdu_ins.ins

349: --
350: -- Having converted the arguments into the pay_tdu_rec
351: -- plsql record structure we call the corresponding record business process.
352: --
353: pay_tdu_ins.ins
354: (p_effective_date
355: ,l_rec
356: );
357: --

Line 366: end pay_tdu_ins;

362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: End ins;
365: --
366: end pay_tdu_ins;