439:
440: hr_utility.set_location(gv_package || lv_procedure_name, 125);
441: lv_action_category := 'AC EARNINGS';
442: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
443: := fnd_number.number_to_canonical(ln_current_hours);
444: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
445: := fnd_number.number_to_canonical(ln_ytd_hours);
446:
447: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
441: lv_action_category := 'AC EARNINGS';
442: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
443: := fnd_number.number_to_canonical(ln_current_hours);
444: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
445: := fnd_number.number_to_canonical(ln_ytd_hours);
446:
447: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
448: := fnd_number.number_to_canonical(ln_current_days);
449: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
444: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
445: := fnd_number.number_to_canonical(ln_ytd_hours);
446:
447: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
448: := fnd_number.number_to_canonical(ln_current_days);
449: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
450: := fnd_number.number_to_canonical(ln_ytd_days);
451:
452: END IF;
446:
447: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
448: := fnd_number.number_to_canonical(ln_current_days);
449: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
450: := fnd_number.number_to_canonical(ln_ytd_days);
451:
452: END IF;
453:
454: hr_utility.set_location(gv_package || lv_procedure_name, 130);
462: := p_xfr_action_id;
463: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
464: := p_primary_balance_id;
465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
466: := fnd_number.number_to_canonical(ln_payments_amount);
467: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
468: := fnd_number.number_to_canonical(ln_ytd_amount);
469: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
470: := p_reporting_name;
464: := p_primary_balance_id;
465: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
466: := fnd_number.number_to_canonical(ln_payments_amount);
467: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
468: := fnd_number.number_to_canonical(ln_ytd_amount);
469: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
470: := p_reporting_name;
471: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
472: := p_attribute_name;
848: 'Taxable Benefits') THEN
849:
850: lv_action_info_category := 'AC EARNINGS';
851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
852: := fnd_number.number_to_canonical(ln_ytd_hours);
853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
854: := fnd_number.number_to_canonical(ln_ytd_days);
855:
856: END IF;
850: lv_action_info_category := 'AC EARNINGS';
851: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
852: := fnd_number.number_to_canonical(ln_ytd_hours);
853: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
854: := fnd_number.number_to_canonical(ln_ytd_days);
855:
856: END IF;
857:
858: ln_step := 20;
864: := p_xfr_action_id ;
865: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
866: := ln_primary_balance_id;
867: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
868: := fnd_number.number_to_canonical(ln_payments_amount);
869: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
870: := fnd_number.number_to_canonical(ln_ytd_amount);
871: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
872: := lv_reporting_name;
866: := ln_primary_balance_id;
867: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
868: := fnd_number.number_to_canonical(ln_payments_amount);
869: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
870: := fnd_number.number_to_canonical(ln_ytd_amount);
871: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
872: := lv_reporting_name;
873: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
874: := lv_attribute_name;
1138: := ln_assignment_id;
1139: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1140: := ln_primary_balance_id;
1141: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1142: := fnd_number.number_to_canonical(ln_ytd_amount);
1143: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1144: := lv_reporting_name;
1145: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1146: := lv_attribute_name;
1146: := lv_attribute_name;
1147:
1148: IF lv_act_info_category = 'AC EARNINGS' THEN
1149: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1150: := fnd_number.number_to_canonical(ln_ytd_hours);
1151: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1152: := fnd_number.number_to_canonical(ln_ytd_days);
1153: END IF;
1154: END IF;
1148: IF lv_act_info_category = 'AC EARNINGS' THEN
1149: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1150: := fnd_number.number_to_canonical(ln_ytd_hours);
1151: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1152: := fnd_number.number_to_canonical(ln_ytd_days);
1153: END IF;
1154: END IF;
1155:
1156: IF ln_assignment_id = p_assignment_id THEN
1277: 'Hourly Earnings',
1278: 'Taxable Benefits') THEN
1279: lv_action_info_category := 'AC EARNINGS';
1280: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1281: := fnd_number.number_to_canonical(ln_ytd_hours);
1282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1283: := fnd_number.number_to_canonical(ln_ytd_days);
1284:
1285: END IF;
1279: lv_action_info_category := 'AC EARNINGS';
1280: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1281: := fnd_number.number_to_canonical(ln_ytd_hours);
1282: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1283: := fnd_number.number_to_canonical(ln_ytd_days);
1284:
1285: END IF;
1286:
1287: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1292: := p_xfr_action_id;
1293: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1294: := ln_primary_balance_id;
1295: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1296: := fnd_number.number_to_canonical(ln_payments_amount);
1297: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1298: := fnd_number.number_to_canonical(ln_ytd_amount);
1299: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1300: := lv_reporting_name;
1294: := ln_primary_balance_id;
1295: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1296: := fnd_number.number_to_canonical(ln_payments_amount);
1297: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1298: := fnd_number.number_to_canonical(ln_ytd_amount);
1299: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1300: := lv_reporting_name;
1301: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1302: := lv_attribute_name;
2966: := p_xfr_action_id;
2967: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2968: := dbt(i).bal_type_id;
2969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2970: := fnd_number.number_to_canonical(ln_pymt_amount);
2971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2972: := fnd_number.number_to_canonical(ln_ytd_amount);
2973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2974: := lv_reporting_name;
2968: := dbt(i).bal_type_id;
2969: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2970: := fnd_number.number_to_canonical(ln_pymt_amount);
2971: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2972: := fnd_number.number_to_canonical(ln_ytd_amount);
2973: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
2974: := lv_reporting_name;
2975:
2976: IF dbt(i).act_info_category = 'AC DEDUCTIONS' THEN
3004:
3005: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3006: := 'MX SUMMARY CURRENT';
3007: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3008: := fnd_number.number_to_canonical(ln_gross_earnings);
3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3010: := fnd_number.number_to_canonical(ln_tax_deductions);
3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3012: := fnd_number.number_to_canonical(ln_deductions);
3006: := 'MX SUMMARY CURRENT';
3007: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3008: := fnd_number.number_to_canonical(ln_gross_earnings);
3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3010: := fnd_number.number_to_canonical(ln_tax_deductions);
3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3012: := fnd_number.number_to_canonical(ln_deductions);
3013: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3014: := fnd_number.number_to_canonical(ln_net_pay);
3008: := fnd_number.number_to_canonical(ln_gross_earnings);
3009: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3010: := fnd_number.number_to_canonical(ln_tax_deductions);
3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3012: := fnd_number.number_to_canonical(ln_deductions);
3013: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3014: := fnd_number.number_to_canonical(ln_net_pay);
3015:
3016: END IF;
3010: := fnd_number.number_to_canonical(ln_tax_deductions);
3011: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3012: := fnd_number.number_to_canonical(ln_deductions);
3013: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3014: := fnd_number.number_to_canonical(ln_net_pay);
3015:
3016: END IF;
3017:
3018: hr_utility.set_location(gv_package || lv_procedure_name, 75);
3021:
3022: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3023: := 'MX SUMMARY YTD';
3024: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3025: := fnd_number.number_to_canonical(ln_ytd_gross_earnings);
3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3027: := fnd_number.number_to_canonical(ln_ytd_tax_deductions);
3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3029: := fnd_number.number_to_canonical(ln_ytd_deductions);
3023: := 'MX SUMMARY YTD';
3024: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3025: := fnd_number.number_to_canonical(ln_ytd_gross_earnings);
3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3027: := fnd_number.number_to_canonical(ln_ytd_tax_deductions);
3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3029: := fnd_number.number_to_canonical(ln_ytd_deductions);
3030: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3031: := fnd_number.number_to_canonical(ln_ytd_net_pay);
3025: := fnd_number.number_to_canonical(ln_ytd_gross_earnings);
3026: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3027: := fnd_number.number_to_canonical(ln_ytd_tax_deductions);
3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3029: := fnd_number.number_to_canonical(ln_ytd_deductions);
3030: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3031: := fnd_number.number_to_canonical(ln_ytd_net_pay);
3032:
3033:
3027: := fnd_number.number_to_canonical(ln_ytd_tax_deductions);
3028: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3029: := fnd_number.number_to_canonical(ln_ytd_deductions);
3030: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3031: := fnd_number.number_to_canonical(ln_ytd_net_pay);
3032:
3033:
3034: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3035:
3461: hr_utility.trace('ln_index = ' || ln_index);
3462: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3463: := 'MX SUMMARY CURRENT';
3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3465: := fnd_number.number_to_canonical(lv_gross_earnings);
3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3467: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3469: := fnd_number.number_to_canonical(lv_deductions);
3463: := 'MX SUMMARY CURRENT';
3464: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3465: := fnd_number.number_to_canonical(lv_gross_earnings);
3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3467: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3469: := fnd_number.number_to_canonical(lv_deductions);
3470: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3471: := fnd_number.number_to_canonical(lv_gross_earnings -
3465: := fnd_number.number_to_canonical(lv_gross_earnings);
3466: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3467: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3469: := fnd_number.number_to_canonical(lv_deductions);
3470: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3471: := fnd_number.number_to_canonical(lv_gross_earnings -
3472: -- Bug 4168970
3473: lv_imputed_earnings -
3467: := fnd_number.number_to_canonical(lv_tax_deductions) ;
3468: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3469: := fnd_number.number_to_canonical(lv_deductions);
3470: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3471: := fnd_number.number_to_canonical(lv_gross_earnings -
3472: -- Bug 4168970
3473: lv_imputed_earnings -
3474: lv_tax_deductions -
3475: lv_deductions);
3481: hr_utility.trace('ln_index = ' || ln_index);
3482: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
3483: := 'MX SUMMARY YTD';
3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3485: := fnd_number.number_to_canonical(lv_ytd_gross_earnings);
3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3487: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3489: := fnd_number.number_to_canonical(lv_ytd_deductions);
3483: := 'MX SUMMARY YTD';
3484: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
3485: := fnd_number.number_to_canonical(lv_ytd_gross_earnings);
3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3487: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3489: := fnd_number.number_to_canonical(lv_ytd_deductions);
3490: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3491: := fnd_number.number_to_canonical(lv_ytd_gross_earnings -
3485: := fnd_number.number_to_canonical(lv_ytd_gross_earnings);
3486: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
3487: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3489: := fnd_number.number_to_canonical(lv_ytd_deductions);
3490: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3491: := fnd_number.number_to_canonical(lv_ytd_gross_earnings -
3492: -- Bug 4168970
3493: lv_ytd_imputed_earnings -
3487: := fnd_number.number_to_canonical(lv_ytd_tax_deductions) ;
3488: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
3489: := fnd_number.number_to_canonical(lv_ytd_deductions);
3490: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5 -- Bug 4155512
3491: := fnd_number.number_to_canonical(lv_ytd_gross_earnings -
3492: -- Bug 4168970
3493: lv_ytd_imputed_earnings -
3494: lv_ytd_tax_deductions -
3495: lv_ytd_deductions);
4641: hr_utility.trace('ln_current_days = ' ||ln_current_days);
4642: hr_utility.trace('ln_ytd_days = ' ||ln_ytd_days);
4643: ln_step := 120;
4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4645: := fnd_number.number_to_canonical(ln_current_hours);
4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4647: := fnd_number.number_to_canonical(ln_ytd_hours);
4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4649: := fnd_number.number_to_canonical(ln_current_days);
4643: ln_step := 120;
4644: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
4645: := fnd_number.number_to_canonical(ln_current_hours);
4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4647: := fnd_number.number_to_canonical(ln_ytd_hours);
4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4649: := fnd_number.number_to_canonical(ln_current_days);
4650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
4651: := fnd_number.number_to_canonical(ln_ytd_days);
4645: := fnd_number.number_to_canonical(ln_current_hours);
4646: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
4647: := fnd_number.number_to_canonical(ln_ytd_hours);
4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4649: := fnd_number.number_to_canonical(ln_current_days);
4650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
4651: := fnd_number.number_to_canonical(ln_ytd_days);
4652: ELSE
4653: lv_action_category := 'AC DEDUCTIONS';
4647: := fnd_number.number_to_canonical(ln_ytd_hours);
4648: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
4649: := fnd_number.number_to_canonical(ln_current_days);
4650: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
4651: := fnd_number.number_to_canonical(ln_ytd_days);
4652: ELSE
4653: lv_action_category := 'AC DEDUCTIONS';
4654: END IF;
4655: hr_utility.set_location(gv_package || lv_procedure_name, 150);
4667: := p_xfr_action_id;
4668: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
4669: := ln_primary_balance_id;
4670: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4671: := fnd_number.number_to_canonical(ln_payments_amount);
4672: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4673: := fnd_number.number_to_canonical(ln_ytd_amount);
4674: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4675: := lv_reporting_name;
4669: := ln_primary_balance_id;
4670: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
4671: := fnd_number.number_to_canonical(ln_payments_amount);
4672: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
4673: := fnd_number.number_to_canonical(ln_ytd_amount);
4674: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
4675: := lv_reporting_name;
4676:
4677: END IF;