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 966: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);

962: end if;
963:
964: ln_step := 2;
965: if p_jurisdiction_code <> '00-000-0000' then
966: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
967: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
968: else
969: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
970: if gv_reporting_level = 'TAXGRP' then

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

965: if p_jurisdiction_code <> '00-000-0000' then
966: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
967: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
968: else
969: pay_balance_pkg.set_context('JURISDICTION_CODE', p_jurisdiction_code);
970: if gv_reporting_level = 'TAXGRP' then
971: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
972: else
973: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

1029: if lv_rate_exists = 'N' then
1030: ln_step := 7;
1031: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1032: if ln_ytd_defined_balance_id is not null then
1033: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
1034: ln_ytd_defined_balance_id,
1035: p_ytd_balcall_aaid),0);
1036: end if;
1037:

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

1037:
1038: if p_hours_balance_id is not null then
1039: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1040: if ln_ytd_hours_balance_id is not null then
1041: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1042: ln_ytd_hours_balance_id,
1043: p_ytd_balcall_aaid),0);
1044: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1045: end if;

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

1075: hr_utility.trace('ln_pymt_defined_balance_id ' ||
1076: ln_pymt_defined_balance_id);
1077:
1078: if ln_pymt_defined_balance_id is not null then
1079: ln_payments_amount := nvl(pay_balance_pkg.get_value(
1080: ln_pymt_defined_balance_id,
1081: p_pymt_balcall_aaid),0);
1082: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
1083: end if;

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

1110: hr_utility.trace('ln_pymt_hours_balance_id ' ||
1111: ln_pymt_hours_balance_id);
1112:
1113: if ln_pymt_hours_balance_id is not null then
1114: ln_current_hours := nvl(pay_balance_pkg.get_value(
1115: ln_pymt_hours_balance_id,
1116: p_pymt_balcall_aaid),0);
1117: end if;
1118: hr_utility.set_location(gv_package || lv_procedure_name, 120);

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

1462: (ln_hours_balance_id,
1463: gv_dim_asg_tg_ytd,
1464: p_legislation_code);
1465: if ln_tg_ytd_defined_bal_id is not null then
1466: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
1467: ln_tg_ytd_defined_bal_id,
1468: p_ytd_balcall_aaid),0);
1469: end if;
1470: if ln_hours_ytd_defined_bal_id is not null then

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

1467: ln_tg_ytd_defined_bal_id,
1468: p_ytd_balcall_aaid),0);
1469: end if;
1470: if ln_hours_ytd_defined_bal_id is not null then
1471: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1472: ln_hours_ytd_defined_bal_id,
1473: p_ytd_balcall_aaid),0);
1474: end if;
1475: else

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

1484: (ln_hours_balance_id,
1485: gv_dim_asg_gre_ytd,
1486: p_legislation_code);
1487: if ln_gre_ytd_defined_bal_id is not null then
1488: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
1489: ln_gre_ytd_defined_bal_id,
1490: p_ytd_balcall_aaid),0);
1491: end if;
1492: if ln_hours_ytd_defined_bal_id is not null then

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

1489: ln_gre_ytd_defined_bal_id,
1490: p_ytd_balcall_aaid),0);
1491: end if;
1492: if ln_hours_ytd_defined_bal_id is not null then
1493: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
1494: ln_hours_ytd_defined_bal_id,
1495: p_ytd_balcall_aaid),0);
1496: end if;
1497: end if;

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

1511: (ln_primary_balance_id,
1512: '_ASG_PAYMENTS',
1513: p_legislation_code);
1514:
1515: ln_pymt_bal_amt := nvl(pay_balance_pkg.get_value(
1516: ln_pymt_def_bal_id,
1517: p_pymt_balcall_aaid),0);
1518:
1519: hr_utility.trace('ln_pymt_bal_amt : '||ln_pymt_bal_amt);

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

2762: pay_ac_action_arch.emp_elements_tab(ln_index).element_hours_balance_id
2763: := ln_hours_balance_id;
2764:
2765: if lv_jurisdiction_code <> '00-000-0000' then
2766: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
2767: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
2768: else
2769: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
2770: if gv_reporting_level = 'TAXGRP' then

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

2765: if lv_jurisdiction_code <> '00-000-0000' then
2766: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
2767: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
2768: else
2769: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
2770: if gv_reporting_level = 'TAXGRP' then
2771: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
2772: else
2773: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

2781: gv_ytd_balance_dimension,
2782: p_legislation_code);
2783: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2784: if ln_ytd_defined_balance_id is not null then
2785: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
2786: ln_ytd_defined_balance_id,
2787: p_ytd_balcall_aaid),0);
2788: end if;
2789: hr_utility.set_location(gv_package || lv_procedure_name, 70);

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

2794: gv_ytd_balance_dimension,
2795: p_legislation_code);
2796: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2797: if ln_ytd_hours_balance_id is not null then
2798: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
2799: ln_ytd_hours_balance_id,
2800: p_ytd_balcall_aaid),0);
2801: hr_utility.set_location(gv_package || lv_procedure_name, 90);
2802: end if;

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

3066: pay_ac_action_arch.emp_elements_tab(ln_index).jurisdiction_code
3067: := lv_jurisdiction_code;
3068:
3069: if lv_jurisdiction_code <> '00-000-0000' then
3070: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3071: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3072: else
3073: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3074: if gv_reporting_level = 'TAXGRP' then

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

3069: if lv_jurisdiction_code <> '00-000-0000' then
3070: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3071: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3072: else
3073: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3074: if gv_reporting_level = 'TAXGRP' then
3075: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
3076: else
3077: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

3085: gv_ytd_balance_dimension,
3086: p_legislation_code);
3087: hr_utility.set_location(gv_package || lv_procedure_name, 60);
3088: if ln_ytd_defined_balance_id is not null then
3089: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
3090: ln_ytd_defined_balance_id,
3091: p_ytd_balcall_aaid),0);
3092: hr_utility.set_location(gv_package || lv_procedure_name, 70);
3093: end if;

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

3098: gv_ytd_balance_dimension,
3099: p_legislation_code);
3100: hr_utility.set_location(gv_package || lv_procedure_name, 80);
3101: if ln_ytd_hours_balance_id is not null then
3102: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3103: ln_ytd_hours_balance_id,
3104: p_ytd_balcall_aaid),0);
3105: hr_utility.set_location(gv_package || lv_procedure_name, 90);
3106: end if;

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

3924: BEGIN
3925: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3926:
3927: ln_step := 10;
3928: pay_balance_pkg.set_context('TAX_UNIT_ID',p_tax_unit_id); -- Bug 3639249
3929: OPEN c_prev_ytd_action_elements(p_assignment_id
3930: ,p_curr_eff_date
3931: ,trunc(p_curr_eff_date, 'Y')
3932: ,'R', 'Q', 'B');

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

3952: hr_utility.trace('primary balance id = ' || ln_primary_balance_id);
3953: hr_utility.trace('hours balance id = ' || ln_hours_balance_id);
3954:
3955: if lv_jurisdiction_code <> '00-000-0000' then
3956: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3957: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3958: else
3959: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3960: if gv_reporting_level = 'TAXGRP' then

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

3955: if lv_jurisdiction_code <> '00-000-0000' then
3956: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3957: gv_ytd_balance_dimension := gv_dim_asg_jd_gre_ytd;
3958: else
3959: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
3960: if gv_reporting_level = 'TAXGRP' then
3961: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
3962: else
3963: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

3981: hr_utility.set_location(gv_package || lv_procedure_name, 24);
3982:
3983: ln_step := 40;
3984: if ln_ytd_hours_balance_id is not null then
3985: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
3986: ln_ytd_hours_balance_id,
3987: p_assignment_action_id),0);
3988: hr_utility.trace('ln_ytd_hours = '||ln_ytd_hours);
3989: hr_utility.set_location(gv_package || lv_procedure_name, 26);

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

4000: ln_ytd_defined_balance_id);
4001: hr_utility.set_location(gv_package || lv_procedure_name, 30);
4002: if ln_ytd_defined_balance_id is not null then
4003: ln_step := 60;
4004: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
4005: ln_ytd_defined_balance_id,
4006: p_assignment_action_id),0);
4007: hr_utility.trace('ln_ytd_amount = '||ln_ytd_amount);
4008: end if;

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

4645: := pay_emp_action_arch.get_multi_legislative_rule(
4646: p_legislation_code);
4647: end if;
4648:
4649: pay_balance_pkg.set_context('JURISDICTION_CODE', NULL);
4650:
4651: if gv_reporting_level = 'TAXGRP' then
4652: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
4653: else

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

4664: hr_utility.trace('ln_ytd_defined_balance_id = ' ||
4665: ln_ytd_defined_balance_id);
4666:
4667: if ln_ytd_defined_balance_id is not null then
4668: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
4669: ln_ytd_defined_balance_id,
4670: p_ytd_balcall_aaid),0);
4671: end if;
4672: if p_hours_balance_id is not null then

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

4680: hr_utility.trace('ln_ytd_hours_balance_id = ' ||
4681: ln_ytd_hours_balance_id);
4682:
4683: if ln_ytd_hours_balance_id is not null then
4684: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
4685: ln_ytd_hours_balance_id,
4686: p_ytd_balcall_aaid),0);
4687: hr_utility.set_location(gv_package || lv_procedure_name, 60);
4688: end if;

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

5155: := pay_emp_action_arch.get_multi_legislative_rule(
5156: p_legislation_code);
5157: end if;
5158:
5159: pay_balance_pkg.set_context('JURISDICTION_CODE', null);
5160: if gv_reporting_level = 'TAXGRP' then
5161: gv_ytd_balance_dimension := gv_dim_asg_tg_ytd;
5162: else
5163: gv_ytd_balance_dimension := gv_dim_asg_gre_ytd;

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

5192:
5193: ln_step := 5;
5194: hr_utility.set_location(gv_package || lv_procedure_name, 40);
5195: if ln_ytd_defined_balance_id is not null then
5196: ln_ytd_amount := nvl(pay_balance_pkg.get_value(
5197: ln_ytd_defined_balance_id,
5198: p_ytd_balcall_aaid),0);
5199: end if;
5200:

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

5200:
5201: if p_hours_balance_id is not null then
5202: hr_utility.set_location(gv_package || lv_procedure_name, 50);
5203: if ln_ytd_hours_balance_id is not null then
5204: ln_ytd_hours := nvl(pay_balance_pkg.get_value(
5205: ln_ytd_hours_balance_id,
5206: p_ytd_balcall_aaid),0);
5207: hr_utility.set_location(gv_package || lv_procedure_name, 60);
5208: end if;

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

5238: hr_utility.trace('ln_pymt_defined_balance_id ' ||
5239: ln_pymt_defined_balance_id);
5240:
5241: if ln_pymt_defined_balance_id is not null then
5242: ln_payments_amount := nvl(pay_balance_pkg.get_value(
5243: ln_pymt_defined_balance_id,
5244: p_pymt_balcall_aaid),0);
5245: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
5246: end if;