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.2 2012/01/19 11:27:49 rpahune ship $ */
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: -- Bug 11894789
229: Cursor c_ele_class_validation is

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: -- Bug 11894789
229: Cursor c_ele_class_validation is
230: Select null
231: from pay_element_classifications

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

289: End If;
290: Close c_sec_ele_class_validation;
291: END IF;
292: END IF; -- End of Bug 11894789
293: If (pay_txr_ins.g_jurisdiction_code_i is not null or
294: pay_txr_ins.g_tax_type_i is not null or
295: pay_txr_ins.g_tax_category_i is not null or
296: pay_txr_ins.g_classification_id_i is not null or
297: pay_txr_ins.g_taxability_rules_date_id_i is not null or

Line 294: pay_txr_ins.g_tax_type_i is not null or

290: Close c_sec_ele_class_validation;
291: END IF;
292: END IF; -- End of Bug 11894789
293: If (pay_txr_ins.g_jurisdiction_code_i is not null or
294: pay_txr_ins.g_tax_type_i is not null or
295: pay_txr_ins.g_tax_category_i is not null or
296: pay_txr_ins.g_classification_id_i is not null or
297: pay_txr_ins.g_taxability_rules_date_id_i is not null or
298: pay_txr_ins.g_secondary_class_id_i is not null) Then

Line 295: pay_txr_ins.g_tax_category_i is not null or

291: END IF;
292: END IF; -- End of Bug 11894789
293: If (pay_txr_ins.g_jurisdiction_code_i is not null or
294: pay_txr_ins.g_tax_type_i is not null or
295: pay_txr_ins.g_tax_category_i is not null or
296: pay_txr_ins.g_classification_id_i is not null or
297: pay_txr_ins.g_taxability_rules_date_id_i is not null or
298: pay_txr_ins.g_secondary_class_id_i is not null) Then
299: --

Line 296: pay_txr_ins.g_classification_id_i is not null or

292: END IF; -- End of Bug 11894789
293: If (pay_txr_ins.g_jurisdiction_code_i is not null or
294: pay_txr_ins.g_tax_type_i is not null or
295: pay_txr_ins.g_tax_category_i is not null or
296: pay_txr_ins.g_classification_id_i is not null or
297: pay_txr_ins.g_taxability_rules_date_id_i is not null or
298: pay_txr_ins.g_secondary_class_id_i is not null) Then
299: --
300: -- Verify registered primary key values not already in use

Line 297: pay_txr_ins.g_taxability_rules_date_id_i is not null or

293: If (pay_txr_ins.g_jurisdiction_code_i is not null or
294: pay_txr_ins.g_tax_type_i is not null or
295: pay_txr_ins.g_tax_category_i is not null or
296: pay_txr_ins.g_classification_id_i is not null or
297: pay_txr_ins.g_taxability_rules_date_id_i is not null or
298: pay_txr_ins.g_secondary_class_id_i is not null) Then
299: --
300: -- Verify registered primary key values not already in use
301: --

Line 298: pay_txr_ins.g_secondary_class_id_i is not null) Then

294: pay_txr_ins.g_tax_type_i is not null or
295: pay_txr_ins.g_tax_category_i is not null or
296: pay_txr_ins.g_classification_id_i is not null or
297: pay_txr_ins.g_taxability_rules_date_id_i is not null or
298: pay_txr_ins.g_secondary_class_id_i is not null) Then
299: --
300: -- Verify registered primary key values not already in use
301: --
302: Open C_Sel2;

Line 318: pay_txr_ins.g_jurisdiction_code_i;

314: --
315: -- Use registered key values and clear globals
316: --
317: p_rec.jurisdiction_code :=
318: pay_txr_ins.g_jurisdiction_code_i;
319: pay_txr_ins.g_jurisdiction_code_i := null;
320:
321: p_rec.tax_type :=
322: pay_txr_ins.g_tax_type_i;

Line 319: pay_txr_ins.g_jurisdiction_code_i := null;

315: -- Use registered key values and clear globals
316: --
317: p_rec.jurisdiction_code :=
318: pay_txr_ins.g_jurisdiction_code_i;
319: pay_txr_ins.g_jurisdiction_code_i := null;
320:
321: p_rec.tax_type :=
322: pay_txr_ins.g_tax_type_i;
323: pay_txr_ins.g_tax_type_i := null;

Line 322: pay_txr_ins.g_tax_type_i;

318: pay_txr_ins.g_jurisdiction_code_i;
319: pay_txr_ins.g_jurisdiction_code_i := null;
320:
321: p_rec.tax_type :=
322: pay_txr_ins.g_tax_type_i;
323: pay_txr_ins.g_tax_type_i := null;
324:
325: p_rec.tax_category :=
326: pay_txr_ins.g_tax_category_i;

Line 323: pay_txr_ins.g_tax_type_i := null;

319: pay_txr_ins.g_jurisdiction_code_i := null;
320:
321: p_rec.tax_type :=
322: pay_txr_ins.g_tax_type_i;
323: pay_txr_ins.g_tax_type_i := null;
324:
325: p_rec.tax_category :=
326: pay_txr_ins.g_tax_category_i;
327: pay_txr_ins.g_tax_category_i := null;

Line 326: pay_txr_ins.g_tax_category_i;

322: pay_txr_ins.g_tax_type_i;
323: pay_txr_ins.g_tax_type_i := null;
324:
325: p_rec.tax_category :=
326: pay_txr_ins.g_tax_category_i;
327: pay_txr_ins.g_tax_category_i := null;
328:
329: p_rec.classification_id :=
330: pay_txr_ins.g_classification_id_i;

Line 327: pay_txr_ins.g_tax_category_i := null;

323: pay_txr_ins.g_tax_type_i := null;
324:
325: p_rec.tax_category :=
326: pay_txr_ins.g_tax_category_i;
327: pay_txr_ins.g_tax_category_i := null;
328:
329: p_rec.classification_id :=
330: pay_txr_ins.g_classification_id_i;
331: pay_txr_ins.g_classification_id_i := null;

Line 330: pay_txr_ins.g_classification_id_i;

326: pay_txr_ins.g_tax_category_i;
327: pay_txr_ins.g_tax_category_i := null;
328:
329: p_rec.classification_id :=
330: pay_txr_ins.g_classification_id_i;
331: pay_txr_ins.g_classification_id_i := null;
332:
333: p_rec.taxability_rules_date_id :=
334: pay_txr_ins.g_taxability_rules_date_id_i;

Line 331: pay_txr_ins.g_classification_id_i := null;

327: pay_txr_ins.g_tax_category_i := null;
328:
329: p_rec.classification_id :=
330: pay_txr_ins.g_classification_id_i;
331: pay_txr_ins.g_classification_id_i := null;
332:
333: p_rec.taxability_rules_date_id :=
334: pay_txr_ins.g_taxability_rules_date_id_i;
335: pay_txr_ins.g_taxability_rules_date_id_i := null;

Line 334: pay_txr_ins.g_taxability_rules_date_id_i;

330: pay_txr_ins.g_classification_id_i;
331: pay_txr_ins.g_classification_id_i := null;
332:
333: p_rec.taxability_rules_date_id :=
334: pay_txr_ins.g_taxability_rules_date_id_i;
335: pay_txr_ins.g_taxability_rules_date_id_i := null;
336:
337: p_rec.secondary_classification_id :=
338: pay_txr_ins.g_secondary_class_id_i;

Line 335: pay_txr_ins.g_taxability_rules_date_id_i := null;

331: pay_txr_ins.g_classification_id_i := null;
332:
333: p_rec.taxability_rules_date_id :=
334: pay_txr_ins.g_taxability_rules_date_id_i;
335: pay_txr_ins.g_taxability_rules_date_id_i := null;
336:
337: p_rec.secondary_classification_id :=
338: pay_txr_ins.g_secondary_class_id_i;
339: pay_txr_ins.g_secondary_class_id_i := null;

Line 338: pay_txr_ins.g_secondary_class_id_i;

334: pay_txr_ins.g_taxability_rules_date_id_i;
335: pay_txr_ins.g_taxability_rules_date_id_i := null;
336:
337: p_rec.secondary_classification_id :=
338: pay_txr_ins.g_secondary_class_id_i;
339: pay_txr_ins.g_secondary_class_id_i := null;
340:
341: Else
342: --

Line 339: pay_txr_ins.g_secondary_class_id_i := null;

335: pay_txr_ins.g_taxability_rules_date_id_i := null;
336:
337: p_rec.secondary_classification_id :=
338: pay_txr_ins.g_secondary_class_id_i;
339: pay_txr_ins.g_secondary_class_id_i := null;
340:
341: Else
342: --
343: -- No registerd key values, so select the next sequence number

Line 484: pay_txr_ins.pre_insert(p_rec);

480: hr_multi_message.end_validation_set;
481: --
482: -- Call the supporting pre-insert operation
483: --
484: pay_txr_ins.pre_insert(p_rec);
485: --
486: -- Insert the row
487: --
488: pay_txr_ins.insert_dml(p_rec);

Line 488: pay_txr_ins.insert_dml(p_rec);

484: pay_txr_ins.pre_insert(p_rec);
485: --
486: -- Insert the row
487: --
488: pay_txr_ins.insert_dml(p_rec);
489: --
490: -- Call the supporting post-insert operation
491: --
492: pay_txr_ins.post_insert

Line 492: pay_txr_ins.post_insert

488: pay_txr_ins.insert_dml(p_rec);
489: --
490: -- Call the supporting post-insert operation
491: --
492: pay_txr_ins.post_insert
493: (p_effective_date
494: ,p_rec
495: );
496: --

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

541: hr_utility.trace('After calling pay_txr_shd.convert_args ');
542: -- Having converted the arguments into the pay_txr_rec
543: -- plsql record structure we call the corresponding record business process.
544: --
545: hr_utility.trace('Before calling pay_txr_ins.ins ');
546: pay_txr_ins.ins
547: (p_effective_date
548: ,l_rec
549: );

Line 546: pay_txr_ins.ins

542: -- Having converted the arguments into the pay_txr_rec
543: -- plsql record structure we call the corresponding record business process.
544: --
545: hr_utility.trace('Before calling pay_txr_ins.ins ');
546: pay_txr_ins.ins
547: (p_effective_date
548: ,l_rec
549: );
550: --

Line 555: end pay_txr_ins;

551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 10);
553: End ins;
554: --
555: end pay_txr_ins;