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

Line 350: SELECT pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters) payroll_action_id

346: IS
347: --
348: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
349: IS
350: SELECT pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters) payroll_action_id
351: ,pay_core_utils.get_parameter('ASSETID',legislative_parameters) assignment_set_id
352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id

Line 351: ,pay_core_utils.get_parameter('ASSETID',legislative_parameters) assignment_set_id

347: --
348: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
349: IS
350: SELECT pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters) payroll_action_id
351: ,pay_core_utils.get_parameter('ASSETID',legislative_parameters) assignment_set_id
352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year

Line 352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group

348: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
349: IS
350: SELECT pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters) payroll_action_id
351: ,pay_core_utils.get_parameter('ASSETID',legislative_parameters) assignment_set_id
352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
356: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date

Line 353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat

349: IS
350: SELECT pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters) payroll_action_id
351: ,pay_core_utils.get_parameter('ASSETID',legislative_parameters) assignment_set_id
352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
356: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
357: ,pay_core_utils.get_parameter('PAY_ARCH',legislative_parameters) payroll_arch

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

350: SELECT pay_core_utils.get_parameter('PAYROLL_ACTION_ID',legislative_parameters) payroll_action_id
351: ,pay_core_utils.get_parameter('ASSETID',legislative_parameters) assignment_set_id
352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
356: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
357: ,pay_core_utils.get_parameter('PAY_ARCH',legislative_parameters) payroll_arch
358: ,pay_core_utils.get_parameter('SORT1',legislative_parameters) sort_order

Line 355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year

351: ,pay_core_utils.get_parameter('ASSETID',legislative_parameters) assignment_set_id
352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
356: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
357: ,pay_core_utils.get_parameter('PAY_ARCH',legislative_parameters) payroll_arch
358: ,pay_core_utils.get_parameter('SORT1',legislative_parameters) sort_order
359: FROM pay_payroll_actions PPA

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

352: ,pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
356: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
357: ,pay_core_utils.get_parameter('PAY_ARCH',legislative_parameters) payroll_arch
358: ,pay_core_utils.get_parameter('SORT1',legislative_parameters) sort_order
359: FROM pay_payroll_actions PPA
360: WHERE PPA.payroll_action_id = p_payroll_action_id;

Line 357: ,pay_core_utils.get_parameter('PAY_ARCH',legislative_parameters) payroll_arch

353: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
356: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
357: ,pay_core_utils.get_parameter('PAY_ARCH',legislative_parameters) payroll_arch
358: ,pay_core_utils.get_parameter('SORT1',legislative_parameters) sort_order
359: FROM pay_payroll_actions PPA
360: WHERE PPA.payroll_action_id = p_payroll_action_id;
361: --

Line 358: ,pay_core_utils.get_parameter('SORT1',legislative_parameters) sort_order

354: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
355: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
356: ,TO_DATE(pay_core_utils.get_parameter('EDATE',legislative_parameters),'YYYY/MM/DD') effective_date
357: ,pay_core_utils.get_parameter('PAY_ARCH',legislative_parameters) payroll_arch
358: ,pay_core_utils.get_parameter('SORT1',legislative_parameters) sort_order
359: FROM pay_payroll_actions PPA
360: WHERE PPA.payroll_action_id = p_payroll_action_id;
361: --
362: -- Local Variables

Line 553: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));

549: INTO lc_legislative_parameters
550: FROM pay_payroll_actions
551: WHERE payroll_action_id = ln_cur_pact;
552: --
553: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
554:
555: hr_utility.set_location ('ln_cur_assact.. '||ln_cur_assact,20);
556: hr_utility.set_location ('ln_cur_pact... '||ln_cur_pact,20);
557: hr_utility.set_location ('ln_pact_id .. '||ln_pact_id,20);

Line 768: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));

764: INTO lc_legislative_parameters
765: FROM pay_payroll_actions
766: WHERE payroll_action_id = p_payroll_action_id;
767: --
768: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
769: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSETID',lc_legislative_parameters));
770: --
771: g_mag_payroll_action_id:=p_payroll_action_id;
772: gb_debug :=hr_utility.debug_enabled ;

Line 769: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSETID',lc_legislative_parameters));

765: FROM pay_payroll_actions
766: WHERE payroll_action_id = p_payroll_action_id;
767: --
768: ln_old_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAY_ARCH',lc_legislative_parameters));
769: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSETID',lc_legislative_parameters));
770: --
771: g_mag_payroll_action_id:=p_payroll_action_id;
772: gb_debug :=hr_utility.debug_enabled ;
773: --