APPS.ARI_REG_VERIFICATIONS_PKG SQL Statements

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

Line: 9

PROCEDURE Insert_Row(
                     x_rowid                         IN OUT NOCOPY      VARCHAR2,
                     x_client_ip_address                         VARCHAR2,
                     x_question                                  VARCHAR2,
                     x_expected_answer                           VARCHAR2,
                     x_currency_code                             VARCHAR2,
                     x_first_answer                              VARCHAR2 DEFAULT NULL,
                     x_second_answer                             VARCHAR2 DEFAULT NULL,
                     x_third_answer                              VARCHAR2 DEFAULT NULL,
                     x_number_of_attempts                        NUMBER   DEFAULT 0,
                     x_result_code                               VARCHAR2 DEFAULT NULL,
                     x_customer_id                               NUMBER,
                     x_customer_site_use_id                      NUMBER DEFAULT NULL,
                     x_last_update_login                         NUMBER,
                     x_last_update_date                          DATE,
                     x_last_updated_by                           NUMBER,
                     x_creation_date                             DATE,
                     x_created_by                                NUMBER)
------------------------------------------------------------------------------
IS

 l_procedure_name   VARCHAR2(31)    := '.Insert_Row';

Line: 42

  l_debug_info := 'Insert into ari_reg_verifications_gt';

Line: 48

  INSERT INTO ARI_REG_VERIFICATIONS_GT(
                     client_ip_address,
                     question,
                     expected_answer,
                     currency_code,
                     first_answer,
                     second_answer,
                     third_answer,
                     number_of_attempts,
                     result_code,
                     customer_id,
                     customer_site_use_id,
                     last_update_login,
                     last_update_date,
                     last_updated_by,
                     creation_date,
                     created_by
   ) VALUES (
                     x_client_ip_address,
                     x_question,
                     x_expected_answer,
                     x_currency_code,
                     x_first_answer,
                     x_second_answer,
                     x_third_answer,
                     x_number_of_attempts,
                     x_result_code,
                     x_customer_id,
                     x_customer_site_use_id,
                     x_last_update_login,
                     x_last_update_date,
                     x_last_updated_by,
                     x_creation_date,
                     x_created_by);

Line: 83

   l_debug_info := 'After insert';

Line: 108

END Insert_Row;