APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_MAG_UTILS

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

169: end if;
170: close c_payroll_action;
171: hr_utility.set_location(gv_package || '.get_payroll_action_info', 30);
172:
173: ln_payroll_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
174: 'TRANSFER_PAYROLL_ID'
175: ,'TRANSFER_CONSOLIDATION_SET_ID'
176: ,lv_leg_parameter)));
177: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);

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

174: 'TRANSFER_PAYROLL_ID'
175: ,'TRANSFER_CONSOLIDATION_SET_ID'
176: ,lv_leg_parameter)));
177: hr_utility.set_location(gv_package || '.get_payroll_action_info', 40);
178: ln_consolidation_set_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
179: 'TRANSFER_CONSOLIDATION_SET_ID'
180: ,'TRANSFER_TAX_UNIT_ID'
181: ,lv_leg_parameter)));
182: hr_utility.set_location(gv_package || '.get_payroll_action_info', 50);

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

179: 'TRANSFER_CONSOLIDATION_SET_ID'
180: ,'TRANSFER_TAX_UNIT_ID'
181: ,lv_leg_parameter)));
182: hr_utility.set_location(gv_package || '.get_payroll_action_info', 50);
183: ln_tax_unit_id := to_number(rtrim(Pay_Mag_Utils.get_parameter(
184: 'TRANSFER_TAX_UNIT_ID'
185: ,null
186: ,lv_leg_parameter)));
187:

Line 410: and rtrim(pay_mag_utils.get_parameter(

406: and ppa1.report_type = ''FLS''
407: and ppa1.report_qualifier = ''PERIODIC''
408: and ppa1.report_category = ''RT'')
409: and :payroll_action_id is not null
410: and rtrim(pay_mag_utils.get_parameter(
411: ''TRANSFER_PAYROLL_ID''
412: ,''TRANSFER_CONSOLIDATION_SET_ID''
413: ,ppa.legislative_parameters)) =
414: nvl('''||ln_payroll_id

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

411: ''TRANSFER_PAYROLL_ID''
412: ,''TRANSFER_CONSOLIDATION_SET_ID''
413: ,ppa.legislative_parameters)) =
414: nvl('''||ln_payroll_id
415: ||''', rtrim(pay_mag_utils.get_parameter(
416: ''TRANSFER_PAYROLL_ID''
417: ,''TRANSFER_CONSOLIDATION_SET_ID''
418: ,ppa.legislative_parameters)))
419: and rtrim(pay_mag_utils.get_parameter(

Line 419: and rtrim(pay_mag_utils.get_parameter(

415: ||''', rtrim(pay_mag_utils.get_parameter(
416: ''TRANSFER_PAYROLL_ID''
417: ,''TRANSFER_CONSOLIDATION_SET_ID''
418: ,ppa.legislative_parameters)))
419: and rtrim(pay_mag_utils.get_parameter(
420: ''TRANSFER_CONSOLIDATION_SET_ID''
421: ,null
422: ,ppa.legislative_parameters)) =
423: nvl('''||ln_consolidation_set_id

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

420: ''TRANSFER_CONSOLIDATION_SET_ID''
421: ,null
422: ,ppa.legislative_parameters)) =
423: nvl('''||ln_consolidation_set_id
424: ||''', rtrim(pay_mag_utils.get_parameter(
425: ''TRANSFER_CONSOLIDATION_SET_ID''
426: ,null
427: ,ppa.legislative_parameters)))
428: order by paf.person_id';

Line 488: and rtrim(pay_mag_utils.get_parameter(

484: and ppa1.action_type = 'X'
485: and ppa1.report_type = 'FLS'
486: and ppa1.report_qualifier = 'PERIODIC'
487: and ppa1.report_category = 'RT')
488: and rtrim(pay_mag_utils.get_parameter(
489: 'TRANSFER_PAYROLL_ID'
490: ,'TRANSFER_CONSOLIDATION_SET_ID'
491: ,ppa.legislative_parameters)) =
492: nvl(to_char(cp_payroll_id),

Line 493: rtrim(pay_mag_utils.get_parameter(

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

Line 497: and rtrim(pay_mag_utils.get_parameter(

493: rtrim(pay_mag_utils.get_parameter(
494: 'TRANSFER_PAYROLL_ID'
495: ,'TRANSFER_CONSOLIDATION_SET_ID'
496: ,ppa.legislative_parameters)))
497: and rtrim(pay_mag_utils.get_parameter(
498: 'TRANSFER_CONSOLIDATION_SET_ID'
499: ,null
500: ,ppa.legislative_parameters)) =
501: nvl(to_char(cp_consolidation_set_id),

Line 502: rtrim(pay_mag_utils.get_parameter(

498: 'TRANSFER_CONSOLIDATION_SET_ID'
499: ,null
500: ,ppa.legislative_parameters)) =
501: nvl(to_char(cp_consolidation_set_id),
502: rtrim(pay_mag_utils.get_parameter(
503: 'TRANSFER_CONSOLIDATION_SET_ID'
504: ,null
505: ,ppa.legislative_parameters))) ;
506: