8:
9: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
10: L_BUFFER VARCHAR2(400);
11: G_DELIMITER VARCHAR2(1) := ',';
12: G_EOL VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
13: temp boolean;
14: BEGIN
15:
16: --HR_STANDARD.EVENT('BEFORE REPORT');
407: AND HLEI2.INFORMATION_TYPE = 'Establishment Information'
408: AND HLEI2.LEI_INFORMATION_CATEGORY = 'Establishment Information' );
409: L_BUFFER VARCHAR2(2000);
410: G_DELIMITER VARCHAR2(1) := ',';
411: G_EOL VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
412: BEGIN
413: IF P_AUDIT_REPORT = 'Y' THEN
414: FOR per IN C_PERSONS LOOP
415: L_BUFFER := PER.PERSON_ID || G_DELIMITER || PER.LAST_NAME || G_DELIMITER || NVL(PER.FIRST_NAME