APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_BALANCE_PKG

Line 428: pay_balance_pkg.set_context('TAX_GROUP', gn_taxgrp_gre_id);

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;
432:

Line 430: pay_balance_pkg.set_context('TAX_UNIT_ID', gn_taxgrp_gre_id);

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;
432:
433: hr_utility.set_location(gv_package || lv_procedure_name, 20);
434: ln_step := 2;

Line 443: pay_balance_pkg.set_context('JURISDICTION_CODE'

439:
440: if dbt(i).bal_name in ('PROV Withheld', 'QPP EE Withheld' , 'PPIP EE Withheld') -- 4566656
441: then
442: ln_step := 3;
443: pay_balance_pkg.set_context('JURISDICTION_CODE'
444: ,dbt(i).jurisdiction_cd);
445: lv_lookup_code := upper(dbt(i).bal_name|| '(' ||
446: dbt(i).jurisdiction_cd || ')');
447: else

Line 459: ln_pymt_amount := nvl(pay_balance_pkg.get_value(

455: should be used to get ln_pymt_amount. Bug#3498653 */
456: if p_action_type in ('V','B') then
457: if dbt(i).run_def_bal_id is not null then
458: ln_step := 5;
459: ln_pymt_amount := nvl(pay_balance_pkg.get_value(
460: dbt(i).run_def_bal_id,
461: p_pymt_balcall_aaid),0);
462: end if;
463: else

Line 467: ln_pymt_amount := nvl(pay_balance_pkg.get_value(

463: else
464: /* old code before adding run_def_bal_id */
465: if dbt(i).pymt_def_bal_id is not null then
466: ln_step := 5;
467: ln_pymt_amount := nvl(pay_balance_pkg.get_value(
468: dbt(i).pymt_def_bal_id,
469: p_pymt_balcall_aaid),0);
470: end if;
471: end if; -- p_action_type = 'V'

Line 475: ln_ytd_amount := nvl(pay_balance_pkg.get_value(

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);
478: else
479: ln_step := 7;

Line 480: ln_ytd_amount := nvl(pay_balance_pkg.get_value(

476: dbt(i).tg_ytd_def_bal_id,
477: p_ytd_balcall_aaid),0);
478: else
479: ln_step := 7;
480: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
481: dbt(i).gre_ytd_def_bal_id,
482: p_ytd_balcall_aaid),0);
483: end if;
484:

Line 963: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);

959: ** Need to set Tax Unit Id context for Non-Payroll
960: ** Payment element has been processed when Reporting
961: ** Level is Tax Group.
962: ****************************************************/
963: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
964: end if;
965:
966: hr_utility.set_location(gv_package || lv_procedure_name, 90);
967:

Line 1696: ln_gross_earn_bal := nvl(pay_balance_pkg.get_value(

1692: if c_all_runs%notfound then
1693: exit;
1694: end if;
1695:
1696: ln_gross_earn_bal := nvl(pay_balance_pkg.get_value(
1697: gn_gross_earn_def_bal_id,
1698: ln_assignment_action_id),0);
1699:
1700: /**************************************************

Line 1708: ln_gross_earn_bal := nvl(pay_balance_pkg.get_value(

1704: **************************************************/
1705:
1706: if ln_gross_earn_bal = 0 then
1707:
1708: ln_gross_earn_bal := nvl(pay_balance_pkg.get_value(
1709: gn_payments_def_bal_id,
1710: ln_assignment_action_id),0);
1711:
1712: end if;

Line 2844: pay_balance_pkg.set_context('TAX_GROUP', ln_tax_group_id);

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);
2844: pay_balance_pkg.set_context('TAX_GROUP', ln_tax_group_id);
2845: gn_taxgrp_gre_id := ln_tax_group_id;
2846:
2847: ln_tax_unit_id_context := -1;
2848: ln_tax_unit_id_context := get_context_val(

Line 2854: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);

2850: , p_assignment_id => ln_assignment_id
2851: , p_asg_act_id => ln_pymt_balcall_aaid);
2852: if ((ln_tax_unit_id_context = -1) or
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;

Line 2867: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);

2863: gn_taxgrp_gre_id := ln_tax_unit_id_context;
2864:
2865: if ((ln_tax_unit_id_context = -1) or
2866: (ln_tax_unit_id_context is null)) then
2867: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
2868: gn_taxgrp_gre_id := ln_tax_unit_id;
2869: end if;
2870: end if;
2871:

Line 2949: pay_balance_pkg.set_context('TAX_GROUP', ln_tax_group_id);

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);
2949: pay_balance_pkg.set_context('TAX_GROUP', ln_tax_group_id);
2950: gn_taxgrp_gre_id := ln_tax_group_id;
2951:
2952: ln_tax_unit_id_context := -1;
2953: ln_tax_unit_id_context := get_context_val(

Line 2960: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);

2956: , p_asg_act_id => ln_pymt_balcall_aaid);
2957:
2958: if ((ln_tax_unit_id_context = -1) or
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;

Line 2973: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);

2969: gn_taxgrp_gre_id := ln_tax_unit_id_context;
2970:
2971: if ((ln_tax_unit_id_context = -1) or
2972: (ln_tax_unit_id_context is null)) then
2973: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
2974: gn_taxgrp_gre_id := ln_tax_unit_id;
2975: end if;
2976: end if; -- gv_reporting_level = 'TAXGRP'
2977: