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_RUN_BALANCE_BUILD dependencies on PAY_RUN_BALANCE_BUILD

Line 1: PACKAGE BODY pay_run_balance_build AS

1: PACKAGE BODY pay_run_balance_build AS
2: /* $Header: pycorubl.pkb 120.9.12020000.7 2013/01/25 11:06:33 asnell ship $ */
3: --
4: --
5: /* Setup Glabals */

Line 406: ('Entering: pay_run_balance_build.calculate_delta_asg_balnces', 10);

402: --
403: begin
404: --
405: hr_utility.set_location
406: ('Entering: pay_run_balance_build.calculate_delta_asg_balnces', 10);
407: if (g_proc_mode = 'SINGLE') then
408: l_rb_row_status := 'U';
409: --
410:

Line 488: ('Leaving: pay_run_balance_build.calculate_delta_asg_balances', 100);

484: end if;
485: end if;
486: --
487: hr_utility.set_location
488: ('Leaving: pay_run_balance_build.calculate_delta_asg_balances', 100);
489: end calculate_delta_asg_balances;
490: --
491: /* Name : calculate_full_asg_balances
492: Purpose :

Line 510: 'Enter:pay_run_balance_build.calculate_full_asg_balances',10);

506: begin
507: --
508: --
509: hr_utility.set_location(
510: 'Enter:pay_run_balance_build.calculate_full_asg_balances',10);
511: l_rb_row_status := 'U';
512: --
513: if (g_proc_mode = 'SINGLE') then
514: if g_def_bal_id is not null then

Line 524: 'pay_run_balance_build.calculate_full_asg_balances',20);

520: -- If we have been supplied with a start date then delete
521: -- any run balance prior to this date.
522: --
523: hr_utility.set_location(
524: 'pay_run_balance_build.calculate_full_asg_balances',20);
525: --
526: l_delete_bals := FALSE;
527: if (g_start_date is not null
528: and g_start_date > p_eff_date) then

Line 536: 'pay_run_balance_build.calculate_full_asg_balances',30);

532: if (l_delete_bals) then
533: --
534: --
535: hr_utility.set_location(
536: 'pay_run_balance_build.calculate_full_asg_balances',30);
537: -- bug 11874880 reduce number of deletes by checking runbal row status
538: if (l_rb_row_status in ('I','U','O')) then
539: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
540: from pay_run_balances prb

Line 550: 'pay_run_balance_build.calculate_full_asg_balances',40);

546: if not(l_delete_bals) then
547: --
548: --
549: hr_utility.set_location(
550: 'pay_run_balance_build.calculate_full_asg_balances',40);
551: --
552: if l_rb_row_status in ( 'I', 'U','M' ) then
553: pay_balance_pkg.create_asg_balance(g_def_bal_id
554: ,p_asg_act_id

Line 564: 'pay_run_balance_build.calculate_full_asg_balances',50);

560: --
561: else
562: --
563: hr_utility.set_location(
564: 'pay_run_balance_build.calculate_full_asg_balances',50);
565: --
566: -- If we have been supplied with a start date then delete
567: -- any run balance prior to this date.
568: --

Line 578: 'pay_run_balance_build.calculate_full_asg_balances',60);

574: --
575: if (l_delete_bals) then
576: --
577: hr_utility.set_location(
578: 'pay_run_balance_build.calculate_full_asg_balances',60);
579: null;
580: --
581: else
582: --

Line 584: 'pay_run_balance_build.calculate_full_asg_balances',70);

580: --
581: else
582: --
583: hr_utility.set_location(
584: 'pay_run_balance_build.calculate_full_asg_balances',70);
585: --
586: pay_balance_pkg.create_all_asg_balances(p_asg_act_id,
587: g_att_name,
588: 'TRUSTED'

Line 595: 'Leaving:pay_run_balance_build.calculate_full_asg_balances',80);

591: end if;
592: --
593: --
594: hr_utility.set_location(
595: 'Leaving:pay_run_balance_build.calculate_full_asg_balances',80);
596: --
597: end calculate_full_asg_balances;
598: --
599: /* Name : process_asg_lvl_balances

Line 645: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',10);

641: l_rb_row_status varchar2(1);
642:
643: begin
644: --
645: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',10);
646: --
647: l_run_bal_status := 'U';
648: --
649: if (g_proc_mode <> 'SINGLE') then

Line 651: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);

647: l_run_bal_status := 'U';
648: --
649: if (g_proc_mode <> 'SINGLE') then
650: --
651: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
652: --
653: if (g_proc_mode = 'INVALID') then
654: --
655: -- altered delete statement to use pay_balance_attributes rather than

Line 740: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);

736: --
737: end if;
738: else
739: --
740: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
741: --
742: -- No need to delete the balance, but we do need to get the status
743: --
744: begin

Line 765: hr_utility.trace('pay_run_balance_build.process_asg_lvl_balance delete rb rows before load date:' ||SQL%ROWCOUNT);

761: delete from pay_run_balances where assignment_id = p_asg_id and
762: effective_date < l_bal_load_date
763: and defined_balance_id = g_def_bal_id;
764: if g_debug then
765: hr_utility.trace('pay_run_balance_build.process_asg_lvl_balance delete rb rows before load date:' ||SQL%ROWCOUNT);
766: end if;
767:
768:
769: if not g_purge_only then -- bug 11874880 adjust balance load date

Line 781: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',30);

777: If lt_tab_getaa.count > 0 then
778:
779: for aarec in lt_tab_getaa.first..lt_tab_getaa.last loop
780: --
781: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',30);
782: --
783: if (lt_tab_getaa(aarec).run_method <> 'C') then
784: --
785: --

Line 786: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',40);

782: --
783: if (lt_tab_getaa(aarec).run_method <> 'C') then
784: --
785: --
786: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',40);
787: --
788: if (g_load_type <> 'DELTA') then
789: --
790: --

Line 792: 'pay_run_balance_build.process_asg_lvl_balance',50);

788: if (g_load_type <> 'DELTA') then
789: --
790: --
791: hr_utility.set_location(
792: 'pay_run_balance_build.process_asg_lvl_balance',50);
793: if g_def_bal_id is not null then
794: l_rb_row_status := pay_balance_pkg.run_balance_row_status(g_def_bal_id, p_asg_id,
795: lt_tab_getaa(aarec).assignment_action_id,
796: lt_tab_getaa(aarec).business_group_id,

Line 814: 'pay_run_balance_build.process_asg_lvl_balance',60);

810: else
811: --
812: --
813: hr_utility.set_location(
814: 'pay_run_balance_build.process_asg_lvl_balance',60);
815: --
816: if (l_run_bal_status = 'V') then
817: --
818: --

Line 820: 'pay_run_balance_build.process_asg_lvl_balance',70);

816: if (l_run_bal_status = 'V') then
817: --
818: --
819: hr_utility.set_location(
820: 'pay_run_balance_build.process_asg_lvl_balance',70);
821: --
822: calculate_delta_asg_balances( p_asg_id,
823: lt_tab_getaa(aarec).assignment_action_id,
824: lt_tab_getaa(aarec).business_group_id,

Line 843: 'Leaving:pay_run_balance_build.process_asg_lvl_balance',80);

839: lt_tab_getaa.delete;
840:
841: end if;
842: hr_utility.set_location(
843: 'Leaving:pay_run_balance_build.process_asg_lvl_balance',80);
844: --
845: end process_asg_lvl_balances;
846: --
847: /* Name : calculate_delta_grp_balances

Line 871: ('Entering: pay_run_balance_build.calculate_delta_grp_balances', 10);

867: l_delta varchar2(10);
868: begin
869: --
870: hr_utility.set_location
871: ('Entering: pay_run_balance_build.calculate_delta_grp_balances', 10);
872: --
873: if (g_proc_mode = 'SINGLE') then
874: --
875: -- If we have been supplied with a start date then delete

Line 975: ('Leaving: pay_run_balance_build.calculate_delta_grp_balances', 100);

971: end if;
972: end if;
973: end if;
974: hr_utility.set_location
975: ('Leaving: pay_run_balance_build.calculate_delta_grp_balances', 100);
976: --
977: end calculate_delta_grp_balances;
978: --
979: /* Name : calculate_full_grp_balances

Line 993: hr_utility.set_location ('Entering: pay_run_balance_build.calculate_full_grp_balances', 10);

989: is
990: l_delete_bals boolean;
991: begin
992: if g_debug then
993: hr_utility.set_location ('Entering: pay_run_balance_build.calculate_full_grp_balances', 10);
994: hr_utility.trace('p_eff_date:'||p_eff_date||' g_start_date:'||g_start_date);
995: end if;
996: if (g_proc_mode = 'SINGLE') then
997: --

Line 1070: hr_utility.set_location ('Leaving: pay_run_balance_build.calculate_full_grp_balances', 90);

1066: end if;
1067: end if;
1068: end if;
1069: if g_debug then
1070: hr_utility.set_location ('Leaving: pay_run_balance_build.calculate_full_grp_balances', 90);
1071: end if;
1072: --
1073: end calculate_full_grp_balances;
1074: --

Line 1092: hr_utility.set_location ('Entering: pay_run_balance_build.process_group_lvl_balances', 10);

1088: l_del_cnt number;
1089: begin
1090: --
1091: if g_debug then
1092: hr_utility.set_location ('Entering: pay_run_balance_build.process_group_lvl_balances', 10);
1093: end if;
1094: begin
1095: select ppa.effective_date,
1096: ppa.business_group_id,

Line 1235: hr_utility.set_location ('Leaving: pay_run_balance_build.process_group_lvl_balances', 90);

1231: end if;
1232: --
1233: end if;
1234: if g_debug then
1235: hr_utility.set_location ('Leaving: pay_run_balance_build.process_group_lvl_balances', 90);
1236: end if;
1237: --
1238: end process_group_lvl_balances;
1239: --

Line 1283: 'Entering:pay_run_balance_build.action_archive_data',10);

1279: l_chunk_number pay_assignment_actions.chunk_number%type;
1280: --
1281: BEGIN
1282: hr_utility.set_location(
1283: 'Entering:pay_run_balance_build.action_archive_data',10);
1284: --
1285: select paa.payroll_action_id,
1286: paa.object_id,
1287: paa.assignment_id,

Line 1300: 'pay_run_balance_build.action_archive_data',20);

1296: set_globals(l_payroll_action_id);
1297: --
1298: --
1299: hr_utility.set_location(
1300: 'pay_run_balance_build.action_archive_data',20);
1301: --
1302: /* Have we timed out */
1303: select sysdate
1304: into current_date

Line 1320: 'pay_run_balance_build.action_archive_data',30);

1316: if (load_bals) then
1317: --
1318: --
1319: hr_utility.set_location(
1320: 'pay_run_balance_build.action_archive_data',30);
1321: --
1322: if (g_bal_lvl = 'GRP') then
1323: --
1324: --

Line 1326: 'pay_run_balance_build.action_archive_data',40);

1322: if (g_bal_lvl = 'GRP') then
1323: --
1324: --
1325: hr_utility.set_location(
1326: 'pay_run_balance_build.action_archive_data',40);
1327: --
1328: /* Only do something if the legislation rule is set */
1329: if (g_save_run_bals = 'Y') then
1330: --

Line 1333: 'pay_run_balance_build.action_archive_data',50);

1329: if (g_save_run_bals = 'Y') then
1330: --
1331: --
1332: hr_utility.set_location(
1333: 'pay_run_balance_build.action_archive_data',50);
1334: --
1335: process_group_lvl_balances(l_object_id);
1336: --
1337: end if;

Line 1342: 'pay_run_balance_build.action_archive_data',60);

1338: else
1339: --
1340: --
1341: hr_utility.set_location(
1342: 'pay_run_balance_build.action_archive_data',60);
1343: --
1344: /* Only do something if the legislation rule is set */
1345: if (g_save_asg_run_bals = 'Y') then
1346: --

Line 1349: 'pay_run_balance_build.action_archive_data',70);

1345: if (g_save_asg_run_bals = 'Y') then
1346: --
1347: --
1348: hr_utility.set_location(
1349: 'pay_run_balance_build.action_archive_data',70);
1350: --
1351: process_asg_lvl_balances(l_asg_id,
1352: l_bus_grp, l_chunk_number);
1353: --

Line 1359: 'pay_run_balance_build.action_archive_data',80);

1355: end if;
1356: --
1357: --
1358: hr_utility.set_location(
1359: 'pay_run_balance_build.action_archive_data',80);
1360: --
1361: end if;
1362: --
1363: --

Line 1365: 'Leaving:pay_run_balance_build.action_archive_data',90);

1361: end if;
1362: --
1363: --
1364: hr_utility.set_location(
1365: 'Leaving:pay_run_balance_build.action_archive_data',90);
1366: --
1367: END action_archive_data;
1368:
1369:

Line 1954: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);

1950: begin
1951: --
1952: set_globals(pactid);
1953: --
1954: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);
1955: /* only do something if the legislation rule is set */
1956: if (g_save_run_bals = 'Y') then
1957: /* do we need to load assignment balances */
1958: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);

Line 1958: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);

1954: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);
1955: /* only do something if the legislation rule is set */
1956: if (g_save_run_bals = 'Y') then
1957: /* do we need to load assignment balances */
1958: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);
1959: load_bals := TRUE;
1960: if (g_proc_mode = 'SINGLE') then
1961: load_bals := FALSE;
1962: elsif (g_bal_lvl = 'GRP') then

Line 1969: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);

1965: --
1966: cnt := 0;
1967: if (load_bals) then
1968: --
1969: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);
1970: --
1971: if (g_bal_lvl = 'BOTH') then
1972: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1973: for parec in getpa(pactid) loop

Line 1972: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);

1968: --
1969: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);
1970: --
1971: if (g_bal_lvl = 'BOTH') then
1972: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1973: for parec in getpa(pactid) loop
1974: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);
1975: --
1976: process_group_lvl_balances(parec.payroll_action_id);

Line 1974: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);

1970: --
1971: if (g_bal_lvl = 'BOTH') then
1972: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1973: for parec in getpa(pactid) loop
1974: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);
1975: --
1976: process_group_lvl_balances(parec.payroll_action_id);
1977: --
1978: end loop;

Line 1984: hr_utility.set_location('pay_run_balance_build.deinitialise', 60);

1980: --
1981: end if;
1982: end if;
1983: --
1984: hr_utility.set_location('pay_run_balance_build.deinitialise', 60);
1985: --
1986: /* Remove the actions if needed */
1987: select count(*)
1988: into act_com

Line 2025: end pay_run_balance_build;

2021: --
2022: begin
2023: g_globals_set := FALSE;
2024: g_att_cached := FALSE; /*Bug 9315998*/
2025: end pay_run_balance_build;