DBA Data[Home] [Help]

APPS.PAY_TXR_BUS dependencies on PAY_TXR_BUS

Line 1: Package Body pay_txr_bus as

1: Package Body pay_txr_bus 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_bus.'; -- Global package name

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

Line 217: if (( nvl(pay_txr_bus.g_jurisdiction_code, hr_api.g_varchar2)

213: ,p_argument => 'taxability_rules_date_id'
214: ,p_argument_value => p_taxability_rules_date_id
215: );
216: --
217: if (( nvl(pay_txr_bus.g_jurisdiction_code, hr_api.g_varchar2)
218: = p_jurisdiction_code)
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)

Line 219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)

215: );
216: --
217: if (( nvl(pay_txr_bus.g_jurisdiction_code, hr_api.g_varchar2)
218: = p_jurisdiction_code)
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)

Line 221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)

217: if (( nvl(pay_txr_bus.g_jurisdiction_code, hr_api.g_varchar2)
218: = p_jurisdiction_code)
219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)

Line 223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)

219: and ( nvl(pay_txr_bus.g_tax_type, hr_api.g_varchar2)
220: = nvl(p_tax_type, hr_api.g_varchar2))
221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)

Line 225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)

221: and ( nvl(pay_txr_bus.g_tax_category, hr_api.g_varchar2)
222: = nvl(p_tax_category, hr_api.g_varchar2))
223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)
228: = p_taxability_rules_date_id)) then
229: --

Line 227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)

223: and ( nvl(pay_txr_bus.g_classification_id, hr_api.g_number)
224: = nvl(p_classification_id, hr_api.g_number))
225: and ( nvl(pay_txr_bus.g_secondary_classification_id, hr_api.g_number)
226: = nvl(p_secondary_classification_id, hr_api.g_number))
227: and ( nvl(pay_txr_bus.g_taxability_rules_date_id, hr_api.g_number)
228: = p_taxability_rules_date_id)) then
229: --
230: -- The legislation code has already been found with a previous
231: -- call to this function. Just return the value in the global

Line 234: l_legislation_code := pay_txr_bus.g_legislation_code;

230: -- The legislation code has already been found with a previous
231: -- call to this function. Just return the value in the global
232: -- variable.
233: --
234: l_legislation_code := pay_txr_bus.g_legislation_code;
235: hr_utility.set_location(l_proc, 20);
236: else
237: --
238: -- The ID is different to the last call to this function

Line 258: pay_txr_bus.g_jurisdiction_code := p_jurisdiction_code;

254: -- Set the global variables so the values are
255: -- available for the next call to this function.
256: --
257: close csr_leg_code;
258: pay_txr_bus.g_jurisdiction_code := p_jurisdiction_code;
259: pay_txr_bus.g_tax_type := p_tax_type;
260: pay_txr_bus.g_tax_category := p_tax_category;
261: pay_txr_bus.g_classification_id := p_classification_id;
262: pay_txr_bus.g_secondary_classification_id := p_secondary_classification_id;

Line 259: pay_txr_bus.g_tax_type := p_tax_type;

255: -- available for the next call to this function.
256: --
257: close csr_leg_code;
258: pay_txr_bus.g_jurisdiction_code := p_jurisdiction_code;
259: pay_txr_bus.g_tax_type := p_tax_type;
260: pay_txr_bus.g_tax_category := p_tax_category;
261: pay_txr_bus.g_classification_id := p_classification_id;
262: pay_txr_bus.g_secondary_classification_id := p_secondary_classification_id;
263: pay_txr_bus.g_taxability_rules_date_id := p_taxability_rules_date_id;

Line 260: pay_txr_bus.g_tax_category := p_tax_category;

256: --
257: close csr_leg_code;
258: pay_txr_bus.g_jurisdiction_code := p_jurisdiction_code;
259: pay_txr_bus.g_tax_type := p_tax_type;
260: pay_txr_bus.g_tax_category := p_tax_category;
261: pay_txr_bus.g_classification_id := p_classification_id;
262: pay_txr_bus.g_secondary_classification_id := p_secondary_classification_id;
263: pay_txr_bus.g_taxability_rules_date_id := p_taxability_rules_date_id;
264: pay_txr_bus.g_legislation_code := l_legislation_code;

Line 261: pay_txr_bus.g_classification_id := p_classification_id;

257: close csr_leg_code;
258: pay_txr_bus.g_jurisdiction_code := p_jurisdiction_code;
259: pay_txr_bus.g_tax_type := p_tax_type;
260: pay_txr_bus.g_tax_category := p_tax_category;
261: pay_txr_bus.g_classification_id := p_classification_id;
262: pay_txr_bus.g_secondary_classification_id := p_secondary_classification_id;
263: pay_txr_bus.g_taxability_rules_date_id := p_taxability_rules_date_id;
264: pay_txr_bus.g_legislation_code := l_legislation_code;
265: end if;

Line 262: pay_txr_bus.g_secondary_classification_id := p_secondary_classification_id;

258: pay_txr_bus.g_jurisdiction_code := p_jurisdiction_code;
259: pay_txr_bus.g_tax_type := p_tax_type;
260: pay_txr_bus.g_tax_category := p_tax_category;
261: pay_txr_bus.g_classification_id := p_classification_id;
262: pay_txr_bus.g_secondary_classification_id := p_secondary_classification_id;
263: pay_txr_bus.g_taxability_rules_date_id := p_taxability_rules_date_id;
264: pay_txr_bus.g_legislation_code := l_legislation_code;
265: end if;
266: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 263: pay_txr_bus.g_taxability_rules_date_id := p_taxability_rules_date_id;

259: pay_txr_bus.g_tax_type := p_tax_type;
260: pay_txr_bus.g_tax_category := p_tax_category;
261: pay_txr_bus.g_classification_id := p_classification_id;
262: pay_txr_bus.g_secondary_classification_id := p_secondary_classification_id;
263: pay_txr_bus.g_taxability_rules_date_id := p_taxability_rules_date_id;
264: pay_txr_bus.g_legislation_code := l_legislation_code;
265: end if;
266: hr_utility.set_location(' Leaving:'|| l_proc, 40);
267: return l_legislation_code;

Line 264: pay_txr_bus.g_legislation_code := l_legislation_code;

260: pay_txr_bus.g_tax_category := p_tax_category;
261: pay_txr_bus.g_classification_id := p_classification_id;
262: pay_txr_bus.g_secondary_classification_id := p_secondary_classification_id;
263: pay_txr_bus.g_taxability_rules_date_id := p_taxability_rules_date_id;
264: pay_txr_bus.g_legislation_code := l_legislation_code;
265: end if;
266: hr_utility.set_location(' Leaving:'|| l_proc, 40);
267: return l_legislation_code;
268: end return_legislation_code;

Line 408: end pay_txr_bus;

404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: End delete_validate;
407: --
408: end pay_txr_bus;