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

Line 398: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;

394: p_assct_id in pay_assignment_actions.assignment_action_id%type,
395: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
396: p_person_counter in number )
397: is
398: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
399: l_context_tab pay_balance_pkg.t_context_tab;
400: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
401:
402: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

Line 399: l_context_tab pay_balance_pkg.t_context_tab;

395: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
396: p_person_counter in number )
397: is
398: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
399: l_context_tab pay_balance_pkg.t_context_tab;
400: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
401:
402: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
403: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 400: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

396: p_person_counter in number )
397: is
398: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
399: l_context_tab pay_balance_pkg.t_context_tab;
400: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
401:
402: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
403: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
404:

Line 402: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

398: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
399: l_context_tab pay_balance_pkg.t_context_tab;
400: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
401:
402: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
403: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
404:
405: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
406: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 403: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

399: l_context_tab pay_balance_pkg.t_context_tab;
400: l_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
401:
402: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
403: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
404:
405: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
406: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
407:

Line 405: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

401:
402: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
403: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
404:
405: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
406: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
407:
408: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
409: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

Line 406: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

402: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
403: l_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
404:
405: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
406: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
407:
408: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
409: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
410:

Line 408: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

404:
405: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
406: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
407:
408: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
409: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
410:
411: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
412: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

Line 409: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

405: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
406: l_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
407:
408: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
409: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
410:
411: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
412: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
413:

Line 411: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

407:
408: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
409: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
410:
411: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
412: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
413:
414: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
415: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;

Line 412: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

408: l_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
409: l_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
410:
411: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
412: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
413:
414: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
415: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
416:

Line 414: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;

410:
411: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
412: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
413:
414: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
415: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
416:
417: l_ytd_a8a_counter number;
418: --

Line 415: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;

411: l_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
412: l_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
413:
414: l_balance_value_tab5 pay_balance_pkg.t_balance_value_tab;
415: l_detailed_bal_out_tab5 pay_balance_pkg.t_detailed_bal_out_tab;
416:
417: l_ytd_a8a_counter number;
418: --
419: cursor ytd_A8A_balances is

Line 584: pay_balance_pkg.get_value( p_assct_id,

580: end loop;
581:
582: --
583: if p_assct_id is not null then
584: pay_balance_pkg.get_value( p_assct_id,
585: l_balance_value_tab1,
586: l_context_tab,
587: false,
588: false,

Line 590: pay_balance_pkg.get_value( p_assct_id,

586: l_context_tab,
587: false,
588: false,
589: l_detailed_bal_out_tab1);
590: pay_balance_pkg.get_value( p_assct_id,
591: l_balance_value_tab2,
592: l_context_tab,
593: false,
594: false,

Line 596: pay_balance_pkg.get_value( p_assct_id,

592: l_context_tab,
593: false,
594: false,
595: l_detailed_bal_out_tab2);
596: pay_balance_pkg.get_value( p_assct_id,
597: l_balance_value_tab3,
598: l_context_tab,
599: false,
600: false,

Line 602: pay_balance_pkg.get_value( p_assct_id,

598: l_context_tab,
599: false,
600: false,
601: l_detailed_bal_out_tab3);
602: pay_balance_pkg.get_value( p_assct_id,
603: l_balance_value_tab4,
604: l_context_tab,
605: false,
606: false,

Line 608: pay_balance_pkg.get_value( p_assct_id,

604: l_context_tab,
605: false,
606: false,
607: l_detailed_bal_out_tab4);
608: pay_balance_pkg.get_value( p_assct_id,
609: l_balance_value_tab5,
610: l_context_tab,
611: false,
612: false,

Line 854: -- that to pay_balance_pkg.

850: ---------------------------------------------------------------------------
851: -- Selects data required to archive the YTD and Month balances. The
852: -- cursors' main purpose is to select the latest action sequence for the
853: -- PERSON (independent of assignment) within the Legal Entity, and pass
854: -- that to pay_balance_pkg.
855: -- Also the User Entity Name must match up to the balance.
856: --
857: -- YTD Balances: All IRAS balances + specific previously seeded balances
858: -- Month Balances: Specific balances required for IR8S as this breaks down

Line 1071: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1067: mtd_balance_rec mtd_balance_tab;
1068: ---------------------------------------------------------------------------------------------------
1069: -- Bug 3064282 Batch Balance fetch implemented
1070: ---------------------------------------------------------------------------------------------------
1071: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1072: g_context_tab pay_balance_pkg.t_context_tab;
1073: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1074:
1075: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

Line 1072: g_context_tab pay_balance_pkg.t_context_tab;

1068: ---------------------------------------------------------------------------------------------------
1069: -- Bug 3064282 Batch Balance fetch implemented
1070: ---------------------------------------------------------------------------------------------------
1071: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1072: g_context_tab pay_balance_pkg.t_context_tab;
1073: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1074:
1075: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1076: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1073: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;

1069: -- Bug 3064282 Batch Balance fetch implemented
1070: ---------------------------------------------------------------------------------------------------
1071: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1072: g_context_tab pay_balance_pkg.t_context_tab;
1073: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1074:
1075: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1076: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1077:

Line 1075: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1071: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1072: g_context_tab pay_balance_pkg.t_context_tab;
1073: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1074:
1075: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1076: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1077:
1078: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1076: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;

1072: g_context_tab pay_balance_pkg.t_context_tab;
1073: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
1074:
1075: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1076: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1077:
1078: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1080: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

Line 1078: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

1074:
1075: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1076: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1077:
1078: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1080: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1081: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1082: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

Line 1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;

1075: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1076: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1077:
1078: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1080: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1081: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1082: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1083: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1080: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;

1076: g_detailed_bal_out_tab1 pay_balance_pkg.t_detailed_bal_out_tab;
1077:
1078: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1080: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1081: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1082: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1083: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1084: ---------------------------------------------------------------------------------------------------

Line 1081: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;

1077:
1078: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1080: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1081: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1082: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1083: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1084: ---------------------------------------------------------------------------------------------------
1085: -- Type to store the person ids with same national_identifier (Bug 2649107)

Line 1082: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;

1078: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1080: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1081: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1082: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1083: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1084: ---------------------------------------------------------------------------------------------------
1085: -- Type to store the person ids with same national_identifier (Bug 2649107)
1086: ---------------------------------------------------------------------------------------------------

Line 1083: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;

1079: g_detailed_bal_out_tab2 pay_balance_pkg.t_detailed_bal_out_tab;
1080: g_balance_value_tab3 pay_balance_pkg.t_balance_value_tab;
1081: g_detailed_bal_out_tab3 pay_balance_pkg.t_detailed_bal_out_tab;
1082: g_balance_value_tab4 pay_balance_pkg.t_balance_value_tab;
1083: g_detailed_bal_out_tab4 pay_balance_pkg.t_detailed_bal_out_tab;
1084: ---------------------------------------------------------------------------------------------------
1085: -- Type to store the person ids with same national_identifier (Bug 2649107)
1086: ---------------------------------------------------------------------------------------------------
1087: type person_id_store_rec is record

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

1253: g_balance_value_tab(counter).defined_balance_id := t_month_balanceid_store(counter).defined_balance_id;
1254: g_context_tab(counter).tax_unit_id := month_year_action_rec.tax_uid;
1255: end loop;
1256: ----------------------------------------------------------------------------------
1257: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1258: ----------------------------------------------------------------------------------
1259: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1260: g_balance_value_tab,
1261: g_context_tab,

Line 1259: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

1255: end loop;
1256: ----------------------------------------------------------------------------------
1257: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1258: ----------------------------------------------------------------------------------
1259: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1260: g_balance_value_tab,
1261: g_context_tab,
1262: false,
1263: false,

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

1311: g_context_tab(counter).tax_unit_id := month_year_action_rec.tax_uid;
1312: end loop;
1313: hr_utility.set_location('pysgiraa: archive_balances ',1190);
1314: ----------------------------------------------------------------------------------
1315: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1316: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1317: ----------------------------------------------------------------------------------
1318: if month_year_action_rec.assact_id is not null then
1319: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

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

1312: end loop;
1313: hr_utility.set_location('pysgiraa: archive_balances ',1190);
1314: ----------------------------------------------------------------------------------
1315: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1316: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1317: ----------------------------------------------------------------------------------
1318: if month_year_action_rec.assact_id is not null then
1319: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1320: g_balance_value_tab,

Line 1319: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

1315: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1316: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1317: ----------------------------------------------------------------------------------
1318: if month_year_action_rec.assact_id is not null then
1319: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1320: g_balance_value_tab,
1321: g_context_tab,
1322: false,
1323: false,

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

1358: g_context_tab(counter).tax_unit_id := month_year_action_rec.tax_uid;
1359: end loop;
1360:
1361: ----------------------------------------------------------------------------------
1362: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1363: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1364: ----------------------------------------------------------------------------------
1365: if month_year_action_rec.assact_id is not null then
1366: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

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

1359: end loop;
1360:
1361: ----------------------------------------------------------------------------------
1362: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1363: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1364: ----------------------------------------------------------------------------------
1365: if month_year_action_rec.assact_id is not null then
1366: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1367: g_balance_value_tab,

Line 1366: pay_balance_pkg.get_value( month_year_action_rec.assact_id,

1362: -- Bug 3223822 - Modified call to the function pay_balance_pkg.get_value
1363: -- Bug 3430277 - Put a condition before function pay_balance_pkg.get_value call.
1364: ----------------------------------------------------------------------------------
1365: if month_year_action_rec.assact_id is not null then
1366: pay_balance_pkg.get_value( month_year_action_rec.assact_id,
1367: g_balance_value_tab,
1368: g_context_tab,
1369: false,
1370: false,