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

Line 600: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;

596: p_assct_id in pay_assignment_actions.assignment_action_id%type,
597: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
598: p_person_counter in number )
599: is
600: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
601: l_context_tab pay_balance_pkg.t_context_tab;
602: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
603:
604: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

Line 601: l_context_tab pay_balance_pkg.t_context_tab;

597: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
598: p_person_counter in number )
599: is
600: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
601: l_context_tab pay_balance_pkg.t_context_tab;
602: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
603:
604: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
605: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 602: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

598: p_person_counter in number )
599: is
600: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
601: l_context_tab pay_balance_pkg.t_context_tab;
602: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
603:
604: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
605: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
606:

Line 604: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

600: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
601: l_context_tab pay_balance_pkg.t_context_tab;
602: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
603:
604: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
605: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
606:
607: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
608: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 605: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

601: l_context_tab pay_balance_pkg.t_context_tab;
602: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
603:
604: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
605: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
606:
607: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
608: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
609:

Line 607: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

603:
604: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
605: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
606:
607: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
608: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
609:
610: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
611: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

Line 608: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

604: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
605: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
606:
607: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
608: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
609:
610: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
611: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
612:

Line 610: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

606:
607: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
608: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
609:
610: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
611: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
612:
613: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
614: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

Line 611: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

607: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
608: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
609:
610: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
611: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
612:
613: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
614: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
615:

Line 613: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

609:
610: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
611: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
612:
613: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
614: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
615:
616: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
617: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;

Line 614: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

610: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
611: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
612:
613: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
614: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
615:
616: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
617: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
618:

Line 616: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;

612:
613: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
614: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
615:
616: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
617: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
618:
619: l_ytd_a8a_counter number;
620: --

Line 617: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;

613: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
614: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
615:
616: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
617: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
618:
619: l_ytd_a8a_counter number;
620: --
621: cursor ytd_A8A_balances is

Line 789: pay_balance_pkg.get_value( p_assct_id,

785: end loop;
786:
787: --
788: if p_assct_id is not null then
789: pay_balance_pkg.get_value( p_assct_id,
790: l_balance_value_tab1,
791: l_context_tab,
792: false,
793: false,

Line 795: pay_balance_pkg.get_value( p_assct_id,

791: l_context_tab,
792: false,
793: false,
794: l_detailed_bal_out_tab1);
795: pay_balance_pkg.get_value( p_assct_id,
796: l_balance_value_tab2,
797: l_context_tab,
798: false,
799: false,

Line 801: pay_balance_pkg.get_value( p_assct_id,

797: l_context_tab,
798: false,
799: false,
800: l_detailed_bal_out_tab2);
801: pay_balance_pkg.get_value( p_assct_id,
802: l_balance_value_tab3,
803: l_context_tab,
804: false,
805: false,

Line 807: pay_balance_pkg.get_value( p_assct_id,

803: l_context_tab,
804: false,
805: false,
806: l_detailed_bal_out_tab3);
807: pay_balance_pkg.get_value( p_assct_id,
808: l_balance_value_tab4,
809: l_context_tab,
810: false,
811: false,

Line 813: pay_balance_pkg.get_value( p_assct_id,

809: l_context_tab,
810: false,
811: false,
812: l_detailed_bal_out_tab4);
813: pay_balance_pkg.get_value( p_assct_id,
814: l_balance_value_tab5,
815: l_context_tab,
816: false,
817: false,

Line 1064: -- that to pay_balance_pkg.

1060: ---------------------------------------------------------------------------
1061: -- Selects data required to archive the YTD and Month balances. The
1062: -- cursors' main purpose is to select the latest action sequence for the
1063: -- PERSON (independent of assignment) within the Legal Entity, and pass
1064: -- that to pay_balance_pkg.
1065: -- Also the User Entity Name must match up to the balance.
1066: --
1067: -- YTD Balances: All IRAS balances + specific previously seeded balances
1068: -- Month Balances: Specific balances required for IR8S as this breaks down

Line 1240: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1236: mtd_balance_rec mtd_balance_tab;
1237: ---------------------------------------------------------------------------------------------------
1238: -- Bug 3064282 Batch Balance fetch implemented
1239: ---------------------------------------------------------------------------------------------------
1240: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1241: g_context_tab pay_balance_pkg.t_context_tab;
1242: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1243:
1244: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

Line 1241: g_context_tab pay_balance_pkg.t_context_tab;

1237: ---------------------------------------------------------------------------------------------------
1238: -- Bug 3064282 Batch Balance fetch implemented
1239: ---------------------------------------------------------------------------------------------------
1240: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1241: g_context_tab pay_balance_pkg.t_context_tab;
1242: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1243:
1244: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1245: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1242: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

1238: -- Bug 3064282 Batch Balance fetch implemented
1239: ---------------------------------------------------------------------------------------------------
1240: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1241: g_context_tab pay_balance_pkg.t_context_tab;
1242: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1243:
1244: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1245: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1246:

Line 1244: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1240: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1241: g_context_tab pay_balance_pkg.t_context_tab;
1242: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1243:
1244: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1245: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1246:
1247: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1245: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

1241: g_context_tab pay_balance_pkg.t_context_tab;
1242: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1243:
1244: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1245: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1246:
1247: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1249: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

Line 1247: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

1243:
1244: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1245: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1246:
1247: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1249: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1250: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1251: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

Line 1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

1244: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1245: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1246:
1247: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1249: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1250: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1251: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1252: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1249: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

1245: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1246:
1247: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1249: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1250: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1251: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1252: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1253: ---------------------------------------------------------------------------------------------------

Line 1250: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

1246:
1247: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1249: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1250: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1251: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1252: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1253: ---------------------------------------------------------------------------------------------------
1254: -- Type to store the person ids with same national_identifier (Bug 2649107)

Line 1251: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

1247: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1249: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1250: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1251: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1252: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1253: ---------------------------------------------------------------------------------------------------
1254: -- Type to store the person ids with same national_identifier (Bug 2649107)
1255: ---------------------------------------------------------------------------------------------------

Line 1252: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

1248: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1249: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1250: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1251: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1252: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1253: ---------------------------------------------------------------------------------------------------
1254: -- Type to store the person ids with same national_identifier (Bug 2649107)
1255: ---------------------------------------------------------------------------------------------------
1256: type person_id_store_rec is record

Line 1405: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value

1401: g_balance_value_tab(counter).defined_balance_id := t_month_balanceid_store(counter).defined_balance_id;
1402: g_context_tab(counter).tax_unit_id := month_year_action_rec.tax_uid;
1403: end loop;
1404: ----------------------------------------------------------------------------------
1405: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1406: ----------------------------------------------------------------------------------
1407: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1408: g_balance_value_tab,
1409: g_context_tab,

Line 1407: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

1403: end loop;
1404: ----------------------------------------------------------------------------------
1405: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1406: ----------------------------------------------------------------------------------
1407: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1408: g_balance_value_tab,
1409: g_context_tab,
1410: false,
1411: false,

Line 1461: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value

1457: g_context_tab(counter).tax_unit_id := month_year_action_rec.tax_uid;
1458: end loop;
1459:
1460: ----------------------------------------------------------------------------------
1461: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1462: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1463: ----------------------------------------------------------------------------------
1464: if month_year_action_rec.assact_id is not null then
1465: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

Line 1462: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.

1458: end loop;
1459:
1460: ----------------------------------------------------------------------------------
1461: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1462: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1463: ----------------------------------------------------------------------------------
1464: if month_year_action_rec.assact_id is not null then
1465: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1466: g_balance_value_tab,

Line 1465: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

1461: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1462: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1463: ----------------------------------------------------------------------------------
1464: if month_year_action_rec.assact_id is not null then
1465: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1466: g_balance_value_tab,
1467: g_context_tab,
1468: false,
1469: false,