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

1284: insert_xml_plsql_table( p_xml_data,'SOCIAL_SECURITY_ID',l_ss_id,
1285: 'D','C');
1286:
1287: /* Setting the Context for the Balances to be Fetched */
1288: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1289: pay_balance_pkg.set_context('DATE_EARNED',
1290: to_char(p_end_date_earned,'YYYY/MM/DD'));
1291: pay_balance_pkg.set_context('BALANCE_DATE',
1292: to_char(p_start_date_earned,'YYYY/MM/DD'));

Line 1289: pay_balance_pkg.set_context('DATE_EARNED',

1285: 'D','C');
1286:
1287: /* Setting the Context for the Balances to be Fetched */
1288: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1289: pay_balance_pkg.set_context('DATE_EARNED',
1290: to_char(p_end_date_earned,'YYYY/MM/DD'));
1291: pay_balance_pkg.set_context('BALANCE_DATE',
1292: to_char(p_start_date_earned,'YYYY/MM/DD'));
1293:

Line 1291: pay_balance_pkg.set_context('BALANCE_DATE',

1287: /* Setting the Context for the Balances to be Fetched */
1288: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1289: pay_balance_pkg.set_context('DATE_EARNED',
1290: to_char(p_end_date_earned,'YYYY/MM/DD'));
1291: pay_balance_pkg.set_context('BALANCE_DATE',
1292: to_char(p_start_date_earned,'YYYY/MM/DD'));
1293:
1294: dbg('Get Gross Earnings Balances');
1295:

Line 1297: l_gross_subj_ctd := pay_balance_pkg.get_value(

1293:
1294: dbg('Get Gross Earnings Balances');
1295:
1296: IF l_assignment_act <> 0 THEN
1297: l_gross_subj_ctd := pay_balance_pkg.get_value(
1298: p_assignment_action_id =>l_assignment_act,
1299: p_defined_balance_id =>l_gross_ctd_def_bal_id);
1300: END IF;
1301:

Line 1307: l_gross_subj_dtd := pay_balance_pkg.get_value(

1303: IF l_gross_dtd_def_bal_id IS NOT NULL THEN
1304:
1305: IF l_assignment_act <> 0 THEN
1306:
1307: l_gross_subj_dtd := pay_balance_pkg.get_value(
1308: p_assignment_action_id =>l_assignment_act,
1309: p_defined_balance_id =>l_gross_dtd_def_bal_id);
1310:
1311: END IF;

Line 1342: l_isr_witheld_ctd := pay_balance_pkg.get_value(

1338:
1339: dbg('Get ISR Tax Balance');
1340:
1341: IF l_assignment_act <> 0 THEN
1342: l_isr_witheld_ctd := pay_balance_pkg.get_value(
1343: p_assignment_action_id =>l_assignment_act,
1344: p_defined_balance_id =>l_isr_withheld_ctd_def_bal_id);
1345:
1346: l_isr_subj_ctd := pay_balance_pkg.get_value(

Line 1346: l_isr_subj_ctd := pay_balance_pkg.get_value(

1342: l_isr_witheld_ctd := pay_balance_pkg.get_value(
1343: p_assignment_action_id =>l_assignment_act,
1344: p_defined_balance_id =>l_isr_withheld_ctd_def_bal_id);
1345:
1346: l_isr_subj_ctd := pay_balance_pkg.get_value(
1347: p_assignment_action_id =>l_assignment_act,
1348: p_defined_balance_id =>l_isr_subj_ctd_def_bal_id);
1349: END IF;
1350:

Line 1356: l_isr_witheld_dtd := pay_balance_pkg.get_value(

1352: l_isr_subj_dtd_def_bal_id is not null THEN
1353:
1354: IF l_assignment_act <> 0 THEN
1355:
1356: l_isr_witheld_dtd := pay_balance_pkg.get_value(
1357: p_assignment_action_id =>l_assignment_act,
1358: p_defined_balance_id =>l_isr_withheld_dtd_def_bal_id);
1359:
1360: l_isr_subj_dtd := pay_balance_pkg.get_value(

Line 1360: l_isr_subj_dtd := pay_balance_pkg.get_value(

1356: l_isr_witheld_dtd := pay_balance_pkg.get_value(
1357: p_assignment_action_id =>l_assignment_act,
1358: p_defined_balance_id =>l_isr_withheld_dtd_def_bal_id);
1359:
1360: l_isr_subj_dtd := pay_balance_pkg.get_value(
1361: p_assignment_action_id =>l_assignment_act,
1362: p_defined_balance_id =>l_isr_subj_dtd_def_bal_id);
1363:
1364: END IF;

Line 1423: l_ss_ee_ctd := pay_balance_pkg.get_value(

1419: dbg('l_cnt5' || l_cnt5 );
1420: dbg('Soc Sec Ins Type: '||soc_sec_det_tab(l_cnt5).balance_name);
1421:
1422: IF l_assignment_act <> 0 THEN
1423: l_ss_ee_ctd := pay_balance_pkg.get_value(
1424: p_assignment_action_id =>l_assignment_act,
1425: p_defined_balance_id =>
1426: soc_sec_det_tab(l_cnt5).soc_sec_ee_ctd_id);
1427:

Line 1428: l_ss_er_ctd := pay_balance_pkg.get_value(

1424: p_assignment_action_id =>l_assignment_act,
1425: p_defined_balance_id =>
1426: soc_sec_det_tab(l_cnt5).soc_sec_ee_ctd_id);
1427:
1428: l_ss_er_ctd := pay_balance_pkg.get_value(
1429: p_assignment_action_id =>l_assignment_act,
1430: p_defined_balance_id =>
1431: soc_sec_det_tab(l_cnt5).soc_sec_er_ctd_id);
1432: END IF;

Line 1438: l_ss_ee_dtd := pay_balance_pkg.get_value(

1434: IF p_dimension <> 'CTD' THEN
1435:
1436: IF l_assignment_act <> 0 THEN
1437:
1438: l_ss_ee_dtd := pay_balance_pkg.get_value(
1439: p_assignment_action_id =>l_assignment_act,
1440: p_defined_balance_id =>
1441: soc_sec_det_tab(l_cnt5).soc_sec_ee_dtd_id);
1442: l_ss_er_dtd := pay_balance_pkg.get_value(

Line 1442: l_ss_er_dtd := pay_balance_pkg.get_value(

1438: l_ss_ee_dtd := pay_balance_pkg.get_value(
1439: p_assignment_action_id =>l_assignment_act,
1440: p_defined_balance_id =>
1441: soc_sec_det_tab(l_cnt5).soc_sec_ee_dtd_id);
1442: l_ss_er_dtd := pay_balance_pkg.get_value(
1443: p_assignment_action_id =>l_assignment_act,
1444: p_defined_balance_id =>
1445: soc_sec_det_tab(l_cnt5).soc_sec_er_dtd_id);
1446:

Line 1526: l_st_subj_ctd := pay_balance_pkg.get_value(

1522: IF l_st_withheld_ctd_def_bal_id IS NOT NULL THEN /*7687079*/
1523:
1524: IF l_assignment_act <> 0 THEN
1525:
1526: l_st_subj_ctd := pay_balance_pkg.get_value(
1527: p_assignment_action_id =>l_assignment_act,
1528: p_defined_balance_id =>l_st_subj_ctd_def_bal_id);
1529:
1530: END IF;

Line 1540: l_st_witheld_ctd := pay_balance_pkg.get_value(

1536: IF l_st_withheld_ctd_def_bal_id IS NOT NULL THEN
1537:
1538: IF l_assignment_act <> 0 THEN
1539:
1540: l_st_witheld_ctd := pay_balance_pkg.get_value(
1541: p_assignment_action_id =>l_assignment_act,
1542: p_defined_balance_id =>l_st_withheld_ctd_def_bal_id);
1543:
1544: END IF;

Line 1561: l_st_subj_dtd := pay_balance_pkg.get_value(

1557: l_st_subj_dtd_def_bal_id IS NOT NULL THEN
1558:
1559: IF l_assignment_act <> 0 THEN
1560:
1561: l_st_subj_dtd := pay_balance_pkg.get_value(
1562: p_assignment_action_id =>l_assignment_act,
1563: p_defined_balance_id =>l_st_subj_dtd_def_bal_id);
1564:
1565: END IF;

Line 1571: l_st_witheld_dtd := pay_balance_pkg.get_value(

1567: IF l_state <> 'CHIH' OR l_state <> 'CAMP' THEN /*bug 10236983 */
1568:
1569: IF l_assignment_act <> 0 THEN
1570:
1571: l_st_witheld_dtd := pay_balance_pkg.get_value(
1572: p_assignment_action_id =>l_assignment_act,
1573: p_defined_balance_id =>l_st_withheld_dtd_def_bal_id);
1574:
1575: END IF;

Line 1655: l_st_earn_ctd_value := pay_balance_pkg.get_value(

1651: IF state_earnings(l_cnt50).state_earnings_ctd_id IS NOT NULL THEN
1652:
1653: IF l_assignment_act <> 0 THEN
1654:
1655: l_st_earn_ctd_value := pay_balance_pkg.get_value(
1656: p_assignment_action_id =>l_assignment_act,
1657: p_defined_balance_id =>
1658: state_earnings(l_cnt50).state_earnings_ctd_id);
1659:

Line 1671: l_st_earn_dtd_value := pay_balance_pkg.get_value(

1667: THEN
1668:
1669: IF l_assignment_act <> 0 THEN
1670:
1671: l_st_earn_dtd_value := pay_balance_pkg.get_value(
1672: p_assignment_action_id =>l_assignment_act,
1673: p_defined_balance_id =>
1674: state_earnings(l_cnt50).state_earnings_dtd_id);
1675: