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.6.12010000.1 2008/07/27 22:23:31 appldev ship $ */
3: --
4: --
5: /* Setup Glabals */

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

325: --
326: begin
327: --
328: hr_utility.set_location
329: ('Entering: pay_run_balance_build.calculate_delta_asg_balnces', 10);
330: if (g_proc_mode = 'SINGLE') then
331: --
332: -- If we have been supplied with a start date then delete
333: -- any run balance prior to this date.

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

397: end if;
398: end if;
399: --
400: hr_utility.set_location
401: ('Leaving: pay_run_balance_build.calculate_delta_asg_balances', 100);
402: end calculate_delta_asg_balances;
403: --
404: /* Name : calculate_full_asg_balances
405: Purpose :

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

415: begin
416: --
417: --
418: hr_utility.set_location(
419: 'Enter:pay_run_balance_build.calculate_full_asg_balances',10);
420: --
421: if (g_proc_mode = 'SINGLE') then
422: --
423: -- If we have been supplied with a start date then delete

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

423: -- If we have been supplied with a start date then delete
424: -- any run balance prior to this date.
425: --
426: hr_utility.set_location(
427: 'pay_run_balance_build.calculate_full_asg_balances',20);
428: --
429: l_delete_bals := FALSE;
430: if (g_start_date is not null
431: and g_start_date > p_eff_date) then

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

435: if (l_delete_bals) then
436: --
437: --
438: hr_utility.set_location(
439: 'pay_run_balance_build.calculate_full_asg_balances',30);
440:
441: --
442: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
443: from pay_run_balances prb

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

447: else
448: --
449: --
450: hr_utility.set_location(
451: 'pay_run_balance_build.calculate_full_asg_balances',40);
452: --
453: pay_balance_pkg.create_asg_balance(g_def_bal_id
454: ,p_asg_act_id
455: ,'FORCE'

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

459: --
460: else
461: --
462: hr_utility.set_location(
463: 'pay_run_balance_build.calculate_full_asg_balances',50);
464: --
465: -- If we have been supplied with a start date then delete
466: -- any run balance prior to this date.
467: --

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

473: --
474: if (l_delete_bals) then
475: --
476: hr_utility.set_location(
477: 'pay_run_balance_build.calculate_full_asg_balances',60);
478: null;
479: --
480: else
481: --

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

479: --
480: else
481: --
482: hr_utility.set_location(
483: 'pay_run_balance_build.calculate_full_asg_balances',70);
484: --
485: pay_balance_pkg.create_all_asg_balances(p_asg_act_id,
486: g_att_name,
487: 'TRUSTED'

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

490: end if;
491: --
492: --
493: hr_utility.set_location(
494: 'Leaving:pay_run_balance_build.calculate_full_asg_balances',80);
495: --
496: end calculate_full_asg_balances;
497: --
498: /* Name : process_asg_lvl_balances

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

531: l_run_bal_status pay_balance_validation.run_balance_status%type;
532: l_bal_load_date pay_balance_validation.balance_load_date%type;
533: begin
534: --
535: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',10);
536: --
537: l_run_bal_status := 'V';
538: --
539: if (g_proc_mode <> 'SINGLE') then

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

537: l_run_bal_status := 'V';
538: --
539: if (g_proc_mode <> 'SINGLE') then
540: --
541: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
542: --
543: if (g_proc_mode = 'INVALID') then
544: --
545: -- altered delete statement to use pay_balance_attributes rather than

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

589: --
590: end if;
591: else
592: --
593: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',20);
594: --
595: -- No need to delete the balance, but we do need to get the status
596: --
597: begin

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

611: end if;
612: --
613: for aarec in getaa(p_asg_id) loop
614: --
615: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',30);
616: --
617: if (aarec.run_method <> 'C') then
618: --
619: --

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

616: --
617: if (aarec.run_method <> 'C') then
618: --
619: --
620: hr_utility.set_location('pay_run_balance_build.process_asg_lvl_balance',40);
621: --
622: if (g_load_type <> 'DELTA') then
623: --
624: --

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

622: if (g_load_type <> 'DELTA') then
623: --
624: --
625: hr_utility.set_location(
626: 'pay_run_balance_build.process_asg_lvl_balance',50);
627: --
628: calculate_full_asg_balances( aarec.assignment_action_id,
629: aarec.effective_date
630: );

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

632: else
633: --
634: --
635: hr_utility.set_location(
636: 'pay_run_balance_build.process_asg_lvl_balance',60);
637: --
638: if (l_run_bal_status = 'V') then
639: --
640: --

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

638: if (l_run_bal_status = 'V') then
639: --
640: --
641: hr_utility.set_location(
642: 'pay_run_balance_build.process_asg_lvl_balance',70);
643: --
644: calculate_delta_asg_balances( aarec.assignment_action_id,
645: aarec.effective_date,
646: l_bal_load_date

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

653: end loop;
654: --
655: --
656: hr_utility.set_location(
657: 'Leaving:pay_run_balance_build.process_asg_lvl_balance',80);
658: --
659: end process_asg_lvl_balances;
660: --
661: /* Name : calculate_delta_grp_balances

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

681: l_delta varchar2(10);
682: begin
683: --
684: hr_utility.set_location
685: ('Entering: pay_run_balance_build.calculate_delta_grp_balances', 10);
686: --
687: if (g_proc_mode = 'SINGLE') then
688: --
689: -- If we have been supplied with a start date then delete

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

783: );
784: end if;
785: end if;
786: hr_utility.set_location
787: ('Leaving: pay_run_balance_build.calculate_delta_grp_balances', 100);
788: --
789: end calculate_delta_grp_balances;
790: --
791: /* Name : calculate_full_grp_balances

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

1035: l_asg_id pay_assignment_actions.assignment_id%type;
1036: --
1037: BEGIN
1038: hr_utility.set_location(
1039: 'Entering:pay_run_balance_build.action_archive_data',10);
1040: --
1041: select paa.payroll_action_id,
1042: paa.object_id,
1043: paa.assignment_id,

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

1051: set_globals(l_payroll_action_id);
1052: --
1053: --
1054: hr_utility.set_location(
1055: 'pay_run_balance_build.action_archive_data',20);
1056: --
1057: /* Have we timed out */
1058: select sysdate
1059: into current_date

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

1071: if (load_bals) then
1072: --
1073: --
1074: hr_utility.set_location(
1075: 'pay_run_balance_build.action_archive_data',30);
1076: --
1077: if (g_bal_lvl = 'GRP') then
1078: --
1079: --

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

1077: if (g_bal_lvl = 'GRP') then
1078: --
1079: --
1080: hr_utility.set_location(
1081: 'pay_run_balance_build.action_archive_data',40);
1082: --
1083: /* Only do something if the legislation rule is set */
1084: if (g_save_run_bals = 'Y') then
1085: --

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

1084: if (g_save_run_bals = 'Y') then
1085: --
1086: --
1087: hr_utility.set_location(
1088: 'pay_run_balance_build.action_archive_data',50);
1089: --
1090: process_group_lvl_balances(l_object_id);
1091: --
1092: end if;

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

1093: else
1094: --
1095: --
1096: hr_utility.set_location(
1097: 'pay_run_balance_build.action_archive_data',60);
1098: --
1099: /* Only do something if the legislation rule is set */
1100: if (g_save_asg_run_bals = 'Y') then
1101: --

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

1100: if (g_save_asg_run_bals = 'Y') then
1101: --
1102: --
1103: hr_utility.set_location(
1104: 'pay_run_balance_build.action_archive_data',70);
1105: --
1106: process_asg_lvl_balances(l_asg_id,
1107: l_bus_grp);
1108: --

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

1110: end if;
1111: --
1112: --
1113: hr_utility.set_location(
1114: 'pay_run_balance_build.action_archive_data',80);
1115: --
1116: end if;
1117: --
1118: --

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

1116: end if;
1117: --
1118: --
1119: hr_utility.set_location(
1120: 'Leaving:pay_run_balance_build.action_archive_data',90);
1121: --
1122: END action_archive_data;
1123:
1124:

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

1511: begin
1512: --
1513: set_globals(pactid);
1514: --
1515: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);
1516: /* only do something if the legislation rule is set */
1517: if (g_save_run_bals = 'Y') then
1518: /* do we need to load assignment balances */
1519: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);

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

1515: hr_utility.set_location('pay_run_balance_build.deinitialise', 10);
1516: /* only do something if the legislation rule is set */
1517: if (g_save_run_bals = 'Y') then
1518: /* do we need to load assignment balances */
1519: hr_utility.set_location('pay_run_balance_build.deinitialise', 20);
1520: load_bals := TRUE;
1521: if (g_proc_mode = 'SINGLE') then
1522: load_bals := FALSE;
1523: elsif (g_bal_lvl = 'GRP') then

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

1526: --
1527: cnt := 0;
1528: if (load_bals) then
1529: --
1530: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);
1531: --
1532: if (g_bal_lvl = 'BOTH') then
1533: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1534: for parec in getpa(pactid) loop

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

1529: --
1530: hr_utility.set_location('pay_run_balance_build.deinitialise', 30);
1531: --
1532: if (g_bal_lvl = 'BOTH') then
1533: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1534: for parec in getpa(pactid) loop
1535: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);
1536: --
1537: process_group_lvl_balances(parec.payroll_action_id);

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

1531: --
1532: if (g_bal_lvl = 'BOTH') then
1533: hr_utility.set_location('pay_run_balance_build.deinitialise', 40);
1534: for parec in getpa(pactid) loop
1535: hr_utility.set_location('pay_run_balance_build.deinitialise', 50);
1536: --
1537: process_group_lvl_balances(parec.payroll_action_id);
1538: --
1539: end loop;

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

1541: --
1542: end if;
1543: end if;
1544: --
1545: hr_utility.set_location('pay_run_balance_build.deinitialise', 60);
1546: --
1547: /* Remove the actions if needed */
1548: select count(*)
1549: into act_com

Line 1585: end pay_run_balance_build;

1581: end deinitialise;
1582: --
1583: begin
1584: g_globals_set := FALSE;
1585: end pay_run_balance_build;