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_PYUCSLIS_PKG dependencies on PAY_CORE_UTILS

Line 5744: pay_core_utils.pay_action_parameter_group_id := p_action_parameter_group_id;

5740: p_update_date := trunc(sysdate);
5741:
5742: -- Bug 3813908
5743: if p_action_parameter_group_id is not null then
5744: pay_core_utils.pay_action_parameter_group_id := p_action_parameter_group_id;
5745: end if;
5746:
5747: generate_list_control
5748: (p_effective_date => nvl(fnd_date.canonical_to_date(p_effective_date)

Line 6093: select pay_core_utils.get_parameter('GENERATION_SCOPE',

6089: l_generation_scope varchar2(20);
6090: begin
6091: --hr_utility.trace_on('F','LISTGEN');
6092: hr_utility.set_location('Entering : '||l_proc,10);
6093: select pay_core_utils.get_parameter('GENERATION_SCOPE',
6094: pa1.legislative_parameters)
6095: into l_generation_scope
6096: from pay_payroll_actions pa1
6097: where payroll_action_id = pactid;

Line 6123: and pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'',

6119: sqlstr := 'select distinct per.person_id
6120: from per_all_people_f per
6121: ,pay_payroll_actions ppa
6122: where ppa.payroll_action_id = :payroll_action_id
6123: and pay_core_utils.get_parameter(''BUSINESS_GROUP_ID'',
6124: ppa.legislative_parameters) =
6125: per.business_group_id
6126: order by per.person_id';
6127: -- and ppa.effective_date between per.effective_start_date

Line 6260: and ( pay_core_utils.get_parameter('BUSINESS_GROUP_ID',

6256: ,pay_payroll_actions ppa
6257: where asg.assignment_type in ('E','A','C')
6258: and asg.person_id between stperson and endperson
6259: and ppa.payroll_action_id = pactid
6260: and ( pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
6261: ppa.legislative_parameters) =
6262: asg.business_group_id
6263: and pay_core_utils.get_parameter('GENERATION_SCOPE',
6264: ppa.legislative_parameters) =

Line 6263: and pay_core_utils.get_parameter('GENERATION_SCOPE',

6259: and ppa.payroll_action_id = pactid
6260: and ( pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
6261: ppa.legislative_parameters) =
6262: asg.business_group_id
6263: and pay_core_utils.get_parameter('GENERATION_SCOPE',
6264: ppa.legislative_parameters) =
6265: 'ALL_BUS_GRP'
6266: OR
6267: pay_core_utils.get_parameter('GENERATION_SCOPE',

Line 6267: pay_core_utils.get_parameter('GENERATION_SCOPE',

6263: and pay_core_utils.get_parameter('GENERATION_SCOPE',
6264: ppa.legislative_parameters) =
6265: 'ALL_BUS_GRP'
6266: OR
6267: pay_core_utils.get_parameter('GENERATION_SCOPE',
6268: ppa.legislative_parameters) =
6269: 'ALL_GLOBAL'
6270: OR
6271: pay_core_utils.get_parameter('GENERATION_SCOPE',

Line 6271: pay_core_utils.get_parameter('GENERATION_SCOPE',

6267: pay_core_utils.get_parameter('GENERATION_SCOPE',
6268: ppa.legislative_parameters) =
6269: 'ALL_GLOBAL'
6270: OR
6271: pay_core_utils.get_parameter('GENERATION_SCOPE',
6272: ppa.legislative_parameters) =
6273: 'ALL_PROFILES')
6274: and ((ppa.effective_date between asg.effective_start_date
6275: and asg.effective_end_date)

Line 6290: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',

6286: begin
6287:
6288: l_temp_person_id := null;
6289:
6290: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
6291: ppa.legislative_parameters),
6292: pay_core_utils.get_parameter('GENERATION_SCOPE',
6293: ppa.legislative_parameters),
6294: pay_core_utils.get_parameter('WHO_TO_PROCESS',

Line 6292: pay_core_utils.get_parameter('GENERATION_SCOPE',

6288: l_temp_person_id := null;
6289:
6290: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
6291: ppa.legislative_parameters),
6292: pay_core_utils.get_parameter('GENERATION_SCOPE',
6293: ppa.legislative_parameters),
6294: pay_core_utils.get_parameter('WHO_TO_PROCESS',
6295: ppa.legislative_parameters)
6296: into l_business_group_id, l_generation_scope, l_who_to_proc

Line 6294: pay_core_utils.get_parameter('WHO_TO_PROCESS',

6290: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
6291: ppa.legislative_parameters),
6292: pay_core_utils.get_parameter('GENERATION_SCOPE',
6293: ppa.legislative_parameters),
6294: pay_core_utils.get_parameter('WHO_TO_PROCESS',
6295: ppa.legislative_parameters)
6296: into l_business_group_id, l_generation_scope, l_who_to_proc
6297: from pay_payroll_actions ppa
6298: where ppa.payroll_action_id = pactid;

Line 6448: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',

6444: begin
6445: --hr_utility.trace_on('F','PERSLM');
6446:
6447:
6448: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
6449: ppa.legislative_parameters),
6450: pay_core_utils.get_parameter('GENERATION_SCOPE',
6451: ppa.legislative_parameters),
6452: pay_core_utils.get_parameter('WHO_TO_PROCESS',

Line 6450: pay_core_utils.get_parameter('GENERATION_SCOPE',

6446:
6447:
6448: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
6449: ppa.legislative_parameters),
6450: pay_core_utils.get_parameter('GENERATION_SCOPE',
6451: ppa.legislative_parameters),
6452: pay_core_utils.get_parameter('WHO_TO_PROCESS',
6453: ppa.legislative_parameters)
6454: into l_business_group_id, l_generation_scope, l_who_to_process

Line 6452: pay_core_utils.get_parameter('WHO_TO_PROCESS',

6448: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',
6449: ppa.legislative_parameters),
6450: pay_core_utils.get_parameter('GENERATION_SCOPE',
6451: ppa.legislative_parameters),
6452: pay_core_utils.get_parameter('WHO_TO_PROCESS',
6453: ppa.legislative_parameters)
6454: into l_business_group_id, l_generation_scope, l_who_to_process
6455: from pay_payroll_actions ppa,
6456: pay_assignment_actions paa