APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_AC_ACTION_ARCH

Line 76: pay_ac_action_arch and

72: update_ytd_withheld
73: Modified py_archive_date and
74: py_action_creation. Calling
75: get_multi_assignment_flag of
76: pay_ac_action_arch and
77: arch_pay_action_level_data of
78: pay_emp_action_arch.
79: 19-FEB-2002 vpandya 115.7 Changed global variable name for
80: Multiple Assignment Payments.

Line 158: pay_ac_action_arch is being called.

154: cursor c_prev_run_information, which
155: was in get_last_xfr_info procedure.
156: This procedure has been removed from
157: this package and same procedure of
158: pay_ac_action_arch is being called.
159: 17-Apr-2004 rsethupa 115.27 3311866 SS Payslip Currency Format Enhancement
160: Current Amount and Ytd Amount for
161: category 'AC DEDUCTIONS' will be
162: archived in canonical format.

Line 427: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

423: hr_utility.set_location(gv_package || lv_procedure_name, 10);
424: i := 0;
425: j := 0;
426:
427: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
428: pay_balance_pkg.set_context('TAX_GROUP', gn_taxgrp_gre_id);
429: else
430: pay_balance_pkg.set_context('TAX_UNIT_ID', gn_taxgrp_gre_id);
431: end if;

Line 473: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

469: p_pymt_balcall_aaid),0);
470: end if;
471: end if; -- p_action_type = 'V'
472:
473: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
474: ln_step := 6;
475: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
476: dbt(i).tg_ytd_def_bal_id,
477: p_ytd_balcall_aaid),0);

Line 496: if tax(j).language = pay_ac_action_arch.gv_person_lang and

492:
493: ln_step := 9;
494: j := 0;
495: for j in tax.first..tax.last loop
496: if tax(j).language = pay_ac_action_arch.gv_person_lang and
497: tax(j).lookup_code = lv_lookup_code
498: then
499: lv_reporting_name := tax(j).meaning;
500: exit;

Line 510: ln_index := pay_ac_action_arch.lrr_act_tab.count;

506: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
507: hr_utility.set_location(gv_package || lv_procedure_name, 50);
508:
509: ln_step := 10;
510: ln_index := pay_ac_action_arch.lrr_act_tab.count;
511:
512: hr_utility.trace('ln_index is '
513: || pay_ac_action_arch.lrr_act_tab.count);
514:

Line 513: || pay_ac_action_arch.lrr_act_tab.count);

509: ln_step := 10;
510: ln_index := pay_ac_action_arch.lrr_act_tab.count;
511:
512: hr_utility.trace('ln_index is '
513: || pay_ac_action_arch.lrr_act_tab.count);
514:
515: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
516: := 'AC DEDUCTIONS';
517: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 515: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

511:
512: hr_utility.trace('ln_index is '
513: || pay_ac_action_arch.lrr_act_tab.count);
514:
515: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
516: := 'AC DEDUCTIONS';
517: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
518: := dbt(i).jurisdiction_cd;
519: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date

Line 517: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

513: || pay_ac_action_arch.lrr_act_tab.count);
514:
515: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
516: := 'AC DEDUCTIONS';
517: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
518: := dbt(i).jurisdiction_cd;
519: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date
520: -- := p_pymt_eff_date;
521: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4

Line 519: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date

515: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
516: := 'AC DEDUCTIONS';
517: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
518: := dbt(i).jurisdiction_cd;
519: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date
520: -- := p_pymt_eff_date;
521: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
522: --:= p_element_type_id;
523: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

Line 521: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4

517: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
518: := dbt(i).jurisdiction_cd;
519: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date
520: -- := p_pymt_eff_date;
521: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
522: --:= p_element_type_id;
523: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
524: := p_xfr_action_id;
525: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 523: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

519: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date
520: -- := p_pymt_eff_date;
521: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
522: --:= p_element_type_id;
523: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
524: := p_xfr_action_id;
525: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
526: := 'Tax Deductions';
527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 525: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

521: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
522: --:= p_element_type_id;
523: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
524: := p_xfr_action_id;
525: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
526: := 'Tax Deductions';
527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
528: := dbt(i).bal_type_id;
529: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

Line 527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

523: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
524: := p_xfr_action_id;
525: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
526: := 'Tax Deductions';
527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
528: := dbt(i).bal_type_id;
529: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
530: := dbt(i).disp_sequence;
531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 529: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

525: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
526: := 'Tax Deductions';
527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
528: := dbt(i).bal_type_id;
529: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
530: := dbt(i).disp_sequence;
531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
532: := fnd_number.number_to_canonical(ln_pymt_amount); /*Bug 3311866*/
533: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

527: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
528: := dbt(i).bal_type_id;
529: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
530: := dbt(i).disp_sequence;
531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
532: := fnd_number.number_to_canonical(ln_pymt_amount); /*Bug 3311866*/
533: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
534: := fnd_number.number_to_canonical(ln_ytd_amount);
535: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 533: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

529: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
530: := dbt(i).disp_sequence;
531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
532: := fnd_number.number_to_canonical(ln_pymt_amount); /*Bug 3311866*/
533: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
534: := fnd_number.number_to_canonical(ln_ytd_amount);
535: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
536: := lv_reporting_name; --lv_reporting_name bug#2077373;
537:

Line 535: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

531: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
532: := fnd_number.number_to_canonical(ln_pymt_amount); /*Bug 3311866*/
533: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
534: := fnd_number.number_to_canonical(ln_ytd_amount);
535: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
536: := lv_reporting_name; --lv_reporting_name bug#2077373;
537:
538: hr_utility.set_location(gv_package || lv_procedure_name, 60);
539:

Line 541: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;

537:
538: hr_utility.set_location(gv_package || lv_procedure_name, 60);
539:
540: ln_step := 11;
541: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
542: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
543: := 'Tax Deductions';
544: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
545: := dbt(i).jurisdiction_cd;

Line 542: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn

538: hr_utility.set_location(gv_package || lv_procedure_name, 60);
539:
540: ln_step := 11;
541: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
542: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
543: := 'Tax Deductions';
544: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
545: := dbt(i).jurisdiction_cd;
546: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

Line 544: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

540: ln_step := 11;
541: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
542: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
543: := 'Tax Deductions';
544: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
545: := dbt(i).jurisdiction_cd;
546: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
547: := dbt(i).bal_name;
548: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

Line 546: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

542: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
543: := 'Tax Deductions';
544: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
545: := dbt(i).jurisdiction_cd;
546: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
547: := dbt(i).bal_name;
548: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
549: := dbt(i).bal_type_id;
550:

Line 548: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

544: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
545: := dbt(i).jurisdiction_cd;
546: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
547: := dbt(i).bal_name;
548: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
549: := dbt(i).bal_type_id;
550:
551: hr_utility.set_location(gv_package || lv_procedure_name, 70);
552:

Line 807: -- if pay_ac_action_arch.gv_reporting_level = 'GRE' then

803: if p_action_type in ('U', 'P') then
804:
805: if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
806:
807: -- if pay_ac_action_arch.gv_reporting_level = 'GRE' then
808: --
809: -- hr_utility.set_location(gv_package || lv_procedure_name, 40);
810: -- ln_step := 2;
811: -- open c_ytd_aaid_for_gre(p_rqp_action_id,

Line 873: pay_ac_action_arch.gv_person_lang := lv_person_lang;

869: lv_person_lang := lv_base_lang;
870:
871: end if;
872:
873: pay_ac_action_arch.gv_person_lang := lv_person_lang;
874: /* Bug 3559626 */
875: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;
876:
877: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);

Line 877: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);

873: pay_ac_action_arch.gv_person_lang := lv_person_lang;
874: /* Bug 3559626 */
875: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;
876:
877: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);
878: hr_utility.trace('ln_ytd_balcall_aaid: '|| ln_ytd_balcall_aaid);
879:
880: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
881: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

Line 881: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

877: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);
878: hr_utility.trace('ln_ytd_balcall_aaid: '|| ln_ytd_balcall_aaid);
879:
880: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
881: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
882: ln_step := 5;
883: /* removed old code to use the get_taxgroup_val function bug#3498653*/
884:
885: ln_taxgrp_gre_id := get_taxgroup_val(

Line 895: hr_utility.trace('Reporting Level : '|| pay_ac_action_arch.gv_reporting_level);

891: end if;
892:
893: gn_taxgrp_gre_id := ln_taxgrp_gre_id;
894:
895: hr_utility.trace('Reporting Level : '|| pay_ac_action_arch.gv_reporting_level);
896: hr_utility.trace('gv_taxgrp_gre_id : '|| gn_taxgrp_gre_id);
897:
898: ln_step := 7;
899: gv_jurisdiction_cd := get_context_val(

Line 910: pay_ac_action_arch.get_last_xfr_info(

906: ln_step := 8;
907:
908: -- end if;
909: -- Added p_xfr_action_id parameter part of fix for bug#3940380
910: pay_ac_action_arch.get_last_xfr_info(
911: p_assignment_id => p_assignment_id
912: ,p_curr_effective_date => p_xfr_end_date
913: ,p_action_info_category=> 'EMPLOYEE DETAILS'
914: ,p_xfr_action_id => p_xfr_action_id

Line 940: pay_ac_action_arch.initialization_process;

936: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
937: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
938:
939: ln_step := 9;
940: pay_ac_action_arch.initialization_process;
941:
942: ln_step := 10;
943:
944: if p_archive_balance_info = 'Y' then -- Bug 3960157

Line 957: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

953: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
954: );
955:
956: ln_step := 11;
957: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
958: /****************************************************
959: ** Need to set Tax Unit Id context for Non-Payroll
960: ** Payment element has been processed when Reporting
961: ** Level is Tax Group.

Line 979: pay_ac_action_arch.first_time_process(

975: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
976: if ld_last_xfr_eff_date is null then
977: hr_utility.set_location(gv_package || lv_procedure_name, 100);
978: ln_step := 13;
979: pay_ac_action_arch.first_time_process(
980: p_xfr_action_id => p_xfr_action_id
981: ,p_assignment_id => p_assignment_id
982: ,p_curr_pymt_action_id => p_rqp_action_id --PP
983: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date

Line 1002: pay_ac_action_arch.get_current_elements(

998: ln_last_pymt_action_id
999: );
1000:
1001: ln_step := 15;
1002: pay_ac_action_arch.get_current_elements(
1003: p_xfr_action_id => p_xfr_action_id
1004: ,p_curr_pymt_action_id => p_rqp_action_id
1005: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
1006: ,p_assignment_id => p_assignment_id

Line 1015: pay_ac_action_arch.get_xfr_elements(

1011: ,p_sepchk_flag => p_seperate_check_flag
1012: ,p_legislation_code => p_legislation_code);
1013:
1014: ln_step := 16;
1015: pay_ac_action_arch.get_xfr_elements(
1016: p_xfr_action_id => p_xfr_action_id
1017: ,p_last_xfr_action_id => ln_last_xfr_action_id
1018: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
1019: ,p_pymt_eff_date => p_curr_pymt_eff_date

Line 1026: pay_ac_action_arch.get_missing_xfr_info(

1022: ,p_assignment_id => p_assignment_id);
1023:
1024: if ld_last_pymt_eff_date <> p_curr_pymt_eff_date then
1025: ln_step := 17;
1026: pay_ac_action_arch.get_missing_xfr_info(
1027: p_xfr_action_id => p_xfr_action_id
1028: ,p_tax_unit_id => p_tax_unit_id
1029: ,p_assignment_id => p_assignment_id
1030: ,p_last_pymt_action_id => ln_last_pymt_action_id

Line 1041: pay_ac_action_arch.populate_summary(

1037:
1038: end if;
1039: -- end if;
1040: ln_step := 19;
1041: pay_ac_action_arch.populate_summary(
1042: p_xfr_action_id => p_xfr_action_id);
1043:
1044: end if;
1045:

Line 1071: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

1067: ,p_action_context_type=> 'AAP'
1068: ,p_assignment_id => p_assignment_id
1069: ,p_tax_unit_id => p_tax_unit_id
1070: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
1071: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
1072: );
1073:
1074: EXCEPTION
1075: when others then

Line 1586: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then

1582: ** of particular GRE. If no data found then use the
1583: ** master prepayment assignment action id.
1584: *****************************************************/
1585:
1586: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1587:
1588: if (pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
1589: pay_emp_action_arch.gv_multi_payroll_pymt is null) then
1590:

Line 1649: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then

1645: hr_utility.trace('c_run_aa_id%NOT FOUND satisfied with action type B');
1646: ln_master_run_aa_id := ln_prepay_asg_act_id;
1647: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
1648: else
1649: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1650: hr_utility.trace('Procedure name: '||lv_procedure_name);
1651: hr_utility.trace('gv_multi_gre_payment = N satisfied');
1652:
1653: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE

Line 1667: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then

1663: /* Old code before bug#3498653 fix
1664: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);
1665: hr_utility.trace('GRE ln_run_source_aa_id = ' || ln_run_source_aa_id);
1666:
1667: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
1668: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE
1669: else
1670: ln_master_run_aa_id := ln_run_source_aa_id; -- Main Master
1671: end if;

Line 2093: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then

2089:
2090: hr_utility.trace('MG ln_run_aa_id = ' || ln_run_aa_id);
2091: hr_utility.trace('MG ln_source_aa_id = ' || ln_source_aa_id);
2092:
2093: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2094: ln_master_run_aa_id := ln_run_aa_id;
2095: else
2096: ln_master_run_aa_id := ln_source_aa_id;
2097: end if;

Line 2293: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then

2289: pay_emp_action_arch.gv_multi_payroll_pymt);
2290: ln_step := 3;
2291: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2292: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2293: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2294:
2295: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2296: hr_utility.trace('ln_master_prepay_action_id ' ||
2297: p_master_prepay_action_id);

Line 2319: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then

2315: ln_step := 6;
2316: loop
2317: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2318: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2319: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2320:
2321: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2322: ln_step := 7;
2323: fetch c_asg_child_action into ln_assignment_id,

Line 2372: -- if pay_ac_action_arch.gv_multi_asg_enabled = 'Y' then

2368: hr_nonrun_asact.insint(ln_child_xfr_action_id,
2369: ln_asg_action_id);
2370:
2371: hr_utility.set_location(gv_package || lv_procedure_name, 110);
2372: -- if pay_ac_action_arch.gv_multi_asg_enabled = 'Y' then
2373: -- open c_pre_pay_run_action (ln_asg_action_id, p_sepchk_run_type_id);
2374: -- fetch c_pre_pay_run_action into ln_run_action_id;
2375: -- close c_pre_pay_run_action;
2376: -- end if;

Line 2415: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then

2411:
2412: ln_step := 14;
2413: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2414: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2415: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2416: close c_asg_child_action;
2417: else
2418: close c_multi_asg_child_action;
2419: end if;

Line 2669: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

2665: open c_master_run_action_type(ln_asg_action_id,ln_assignment_id);
2666: fetch c_master_run_action_type into lv_run_action_type;
2667: hr_utility.trace('lv_run_action_type ='||lv_run_action_type);
2668:
2669: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
2670: /* Added this validation to avoid creating child assignment actions,
2671: when reversals to be picked up based on Pre-payments. Reversals
2672: are archived directly based on run actions. Bug#3498653 */
2673:

Line 2726: -- if ( ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) and

2722: close c_master_run_action_type;
2723:
2724: end if; -- gv_reporting_level = 'TAXGRP'
2725:
2726: -- if ( ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) and
2727: -- ( pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2728: -- pay_emp_action_arch.gv_multi_payroll_pymt is null ) ) then
2729:
2730: -- create_chld_act_for_multi_gre(

Line 2826: pay_ac_action_arch.initialization_process;

2822: ||to_char(ln_pymt_balcall_aaid));
2823: /* Added this code to archive the tax balances and other elements
2824: for reversals in Canada. Bug#3498653 */
2825: ln_step := 14;
2826: pay_ac_action_arch.initialization_process;
2827:
2828: hr_utility.trace('Populating Tax Balances for Reversals');
2829: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
2830: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));

Line 2839: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

2835: Reversals. Need to set both contexts for
2836: Tax Group reporting because for current amounts we
2837: use GRE context and for YTD amounts we use Tax_Group
2838: context */
2839: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
2840: ln_tax_group_id := get_taxgroup_val(
2841: p_tax_unit_id => ln_tax_unit_id,
2842: p_assignment_id => ln_assignment_id,
2843: p_asg_act_id =>ln_pymt_balcall_aaid);

Line 2857: elsif pay_ac_action_arch.gv_reporting_level = 'GRE' then

2853: (ln_tax_unit_id_context is null)) then
2854: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
2855: end if;
2856:
2857: elsif pay_ac_action_arch.gv_reporting_level = 'GRE' then
2858: ln_tax_unit_id_context := -1;
2859: ln_tax_unit_id_context := get_context_val(
2860: p_context_name => 'TAX_UNIT_ID'
2861: , p_assignment_id => ln_assignment_id

Line 2886: pay_ac_action_arch.get_current_elements(

2882: );
2883:
2884: ln_step := 16;
2885: hr_utility.trace('Populating Current Elements for Reversals');
2886: pay_ac_action_arch.get_current_elements(
2887: p_xfr_action_id => p_xfr_action_id
2888: ,p_curr_pymt_action_id => ln_pymt_balcall_aaid
2889: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
2890: ,p_assignment_id => ln_assignment_id

Line 2907: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

2903: ,p_action_context_type=> 'AAP'
2904: ,p_assignment_id => ln_assignment_id
2905: ,p_tax_unit_id => ln_tax_unit_id
2906: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
2907: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
2908: );
2909:
2910: end if; -- lv_master_action_type = 'V'
2911:

Line 2921: pay_ac_action_arch.initialization_process;

2917: if lv_master_action_type = 'B' then
2918: hr_utility.trace('Populating Current Elements for Balance Adjustments');
2919: /* ln_asg_action_id is nothing but Balance Adjustment run action id */
2920: ln_asg_action_id := -1;
2921: pay_ac_action_arch.initialization_process;
2922: open c_get_emp_adjbal(p_xfr_action_id);
2923: loop
2924: fetch c_get_emp_adjbal into ln_asg_action_id;
2925: exit when c_get_emp_adjbal%NOTFOUND;

Line 2944: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

2940: Tax Group reporting because for current amounts we
2941: use GRE context and for YTD amounts we use Tax_Group
2942: context */
2943:
2944: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
2945: ln_tax_group_id := get_taxgroup_val(
2946: p_tax_unit_id => ln_tax_unit_id,
2947: p_assignment_id => ln_assignment_id,
2948: p_asg_act_id =>ln_pymt_balcall_aaid);

Line 2963: elsif pay_ac_action_arch.gv_reporting_level = 'GRE' then

2959: (ln_tax_unit_id_context is null)) then
2960: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
2961: end if;
2962:
2963: elsif pay_ac_action_arch.gv_reporting_level = 'GRE' then
2964: ln_tax_unit_id_context := -1;
2965: ln_tax_unit_id_context := get_context_val(
2966: p_context_name => 'TAX_UNIT_ID'
2967: , p_assignment_id => ln_assignment_id

Line 2985: pay_ac_action_arch.get_current_elements(

2981: will be archived. */
2982:
2983: if ln_asg_action_id <> -1 and ln_asg_action_id is not null then
2984: ln_step := 19;
2985: pay_ac_action_arch.get_current_elements(
2986: p_xfr_action_id => p_xfr_action_id
2987: ,p_curr_pymt_action_id => p_xfr_action_id
2988: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
2989: ,p_assignment_id => ln_assignment_id

Line 3008: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

3004: ,p_action_context_type=> 'AAP'
3005: ,p_assignment_id => ln_assignment_id
3006: ,p_tax_unit_id => ln_tax_unit_id
3007: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
3008: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
3009: );
3010:
3011: end if; -- master_action_type = 'B'
3012: /* End of Balance Adjustments archiving Bug#3498653 */

Line 3513: fetch cur_mg_payment into pay_ac_action_arch.gv_multi_gre_payment;

3509: j := 0;
3510:
3511: ln_step := 5;
3512: open cur_mg_payment;
3513: fetch cur_mg_payment into pay_ac_action_arch.gv_multi_gre_payment;
3514: if cur_mg_payment%notfound then
3515: pay_ac_action_arch.gv_multi_gre_payment := 'N';
3516: end if;
3517: close cur_mg_payment;

Line 3515: pay_ac_action_arch.gv_multi_gre_payment := 'N';

3511: ln_step := 5;
3512: open cur_mg_payment;
3513: fetch cur_mg_payment into pay_ac_action_arch.gv_multi_gre_payment;
3514: if cur_mg_payment%notfound then
3515: pay_ac_action_arch.gv_multi_gre_payment := 'N';
3516: end if;
3517: close cur_mg_payment;
3518:
3519: ln_step := 6;

Line 3549: pay_ac_action_arch.gv_reporting_level := lv_reporting_level;

3545: lv_reporting_level := 'GRE';
3546: end if;
3547: close cur_reporting_level;
3548:
3549: pay_ac_action_arch.gv_reporting_level := lv_reporting_level;
3550:
3551: ln_step := 20;
3552: if pay_emp_action_arch.gv_multi_leg_rule is null then
3553: pay_emp_action_arch.gv_multi_leg_rule