APPS.IES_TRANSACTION_UTIL_PUB SQL Statements

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

Line: 20

   SELECT status
     FROM ies_transactions
    WHERE transaction_id = :1' using  p_transaction_id;

Line: 30

PROCEDURE update_status_to_completed
(
   p_api_version                    IN     NUMBER,
   p_init_msg_list                  IN     VARCHAR2        := FND_API.G_FALSE,
   p_commit                         IN     VARCHAR2        := FND_API.G_TRUE,
   p_validation_level               IN     NUMBER          := FND_API.G_VALID_LEVEL_FULL,
   p_transaction_id                 IN     NUMBER,
   x_return_status                  OUT NOCOPY     VARCHAR2,
   x_msg_count                      OUT NOCOPY     NUMBER,
   x_msg_data                       OUT NOCOPY     VARCHAR2
) IS
  l_api_name      CONSTANT VARCHAR2(30)   := 'update_status_to_completed';

Line: 47

  SAVEPOINT   update_status_to_completed_sp;

Line: 67

      EXECUTE IMMEDIATE 'UPDATE ies_transactions SET status = 0 '||
                    'WHERE transaction_id = :1' USING p_transaction_id;

Line: 70

  	 FND_MESSAGE.SET_NAME('IES', 'IES_STATUS_UPDATE_ERROR');

Line: 80

      FND_MESSAGE.SET_NAME('IES', 'IES_STATUS_UPDATE_SUCCESS');

Line: 100

  ROLLBACK TO update_status_to_completed_sp;

Line: 110

  ROLLBACK TO update_status_to_completed_sp;

Line: 120

  ROLLBACK TO update_status_to_completed_sp;

Line: 138

END update_status_to_completed;