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_MX_PAYROLL_ARCH dependencies on PAY_BALANCE_PKG

Line 230: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);

226: END IF;
227:
228: ln_step := 2;
229: IF p_jurisdiction_code IS NOT NULL THEN
230: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
231: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
232: ELSE
233: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
234: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

Line 233: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);

229: IF p_jurisdiction_code IS NOT NULL THEN
230: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
231: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
232: ELSE
233: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
234: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;
235: END IF;
236:
237:

Line 306: ln_ytd_amount := NVL(pay_balance_pkg.get_value(

302: IF lv_rate_exists = 'N' THEN
303: ln_step := 7;
304: hr_utility.set_location(gv_package || lv_procedure_name, 40);
305: IF ln_ytd_defined_balance_id IS NOT NULL THEN
306: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
307: ln_ytd_defined_balance_id,
308: p_ytd_balcall_aaid),0);
309: END IF;
310:

Line 314: ln_ytd_hours := NVL(pay_balance_pkg.get_value(

310:
311: IF p_hours_balance_id IS NOT NULL THEN
312: hr_utility.set_location(gv_package || lv_procedure_name, 50);
313: IF ln_ytd_hours_balance_id IS NOT NULL THEN
314: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
315: ln_ytd_hours_balance_id,
316: p_ytd_balcall_aaid),0);
317: hr_utility.set_location(gv_package || lv_procedure_name, 60);
318: END IF;

Line 324: ln_ytd_days := NVL(pay_balance_pkg.get_value(

320:
321: IF p_days_balance_id IS NOT NULL THEN
322: hr_utility.set_location(gv_package || lv_procedure_name, 50);
323: IF ln_ytd_days_balance_id IS NOT NULL THEN
324: ln_ytd_days := NVL(pay_balance_pkg.get_value(
325: ln_ytd_days_balance_id,
326: p_ytd_balcall_aaid),0);
327: hr_utility.set_location(gv_package || lv_procedure_name, 60);
328: END IF;

Line 359: ln_payments_amount := NVL(pay_balance_pkg.get_value(

355: /* END of addition FOR Reversals AND bal adjustments */
356: hr_utility.trace('ln_pymt_defined_balance_id ' ||
357: ln_pymt_defined_balance_id);
358: IF ln_pymt_defined_balance_id IS NOT NULL THEN
359: ln_payments_amount := NVL(pay_balance_pkg.get_value(
360: ln_pymt_defined_balance_id,
361: p_pymt_balcall_aaid),0);
362: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
363: END IF;

Line 391: ln_current_hours := NVL(pay_balance_pkg.get_value(

387:
388: hr_utility.trace('ln_pymt_hours_balance_id ' ||
389: ln_pymt_hours_balance_id);
390: IF ln_pymt_hours_balance_id IS NOT NULL THEN
391: ln_current_hours := NVL(pay_balance_pkg.get_value(
392: ln_pymt_hours_balance_id,
393: p_pymt_balcall_aaid),0);
394: END IF;
395: hr_utility.set_location(gv_package || lv_procedure_name, 120);

Line 424: ln_current_days := NVL(pay_balance_pkg.get_value(

420:
421: hr_utility.trace('ln_pymt_days_balance_id ' ||
422: ln_pymt_days_balance_id);
423: IF ln_pymt_days_balance_id IS NOT NULL THEN
424: ln_current_days := NVL(pay_balance_pkg.get_value(
425: ln_pymt_days_balance_id,
426: p_pymt_balcall_aaid),0);
427: END IF;
428: hr_utility.set_location(gv_package || lv_procedure_name, 120);

Line 789: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);

785: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
786: := lv_jurisdiction_code;
787:
788: IF lv_jurisdiction_code IS NOT NULL THEN
789: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
790: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
791: ELSE
792: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
793: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

Line 792: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);

788: IF lv_jurisdiction_code IS NOT NULL THEN
789: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
790: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
791: ELSE
792: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
793: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;
794: END IF;
795:
796: ln_step := 15;

Line 804: ln_ytd_amount := NVL(pay_balance_pkg.get_value(

800: gv_ytd_balance_dimension,
801: p_legislation_code);
802: hr_utility.set_location(gv_package || lv_procedure_name, 60);
803: IF ln_ytd_defined_balance_id IS NOT NULL THEN
804: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
805: ln_ytd_defined_balance_id,
806: p_ytd_balcall_aaid),0);
807: hr_utility.set_location(gv_package || lv_procedure_name, 70);
808: END IF;

Line 817: ln_ytd_hours := NVL(pay_balance_pkg.get_value(

813: gv_ytd_balance_dimension,
814: p_legislation_code);
815: hr_utility.set_location(gv_package || lv_procedure_name, 80);
816: IF ln_ytd_hours_balance_id IS NOT NULL THEN
817: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
818: ln_ytd_hours_balance_id,
819: p_ytd_balcall_aaid),0);
820: hr_utility.set_location(gv_package || lv_procedure_name, 90);
821: END IF;

Line 832: ln_ytd_days := NVL(pay_balance_pkg.get_value(

828: gv_ytd_balance_dimension,
829: p_legislation_code);
830: hr_utility.set_location(gv_package || lv_procedure_name, 80);
831: IF ln_ytd_days_balance_id IS NOT NULL THEN
832: ln_ytd_days := NVL(pay_balance_pkg.get_value(
833: ln_ytd_days_balance_id,
834: p_ytd_balcall_aaid),0);
835: hr_utility.set_location(gv_package || lv_procedure_name, 90);
836: END IF;

Line 1215: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);

1211: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
1212: := ln_hours_balance_id;
1213:
1214: IF lv_jurisdiction_code IS NOT NULL THEN
1215: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
1216: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
1217: ELSE
1218: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
1219: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

Line 1218: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);

1214: IF lv_jurisdiction_code IS NOT NULL THEN
1215: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
1216: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
1217: ELSE
1218: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
1219: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;
1220: END IF;
1221:
1222: ln_step := 15;

Line 1230: ln_ytd_amount := NVL(pay_balance_pkg.get_value(

1226: gv_ytd_balance_dimension,
1227: p_legislation_code);
1228: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1229: IF ln_ytd_defined_balance_id IS NOT NULL THEN
1230: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
1231: ln_ytd_defined_balance_id,
1232: p_ytd_balcall_aaid),0);
1233: END IF;
1234: hr_utility.set_location(gv_package || lv_procedure_name, 70);

Line 1243: ln_ytd_hours := NVL(pay_balance_pkg.get_value(

1239: gv_ytd_balance_dimension,
1240: p_legislation_code);
1241: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1242: IF ln_ytd_hours_balance_id IS NOT NULL THEN
1243: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1244: ln_ytd_hours_balance_id,
1245: p_ytd_balcall_aaid),0);
1246: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1247: END IF;

Line 1258: ln_ytd_hours := NVL(pay_balance_pkg.get_value(

1254: gv_ytd_balance_dimension,
1255: p_legislation_code);
1256: hr_utility.set_location(gv_package || lv_procedure_name, 93);
1257: IF ln_ytd_days_balance_id IS NOT NULL THEN
1258: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1259: ln_ytd_days_balance_id,
1260: p_ytd_balcall_aaid),0);
1261: hr_utility.set_location(gv_package || lv_procedure_name, 96);
1262: END IF;

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

2873: hr_utility.set_location(gv_package || lv_procedure_name, 10);
2874: i := 0;
2875: j := 0;
2876:
2877: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
2878:
2879: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2880: ln_step := 2;
2881: FOR i IN dbt.first..dbt.last LOOP

Line 2891: ln_pymt_amount := NVL(pay_balance_pkg.get_value(

2887:
2888: IF p_action_type IN ('V','B') THEN
2889: IF dbt(i).run_def_bal_id IS NOT NULL THEN
2890: ln_step := 5;
2891: ln_pymt_amount := NVL(pay_balance_pkg.get_value(
2892: dbt(i).run_def_bal_id,
2893: p_pymt_balcall_aaid),0);
2894: END IF;
2895: ELSE

Line 2898: ln_pymt_amount := NVL(pay_balance_pkg.get_value(

2894: END IF;
2895: ELSE
2896: IF dbt(i).pymt_def_bal_id IS NOT NULL THEN
2897: ln_step := 5;
2898: ln_pymt_amount := NVL(pay_balance_pkg.get_value(
2899: dbt(i).pymt_def_bal_id,
2900: p_pymt_balcall_aaid),0);
2901: END IF;
2902: END IF; -- p_action_type = 'V'

Line 2911: ln_ytd_amount := NVL(pay_balance_pkg.get_value(

2907:
2908: END IF; -- p_pymt_balcall_aaid <> -999
2909:
2910: ln_step := 7;
2911: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
2912: dbt(i).gre_ytd_def_bal_id,
2913: p_ytd_balcall_aaid),0);
2914:
2915: hr_utility.set_location(gv_package || lv_procedure_name, 30);

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

4436: lv_action_category := 'AC DEDUCTIONS';
4437:
4438:
4439: ln_step := 10;
4440: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id);
4441:
4442:
4443: -- Populating the PL/SQL table run_bal_stat_tab with the validity status
4444: -- of various attributes. If already populated, we use that to check the

Line 4543: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);

4539:
4540: END IF;
4541:
4542: IF lv_jurisdiction_code IS NOT NULL THEN
4543: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4544: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
4545: ELSE
4546: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4547: END IF;

Line 4546: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);

4542: IF lv_jurisdiction_code IS NOT NULL THEN
4543: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4544: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
4545: ELSE
4546: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4547: END IF;
4548:
4549:
4550: IF ln_hours_balance_id IS NOT NULL THEN

Line 4564: ln_ytd_hours := NVL(pay_balance_pkg.get_value(

4560: hr_utility.set_location(gv_package || lv_procedure_name, 70);
4561:
4562: ln_step := 50;
4563: IF ln_ytd_hours_balance_id IS NOT NULL THEN
4564: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
4565: ln_ytd_hours_balance_id,
4566: p_assignment_action_id),0);
4567: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4568: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 4588: ln_ytd_days := NVL(pay_balance_pkg.get_value(

4584: hr_utility.set_location(gv_package || lv_procedure_name, 100);
4585:
4586: ln_step := 70;
4587: IF ln_ytd_days_balance_id IS NOT NULL THEN
4588: ln_ytd_days := NVL(pay_balance_pkg.get_value(
4589: ln_ytd_days_balance_id,
4590: p_assignment_action_id),0);
4591: hr_utility.trace('ln_ytd_days = '||ln_ytd_days);
4592: hr_utility.set_location(gv_package || lv_procedure_name, 110);

Line 4609: ln_ytd_amount := NVL(pay_balance_pkg.get_value(

4605: ln_ytd_defined_balance_id);
4606: hr_utility.set_location(gv_package || lv_procedure_name, 120);
4607: IF ln_ytd_defined_balance_id IS NOT NULL THEN
4608: ln_step := 90;
4609: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
4610: ln_ytd_defined_balance_id,
4611: p_assignment_action_id),0);
4612: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4613: END IF;

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

5165: IF c_all_runs%NOTFOUND THEN
5166: EXIT;
5167: END IF;
5168:
5169: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
5170: ln_earnings := NVL(pay_balance_pkg.get_value(
5171: gn_gross_earn_def_bal_id,
5172: ln_all_run_asg_act_id),0);
5173:

Line 5170: ln_earnings := NVL(pay_balance_pkg.get_value(

5166: EXIT;
5167: END IF;
5168:
5169: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
5170: ln_earnings := NVL(pay_balance_pkg.get_value(
5171: gn_gross_earn_def_bal_id,
5172: ln_all_run_asg_act_id),0);
5173:
5174: /**************************************************

Line 5183: -- ln_earnings := NVL(pay_balance_pkg.get_value(

5179:
5180: -- IF ln_earnings = 0 THEN
5181:
5182: -- ln_step := 20;
5183: -- ln_earnings := NVL(pay_balance_pkg.get_value(
5184: -- gn_payments_def_bal_id,
5185: -- ln_all_run_asg_act_id),0);
5186:
5187: -- END IF;