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_DIST_COVER SQL Statements

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

Line: 8


 |    update_dist_cover						             |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    Converts column parameters to a dist record and                        |
 |    updates a dist line.                                                   |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |		      p_form_name					     |
 |		      p_form_version					     |
 |                    p_backout_flag                                         |
 |                    p_exchange_rate                                        |
 |                    p_base_currency_code                                   |
 |                    p_base_precision                                       |
 |                    p_base_mau                                             |
 |                    p_cust_trx_line_gl_dist_id                             |
 |                    p_customer_trx_id                                      |
 |                    p_customer_trx_line_id                                 |
 |                    p_cust_trx_line_salesrep_id                            |
 |                    p_account_class                                        |
 |                    p_percent                                              |
 |                    p_amount                                               |
 |                    p_acctd_amount                                         |
 |                    p_gl_date                                              |
 |                    p_original_gl_date                                     |
 |                    p_gl_posted_date                                       |
 |                    p_code_combination_id                                  |
 |                    p_concatenated_segments                                |
 |		      p_collected_tax_ccid				     |
 |		      p_collected_tax_concat_seg			     |
 |                    p_comments                                             |
 |                    p_account_set_flag                                     |
 |                    p_latest_rec_flag                                      |
 |                    p_ussgl_transaction_code                               |
 |                    p_ussgl_trx_code_context                               |
 |                    p_attribute_category                                   |
 |                    p_attribute1                                           |
 |                    p_attribute2                                           |
 |                    p_attribute3                                           |
 |                    p_attribute4                                           |
 |                    p_attribute5                                           |
 |                    p_attribute6                                           |
 |                    p_attribute7                                           |
 |                    p_attribute8                                           |
 |                    p_attribute9                                           |
 |                    p_attribute10                                          |
 |                    p_attribute11                                          |
 |                    p_attribute12                                          |
 |                    p_attribute13                                          |
 |                    p_attribute14                                          |
 |                    p_attribute15                                          |
 |                    p_posting_control_id                                   |
 |                    p_header_gl_date                                       |
 |                    p_trx_date                                             |
 |                    p_invoicing_rule_id                                    |
 |              OUT:                                                         |
 |                    p_backout_done_flag                                    |
 |          IN/ OUT:							     |
 |                    None						     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     11-OCT-95  Martin Johnson      Created                                |
 |     07-NOV-95  Martin Johnson      Added OUT NOCOPY parameter p_backout_done_flag|
 |                                    Added IN parameters p_header_gl_date,  |
 |                                      p_trx_date, p_invoicing_rule_id      |
 |     05-JAN-99  Tasman Tang         Added new parameters collected_tax_ccid|
 |                                    and collected_tax_concat_seg for       |
 |                                    deferred tax                           |
 |                                                                           |
 +===========================================================================*/

PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line: 89


PROCEDURE update_dist_cover(
           p_form_name                      IN varchar2,
           p_form_version                   IN number,
           p_backout_flag                   IN boolean,
           p_exchange_rate                  IN
             ra_customer_trx.exchange_rate%type,
           p_base_currency_code             IN
             fnd_currencies.currency_code%type,
           p_base_precision                 IN
             fnd_currencies.precision%type,
           p_base_mau                       IN
             fnd_currencies.minimum_accountable_unit%type,
           p_cust_trx_line_gl_dist_id       IN
             ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
           p_customer_trx_id                IN
             ra_cust_trx_line_gl_dist.customer_trx_id%type,
           p_customer_trx_line_id           IN
             ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
           p_cust_trx_line_salesrep_id      IN
             ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
           p_account_class                  IN
             ra_cust_trx_line_gl_dist.account_class%type,
           p_percent                        IN
             ra_cust_trx_line_gl_dist.percent%type,
           p_amount                         IN
             ra_cust_trx_line_gl_dist.amount%type,
           p_gl_date                        IN
             ra_cust_trx_line_gl_dist.gl_date%type,
           p_original_gl_date               IN
             ra_cust_trx_line_gl_dist.original_gl_date%type,
           p_gl_posted_date                 IN
             ra_cust_trx_line_gl_dist.gl_posted_date%type,
           p_code_combination_id            IN
             ra_cust_trx_line_gl_dist.code_combination_id%type,
           p_concatenated_segments          IN
             ra_cust_trx_line_gl_dist.concatenated_segments%type,
           p_collected_tax_ccid             IN
             ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
           p_collected_tax_concat_seg       IN
             ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
           p_comments                       IN
             ra_cust_trx_line_gl_dist.comments%type,
           p_account_set_flag               IN
             ra_cust_trx_line_gl_dist.account_set_flag%type,
           p_latest_rec_flag                IN
             ra_cust_trx_line_gl_dist.latest_rec_flag%type,
           p_ussgl_transaction_code         IN
             ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
           p_ussgl_trx_code_context         IN
             ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
           p_attribute_category             IN
             ra_cust_trx_line_gl_dist.attribute_category%type,
           p_attribute1                     IN
             ra_cust_trx_line_gl_dist.attribute1%type,
           p_attribute2                     IN
             ra_cust_trx_line_gl_dist.attribute2%type,
           p_attribute3                     IN
             ra_cust_trx_line_gl_dist.attribute3%type,
           p_attribute4                     IN
             ra_cust_trx_line_gl_dist.attribute4%type,
           p_attribute5                     IN
             ra_cust_trx_line_gl_dist.attribute5%type,
           p_attribute6                     IN
             ra_cust_trx_line_gl_dist.attribute6%type,
           p_attribute7                     IN
             ra_cust_trx_line_gl_dist.attribute7%type,
           p_attribute8                     IN
             ra_cust_trx_line_gl_dist.attribute8%type,
           p_attribute9                     IN
             ra_cust_trx_line_gl_dist.attribute9%type,
           p_attribute10                    IN
             ra_cust_trx_line_gl_dist.attribute10%type,
           p_attribute11                    IN
             ra_cust_trx_line_gl_dist.attribute11%type,
           p_attribute12                    IN
             ra_cust_trx_line_gl_dist.attribute12%type,
           p_attribute13                    IN
             ra_cust_trx_line_gl_dist.attribute13%type,
           p_attribute14                    IN
             ra_cust_trx_line_gl_dist.attribute14%type,
           p_attribute15                    IN
             ra_cust_trx_line_gl_dist.attribute15%type,
           p_posting_control_id             IN
             ra_cust_trx_line_gl_dist.posting_control_id%type,
           p_header_gl_date                 IN date,
           p_trx_date                       IN date,
           p_invoicing_rule_id              IN
             ra_customer_trx.invoicing_rule_id%type,
           p_rec_offset_flag             IN
             ra_cust_trx_line_gl_dist.rec_offset_flag%type, 	/* Bug 3568021 */
           p_backout_done_flag              OUT NOCOPY boolean,
           p_rounding_correction_flag       IN varchar2 DEFAULT NULL,
           p_ccid_change_flag               IN
             ra_cust_trx_line_gl_dist.ccid_change_flag%type) /* Bug 8788491 */
IS

      l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

Line: 190


         arp_util.debug('arp_process_dist.update_dist_cover()+',
                     pg_msg_level_debug);

Line: 244


      arp_process_dist.update_dist(
                   p_form_name,
                   p_form_version,
                   p_backout_flag,
                   p_cust_trx_line_gl_dist_id,
                   p_customer_trx_id,
                   l_dist_rec,
                   p_header_gl_date,
                   p_trx_date,
                   p_invoicing_rule_id,
                   p_backout_done_flag,
                   p_exchange_rate,
                   p_base_currency_code,
                   p_base_precision,
                   p_base_mau );

Line: 261


         arp_util.debug('arp_process_dist.update_dist_cover()-',
                     pg_msg_level_debug);

Line: 269


       arp_util.debug('EXCEPTION:  arp_process_dist.update_dist_cover()',
                   pg_msg_level_debug);

Line: 271


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

Line: 274


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

Line: 276


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

Line: 278


       arp_util.debug('update_dist_cover: ' || 'p_backout_flag              = ' ||
                     arp_trx_util.boolean_to_varchar2(p_backout_flag),
                   pg_msg_level_debug);

Line: 281


       arp_util.debug('update_dist_cover: ' || 'p_exchange_rate             = ' || p_exchange_rate,
                   pg_msg_level_debug);

Line: 283


       arp_util.debug('update_dist_cover: ' || 'p_base_currency_code        = ' || p_base_currency_code,
                   pg_msg_level_debug);

Line: 285


       arp_util.debug('update_dist_cover: ' || 'p_base_precision            = ' || p_base_precision,
                   pg_msg_level_debug);

Line: 287


       arp_util.debug('update_dist_cover: ' || 'p_base_mau                  = ' || p_base_mau,
                   pg_msg_level_debug);

Line: 289


       arp_util.debug('update_dist_cover: ' || 'p_cust_trx_line_gl_dist_id  = ' ||
                     p_cust_trx_line_gl_dist_id,
                   pg_msg_level_debug);

Line: 292


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

Line: 294


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

Line: 296


       arp_util.debug('update_dist_cover: ' || 'p_cust_trx_line_salesrep_id = ' ||
                     p_cust_trx_line_salesrep_id,
                   pg_msg_level_debug);

Line: 299


       arp_util.debug('update_dist_cover: ' || 'p_account_class             = ' || p_account_class,
                   pg_msg_level_debug);

Line: 301


       arp_util.debug('update_dist_cover: ' || 'p_percent                   = ' || p_percent,
                   pg_msg_level_debug);

Line: 303


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

Line: 305


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

Line: 307


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

Line: 309


       arp_util.debug('update_dist_cover: ' || 'p_original_gl_date          = ' || p_original_gl_date,
                   pg_msg_level_debug);

Line: 311


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

Line: 313


       arp_util.debug('update_dist_cover: ' || 'p_concatenated_segments     = ' || p_concatenated_segments,
                   pg_msg_level_debug);

Line: 315


       arp_util.debug('update_dist_cover: ' || 'p_collected_tax_ccid        = ' || p_collected_tax_ccid,
                   pg_msg_level_debug);

Line: 317


       arp_util.debug('update_dist_cover: ' || 'p_collected_tax_concat_seg  = ' || p_collected_tax_concat_seg,
                   pg_msg_level_debug);

Line: 319


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

Line: 321


       arp_util.debug('update_dist_cover: ' || 'p_account_set_flag          = ' || p_account_set_flag,
                   pg_msg_level_debug);

Line: 323


       arp_util.debug('update_dist_cover: ' || 'p_latest_rec_flag           = ' || p_latest_rec_flag,
                   pg_msg_level_debug);

Line: 325


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

Line: 328


       arp_util.debug('update_dist_cover: ' || 'p_ussgl_trx_code_context    = ' ||
                      p_ussgl_trx_code_context,
                   pg_msg_level_debug);

Line: 331


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

Line: 333


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

Line: 335


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

Line: 337


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

Line: 339


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

Line: 341


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

Line: 343


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

Line: 345


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

Line: 347


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

Line: 349


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

Line: 351


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

Line: 353


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

Line: 355


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

Line: 357


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

Line: 359


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

Line: 361


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

Line: 363


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

Line: 365


       arp_util.debug('update_dist_cover: ' || 'p_header_gl_date            = ' || p_header_gl_date,
                   pg_msg_level_debug);

Line: 367


       arp_util.debug('update_dist_cover: ' || 'p_trx_date                  = ' || p_trx_date,
                   pg_msg_level_debug);

Line: 369


       arp_util.debug('update_dist_cover: ' || 'p_invoicing_rule_id         = ' || p_invoicing_rule_id,
                   pg_msg_level_debug);

Line: 375


END update_dist_cover;