APPS.POS_TAX_REPORT_BO_PKG SQL Statements

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

Line: 32

    SELECT pos_tax_report_bo(reporting_code_assoc_id,
                             entity_code,
                             entity_id,
                             exception_code,
                             effective_from,
                             effective_to,
                             created_by,
                             creation_date,
                             last_updated_by,
                             last_update_date,
                             last_update_login,
                             reporting_code_char_value,
                             reporting_code_date_value,
                             reporting_code_num_value,
                             reporting_type_id,
                             reporting_code_id,
                             object_version_number) BULK COLLECT
    INTO   l_pos_tax_report_bo_tbl
    FROM   zx_report_codes_assoc
    WHERE  entity_id = l_party_id;

Line: 81

    p_create_update_flag    IN VARCHAR2,
    p_pos_tax_report_bo     IN pos_tax_report_bo_tbl,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2
  ) IS

    l_row_exists        NUMBER := 0;

Line: 106

      IF p_create_update_flag = 'U' THEN
        --update the existing row;

Line: 108

        UPDATE zx_report_codes_assoc
        SET    reporting_code_assoc_id   = p_pos_tax_report_bo(i)
                                           .reporting_code_assoc_id,
               entity_code               = p_pos_tax_report_bo(i).entity_code,
               exception_code            = p_pos_tax_report_bo(i)
                                           .exception_code,
               effective_from            = p_pos_tax_report_bo(i)
                                           .effective_from,
               effective_to              = p_pos_tax_report_bo(i)
                                           .effective_to,
               last_updated_by           = p_pos_tax_report_bo(i)
                                           .last_updated_by,
               last_update_date          = SYSDATE,
               last_update_login         = p_pos_tax_report_bo(i)
                                           .last_update_login,
               reporting_code_char_value = p_pos_tax_report_bo(i)
                                           .reporting_code_char_value,
               reporting_code_date_value = p_pos_tax_report_bo(i)
                                           .reporting_code_date_value,
               reporting_code_num_value  = p_pos_tax_report_bo(i)
                                           .reporting_code_num_value,
               reporting_type_id         = p_pos_tax_report_bo(i)
                                           .reporting_type_id,
               reporting_code_id         = p_pos_tax_report_bo(i)
                                           .reporting_code_id,
               object_version_number     = p_pos_tax_report_bo(i)
                                           .object_version_number
        WHERE  entity_id = l_party_id;

Line: 137

      ELSIF p_create_update_flag = 'C' THEN
        SELECT zx_reporting_codes_b_s.nextval
        INTO   l_reporting_code_id
        FROM   dual;

Line: 144

        INSERT INTO zx_report_codes_assoc
          (reporting_code_assoc_id,
           entity_code,
           entity_id,
           exception_code,
           effective_from,
           effective_to,
           created_by,
           creation_date,
           last_updated_by,
           last_update_date,
           last_update_login,
           reporting_code_char_value,
           reporting_code_date_value,
           reporting_code_num_value,
           reporting_type_id,
           reporting_code_id,
           object_version_number)
        VALUES
          (l_reporting_code_id,
           p_pos_tax_report_bo(i).entity_code,
           p_pos_tax_report_bo(i).entity_id,
           p_pos_tax_report_bo(i).exception_code,
           p_pos_tax_report_bo(i).effective_from,
           p_pos_tax_report_bo(i).effective_to,
           p_pos_tax_report_bo(i).created_by,
           SYSDATE,
           p_pos_tax_report_bo(i).last_updated_by,
           SYSDATE,
           p_pos_tax_report_bo(i).last_update_login,
           p_pos_tax_report_bo(i).reporting_code_char_value,
           p_pos_tax_report_bo(i).reporting_code_date_value,
           p_pos_tax_report_bo(i).reporting_code_num_value,
           p_pos_tax_report_bo(i).reporting_type_id,
           p_pos_tax_report_bo(i).reporting_code_id,
           p_pos_tax_report_bo(i).object_version_number);