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_CA_T4_REG dependencies on PAY_CA_T4_REG

Line 1: PACKAGE BODY pay_ca_t4_reg AS

1: PACKAGE BODY pay_ca_t4_reg AS
2: /* $Header: pycat4rg.pkb 120.3.12000000.1 2007/01/17 17:29:50 appldev noship $ */
3: function get_user_entity_id(p_user_name varchar2) return number is
4:
5: begin

Line 71: nvl(pay_ca_t4_reg.get_parameter(''TAX_YEAR'',

67: pay_assignment_actions paa
68: where ppa.payroll_action_id = :payroll_action_id
69: and fai1.user_entity_id = ' || l_uid_caeoy_tax_year ||
70: ' and fai1.value =
71: nvl(pay_ca_t4_reg.get_parameter(''TAX_YEAR'',
72: ppa.legislative_parameters),fai1.value)
73: and fai1.context1 = paa.payroll_action_id
74: and fai2.user_entity_id = ' || l_uid_caeoy_tax_unit_id ||
75: ' and fai2.value =

Line 76: nvl(pay_ca_t4_reg.get_parameter(''GRE_ID'',

72: ppa.legislative_parameters),fai1.value)
73: and fai1.context1 = paa.payroll_action_id
74: and fai2.user_entity_id = ' || l_uid_caeoy_tax_unit_id ||
75: ' and fai2.value =
76: nvl(pay_ca_t4_reg.get_parameter(''GRE_ID'',
77: ppa.legislative_parameters),fai2.value)
78: and fai2.context1 = paa.payroll_action_id
79: and fai3.user_entity_id = ' || l_uid_caeoy_prov_of_emp ||
80: ' and fai3.value =

Line 81: nvl(pay_ca_t4_reg.get_parameter(''PROV_CD'',

77: ppa.legislative_parameters),fai2.value)
78: and fai2.context1 = paa.payroll_action_id
79: and fai3.user_entity_id = ' || l_uid_caeoy_prov_of_emp ||
80: ' and fai3.value =
81: nvl(pay_ca_t4_reg.get_parameter(''PROV_CD'',
82: ppa.legislative_parameters),fai3.value)
83: and fai3.context1 = paa.assignment_action_id
84: and fai4.user_entity_id = ' || l_uid_caeoy_person_id ||
85: ' and fai4.context1 = paa.assignment_action_id

Line 86: and fai4.value = nvl(pay_ca_t4_reg.get_parameter(''PER_ID'',

82: ppa.legislative_parameters),fai3.value)
83: and fai3.context1 = paa.assignment_action_id
84: and fai4.user_entity_id = ' || l_uid_caeoy_person_id ||
85: ' and fai4.context1 = paa.assignment_action_id
86: and fai4.value = nvl(pay_ca_t4_reg.get_parameter(''PER_ID'',
87: ppa.legislative_parameters),fai4.value)
88: order by to_number(fai4.value)';
89:
90: hr_utility.trace('End of range_cursor 2 ');

Line 139: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters),

135: l_session_date pay_payroll_actions.effective_date%TYPE;
136:
137: cursor c_all_gres is
138: SELECT
139: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters),
140: ppa.payroll_action_id,
141: ppa.effective_date
142: FROM
143: pay_payroll_actions ppa

Line 167: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters)

163: ppa.report_type = 'T4' AND
164: ppa.report_category = 'CAEOY' and
165: ppa.report_qualifier = 'CAEOY' and
166: ppa.business_group_id = l_bus_group_id and
167: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters)
168: = to_char(p_tax_unit_id) and
169: ppa.effective_date = l_year_end and
170: ppa.action_status = 'C';
171:

Line 300: l_year := pay_ca_t4_reg.get_parameter('TAX_YEAR',l_legislative_parameters);

296:
297: hr_utility.trace('begining of action creation 2 '||to_char(l_bus_group_id));
298: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
299:
300: l_year := pay_ca_t4_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
301: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
302: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
303: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
304: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);

Line 303: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);

299:
300: l_year := pay_ca_t4_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
301: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
302: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
303: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
304: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);
305:
306: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',
307: l_legislative_parameters));

Line 304: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);

300: l_year := pay_ca_t4_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
301: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
302: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
303: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
304: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);
305:
306: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',
307: l_legislative_parameters));
308:

Line 306: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',

302: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
303: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
304: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);
305:
306: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',
307: l_legislative_parameters));
308:
309: lv_per_id := pay_ca_t4_reg.get_parameter('PER_ID',
310: l_legislative_parameters);

Line 309: lv_per_id := pay_ca_t4_reg.get_parameter('PER_ID',

305:
306: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',
307: l_legislative_parameters));
308:
309: lv_per_id := pay_ca_t4_reg.get_parameter('PER_ID',
310: l_legislative_parameters);
311:
312: hr_utility.trace('begining of action creation 4 '||
313: to_char(l_t4reg_tax_unit_id));

Line 437: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');

433: 'CAEOY_EMPLOYEE_LAST_NAME');
434:
435: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
436:
437: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
438: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
439: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
440:
441: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) ||

Line 438: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');

434:
435: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
436:
437: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
438: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
439: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
440:
441: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) ||
442: '(' || lv_sin || ') ' || lv_neg_bal_mesg;

Line 439: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');

435: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
436:
437: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
438: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
439: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
440:
441: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) ||
442: '(' || lv_sin || ') ' || lv_neg_bal_mesg;
443:

Line 564: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');

560: 'CAEOY_EMPLOYEE_LAST_NAME');
561:
562: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
563:
564: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
565: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
566: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
567:
568: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) || '(' || lv_sin || ') ' || lv_neg_bal_mesg;

Line 565: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');

561:
562: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
563:
564: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
565: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
566: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
567:
568: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) || '(' || lv_sin || ') ' || lv_neg_bal_mesg;
569:

Line 566: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');

562: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
563:
564: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
565: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
566: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
567:
568: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) || '(' || lv_sin || ') ' || lv_neg_bal_mesg;
569:
570: pay_core_utils.push_message(801,'HR_ELE_ENTRY_FORMULA_HINT','A');

Line 635: decode(pay_ca_t4_reg.get_parameter

631: and ppf2.effective_start_date
632: <= ppa1.effective_date)
633: and ppf.effective_end_date >= ppa1.start_date
634: order by
635: decode(pay_ca_t4_reg.get_parameter
636: (''P_S1'',ppa1.legislative_parameters),
637: ''GRE'',hou1.name,
638: ''ORGANIZATION'',hou.name,
639: ''LOCATION'',loc.location_code,null),

Line 640: decode(pay_ca_t4_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),

636: (''P_S1'',ppa1.legislative_parameters),
637: ''GRE'',hou1.name,
638: ''ORGANIZATION'',hou.name,
639: ''LOCATION'',loc.location_code,null),
640: decode(pay_ca_t4_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),
641: ''GRE'',hou1.name,
642: ''ORGANIZATION'',hou.name,
643: ''LOCATION'',loc.location_code,null),
644:

Line 645: decode(pay_ca_t4_reg.get_parameter(''P_S3'',ppa1.legislative_parameters),

641: ''GRE'',hou1.name,
642: ''ORGANIZATION'',hou.name,
643: ''LOCATION'',loc.location_code,null),
644:
645: decode(pay_ca_t4_reg.get_parameter(''P_S3'',ppa1.legislative_parameters),
646: ''GRE'',hou1.name,
647: ''ORGANIZATION'',hou.name,
648: ''LOCATION'',loc.location_code,null),
649: ppf.last_name,first_name

Line 713: end pay_ca_t4_reg;

709: RETURN l_meaning;
710:
711: END get_label; -- get_label
712:
713: end pay_ca_t4_reg;