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

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

1246: end if;
1247:
1248: ln_step := 2;
1249: if p_jurisdiction_code <> '00-000-0000' then
1250: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
1251: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
1252: else
1253: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
1254: if gv_reporting_level = 'TAXGRP' then

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

1249: if p_jurisdiction_code <> '00-000-0000' then
1250: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
1251: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
1252: else
1253: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
1254: if gv_reporting_level = 'TAXGRP' then
1255: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
1256: else
1257: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

1313: if lv_rate_exists = 'N' then
1314: ln_step := 7;
1315: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1316: if ln_ytd_defined_balance_id is not null then
1317: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
1318: ln_ytd_defined_balance_id,
1319: p_ytd_balcall_aaid),0);
1320: end if;
1321:

Line 1325: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

1321:
1322: if p_hours_balance_id is not null then
1323: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1324: if ln_ytd_hours_balance_id is not null then
1325: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1326: ln_ytd_hours_balance_id,
1327: p_ytd_balcall_aaid),0);
1328: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1329: end if;

Line 1363: ln_payments_amount := nvl(pay_balance_pkg.get_value(

1359: hr_utility.trace('ln_pymt_defined_balance_id ' ||
1360: ln_pymt_defined_balance_id);
1361:
1362: if ln_pymt_defined_balance_id is not null then
1363: ln_payments_amount := nvl(pay_balance_pkg.get_value(
1364: ln_pymt_defined_balance_id,
1365: p_pymt_balcall_aaid),0);
1366: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
1367: end if;

Line 1398: ln_current_hours := nvl(pay_balance_pkg.get_value(

1394: hr_utility.trace('ln_pymt_hours_balance_id ' ||
1395: ln_pymt_hours_balance_id);
1396:
1397: if ln_pymt_hours_balance_id is not null then
1398: ln_current_hours := nvl(pay_balance_pkg.get_value(
1399: ln_pymt_hours_balance_id,
1400: p_pymt_balcall_aaid),0);
1401: end if;
1402: hr_utility.set_location(gv_package || lv_procedure_name, 120);

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

1772: (ln_hours_balance_id,
1773: gv_dim_asg_tg_ytd,
1774: p_legislation_code);
1775: if ln_tg_ytd_defined_bal_id is not null then
1776: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
1777: ln_tg_ytd_defined_bal_id,
1778: p_ytd_balcall_aaid),0);
1779: end if;
1780: if ln_hours_ytd_defined_bal_id is not null then

Line 1781: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

1777: ln_tg_ytd_defined_bal_id,
1778: p_ytd_balcall_aaid),0);
1779: end if;
1780: if ln_hours_ytd_defined_bal_id is not null then
1781: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1782: ln_hours_ytd_defined_bal_id,
1783: p_ytd_balcall_aaid),0);
1784: end if;
1785: else

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

1794: (ln_hours_balance_id,
1795: gv_dim_asg_gre_ytd,
1796: p_legislation_code);
1797: if ln_gre_ytd_defined_bal_id is not null then
1798: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
1799: ln_gre_ytd_defined_bal_id,
1800: p_ytd_balcall_aaid),0);
1801: end if;
1802: if ln_hours_ytd_defined_bal_id is not null then

Line 1803: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

1799: ln_gre_ytd_defined_bal_id,
1800: p_ytd_balcall_aaid),0);
1801: end if;
1802: if ln_hours_ytd_defined_bal_id is not null then
1803: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1804: ln_hours_ytd_defined_bal_id,
1805: p_ytd_balcall_aaid),0);
1806: end if;
1807: end if;

Line 1825: ln_pymt_bal_amt := nvl(pay_balance_pkg.get_value(

1821: (ln_primary_balance_id,
1822: '_ASG_PAYMENTS',
1823: p_legislation_code);
1824:
1825: ln_pymt_bal_amt := nvl(pay_balance_pkg.get_value(
1826: ln_pymt_def_bal_id,
1827: p_pymt_balcall_aaid),0);
1828:
1829: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);

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

3255: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
3256: := ln_hours_balance_id;
3257:
3258: if lv_jurisdiction_code <> '00-000-0000' then
3259: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3260: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3261: else
3262: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3263: if gv_reporting_level = 'TAXGRP' then

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

3258: if lv_jurisdiction_code <> '00-000-0000' then
3259: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3260: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3261: else
3262: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3263: if gv_reporting_level = 'TAXGRP' then
3264: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
3265: else
3266: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

3274: gv_ytd_balance_dimension,
3275: p_legislation_code);
3276: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3277: if ln_ytd_defined_balance_id is not null then
3278: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3279: ln_ytd_defined_balance_id,
3280: p_ytd_balcall_aaid),0);
3281: end if;
3282: hr_utility.set_location(gv_package || lv_procedure_name, 70);

Line 3291: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

3287: gv_ytd_balance_dimension,
3288: p_legislation_code);
3289: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3290: if ln_ytd_hours_balance_id is not null then
3291: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3292: ln_ytd_hours_balance_id,
3293: p_ytd_balcall_aaid),0);
3294: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3295: end if;

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

3561: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3562: := lv_jurisdiction_code;
3563:
3564: if lv_jurisdiction_code <> '00-000-0000' then
3565: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3566: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3567: else
3568: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3569: if gv_reporting_level = 'TAXGRP' then

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

3564: if lv_jurisdiction_code <> '00-000-0000' then
3565: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3566: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3567: else
3568: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3569: if gv_reporting_level = 'TAXGRP' then
3570: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
3571: else
3572: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

3580: gv_ytd_balance_dimension,
3581: p_legislation_code);
3582: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3583: if ln_ytd_defined_balance_id is not null then
3584: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3585: ln_ytd_defined_balance_id,
3586: p_ytd_balcall_aaid),0);
3587: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3588: end if;

Line 3597: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

3593: gv_ytd_balance_dimension,
3594: p_legislation_code);
3595: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3596: if ln_ytd_hours_balance_id is not null then
3597: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3598: ln_ytd_hours_balance_id,
3599: p_ytd_balcall_aaid),0);
3600: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3601: end if;

Line 4423: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id); -- Bug 3639249

4419: BEGIN
4420: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4421:
4422: ln_step := 10;
4423: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id); -- Bug 3639249
4424: OPEN c_prev_ytd_action_elements(p_assignment_id
4425: ,p_curr_eff_date
4426: ,trunc(p_curr_eff_date, 'Y')
4427: ,'R', 'Q', 'B');

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

4447: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
4448: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
4449:
4450: if lv_jurisdiction_code <> '00-000-0000' then
4451: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4452: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
4453: else
4454: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4455: if gv_reporting_level = 'TAXGRP' then

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

4450: if lv_jurisdiction_code <> '00-000-0000' then
4451: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4452: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
4453: else
4454: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
4455: if gv_reporting_level = 'TAXGRP' then
4456: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
4457: else
4458: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

Line 4480: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

4476: hr_utility.set_location(gv_package || lv_procedure_name, 24);
4477:
4478: ln_step := 40;
4479: if ln_ytd_hours_balance_id is not null then
4480: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
4481: ln_ytd_hours_balance_id,
4482: p_assignment_action_id),0);
4483: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
4484: hr_utility.set_location(gv_package || lv_procedure_name, 26);

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

4495: ln_ytd_defined_balance_id);
4496: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4497: if ln_ytd_defined_balance_id is not null then
4498: ln_step := 60;
4499: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
4500: ln_ytd_defined_balance_id,
4501: p_assignment_action_id),0);
4502: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4503: end if;

Line 5245: pay_balance_pkg.set_context('JURISDICTION_CODE', NULL);

5241: := pay_emp_action_arch.get_multi_legislative_rule(
5242: p_legislation_code);
5243: end if;
5244:
5245: pay_balance_pkg.set_context('JURISDICTION_CODE', NULL);
5246: if gv_reporting_level = 'TAXGRP' then
5247: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
5248: else
5249: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

5259: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
5260: ln_ytd_defined_balance_id);
5261:
5262: if ln_ytd_defined_balance_id is not null then
5263: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
5264: ln_ytd_defined_balance_id,
5265: p_ytd_balcall_aaid),0);
5266: end if;
5267: if p_hours_balance_id is not null then

Line 5279: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

5275: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
5276: ln_ytd_hours_balance_id);
5277:
5278: if ln_ytd_hours_balance_id is not null then
5279: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5280: ln_ytd_hours_balance_id,
5281: p_ytd_balcall_aaid),0);
5282: hr_utility.set_location(gv_package || lv_procedure_name, 60);
5283: end if;

Line 5782: pay_balance_pkg.set_context('JURISDICTION_CODE', null);

5778: := pay_emp_action_arch.get_multi_legislative_rule(
5779: p_legislation_code);
5780: end if;
5781:
5782: pay_balance_pkg.set_context('JURISDICTION_CODE', null);
5783: if gv_reporting_level = 'TAXGRP' then
5784: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
5785: else
5786: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

5815:
5816: ln_step := 5;
5817: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5818: if ln_ytd_defined_balance_id is not null then
5819: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
5820: ln_ytd_defined_balance_id,
5821: p_ytd_balcall_aaid),0);
5822: end if;
5823:

Line 5827: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

5823:
5824: if p_hours_balance_id is not null then
5825: hr_utility.set_location(gv_package || lv_procedure_name, 50);
5826: if ln_ytd_hours_balance_id is not null then
5827: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5828: ln_ytd_hours_balance_id,
5829: p_ytd_balcall_aaid),0);
5830: hr_utility.set_location(gv_package || lv_procedure_name, 60);
5831: end if;

Line 5865: ln_payments_amount := nvl(pay_balance_pkg.get_value(

5861: hr_utility.trace('ln_pymt_defined_balance_id ' ||
5862: ln_pymt_defined_balance_id);
5863:
5864: if ln_pymt_defined_balance_id is not null then
5865: ln_payments_amount := nvl(pay_balance_pkg.get_value(
5866: ln_pymt_defined_balance_id,
5867: p_pymt_balcall_aaid),0);
5868: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
5869: end if;

Line 6394: pay_balance_pkg.set_context('JURISDICTION_CODE', null);

6390: := pay_emp_action_arch.get_multi_legislative_rule(
6391: p_legislation_code);
6392: end if;
6393:
6394: pay_balance_pkg.set_context('JURISDICTION_CODE', null);
6395: if gv_reporting_level = 'TAXGRP' then
6396: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
6397: else
6398: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

6427:
6428: ln_step := 5;
6429: hr_utility.set_location(gv_package || lv_procedure_name, 40);
6430: if ln_ytd_defined_balance_id is not null then
6431: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
6432: ln_ytd_defined_balance_id,
6433: p_ytd_balcall_aaid),0);
6434: end if;
6435:

Line 6439: ln_ytd_hours := nvl(pay_balance_pkg.get_value(

6435:
6436: if p_hours_balance_id is not null then
6437: hr_utility.set_location(gv_package || lv_procedure_name, 50);
6438: if ln_ytd_hours_balance_id is not null then
6439: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
6440: ln_ytd_hours_balance_id,
6441: p_ytd_balcall_aaid),0);
6442: hr_utility.set_location(gv_package || lv_procedure_name, 60);
6443: end if;

Line 6477: ln_payments_amount := nvl(pay_balance_pkg.get_value(

6473: hr_utility.trace('ln_pymt_defined_balance_id ' ||
6474: ln_pymt_defined_balance_id);
6475:
6476: if ln_pymt_defined_balance_id is not null then
6477: ln_payments_amount := nvl(pay_balance_pkg.get_value(
6478: ln_pymt_defined_balance_id,
6479: p_pymt_balcall_aaid),0);
6480: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
6481: end if;