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.3 2006/02/11 00:09:29 ssouresr noship $ */
3: /*
4: Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
5: --

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

181: where ppa.payroll_action_id = :payroll_action_id
182: and fai1.user_entity_id = fdi1.user_entity_id
183: and fdi1.user_name = ''CAEOY_TAXATION_YEAR''
184: and fai1.value =
185: nvl(pay_ca_rl1_reg.get_parameter(''TAX_YEAR'',
186: ppa.legislative_parameters),fai1.value)
187: and fai2.user_entity_id = fdi2.user_entity_id
188: and fdi2.user_name = ''CAEOY_RL1_PRE_ORG_ID''
189: and fai2.value =

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

186: ppa.legislative_parameters),fai1.value)
187: and fai2.user_entity_id = fdi2.user_entity_id
188: and fdi2.user_name = ''CAEOY_RL1_PRE_ORG_ID''
189: and fai2.value =
190: nvl(pay_ca_rl1_reg.get_parameter(''PRE_ORGANIZATION_ID'',
191: ppa.legislative_parameters),
192: fai2.value)
193: and fai1.context1 = fai2.context1
194: and paa.payroll_action_id= fai2.context1

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

194: and paa.payroll_action_id= fai2.context1
195: and paa.assignment_action_id=fai3.context1
196: and fai3.user_entity_id = fdi3.user_entity_id
197: and fdi3.user_name = ''CAEOY_PERSON_ID''
198: and fai3.value = nvl(pay_ca_rl1_reg.get_parameter(''PER_ID'',
199: ppa.legislative_parameters),fai3.value)
200: order by to_number(fai3.value)';
201:
202: hr_utility.trace('End of range_cursor 2 ');

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

370: to_char(l_bus_group_id));
371:
372: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
373:
374: l_year := pay_ca_rl1_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
375: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
376: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
377: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
378: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);

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

373:
374: l_year := pay_ca_rl1_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
375: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
376: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
377: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
378: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);
379:
380: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));
381:

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

374: l_year := pay_ca_rl1_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
375: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
376: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;
377: l_asg_set_id := pay_ca_rl1_reg.get_parameter('ASG_SET_ID',l_legislative_parameters);
378: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);
379:
380: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));
381:
382: l_rl1reg_pre_org_id := pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID',

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

378: lv_per_id := pay_ca_rl1_reg.get_parameter('PER_ID',l_legislative_parameters);
379:
380: hr_utility.trace('begin action creation '||l_year||to_char(l_year_start)||to_char(l_year_end));
381:
382: l_rl1reg_pre_org_id := pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID',
383: l_legislative_parameters);
384:
385: hr_utility.trace('begining of action creation 4 *'||
386: l_rl1reg_pre_org_id||'*');

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

671: from per_all_assignments_f paaf2
672: where paaf2.assignment_id = paf.assignment_id
673: and paaf2.effective_start_date <= ppa1.effective_date)
674: order by
675: decode(pay_ca_rl1_reg.get_parameter(''P_S1'',ppa1.legislative_parameters),
676: ''RL1_PRE'',hou.name,
677: ''RL1_ORG'',hou1.name,
678: ''RL1_LOC'',loc.location_code,null)
679: ,decode(pay_ca_rl1_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),

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

675: decode(pay_ca_rl1_reg.get_parameter(''P_S1'',ppa1.legislative_parameters),
676: ''RL1_PRE'',hou.name,
677: ''RL1_ORG'',hou1.name,
678: ''RL1_LOC'',loc.location_code,null)
679: ,decode(pay_ca_rl1_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),
680: ''RL1_PRE'',hou.name,
681: ''RL1_ORG'',hou1.name,
682: ''RL1_LOC'',loc.location_code,null)
683: ,decode(pay_ca_rl1_reg.get_parameter(''P_S3'',ppa1.legislative_parameters),

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

679: ,decode(pay_ca_rl1_reg.get_parameter(''P_S2'',ppa1.legislative_parameters),
680: ''RL1_PRE'',hou.name,
681: ''RL1_ORG'',hou1.name,
682: ''RL1_LOC'',loc.location_code,null)
683: ,decode(pay_ca_rl1_reg.get_parameter(''P_S3'',ppa1.legislative_parameters),
684: ''RL1_PRE'',hou.name,
685: ''RL1_ORG'',hou1.name,
686: ''RL1_LOC'',loc.location_code,null)
687: ,ppf.last_name,ppf.first_name';

Line 885: end pay_ca_rl1_reg;

881:
882: return l_label_meaning;
883: end get_label;
884:
885: end pay_ca_rl1_reg;