APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_BALANCE_PKG

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

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

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

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;
446:
447: hr_utility.set_location(gv_package || lv_procedure_name, 20);
448: ln_step := 2;

Line 457: pay_balance_pkg.set_context('JURISDICTION_CODE'

453:
454: if dbt(i).bal_name in ('PROV Withheld', 'QPP EE Withheld' , 'PPIP EE Withheld') -- 4566656
455: then
456: ln_step := 3;
457: pay_balance_pkg.set_context('JURISDICTION_CODE'
458: ,dbt(i).jurisdiction_cd);
459: lv_lookup_code := upper(dbt(i).bal_name|| '(' ||
460: dbt(i).jurisdiction_cd || ')');
461: else

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

469: should be used to get ln_pymt_amount. Bug#3498653 */
470: if p_action_type in ('V','B') then
471: if dbt(i).run_def_bal_id is not null then
472: ln_step := 5;
473: ln_pymt_amount := nvl(pay_balance_pkg.get_value(
474: dbt(i).run_def_bal_id,
475: p_pymt_balcall_aaid),0);
476: end if;
477: else

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

477: else
478: /* old code before adding run_def_bal_id */
479: if dbt(i).pymt_def_bal_id is not null then
480: ln_step := 5;
481: ln_pymt_amount := nvl(pay_balance_pkg.get_value(
482: dbt(i).pymt_def_bal_id,
483: p_pymt_balcall_aaid),0);
484: end if;
485: end if; -- p_action_type = 'V'

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

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);
492: else
493: ln_step := 7;

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

490: dbt(i).tg_ytd_def_bal_id,
491: p_ytd_balcall_aaid),0);
492: else
493: ln_step := 7;
494: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
495: dbt(i).gre_ytd_def_bal_id,
496: p_ytd_balcall_aaid),0);
497: end if;
498:

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

1439: ** Need to set Tax Unit Id context for Non-Payroll
1440: ** Payment element has been processed when Reporting
1441: ** Level is Tax Group.
1442: ****************************************************/
1443: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
1444: end if;
1445:
1446: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1447:

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

2199: if c_all_runs%notfound then
2200: exit;
2201: end if;
2202:
2203: ln_gross_earn_bal := nvl(pay_balance_pkg.get_value(
2204: gn_gross_earn_def_bal_id,
2205: ln_assignment_action_id),0);
2206:
2207: /**************************************************

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

2213:
2214:
2215: if ln_gross_earn_bal = 0 then
2216:
2217: ln_gross_earn_bal := nvl(pay_balance_pkg.get_value(
2218: gn_payments_def_bal_id,
2219: ln_assignment_action_id),0);
2220: hr_utility.trace('GRE ln_gross_earn_bal using gn_payments_def_bal_id: ' || ln_gross_earn_bal);
2221:

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

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);
3355: pay_balance_pkg.set_context('TAX_GROUP', ln_tax_group_id);
3356: gn_taxgrp_gre_id := ln_tax_group_id;
3357:
3358: ln_tax_unit_id_context := -1;
3359: ln_tax_unit_id_context := get_context_val(

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

3361: , p_assignment_id => ln_assignment_id
3362: , p_asg_act_id => ln_pymt_balcall_aaid);
3363: if ((ln_tax_unit_id_context = -1) or
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;

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

3374: gn_taxgrp_gre_id := ln_tax_unit_id_context;
3375:
3376: if ((ln_tax_unit_id_context = -1) or
3377: (ln_tax_unit_id_context is null)) then
3378: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
3379: gn_taxgrp_gre_id := ln_tax_unit_id;
3380: end if;
3381: end if;
3382:

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

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);
3460: pay_balance_pkg.set_context('TAX_GROUP', ln_tax_group_id);
3461: gn_taxgrp_gre_id := ln_tax_group_id;
3462:
3463: ln_tax_unit_id_context := -1;
3464: ln_tax_unit_id_context := get_context_val(

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

3467: , p_asg_act_id => ln_pymt_balcall_aaid);
3468:
3469: if ((ln_tax_unit_id_context = -1) or
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;

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

3480: gn_taxgrp_gre_id := ln_tax_unit_id_context;
3481:
3482: if ((ln_tax_unit_id_context = -1) or
3483: (ln_tax_unit_id_context is null)) then
3484: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
3485: gn_taxgrp_gre_id := ln_tax_unit_id;
3486: end if;
3487: end if; -- gv_reporting_level = 'TAXGRP'
3488: