720: IS
721: CURSOR c_line IS
722: SELECT TRX_LINE_ID ,
723: ERROR_MESSAGE||':'||INVALID_VALUE
724: FROM ar_trx_errors_gt
725: WHERE TRX_LINE_ID IS NOT NULL
726: ORDER BY TRX_HEADER_ID, TRX_LINE_ID;
727:
728:
728:
729: CURSOR c_hdr IS
730: SELECT TRX_HEADER_ID ,
731: ERROR_MESSAGE||':'||INVALID_VALUE
732: FROM ar_trx_errors_gt
733: WHERE TRX_LINE_ID IS NULL
734: ORDER BY TRX_HEADER_ID;
735:
736: CURSOR c_nb_inv_in_err IS
734: ORDER BY TRX_HEADER_ID;
735:
736: CURSOR c_nb_inv_in_err IS
737: SELECT count(TRX_HEADER_ID)
738: FROM ar_trx_errors_gt
739: GROUP BY TRX_HEADER_ID;
740:
741:
742: CURSOR c_s IS