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

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

1257: insert_xml_plsql_table( p_xml_data,'SOCIAL_SECURITY_ID',l_ss_id,
1258: 'D','C');
1259:
1260: /* Setting the Context for the Balances to be Fetched */
1261: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1262: pay_balance_pkg.set_context('DATE_EARNED',
1263: to_char(p_end_date_earned,'YYYY/MM/DD'));
1264: pay_balance_pkg.set_context('BALANCE_DATE',
1265: to_char(p_start_date_earned,'YYYY/MM/DD'));

Line 1262: pay_balance_pkg.set_context('DATE_EARNED',

1258: 'D','C');
1259:
1260: /* Setting the Context for the Balances to be Fetched */
1261: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1262: pay_balance_pkg.set_context('DATE_EARNED',
1263: to_char(p_end_date_earned,'YYYY/MM/DD'));
1264: pay_balance_pkg.set_context('BALANCE_DATE',
1265: to_char(p_start_date_earned,'YYYY/MM/DD'));
1266:

Line 1264: pay_balance_pkg.set_context('BALANCE_DATE',

1260: /* Setting the Context for the Balances to be Fetched */
1261: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1262: pay_balance_pkg.set_context('DATE_EARNED',
1263: to_char(p_end_date_earned,'YYYY/MM/DD'));
1264: pay_balance_pkg.set_context('BALANCE_DATE',
1265: to_char(p_start_date_earned,'YYYY/MM/DD'));
1266:
1267: dbg('Get Gross Earnings Balances');
1268:

Line 1270: l_gross_subj_ctd := pay_balance_pkg.get_value(

1266:
1267: dbg('Get Gross Earnings Balances');
1268:
1269: IF l_assignment_act <> 0 THEN
1270: l_gross_subj_ctd := pay_balance_pkg.get_value(
1271: p_assignment_action_id =>l_assignment_act,
1272: p_defined_balance_id =>l_gross_ctd_def_bal_id);
1273: END IF;
1274:

Line 1280: l_gross_subj_dtd := pay_balance_pkg.get_value(

1276: IF l_gross_dtd_def_bal_id IS NOT NULL THEN
1277:
1278: IF l_assignment_act <> 0 THEN
1279:
1280: l_gross_subj_dtd := pay_balance_pkg.get_value(
1281: p_assignment_action_id =>l_assignment_act,
1282: p_defined_balance_id =>l_gross_dtd_def_bal_id);
1283:
1284: END IF;

Line 1315: l_isr_witheld_ctd := pay_balance_pkg.get_value(

1311:
1312: dbg('Get ISR Tax Balance');
1313:
1314: IF l_assignment_act <> 0 THEN
1315: l_isr_witheld_ctd := pay_balance_pkg.get_value(
1316: p_assignment_action_id =>l_assignment_act,
1317: p_defined_balance_id =>l_isr_withheld_ctd_def_bal_id);
1318:
1319: l_isr_subj_ctd := pay_balance_pkg.get_value(

Line 1319: l_isr_subj_ctd := pay_balance_pkg.get_value(

1315: l_isr_witheld_ctd := pay_balance_pkg.get_value(
1316: p_assignment_action_id =>l_assignment_act,
1317: p_defined_balance_id =>l_isr_withheld_ctd_def_bal_id);
1318:
1319: l_isr_subj_ctd := pay_balance_pkg.get_value(
1320: p_assignment_action_id =>l_assignment_act,
1321: p_defined_balance_id =>l_isr_subj_ctd_def_bal_id);
1322: END IF;
1323:

Line 1329: l_isr_witheld_dtd := pay_balance_pkg.get_value(

1325: l_isr_subj_dtd_def_bal_id is not null THEN
1326:
1327: IF l_assignment_act <> 0 THEN
1328:
1329: l_isr_witheld_dtd := pay_balance_pkg.get_value(
1330: p_assignment_action_id =>l_assignment_act,
1331: p_defined_balance_id =>l_isr_withheld_dtd_def_bal_id);
1332:
1333: l_isr_subj_dtd := pay_balance_pkg.get_value(

Line 1333: l_isr_subj_dtd := pay_balance_pkg.get_value(

1329: l_isr_witheld_dtd := pay_balance_pkg.get_value(
1330: p_assignment_action_id =>l_assignment_act,
1331: p_defined_balance_id =>l_isr_withheld_dtd_def_bal_id);
1332:
1333: l_isr_subj_dtd := pay_balance_pkg.get_value(
1334: p_assignment_action_id =>l_assignment_act,
1335: p_defined_balance_id =>l_isr_subj_dtd_def_bal_id);
1336:
1337: END IF;

Line 1396: l_ss_ee_ctd := pay_balance_pkg.get_value(

1392: dbg('l_cnt5' || l_cnt5 );
1393: dbg('Soc Sec Ins Type: '||soc_sec_det_tab(l_cnt5).balance_name);
1394:
1395: IF l_assignment_act <> 0 THEN
1396: l_ss_ee_ctd := pay_balance_pkg.get_value(
1397: p_assignment_action_id =>l_assignment_act,
1398: p_defined_balance_id =>
1399: soc_sec_det_tab(l_cnt5).soc_sec_ee_ctd_id);
1400:

Line 1401: l_ss_er_ctd := pay_balance_pkg.get_value(

1397: p_assignment_action_id =>l_assignment_act,
1398: p_defined_balance_id =>
1399: soc_sec_det_tab(l_cnt5).soc_sec_ee_ctd_id);
1400:
1401: l_ss_er_ctd := pay_balance_pkg.get_value(
1402: p_assignment_action_id =>l_assignment_act,
1403: p_defined_balance_id =>
1404: soc_sec_det_tab(l_cnt5).soc_sec_er_ctd_id);
1405: END IF;

Line 1411: l_ss_ee_dtd := pay_balance_pkg.get_value(

1407: IF p_dimension <> 'CTD' THEN
1408:
1409: IF l_assignment_act <> 0 THEN
1410:
1411: l_ss_ee_dtd := pay_balance_pkg.get_value(
1412: p_assignment_action_id =>l_assignment_act,
1413: p_defined_balance_id =>
1414: soc_sec_det_tab(l_cnt5).soc_sec_ee_dtd_id);
1415: l_ss_er_dtd := pay_balance_pkg.get_value(

Line 1415: l_ss_er_dtd := pay_balance_pkg.get_value(

1411: l_ss_ee_dtd := pay_balance_pkg.get_value(
1412: p_assignment_action_id =>l_assignment_act,
1413: p_defined_balance_id =>
1414: soc_sec_det_tab(l_cnt5).soc_sec_ee_dtd_id);
1415: l_ss_er_dtd := pay_balance_pkg.get_value(
1416: p_assignment_action_id =>l_assignment_act,
1417: p_defined_balance_id =>
1418: soc_sec_det_tab(l_cnt5).soc_sec_er_dtd_id);
1419:

Line 1499: l_st_subj_ctd := pay_balance_pkg.get_value(

1495: IF l_st_withheld_dtd_def_bal_id IS NOT NULL THEN
1496:
1497: IF l_assignment_act <> 0 THEN
1498:
1499: l_st_subj_ctd := pay_balance_pkg.get_value(
1500: p_assignment_action_id =>l_assignment_act,
1501: p_defined_balance_id =>l_st_subj_ctd_def_bal_id);
1502:
1503: END IF;

Line 1513: l_st_witheld_ctd := pay_balance_pkg.get_value(

1509: IF l_st_withheld_ctd_def_bal_id IS NOT NULL THEN
1510:
1511: IF l_assignment_act <> 0 THEN
1512:
1513: l_st_witheld_ctd := pay_balance_pkg.get_value(
1514: p_assignment_action_id =>l_assignment_act,
1515: p_defined_balance_id =>l_st_withheld_ctd_def_bal_id);
1516:
1517: END IF;

Line 1534: l_st_subj_dtd := pay_balance_pkg.get_value(

1530: l_st_subj_dtd_def_bal_id IS NOT NULL THEN
1531:
1532: IF l_assignment_act <> 0 THEN
1533:
1534: l_st_subj_dtd := pay_balance_pkg.get_value(
1535: p_assignment_action_id =>l_assignment_act,
1536: p_defined_balance_id =>l_st_subj_dtd_def_bal_id);
1537:
1538: END IF;

Line 1544: l_st_witheld_dtd := pay_balance_pkg.get_value(

1540: IF l_state <> 'CHIH' THEN
1541:
1542: IF l_assignment_act <> 0 THEN
1543:
1544: l_st_witheld_dtd := pay_balance_pkg.get_value(
1545: p_assignment_action_id =>l_assignment_act,
1546: p_defined_balance_id =>l_st_withheld_dtd_def_bal_id);
1547:
1548: END IF;

Line 1616: l_st_earn_ctd_value := pay_balance_pkg.get_value(

1612: IF state_earnings(l_cnt50).state_earnings_ctd_id IS NOT NULL THEN
1613:
1614: IF l_assignment_act <> 0 THEN
1615:
1616: l_st_earn_ctd_value := pay_balance_pkg.get_value(
1617: p_assignment_action_id =>l_assignment_act,
1618: p_defined_balance_id =>
1619: state_earnings(l_cnt50).state_earnings_ctd_id);
1620:

Line 1632: l_st_earn_dtd_value := pay_balance_pkg.get_value(

1628: THEN
1629:
1630: IF l_assignment_act <> 0 THEN
1631:
1632: l_st_earn_dtd_value := pay_balance_pkg.get_value(
1633: p_assignment_action_id =>l_assignment_act,
1634: p_defined_balance_id =>
1635: state_earnings(l_cnt50).state_earnings_dtd_id);
1636: