APPS.PAY_US_ACTION_ARCH dependencies on PAY_BALANCE_PKG

Line 3033: nvl(pay_balance_pkg.get_value(

3029: BEGIN
3030:
3031: if p_defined_balance_id is not null then
3032: ln_bal_value := fnd_number.number_to_canonical(
3033: nvl(pay_balance_pkg.get_value(
3034: p_defined_balance_id,
3035: p_balcall_aaid),0));
3036: end if;
3037:

Line 3348: pay_balance_pkg.set_context('JURISDICTION_CODE',

3344: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
3345: hr_utility.trace('Archiving for Jurisdiction = ' ||
3346: p_jurisdiction_tab(i).emp_jd);
3347:
3348: pay_balance_pkg.set_context('JURISDICTION_CODE',
3349: p_jurisdiction_tab(i).emp_jd);
3350:
3351: ln_bal_value := 0;
3352: ln_curr_withheld := 0;

Line 3747: pay_balance_pkg.set_context('JURISDICTION_CODE',

3743: lv_county_head_tax_exists);
3744: hr_utility.trace('COUNTY Archiving for Jurisdiction = ' ||
3745: p_jurisdiction_tab(i).emp_jd);
3746:
3747: pay_balance_pkg.set_context('JURISDICTION_CODE',
3748: p_jurisdiction_tab(i).emp_jd);
3749:
3750: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd);
3751:

Line 3931: pay_balance_pkg.set_context('JURISDICTION_CODE',

3927:
3928: hr_utility.trace('CITY Archiving for Jurisdiction = ' ||
3929: p_jurisdiction_tab(i).emp_jd);
3930:
3931: pay_balance_pkg.set_context('JURISDICTION_CODE',
3932: p_jurisdiction_tab(i).emp_jd);
3933:
3934: ln_index := get_table_index(p_jurisdiction_tab(i).emp_jd);
3935: hr_utility.trace('Index = '|| ln_index);

Line 4117: pay_balance_pkg.set_context('JURISDICTION_CODE',

4113: p_jurisdiction_tab(j).emp_jd);
4114: hr_utility.trace(' Parent JD for School Dist = ' ||
4115: p_jurisdiction_tab(j).emp_parent_jd);
4116:
4117: pay_balance_pkg.set_context('JURISDICTION_CODE',
4118: p_jurisdiction_tab(j).emp_jd);
4119:
4120: lv_emp_school_jd := p_jurisdiction_tab(j).emp_jd;
4121: ln_index := get_table_index(p_jurisdiction_tab(j).emp_jd);

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

4443:
4444: BEGIN
4445: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4446:
4447: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
4448:
4449: /*****************************************************************
4450: ** Get Jurisdictions from pay_run_results for all locked actions
4451: ** actions of the U,P,V case and then populating different PLSQL

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

4668:
4669: BEGIN
4670: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4671:
4672: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
4673:
4674: open c_get_emp_adjbal(p_xfr_action_id);
4675: loop
4676: fetch c_get_emp_adjbal into ln_baladj_action_id;

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

5243: lv_error_message VARCHAR2(200);
5244:
5245: BEGIN
5246: hr_utility.set_location(gv_package || lv_procedure_name, 10);
5247: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
5248: /****************************************************************
5249: ** For Seperate Check we do the YTD balance calls with the Run
5250: ** Action ID. So, we do not need to get the max. action which is
5251: ** not seperate Check.

Line 6047: ln_earnings := nvl(pay_balance_pkg.get_value(

6043: if c_all_runs%notfound then
6044: exit;
6045: end if;
6046:
6047: ln_earnings := nvl(pay_balance_pkg.get_value(
6048: gn_gross_earn_def_bal_id,
6049: ln_all_run_asg_act_id),0);
6050:
6051: /**************************************************

Line 6060: ln_earnings := nvl(pay_balance_pkg.get_value(

6056:
6057: if ln_earnings = 0 then
6058:
6059: ln_step := 20;
6060: ln_earnings := nvl(pay_balance_pkg.get_value(
6061: gn_payments_def_bal_id,
6062: ln_all_run_asg_act_id),0);
6063:
6064: end if;