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.PER_JP_WRKREG_REPORT_PKG dependencies on PAY_CORE_UTILS

Line 268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id

264: IS
265: --
266: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
267: IS
268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id
269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id

Line 269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid

265: --
266: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
267: IS
268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id
269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id

Line 270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id

266: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
267: IS
268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id
269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date

Line 271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy

267: IS
268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id
269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1

Line 272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id

268: SELECT fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters)) payroll_action_id
269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2

Line 273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id

269: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',legislative_parameters)) ass_setid
270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3

Line 274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date

270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp

Line 275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1

271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
279: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_eff_date_from

Line 276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2

272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
279: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_eff_date_from
280: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to

Line 277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3

273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
279: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_eff_date_from
280: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
281: FROM pay_payroll_actions PPA

Line 278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp

274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
279: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_eff_date_from
280: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
281: FROM pay_payroll_actions PPA
282: WHERE PPA.payroll_action_id = p_payroll_action_id;

Line 279: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_eff_date_from

275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
279: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_eff_date_from
280: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
281: FROM pay_payroll_actions PPA
282: WHERE PPA.payroll_action_id = p_payroll_action_id;
283: --

Line 280: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to

276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp
279: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') term_eff_date_from
280: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') term_eff_date_to
281: FROM pay_payroll_actions PPA
282: WHERE PPA.payroll_action_id = p_payroll_action_id;
283: --
284: -- Local Variables

Line 301: SELECT TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD')

297: OPEN lcr_params(p_payroll_action_id);
298: FETCH lcr_params into gr_parameters;
299: CLOSE lcr_params;
300: --
301: SELECT TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD')
302: INTO gr_parameters.effective_date
303: FROM pay_payroll_actions PPA
304: WHERE PPA.payroll_action_id = gr_parameters.payroll_action_id;
305: --

Line 725: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));

721: INTO lc_legislative_parameters
722: FROM pay_payroll_actions
723: WHERE payroll_action_id = p_payroll_action_id;
724: --
725: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
726: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));
727: --
728: g_mag_payroll_action_id:=p_payroll_action_id;
729: gb_debug :=hr_utility.debug_enabled ;

Line 726: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));

722: FROM pay_payroll_actions
723: WHERE payroll_action_id = p_payroll_action_id;
724: --
725: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
726: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));
727: --
728: g_mag_payroll_action_id:=p_payroll_action_id;
729: gb_debug :=hr_utility.debug_enabled ;
730: --

Line 1670: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));

1666: INTO lc_legislative_parameters
1667: FROM pay_payroll_actions
1668: WHERE payroll_action_id = ln_cur_pact;
1669: --
1670: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ACTION_ID',lc_legislative_parameters));
1671: --
1672: SELECT PAA1.assignment_action_id
1673: INTO ln_old_assact_id
1674: FROM pay_assignment_actions PAA,