DELETE AR INVOICE API EBS R12
DECLARE CURSOR cur_all_trx IS SELECT ROWID, NULL PARTY_NUMBER, RCT.ORG_ID, RCT.CUSTOMER_TRX_ID, RCT.TRX_NUMBER FROM XX_DELETE_TRANSACTION RCT WHERE NVL (V_RET_STATUS, 0) <> 'S' AND TRX_NUMBER = 'inv'; xv_msg_data VARCHAR2 (4000) := NULL; xv_msg_count NUMBER := 0; v_msg_index NUMBER := 0; xv_ret_status VARCHAR2 (1) := NULL; v_message_tbl arp_trx_validate.message_tbl_type; v_res VARCHAR2 (4000) := NULL; v_res_na...