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_TXR_INS dependencies on PAY_TXR_INS

Line 1: Package Body pay_txr_ins as

1: Package Body pay_txr_ins as
2: /* $Header: pytxrrhi.pkb 120.0 2005/05/29 09:09 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_txr_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 36: pay_txr_ins.g_jurisdiction_code_i := p_jurisdiction_code;

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 10);
35: --
36: pay_txr_ins.g_jurisdiction_code_i := p_jurisdiction_code;
37: pay_txr_ins.g_tax_type_i := p_tax_type;
38: pay_txr_ins.g_tax_category_i := p_tax_category;
39: pay_txr_ins.g_classification_id_i := p_classification_id;
40: pay_txr_ins.g_taxability_rules_date_id_i := p_taxability_rules_date_id;

Line 37: pay_txr_ins.g_tax_type_i := p_tax_type;

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 10);
35: --
36: pay_txr_ins.g_jurisdiction_code_i := p_jurisdiction_code;
37: pay_txr_ins.g_tax_type_i := p_tax_type;
38: pay_txr_ins.g_tax_category_i := p_tax_category;
39: pay_txr_ins.g_classification_id_i := p_classification_id;
40: pay_txr_ins.g_taxability_rules_date_id_i := p_taxability_rules_date_id;
41: pay_txr_ins.g_secondary_class_id_i := p_secondary_classification_id;

Line 38: pay_txr_ins.g_tax_category_i := p_tax_category;

34: hr_utility.set_location('Entering:'||l_proc, 10);
35: --
36: pay_txr_ins.g_jurisdiction_code_i := p_jurisdiction_code;
37: pay_txr_ins.g_tax_type_i := p_tax_type;
38: pay_txr_ins.g_tax_category_i := p_tax_category;
39: pay_txr_ins.g_classification_id_i := p_classification_id;
40: pay_txr_ins.g_taxability_rules_date_id_i := p_taxability_rules_date_id;
41: pay_txr_ins.g_secondary_class_id_i := p_secondary_classification_id;
42: --

Line 39: pay_txr_ins.g_classification_id_i := p_classification_id;

35: --
36: pay_txr_ins.g_jurisdiction_code_i := p_jurisdiction_code;
37: pay_txr_ins.g_tax_type_i := p_tax_type;
38: pay_txr_ins.g_tax_category_i := p_tax_category;
39: pay_txr_ins.g_classification_id_i := p_classification_id;
40: pay_txr_ins.g_taxability_rules_date_id_i := p_taxability_rules_date_id;
41: pay_txr_ins.g_secondary_class_id_i := p_secondary_classification_id;
42: --
43: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 40: pay_txr_ins.g_taxability_rules_date_id_i := p_taxability_rules_date_id;

36: pay_txr_ins.g_jurisdiction_code_i := p_jurisdiction_code;
37: pay_txr_ins.g_tax_type_i := p_tax_type;
38: pay_txr_ins.g_tax_category_i := p_tax_category;
39: pay_txr_ins.g_classification_id_i := p_classification_id;
40: pay_txr_ins.g_taxability_rules_date_id_i := p_taxability_rules_date_id;
41: pay_txr_ins.g_secondary_class_id_i := p_secondary_classification_id;
42: --
43: hr_utility.set_location(' Leaving:'||l_proc, 20);
44: End set_base_key_value;

Line 41: pay_txr_ins.g_secondary_class_id_i := p_secondary_classification_id;

37: pay_txr_ins.g_tax_type_i := p_tax_type;
38: pay_txr_ins.g_tax_category_i := p_tax_category;
39: pay_txr_ins.g_classification_id_i := p_classification_id;
40: pay_txr_ins.g_taxability_rules_date_id_i := p_taxability_rules_date_id;
41: pay_txr_ins.g_secondary_class_id_i := p_secondary_classification_id;
42: --
43: hr_utility.set_location(' Leaving:'||l_proc, 20);
44: End set_base_key_value;
45: --

Line 217: pay_txr_ins.g_jurisdiction_code_i

213: Cursor C_Sel2 is
214: Select null
215: from pay_taxability_rules
216: where jurisdiction_code =
217: pay_txr_ins.g_jurisdiction_code_i
218: or tax_type =
219: pay_txr_ins.g_tax_type_i
220: or tax_category =
221: pay_txr_ins.g_tax_category_i

Line 219: pay_txr_ins.g_tax_type_i

215: from pay_taxability_rules
216: where jurisdiction_code =
217: pay_txr_ins.g_jurisdiction_code_i
218: or tax_type =
219: pay_txr_ins.g_tax_type_i
220: or tax_category =
221: pay_txr_ins.g_tax_category_i
222: or classification_id =
223: pay_txr_ins.g_classification_id_i

Line 221: pay_txr_ins.g_tax_category_i

217: pay_txr_ins.g_jurisdiction_code_i
218: or tax_type =
219: pay_txr_ins.g_tax_type_i
220: or tax_category =
221: pay_txr_ins.g_tax_category_i
222: or classification_id =
223: pay_txr_ins.g_classification_id_i
224: or secondary_classification_id =
225: pay_txr_ins.g_secondary_class_id_i

Line 223: pay_txr_ins.g_classification_id_i

219: pay_txr_ins.g_tax_type_i
220: or tax_category =
221: pay_txr_ins.g_tax_category_i
222: or classification_id =
223: pay_txr_ins.g_classification_id_i
224: or secondary_classification_id =
225: pay_txr_ins.g_secondary_class_id_i
226: or taxability_rules_date_id =
227: pay_txr_ins.g_taxability_rules_date_id_i;

Line 225: pay_txr_ins.g_secondary_class_id_i

221: pay_txr_ins.g_tax_category_i
222: or classification_id =
223: pay_txr_ins.g_classification_id_i
224: or secondary_classification_id =
225: pay_txr_ins.g_secondary_class_id_i
226: or taxability_rules_date_id =
227: pay_txr_ins.g_taxability_rules_date_id_i;
228: --
229: l_proc varchar2(72) := g_package||'pre_insert';

Line 227: pay_txr_ins.g_taxability_rules_date_id_i;

223: pay_txr_ins.g_classification_id_i
224: or secondary_classification_id =
225: pay_txr_ins.g_secondary_class_id_i
226: or taxability_rules_date_id =
227: pay_txr_ins.g_taxability_rules_date_id_i;
228: --
229: l_proc varchar2(72) := g_package||'pre_insert';
230: l_exists varchar2(1);
231: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;

Line 236: If (pay_txr_ins.g_jurisdiction_code_i is not null or

232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: If (pay_txr_ins.g_jurisdiction_code_i is not null or
237: pay_txr_ins.g_tax_type_i is not null or
238: pay_txr_ins.g_tax_category_i is not null or
239: pay_txr_ins.g_classification_id_i is not null or
240: pay_txr_ins.g_taxability_rules_date_id_i is not null or

Line 237: pay_txr_ins.g_tax_type_i is not null or

233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: If (pay_txr_ins.g_jurisdiction_code_i is not null or
237: pay_txr_ins.g_tax_type_i is not null or
238: pay_txr_ins.g_tax_category_i is not null or
239: pay_txr_ins.g_classification_id_i is not null or
240: pay_txr_ins.g_taxability_rules_date_id_i is not null or
241: pay_txr_ins.g_secondary_class_id_i is not null) Then

Line 238: pay_txr_ins.g_tax_category_i is not null or

234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: If (pay_txr_ins.g_jurisdiction_code_i is not null or
237: pay_txr_ins.g_tax_type_i is not null or
238: pay_txr_ins.g_tax_category_i is not null or
239: pay_txr_ins.g_classification_id_i is not null or
240: pay_txr_ins.g_taxability_rules_date_id_i is not null or
241: pay_txr_ins.g_secondary_class_id_i is not null) Then
242: --

Line 239: pay_txr_ins.g_classification_id_i is not null or

235: --
236: If (pay_txr_ins.g_jurisdiction_code_i is not null or
237: pay_txr_ins.g_tax_type_i is not null or
238: pay_txr_ins.g_tax_category_i is not null or
239: pay_txr_ins.g_classification_id_i is not null or
240: pay_txr_ins.g_taxability_rules_date_id_i is not null or
241: pay_txr_ins.g_secondary_class_id_i is not null) Then
242: --
243: -- Verify registered primary key values not already in use

Line 240: pay_txr_ins.g_taxability_rules_date_id_i is not null or

236: If (pay_txr_ins.g_jurisdiction_code_i is not null or
237: pay_txr_ins.g_tax_type_i is not null or
238: pay_txr_ins.g_tax_category_i is not null or
239: pay_txr_ins.g_classification_id_i is not null or
240: pay_txr_ins.g_taxability_rules_date_id_i is not null or
241: pay_txr_ins.g_secondary_class_id_i is not null) Then
242: --
243: -- Verify registered primary key values not already in use
244: --

Line 241: pay_txr_ins.g_secondary_class_id_i is not null) Then

237: pay_txr_ins.g_tax_type_i is not null or
238: pay_txr_ins.g_tax_category_i is not null or
239: pay_txr_ins.g_classification_id_i is not null or
240: pay_txr_ins.g_taxability_rules_date_id_i is not null or
241: pay_txr_ins.g_secondary_class_id_i is not null) Then
242: --
243: -- Verify registered primary key values not already in use
244: --
245: Open C_Sel2;

Line 261: pay_txr_ins.g_jurisdiction_code_i;

257: --
258: -- Use registered key values and clear globals
259: --
260: p_rec.jurisdiction_code :=
261: pay_txr_ins.g_jurisdiction_code_i;
262: pay_txr_ins.g_jurisdiction_code_i := null;
263:
264: p_rec.tax_type :=
265: pay_txr_ins.g_tax_type_i;

Line 262: pay_txr_ins.g_jurisdiction_code_i := null;

258: -- Use registered key values and clear globals
259: --
260: p_rec.jurisdiction_code :=
261: pay_txr_ins.g_jurisdiction_code_i;
262: pay_txr_ins.g_jurisdiction_code_i := null;
263:
264: p_rec.tax_type :=
265: pay_txr_ins.g_tax_type_i;
266: pay_txr_ins.g_tax_type_i := null;

Line 265: pay_txr_ins.g_tax_type_i;

261: pay_txr_ins.g_jurisdiction_code_i;
262: pay_txr_ins.g_jurisdiction_code_i := null;
263:
264: p_rec.tax_type :=
265: pay_txr_ins.g_tax_type_i;
266: pay_txr_ins.g_tax_type_i := null;
267:
268: p_rec.tax_category :=
269: pay_txr_ins.g_tax_category_i;

Line 266: pay_txr_ins.g_tax_type_i := null;

262: pay_txr_ins.g_jurisdiction_code_i := null;
263:
264: p_rec.tax_type :=
265: pay_txr_ins.g_tax_type_i;
266: pay_txr_ins.g_tax_type_i := null;
267:
268: p_rec.tax_category :=
269: pay_txr_ins.g_tax_category_i;
270: pay_txr_ins.g_tax_category_i := null;

Line 269: pay_txr_ins.g_tax_category_i;

265: pay_txr_ins.g_tax_type_i;
266: pay_txr_ins.g_tax_type_i := null;
267:
268: p_rec.tax_category :=
269: pay_txr_ins.g_tax_category_i;
270: pay_txr_ins.g_tax_category_i := null;
271:
272: p_rec.classification_id :=
273: pay_txr_ins.g_classification_id_i;

Line 270: pay_txr_ins.g_tax_category_i := null;

266: pay_txr_ins.g_tax_type_i := null;
267:
268: p_rec.tax_category :=
269: pay_txr_ins.g_tax_category_i;
270: pay_txr_ins.g_tax_category_i := null;
271:
272: p_rec.classification_id :=
273: pay_txr_ins.g_classification_id_i;
274: pay_txr_ins.g_classification_id_i := null;

Line 273: pay_txr_ins.g_classification_id_i;

269: pay_txr_ins.g_tax_category_i;
270: pay_txr_ins.g_tax_category_i := null;
271:
272: p_rec.classification_id :=
273: pay_txr_ins.g_classification_id_i;
274: pay_txr_ins.g_classification_id_i := null;
275:
276: p_rec.taxability_rules_date_id :=
277: pay_txr_ins.g_taxability_rules_date_id_i;

Line 274: pay_txr_ins.g_classification_id_i := null;

270: pay_txr_ins.g_tax_category_i := null;
271:
272: p_rec.classification_id :=
273: pay_txr_ins.g_classification_id_i;
274: pay_txr_ins.g_classification_id_i := null;
275:
276: p_rec.taxability_rules_date_id :=
277: pay_txr_ins.g_taxability_rules_date_id_i;
278: pay_txr_ins.g_taxability_rules_date_id_i := null;

Line 277: pay_txr_ins.g_taxability_rules_date_id_i;

273: pay_txr_ins.g_classification_id_i;
274: pay_txr_ins.g_classification_id_i := null;
275:
276: p_rec.taxability_rules_date_id :=
277: pay_txr_ins.g_taxability_rules_date_id_i;
278: pay_txr_ins.g_taxability_rules_date_id_i := null;
279:
280: p_rec.secondary_classification_id :=
281: pay_txr_ins.g_secondary_class_id_i;

Line 278: pay_txr_ins.g_taxability_rules_date_id_i := null;

274: pay_txr_ins.g_classification_id_i := null;
275:
276: p_rec.taxability_rules_date_id :=
277: pay_txr_ins.g_taxability_rules_date_id_i;
278: pay_txr_ins.g_taxability_rules_date_id_i := null;
279:
280: p_rec.secondary_classification_id :=
281: pay_txr_ins.g_secondary_class_id_i;
282: pay_txr_ins.g_secondary_class_id_i := null;

Line 281: pay_txr_ins.g_secondary_class_id_i;

277: pay_txr_ins.g_taxability_rules_date_id_i;
278: pay_txr_ins.g_taxability_rules_date_id_i := null;
279:
280: p_rec.secondary_classification_id :=
281: pay_txr_ins.g_secondary_class_id_i;
282: pay_txr_ins.g_secondary_class_id_i := null;
283:
284: Else
285: --

Line 282: pay_txr_ins.g_secondary_class_id_i := null;

278: pay_txr_ins.g_taxability_rules_date_id_i := null;
279:
280: p_rec.secondary_classification_id :=
281: pay_txr_ins.g_secondary_class_id_i;
282: pay_txr_ins.g_secondary_class_id_i := null;
283:
284: Else
285: --
286: -- No registerd key values, so select the next sequence number

Line 427: pay_txr_ins.pre_insert(p_rec);

423: hr_multi_message.end_validation_set;
424: --
425: -- Call the supporting pre-insert operation
426: --
427: pay_txr_ins.pre_insert(p_rec);
428: --
429: -- Insert the row
430: --
431: pay_txr_ins.insert_dml(p_rec);

Line 431: pay_txr_ins.insert_dml(p_rec);

427: pay_txr_ins.pre_insert(p_rec);
428: --
429: -- Insert the row
430: --
431: pay_txr_ins.insert_dml(p_rec);
432: --
433: -- Call the supporting post-insert operation
434: --
435: pay_txr_ins.post_insert

Line 435: pay_txr_ins.post_insert

431: pay_txr_ins.insert_dml(p_rec);
432: --
433: -- Call the supporting post-insert operation
434: --
435: pay_txr_ins.post_insert
436: (p_effective_date
437: ,p_rec
438: );
439: --

Line 488: hr_utility.trace('Before calling pay_txr_ins.ins ');

484: hr_utility.trace('After calling pay_txr_shd.convert_args ');
485: -- Having converted the arguments into the pay_txr_rec
486: -- plsql record structure we call the corresponding record business process.
487: --
488: hr_utility.trace('Before calling pay_txr_ins.ins ');
489: pay_txr_ins.ins
490: (p_effective_date
491: ,l_rec
492: );

Line 489: pay_txr_ins.ins

485: -- Having converted the arguments into the pay_txr_rec
486: -- plsql record structure we call the corresponding record business process.
487: --
488: hr_utility.trace('Before calling pay_txr_ins.ins ');
489: pay_txr_ins.ins
490: (p_effective_date
491: ,l_rec
492: );
493: --

Line 498: end pay_txr_ins;

494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 10);
496: End ins;
497: --
498: end pay_txr_ins;