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_RL1_REG dependencies on PAY_CA_RL1_REG

Line 1: package body pay_ca_rl1_reg as

1: package body pay_ca_rl1_reg as
2: /* $Header: pycarrrg.pkb 120.5.12020000.4 2013/04/30 10:00:23 rgottipa ship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5: --

Line 201: nvl(pay_ca_rl1_reg.get_parameter(''TAX_YEAR'',

197: where ppa.payroll_action_id = :payroll_action_id
198: and fai1.user_entity_id = fdi1.user_entity_id
199: and fdi1.user_name = ''CAEOY_TAXATION_YEAR''
200: and fai1.value =
201: nvl(pay_ca_rl1_reg.get_parameter(''TAX_YEAR'',
202: ppa.legislative_parameters),fai1.value)
203: and fai2.user_entity_id = fdi2.user_entity_id
204: and fdi2.user_name = ''CAEOY_RL1_PRE_ORG_ID''
205: and fai2.value =

Line 206: nvl(pay_ca_rl1_reg.get_parameter(''PRE_ORGANIZATION_ID'',

202: ppa.legislative_parameters),fai1.value)
203: and fai2.user_entity_id = fdi2.user_entity_id
204: and fdi2.user_name = ''CAEOY_RL1_PRE_ORG_ID''
205: and fai2.value =
206: nvl(pay_ca_rl1_reg.get_parameter(''PRE_ORGANIZATION_ID'',
207: ppa.legislative_parameters),
208: fai2.value)
209: and fai1.context1 = fai2.context1
210: and paa.payroll_action_id= fai2.context1

Line 214: and fai3.value = nvl(pay_ca_rl1_reg.get_parameter(''PER_ID'',

210: and paa.payroll_action_id= fai2.context1
211: and paa.assignment_action_id=fai3.context1
212: and fai3.user_entity_id = fdi3.user_entity_id
213: and fdi3.user_name = ''CAEOY_PERSON_ID''
214: and fai3.value = nvl(pay_ca_rl1_reg.get_parameter(''PER_ID'',
215: ppa.legislative_parameters),fai3.value)
216: order by to_number(fai3.value)';
217:
218: hr_utility.trace('End of range_cursor 2 ');

Line 510: l_year := pay_ca_rl1_reg.get_parameter('TAX_YEAR',l_legislative_parameters);

506: to_char(l_bus_group_id));
507:
508: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
509:
510: l_year := pay_ca_rl1_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
511: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
512: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
513: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
514: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);

Line 513: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);

509:
510: l_year := pay_ca_rl1_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
511: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
512: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
513: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
514: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);
515: l_print_term := pay_ca_rl1_reg.get_parameter('PRINT_TERM',l_legislative_parameters);
516:
517: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));

Line 514: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);

510: l_year := pay_ca_rl1_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
511: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
512: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
513: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
514: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);
515: l_print_term := pay_ca_rl1_reg.get_parameter('PRINT_TERM',l_legislative_parameters);
516:
517: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));
518:

Line 515: l_print_term := pay_ca_rl1_reg.get_parameter('PRINT_TERM',l_legislative_parameters);

511: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
512: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
513: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
514: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);
515: l_print_term := pay_ca_rl1_reg.get_parameter('PRINT_TERM',l_legislative_parameters);
516:
517: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));
518:
519: l_rl1reg_pre_org_id := pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID',

Line 519: l_rl1reg_pre_org_id := pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID',

515: l_print_term := pay_ca_rl1_reg.get_parameter('PRINT_TERM',l_legislative_parameters);
516:
517: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));
518:
519: l_rl1reg_pre_org_id := pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID',
520: l_legislative_parameters);
521:
522: hr_utility.trace('begining of action creation 4 *'||
523: l_rl1reg_pre_org_id||'*');

Line 969: decode(pay_ca_rl1_reg.get_parameter(''P_S1'',ppa1.legislative_parameters),

965: from per_all_assignments_f paaf2
966: where paaf2.assignment_id = paf.assignment_id
967: and paaf2.effective_start_date <= ppa1.effective_date)
968: order by
969: decode(pay_ca_rl1_reg.get_parameter(''P_S1'',ppa1.legislative_parameters),
970: ''RL1_PRE'',hou.name,
971: ''RL1_ORG'',hou1.name,
972: ''RL1_LOC'',loc.location_code,null)
973: ,decode(pay_ca_rl1_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),

Line 973: ,decode(pay_ca_rl1_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),

969: decode(pay_ca_rl1_reg.get_parameter(''P_S1'',ppa1.legislative_parameters),
970: ''RL1_PRE'',hou.name,
971: ''RL1_ORG'',hou1.name,
972: ''RL1_LOC'',loc.location_code,null)
973: ,decode(pay_ca_rl1_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),
974: ''RL1_PRE'',hou.name,
975: ''RL1_ORG'',hou1.name,
976: ''RL1_LOC'',loc.location_code,null)
977: ,decode(pay_ca_rl1_reg.get_parameter(''P_S3'',ppa1.legislative_parameters),

Line 977: ,decode(pay_ca_rl1_reg.get_parameter(''P_S3'',ppa1.legislative_parameters),

973: ,decode(pay_ca_rl1_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),
974: ''RL1_PRE'',hou.name,
975: ''RL1_ORG'',hou1.name,
976: ''RL1_LOC'',loc.location_code,null)
977: ,decode(pay_ca_rl1_reg.get_parameter(''P_S3'',ppa1.legislative_parameters),
978: ''RL1_PRE'',hou.name,
979: ''RL1_ORG'',hou1.name,
980: ''RL1_LOC'',loc.location_code,null)
981: ,ppf.last_name,ppf.first_name';

Line 1179: end pay_ca_rl1_reg;

1175:
1176: return l_label_meaning;
1177: end get_label;
1178:
1179: end pay_ca_rl1_reg;