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.5.12020000.3 2013/01/25 13:00:01 rgottipa ship $ */
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 511: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);

507: hr_utility.trace('Start Person ID = '||to_char(stperson));
508: hr_utility.trace('End Person ID = '||to_char(endperson));
509: hr_utility.trace('Chunk # = '||to_char(chunk));
510:
511: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
512: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
513: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
514: l_asg_set_id := pay_ca_t4a_reg.get_parameter('ASG_SET_ID',
515: l_legislative_parameters);

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

510:
511: l_year := pay_ca_t4a_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
512: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
513: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
514: l_asg_set_id := pay_ca_t4a_reg.get_parameter('ASG_SET_ID',
515: l_legislative_parameters);
516: lv_per_id := pay_ca_t4a_reg.get_parameter('PER_ID',l_legislative_parameters);
517: l_print_term := pay_ca_t4_reg.get_parameter('PRINT_TERM',l_legislative_parameters);
518:

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

512: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
513: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
514: l_asg_set_id := pay_ca_t4a_reg.get_parameter('ASG_SET_ID',
515: l_legislative_parameters);
516: lv_per_id := pay_ca_t4a_reg.get_parameter('PER_ID',l_legislative_parameters);
517: l_print_term := pay_ca_t4_reg.get_parameter('PRINT_TERM',l_legislative_parameters);
518:
519: hr_utility.trace('begining of action creation 3 '||
520: l_year||to_char(l_year_start)||to_char(l_year_end));

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

518:
519: hr_utility.trace('begining of action creation 3 '||
520: l_year||to_char(l_year_start)||to_char(l_year_end));
521:
522: l_t4areg_tax_unit_id := to_number(pay_ca_t4a_reg.get_parameter('GRE_ID',
523: l_legislative_parameters));
524: l_uid_caeoy_tax_year := get_user_entity_id('CAEOY_TAXATION_YEAR');
525: l_uid_caeoy_tax_unit_id := get_user_entity_id('CAEOY_TAX_UNIT_ID');
526:

Line 1208: end pay_ca_t4a_reg;

1204:
1205: return l_label_meaning;
1206: end get_label;
1207:
1208: end pay_ca_t4a_reg;