743: IS
744: CURSOR c_line IS
745: SELECT TRX_LINE_ID ,
746: ERROR_MESSAGE||':'||INVALID_VALUE
747: FROM ar_trx_errors_gt
748: WHERE TRX_LINE_ID IS NOT NULL
749: ORDER BY TRX_HEADER_ID, TRX_LINE_ID;
750:
751:
751:
752: CURSOR c_hdr IS
753: SELECT TRX_HEADER_ID ,
754: ERROR_MESSAGE||':'||INVALID_VALUE
755: FROM ar_trx_errors_gt
756: WHERE TRX_LINE_ID IS NULL
757: ORDER BY TRX_HEADER_ID;
758:
759: CURSOR c_nb_inv_in_err IS
757: ORDER BY TRX_HEADER_ID;
758:
759: CURSOR c_nb_inv_in_err IS
760: SELECT count(TRX_HEADER_ID)
761: FROM ar_trx_errors_gt
762: GROUP BY TRX_HEADER_ID;
763:
764:
765: CURSOR c_s IS