929: L_UR_WMEN := L_UR_WMEN + J.URWMEN;
930: L_TOT_MEN := L_TOT_MEN + J.BNHMEN + J.AM_ALMEN + J.A_PMEN + J.HMEN + J.WNHMEN + J.URMEN;
931: L_TOT_WMEN := L_TOT_WMEN + J.BNHWMEN + J.AM_ALWMEN + J.A_PWMEN + J.HWMEN + J.WNHWMEN + J.URWMEN;
932: END LOOP;
933: INSERT INTO PAY_US_RPT_TOTALS
934: (SESSION_ID
935: ,ATTRIBUTE1
936: ,VALUE1
937: ,VALUE2
996: L_UR_MEN := L_UR_MEN + L_TMR_UR_MEN;
997: L_UR_WMEN := L_UR_WMEN + L_TMR_UR_WMEN;
998: L_TOT_MEN := L_TOT_MEN + L_TMR_BNH_MEN + L_TMR_AMAI_MEN + L_TMR_AP_MEN + L_TMR_H_MEN + L_TMR_WNH_MEN + L_TMR_UR_MEN;
999: L_TOT_WMEN := L_TOT_WMEN + L_TMR_BNH_WMEN + L_TMR_AMAI_WMEN + L_TMR_AP_WMEN + L_TMR_H_WMEN + L_TMR_WNH_WMEN + L_TMR_UR_WMEN;
1000: INSERT INTO PAY_US_RPT_TOTALS
1001: (SESSION_ID
1002: ,ATTRIBUTE1
1003: ,ATTRIBUTE2
1004: ,VALUE1
1055: function AfterReport return boolean is
1056: begin
1057: --hr_standard.event('AFTER REPORT');
1058: EXECUTE IMMEDIATE
1059: 'DELETE FROM pay_us_rpt_totals
1060: WHERE attribute1 = ''IPED11''';
1061:
1062: return (TRUE);
1063: end;