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

Line 1680: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

1676:
1677: if l_bal_aaid <> -9999 then /* Assignment action in year */
1678: /* Set up the context of tax unit id */
1679: hr_utility.trace('Setting context');
1680: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1681:
1682: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1683: hr_utility.trace('defined_balance_id = '||
1684: to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));

Line 1686: l_value := nvl(pay_balance_pkg.get_value

1682: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1683: hr_utility.trace('defined_balance_id = '||
1684: to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));
1685:
1686: l_value := nvl(pay_balance_pkg.get_value
1687: (p_defined_balance_id
1688: => bal_db_item('GROSS_EARNINGS_PER_GRE_YTD'),
1689: p_assignment_action_id => l_bal_aaid),0);
1690:

Line 1696: l_value := nvl(pay_balance_pkg.get_value

1692: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1693: hr_utility.trace('defined_balance_id = '||
1694: to_char(bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD')));
1695:
1696: l_value := nvl(pay_balance_pkg.get_value
1697: (p_defined_balance_id
1698: => bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD'),
1699: p_assignment_action_id => l_bal_aaid),0);
1700:

Line 1706: l_value := nvl(pay_balance_pkg.get_value

1702: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1703: hr_utility.trace('defined_balance_id = '||
1704: to_char(bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD')));
1705:
1706: l_value := nvl(pay_balance_pkg.get_value
1707: (p_defined_balance_id
1708: => bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD'),
1709: p_assignment_action_id => l_bal_aaid),0);
1710:

Line 1716: l_value := nvl(pay_balance_pkg.get_value

1712: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1713: hr_utility.trace('defined_balance_id = '||
1714: to_char(bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD')));
1715:
1716: l_value := nvl(pay_balance_pkg.get_value
1717: (p_defined_balance_id
1718: => bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD'),
1719: p_assignment_action_id => l_bal_aaid),0);
1720:

Line 1726: l_value := nvl(pay_balance_pkg.get_value

1722: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1723: hr_utility.trace('defined_balance_id = '||
1724: to_char(bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD')));
1725:
1726: l_value := nvl(pay_balance_pkg.get_value
1727: (p_defined_balance_id
1728: => bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD'),
1729: p_assignment_action_id => l_bal_aaid),0);
1730:

Line 3219: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction_code);

3215: raise_application_error(-20001,'eoy_archinit:US_YEP_STATE formula not compiled');
3216: end;
3217:
3218: l_step := 6;
3219: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction_code);
3220:
3221: hr_utility.set_location ('eoy_archinit',2);
3222:
3223: /* Get the tax unit id and set it up as the context */

Line 3269: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_tax_unit_id);

3265:
3266: hr_utility.set_location ('eoy_archinit',3);
3267:
3268: l_step := 8;
3269: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_tax_unit_id);
3270:
3271: l_step := 9;
3272: hr_utility.set_location ('eoy_archinit getting min chunk number',10);
3273:

Line 4514: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));

4510: /* Set the no. of contexts */
4511: pay_archive.g_context_values.sz := l_count;
4512:
4513: if l_count = 1 then
4514: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));
4515: -- lt_jursd_context(1) := NULL;
4516: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));
4517: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
4518: else

Line 4557: lv_value := nvl(pay_balance_pkg.get_value

4553: pay_us_archive.ltr_pre_tax_bal.last loop
4554:
4555: l_step := 53;
4556:
4557: lv_value := nvl(pay_balance_pkg.get_value
4558: (p_defined_balance_id => pay_us_archive.ltr_pre_tax_bal(ln_count).defined_balance,
4559: p_assignment_action_id => l_aaid),0);
4560:
4561: l_step := 54;

Line 4589: lv_value := nvl(pay_balance_pkg.get_value

4585: pay_us_archive.ltr_w2_box_bal.last loop
4586:
4587: l_step := 55.1;
4588:
4589: lv_value := nvl(pay_balance_pkg.get_value
4590: (p_defined_balance_id => pay_us_archive.ltr_w2_box_bal(ln_count).defined_balance,
4591: p_assignment_action_id => l_aaid),0);
4592:
4593: l_step := 55.2;

Line 4675: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);

4671:
4672: hr_utility.trace('Maritial Status = '||l_marital_status);
4673: hr_utility.trace('Contact National Identifier = '||l_con_national_identifier);
4674:
4675: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
4676:
4677: l_step := 58;
4678:
4679: for k in pay_us_archive.ltr_pr_balances.first ..

Line 4686: l_value_tab(l_index) := nvl(pay_balance_pkg.get_value

4682: l_index := l_user_entity_id_tab.count + 1;
4683:
4684: l_user_entity_id_tab(l_index) := pay_us_archive.ltr_pr_balances(k).user_entity_id;
4685: l_defined_balance_id_tab(l_index) := pay_us_archive.ltr_pr_balances(k).defined_balance;
4686: l_value_tab(l_index) := nvl(pay_balance_pkg.get_value
4687: (p_defined_balance_id =>l_defined_balance_id_tab(l_index) ,
4688: p_assignment_action_id => l_aaid),0);
4689:
4690: end loop;

Line 4778: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);

4774: hr_utility.trace('l_ee_distribution_percent='||l_ee_distribution_percent);
4775: hr_utility.trace('l_total_distribution_percent = '||l_total_distribution_percent);
4776:
4777:
4778: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
4779:
4780: l_step := 77;
4781:
4782: for m in pay_us_archive.ltr_1099_bal.first ..

Line 4793: l_value_tab(l_index) := nvl(pay_balance_pkg.get_value

4789: l_balance_feed_tab(l_index) := pay_us_archive.ltr_1099_bal(m).feed_info;
4790:
4791: if l_balance_feed_tab(l_index) = 'Y' then
4792:
4793: l_value_tab(l_index) := nvl(pay_balance_pkg.get_value
4794: (p_defined_balance_id =>l_defined_balance_id_tab(l_index) ,
4795: p_assignment_action_id => l_aaid),0);
4796: else
4797: l_value_tab(l_index) := 0;

Line 4889: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);

4885:
4886: l_step := 94;
4887:
4888: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
4889: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
4890: pay_archive.balance_aa := l_aaid;
4891:
4892: l_step := 95;
4893: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);

Line 4893: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);

4889: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
4890: pay_archive.balance_aa := l_aaid;
4891:
4892: l_step := 95;
4893: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
4894:
4895: l_user_entity_id_tab.delete;
4896: l_user_entity_tab.delete;
4897: l_value_tab.delete;

Line 4917: l_value_tab(ln_count) := nvl(pay_balance_pkg.get_value

4913:
4914: hr_utility.trace('l_user_entity_tab('||ln_count||')is '||l_user_entity_tab(ln_count));
4915: hr_utility.trace('l_user_entity_id_tab('||ln_count||')is '||l_user_entity_id_tab(ln_count));
4916:
4917: l_value_tab(ln_count) := nvl(pay_balance_pkg.get_value
4918: (p_defined_balance_id =>bal_db_item(l_user_entity_tab(ln_count)),
4919: p_assignment_action_id => l_aaid),0);
4920:
4921: l_step := 97;

Line 5193: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);

5189: fetch c_get_jurisdiction
5190: into l_psd_jurisdiction;
5191: exit when c_get_jurisdiction%notfound;
5192:
5193: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
5194:
5195: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_psd_jurisdiction);
5196:
5197: hr_utility.trace('l_psd_jurisdiction '|| to_char(l_psd_jurisdiction));

Line 5195: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_psd_jurisdiction);

5191: exit when c_get_jurisdiction%notfound;
5192:
5193: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
5194:
5195: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_psd_jurisdiction);
5196:
5197: hr_utility.trace('l_psd_jurisdiction '|| to_char(l_psd_jurisdiction));
5198:
5199: --Archiving this balance to get the value of PSD Withheld

Line 5215: nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_psd_def_bal_id

5211: lv_user_entity_name;
5212: close pay_us_payroll_utils.c_get_defined_balance_id;
5213:
5214: l_psd_balance_value := fnd_number.number_to_canonical(
5215: nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_psd_def_bal_id
5216: ,p_assignment_action_id => l_aaid),0));
5217: hr_utility.trace('l_psd_bal_value in archive data: '||l_psd_balance_value);
5218:
5219: if (l_psd_balance_value<>0) then

Line 5235: nvl(pay_balance_pkg.get_value(p_defined_balance_id => ln_psd_def_bal_id

5231: pay_us_archive.ltr_psd_tax_bal(k).defined_balance;
5232:
5233:
5234: ln_bal_value := fnd_number.number_to_canonical(
5235: nvl(pay_balance_pkg.get_value(p_defined_balance_id => ln_psd_def_bal_id
5236: ,p_assignment_action_id => l_aaid),0));
5237:
5238: hr_utility.trace('ln_bal_value = '|| ln_bal_value);
5239: