eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_UPDATE_ADJ_COVER SQL Statements

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

Line: 8


PROCEDURE update_adj_cover(
           p_form_name                      IN varchar2,
           p_form_version                   IN number,
           p_acctd_amount                   IN
              ar_adjustments.acctd_amount%type,
           p_adjustment_id                  IN
              ar_adjustments.adjustment_id%type,
           p_adjustment_number              IN
              ar_adjustments.adjustment_number%type,
           p_adjustment_type                IN
              ar_adjustments.adjustment_type%type,
           p_amount                         IN
              ar_adjustments.amount%type,
           p_apply_date                     IN
              ar_adjustments.apply_date%type,
           p_approved_by                    IN
              ar_adjustments.approved_by%type,
           p_associated_application_id      IN
              ar_adjustments.associated_application_id%type,
           p_associated_cash_receipt_id     IN
              ar_adjustments.associated_cash_receipt_id%type,
           p_attribute1                     IN
              ar_adjustments.attribute1%type,
           p_attribute10                    IN
              ar_adjustments.attribute10%type,
           p_attribute11                    IN
              ar_adjustments.attribute11%type,
           p_attribute12                    IN
              ar_adjustments.attribute12%type,
           p_attribute13                    IN
              ar_adjustments.attribute13%type,
           p_attribute14                    IN
              ar_adjustments.attribute14%type,
           p_attribute15                    IN
              ar_adjustments.attribute15%type,
           p_attribute2                     IN
              ar_adjustments.attribute2%type,
           p_attribute3                     IN
              ar_adjustments.attribute3%type,
           p_attribute4                     IN
              ar_adjustments.attribute4%type,
           p_attribute5                     IN
              ar_adjustments.attribute5%type,
           p_attribute6                     IN
              ar_adjustments.attribute6%type,
           p_attribute7                     IN
              ar_adjustments.attribute7%type,
           p_attribute8                     IN
              ar_adjustments.attribute8%type,
           p_attribute9                     IN
              ar_adjustments.attribute9%type,
           p_attribute_category             IN
              ar_adjustments.attribute_category%type,
           p_automatically_generated        IN
              ar_adjustments.automatically_generated%type,
           p_batch_id                       IN
              ar_adjustments.batch_id%type,
           p_chargeback_customer_trx_id     IN
              ar_adjustments.chargeback_customer_trx_id%type,
           p_code_combination_id            IN
              ar_adjustments.code_combination_id%type,
           p_comments                       IN
              ar_adjustments.comments%type,
           p_created_by                     IN
              ar_adjustments.created_by%type,
           p_created_from                   IN
              ar_adjustments.created_from%type,
           p_creation_date                  IN
              ar_adjustments.creation_date%type,
           p_customer_trx_id                IN
              ar_adjustments.customer_trx_id%type,
           p_customer_trx_line_id           IN
              ar_adjustments.customer_trx_line_id%type,
           p_distribution_set_id            IN
              ar_adjustments.distribution_set_id%type,
           p_doc_sequence_id                IN
              ar_adjustments.doc_sequence_id%type,
           p_doc_sequence_value             IN
              ar_adjustments.doc_sequence_value%type,
           p_freight_adjusted               IN
              ar_adjustments.freight_adjusted%type,
           p_gl_date                        IN
              ar_adjustments.gl_date%type,
           p_gl_posted_date                 IN
              ar_adjustments.gl_posted_date%type,
           p_last_updated_by                IN
              ar_adjustments.last_updated_by%type,
           p_last_update_date               IN
              ar_adjustments.last_update_date%type,
           p_last_update_login              IN
              ar_adjustments.last_update_login%type,
           p_line_adjusted                  IN
              ar_adjustments.line_adjusted%type,
           p_org_id                         IN
              ar_adjustments.org_id%type,
           p_payment_schedule_id            IN
              ar_adjustments.payment_schedule_id%type,
           p_postable                       IN
              ar_adjustments.postable%type,
           p_posting_control_id             IN
              ar_adjustments.posting_control_id%type,
           p_program_application_id         IN
              ar_adjustments.program_application_id%type,
           p_program_id                     IN
              ar_adjustments.program_id%type,
           p_program_update_date            IN
              ar_adjustments.program_update_date%type,
           p_reason_code                    IN
              ar_adjustments.reason_code%type,
           p_receivables_charges_adjusted   IN
              ar_adjustments.receivables_charges_adjusted%type,
           p_receivables_trx_id             IN
              ar_adjustments.receivables_trx_id%type,
           p_request_id                     IN
              ar_adjustments.request_id%type,
           p_set_of_books_id                IN
              ar_adjustments.set_of_books_id%type,
           p_status                         IN
              ar_adjustments.status%type,
           p_subsequent_trx_id              IN
              ar_adjustments.subsequent_trx_id%type,
           p_tax_adjusted                   IN
              ar_adjustments.tax_adjusted%type,
           p_type                           IN
              ar_adjustments.type%type,
           p_ussgl_transaction_code         IN
              ar_adjustments.ussgl_transaction_code%type,
           p_ussgl_transaction_code_conte IN
              ar_adjustments.ussgl_transaction_code_context%type)

IS

      l_adj_rec ar_adjustments%rowtype ;

Line: 145


         arp_util.debug('arp_process_adjustment.update_adj_cover()+',
                      pg_msg_level_debug);

Line: 185


      l_adj_rec.last_updated_by                := p_last_updated_by;

Line: 186


      l_adj_rec.last_update_date               := p_last_update_date;

Line: 202


      arp_process_adjustment.update_adjustment(
                  p_form_name     => p_form_name,
                  p_form_version  => p_form_version,
                  p_adj_rec       => l_adj_rec,
                  p_adjustment_id => p_adjustment_id);

Line: 210


         arp_util.debug('arp_process_adjustment.update_adj_cover()-',
                     pg_msg_level_debug);

Line: 218


       arp_util.debug('EXCEPTION:  arp_process_adjustment.update_adj_cover()',
                   pg_msg_level_debug);

Line: 220


       arp_util.debug('------- parameters for update_adj_cover() ' ||
                   '---------',
                   pg_msg_level_debug);

Line: 223


       arp_util.debug('update_adj_cover: ' || 'p_form_name                      = ' || p_form_name, pg_msg_level_debug);

Line: 224


       arp_util.debug('update_adj_cover: ' || 'p_form_version                   = ' || p_form_version, pg_msg_level_debug);

Line: 225


       arp_util.debug('update_adj_cover: ' || 'p_acctd_amount                   = '|| p_acctd_amount, pg_msg_level_debug);

Line: 226


       arp_util.debug('update_adj_cover: ' || 'p_adjustment_id                  = '|| p_adjustment_id, pg_msg_level_debug);

Line: 227


       arp_util.debug('update_adj_cover: ' || 'p_adjustment_number              = '|| p_adjustment_number, pg_msg_level_debug);

Line: 228


       arp_util.debug('update_adj_cover: ' || 'p_adjustment_type                = '|| p_adjustment_type, pg_msg_level_debug);

Line: 229


       arp_util.debug('update_adj_cover: ' || 'p_amount                         = '|| p_amount, pg_msg_level_debug);

Line: 230


       arp_util.debug('update_adj_cover: ' || 'p_apply_date                     = '|| p_apply_date, pg_msg_level_debug);

Line: 231


       arp_util.debug('update_adj_cover: ' || 'p_approved_by                    = '|| p_approved_by, pg_msg_level_debug);

Line: 232


       arp_util.debug('update_adj_cover: ' || 'p_associated_application_id      = '|| p_associated_application_id, pg_msg_level_debug);

Line: 233


       arp_util.debug('update_adj_cover: ' || 'p_associated_cash_receipt_id     = '|| p_associated_cash_receipt_id, pg_msg_level_debug);

Line: 234


       arp_util.debug('update_adj_cover: ' || 'p_attribute1                     = '|| p_attribute1, pg_msg_level_debug);

Line: 235


       arp_util.debug('update_adj_cover: ' || 'p_attribute10                    = '|| p_attribute10, pg_msg_level_debug);

Line: 236


       arp_util.debug('update_adj_cover: ' || 'p_attribute11                    = '|| p_attribute11, pg_msg_level_debug);

Line: 237


       arp_util.debug('update_adj_cover: ' || 'p_attribute12                    = '|| p_attribute12, pg_msg_level_debug);

Line: 238


       arp_util.debug('update_adj_cover: ' || 'p_attribute13                    = '|| p_attribute13, pg_msg_level_debug);

Line: 239


       arp_util.debug('update_adj_cover: ' || 'p_attribute14                    = '|| p_attribute14, pg_msg_level_debug);

Line: 240


       arp_util.debug('update_adj_cover: ' || 'p_attribute15                    = '|| p_attribute15, pg_msg_level_debug);

Line: 241


       arp_util.debug('update_adj_cover: ' || 'p_attribute2                     = '|| p_attribute2, pg_msg_level_debug);

Line: 242


       arp_util.debug('update_adj_cover: ' || 'p_attribute3                     = '|| p_attribute3, pg_msg_level_debug);

Line: 243


       arp_util.debug('update_adj_cover: ' || 'p_attribute4                     = '|| p_attribute4, pg_msg_level_debug);

Line: 244


       arp_util.debug('update_adj_cover: ' || 'p_attribute5                     = '|| p_attribute5, pg_msg_level_debug);

Line: 245


       arp_util.debug('update_adj_cover: ' || 'p_attribute6                     = '|| p_attribute6, pg_msg_level_debug);

Line: 246


       arp_util.debug('update_adj_cover: ' || 'p_attribute7                     = '|| p_attribute7, pg_msg_level_debug);

Line: 247


       arp_util.debug('update_adj_cover: ' || 'p_attribute8                     = '|| p_attribute8, pg_msg_level_debug);

Line: 248


       arp_util.debug('update_adj_cover: ' || 'p_attribute9                     = '|| p_attribute9, pg_msg_level_debug);

Line: 249


       arp_util.debug('update_adj_cover: ' || 'p_attribute_category             = '|| p_attribute_category, pg_msg_level_debug);

Line: 250


       arp_util.debug('update_adj_cover: ' || 'p_automatically_generated        = '|| p_automatically_generated, pg_msg_level_debug);

Line: 251


       arp_util.debug('update_adj_cover: ' || 'p_batch_id                       = '|| p_batch_id, pg_msg_level_debug);

Line: 252


       arp_util.debug('update_adj_cover: ' || 'p_chargeback_customer_trx_id     = '|| p_chargeback_customer_trx_id, pg_msg_level_debug);

Line: 253


       arp_util.debug('update_adj_cover: ' || 'p_code_combination_id            = '|| p_code_combination_id, pg_msg_level_debug);

Line: 254


       arp_util.debug('update_adj_cover: ' || 'p_comments                       = '|| p_comments, pg_msg_level_debug);

Line: 255


       arp_util.debug('update_adj_cover: ' || 'p_created_by                     = '|| p_created_by, pg_msg_level_debug);

Line: 256


       arp_util.debug('update_adj_cover: ' || 'p_created_from                   = '|| p_created_from, pg_msg_level_debug);

Line: 257


       arp_util.debug('update_adj_cover: ' || 'p_creation_date                  = '|| p_creation_date, pg_msg_level_debug);

Line: 258


       arp_util.debug('update_adj_cover: ' || 'p_customer_trx_id                = '|| p_customer_trx_id, pg_msg_level_debug);

Line: 259


       arp_util.debug('update_adj_cover: ' || 'p_customer_trx_line_id           = '|| p_customer_trx_line_id, pg_msg_level_debug);

Line: 260


       arp_util.debug('update_adj_cover: ' || 'p_distribution_set_id            = '|| p_distribution_set_id, pg_msg_level_debug);

Line: 261


       arp_util.debug('update_adj_cover: ' || 'p_doc_sequence_id                = '|| p_doc_sequence_id, pg_msg_level_debug);

Line: 262


       arp_util.debug('update_adj_cover: ' || 'p_doc_sequence_value             = '|| p_doc_sequence_value, pg_msg_level_debug);

Line: 263


       arp_util.debug('update_adj_cover: ' || 'p_freight_adjusted               = '|| p_freight_adjusted, pg_msg_level_debug);

Line: 264


       arp_util.debug('update_adj_cover: ' || 'p_gl_date                        = '|| p_gl_date, pg_msg_level_debug);

Line: 265


       arp_util.debug('update_adj_cover: ' || 'p_gl_posted_date                 = '|| p_gl_posted_date, pg_msg_level_debug);

Line: 266


       arp_util.debug('update_adj_cover: ' || 'p_last_updated_by                = '|| p_last_updated_by, pg_msg_level_debug);

Line: 267


       arp_util.debug('update_adj_cover: ' || 'p_last_update_date               = '|| p_last_update_date, pg_msg_level_debug);

Line: 268


       arp_util.debug('update_adj_cover: ' || 'p_last_update_login              = '|| p_last_update_login, pg_msg_level_debug);

Line: 269


       arp_util.debug('update_adj_cover: ' || 'p_line_adjusted                  = '|| p_line_adjusted, pg_msg_level_debug);

Line: 270


       arp_util.debug('update_adj_cover: ' || 'p_org_id                         = '|| p_org_id, pg_msg_level_debug);

Line: 271


       arp_util.debug('update_adj_cover: ' || 'p_payment_schedule_id            = '|| p_payment_schedule_id, pg_msg_level_debug);

Line: 272


       arp_util.debug('update_adj_cover: ' || 'p_postable                       = '|| p_postable, pg_msg_level_debug);

Line: 273


       arp_util.debug('update_adj_cover: ' || 'p_posting_control_id             = '|| p_posting_control_id, pg_msg_level_debug);

Line: 274


       arp_util.debug('update_adj_cover: ' || 'p_program_application_id         = '|| p_program_application_id, pg_msg_level_debug);

Line: 275


       arp_util.debug('update_adj_cover: ' || 'p_program_id                     = '|| p_program_id, pg_msg_level_debug);

Line: 276


       arp_util.debug('update_adj_cover: ' || 'p_program_update_date            = '|| p_program_update_date, pg_msg_level_debug);

Line: 277


       arp_util.debug('update_adj_cover: ' || 'p_reason_code                    = '|| p_reason_code, pg_msg_level_debug);

Line: 278


       arp_util.debug('update_adj_cover: ' || 'p_receivables_charges_adjusted   = '|| p_receivables_charges_adjusted, pg_msg_level_debug);

Line: 279


       arp_util.debug('update_adj_cover: ' || 'p_receivables_trx_id             = '|| p_receivables_trx_id, pg_msg_level_debug);

Line: 280


       arp_util.debug('update_adj_cover: ' || 'p_request_id                     = '|| p_request_id, pg_msg_level_debug);

Line: 281


       arp_util.debug('update_adj_cover: ' || 'p_set_of_books_id                = '|| p_set_of_books_id, pg_msg_level_debug);

Line: 282


       arp_util.debug('update_adj_cover: ' || 'p_status                         = '|| p_status, pg_msg_level_debug);

Line: 283


       arp_util.debug('update_adj_cover: ' || 'p_subsequent_trx_id              = '|| p_subsequent_trx_id, pg_msg_level_debug);

Line: 284


       arp_util.debug('update_adj_cover: ' || 'p_tax_adjusted                   = '|| p_tax_adjusted, pg_msg_level_debug);

Line: 285


       arp_util.debug('update_adj_cover: ' || 'p_type                           = '|| p_type, pg_msg_level_debug);

Line: 286


       arp_util.debug('update_adj_cover: ' || 'p_ussgl_transaction_code         = '|| p_ussgl_transaction_code, pg_msg_level_debug);

Line: 287


       arp_util.debug('update_adj_cover: ' || 'p_ussgl_transaction_code_conte = '|| p_ussgl_transaction_code_conte, pg_msg_level_debug);

Line: 295


END update_adj_cover;