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 1376: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

1372:
1373: if l_bal_aaid <> -9999 then /* Assignment action in year */
1374: /* Set up the context of tax unit id */
1375: hr_utility.trace('Setting context');
1376: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1377:
1378: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1379: hr_utility.trace('defined_balance_id = '||
1380: to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));

Line 1382: l_value := nvl(pay_balance_pkg.get_value

1378: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1379: hr_utility.trace('defined_balance_id = '||
1380: to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));
1381:
1382: l_value := nvl(pay_balance_pkg.get_value
1383: (p_defined_balance_id
1384: => bal_db_item('GROSS_EARNINGS_PER_GRE_YTD'),
1385: p_assignment_action_id => l_bal_aaid),0);
1386:

Line 1392: l_value := nvl(pay_balance_pkg.get_value

1388: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1389: hr_utility.trace('defined_balance_id = '||
1390: to_char(bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD')));
1391:
1392: l_value := nvl(pay_balance_pkg.get_value
1393: (p_defined_balance_id
1394: => bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD'),
1395: p_assignment_action_id => l_bal_aaid),0);
1396:

Line 1402: l_value := nvl(pay_balance_pkg.get_value

1398: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1399: hr_utility.trace('defined_balance_id = '||
1400: to_char(bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD')));
1401:
1402: l_value := nvl(pay_balance_pkg.get_value
1403: (p_defined_balance_id
1404: => bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD'),
1405: p_assignment_action_id => l_bal_aaid),0);
1406:

Line 1412: l_value := nvl(pay_balance_pkg.get_value

1408: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1409: hr_utility.trace('defined_balance_id = '||
1410: to_char(bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD')));
1411:
1412: l_value := nvl(pay_balance_pkg.get_value
1413: (p_defined_balance_id
1414: => bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD'),
1415: p_assignment_action_id => l_bal_aaid),0);
1416:

Line 1422: l_value := nvl(pay_balance_pkg.get_value

1418: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
1419: hr_utility.trace('defined_balance_id = '||
1420: to_char(bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD')));
1421:
1422: l_value := nvl(pay_balance_pkg.get_value
1423: (p_defined_balance_id
1424: => bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD'),
1425: p_assignment_action_id => l_bal_aaid),0);
1426:

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

2705: raise_application_error(-20001,'eoy_archinit:US_YEP_STATE formula not compiled');
2706: end;
2707:
2708: l_step := 6;
2709: pay_balance_pkg.set_context ('JURISDICTION_CODE',l_jurisdiction_code);
2710:
2711: hr_utility.set_location ('eoy_archinit',2);
2712:
2713: /* Get the tax unit id and set it up as the context */

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

2755:
2756: hr_utility.set_location ('eoy_archinit',3);
2757:
2758: l_step := 8;
2759: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_tax_unit_id);
2760:
2761: l_step := 9;
2762: hr_utility.set_location ('eoy_archinit getting min chunk number',10);
2763:

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

3878: /* Set the no. of contexts */
3879: pay_archive.g_context_values.sz := l_count;
3880:
3881: if l_count = 1 then
3882: -- pay_balance_pkg.set_context ('JURISDICTION_CODE',lt_jursd_context(1));
3883: -- lt_jursd_context(1) := NULL;
3884: hr_utility.trace('One context only name : ' || pay_archive.g_context_values.name(1));
3885: hr_utility.trace('One context only value : ' || pay_archive.g_context_values.value(1));
3886: else

Line 3925: lv_value := nvl(pay_balance_pkg.get_value

3921: pay_us_archive.ltr_pre_tax_bal.last loop
3922:
3923: l_step := 53;
3924:
3925: lv_value := nvl(pay_balance_pkg.get_value
3926: (p_defined_balance_id => pay_us_archive.ltr_pre_tax_bal(ln_count).defined_balance,
3927: p_assignment_action_id => l_aaid),0);
3928:
3929: l_step := 54;

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

4007:
4008: hr_utility.trace('Maritial Status = '||l_marital_status);
4009: hr_utility.trace('Contact National Identifier = '||l_con_national_identifier);
4010:
4011: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
4012:
4013: l_step := 58;
4014:
4015: for k in pay_us_archive.ltr_pr_balances.first ..

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

4018: l_index := l_user_entity_id_tab.count + 1;
4019:
4020: l_user_entity_id_tab(l_index) := pay_us_archive.ltr_pr_balances(k).user_entity_id;
4021: l_defined_balance_id_tab(l_index) := pay_us_archive.ltr_pr_balances(k).defined_balance;
4022: l_value_tab(l_index) := nvl(pay_balance_pkg.get_value
4023: (p_defined_balance_id =>l_defined_balance_id_tab(l_index) ,
4024: p_assignment_action_id => l_aaid),0);
4025:
4026: end loop;

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

4106: hr_utility.trace('l_ee_distribution_percent='||l_ee_distribution_percent);
4107: hr_utility.trace('l_total_distribution_percent = '||l_total_distribution_percent);
4108:
4109:
4110: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
4111:
4112: l_step := 77;
4113:
4114: for m in pay_us_archive.ltr_1099_bal.first ..

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

4121: l_balance_feed_tab(l_index) := pay_us_archive.ltr_1099_bal(m).feed_info;
4122:
4123: if l_balance_feed_tab(l_index) = 'Y' then
4124:
4125: l_value_tab(l_index) := nvl(pay_balance_pkg.get_value
4126: (p_defined_balance_id =>l_defined_balance_id_tab(l_index) ,
4127: p_assignment_action_id => l_aaid),0);
4128: else
4129: l_value_tab(l_index) := 0;

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

4216:
4217: l_step := 94;
4218:
4219: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
4220: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
4221: pay_archive.balance_aa := l_aaid;
4222:
4223: l_step := 95;
4224: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);

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

4220: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
4221: pay_archive.balance_aa := l_aaid;
4222:
4223: l_step := 95;
4224: pay_balance_pkg.set_context('TAX_UNIT_ID',l_taxunitid);
4225:
4226: l_user_entity_id_tab.delete;
4227: l_user_entity_tab.delete;
4228: l_value_tab.delete;

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

4244:
4245: hr_utility.trace('l_user_entity_tab('||ln_count||')is '||l_user_entity_tab(ln_count));
4246: hr_utility.trace('l_user_entity_id_tab('||ln_count||')is '||l_user_entity_id_tab(ln_count));
4247:
4248: l_value_tab(ln_count) := nvl(pay_balance_pkg.get_value
4249: (p_defined_balance_id =>bal_db_item(l_user_entity_tab(ln_count)),
4250: p_assignment_action_id => l_aaid),0);
4251:
4252: l_step := 97;