APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_MAG_UTILS

Line 164: ln_payroll_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(

160: end if;
161: close c_payroll_action;
162: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
163:
164: ln_payroll_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
165: 'TRANSFER_PAYROLL_ID'
166: ,'TRANSFER_CONSOLIDATION_SET_ID'
167: ,lv_leg_parameter)));
168: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);

Line 169: ln_consolidation_set_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(

165: 'TRANSFER_PAYROLL_ID'
166: ,'TRANSFER_CONSOLIDATION_SET_ID'
167: ,lv_leg_parameter)));
168: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);
169: ln_consolidation_set_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
170: 'TRANSFER_CONSOLIDATION_SET_ID'
171: ,'TRANSFER_TAX_UNIT_ID'
172: ,lv_leg_parameter)));
173: hr_utility.set_location(gv_package || '.get_payroll_action_info', 50);

Line 174: ln_tax_unit_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(

170: 'TRANSFER_CONSOLIDATION_SET_ID'
171: ,'TRANSFER_TAX_UNIT_ID'
172: ,lv_leg_parameter)));
173: hr_utility.set_location(gv_package || '.get_payroll_action_info', 50);
174: ln_tax_unit_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
175: 'TRANSFER_TAX_UNIT_ID'
176: ,null
177: ,lv_leg_parameter)));
178:

Line 401: and rtrim(pay_mag_utils.get_parameter(

397: and ppa1.report_type = ''FLS''
398: and ppa1.report_qualifier = ''PERIODIC''
399: and ppa1.report_category = ''RT'')
400: and :payroll_action_id is not null
401: and rtrim(pay_mag_utils.get_parameter(
402: ''TRANSFER_PAYROLL_ID''
403: ,''TRANSFER_CONSOLIDATION_SET_ID''
404: ,ppa.legislative_parameters)) =
405: nvl('''||ln_payroll_id

Line 406: ||''', rtrim(pay_mag_utils.get_parameter(

402: ''TRANSFER_PAYROLL_ID''
403: ,''TRANSFER_CONSOLIDATION_SET_ID''
404: ,ppa.legislative_parameters)) =
405: nvl('''||ln_payroll_id
406: ||''', rtrim(pay_mag_utils.get_parameter(
407: ''TRANSFER_PAYROLL_ID''
408: ,''TRANSFER_CONSOLIDATION_SET_ID''
409: ,ppa.legislative_parameters)))
410: and rtrim(pay_mag_utils.get_parameter(

Line 410: and rtrim(pay_mag_utils.get_parameter(

406: ||''', rtrim(pay_mag_utils.get_parameter(
407: ''TRANSFER_PAYROLL_ID''
408: ,''TRANSFER_CONSOLIDATION_SET_ID''
409: ,ppa.legislative_parameters)))
410: and rtrim(pay_mag_utils.get_parameter(
411: ''TRANSFER_CONSOLIDATION_SET_ID''
412: ,null
413: ,ppa.legislative_parameters)) =
414: nvl('''||ln_consolidation_set_id

Line 415: ||''', rtrim(pay_mag_utils.get_parameter(

411: ''TRANSFER_CONSOLIDATION_SET_ID''
412: ,null
413: ,ppa.legislative_parameters)) =
414: nvl('''||ln_consolidation_set_id
415: ||''', rtrim(pay_mag_utils.get_parameter(
416: ''TRANSFER_CONSOLIDATION_SET_ID''
417: ,null
418: ,ppa.legislative_parameters)))
419: order by paf.person_id';

Line 479: and rtrim(pay_mag_utils.get_parameter(

475: and ppa1.action_type = 'X'
476: and ppa1.report_type = 'FLS'
477: and ppa1.report_qualifier = 'PERIODIC'
478: and ppa1.report_category = 'RT')
479: and rtrim(pay_mag_utils.get_parameter(
480: 'TRANSFER_PAYROLL_ID'
481: ,'TRANSFER_CONSOLIDATION_SET_ID'
482: ,ppa.legislative_parameters)) =
483: nvl(to_char(cp_payroll_id),

Line 484: rtrim(pay_mag_utils.get_parameter(

480: 'TRANSFER_PAYROLL_ID'
481: ,'TRANSFER_CONSOLIDATION_SET_ID'
482: ,ppa.legislative_parameters)) =
483: nvl(to_char(cp_payroll_id),
484: rtrim(pay_mag_utils.get_parameter(
485: 'TRANSFER_PAYROLL_ID'
486: ,'TRANSFER_CONSOLIDATION_SET_ID'
487: ,ppa.legislative_parameters)))
488: and rtrim(pay_mag_utils.get_parameter(

Line 488: and rtrim(pay_mag_utils.get_parameter(

484: rtrim(pay_mag_utils.get_parameter(
485: 'TRANSFER_PAYROLL_ID'
486: ,'TRANSFER_CONSOLIDATION_SET_ID'
487: ,ppa.legislative_parameters)))
488: and rtrim(pay_mag_utils.get_parameter(
489: 'TRANSFER_CONSOLIDATION_SET_ID'
490: ,null
491: ,ppa.legislative_parameters)) =
492: nvl(to_char(cp_consolidation_set_id),

Line 493: rtrim(pay_mag_utils.get_parameter(

489: 'TRANSFER_CONSOLIDATION_SET_ID'
490: ,null
491: ,ppa.legislative_parameters)) =
492: nvl(to_char(cp_consolidation_set_id),
493: rtrim(pay_mag_utils.get_parameter(
494: 'TRANSFER_CONSOLIDATION_SET_ID'
495: ,null
496: ,ppa.legislative_parameters))) ;
497: