APPS.PAY_CA_T4A_REG dependencies on PAY_CA_T4A_REG

Line 1: PACKAGE BODY pay_ca_t4a_reg AS

1: PACKAGE BODY pay_ca_t4a_reg AS
2: /* $Header: pycat4ar.pkb 120.1 2005/06/15 16:42:44 ssouresr noship $ */
3:
4: ----------------------------- range_cursor ----------------------------------
5:

Line 65: nvl(pay_ca_t4a_reg.get_parameter(''TAX_YEAR'',ppa.legislative_parameters),fai1.value)

61: pay_assignment_actions paa
62: where ppa.payroll_action_id = :payroll_action_id
63: and fai1.user_entity_id = ' || l_uid_tax_year ||
64: ' and fai1.value =
65: nvl(pay_ca_t4a_reg.get_parameter(''TAX_YEAR'',ppa.legislative_parameters),fai1.value)
66: and fai2.user_entity_id = ' || l_uid_tax_unit_id ||
67: ' and fai2.value =
68: nvl(pay_ca_t4a_reg.get_parameter(''GRE_ID'',ppa.legislative_parameters),fai2.value)
69: and fai1.context1 = fai2.context1

Line 68: nvl(pay_ca_t4a_reg.get_parameter(''GRE_ID'',ppa.legislative_parameters),fai2.value)

64: ' and fai1.value =
65: nvl(pay_ca_t4a_reg.get_parameter(''TAX_YEAR'',ppa.legislative_parameters),fai1.value)
66: and fai2.user_entity_id = ' || l_uid_tax_unit_id ||
67: ' and fai2.value =
68: nvl(pay_ca_t4a_reg.get_parameter(''GRE_ID'',ppa.legislative_parameters),fai2.value)
69: and fai1.context1 = fai2.context1
70: and paa.payroll_action_id= fai2.context1
71: and paa.assignment_action_id=fai3.context1
72: and fai3.user_entity_id = ' || l_uid_person_id ||

Line 74: nvl(pay_ca_t4a_reg.get_parameter(''PER_ID'',ppa.legislative_parameters),fai3.value)

70: and paa.payroll_action_id= fai2.context1
71: and paa.assignment_action_id=fai3.context1
72: and fai3.user_entity_id = ' || l_uid_person_id ||
73: ' and fai3.value =
74: nvl(pay_ca_t4a_reg.get_parameter(''PER_ID'',ppa.legislative_parameters),fai3.value)
75: order by to_number(fai3.value)';
76:
77: hr_utility.trace('End of range_cursor 2 ');
78:

Line 256: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);

252: hr_utility.trace('Start Person ID = '||to_char(stperson));
253: hr_utility.trace('End Person ID = '||to_char(endperson));
254: hr_utility.trace('Chunk # = '||to_char(chunk));
255:
256: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
257: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
258: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
259: l_asg_set_id := pay_ca_t4a_reg.get_parameter('ASG_SET_ID',
260: l_legislative_parameters);

Line 259: l_asg_set_id := pay_ca_t4a_reg.get_parameter('ASG_SET_ID',

255:
256: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
257: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
258: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
259: l_asg_set_id := pay_ca_t4a_reg.get_parameter('ASG_SET_ID',
260: l_legislative_parameters);
261: lv_per_id := pay_ca_t4a_reg.get_parameter('PER_ID',l_legislative_parameters);
262:
263: hr_utility.trace('begining of action creation 3 '||

Line 261: lv_per_id := pay_ca_t4a_reg.get_parameter('PER_ID',l_legislative_parameters);

257: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
258: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
259: l_asg_set_id := pay_ca_t4a_reg.get_parameter('ASG_SET_ID',
260: l_legislative_parameters);
261: lv_per_id := pay_ca_t4a_reg.get_parameter('PER_ID',l_legislative_parameters);
262:
263: hr_utility.trace('begining of action creation 3 '||
264: l_year||to_char(l_year_start)||to_char(l_year_end));
265:

Line 266: l_t4areg_tax_unit_id := to_number(pay_ca_t4a_reg.get_parameter('GRE_ID',

262:
263: hr_utility.trace('begining of action creation 3 '||
264: l_year||to_char(l_year_start)||to_char(l_year_end));
265:
266: l_t4areg_tax_unit_id := to_number(pay_ca_t4a_reg.get_parameter('GRE_ID',
267: l_legislative_parameters));
268: l_uid_caeoy_tax_year := get_user_entity_id('CAEOY_TAXATION_YEAR');
269: l_uid_caeoy_tax_unit_id := get_user_entity_id('CAEOY_TAX_UNIT_ID');
270:

Line 609: end pay_ca_t4a_reg;

605:
606: return l_label_meaning;
607: end get_label;
608:
609: end pay_ca_t4a_reg;