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.5.12020000.3 2013/01/25 11:34:37 rgottipa ship $ */
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 146: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters),

142: l_session_date pay_payroll_actions.effective_date%TYPE;
143:
144: cursor c_all_gres is
145: SELECT
146: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters),
147: ppa.payroll_action_id,
148: ppa.effective_date
149: FROM
150: pay_payroll_actions ppa

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

170: ppa.report_type = 'T4' AND
171: ppa.report_category = 'CAEOY' and
172: ppa.report_qualifier = 'CAEOY' and
173: ppa.business_group_id = l_bus_group_id and
174: pay_ca_t4_reg.get_parameter('TRANSFER_GRE', ppa.legislative_parameters)
175: = to_char(p_tax_unit_id) and
176: ppa.effective_date = l_year_end and
177: ppa.action_status = 'C';
178:

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

602:
603: hr_utility.trace('begining of action creation 2 '||to_char(l_bus_group_id));
604: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
605:
606: l_year := pay_ca_t4_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
607: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
608: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
609: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
610: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);

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

605:
606: l_year := pay_ca_t4_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
607: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
608: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
609: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
610: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);
611: l_print_term := pay_ca_t4_reg.get_parameter('PRINT_TERM',l_legislative_parameters); -- bug 15886428
612:
613: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',

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

606: l_year := pay_ca_t4_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
607: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
608: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
609: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
610: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);
611: l_print_term := pay_ca_t4_reg.get_parameter('PRINT_TERM',l_legislative_parameters); -- bug 15886428
612:
613: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',
614: l_legislative_parameters));

Line 611: l_print_term := pay_ca_t4_reg.get_parameter('PRINT_TERM',l_legislative_parameters); -- bug 15886428

607: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
608: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
609: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
610: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);
611: l_print_term := pay_ca_t4_reg.get_parameter('PRINT_TERM',l_legislative_parameters); -- bug 15886428
612:
613: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',
614: l_legislative_parameters));
615:

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

609: l_asg_set_id := pay_ca_t4_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
610: l_province := pay_ca_t4_reg.get_parameter('PROV_CD',l_legislative_parameters);
611: l_print_term := pay_ca_t4_reg.get_parameter('PRINT_TERM',l_legislative_parameters); -- bug 15886428
612:
613: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',
614: l_legislative_parameters));
615:
616: lv_per_id := pay_ca_t4_reg.get_parameter('PER_ID',
617: l_legislative_parameters);

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

612:
613: l_t4reg_tax_unit_id := to_number(pay_ca_t4_reg.get_parameter('GRE_ID',
614: l_legislative_parameters));
615:
616: lv_per_id := pay_ca_t4_reg.get_parameter('PER_ID',
617: l_legislative_parameters);
618:
619: hr_utility.trace('begining of action creation 4 '||
620: to_char(l_t4reg_tax_unit_id));

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

899: 'CAEOY_EMPLOYEE_LAST_NAME');
900:
901: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
902:
903: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
904: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
905: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
906:
907: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) ||

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

900:
901: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
902:
903: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
904: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
905: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
906:
907: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) ||
908: '(' || lv_sin || ') ' || lv_neg_bal_mesg;

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

901: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
902:
903: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
904: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
905: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
906:
907: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) ||
908: '(' || lv_sin || ') ' || lv_neg_bal_mesg;
909:

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

1194: 'CAEOY_EMPLOYEE_LAST_NAME');
1195:
1196: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
1197:
1198: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
1199: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
1200: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
1201:
1202: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) || '(' || lv_sin || ') ' || lv_neg_bal_mesg;

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

1195:
1196: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
1197:
1198: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
1199: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
1200: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
1201:
1202: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) || '(' || lv_sin || ') ' || lv_neg_bal_mesg;
1203:

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

1196: lv_employee_full_name := lv_employee_last_name ||','|| lv_employee_name;
1197:
1198: lv_neg_bal_mesg := pay_ca_t4_reg.get_label('PAY_CA_LABELS','EOY_NEG_BAL');
1199: lv_person_type := pay_ca_t4_reg.get_label('PERSON_TYPE','EMP');
1200: lv_message_level:= pay_ca_t4_reg.get_label('MESSAGE_LEVEL','W');
1201:
1202: lv_message:= lv_message_level||':'|| lv_person_type ||':'|| substr(lv_employee_full_name,1,45) || '(' || lv_sin || ') ' || lv_neg_bal_mesg;
1203:
1204: pay_core_utils.push_message(801,'HR_ELE_ENTRY_FORMULA_HINT','A');

Line 1307: decode(pay_ca_t4_reg.get_parameter

1303: and ppf2.effective_start_date
1304: <= ppa1.effective_date)
1305: and ppf.effective_end_date >= ppa1.start_date
1306: order by
1307: decode(pay_ca_t4_reg.get_parameter
1308: (''P_S1'',ppa1.legislative_parameters),
1309: ''GRE'',hou1.name,
1310: ''ORGANIZATION'',hou.name,
1311: ''LOCATION'',loc.location_code,null),

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

1308: (''P_S1'',ppa1.legislative_parameters),
1309: ''GRE'',hou1.name,
1310: ''ORGANIZATION'',hou.name,
1311: ''LOCATION'',loc.location_code,null),
1312: decode(pay_ca_t4_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),
1313: ''GRE'',hou1.name,
1314: ''ORGANIZATION'',hou.name,
1315: ''LOCATION'',loc.location_code,null),
1316:

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

1313: ''GRE'',hou1.name,
1314: ''ORGANIZATION'',hou.name,
1315: ''LOCATION'',loc.location_code,null),
1316:
1317: decode(pay_ca_t4_reg.get_parameter(''P_S3'',ppa1.legislative_parameters),
1318: ''GRE'',hou1.name,
1319: ''ORGANIZATION'',hou.name,
1320: ''LOCATION'',loc.location_code,null),
1321: ppf.last_name,first_name

Line 1385: end pay_ca_t4_reg;

1381: RETURN l_meaning;
1382:
1383: END get_label; -- get_label
1384:
1385: end pay_ca_t4_reg;