APPS.AMV_AQ_UTILITY_PVT SQL Statements

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

Line: 21

Select
   queue_table
From user_queue_tables
Where queue_table = p_table;

Line: 30

Select
   name
From user_queues
Where queue_table = p_table
And   name = p_queue
And   queue_type = 'NORMAL_QUEUE';

Line: 99

PROCEDURE Delete_Queue
(
   p_queue_table_name  IN  VARCHAR2 := AMV_QUEUE.queue_table_name,
   p_queue_name        IN  VARCHAR2 := AMV_QUEUE.queue_name
);

Line: 148

   p_delete_flag  IN  VARCHAR2 := FND_API.G_TRUE,
   x_message_obj  OUT NOCOPY SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
);

Line: 212

PROCEDURE Delete_Queue
(
   p_queue_table_name  IN  VARCHAR2 := AMV_QUEUE.queue_table_name,
   p_queue_name        IN  VARCHAR2 := AMV_QUEUE.queue_name
) IS
l_temp_str     varchar2(200);

Line: 248

END Delete_Queue;

Line: 277

   p_delete_flag  IN  VARCHAR2 := FND_API.G_TRUE,
   x_message_obj  OUT NOCOPY  SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
) IS
l_dequeue_options     dbms_aq.dequeue_options_t;

Line: 284

   IF (p_delete_flag  = FND_API.G_FALSE) THEN
       l_dequeue_options.dequeue_mode := DBMS_AQ.BROWSE;

Line: 421

PROCEDURE Delete_Queue
(
    p_api_version       IN  NUMBER,
    p_init_msg_list     IN  VARCHAR2 := FND_API.G_FALSE,
    p_commit            IN  VARCHAR2 := FND_API.G_FALSE,
    p_validation_level  IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
    x_return_status     OUT NOCOPY  VARCHAR2,
    x_msg_count         OUT NOCOPY  NUMBER,
    x_msg_data          OUT NOCOPY  VARCHAR2,
    p_check_login_user  IN  VARCHAR2 := FND_API.G_TRUE,
    p_queue_table_name  IN  VARCHAR2 := AMV_QUEUE.queue_table_name,
    p_queue_name        IN  VARCHAR2 := AMV_QUEUE.queue_name
)  IS
l_api_name             CONSTANT VARCHAR2(30) := 'Delete_Queue';

Line: 444

    SAVEPOINT  Delete_Queue_Pvt;

Line: 495

    Delete_Queue
    (
       p_queue_table_name  => p_queue_table_name,
       p_queue_name        => p_queue_name
    );

Line: 511

       ROLLBACK TO  Delete_Queue_Pvt;

Line: 519

       ROLLBACK TO  Delete_Queue_Pvt;

Line: 527

       ROLLBACK TO  Delete_Queue_Pvt;

Line: 537

END Delete_Queue;

Line: 665

    p_delete_flag       IN  VARCHAR2 := FND_API.G_TRUE,
    x_message_obj       OUT NOCOPY  SYSTEM.AMV_AQ_MSG_OBJECT_TYPE
)  IS
l_api_name             CONSTANT VARCHAR2(30) := 'Delete_Queue';

Line: 678

    SAVEPOINT  Delete_Queue_Pvt;

Line: 731

       p_delete_flag  => p_delete_flag,
       x_message_obj  => x_message_obj
    );

Line: 745

       ROLLBACK TO  Delete_Queue_Pvt;

Line: 753

       ROLLBACK TO  Delete_Queue_Pvt;

Line: 761

       ROLLBACK TO  Delete_Queue_Pvt;