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_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 441: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

437: hr_utility.set_location(gv_package || lv_procedure_name, 10);
438: i := 0;
439: j := 0;
440:
441: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
442: pay_balance_pkg.set_context('TAX_GROUP', gn_taxgrp_gre_id);
443: else
444: pay_balance_pkg.set_context('TAX_UNIT_ID', gn_taxgrp_gre_id);
445: end if;

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

483: p_pymt_balcall_aaid),0);
484: end if;
485: end if; -- p_action_type = 'V'
486:
487: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
488: ln_step := 6;
489: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
490: dbt(i).tg_ytd_def_bal_id,
491: p_ytd_balcall_aaid),0);

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

506:
507: ln_step := 9;
508: j := 0;
509: for j in tax.first..tax.last loop
510: if tax(j).language = pay_ac_action_arch.gv_person_lang and
511: tax(j).lookup_code = lv_lookup_code
512: then
513: lv_reporting_name := tax(j).meaning;
514: exit;

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

520: hr_utility.trace('lv_reporting_name : '||lv_reporting_name);
521: hr_utility.set_location(gv_package || lv_procedure_name, 50);
522:
523: ln_step := 10;
524: ln_index := pay_ac_action_arch.lrr_act_tab.count;
525:
526: hr_utility.trace('ln_index is '
527: || pay_ac_action_arch.lrr_act_tab.count);
528:

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

523: ln_step := 10;
524: ln_index := pay_ac_action_arch.lrr_act_tab.count;
525:
526: hr_utility.trace('ln_index is '
527: || pay_ac_action_arch.lrr_act_tab.count);
528:
529: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
530: := 'AC DEDUCTIONS';
531: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

Line 529: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

525:
526: hr_utility.trace('ln_index is '
527: || pay_ac_action_arch.lrr_act_tab.count);
528:
529: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
530: := 'AC DEDUCTIONS';
531: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
532: := dbt(i).jurisdiction_cd;
533: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date

Line 531: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

527: || pay_ac_action_arch.lrr_act_tab.count);
528:
529: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
530: := 'AC DEDUCTIONS';
531: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
532: := dbt(i).jurisdiction_cd;
533: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date
534: -- := p_pymt_eff_date;
535: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4

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

529: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
530: := 'AC DEDUCTIONS';
531: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
532: := dbt(i).jurisdiction_cd;
533: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date
534: -- := p_pymt_eff_date;
535: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
536: --:= p_element_type_id;
537: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

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

531: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
532: := dbt(i).jurisdiction_cd;
533: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date
534: -- := p_pymt_eff_date;
535: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
536: --:= p_element_type_id;
537: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
538: := p_xfr_action_id;
539: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 537: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id

533: -- pay_ac_action_arch.lrr_act_tab(ln_index).effective_date
534: -- := p_pymt_eff_date;
535: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
536: --:= p_element_type_id;
537: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
538: := p_xfr_action_id;
539: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
540: := 'Tax Deductions';
541: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 539: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

535: --pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
536: --:= p_element_type_id;
537: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
538: := p_xfr_action_id;
539: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
540: := 'Tax Deductions';
541: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
542: := dbt(i).bal_type_id;
543: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

Line 541: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

537: pay_ac_action_arch.lrr_act_tab(ln_index).action_context_id
538: := p_xfr_action_id;
539: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
540: := 'Tax Deductions';
541: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
542: := dbt(i).bal_type_id;
543: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
544: := dbt(i).disp_sequence;
545: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 543: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

539: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
540: := 'Tax Deductions';
541: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
542: := dbt(i).bal_type_id;
543: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
544: := dbt(i).disp_sequence;
545: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
546: := fnd_number.number_to_canonical(ln_pymt_amount); /*Bug 3311866*/
547: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 545: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

541: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
542: := dbt(i).bal_type_id;
543: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
544: := dbt(i).disp_sequence;
545: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
546: := fnd_number.number_to_canonical(ln_pymt_amount); /*Bug 3311866*/
547: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
548: := fnd_number.number_to_canonical(ln_ytd_amount);
549: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 547: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

543: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
544: := dbt(i).disp_sequence;
545: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
546: := fnd_number.number_to_canonical(ln_pymt_amount); /*Bug 3311866*/
547: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
548: := fnd_number.number_to_canonical(ln_ytd_amount);
549: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
550: := lv_reporting_name; --lv_reporting_name bug#2077373;
551:

Line 549: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

545: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
546: := fnd_number.number_to_canonical(ln_pymt_amount); /*Bug 3311866*/
547: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
548: := fnd_number.number_to_canonical(ln_ytd_amount);
549: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
550: := lv_reporting_name; --lv_reporting_name bug#2077373;
551:
552: hr_utility.set_location(gv_package || lv_procedure_name, 60);
553:

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

551:
552: hr_utility.set_location(gv_package || lv_procedure_name, 60);
553:
554: ln_step := 11;
555: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
556: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
557: := 'Tax Deductions';
558: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
559: := dbt(i).jurisdiction_cd;

Line 556: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn

552: hr_utility.set_location(gv_package || lv_procedure_name, 60);
553:
554: ln_step := 11;
555: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
556: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
557: := 'Tax Deductions';
558: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
559: := dbt(i).jurisdiction_cd;
560: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

Line 558: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code

554: ln_step := 11;
555: ln_element_index := pay_ac_action_arch.emp_elements_tab.count;
556: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
557: := 'Tax Deductions';
558: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
559: := dbt(i).jurisdiction_cd;
560: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
561: := dbt(i).bal_name;
562: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

Line 560: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name

556: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_classfn
557: := 'Tax Deductions';
558: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
559: := dbt(i).jurisdiction_cd;
560: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
561: := dbt(i).bal_name;
562: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
563: := dbt(i).bal_type_id;
564:

Line 562: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id

558: pay_ac_action_arch.emp_elements_tab(ln_element_index).jurisdiction_code
559: := dbt(i).jurisdiction_cd;
560: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_reporting_name
561: := dbt(i).bal_name;
562: pay_ac_action_arch.emp_elements_tab(ln_element_index).element_primary_balance_id
563: := dbt(i).bal_type_id;
564:
565: hr_utility.set_location(gv_package || lv_procedure_name, 70);
566:

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

1041: close att_no;
1042:
1043: /* Create the table type and assign the segment values to be archived*/
1044:
1045: ln_index := pay_ac_action_arch.lrr_act_tab.count;
1046:
1047: hr_utility.set_location(gv_package || lv_procedure_name,80);
1048: ln_step := 11;
1049: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '

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

1046:
1047: hr_utility.set_location(gv_package || lv_procedure_name,80);
1048: ln_step := 11;
1049: hr_utility.trace('ln_index in get_3rdparty_pay_distribution proc is '
1050: || pay_ac_action_arch.lrr_act_tab.count);
1051:
1052: hr_utility.trace('Attach details ln_earned_date = '|| ln_earned_date);
1053: hr_utility.trace('ln_garn_ref_no = '|| ln_garn_ref_no);
1054: hr_utility.trace('ln_payment_date = '|| ln_payment_date);

Line 1056: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category

1052: hr_utility.trace('Attach details ln_earned_date = '|| ln_earned_date);
1053: hr_utility.trace('ln_garn_ref_no = '|| ln_garn_ref_no);
1054: hr_utility.trace('ln_payment_date = '|| ln_payment_date);
1055:
1056: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1057: := 'CA THIRD PARTY CHEQUES';
1058: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1059: := '00-000-0000';
1060: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

Line 1058: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code

1054: hr_utility.trace('ln_payment_date = '|| ln_payment_date);
1055:
1056: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1057: := 'CA THIRD PARTY CHEQUES';
1058: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1059: := '00-000-0000';
1060: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1061: := NULL;
1062: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);

Line 1060: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1

1056: pay_ac_action_arch.lrr_act_tab(ln_index).action_info_category
1057: := 'CA THIRD PARTY CHEQUES';
1058: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
1059: := '00-000-0000';
1060: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1061: := NULL;
1062: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
1063: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1064: := ln_pre_payment_id;

Line 1063: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2

1059: := '00-000-0000';
1060: pay_ac_action_arch.lrr_act_tab(ln_index).act_info1
1061: := NULL;
1062: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
1063: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1064: := ln_pre_payment_id;
1065: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
1066: := fnd_number.number_to_canonical(ln_value);
1067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4

Line 1065: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3

1061: := NULL;
1062: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
1063: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1064: := ln_pre_payment_id;
1065: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
1066: := fnd_number.number_to_canonical(ln_value);
1067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1068: := ltt_actions(j);
1069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5

Line 1067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4

1063: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
1064: := ln_pre_payment_id;
1065: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
1066: := fnd_number.number_to_canonical(ln_value);
1067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1068: := ltt_actions(j);
1069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1070: := ln_org_payment_method_id;
1071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

Line 1069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5

1065: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
1066: := fnd_number.number_to_canonical(ln_value);
1067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1068: := ltt_actions(j);
1069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1070: := ln_org_payment_method_id;
1071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1072: := lv_org_payment_method_name;
1073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

Line 1071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6

1067: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1068: := ltt_actions(j);
1069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1070: := ln_org_payment_method_id;
1071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1072: := lv_org_payment_method_name;
1073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1074: := ln_emp_payment_method_id;
1075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

Line 1073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7

1069: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1070: := ln_org_payment_method_id;
1071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1072: := lv_org_payment_method_name;
1073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1074: := ln_emp_payment_method_id;
1075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1076: := ln_payee_id;
1077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 1075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8

1071: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1072: := lv_org_payment_method_name;
1073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1074: := ln_emp_payment_method_id;
1075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1076: := ln_payee_id;
1077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1078: := fnd_date.date_to_canonical(ln_earned_date);
1079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

Line 1077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

1073: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1074: := ln_emp_payment_method_id;
1075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1076: := ln_payee_id;
1077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1078: := fnd_date.date_to_canonical(ln_earned_date);
1079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1080: := fnd_date.date_to_canonical(ln_payment_date);
1081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11

Line 1079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10

1075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1076: := ln_payee_id;
1077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1078: := fnd_date.date_to_canonical(ln_earned_date);
1079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1080: := fnd_date.date_to_canonical(ln_payment_date);
1081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1082: := ln_payee_name ;
1083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

Line 1081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11

1077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1078: := fnd_date.date_to_canonical(ln_earned_date);
1079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1080: := fnd_date.date_to_canonical(ln_payment_date);
1081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1082: := ln_payee_name ;
1083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1084: := ln_address_line1;
1085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13

Line 1083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12

1079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1080: := fnd_date.date_to_canonical(ln_payment_date);
1081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1082: := ln_payee_name ;
1083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1084: := ln_address_line1;
1085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1086: := ln_address_line2;
1087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14

Line 1085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13

1081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1082: := ln_payee_name ;
1083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1084: := ln_address_line1;
1085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1086: := ln_address_line2;
1087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
1088: := ln_address_line3;
1089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15

Line 1087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14

1083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1084: := ln_address_line1;
1085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1086: := ln_address_line2;
1087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
1088: := ln_address_line3;
1089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1090: := ln_town_or_city;
1091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

Line 1089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15

1085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info13
1086: := ln_address_line2;
1087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
1088: := ln_address_line3;
1089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1090: := ln_town_or_city;
1091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1092: := ln_region1;
1093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17

Line 1091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16

1087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info14
1088: := ln_address_line3;
1089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1090: := ln_town_or_city;
1091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1092: := ln_region1;
1093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1094: := ln_postal_code;
1095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18

Line 1093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17

1089: pay_ac_action_arch.lrr_act_tab(ln_index).act_info15
1090: := ln_town_or_city;
1091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1092: := ln_region1;
1093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1094: := ln_postal_code;
1095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1096: := ln_garn_ref_no;
1097:

Line 1095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18

1091: pay_ac_action_arch.lrr_act_tab(ln_index).act_info16
1092: := ln_region1;
1093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info17
1094: := ln_postal_code;
1095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info18
1096: := ln_garn_ref_no;
1097:
1098: end loop;
1099: close c_third_party_pay;

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

1283: if p_action_type in ('U', 'P') then
1284:
1285: if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
1286:
1287: -- if pay_ac_action_arch.gv_reporting_level = 'GRE' then
1288: --
1289: -- hr_utility.set_location(gv_package || lv_procedure_name, 40);
1290: -- ln_step := 2;
1291: -- open c_ytd_aaid_for_gre(p_rqp_action_id,

Line 1353: pay_ac_action_arch.gv_person_lang := lv_person_lang;

1349: lv_person_lang := lv_base_lang;
1350:
1351: end if;
1352:
1353: pay_ac_action_arch.gv_person_lang := lv_person_lang;
1354: /* Bug 3559626 */
1355: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;
1356:
1357: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);

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

1353: pay_ac_action_arch.gv_person_lang := lv_person_lang;
1354: /* Bug 3559626 */
1355: pay_emp_action_arch.gv_correspondence_language := lv_person_lang;
1356:
1357: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);
1358: hr_utility.trace('ln_ytd_balcall_aaid: '|| ln_ytd_balcall_aaid);
1359:
1360: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
1361: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then

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

1357: hr_utility.trace('Correspondance Lang: '|| pay_ac_action_arch.gv_person_lang);
1358: hr_utility.trace('ln_ytd_balcall_aaid: '|| ln_ytd_balcall_aaid);
1359:
1360: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
1361: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
1362: ln_step := 5;
1363: /* removed old code to use the get_taxgroup_val function bug#3498653*/
1364:
1365: ln_taxgrp_gre_id := get_taxgroup_val(

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

1371: end if;
1372:
1373: gn_taxgrp_gre_id := ln_taxgrp_gre_id;
1374:
1375: hr_utility.trace('Reporting Level : '|| pay_ac_action_arch.gv_reporting_level);
1376: hr_utility.trace('gv_taxgrp_gre_id : '|| gn_taxgrp_gre_id);
1377:
1378: ln_step := 7;
1379: gv_jurisdiction_cd := get_context_val(

Line 1390: pay_ac_action_arch.get_last_xfr_info(

1386: ln_step := 8;
1387:
1388: -- end if;
1389: -- Added p_xfr_action_id parameter part of fix for bug#3940380
1390: pay_ac_action_arch.get_last_xfr_info(
1391: p_assignment_id => p_assignment_id
1392: ,p_curr_effective_date => p_xfr_end_date
1393: ,p_action_info_category=> 'EMPLOYEE DETAILS'
1394: ,p_xfr_action_id => p_xfr_action_id

Line 1420: pay_ac_action_arch.initialization_process;

1416: hr_utility.trace('ld_last_xfr_eff_date = ' || ld_last_xfr_eff_date);
1417: hr_utility.trace('ln_last_xfr_action_id = ' || ln_last_xfr_action_id);
1418:
1419: ln_step := 9;
1420: pay_ac_action_arch.initialization_process;
1421:
1422: ln_step := 10;
1423:
1424: if p_archive_balance_info = 'Y' then -- Bug 3960157

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

1433: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
1434: );
1435:
1436: ln_step := 11;
1437: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
1438: /****************************************************
1439: ** Need to set Tax Unit Id context for Non-Payroll
1440: ** Payment element has been processed when Reporting
1441: ** Level is Tax Group.

Line 1459: pay_ac_action_arch.first_time_process(

1455: -- if p_seperate_check_flag = 'N' and p_archive_balance_info <> 'N' then
1456: if ld_last_xfr_eff_date is null then
1457: hr_utility.set_location(gv_package || lv_procedure_name, 100);
1458: ln_step := 13;
1459: pay_ac_action_arch.first_time_process(
1460: p_xfr_action_id => p_xfr_action_id
1461: ,p_assignment_id => p_assignment_id
1462: ,p_curr_pymt_action_id => p_rqp_action_id --PP
1463: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date

Line 1482: pay_ac_action_arch.get_current_elements(

1478: ln_last_pymt_action_id
1479: );
1480:
1481: ln_step := 15;
1482: pay_ac_action_arch.get_current_elements(
1483: p_xfr_action_id => p_xfr_action_id
1484: ,p_curr_pymt_action_id => p_rqp_action_id
1485: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
1486: ,p_assignment_id => p_assignment_id

Line 1495: pay_ac_action_arch.get_xfr_elements(

1491: ,p_sepchk_flag => p_seperate_check_flag
1492: ,p_legislation_code => p_legislation_code);
1493:
1494: ln_step := 16;
1495: pay_ac_action_arch.get_xfr_elements(
1496: p_xfr_action_id => p_xfr_action_id
1497: ,p_last_xfr_action_id => ln_last_xfr_action_id
1498: ,p_ytd_balcall_aaid => ln_ytd_balcall_aaid
1499: ,p_pymt_eff_date => p_curr_pymt_eff_date

Line 1506: pay_ac_action_arch.get_missing_xfr_info(

1502: ,p_assignment_id => p_assignment_id);
1503:
1504: if ld_last_pymt_eff_date <> p_curr_pymt_eff_date then
1505: ln_step := 17;
1506: pay_ac_action_arch.get_missing_xfr_info(
1507: p_xfr_action_id => p_xfr_action_id
1508: ,p_tax_unit_id => p_tax_unit_id
1509: ,p_assignment_id => p_assignment_id
1510: ,p_last_pymt_action_id => ln_last_pymt_action_id

Line 1521: pay_ac_action_arch.populate_summary(

1517:
1518: end if;
1519: -- end if;
1520: ln_step := 19;
1521: pay_ac_action_arch.populate_summary(
1522: p_xfr_action_id => p_xfr_action_id);
1523:
1524: end if;
1525:

Line 1568: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

1564: ,p_action_context_type=> 'AAP'
1565: ,p_assignment_id => p_assignment_id
1566: ,p_tax_unit_id => p_tax_unit_id
1567: ,p_curr_pymt_eff_date => p_curr_pymt_eff_date
1568: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
1569: );
1570:
1571: EXCEPTION
1572: when others then

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

2087: ** of particular GRE. If no data found then use the
2088: ** master prepayment assignment action id.
2089: *****************************************************/
2090:
2091: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2092:
2093: if (pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2094: pay_emp_action_arch.gv_multi_payroll_pymt is null) then
2095:

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

2150: hr_utility.trace('c_run_aa_id%NOT FOUND satisfied with action type B');
2151: ln_master_run_aa_id := ln_prepay_asg_act_id;
2152: hr_utility.trace('ln_master_run_aa_id :'||to_char(ln_master_run_aa_id));
2153: else
2154: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2155: hr_utility.trace('Procedure name: '||lv_procedure_name);
2156: hr_utility.trace('gv_multi_gre_payment = N satisfied');
2157:
2158: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE

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

2168: /* Old code before bug#3498653 fix
2169: hr_utility.trace('GRE ln_run_aa_id = ' || ln_run_aa_id);
2170: hr_utility.trace('GRE ln_run_source_aa_id = ' || ln_run_source_aa_id);
2171:
2172: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2173: ln_master_run_aa_id := ln_run_aa_id; -- Sub Master for Multi GRE
2174: else
2175: ln_master_run_aa_id := ln_run_source_aa_id; -- Main Master
2176: end if;

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

2600:
2601: hr_utility.trace('MG ln_run_aa_id = ' || ln_run_aa_id);
2602: hr_utility.trace('MG ln_source_aa_id = ' || ln_source_aa_id);
2603:
2604: if pay_ac_action_arch.gv_multi_gre_payment = 'N' then
2605: ln_master_run_aa_id := ln_run_aa_id;
2606: else
2607: ln_master_run_aa_id := ln_source_aa_id;
2608: end if;

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

2800: pay_emp_action_arch.gv_multi_payroll_pymt);
2801: ln_step := 3;
2802: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2803: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2804: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2805:
2806: hr_utility.set_location(gv_package || lv_procedure_name, 30);
2807: hr_utility.trace('ln_master_prepay_action_id ' ||
2808: p_master_prepay_action_id);

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

2826: ln_step := 6;
2827: loop
2828: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2829: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2830: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2831:
2832: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2833: ln_step := 7;
2834: fetch c_asg_child_action into ln_assignment_id,

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

2879: hr_nonrun_asact.insint(ln_child_xfr_action_id,
2880: ln_asg_action_id);
2881:
2882: hr_utility.set_location(gv_package || lv_procedure_name, 110);
2883: -- if pay_ac_action_arch.gv_multi_asg_enabled = 'Y' then
2884: -- open c_pre_pay_run_action (ln_asg_action_id, p_sepchk_run_type_id);
2885: -- fetch c_pre_pay_run_action into ln_run_action_id;
2886: -- close c_pre_pay_run_action;
2887: -- end if;

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

2922:
2923: ln_step := 14;
2924: if ((pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
2925: pay_emp_action_arch.gv_multi_payroll_pymt is null) and
2926: pay_ac_action_arch.gv_multi_gre_payment = 'Y' ) then
2927: close c_asg_child_action;
2928: else
2929: close c_multi_asg_child_action;
2930: end if;

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

3176: open c_master_run_action_type(ln_asg_action_id,ln_assignment_id);
3177: fetch c_master_run_action_type into lv_run_action_type;
3178: hr_utility.trace('lv_run_action_type ='||lv_run_action_type);
3179:
3180: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
3181: /* Added this validation to avoid creating child assignment actions,
3182: when reversals to be picked up based on Pre-payments. Reversals
3183: are archived directly based on run actions. Bug#3498653 */
3184:

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

3233: close c_master_run_action_type;
3234:
3235: end if; -- gv_reporting_level = 'TAXGRP'
3236:
3237: -- if ( ( pay_ac_action_arch.gv_multi_gre_payment = 'N' ) and
3238: -- ( pay_emp_action_arch.gv_multi_payroll_pymt = 'N' or
3239: -- pay_emp_action_arch.gv_multi_payroll_pymt is null ) ) then
3240:
3241: -- create_chld_act_for_multi_gre(

Line 3337: pay_ac_action_arch.initialization_process;

3333: ||to_char(ln_pymt_balcall_aaid));
3334: /* Added this code to archive the tax balances and other elements
3335: for reversals in Canada. Bug#3498653 */
3336: ln_step := 14;
3337: pay_ac_action_arch.initialization_process;
3338:
3339: hr_utility.trace('Populating Tax Balances for Reversals');
3340: hr_utility.trace('ln_tax_unit_id : '||to_char(ln_tax_unit_id));
3341: hr_utility.trace('ln_pymt_balcall_aaid :'||to_char(ln_pymt_balcall_aaid));

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

3346: Reversals. Need to set both contexts for
3347: Tax Group reporting because for current amounts we
3348: use GRE context and for YTD amounts we use Tax_Group
3349: context */
3350: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
3351: ln_tax_group_id := get_taxgroup_val(
3352: p_tax_unit_id => ln_tax_unit_id,
3353: p_assignment_id => ln_assignment_id,
3354: p_asg_act_id =>ln_pymt_balcall_aaid);

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

3364: (ln_tax_unit_id_context is null)) then
3365: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
3366: end if;
3367:
3368: elsif pay_ac_action_arch.gv_reporting_level = 'GRE' then
3369: ln_tax_unit_id_context := -1;
3370: ln_tax_unit_id_context := get_context_val(
3371: p_context_name => 'TAX_UNIT_ID'
3372: , p_assignment_id => ln_assignment_id

Line 3397: pay_ac_action_arch.get_current_elements(

3393: );
3394:
3395: ln_step := 16;
3396: hr_utility.trace('Populating Current Elements for Reversals');
3397: pay_ac_action_arch.get_current_elements(
3398: p_xfr_action_id => p_xfr_action_id
3399: ,p_curr_pymt_action_id => ln_pymt_balcall_aaid
3400: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
3401: ,p_assignment_id => ln_assignment_id

Line 3418: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

3414: ,p_action_context_type=> 'AAP'
3415: ,p_assignment_id => ln_assignment_id
3416: ,p_tax_unit_id => ln_tax_unit_id
3417: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
3418: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
3419: );
3420:
3421: end if; -- lv_master_action_type = 'V'
3422:

Line 3432: pay_ac_action_arch.initialization_process;

3428: if lv_master_action_type = 'B' then
3429: hr_utility.trace('Populating Current Elements for Balance Adjustments');
3430: /* ln_asg_action_id is nothing but Balance Adjustment run action id */
3431: ln_asg_action_id := -1;
3432: pay_ac_action_arch.initialization_process;
3433: open c_get_emp_adjbal(p_xfr_action_id);
3434: loop
3435: fetch c_get_emp_adjbal into ln_asg_action_id;
3436: exit when c_get_emp_adjbal%NOTFOUND;

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

3451: Tax Group reporting because for current amounts we
3452: use GRE context and for YTD amounts we use Tax_Group
3453: context */
3454:
3455: if pay_ac_action_arch.gv_reporting_level = 'TAXGRP' then
3456: ln_tax_group_id := get_taxgroup_val(
3457: p_tax_unit_id => ln_tax_unit_id,
3458: p_assignment_id => ln_assignment_id,
3459: p_asg_act_id =>ln_pymt_balcall_aaid);

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

3470: (ln_tax_unit_id_context is null)) then
3471: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
3472: end if;
3473:
3474: elsif pay_ac_action_arch.gv_reporting_level = 'GRE' then
3475: ln_tax_unit_id_context := -1;
3476: ln_tax_unit_id_context := get_context_val(
3477: p_context_name => 'TAX_UNIT_ID'
3478: , p_assignment_id => ln_assignment_id

Line 3496: pay_ac_action_arch.get_current_elements(

3492: will be archived. */
3493:
3494: if ln_asg_action_id <> -1 and ln_asg_action_id is not null then
3495: ln_step := 19;
3496: pay_ac_action_arch.get_current_elements(
3497: p_xfr_action_id => p_xfr_action_id
3498: ,p_curr_pymt_action_id => p_xfr_action_id
3499: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
3500: ,p_assignment_id => ln_assignment_id

Line 3519: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab

3515: ,p_action_context_type=> 'AAP'
3516: ,p_assignment_id => ln_assignment_id
3517: ,p_tax_unit_id => ln_tax_unit_id
3518: ,p_curr_pymt_eff_date => ld_curr_pymt_eff_date
3519: ,p_tab_rec_data => pay_ac_action_arch.lrr_act_tab
3520: );
3521:
3522: end if; -- master_action_type = 'B'
3523: /* End of Balance Adjustments archiving Bug#3498653 */

Line 4024: fetch cur_mg_payment into pay_ac_action_arch.gv_multi_gre_payment;

4020: j := 0;
4021:
4022: ln_step := 5;
4023: open cur_mg_payment;
4024: fetch cur_mg_payment into pay_ac_action_arch.gv_multi_gre_payment;
4025: if cur_mg_payment%notfound then
4026: pay_ac_action_arch.gv_multi_gre_payment := 'N';
4027: end if;
4028: close cur_mg_payment;

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

4022: ln_step := 5;
4023: open cur_mg_payment;
4024: fetch cur_mg_payment into pay_ac_action_arch.gv_multi_gre_payment;
4025: if cur_mg_payment%notfound then
4026: pay_ac_action_arch.gv_multi_gre_payment := 'N';
4027: end if;
4028: close cur_mg_payment;
4029:
4030: ln_step := 6;

Line 4060: pay_ac_action_arch.gv_reporting_level := lv_reporting_level;

4056: lv_reporting_level := 'GRE';
4057: end if;
4058: close cur_reporting_level;
4059:
4060: pay_ac_action_arch.gv_reporting_level := lv_reporting_level;
4061:
4062: ln_step := 20;
4063: if pay_emp_action_arch.gv_multi_leg_rule is null then
4064: pay_emp_action_arch.gv_multi_leg_rule