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_FR_ARC_PKG dependencies on PAY_FR_ARC_PKG

Line 1: package body PAY_FR_ARC_PKG as

1: package body PAY_FR_ARC_PKG as
2: /* $Header: pyfrarch.pkb 120.3 2006/03/05 12:07:10 aparkes noship $ */
3: --
4: -- Globals
5: --

Line 6: g_package CONSTANT VARCHAR2(20):= 'pay_fr_arc_pkg.';

2: /* $Header: pyfrarch.pkb 120.3 2006/03/05 12:07:10 aparkes noship $ */
3: --
4: -- Globals
5: --
6: g_package CONSTANT VARCHAR2(20):= 'pay_fr_arc_pkg.';
7: --
8: -- Parameters to the process - g_payroll_action_id is the cache context
9: --
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

Line 155: pay_fr_arc_pkg.load_payslip_text (

151: hr_utility.set_location('Entering ' || l_proc,10);
152: --
153: -- Get the descriptive text for running subtotals and YTD balances
154: --
155: pay_fr_arc_pkg.load_payslip_text (
156: p_action_id => pactid);
157: --
158: hr_utility.set_location('Step ' || l_proc,20);
159: --

Line 225: pay_fr_arc_pkg.get_all_parameters

221:
222: if g_payroll_action_id is null
223: or g_payroll_action_id <> pactid
224: then
225: pay_fr_arc_pkg.get_all_parameters
226: (p_payroll_action_id => pactid
227: ,p_payroll_id => g_param_payroll_id
228: ,p_assignment_id => g_param_assignment_id
229: ,p_assignment_set_id => g_param_assignment_set_id

Line 317: g_1total_gross_pay_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_GROSS_PAY'

313: -- Load the defined balance ids, note balance 12 is a PTD
314: --
315: hr_utility.set_location('Entering ' || l_proc, 10);
316: hr_utility.set_location('Loading def balance ids ' || l_proc, 20);
317: g_1total_gross_pay_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_GROSS_PAY'
318: ,'Assignment Establishment Year To Date');
319: g_2ss_ceiling_db := pay_fr_arc_pkg.get_balance_id('FR_SS_CEILING'
320: ,'Assignment Establishment Year To Date');
321: g_3es_total_contributions_db := pay_fr_arc_pkg.get_balance_id('FR_EMPLOYEES_TOTAL_CONTRIBUTIONS'

Line 319: g_2ss_ceiling_db := pay_fr_arc_pkg.get_balance_id('FR_SS_CEILING'

315: hr_utility.set_location('Entering ' || l_proc, 10);
316: hr_utility.set_location('Loading def balance ids ' || l_proc, 20);
317: g_1total_gross_pay_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_GROSS_PAY'
318: ,'Assignment Establishment Year To Date');
319: g_2ss_ceiling_db := pay_fr_arc_pkg.get_balance_id('FR_SS_CEILING'
320: ,'Assignment Establishment Year To Date');
321: g_3es_total_contributions_db := pay_fr_arc_pkg.get_balance_id('FR_EMPLOYEES_TOTAL_CONTRIBUTIONS'
322: ,'Assignment Establishment Year To Date');
323: g_4statutory_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_STATUTORY_EMPLOYER_CHARGES'

Line 321: g_3es_total_contributions_db := pay_fr_arc_pkg.get_balance_id('FR_EMPLOYEES_TOTAL_CONTRIBUTIONS'

317: g_1total_gross_pay_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_GROSS_PAY'
318: ,'Assignment Establishment Year To Date');
319: g_2ss_ceiling_db := pay_fr_arc_pkg.get_balance_id('FR_SS_CEILING'
320: ,'Assignment Establishment Year To Date');
321: g_3es_total_contributions_db := pay_fr_arc_pkg.get_balance_id('FR_EMPLOYEES_TOTAL_CONTRIBUTIONS'
322: ,'Assignment Establishment Year To Date');
323: g_4statutory_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_STATUTORY_EMPLOYER_CHARGES'
324: ,'Assignment Establishment Year To Date');
325: g_5conventional_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_CONVENTIONAL_EMPLOYER_CHARGES'

Line 323: g_4statutory_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_STATUTORY_EMPLOYER_CHARGES'

319: g_2ss_ceiling_db := pay_fr_arc_pkg.get_balance_id('FR_SS_CEILING'
320: ,'Assignment Establishment Year To Date');
321: g_3es_total_contributions_db := pay_fr_arc_pkg.get_balance_id('FR_EMPLOYEES_TOTAL_CONTRIBUTIONS'
322: ,'Assignment Establishment Year To Date');
323: g_4statutory_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_STATUTORY_EMPLOYER_CHARGES'
324: ,'Assignment Establishment Year To Date');
325: g_5conventional_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_CONVENTIONAL_EMPLOYER_CHARGES'
326: ,'Assignment Establishment Year To Date');
327: g_6t1_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T1_ARRCO_BAND'

Line 325: g_5conventional_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_CONVENTIONAL_EMPLOYER_CHARGES'

321: g_3es_total_contributions_db := pay_fr_arc_pkg.get_balance_id('FR_EMPLOYEES_TOTAL_CONTRIBUTIONS'
322: ,'Assignment Establishment Year To Date');
323: g_4statutory_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_STATUTORY_EMPLOYER_CHARGES'
324: ,'Assignment Establishment Year To Date');
325: g_5conventional_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_CONVENTIONAL_EMPLOYER_CHARGES'
326: ,'Assignment Establishment Year To Date');
327: g_6t1_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T1_ARRCO_BAND'
328: ,'Assignment Establishment Year To Date');
329: g_7t2_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T2_ARRCO_BAND'

Line 327: g_6t1_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T1_ARRCO_BAND'

323: g_4statutory_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_STATUTORY_EMPLOYER_CHARGES'
324: ,'Assignment Establishment Year To Date');
325: g_5conventional_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_CONVENTIONAL_EMPLOYER_CHARGES'
326: ,'Assignment Establishment Year To Date');
327: g_6t1_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T1_ARRCO_BAND'
328: ,'Assignment Establishment Year To Date');
329: g_7t2_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T2_ARRCO_BAND'
330: ,'Assignment Establishment Year To Date');
331: g_8tb_argic_band_db := pay_fr_arc_pkg.get_balance_id('FR_TB_AGIRC_BAND'

Line 329: g_7t2_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T2_ARRCO_BAND'

325: g_5conventional_er_charges_db := pay_fr_arc_pkg.get_balance_id('FR_CONVENTIONAL_EMPLOYER_CHARGES'
326: ,'Assignment Establishment Year To Date');
327: g_6t1_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T1_ARRCO_BAND'
328: ,'Assignment Establishment Year To Date');
329: g_7t2_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T2_ARRCO_BAND'
330: ,'Assignment Establishment Year To Date');
331: g_8tb_argic_band_db := pay_fr_arc_pkg.get_balance_id('FR_TB_AGIRC_BAND'
332: ,'Assignment Establishment Year To Date');
333: g_9tc_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_TC_AGIRC_BAND'

Line 331: g_8tb_argic_band_db := pay_fr_arc_pkg.get_balance_id('FR_TB_AGIRC_BAND'

327: g_6t1_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T1_ARRCO_BAND'
328: ,'Assignment Establishment Year To Date');
329: g_7t2_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T2_ARRCO_BAND'
330: ,'Assignment Establishment Year To Date');
331: g_8tb_argic_band_db := pay_fr_arc_pkg.get_balance_id('FR_TB_AGIRC_BAND'
332: ,'Assignment Establishment Year To Date');
333: g_9tc_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_TC_AGIRC_BAND'
334: ,'Assignment Establishment Year To Date');
335: g_10gmp_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_GMP_AGIRC_BAND'

Line 333: g_9tc_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_TC_AGIRC_BAND'

329: g_7t2_arrco_band_db := pay_fr_arc_pkg.get_balance_id('FR_T2_ARRCO_BAND'
330: ,'Assignment Establishment Year To Date');
331: g_8tb_argic_band_db := pay_fr_arc_pkg.get_balance_id('FR_TB_AGIRC_BAND'
332: ,'Assignment Establishment Year To Date');
333: g_9tc_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_TC_AGIRC_BAND'
334: ,'Assignment Establishment Year To Date');
335: g_10gmp_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_GMP_AGIRC_BAND'
336: ,'Assignment Establishment Year To Date');
337: g_11total_cost_to_employer_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_COST_TO_EMPLOYER'

Line 335: g_10gmp_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_GMP_AGIRC_BAND'

331: g_8tb_argic_band_db := pay_fr_arc_pkg.get_balance_id('FR_TB_AGIRC_BAND'
332: ,'Assignment Establishment Year To Date');
333: g_9tc_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_TC_AGIRC_BAND'
334: ,'Assignment Establishment Year To Date');
335: g_10gmp_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_GMP_AGIRC_BAND'
336: ,'Assignment Establishment Year To Date');
337: g_11total_cost_to_employer_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_COST_TO_EMPLOYER'
338: ,'Assignment Establishment Year To Date');
339: g_12taxable_income_db := pay_fr_arc_pkg.get_balance_id('FR_TAXABLE_INCOME'

Line 337: g_11total_cost_to_employer_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_COST_TO_EMPLOYER'

333: g_9tc_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_TC_AGIRC_BAND'
334: ,'Assignment Establishment Year To Date');
335: g_10gmp_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_GMP_AGIRC_BAND'
336: ,'Assignment Establishment Year To Date');
337: g_11total_cost_to_employer_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_COST_TO_EMPLOYER'
338: ,'Assignment Establishment Year To Date');
339: g_12taxable_income_db := pay_fr_arc_pkg.get_balance_id('FR_TAXABLE_INCOME'
340: ,'Assignment Establishment Period To Date');
341: --

Line 339: g_12taxable_income_db := pay_fr_arc_pkg.get_balance_id('FR_TAXABLE_INCOME'

335: g_10gmp_agirc_band_db := pay_fr_arc_pkg.get_balance_id('FR_GMP_AGIRC_BAND'
336: ,'Assignment Establishment Year To Date');
337: g_11total_cost_to_employer_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_COST_TO_EMPLOYER'
338: ,'Assignment Establishment Year To Date');
339: g_12taxable_income_db := pay_fr_arc_pkg.get_balance_id('FR_TAXABLE_INCOME'
340: ,'Assignment Establishment Period To Date');
341: --
342: -- Get the translated names of input values from NAME Translations lookup
343: --

Line 373: pay_fr_arc_pkg.get_all_parameters

369: if g_payroll_action_id is null
370: or g_payroll_action_id <> p_payroll_action_id
371: then
372: hr_utility.set_location('Loading parameters ' || l_proc, 60);
373: pay_fr_arc_pkg.get_all_parameters
374: (p_payroll_action_id => p_payroll_action_id
375: ,p_payroll_id => g_param_payroll_id
376: ,p_assignment_id => g_param_assignment_id
377: ,p_assignment_set_id => g_param_assignment_set_id

Line 633: pay_fr_arc_pkg.get_instance_variables (

629: --
630: -------------------------------------------------------------------
631: -- Get instance variables for this particular assignment action
632: -------------------------------------------------------------------
633: pay_fr_arc_pkg.get_instance_variables (
634: p_assignment_action_id => p_assactid
635: ,p_person_id => l_person_id /* out */
636: ,p_establishment_id => l_establishment_id /* out */
637: ,p_assignment_id => l_assignment_id /* out */

Line 644: pay_fr_arc_pkg.get_latest_run_data (

640: -------------------------------------------------------------------
641: -- Get latest date earned (no archiving) and process type
642: -------------------------------------------------------------------
643: hr_utility.set_location('Step ' || l_proc,20);
644: pay_fr_arc_pkg.get_latest_run_data (
645: p_archive_action_id => p_assactid
646: ,p_assignment_id => l_assignment_id
647: ,p_establishment_id => l_establishment_id
648: ,p_date_earned => l_latest_date_paid /* out */

Line 661: pay_fr_arc_pkg.load_employee_dates (

657: -- Get the employee dates start / end estab, pay_period dates,
658: -- term date, sen date and archive
659: -------------------------------------------------------------------
660: hr_utility.set_location('Step ' || l_proc,30);
661: pay_fr_arc_pkg.load_employee_dates (
662: p_assignment_id => l_assignment_id
663: ,p_effective_date => g_param_effective_date
664: ,p_assignment_action_id => p_assactid
665: ,p_latest_date_earned => l_latest_date_paid

Line 682: pay_fr_arc_pkg.load_employee (

678: -- Get the employee data and archive AS AT p_asat date
679: -------------------------------------------------------------------
680: hr_utility.set_location('Step ' || l_proc,40);
681: hr_utility.set_location('person_id is ' || to_char(l_person_id),12);
682: pay_fr_arc_pkg.load_employee (
683: p_assignment_id => l_assignment_id
684: ,p_person_id => l_person_id
685: ,p_asat_date => l_ee_asat_date
686: ,p_assignment_action_id => p_assactid

Line 695: pay_fr_arc_pkg.load_balances(

691: -------------------------------------------------------------------
692: -- Get the balance values and archive
693: -------------------------------------------------------------------
694: hr_utility.set_location('Step ' || l_proc,50);
695: pay_fr_arc_pkg.load_balances(
696: p_assignment_action_id => l_latest_assignment_action_id /* TO GET BALANCE VALUES */
697: ,p_archive_action_id => p_assactid
698: ,p_context_id => l_establishment_id
699: ,p_totals_taxable_income => l_totals_c4_taxable_income);

Line 705: pay_fr_arc_pkg.load_holidays (

701: -------------------------------------------------------------------
702: -- Get the Holidays values and archive
703: -------------------------------------------------------------------
704: hr_utility.set_location('Step ' || l_proc,60);
705: pay_fr_arc_pkg.load_holidays (
706: p_assignment_id => l_assignment_id
707: ,p_person_id => l_person_id
708: ,p_effective_date => g_param_effective_date
709: ,p_assignment_action_id => p_assactid

Line 717: pay_fr_arc_pkg.load_bank (

713: -------------------------------------------------------------------
714: -- Get the BANK values and archive
715: -------------------------------------------------------------------
716: hr_utility.set_location('Step ' || l_proc,70);
717: pay_fr_arc_pkg.load_bank (
718: p_assignment_action_id => p_assactid
719: ,p_assignment_id => l_assignment_id
720: ,p_totals_previous_advice => l_totals_c8_previous_advice
721: ,p_totals_this_advice => l_totals_c9_this_advice

Line 730: pay_fr_arc_pkg.load_messages (

726: -------------------------------------------------------------------
727: -- Get the MESSAGES values and archive
728: -------------------------------------------------------------------
729: hr_utility.set_location('Step ' || l_proc,80);
730: pay_fr_arc_pkg.load_messages (
731: p_archive_assignment_action_id => p_assactid
732: ,p_establishment_id => l_establishment_id
733: ,p_term_atd => l_term_atd
734: ,p_term_reason => l_term_reason);

Line 741: pay_fr_arc_pkg.load_ee_rate_grouped_runs(

737: -- Get the Rate GROUPED Earnings and Net payments run values and archive
738: -- pass back total gross pay, net pay and court orders
739: -------------------------------------------------------------------
740: hr_utility.set_location('Step ' || l_proc,90);
741: pay_fr_arc_pkg.load_ee_rate_grouped_runs(
742: p_archive_assignment_action_id => p_assactid
743: ,p_assignment_id => l_assignment_id
744: ,p_latest_process_type => l_latest_process_type
745: ,p_total_gross_pay => l_totals_c1_total_gross /* out */

Line 761: pay_fr_arc_pkg.load_deductions(

757: -------------------------------------------------------------------
758: -- Get the DEDUCTIONS values and archive
759: -------------------------------------------------------------------
760: hr_utility.set_location('Step ' || l_proc,100);
761: pay_fr_arc_pkg.load_deductions(
762: p_archive_assignment_action_id => p_assactid
763: ,p_assignment_id => l_assignment_id
764: ,p_latest_process_type => l_latest_process_type
765: ,p_total_deduct_ee => l_totals_c3_total_deduct_ee /* out */

Line 776: pay_fr_arc_pkg.load_rate_grouped_runs(

772: -------------------------------------------------------------------
773: -- Get the RATE GROUPED run values and archive (net ee and ER LV)
774: -------------------------------------------------------------------
775: hr_utility.set_location('Step ' || l_proc,110);
776: pay_fr_arc_pkg.load_rate_grouped_runs(
777: p_archive_assignment_action_id => p_assactid
778: ,p_assignment_id => l_assignment_id
779: ,p_latest_process_type => l_latest_process_type
780: ,p_total_ee_net_deductions => l_total_ee_net_deductions

Line 3140: pay_fr_arc_pkg.write_archive(p_action_context_id => p_archive_assignment_action_id

3136: -- Arcvive ee values
3137: --
3138: if rec_results.class = 'EE' then
3139: l_ee_context_order := l_ee_context_order + 1;
3140: pay_fr_arc_pkg.write_archive(p_action_context_id => p_archive_assignment_action_id
3141: ,p_action_context_type => l_archive_type
3142: ,p_context_prefix => l_context_prefix
3143: ,p_rubric => rec_results.rubric
3144: ,p_rubric_sort => l_ee_context_order

Line 3158: pay_fr_arc_pkg.write_archive(p_action_context_id => p_archive_assignment_action_id

3154: --
3155: -- Arcvive er values
3156: --
3157: l_er_context_order := l_er_context_order + 1;
3158: pay_fr_arc_pkg.write_archive(p_action_context_id => p_archive_assignment_action_id
3159: ,p_action_context_type => l_archive_type
3160: ,p_context_prefix => l_context_prefix
3161: ,p_rubric => rec_results.rubric
3162: ,p_rubric_sort => l_er_context_order

Line 3243: SELECT pay_fr_arc_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')

3239: ,p_start_date out nocopy date
3240: ,p_effective_date out nocopy date) is
3241: --
3242: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
3243: SELECT pay_fr_arc_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
3244: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_ID')
3245: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_SET')
3246: ,business_group_id
3247: ,start_date

Line 3244: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_ID')

3240: ,p_effective_date out nocopy date) is
3241: --
3242: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
3243: SELECT pay_fr_arc_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
3244: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_ID')
3245: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_SET')
3246: ,business_group_id
3247: ,start_date
3248: ,effective_date

Line 3245: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_SET')

3241: --
3242: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
3243: SELECT pay_fr_arc_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
3244: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_ID')
3245: ,pay_fr_arc_pkg.get_parameter(legislative_parameters, 'ASSIGNMENT_SET')
3246: ,business_group_id
3247: ,start_date
3248: ,effective_date
3249: FROM pay_payroll_actions

Line 3324: pay_fr_arc_pkg.get_all_parameters (

3320: --
3321: if g_payroll_action_id is null
3322: or g_payroll_action_id <> p_payroll_action_id
3323: then
3324: pay_fr_arc_pkg.get_all_parameters (
3325: p_payroll_action_id => p_payroll_action_id
3326: ,p_payroll_id => g_param_payroll_id
3327: ,p_assignment_id => g_param_assignment_id
3328: ,p_assignment_set_id => g_param_assignment_set_id

Line 3340: pay_fr_arc_pkg.load_organization_details(

3336: -- Get the company addresses and establishment addresses and
3337: -- company and establishment details
3338: --
3339: hr_utility.set_location('Step ' || l_proc,30);
3340: pay_fr_arc_pkg.load_organization_details(
3341: p_payroll_action_id => p_payroll_action_id
3342: ,p_business_Group_id => g_param_business_group_id
3343: ,p_payroll_id => g_param_payroll_id
3344: ,p_assignment_id => g_param_assignment_id

Line 4018: END pay_fr_arc_pkg;

4014: hr_utility.trace('p_total_charge_er='|| p_total_charge_er);
4015: --
4016: hr_utility.set_location('Leaving ' || l_proc, 210);
4017: END load_deductions;
4018: END pay_fr_arc_pkg;