APPS.FUN_UPDATE_UPGRADED_TRX_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

         update fun_trx_batches
         set from_le_id = p_legal_entity_id
         where from_le_id = -1
         and initiator_id = p_org_id;

Line: 18

         FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of Initiator Batches updated: '|| SQL%ROWCOUNT);

Line: 20

         update fun_trx_headers
         set to_le_id = p_legal_entity_id
         where to_le_id  = -1
         and recipient_id = p_org_id;

Line: 24

         FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of Recipient Transactions updated: '|| SQL%ROWCOUNT);

Line: 31

END UPDATE_UPGRADED_TRX;