APPS.ARP_CT_PKG SQL Statements

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

Line: 5

   |  Package global variables to hold the parsed update cursors.  |
   |  This allows the cursors to be reused without being reparsed. |
   +---------------------------------------------------------------*/

  /*--------------------------------------------------------+
   |  Dummy constants for use in update and lock operations |
   +--------------------------------------------------------*/
  AR_TEXT_DUMMY   CONSTANT VARCHAR2(10) := '~~!@#$*&^';

Line: 36

 |    in the dynamic SQL update statement.                                  |
 |                                                                          |
 | SCOPE - PRIVATE                                                          |
 |                                                                          |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                  |
 |    dbms_sql.bind_variable                                                |
 |    arp_util.debug                                                        |
 |                                                                          |
 | ARGUMENTS  : IN:                                                         |
 |                    p_update_cursor  - ID of the update cursor            |
 |                    p_trx_rec        - ra_customer_trx record             |
 |              OUT:                                                        |
 |                    None                                                  |
 |                                                                          |
 | RETURNS    : NONE                                                        |
 |                                                                          |
 | NOTES                                                                    |
 |                                                                          |
 | MODIFICATION HISTORY                                                     |
 | 06-JUN-95   Charlie Tomberg  Created    			            |
 |                                                                          |
 | 20-MAR-2000 J Rautiainen     Added BR project related columns            |
 |                              BR_AMOUNT, BR_UNPAID_FLAG,BR_ON_HOLD_FLAG,  |
 |                              DRAWEE_ID, DRAWEE_CONTACT_ID,               |
 |				DRAWEE_SITE_USE_ID, DRAWEE_BANK_ACCOUNT_ID, |
 |                              REMITTANCE_BANK_ACCOUNT_ID,                 |
 |                              OVERRIDE_REMIT_ACCOUNT_FLAG and             |
 |                              SPECIAL_INSTRUCTIONSinto table handlers     |
 | 24-JUL-2000 J Rautiainen     Added BR project related column             |
 |                              REMITTANCE_BATCH_ID	                    |
 |            								    |
 | 31-OCT-2000 Y Rakotonirainy	Bug 1243304 : Added columns                 |
 |                              address_verification_code and	            |
 |				approval_code	and		            |
 |				bill_to_address_id and	                    |
 |				edi_processed_flag and			    |
 |				edi_processed_status and		    |
 |				payment_server_order_num and		    |
 |				post_request_id and			    |
 |				request_id and				    |
 |				ship_to_address_id		    	    |
 |				wh_update_date			            |
 | 				into the table handlers.  		    |
 | 20-Jun-2002 Sahana           Bug2427456 : Added global attribute columns |
 +===========================================================================*/


PROCEDURE bind_trx_variables(p_update_cursor IN integer,
                             p_trx_rec       IN ra_customer_trx%rowtype) IS

BEGIN

   arp_util.debug('arp_ct_pkg.bind_trx_variables()+');

Line: 94

   dbms_sql.bind_variable(p_update_cursor, ':ar_text_dummy',
                          AR_TEXT_DUMMY);

Line: 97

   dbms_sql.bind_variable(p_update_cursor, ':ar_flag_dummy',
                          AR_FLAG_DUMMY);

Line: 100

   dbms_sql.bind_variable(p_update_cursor, ':ar_number_dummy',
                          AR_NUMBER_DUMMY);

Line: 103

   dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
                          AR_DATE_DUMMY);

Line: 111

   dbms_sql.bind_variable(p_update_cursor, ':pg_user_id',
                          pg_user_id);

Line: 114

   dbms_sql.bind_variable(p_update_cursor, ':pg_login_id',
                          pg_login_id);

Line: 117

   dbms_sql.bind_variable(p_update_cursor, ':pg_conc_login_id',
                          pg_conc_login_id);

Line: 126

   dbms_sql.bind_variable(p_update_cursor, ':customer_trx_id',
                          p_trx_rec.customer_trx_id);

Line: 129

   dbms_sql.bind_variable(p_update_cursor, ':trx_number',
                          p_trx_rec.trx_number);

Line: 132

   dbms_sql.bind_variable(p_update_cursor, ':created_by',
                          p_trx_rec.created_by);

Line: 135

   dbms_sql.bind_variable(p_update_cursor, ':creation_date',
                          p_trx_rec.creation_date);

Line: 138

   dbms_sql.bind_variable(p_update_cursor, ':last_updated_by',
                          p_trx_rec.last_updated_by);

Line: 141

   dbms_sql.bind_variable(p_update_cursor, ':last_update_date',
                          p_trx_rec.last_update_date);

Line: 144

   dbms_sql.bind_variable(p_update_cursor, ':last_update_login',
                          p_trx_rec.last_update_login);

Line: 147

   dbms_sql.bind_variable(p_update_cursor, ':set_of_books_id',
                          p_trx_rec.set_of_books_id);

Line: 150

   dbms_sql.bind_variable(p_update_cursor, ':program_application_id',
                          p_trx_rec.program_application_id);

Line: 153

   dbms_sql.bind_variable(p_update_cursor, ':program_id',
                          p_trx_rec.program_id);

Line: 156

   dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
                          p_trx_rec.program_update_date);

Line: 159

   dbms_sql.bind_variable(p_update_cursor, ':posting_control_id',
                          p_trx_rec.posting_control_id);

Line: 162

   dbms_sql.bind_variable(p_update_cursor, ':ra_post_loop_number',
                          p_trx_rec.ra_post_loop_number);

Line: 165

   dbms_sql.bind_variable(p_update_cursor, ':complete_flag',
                          p_trx_rec.complete_flag);

Line: 168

   dbms_sql.bind_variable(p_update_cursor, ':initial_customer_trx_id',
                          p_trx_rec.initial_customer_trx_id);

Line: 171

   dbms_sql.bind_variable(p_update_cursor, ':previous_customer_trx_id',
                          p_trx_rec.previous_customer_trx_id);

Line: 174

   dbms_sql.bind_variable(p_update_cursor, ':related_customer_trx_id',
                          p_trx_rec.related_customer_trx_id);

Line: 177

   dbms_sql.bind_variable(p_update_cursor, ':recurred_from_trx_number',
                          p_trx_rec.recurred_from_trx_number);

Line: 180

   dbms_sql.bind_variable(p_update_cursor, ':cust_trx_type_id',
                          p_trx_rec.cust_trx_type_id);

Line: 183

   dbms_sql.bind_variable(p_update_cursor, ':batch_id',
                          p_trx_rec.batch_id);

Line: 186

   dbms_sql.bind_variable(p_update_cursor, ':batch_source_id',
                          p_trx_rec.batch_source_id);

Line: 189

   dbms_sql.bind_variable(p_update_cursor, ':agreement_id',
                          p_trx_rec.agreement_id);

Line: 192

   dbms_sql.bind_variable(p_update_cursor, ':trx_date',
                          p_trx_rec.trx_date);

Line: 195

   dbms_sql.bind_variable(p_update_cursor, ':bill_to_customer_id',
                          p_trx_rec.bill_to_customer_id);

Line: 198

   dbms_sql.bind_variable(p_update_cursor, ':bill_to_contact_id',
                          p_trx_rec.bill_to_contact_id);

Line: 201

   dbms_sql.bind_variable(p_update_cursor, ':bill_to_site_use_id',
                          p_trx_rec.bill_to_site_use_id);

Line: 204

   dbms_sql.bind_variable(p_update_cursor, ':ship_to_customer_id',
                          p_trx_rec.ship_to_customer_id);

Line: 207

   dbms_sql.bind_variable(p_update_cursor, ':ship_to_contact_id',
                          p_trx_rec.ship_to_contact_id);

Line: 210

   dbms_sql.bind_variable(p_update_cursor, ':ship_to_site_use_id',
                          p_trx_rec.ship_to_site_use_id);

Line: 213

   dbms_sql.bind_variable(p_update_cursor, ':sold_to_customer_id',
                          p_trx_rec.sold_to_customer_id);

Line: 216

   dbms_sql.bind_variable(p_update_cursor, ':sold_to_site_use_id',
                          p_trx_rec.sold_to_site_use_id);

Line: 219

   dbms_sql.bind_variable(p_update_cursor, ':sold_to_contact_id',
                          p_trx_rec.sold_to_contact_id);

Line: 222

   dbms_sql.bind_variable(p_update_cursor, ':customer_reference',
                          p_trx_rec.customer_reference);

Line: 225

   dbms_sql.bind_variable(p_update_cursor, ':customer_reference_date',
                          p_trx_rec.customer_reference_date);

Line: 228

   dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_installments',
                          p_trx_rec.credit_method_for_installments);

Line: 231

   dbms_sql.bind_variable(p_update_cursor, ':credit_method_for_rules',
                          p_trx_rec.credit_method_for_rules);

Line: 234

   dbms_sql.bind_variable(p_update_cursor, ':start_date_commitment',
                          p_trx_rec.start_date_commitment);

Line: 237

   dbms_sql.bind_variable(p_update_cursor, ':end_date_commitment',
                          p_trx_rec.end_date_commitment);

Line: 240

   dbms_sql.bind_variable(p_update_cursor, ':exchange_date',
                          p_trx_rec.exchange_date);

Line: 243

   dbms_sql.bind_variable(p_update_cursor, ':exchange_rate',
                          p_trx_rec.exchange_rate);

Line: 246

   dbms_sql.bind_variable(p_update_cursor, ':exchange_rate_type',
                          p_trx_rec.exchange_rate_type);

Line: 249

   dbms_sql.bind_variable(p_update_cursor, ':customer_bank_account_id',
                          p_trx_rec.customer_bank_account_id);

Line: 252

   dbms_sql.bind_variable(p_update_cursor, ':finance_charges',
                          p_trx_rec.finance_charges);

Line: 255

   dbms_sql.bind_variable(p_update_cursor, ':fob_point',
                          p_trx_rec.fob_point);

Line: 258

   dbms_sql.bind_variable(p_update_cursor, ':comments',
                          p_trx_rec.comments);

Line: 261

   dbms_sql.bind_variable(p_update_cursor, ':internal_notes',
                          p_trx_rec.internal_notes);

Line: 264

   dbms_sql.bind_variable(p_update_cursor, ':invoice_currency_code',
                          p_trx_rec.invoice_currency_code);

Line: 267

   dbms_sql.bind_variable(p_update_cursor, ':invoicing_rule_id',
                          p_trx_rec.invoicing_rule_id);

Line: 270

   dbms_sql.bind_variable(p_update_cursor, ':last_printed_sequence_num',
                          p_trx_rec.last_printed_sequence_num);

Line: 273

   dbms_sql.bind_variable(p_update_cursor, ':orig_system_batch_name',
                          p_trx_rec.orig_system_batch_name);

Line: 276

   dbms_sql.bind_variable(p_update_cursor, ':primary_salesrep_id',
                          p_trx_rec.primary_salesrep_id);

Line: 279

   dbms_sql.bind_variable(p_update_cursor, ':printing_count',
                          p_trx_rec.printing_count);

Line: 282

   dbms_sql.bind_variable(p_update_cursor, ':printing_last_printed',
                          p_trx_rec.printing_last_printed);

Line: 285

   dbms_sql.bind_variable(p_update_cursor, ':printing_option',
                          p_trx_rec.printing_option);

Line: 288

   dbms_sql.bind_variable(p_update_cursor, ':printing_original_date',
                          p_trx_rec.printing_original_date);

Line: 291

   dbms_sql.bind_variable(p_update_cursor, ':printing_pending',
                          p_trx_rec.printing_pending);

Line: 294

   dbms_sql.bind_variable(p_update_cursor, ':purchase_order',
                          p_trx_rec.purchase_order);

Line: 297

   dbms_sql.bind_variable(p_update_cursor, ':purchase_order_date',
                          p_trx_rec.purchase_order_date);

Line: 300

   dbms_sql.bind_variable(p_update_cursor, ':purchase_order_revision',
                          p_trx_rec.purchase_order_revision);

Line: 303

   dbms_sql.bind_variable(p_update_cursor, ':receipt_method_id',
                          p_trx_rec.receipt_method_id);

Line: 306

   dbms_sql.bind_variable(p_update_cursor, ':remit_to_address_id',
                          p_trx_rec.remit_to_address_id);

Line: 309

   dbms_sql.bind_variable(p_update_cursor, ':shipment_id',
                          p_trx_rec.shipment_id);

Line: 312

   dbms_sql.bind_variable(p_update_cursor, ':ship_date_actual',
                          p_trx_rec.ship_date_actual);

Line: 315

   dbms_sql.bind_variable(p_update_cursor, ':ship_via',
                          p_trx_rec.ship_via);

Line: 318

   dbms_sql.bind_variable(p_update_cursor, ':term_due_date',
                          p_trx_rec.term_due_date);

Line: 321

   dbms_sql.bind_variable(p_update_cursor, ':term_id',
                          p_trx_rec.term_id);

Line: 324

   dbms_sql.bind_variable(p_update_cursor, ':territory_id',
                          p_trx_rec.territory_id);

Line: 327

   dbms_sql.bind_variable(p_update_cursor, ':waybill_number',
                          p_trx_rec.waybill_number);

Line: 330

   dbms_sql.bind_variable(p_update_cursor, ':status_trx',
                          p_trx_rec.status_trx);

Line: 333

   dbms_sql.bind_variable(p_update_cursor, ':reason_code',
                          p_trx_rec.reason_code);

Line: 336

   dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_id',
                          p_trx_rec.doc_sequence_id);

Line: 339

   dbms_sql.bind_variable(p_update_cursor, ':doc_sequence_value',
                          p_trx_rec.doc_sequence_value);

Line: 342

   dbms_sql.bind_variable(p_update_cursor, ':paying_customer_id',
                          p_trx_rec.paying_customer_id);

Line: 345

   dbms_sql.bind_variable(p_update_cursor, ':paying_site_use_id',
                          p_trx_rec.paying_site_use_id);

Line: 348

   dbms_sql.bind_variable(p_update_cursor, ':related_batch_source_id',
                          p_trx_rec.related_batch_source_id);

Line: 351

   dbms_sql.bind_variable(p_update_cursor, ':default_tax_exempt_flag',
                          p_trx_rec.default_tax_exempt_flag);

Line: 354

   dbms_sql.bind_variable(p_update_cursor, ':created_from',
                          p_trx_rec.created_from);

Line: 357

   dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_trx_code_context',
                          p_trx_rec.default_ussgl_trx_code_context);

Line: 360

   dbms_sql.bind_variable(p_update_cursor, ':default_ussgl_transaction_code',
                          p_trx_rec.default_ussgl_transaction_code);

Line: 363

   dbms_sql.bind_variable(p_update_cursor, ':old_trx_number',
                          p_trx_rec.old_trx_number);

Line: 366

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_context',
                          p_trx_rec.interface_header_context);

Line: 369

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute1',
                          p_trx_rec.interface_header_attribute1);

Line: 372

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute2',
                          p_trx_rec.interface_header_attribute2);

Line: 375

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute3',
                          p_trx_rec.interface_header_attribute3);

Line: 378

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute4',
                          p_trx_rec.interface_header_attribute4);

Line: 381

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute5',
                          p_trx_rec.interface_header_attribute5);

Line: 384

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute6',
                          p_trx_rec.interface_header_attribute6);

Line: 387

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute7',
                          p_trx_rec.interface_header_attribute7);

Line: 390

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute8',
                          p_trx_rec.interface_header_attribute8);

Line: 393

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute9',
                          p_trx_rec.interface_header_attribute9);

Line: 396

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute10',
                          p_trx_rec.interface_header_attribute10);

Line: 399

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute11',
                          p_trx_rec.interface_header_attribute11);

Line: 402

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute12',
                          p_trx_rec.interface_header_attribute12);

Line: 405

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute13',
                          p_trx_rec.interface_header_attribute13);

Line: 408

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute14',
                          p_trx_rec.interface_header_attribute14);

Line: 411

   dbms_sql.bind_variable(p_update_cursor, ':interface_header_attribute15',
                          p_trx_rec.interface_header_attribute15);

Line: 414

   dbms_sql.bind_variable(p_update_cursor, ':attribute_category',
                          p_trx_rec.attribute_category);

Line: 417

   dbms_sql.bind_variable(p_update_cursor, ':attribute1',
                          p_trx_rec.attribute1);

Line: 420

   dbms_sql.bind_variable(p_update_cursor, ':attribute2',
                          p_trx_rec.attribute2);

Line: 423

   dbms_sql.bind_variable(p_update_cursor, ':attribute3',
                          p_trx_rec.attribute3);

Line: 426

   dbms_sql.bind_variable(p_update_cursor, ':attribute4',
                          p_trx_rec.attribute4);

Line: 429

   dbms_sql.bind_variable(p_update_cursor, ':attribute5',
                          p_trx_rec.attribute5);

Line: 432

   dbms_sql.bind_variable(p_update_cursor, ':attribute6',
                          p_trx_rec.attribute6);

Line: 435

   dbms_sql.bind_variable(p_update_cursor, ':attribute7',
                          p_trx_rec.attribute7);

Line: 438

   dbms_sql.bind_variable(p_update_cursor, ':attribute8',
                          p_trx_rec.attribute8);

Line: 441

   dbms_sql.bind_variable(p_update_cursor, ':attribute9',
                          p_trx_rec.attribute9);

Line: 444

   dbms_sql.bind_variable(p_update_cursor, ':attribute10',
                          p_trx_rec.attribute10);

Line: 447

   dbms_sql.bind_variable(p_update_cursor, ':attribute11',
                          p_trx_rec.attribute11);

Line: 450

   dbms_sql.bind_variable(p_update_cursor, ':attribute12',
                          p_trx_rec.attribute12);

Line: 453

   dbms_sql.bind_variable(p_update_cursor, ':attribute13',
                          p_trx_rec.attribute13);

Line: 456

   dbms_sql.bind_variable(p_update_cursor, ':attribute14',
                          p_trx_rec.attribute14);

Line: 459

   dbms_sql.bind_variable(p_update_cursor, ':attribute15',
                          p_trx_rec.attribute15);

Line: 462

   dbms_sql.bind_variable(p_update_cursor, ':br_amount',
                          p_trx_rec.br_amount);

Line: 465

   dbms_sql.bind_variable(p_update_cursor, ':br_unpaid_flag',
                          p_trx_rec.br_unpaid_flag);

Line: 468

   dbms_sql.bind_variable(p_update_cursor, ':br_on_hold_flag',
                          p_trx_rec.br_on_hold_flag);

Line: 471

   dbms_sql.bind_variable(p_update_cursor, ':drawee_id',
                          p_trx_rec.drawee_id);

Line: 474

   dbms_sql.bind_variable(p_update_cursor, ':drawee_contact_id',
                          p_trx_rec.drawee_contact_id);

Line: 477

   dbms_sql.bind_variable(p_update_cursor, ':drawee_site_use_id',
                          p_trx_rec.drawee_site_use_id);

Line: 480

   dbms_sql.bind_variable(p_update_cursor, ':drawee_bank_account_id',
                          p_trx_rec.drawee_bank_account_id);

Line: 483

   dbms_sql.bind_variable(p_update_cursor, ':remittance_bank_account_id',
                          p_trx_rec.remit_bank_acct_use_id);

Line: 486

   dbms_sql.bind_variable(p_update_cursor, ':override_remit_account_flag',
                          p_trx_rec.override_remit_account_flag);

Line: 489

   dbms_sql.bind_variable(p_update_cursor, ':special_instructions',
                          p_trx_rec.special_instructions);

Line: 492

   dbms_sql.bind_variable(p_update_cursor, ':remittance_batch_id',
                          p_trx_rec.remittance_batch_id);

Line: 495

   dbms_sql.bind_variable(p_update_cursor, ':address_verification_code',
                          p_trx_rec.address_verification_code);

Line: 498

   dbms_sql.bind_variable(p_update_cursor, ':approval_code',
                          p_trx_rec.approval_code);

Line: 501

   dbms_sql.bind_variable(p_update_cursor, ':bill_to_address_id',
                          p_trx_rec.bill_to_address_id);

Line: 504

   dbms_sql.bind_variable(p_update_cursor, ':edi_processed_flag',
                          p_trx_rec.edi_processed_flag);

Line: 507

   dbms_sql.bind_variable(p_update_cursor, ':edi_processed_status',
                          p_trx_rec.edi_processed_status);

Line: 510

   dbms_sql.bind_variable(p_update_cursor, ':payment_server_order_num',
                          p_trx_rec.payment_server_order_num);

Line: 513

   dbms_sql.bind_variable(p_update_cursor, ':post_request_id',
                          p_trx_rec.post_request_id);

Line: 516

   dbms_sql.bind_variable(p_update_cursor, ':request_id',
                          p_trx_rec.request_id);

Line: 519

   dbms_sql.bind_variable(p_update_cursor, ':ship_to_address_id',
                          p_trx_rec.ship_to_address_id);

Line: 522

   dbms_sql.bind_variable(p_update_cursor, ':wh_update_date',
                          p_trx_rec.wh_update_date);

Line: 525

   dbms_sql.bind_variable(p_update_cursor, ':legal_entity_id',
                          p_trx_rec.legal_entity_id);

Line: 528

   dbms_sql.bind_variable(p_update_cursor, ':payment_trxn_extension_id',
                          p_trx_rec.payment_trxn_extension_id);

Line: 531

   dbms_sql.bind_variable(p_update_cursor, ':billing_date',
                          p_trx_rec.billing_date);

Line: 534

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute_category',
                          p_trx_rec.global_attribute_category);

Line: 537

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute1',
                          p_trx_rec.global_attribute1);

Line: 540

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute2',
                          p_trx_rec.global_attribute2);

Line: 543

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute3',
                          p_trx_rec.global_attribute3);

Line: 546

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute4',
                          p_trx_rec.global_attribute4);

Line: 549

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute5',
                          p_trx_rec.global_attribute5);

Line: 552

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute6',
                          p_trx_rec.global_attribute6);

Line: 555

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute7',
                          p_trx_rec.global_attribute7);

Line: 559

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute8',
                          p_trx_rec.global_attribute8);

Line: 562

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute9',
                          p_trx_rec.global_attribute9);

Line: 565

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute10',
                          p_trx_rec.global_attribute10);

Line: 568

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute11',
                          p_trx_rec.global_attribute11);

Line: 571

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute12',
                          p_trx_rec.global_attribute12);

Line: 574

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute13',
                          p_trx_rec.global_attribute13);

Line: 577

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute14',
                          p_trx_rec.global_attribute14);

Line: 580

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute15',
                          p_trx_rec.global_attribute15);

Line: 583

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute16',
                          p_trx_rec.global_attribute16);

Line: 586

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute17',
                          p_trx_rec.global_attribute17);

Line: 589

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute18',
                          p_trx_rec.global_attribute18);

Line: 592

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute19',
                          p_trx_rec.global_attribute19);

Line: 595

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute20',
                          p_trx_rec.global_attribute20);

Line: 598

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute21',
                          p_trx_rec.global_attribute21);

Line: 601

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute22',
                          p_trx_rec.global_attribute22);

Line: 604

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute23',
                          p_trx_rec.global_attribute23);

Line: 607

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute24',
                          p_trx_rec.global_attribute24);

Line: 610

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute25',
                          p_trx_rec.global_attribute25);

Line: 613

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute26',
                          p_trx_rec.global_attribute26);

Line: 616

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute27',
                          p_trx_rec.global_attribute27);

Line: 619

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute28',
                          p_trx_rec.global_attribute28);

Line: 622

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute29',
                          p_trx_rec.global_attribute29);

Line: 625

   dbms_sql.bind_variable(p_update_cursor, ':global_attribute30',
                          p_trx_rec.global_attribute30);

Line: 641

 |    construct_trx_update_stmt 					    |
 |                                                                          |
 | DESCRIPTION                                                              |
 |    Copies the text of the dynamic SQL update statement into the          |
 |    out NOCOPY paramater. The update statement does not contain a where   |
 |    clause since this is the dynamic part that is added later.            |
 |                                                                          |
 | SCOPE - PRIVATE                                                          |
 |                                                                          |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                  |
 |    arp_util.debug                                                        |
 |                                                                          |
 | ARGUMENTS  : IN:                                                         |
 |                    None.                                                 |
 |              OUT:                                                        |
 |                    update_text  - text of the update statement           |
 |                                                                          |
 | RETURNS    : NONE                                                        |
 |                                                                          |
 | NOTES                                                                    |
 |   This statement only updates columns in the trx record that do not      |
 |   contain the dummy values that indicate that they should not be changed.|
 |                                                                          |
 | MODIFICATION HISTORY                                                     |
 |     06-JUN-95  Charlie Tomberg     Created                               |
 |                                                                          |
 | 20-MAR-2000  J Rautiainen    Added BR project related columns            |
 |                              BR_AMOUNT, BR_UNPAID_FLAG,BR_ON_HOLD_FLAG,  |
 |                              DRAWEE_ID, DRAWEE_CONTACT_ID,               |
 |                              DRAWEE_SITE_USE_ID, DRAWEE_BANK_ACCOUNT_ID, |
 |                              REMITTANCE_BANK_ACCOUNT_ID,   		    |
 |                              OVERRIDE_REMIT_ACCOUNT_FLAG and             |
 |                              SPECIAL_INSTRUCTIONSinto table handlers     |
 | 24-JUL-2000  J Rautiainen    Added BR project related column             |
 |                              REMITTANCE_BATCH_ID		            |
 |            							            |
 | 31-OCT-2000 Y Rakotonirainy	Bug 1243304 : Added columns                 |
 |                              address_verification_code and	            |
 |				approval_code	and                         |
 |				bill_to_address_id and		            |
 |				edi_processed_flag and		            |
 |				edi_processed_status and		    |
 |				payment_server_order_num and		    |
 |				post_request_id and			    |
 |				request_id and                              |
 |				ship_to_address_id			    |
 |				wh_update_date				    |
 | 				into the table handlers.  		    |
 |                                                                          |
 | 20-Jun-2002  Sahana    Bug2427456 Added global attribute columns         |
 +==========================================================================*/

PROCEDURE construct_trx_update_stmt( update_text OUT NOCOPY varchar2) IS

BEGIN
   arp_util.debug('arp_ct_pkg.construct_trx_update_stmt()+');

Line: 698

   update_text :=
 'UPDATE ra_customer_trx
   SET    customer_trx_id =
               DECODE(:customer_trx_id,
                      :ar_number_dummy, customer_trx_id,
                                        :customer_trx_id),
          trx_number =
               DECODE(:trx_number,
                      :ar_text_dummy, trx_number,
                                      :trx_number),
          created_by =
               DECODE(:created_by,
                      :ar_number_dummy, created_by,
                                        :created_by),
          creation_date =
               DECODE(:creation_date,
                      :ar_date_dummy, creation_date,
                                      :creation_date),
          last_updated_by =
               DECODE(:last_updated_by,
                      :ar_number_dummy, :pg_user_id,
                                        :last_updated_by),
          last_update_date =
               DECODE(:last_update_date,
                      :ar_date_dummy, sysdate,
                                      :last_update_date),
          last_update_login =
               DECODE(:last_update_login,
                      :ar_number_dummy, nvl(:pg_conc_login_id,
                                            :pg_login_id),
                                        :last_update_login),
          set_of_books_id =
               DECODE(:set_of_books_id,
                      :ar_number_dummy, set_of_books_id,
                                        :set_of_books_id),
          program_application_id =
               DECODE(:program_application_id,
                      :ar_number_dummy, program_application_id,
                                        :program_application_id),
          program_id =
               DECODE(:program_id,
                      :ar_number_dummy, program_id,
                                        :program_id),
          program_update_date =
               DECODE(:program_update_date,
                      :ar_date_dummy, program_update_date,
                                      :program_update_date),
          posting_control_id =
               DECODE(:posting_control_id,
                      :ar_number_dummy, posting_control_id,
                                        :posting_control_id),
          ra_post_loop_number =
               DECODE(:ra_post_loop_number,
                      :ar_number_dummy, ra_post_loop_number,
                                        :ra_post_loop_number),
          complete_flag =
               DECODE(:complete_flag,
                      :ar_flag_dummy, complete_flag,
                                      :complete_flag),
          initial_customer_trx_id =
               DECODE(:initial_customer_trx_id,
                      :ar_number_dummy, initial_customer_trx_id,
                                        :initial_customer_trx_id),
          previous_customer_trx_id =
               DECODE(:previous_customer_trx_id,
                      :ar_number_dummy, previous_customer_trx_id,
                                        :previous_customer_trx_id),
          related_customer_trx_id =
               DECODE(:related_customer_trx_id,
                      :ar_number_dummy, related_customer_trx_id,
                                        :related_customer_trx_id),
          recurred_from_trx_number =
               DECODE(:recurred_from_trx_number,
                      :ar_text_dummy, recurred_from_trx_number,
                                      :recurred_from_trx_number),
          cust_trx_type_id =
               DECODE(:cust_trx_type_id,
                      :ar_number_dummy, cust_trx_type_id,
                                        :cust_trx_type_id),
          batch_id =
               DECODE(:batch_id,
                      :ar_number_dummy, batch_id,
                                        :batch_id),
          batch_source_id =
               DECODE(:batch_source_id,
                      :ar_number_dummy, batch_source_id,
                                        :batch_source_id),
          agreement_id =
               DECODE(:agreement_id,
                      :ar_number_dummy, agreement_id,
                                        :agreement_id),
          trx_date =
               DECODE(:trx_date,
                      :ar_date_dummy, trx_date,
                                      :trx_date),
          bill_to_customer_id =
               DECODE(:bill_to_customer_id,
                      :ar_number_dummy, bill_to_customer_id,
                                        :bill_to_customer_id),
          bill_to_contact_id =
               DECODE(:bill_to_contact_id,
                      :ar_number_dummy, bill_to_contact_id,
                                        :bill_to_contact_id),
          bill_to_site_use_id =
               DECODE(:bill_to_site_use_id,
                      :ar_number_dummy, bill_to_site_use_id,
                                        :bill_to_site_use_id),
          ship_to_customer_id =
               DECODE(:ship_to_customer_id,
                      :ar_number_dummy, ship_to_customer_id,
                                        :ship_to_customer_id),
          ship_to_contact_id =
               DECODE(:ship_to_contact_id,
                      :ar_number_dummy, ship_to_contact_id,
                                        :ship_to_contact_id),
          ship_to_site_use_id =
               DECODE(:ship_to_site_use_id,
                      :ar_number_dummy, ship_to_site_use_id,
                                        :ship_to_site_use_id),
          sold_to_customer_id =
               DECODE(:sold_to_customer_id,
                      :ar_number_dummy, sold_to_customer_id,
                                        :sold_to_customer_id),
          sold_to_site_use_id =
               DECODE(:sold_to_site_use_id,
                      :ar_number_dummy, sold_to_site_use_id,
                                        :sold_to_site_use_id),
          sold_to_contact_id =
               DECODE(:sold_to_contact_id,
                      :ar_number_dummy, sold_to_contact_id,
                                        :sold_to_contact_id),
          customer_reference =
               DECODE(:customer_reference,
                      :ar_text_dummy, customer_reference,
                                      :customer_reference),
          customer_reference_date =
               DECODE(:customer_reference_date,
                      :ar_date_dummy, customer_reference_date,
                                      :customer_reference_date),
          credit_method_for_installments =
               DECODE(:credit_method_for_installments,
                      :ar_text_dummy, credit_method_for_installments,
                                      :credit_method_for_installments),
          credit_method_for_rules =
               DECODE(:credit_method_for_rules,
                      :ar_text_dummy, credit_method_for_rules,
                                      :credit_method_for_rules),
          start_date_commitment =
               DECODE(:start_date_commitment,
                      :ar_date_dummy, start_date_commitment,
                                      :start_date_commitment),
          end_date_commitment =
               DECODE(:end_date_commitment,
                      :ar_date_dummy, end_date_commitment,
                                      :end_date_commitment),
          exchange_date =
               DECODE(:exchange_date,
                      :ar_date_dummy, exchange_date,
                                      :exchange_date),
          exchange_rate =
               DECODE(:exchange_rate,
                      :ar_number_dummy, exchange_rate,
                                        :exchange_rate),
          exchange_rate_type =
               DECODE(:exchange_rate_type,
                      :ar_text_dummy, exchange_rate_type,
                                      :exchange_rate_type),
          customer_bank_account_id =
               DECODE(:customer_bank_account_id,
                      :ar_number_dummy, customer_bank_account_id,
                                        :customer_bank_account_id),
          finance_charges =
               DECODE(:finance_charges,
                      :ar_flag_dummy, finance_charges,
                                      :finance_charges),
          fob_point =
               DECODE(:fob_point,
                      :ar_text_dummy, fob_point,
                                      :fob_point),
          comments =
               DECODE(:comments,
                      :ar_text_dummy, comments,
                                      :comments),
          internal_notes =
               DECODE(:internal_notes,
                      :ar_text_dummy, internal_notes,
                                      :internal_notes),
          invoice_currency_code =
               DECODE(:invoice_currency_code,
                      :ar_text_dummy, invoice_currency_code,
                                      :invoice_currency_code),
          invoicing_rule_id =
               DECODE(:invoicing_rule_id,
                      :ar_number_dummy, invoicing_rule_id,
                                        :invoicing_rule_id),
          last_printed_sequence_num =
               DECODE(:last_printed_sequence_num,
                      :ar_number_dummy, last_printed_sequence_num,
                                        :last_printed_sequence_num),
          orig_system_batch_name =
               DECODE(:orig_system_batch_name,
                      :ar_text_dummy, orig_system_batch_name,
                                      :orig_system_batch_name),
          primary_salesrep_id =
               DECODE(:primary_salesrep_id,
                      :ar_number_dummy, primary_salesrep_id,
                                        :primary_salesrep_id),
          printing_count =
               DECODE(:printing_count,
                      :ar_number_dummy, printing_count,
                                        :printing_count),
          printing_last_printed =
               DECODE(:printing_last_printed,
                      :ar_date_dummy, printing_last_printed,
                                      :printing_last_printed),
          printing_option =
               DECODE(:printing_option,
                      :ar_text_dummy, printing_option,
                                      :printing_option),
          printing_original_date =
               DECODE(:printing_original_date,
                      :ar_date_dummy, printing_original_date,
                                      :printing_original_date),
          printing_pending =
               DECODE(:printing_option,
                        printing_option, printing_pending,
                              DECODE(:printing_option,
                                     ''PRI'', ''Y'',
                                     ''NOT'', ''N'',
                                              DECODE(:printing_pending,
                                                     :ar_flag_dummy,
                                                       printing_pending,
                                                       :printing_pending)
                                     )
                     ),
          purchase_order =
               DECODE(:purchase_order,
                      :ar_text_dummy, purchase_order,
                                      :purchase_order),
          purchase_order_date =
               DECODE(:purchase_order_date,
                      :ar_date_dummy, purchase_order_date,
                                      :purchase_order_date),
          purchase_order_revision =
               DECODE(:purchase_order_revision,
                      :ar_text_dummy, purchase_order_revision,
                                      :purchase_order_revision),
          receipt_method_id =
               DECODE(:receipt_method_id,
                      :ar_number_dummy, receipt_method_id,
                                        :receipt_method_id),
          remit_to_address_id =
               DECODE(:remit_to_address_id,
                      :ar_number_dummy, remit_to_address_id,
                                        :remit_to_address_id),
          shipment_id =
               DECODE(:shipment_id,
                      :ar_number_dummy, shipment_id,
                                        :shipment_id),
          ship_date_actual =
               DECODE(:ship_date_actual,
                      :ar_date_dummy, ship_date_actual,
                                      :ship_date_actual),
          ship_via =
               DECODE(:ship_via,
                      :ar_text_dummy, ship_via,
                                      :ship_via),
          term_due_date =
               DECODE(:term_due_date,
                      :ar_date_dummy, term_due_date,
                                      :term_due_date),
          term_id =
               DECODE(:term_id,
                      :ar_number_dummy, term_id,
                                        :term_id),
          territory_id =
               DECODE(:territory_id,
                      :ar_number_dummy, territory_id,
                                        :territory_id),
          waybill_number =
               DECODE(:waybill_number,
                      :ar_text_dummy, waybill_number,
                                      :waybill_number),
          status_trx =
               DECODE(:status_trx,
                      :ar_text_dummy, status_trx,
                                      :status_trx),
          reason_code =
               DECODE(:reason_code,
                      :ar_text_dummy, reason_code,
                                      :reason_code),
          doc_sequence_id =
               DECODE(:doc_sequence_id,
                      :ar_number_dummy, doc_sequence_id,
                                        :doc_sequence_id),
          doc_sequence_value =
               DECODE(:doc_sequence_value,
                      :ar_number_dummy, doc_sequence_value,
                                        :doc_sequence_value),
          paying_customer_id =
               DECODE(:paying_customer_id,
                      :ar_number_dummy, paying_customer_id,
                                        :paying_customer_id),
          paying_site_use_id =
               DECODE(:paying_site_use_id,
                      :ar_number_dummy, paying_site_use_id,
                                        :paying_site_use_id),
          related_batch_source_id =
               DECODE(:related_batch_source_id,
                      :ar_number_dummy, related_batch_source_id,
                                        :related_batch_source_id),
          default_tax_exempt_flag =
               DECODE(:default_tax_exempt_flag,
                      :ar_flag_dummy, default_tax_exempt_flag,
                                      :default_tax_exempt_flag),
          created_from =
               DECODE(:created_from,
                      :ar_text_dummy, created_from,
                                      :created_from),
          default_ussgl_trx_code_context =
               DECODE(:default_ussgl_trx_code_context,
                      :ar_text_dummy, default_ussgl_trx_code_context,
                                      :default_ussgl_trx_code_context),
          default_ussgl_transaction_code =
               DECODE(:default_ussgl_transaction_code,
                      :ar_text_dummy, default_ussgl_transaction_code,
                                      :default_ussgl_transaction_code),
          old_trx_number =
               DECODE(:old_trx_number,
                      :ar_text_dummy, old_trx_number,
                                      :old_trx_number),
          interface_header_context =
               DECODE(:interface_header_context,
                      :ar_text_dummy, interface_header_context,
                                      :interface_header_context),
          interface_header_attribute1 =
               DECODE(:interface_header_attribute1,
                      :ar_text_dummy, interface_header_attribute1,
                                      :interface_header_attribute1),
          interface_header_attribute2 =
               DECODE(:interface_header_attribute2,
                      :ar_text_dummy, interface_header_attribute2,
                                      :interface_header_attribute2),
          interface_header_attribute3 =
               DECODE(:interface_header_attribute3,
                      :ar_text_dummy, interface_header_attribute3,
                                      :interface_header_attribute3),
          interface_header_attribute4 =
               DECODE(:interface_header_attribute4,
                      :ar_text_dummy, interface_header_attribute4,
                                      :interface_header_attribute4),
          interface_header_attribute5 =
               DECODE(:interface_header_attribute5,
                      :ar_text_dummy, interface_header_attribute5,
                                      :interface_header_attribute5),
          interface_header_attribute6 =
               DECODE(:interface_header_attribute6,
                      :ar_text_dummy, interface_header_attribute6,
                                      :interface_header_attribute6),
          interface_header_attribute7 =
               DECODE(:interface_header_attribute7,
                      :ar_text_dummy, interface_header_attribute7,
                                      :interface_header_attribute7),
          interface_header_attribute8 =
               DECODE(:interface_header_attribute8,
                      :ar_text_dummy, interface_header_attribute8,
                                      :interface_header_attribute8),
          interface_header_attribute9 =
               DECODE(:interface_header_attribute9,
                      :ar_text_dummy, interface_header_attribute9,
                                      :interface_header_attribute9),
          interface_header_attribute10 =
               DECODE(:interface_header_attribute10,
                      :ar_text_dummy, interface_header_attribute10,
                                      :interface_header_attribute10),
          interface_header_attribute11 =
               DECODE(:interface_header_attribute11,
                      :ar_text_dummy, interface_header_attribute11,
                                      :interface_header_attribute11),
          interface_header_attribute12 =
               DECODE(:interface_header_attribute12,
                      :ar_text_dummy, interface_header_attribute12,
                                      :interface_header_attribute12),
          interface_header_attribute13 =
               DECODE(:interface_header_attribute13,
                      :ar_text_dummy, interface_header_attribute13,
                                      :interface_header_attribute13),
          interface_header_attribute14 =
               DECODE(:interface_header_attribute14,
                      :ar_text_dummy, interface_header_attribute14,
                                      :interface_header_attribute14),
          interface_header_attribute15 =
               DECODE(:interface_header_attribute15,
                      :ar_text_dummy, interface_header_attribute15,
                                      :interface_header_attribute15),
          attribute_category =
               DECODE(:attribute_category,
                      :ar_text_dummy, attribute_category,
                                      :attribute_category),
          attribute1 =
               DECODE(:attribute1,
                      :ar_text_dummy, attribute1,
                                      :attribute1),
          attribute2 =
               DECODE(:attribute2,
                      :ar_text_dummy, attribute2,
                                      :attribute2),
          attribute3 =
               DECODE(:attribute3,
                      :ar_text_dummy, attribute3,
                                      :attribute3),
          attribute4 =
               DECODE(:attribute4,
                      :ar_text_dummy, attribute4,
                                      :attribute4),
          attribute5 =
               DECODE(:attribute5,
                      :ar_text_dummy, attribute5,
                                      :attribute5),
          attribute6 =
               DECODE(:attribute6,
                      :ar_text_dummy, attribute6,
                                      :attribute6),
          attribute7 =
               DECODE(:attribute7,
                      :ar_text_dummy, attribute7,
                                      :attribute7),
          attribute8 =
               DECODE(:attribute8,
                      :ar_text_dummy, attribute8,
                                      :attribute8),
          attribute9 =
               DECODE(:attribute9,
                      :ar_text_dummy, attribute9,
                                      :attribute9),
          attribute10 =
               DECODE(:attribute10,
                      :ar_text_dummy, attribute10,
                                      :attribute10),
          attribute11 =
               DECODE(:attribute11,
                      :ar_text_dummy, attribute11,
                                      :attribute11),
          attribute12 =
               DECODE(:attribute12,
                      :ar_text_dummy, attribute12,
                                      :attribute12),
          attribute13 =
               DECODE(:attribute13,
                      :ar_text_dummy, attribute13,
                                      :attribute13),
          attribute14 =
               DECODE(:attribute14,
                      :ar_text_dummy, attribute14,
                                      :attribute14),
          attribute15 =
               DECODE(:attribute15,
                      :ar_text_dummy, attribute15,
                                      :attribute15),
          br_amount =
               DECODE(:br_amount,
                      :ar_number_dummy, br_amount,
                                        :br_amount),
          br_unpaid_flag =
               DECODE(:br_unpaid_flag,
                      :ar_flag_dummy, br_unpaid_flag,
                                      :br_unpaid_flag),
          br_on_hold_flag =
               DECODE(:br_on_hold_flag,
                      :ar_flag_dummy, br_on_hold_flag,
                                      :br_on_hold_flag),
          drawee_id =
               DECODE(:drawee_id,
                      :ar_number_dummy, drawee_id,
                                        :drawee_id),
          drawee_contact_id =
               DECODE(:drawee_contact_id,
                      :ar_number_dummy, drawee_contact_id,
                                        :drawee_contact_id),
          drawee_site_use_id =
               DECODE(:drawee_site_use_id,
                      :ar_number_dummy, drawee_site_use_id,
                                        :drawee_site_use_id),
          drawee_bank_account_id =
               DECODE(:drawee_bank_account_id,
                      :ar_number_dummy, drawee_bank_account_id,
                                        :drawee_bank_account_id),
          remit_bank_acct_use_id =
               DECODE(:remittance_bank_account_id,
                      :ar_number_dummy, remit_bank_acct_use_id,
                                        :remittance_bank_account_id),
          override_remit_account_flag =
               DECODE(:override_remit_account_flag,
                      :ar_flag_dummy, override_remit_account_flag,
                                      :override_remit_account_flag),
          special_instructions =
               DECODE(:special_instructions,
                      :ar_text_dummy, special_instructions,
                                      :special_instructions),
          remittance_batch_id =
               DECODE(:remittance_batch_id,
                      :ar_number_dummy, remittance_batch_id,
                                        :remittance_batch_id) ,
          address_verification_code =
               DECODE(:address_verification_code,
                      :ar_text_dummy,  address_verification_code,
                                      :address_verification_code),
          approval_code =
               DECODE(:approval_code,
                      :ar_text_dummy, approval_code,
                                      :approval_code),
           bill_to_address_id =
               DECODE(:bill_to_address_id,
                      :ar_number_dummy, bill_to_address_id,
                                      :bill_to_address_id),
           edi_processed_flag =
               DECODE(:edi_processed_flag,
                      :ar_flag_dummy, edi_processed_flag,
                                        :edi_processed_flag),
          edi_processed_status =
               DECODE(:edi_processed_status,
                      :ar_text_dummy, edi_processed_status,
                                        :edi_processed_status),
          payment_server_order_num =
               DECODE(:payment_server_order_num,
                      :ar_text_dummy, payment_server_order_num,
                                        :payment_server_order_num),
          post_request_id =
               DECODE(:post_request_id,
                      :ar_number_dummy, post_request_id,
                                      :post_request_id),
          request_id =
               DECODE(:request_id,
                      :ar_number_dummy, request_id,
                                      :request_id),
          ship_to_address_id =
               DECODE(:ship_to_address_id,
                      :ar_number_dummy, ship_to_address_id,
                                      :ship_to_address_id),
         wh_update_date =
               DECODE(:wh_update_date,
                      :ar_date_dummy,wh_update_date,
                                        :wh_update_date),
         legal_entity_id =
               DECODE(:legal_entity_id,
                      :ar_number_dummy, legal_entity_id,
                                      :legal_entity_id) ,
/* PAYMENT_UPTAKE */
         payment_trxn_extension_id =
               DECODE(:payment_trxn_extension_id,
                      :ar_number_dummy, payment_trxn_extension_id,
                                      :payment_trxn_extension_id),
         billing_date =
               DECODE(:billing_date,
                       :ar_date_dummy, billing_date,
                                      :billing_date)';

Line: 1255

   arp_util.debug('arp_ct_pkg.construct_trx_update_stmt()-');

Line: 1259

        arp_util.debug('EXCEPTION:  arp_ct_pkg.construct_trx_update_stmt()');

Line: 1270

 |    Copies the text of the dynamic SQL update statement for the            |
 |    global_attribute_category and global_attributes(1-30) into the         |
 |    out NOCOPY paramater. The update statement contains a where clause            |
 |    since this is the dynamic part that is added later.                    |
 |                                                                           |
 | SCOPE - PRIVATE                                                           |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    None						     |
 |              OUT:                                                         |
 |                    update_text  - text of the update statement	     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     22-JUN-02  skoukunt            Created for Bug2427456                 |
 |                                                                           |
 +===========================================================================*/
PROCEDURE construct_global_attr_stmt( update_text OUT NOCOPY varchar2) IS
BEGIN
   arp_util.debug('arp_ct_pkg.construct_global_attr_stmt()+');

Line: 1296

   update_text := '
         ,global_attribute_category =
               DECODE(:global_attribute_category,
                      :ar_text_dummy, global_attribute_category,
                                      :global_attribute_category),
          global_attribute1 =
               DECODE(:global_attribute1,
                      :ar_text_dummy, global_attribute1,
                                      :global_attribute1),
          global_attribute2 =
               DECODE(:global_attribute2,
                      :ar_text_dummy, global_attribute2,
                                      :global_attribute2),
          global_attribute3 =
               DECODE(:global_attribute3,
                      :ar_text_dummy, global_attribute3,
                                      :global_attribute3),
          global_attribute4 =
               DECODE(:global_attribute4,
                      :ar_text_dummy, global_attribute4,
                                      :global_attribute4),
          global_attribute5 =
               DECODE(:global_attribute5,
                      :ar_text_dummy, global_attribute5,
                                      :global_attribute5),
          global_attribute6 =
               DECODE(:global_attribute6,
                      :ar_text_dummy, global_attribute6,
                                      :global_attribute6),
          global_attribute7 =
               DECODE(:global_attribute7,
                      :ar_text_dummy, global_attribute7,
                                      :global_attribute7),
          global_attribute8 =
               DECODE(:global_attribute8,
                      :ar_text_dummy, global_attribute8,
                                      :global_attribute8),
          global_attribute9 =
               DECODE(:global_attribute9,
                      :ar_text_dummy, global_attribute9,
                                      :global_attribute9),
          global_attribute10 =
               DECODE(:global_attribute10,
                      :ar_text_dummy, global_attribute10,
                                      :global_attribute10),
          global_attribute11 =
               DECODE(:global_attribute11,
                      :ar_text_dummy, global_attribute11,
                                      :global_attribute11),
          global_attribute12 =
               DECODE(:global_attribute12,
                      :ar_text_dummy, global_attribute12,
                                      :global_attribute12),
          global_attribute13 =
               DECODE(:global_attribute13,
                      :ar_text_dummy, global_attribute13,
                                      :global_attribute13),
          global_attribute14 =
               DECODE(:global_attribute14,
                      :ar_text_dummy, global_attribute14,
                                      :global_attribute14),
          global_attribute15 =
               DECODE(:global_attribute15,
                      :ar_text_dummy, global_attribute15,
                                      :global_attribute15),
          global_attribute16 =
               DECODE(:global_attribute16,
                      :ar_text_dummy, global_attribute16,
                                      :global_attribute16),
          global_attribute17 =
               DECODE(:global_attribute17,
                      :ar_text_dummy, global_attribute17,
                                      :global_attribute17),
          global_attribute18 =
               DECODE(:global_attribute18,
                      :ar_text_dummy, global_attribute18,
                                      :global_attribute18),
          global_attribute19 =
               DECODE(:global_attribute19,
                      :ar_text_dummy, global_attribute19,
                                      :global_attribute19),
          global_attribute20 =
               DECODE(:global_attribute20,
                      :ar_text_dummy, global_attribute20,
                                      :global_attribute20),
          global_attribute21 =
               DECODE(:global_attribute21,
                      :ar_text_dummy, global_attribute21,
                                      :global_attribute21),
          global_attribute22 =
               DECODE(:global_attribute22,
                      :ar_text_dummy, global_attribute22,
                                      :global_attribute22),
          global_attribute23 =
               DECODE(:global_attribute23,
                      :ar_text_dummy, global_attribute23,
                                      :global_attribute23),
          global_attribute24 =
               DECODE(:global_attribute24,
                      :ar_text_dummy, global_attribute24,
                                      :global_attribute24),
          global_attribute25 =
               DECODE(:global_attribute25,
                      :ar_text_dummy, global_attribute25,
                                      :global_attribute25),
          global_attribute26 =
               DECODE(:global_attribute26,
                      :ar_text_dummy, global_attribute26,
                                      :global_attribute26),
          global_attribute27 =
               DECODE(:global_attribute27,
                      :ar_text_dummy, global_attribute27,
                                      :global_attribute27),
          global_attribute28 =
               DECODE(:global_attribute28,
                      :ar_text_dummy, global_attribute28,
                                      :global_attribute28),
          global_attribute29 =
               DECODE(:global_attribute29,
                      :ar_text_dummy, global_attribute29,
                                      :global_attribute29),
          global_attribute30 =
               DECODE(:global_attribute30,
                      :ar_text_dummy, global_attribute30,
                                      :global_attribute30)';

Line: 1432

 |    generic_update                                                         |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    This procedure Updates records in ra_customer_trx identified by the    |
 |    where clause that is passed in as a parameter. Only those columns in   |
 |    the trx record parameter that do not contain the special dummy values  |
 |    are updated.                                                           |
 |                                                                           |
 | SCOPE - PRIVATE                                                           |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |    dbms_sql.open_cursor 						     |
 |    dbms_sql.parse							     |
 |    dbms_sql.execute							     |
 |    dbms_sql.close_cursor						     |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |		      p_update_cursor  - identifies the cursor to use 	     |
 |                    p_where_clause   - identifies which rows to update     |
 | 		      p_where1         - value to bind into where clause     |
 |		      p_trx_rec        - contains the new trx values         |
 |              OUT:                                                         |
 |                    None						     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     06-JUN-95  Charlie Tomberg     Created                                |
 |     08-NOV-01  Debbie Jancis	      Added calls to MRC engine for          |
 |                                    RA_CUSTOMER_TRX processing             |
 |                                                                           |
 +===========================================================================*/

PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
			 p_where_clause      IN varchar2,
			 p_where1            IN number,
                         p_trx_rec           IN ra_customer_trx%rowtype) IS

   l_count             number;

Line: 1474

   l_update_statement_1  varchar2(30000);

Line: 1475

   l_update_statement_2  varchar2(30000);

Line: 1476

   l_update_statement  long;

Line: 1480

   arp_util.debug('arp_ct_pkg.generic_update()+');

Line: 1483

   |  If this update statement has not already been parsed, 	  |
   |  construct the statement and parse it.			  |
   |  Otherwise, use the already parsed statement and rebind its  |
   |  variables.						  |
   +--------------------------------------------------------------*/

   IF (p_update_cursor is null)
   THEN

         p_update_cursor := dbms_sql.open_cursor;

Line: 1495

          |  Construct the update statement |
          +---------------------------------*/

         arp_ct_pkg.construct_trx_update_stmt(l_update_statement_1);

Line: 1499

         arp_ct_pkg.construct_global_attr_stmt(l_update_statement_2);

Line: 1501

         l_update_statement := l_update_statement_1 || l_update_statement_2;

Line: 1503

         l_update_statement := l_update_statement || p_where_clause;

Line: 1509

         l_update_statement := l_update_statement ||
             ' RETURNING customer_trx_id INTO :ctrx_key_value ';

Line: 1516

         dbms_sql.parse(p_update_cursor,
                        l_update_statement,
                        dbms_sql.v7);

Line: 1522

   arp_ct_pkg.bind_trx_variables(p_update_cursor, p_trx_rec);

Line: 1528

   dbms_sql.bind_array(p_update_cursor, ':ctrx_key_value',
                        ctrx_array);

Line: 1535

   dbms_sql.bind_variable(p_update_cursor, ':where_1',
                          p_where1);

Line: 1538

   l_count := dbms_sql.execute(p_update_cursor);

Line: 1540

   arp_util.debug( to_char(l_count) || ' rows updated');

Line: 1546

    dbms_sql.variable_value( p_update_cursor, ':ctrx_key_value', ctrx_array);

Line: 1550

    |  Raise the NO_DATA_FOUND exception if no rows were updated |
    +------------------------------------------------------------*/

   IF  (l_count = 0)
   THEN RAISE NO_DATA_FOUND;

Line: 1560

        | call mrc engine to update RA_MC_CUSTOMER_TRX   |
        +------------------------------------------------*/
--       ar_mrc_engine.maintain_mrc_data(
--                        p_event_mode       => 'UPDATE',
--                        p_table_name       => 'RA_CUSTOMER_TRX',
--                        p_mode             => 'SINGLE',
--                        p_key_value        => ctrx_array(I));

Line: 1571

   arp_util.debug('arp_ct_pkg.generic_update()-');

Line: 1575

        arp_util.debug('EXCEPTION:  arp_ct_pkg.generic_update()');

Line: 1576

        arp_util.debug(l_update_statement);

Line: 1633

 |				wh_update_date				     |
 | 				into the table handlers.  	             |
 | 20-Jun-2002 Sahana           Bug2427456 : Added Global Attribute Columns  |
 +===========================================================================*/

PROCEDURE set_to_dummy( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype) IS

BEGIN

    arp_util.debug('arp_ct_pkg.set_to_dummy()+');

Line: 1648

    p_trx_rec.last_updated_by := 		AR_NUMBER_DUMMY;

Line: 1649

    p_trx_rec.last_update_date := 		AR_DATE_DUMMY;

Line: 1650

    p_trx_rec.last_update_login := 		AR_NUMBER_DUMMY;

Line: 1654

    p_trx_rec.program_update_date := 		AR_DATE_DUMMY;

Line: 1777

    p_trx_rec.wh_update_date           	     := AR_DATE_DUMMY;

Line: 1862

    SELECT customer_trx_id
    INTO   l_customer_trx_id
    FROM   ra_customer_trx
    WHERE  customer_trx_id = p_customer_trx_id
    FOR UPDATE OF customer_trx_id NOWAIT;

Line: 1911

    SELECT        *
    INTO          p_trx_rec
    FROM          ra_customer_trx
    WHERE         customer_trx_id = p_customer_trx_id
    FOR UPDATE OF customer_trx_id NOWAIT;

Line: 1932

 |    changed from when they were first selected in the form.		      |
 |                                                                            |
 | SCOPE - PUBLIC                                                             |
 |                                                                            |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                    |
 |    arp_util.debug                                                          |
 |                                                                            |
 | ARGUMENTS  : IN:                                                           |
 |                    p_customer_trx_id	- identifies the row to lock	      |
 | 		      p_trx_rec    	- trx record for comparison	      |
 |              OUT:                                                          |
 |                    None						      |
 |                                                                            |
 | RETURNS    : NONE                                                          |
 |                                                                            |
 | NOTES                                                                      |
 |                                                                            |
 | MODIFICATION HISTORY                                                       |
 | 07-JUN-95    Charlie Tomberg Created                                       |
 | 29-JUN-95    Charlie Tomberg Modified to use select for update             |
 | 20-MAR-2000  J Rautiainen    Added BR project related columns              |
 |                              BR_AMOUNT, BR_UNPAID_FLAG,BR_ON_HOLD_FLAG,    |
 |                              DRAWEE_ID, DRAWEE_CONTACT_ID,                 |
 |                              DRAWEE_SITE_USE_ID   		              |
 |                              DRAWEE_BANK_ACCOUNT_ID,                       |
 |                              REMITTANCE_BANK_ACCOUNT_ID,		      |
 |                              OVERRIDE_REMIT_ACCOUNT_FLAG and               |
 |                              SPECIAL_INSTRUCTIONSinto table handlers       |
 | 24-JUL-2000  J Rautiainen    Added BR project related column               |
 |                              REMITTANCE_BATCH_ID		              |
 | 31-OCT-2000 Y Rakotonirainy	Bug 1243304 : Added columns                   |
 |                              address_verification_code and	              |
 |				approval_code	and			      |
 |				bill_to_address_id and			      |
 |				edi_processed_flag and			      |
 |				edi_processed_status and		      |
 |				payment_server_order_num and		      |
 |				post_request_id and			      |
 |				request_id and				      |
 |				ship_to_address_id			      |
 |				wh_update_date				      |
 | 				into the table handlers.  		      |
 |                                                                            |
 | 20-Jun-2002  Sahana          Bug2427456: Added global attribute columns    |
 | 18-May-2005  Debbie Jancis   Added Legal entity Id for LE project          |
 | 09-Aug-2005  Surendra Rajan  Added payment_trxn_extension_id               |
 +============================================================================*/

PROCEDURE lock_compare_p( p_trx_rec          IN ra_customer_trx%rowtype,
                          p_customer_trx_id  IN
                                     ra_customer_trx.customer_trx_id%type,
                          p_lock_trx_flag    IN BOOLEAN DEFAULT TRUE) IS

    l_new_trx_rec  ra_customer_trx%rowtype;

Line: 1991

    SELECT   *
    INTO     l_new_trx_rec
    FROM     ra_customer_trx trx
    WHERE    trx.customer_trx_id = p_customer_trx_id
    AND
       (
           NVL(trx.trx_number, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.trx_number,
                        AR_TEXT_DUMMY, trx.trx_number,
                                       p_trx_rec.trx_number),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.customer_trx_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.customer_trx_id,
                        AR_NUMBER_DUMMY, trx.customer_trx_id,
                                       p_trx_rec.customer_trx_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.created_by, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.created_by,
                        AR_NUMBER_DUMMY, trx.created_by,
                                       p_trx_rec.created_by),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.creation_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.creation_date),
                        AR_DATE_DUMMY, TRUNC(trx.creation_date),
                                       TRUNC(p_trx_rec.creation_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.last_updated_by, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.last_updated_by,
                        AR_NUMBER_DUMMY, trx.last_updated_by,
                                       p_trx_rec.last_updated_by),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.last_update_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.last_update_date),
                        AR_DATE_DUMMY, TRUNC(trx.last_update_date),
                                       TRUNC(p_trx_rec.last_update_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.last_update_login, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.last_update_login,
                        AR_NUMBER_DUMMY, trx.last_update_login,
                                       p_trx_rec.last_update_login),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.set_of_books_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.set_of_books_id,
                        AR_NUMBER_DUMMY, trx.set_of_books_id,
                                       p_trx_rec.set_of_books_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.program_application_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.program_application_id,
                        AR_NUMBER_DUMMY, trx.program_application_id,
                                       p_trx_rec.program_application_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.program_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.program_id,
                        AR_NUMBER_DUMMY, trx.program_id,
                                       p_trx_rec.program_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.program_update_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.program_update_date),
                        AR_DATE_DUMMY, TRUNC(trx.program_update_date),
                                       TRUNC(p_trx_rec.program_update_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.posting_control_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.posting_control_id,
                        AR_NUMBER_DUMMY, trx.posting_control_id,
                                       p_trx_rec.posting_control_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ra_post_loop_number, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ra_post_loop_number,
                        AR_NUMBER_DUMMY, trx.ra_post_loop_number,
                                       p_trx_rec.ra_post_loop_number),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.complete_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.complete_flag,
                        AR_FLAG_DUMMY, trx.complete_flag,
                                       p_trx_rec.complete_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.initial_customer_trx_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.initial_customer_trx_id,
                        AR_NUMBER_DUMMY, trx.initial_customer_trx_id,
                                       p_trx_rec.initial_customer_trx_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.previous_customer_trx_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.previous_customer_trx_id,
                        AR_NUMBER_DUMMY, trx.previous_customer_trx_id,
                                       p_trx_rec.previous_customer_trx_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.related_customer_trx_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.related_customer_trx_id,
                        AR_NUMBER_DUMMY, trx.related_customer_trx_id,
                                       p_trx_rec.related_customer_trx_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.recurred_from_trx_number, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.recurred_from_trx_number,
                        AR_TEXT_DUMMY, trx.recurred_from_trx_number,
                                       p_trx_rec.recurred_from_trx_number),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.cust_trx_type_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.cust_trx_type_id,
                        AR_NUMBER_DUMMY, trx.cust_trx_type_id,
                                       p_trx_rec.cust_trx_type_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.batch_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.batch_id,
                        AR_NUMBER_DUMMY, trx.batch_id,
                                       p_trx_rec.batch_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.batch_source_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.batch_source_id,
                        AR_NUMBER_DUMMY, trx.batch_source_id,
                                       p_trx_rec.batch_source_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.agreement_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.agreement_id,
                        AR_NUMBER_DUMMY, trx.agreement_id,
                                       p_trx_rec.agreement_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.trx_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.trx_date),
                        AR_DATE_DUMMY, TRUNC(trx.trx_date),
                                       TRUNC(p_trx_rec.trx_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.bill_to_customer_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.bill_to_customer_id,
                        AR_NUMBER_DUMMY, trx.bill_to_customer_id,
                                       p_trx_rec.bill_to_customer_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.bill_to_contact_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.bill_to_contact_id,
                        AR_NUMBER_DUMMY, trx.bill_to_contact_id,
                                       p_trx_rec.bill_to_contact_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.bill_to_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.bill_to_site_use_id,
                        AR_NUMBER_DUMMY, trx.bill_to_site_use_id,
                                       p_trx_rec.bill_to_site_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ship_to_customer_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_to_customer_id,
                        AR_NUMBER_DUMMY, trx.ship_to_customer_id,
                                       p_trx_rec.ship_to_customer_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ship_to_contact_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_to_contact_id,
                        AR_NUMBER_DUMMY, trx.ship_to_contact_id,
                                       p_trx_rec.ship_to_contact_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ship_to_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_to_site_use_id,
                        AR_NUMBER_DUMMY, trx.ship_to_site_use_id,
                                       p_trx_rec.ship_to_site_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.sold_to_customer_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.sold_to_customer_id,
                        AR_NUMBER_DUMMY, trx.sold_to_customer_id,
                                       p_trx_rec.sold_to_customer_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.sold_to_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.sold_to_site_use_id,
                        AR_NUMBER_DUMMY, trx.sold_to_site_use_id,
                                       p_trx_rec.sold_to_site_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.sold_to_contact_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.sold_to_contact_id,
                        AR_NUMBER_DUMMY, trx.sold_to_contact_id,
                                       p_trx_rec.sold_to_contact_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.customer_reference, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.customer_reference,
                        AR_TEXT_DUMMY, trx.customer_reference,
                                       p_trx_rec.customer_reference),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(TRUNC(trx.customer_reference_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.customer_reference_date),
                        AR_DATE_DUMMY, TRUNC(trx.customer_reference_date),
                                     TRUNC(p_trx_rec.customer_reference_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.credit_method_for_installments, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.credit_method_for_installments,
                        AR_TEXT_DUMMY, trx.credit_method_for_installments,
                                     p_trx_rec.credit_method_for_installments),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.credit_method_for_rules, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.credit_method_for_rules,
                        AR_TEXT_DUMMY, trx.credit_method_for_rules,
                                       p_trx_rec.credit_method_for_rules),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(TRUNC(trx.start_date_commitment), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.start_date_commitment),
                        AR_DATE_DUMMY, TRUNC(trx.start_date_commitment),
                                       TRUNC(p_trx_rec.start_date_commitment)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(TRUNC(trx.end_date_commitment), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.end_date_commitment),
                        AR_DATE_DUMMY, TRUNC(trx.end_date_commitment),
                                       TRUNC(p_trx_rec.end_date_commitment)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(TRUNC(trx.exchange_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.exchange_date),
                        AR_DATE_DUMMY, TRUNC(trx.exchange_date),
                                       TRUNC(p_trx_rec.exchange_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.exchange_rate, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.exchange_rate,
                        AR_NUMBER_DUMMY, trx.exchange_rate,
                                       p_trx_rec.exchange_rate),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.exchange_rate_type, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.exchange_rate_type,
                        AR_TEXT_DUMMY, trx.exchange_rate_type,
                                       p_trx_rec.exchange_rate_type),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.customer_bank_account_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.customer_bank_account_id,
                        AR_NUMBER_DUMMY, trx.customer_bank_account_id,
                                       p_trx_rec.customer_bank_account_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.finance_charges, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.finance_charges,
                        AR_FLAG_DUMMY, trx.finance_charges,
                                       p_trx_rec.finance_charges),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.fob_point, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.fob_point,
                        AR_TEXT_DUMMY, trx.fob_point,
                                       p_trx_rec.fob_point),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.comments, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.comments,
                        AR_TEXT_DUMMY, trx.comments,
                                       p_trx_rec.comments),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.internal_notes, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.internal_notes,
                        AR_TEXT_DUMMY, trx.internal_notes,
                                       p_trx_rec.internal_notes),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.invoice_currency_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.invoice_currency_code,
                        AR_TEXT_DUMMY, trx.invoice_currency_code,
                                       p_trx_rec.invoice_currency_code),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.invoicing_rule_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.invoicing_rule_id,
                        AR_NUMBER_DUMMY, trx.invoicing_rule_id,
                                       p_trx_rec.invoicing_rule_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.last_printed_sequence_num, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.last_printed_sequence_num,
                        AR_NUMBER_DUMMY, trx.last_printed_sequence_num,
                                       p_trx_rec.last_printed_sequence_num),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.orig_system_batch_name, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.orig_system_batch_name,
                        AR_TEXT_DUMMY, trx.orig_system_batch_name,
                                       p_trx_rec.orig_system_batch_name),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.primary_salesrep_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.primary_salesrep_id,
                        AR_NUMBER_DUMMY, trx.primary_salesrep_id,
                                       p_trx_rec.primary_salesrep_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.printing_count, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.printing_count,
                        AR_NUMBER_DUMMY, trx.printing_count,
                                       p_trx_rec.printing_count),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.printing_last_printed), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.printing_last_printed),
                        AR_DATE_DUMMY, TRUNC(trx.printing_last_printed),
                                       TRUNC(p_trx_rec.printing_last_printed)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.printing_option, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.printing_option,
                        AR_TEXT_DUMMY, trx.printing_option,
                                       p_trx_rec.printing_option),
                 AR_TEXT_DUMMY
              )
       )
     AND
       (
           NVL(TRUNC(trx.printing_original_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.printing_original_date),
                        AR_DATE_DUMMY, TRUNC(trx.printing_original_date),
                                       TRUNC(p_trx_rec.printing_original_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.printing_pending, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.printing_pending,
                        AR_FLAG_DUMMY, trx.printing_pending,
                                       p_trx_rec.printing_pending),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.purchase_order, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.purchase_order,
                        AR_TEXT_DUMMY, trx.purchase_order,
                                       p_trx_rec.purchase_order),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(TRUNC(trx.purchase_order_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.purchase_order_date),
                        AR_DATE_DUMMY, TRUNC(trx.purchase_order_date),
                                       TRUNC(p_trx_rec.purchase_order_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.purchase_order_revision, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.purchase_order_revision,
                        AR_TEXT_DUMMY, trx.purchase_order_revision,
                                       p_trx_rec.purchase_order_revision),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.receipt_method_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.receipt_method_id,
                        AR_NUMBER_DUMMY, trx.receipt_method_id,
                                       p_trx_rec.receipt_method_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.remit_to_address_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.remit_to_address_id,
                        AR_NUMBER_DUMMY, trx.remit_to_address_id,
                                       p_trx_rec.remit_to_address_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.shipment_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.shipment_id,
                        AR_NUMBER_DUMMY, trx.shipment_id,
                                       p_trx_rec.shipment_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.ship_date_actual), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.ship_date_actual),
                        AR_DATE_DUMMY, TRUNC(trx.ship_date_actual),
                                       TRUNC(p_trx_rec.ship_date_actual)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.ship_via, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_via,
                        AR_TEXT_DUMMY, trx.ship_via,
                                       p_trx_rec.ship_via),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(TRUNC(trx.term_due_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.term_due_date),
                        AR_DATE_DUMMY, TRUNC(trx.term_due_date),
                                       TRUNC(p_trx_rec.term_due_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.term_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.term_id,
                        AR_NUMBER_DUMMY, trx.term_id,
                                       p_trx_rec.term_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.territory_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.territory_id,
                        AR_NUMBER_DUMMY, trx.territory_id,
                                       p_trx_rec.territory_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.waybill_number, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.waybill_number,
                        AR_TEXT_DUMMY, trx.waybill_number,
                                       p_trx_rec.waybill_number),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.status_trx, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.status_trx,
                        AR_TEXT_DUMMY, trx.status_trx,
                                       p_trx_rec.status_trx),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.reason_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.reason_code,
                        AR_TEXT_DUMMY, trx.reason_code,
                                       p_trx_rec.reason_code),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.doc_sequence_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.doc_sequence_id,
                        AR_NUMBER_DUMMY, trx.doc_sequence_id,
                                       p_trx_rec.doc_sequence_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.doc_sequence_value, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.doc_sequence_value,
                        AR_NUMBER_DUMMY, trx.doc_sequence_value,
                                       p_trx_rec.doc_sequence_value),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.paying_customer_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.paying_customer_id,
                        AR_NUMBER_DUMMY, trx.paying_customer_id,
                                       p_trx_rec.paying_customer_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.paying_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.paying_site_use_id,
                        AR_NUMBER_DUMMY, trx.paying_site_use_id,
                                       p_trx_rec.paying_site_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.related_batch_source_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.related_batch_source_id,
                        AR_NUMBER_DUMMY, trx.related_batch_source_id,
                                       p_trx_rec.related_batch_source_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.default_tax_exempt_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.default_tax_exempt_flag,
                        AR_FLAG_DUMMY, trx.default_tax_exempt_flag,
                                       p_trx_rec.default_tax_exempt_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.created_from, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.created_from,
                        AR_TEXT_DUMMY, trx.created_from,
                                       p_trx_rec.created_from),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.default_ussgl_trx_code_context, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.default_ussgl_trx_code_context,
                        AR_TEXT_DUMMY, trx.default_ussgl_trx_code_context,
                                     p_trx_rec.default_ussgl_trx_code_context),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.default_ussgl_transaction_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.default_ussgl_transaction_code,
                        AR_TEXT_DUMMY, trx.default_ussgl_transaction_code,
                                     p_trx_rec.default_ussgl_transaction_code),
                 AR_TEXT_DUMMY
              )
	AND
           NVL(trx.old_trx_number, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.old_trx_number,
                        AR_TEXT_DUMMY, trx.old_trx_number,
                                       p_trx_rec.old_trx_number),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_context, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_context,
                        AR_TEXT_DUMMY, trx.interface_header_context,
                                       p_trx_rec.interface_header_context),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute1, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute1,
                        AR_TEXT_DUMMY, trx.interface_header_attribute1,
                                       p_trx_rec.interface_header_attribute1),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute2, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute2,
                        AR_TEXT_DUMMY, trx.interface_header_attribute2,
                                       p_trx_rec.interface_header_attribute2),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute3, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute3,
                        AR_TEXT_DUMMY, trx.interface_header_attribute3,
                                       p_trx_rec.interface_header_attribute3),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute4, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute4,
                        AR_TEXT_DUMMY, trx.interface_header_attribute4,
                                       p_trx_rec.interface_header_attribute4),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute5, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute5,
                        AR_TEXT_DUMMY, trx.interface_header_attribute5,
                                       p_trx_rec.interface_header_attribute5),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute6, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute6,
                        AR_TEXT_DUMMY, trx.interface_header_attribute6,
                                       p_trx_rec.interface_header_attribute6),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute7, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute7,
                        AR_TEXT_DUMMY, trx.interface_header_attribute7,
                                       p_trx_rec.interface_header_attribute7),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute8, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute8,
                        AR_TEXT_DUMMY, trx.interface_header_attribute8,
                                       p_trx_rec.interface_header_attribute8),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute9, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute9,
                        AR_TEXT_DUMMY, trx.interface_header_attribute9,
                                       p_trx_rec.interface_header_attribute9),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute10, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute10,
                        AR_TEXT_DUMMY, trx.interface_header_attribute10,
                                       p_trx_rec.interface_header_attribute10),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute11, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute11,
                        AR_TEXT_DUMMY, trx.interface_header_attribute11,
                                       p_trx_rec.interface_header_attribute11),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute12, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute12,
                        AR_TEXT_DUMMY, trx.interface_header_attribute12,
                                       p_trx_rec.interface_header_attribute12),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute13, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute13,
                        AR_TEXT_DUMMY, trx.interface_header_attribute13,
                                       p_trx_rec.interface_header_attribute13),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute14, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute14,
                        AR_TEXT_DUMMY, trx.interface_header_attribute14,
                                       p_trx_rec.interface_header_attribute14),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute15, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute15,
                        AR_TEXT_DUMMY, trx.interface_header_attribute15,
                                       p_trx_rec.interface_header_attribute15),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute_category, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute_category,
                        AR_TEXT_DUMMY, trx.attribute_category,
                                       p_trx_rec.attribute_category),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute1, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute1,
                        AR_TEXT_DUMMY, trx.attribute1,
                                       p_trx_rec.attribute1),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute2, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute2,
                        AR_TEXT_DUMMY, trx.attribute2,
                                       p_trx_rec.attribute2),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute3, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute3,
                        AR_TEXT_DUMMY, trx.attribute3,
                                       p_trx_rec.attribute3),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute4, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute4,
                        AR_TEXT_DUMMY, trx.attribute4,
                                       p_trx_rec.attribute4),
                 AR_TEXT_DUMMY
              )
       )
     AND
       (
           NVL(trx.attribute5, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute5,
                        AR_TEXT_DUMMY, trx.attribute5,
                                       p_trx_rec.attribute5),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute6, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute6,
                        AR_TEXT_DUMMY, trx.attribute6,
                                       p_trx_rec.attribute6),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute7, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute7,
                        AR_TEXT_DUMMY, trx.attribute7,
                                       p_trx_rec.attribute7),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute8, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute8,
                        AR_TEXT_DUMMY, trx.attribute8,
                                       p_trx_rec.attribute8),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute9, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute9,
                        AR_TEXT_DUMMY, trx.attribute9,
                                       p_trx_rec.attribute9),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute10, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute10,
                        AR_TEXT_DUMMY, trx.attribute10,
                                       p_trx_rec.attribute10),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute11, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute11,
                        AR_TEXT_DUMMY, trx.attribute11,
                                       p_trx_rec.attribute11),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute12, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute12,
                        AR_TEXT_DUMMY, trx.attribute12,
                                       p_trx_rec.attribute12),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute13, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute13,
                        AR_TEXT_DUMMY, trx.attribute13,
                                       p_trx_rec.attribute13),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute14, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute14,
                        AR_TEXT_DUMMY, trx.attribute14,
                                       p_trx_rec.attribute14),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute15, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute15,
                        AR_TEXT_DUMMY, trx.attribute15,
                                       p_trx_rec.attribute15),
                 AR_TEXT_DUMMY
              )

         AND
           NVL(trx.br_amount, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.br_amount,
                        AR_NUMBER_DUMMY, trx.br_amount,
                                         p_trx_rec.br_amount),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.br_unpaid_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.br_unpaid_flag,
                        AR_FLAG_DUMMY, trx.br_unpaid_flag,
                                         p_trx_rec.br_unpaid_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.br_on_hold_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.br_on_hold_flag,
                        AR_FLAG_DUMMY, trx.br_on_hold_flag,
                                         p_trx_rec.br_on_hold_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.drawee_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.drawee_id,
                        AR_NUMBER_DUMMY, trx.drawee_id,
                                         p_trx_rec.drawee_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.drawee_contact_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.drawee_contact_id,
                        AR_NUMBER_DUMMY, trx.drawee_contact_id,
                                         p_trx_rec.drawee_contact_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.drawee_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.drawee_site_use_id,
                        AR_NUMBER_DUMMY, trx.drawee_site_use_id,
                                         p_trx_rec.drawee_site_use_id),
                 AR_NUMBER_DUMMY
              )
/*Bug7313869, Removed the check for drawee_bank_account_id*/
         AND
           NVL(trx.remit_bank_acct_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.remit_bank_acct_use_id,
                        AR_NUMBER_DUMMY, trx.remit_bank_acct_use_id,
                                         p_trx_rec.remit_bank_acct_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.override_remit_account_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.override_remit_account_flag,
                        AR_FLAG_DUMMY, trx.override_remit_account_flag,
                                         p_trx_rec.override_remit_account_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.special_instructions, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.special_instructions,
                        AR_TEXT_DUMMY, trx.special_instructions,
                                         p_trx_rec.special_instructions),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.remittance_batch_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.remittance_batch_id,
                        AR_NUMBER_DUMMY, trx.remittance_batch_id,
                                         p_trx_rec.remittance_batch_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.address_verification_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.address_verification_code,
                        AR_TEXT_DUMMY, trx.address_verification_code,
                                         p_trx_rec.address_verification_code),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.approval_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.approval_code,
                        AR_TEXT_DUMMY, trx.approval_code,
                                         p_trx_rec.approval_code),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.bill_to_address_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.bill_to_address_id,
                        AR_NUMBER_DUMMY, trx.bill_to_address_id,
                                         p_trx_rec.bill_to_address_id),
                 AR_NUMBER_DUMMY
              )
          AND
           NVL(trx.edi_processed_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.edi_processed_flag,
                        AR_FLAG_DUMMY, trx.edi_processed_flag,
                                         p_trx_rec.edi_processed_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.edi_processed_status, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.edi_processed_status,
                        AR_TEXT_DUMMY, trx.edi_processed_status,
                                         p_trx_rec.edi_processed_status),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.payment_server_order_num, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.payment_server_order_num,
                        AR_TEXT_DUMMY, trx.payment_server_order_num,
                                         p_trx_rec.payment_server_order_num),
                 AR_TEXT_DUMMY
              )
          AND
           NVL(trx.post_request_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.post_request_id,
                        AR_NUMBER_DUMMY, trx.post_request_id,
                                         p_trx_rec.post_request_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.request_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.request_id,
                        AR_NUMBER_DUMMY, trx.request_id,
                                         p_trx_rec.request_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ship_to_address_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_to_address_id,
                        AR_NUMBER_DUMMY, trx.ship_to_address_id,
                                         p_trx_rec.ship_to_address_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.wh_update_date, AR_DATE_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.wh_update_date,
                        AR_DATE_DUMMY, trx.wh_update_date,
                                         p_trx_rec.wh_update_date),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.global_attribute_category, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute_category,
                        AR_TEXT_DUMMY, trx.global_attribute_category,
                                       p_trx_rec.global_attribute_category),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute1, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute1,
                        AR_TEXT_DUMMY, trx.global_attribute1,
                                       p_trx_rec.global_attribute1),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute2, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute2,
                        AR_TEXT_DUMMY, trx.global_attribute2,
                                       p_trx_rec.global_attribute2),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute3, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute3,
                        AR_TEXT_DUMMY, trx.global_attribute3,
                                       p_trx_rec.global_attribute3),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute4, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute4,
                        AR_TEXT_DUMMY, trx.global_attribute4,
                                       p_trx_rec.global_attribute4),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute5, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute5,
                        AR_TEXT_DUMMY, trx.global_attribute5,
                                       p_trx_rec.global_attribute5),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute6, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute6,
                        AR_TEXT_DUMMY, trx.global_attribute6,
                                       p_trx_rec.global_attribute6),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute7, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute7,
                        AR_TEXT_DUMMY, trx.global_attribute7,
                                       p_trx_rec.global_attribute7),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute8, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute8,
                        AR_TEXT_DUMMY, trx.global_attribute8,
                                       p_trx_rec.global_attribute8),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute9, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute9,
                        AR_TEXT_DUMMY, trx.global_attribute9,
                                       p_trx_rec.global_attribute9),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute10, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute10,
                        AR_TEXT_DUMMY, trx.global_attribute10,
                                       p_trx_rec.global_attribute10),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute11, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute11,
                        AR_TEXT_DUMMY, trx.global_attribute11,
                                       p_trx_rec.global_attribute11),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute12, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute12,
                        AR_TEXT_DUMMY, trx.global_attribute12,
                                       p_trx_rec.global_attribute12),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute13, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute13,
                        AR_TEXT_DUMMY, trx.global_attribute13,
                                       p_trx_rec.global_attribute13),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute14, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute14,
                        AR_TEXT_DUMMY, trx.global_attribute14,
                                       p_trx_rec.global_attribute14),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute15, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute15,
                        AR_TEXT_DUMMY, trx.global_attribute15,
                                       p_trx_rec.global_attribute15),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute16, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute16,
                        AR_TEXT_DUMMY, trx.global_attribute16,
                                       p_trx_rec.global_attribute16),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute17, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute17,
                        AR_TEXT_DUMMY, trx.global_attribute17,
                                       p_trx_rec.global_attribute17),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute18, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute18,
                        AR_TEXT_DUMMY, trx.global_attribute18,
                                       p_trx_rec.global_attribute18),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute19, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute19,
                        AR_TEXT_DUMMY, trx.global_attribute19,
                                       p_trx_rec.global_attribute19),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute20, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute20,
                        AR_TEXT_DUMMY, trx.global_attribute20,
                                       p_trx_rec.global_attribute20),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute21, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute21,
                        AR_TEXT_DUMMY, trx.global_attribute21,
                                       p_trx_rec.global_attribute21),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute22, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute22,
                        AR_TEXT_DUMMY, trx.global_attribute22,
                                       p_trx_rec.global_attribute22),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute23, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute23,
                        AR_TEXT_DUMMY, trx.global_attribute23,
                                       p_trx_rec.global_attribute23),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute24, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute24,
                        AR_TEXT_DUMMY, trx.global_attribute24,
                                       p_trx_rec.global_attribute24),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute25, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute25,
                        AR_TEXT_DUMMY, trx.global_attribute25,
                                       p_trx_rec.global_attribute25),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute26, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute26,
                        AR_TEXT_DUMMY, trx.global_attribute26,
                                       p_trx_rec.global_attribute26),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute27, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute27,
                        AR_TEXT_DUMMY, trx.global_attribute27,
                                       p_trx_rec.global_attribute27),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute28, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute28,
                        AR_TEXT_DUMMY, trx.global_attribute28,
                                       p_trx_rec.global_attribute28),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute29, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute29,
                        AR_TEXT_DUMMY, trx.global_attribute29,
                                       p_trx_rec.global_attribute29),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute30, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute30,
                        AR_TEXT_DUMMY, trx.global_attribute30,
                                       p_trx_rec.global_attribute30),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.legal_entity_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.legal_entity_id,
                        AR_NUMBER_DUMMY, trx.legal_entity_id,
                                       p_trx_rec.legal_entity_id),
                 AR_NUMBER_DUMMY
              )
      )
        AND
           NVL(trx.payment_trxn_extension_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.payment_trxn_extension_id,
                        AR_NUMBER_DUMMY, trx.payment_trxn_extension_id,
                                       p_trx_rec.payment_trxn_extension_id),
                 AR_NUMBER_DUMMY
              )  /* PAYMENT_UPAKE */
        AND
           NVL(trx.billing_date, AR_DATE_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.billing_date,
                        AR_DATE_DUMMY, trx.billing_date,
                                       p_trx_rec.billing_date),
                 AR_DATE_DUMMY
              )

    FOR UPDATE OF customer_trx_id NOWAIT;

Line: 3334

    SELECT   *
    INTO     l_new_trx_rec
    FROM     ra_customer_trx trx
    WHERE    trx.customer_trx_id = p_customer_trx_id
    AND
       (
           NVL(trx.trx_number, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.trx_number,
                        AR_TEXT_DUMMY, trx.trx_number,
                                       p_trx_rec.trx_number),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.customer_trx_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.customer_trx_id,
                        AR_NUMBER_DUMMY, trx.customer_trx_id,
                                       p_trx_rec.customer_trx_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.created_by, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.created_by,
                        AR_NUMBER_DUMMY, trx.created_by,
                                       p_trx_rec.created_by),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.creation_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.creation_date),
                        AR_DATE_DUMMY, TRUNC(trx.creation_date),
                                       TRUNC(p_trx_rec.creation_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.last_updated_by, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.last_updated_by,
                        AR_NUMBER_DUMMY, trx.last_updated_by,
                                       p_trx_rec.last_updated_by),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.last_update_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.last_update_date),
                        AR_DATE_DUMMY, TRUNC(trx.last_update_date),
                                       TRUNC(p_trx_rec.last_update_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.last_update_login, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.last_update_login,
                        AR_NUMBER_DUMMY, trx.last_update_login,
                                       p_trx_rec.last_update_login),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.set_of_books_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.set_of_books_id,
                        AR_NUMBER_DUMMY, trx.set_of_books_id,
                                       p_trx_rec.set_of_books_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.program_application_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.program_application_id,
                        AR_NUMBER_DUMMY, trx.program_application_id,
                                       p_trx_rec.program_application_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.program_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.program_id,
                        AR_NUMBER_DUMMY, trx.program_id,
                                       p_trx_rec.program_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.program_update_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.program_update_date),
                        AR_DATE_DUMMY, TRUNC(trx.program_update_date),
                                       TRUNC(p_trx_rec.program_update_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.posting_control_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.posting_control_id,
                        AR_NUMBER_DUMMY, trx.posting_control_id,
                                       p_trx_rec.posting_control_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ra_post_loop_number, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ra_post_loop_number,
                        AR_NUMBER_DUMMY, trx.ra_post_loop_number,
                                       p_trx_rec.ra_post_loop_number),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.complete_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.complete_flag,
                        AR_FLAG_DUMMY, trx.complete_flag,
                                       p_trx_rec.complete_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.initial_customer_trx_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.initial_customer_trx_id,
                        AR_NUMBER_DUMMY, trx.initial_customer_trx_id,
                                       p_trx_rec.initial_customer_trx_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.previous_customer_trx_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.previous_customer_trx_id,
                        AR_NUMBER_DUMMY, trx.previous_customer_trx_id,
                                       p_trx_rec.previous_customer_trx_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.related_customer_trx_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.related_customer_trx_id,
                        AR_NUMBER_DUMMY, trx.related_customer_trx_id,
                                       p_trx_rec.related_customer_trx_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.recurred_from_trx_number, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.recurred_from_trx_number,
                        AR_TEXT_DUMMY, trx.recurred_from_trx_number,
                                       p_trx_rec.recurred_from_trx_number),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.cust_trx_type_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.cust_trx_type_id,
                        AR_NUMBER_DUMMY, trx.cust_trx_type_id,
                                       p_trx_rec.cust_trx_type_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.batch_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.batch_id,
                        AR_NUMBER_DUMMY, trx.batch_id,
                                       p_trx_rec.batch_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.batch_source_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.batch_source_id,
                        AR_NUMBER_DUMMY, trx.batch_source_id,
                                       p_trx_rec.batch_source_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.agreement_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.agreement_id,
                        AR_NUMBER_DUMMY, trx.agreement_id,
                                       p_trx_rec.agreement_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.trx_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.trx_date),
                        AR_DATE_DUMMY, TRUNC(trx.trx_date),
                                       TRUNC(p_trx_rec.trx_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.bill_to_customer_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.bill_to_customer_id,
                        AR_NUMBER_DUMMY, trx.bill_to_customer_id,
                                       p_trx_rec.bill_to_customer_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.bill_to_contact_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.bill_to_contact_id,
                        AR_NUMBER_DUMMY, trx.bill_to_contact_id,
                                       p_trx_rec.bill_to_contact_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.bill_to_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.bill_to_site_use_id,
                        AR_NUMBER_DUMMY, trx.bill_to_site_use_id,
                                       p_trx_rec.bill_to_site_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ship_to_customer_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_to_customer_id,
                        AR_NUMBER_DUMMY, trx.ship_to_customer_id,
                                       p_trx_rec.ship_to_customer_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ship_to_contact_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_to_contact_id,
                        AR_NUMBER_DUMMY, trx.ship_to_contact_id,
                                       p_trx_rec.ship_to_contact_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ship_to_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_to_site_use_id,
                        AR_NUMBER_DUMMY, trx.ship_to_site_use_id,
                                       p_trx_rec.ship_to_site_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.sold_to_customer_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.sold_to_customer_id,
                        AR_NUMBER_DUMMY, trx.sold_to_customer_id,
                                       p_trx_rec.sold_to_customer_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.sold_to_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.sold_to_site_use_id,
                        AR_NUMBER_DUMMY, trx.sold_to_site_use_id,
                                       p_trx_rec.sold_to_site_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.sold_to_contact_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.sold_to_contact_id,
                        AR_NUMBER_DUMMY, trx.sold_to_contact_id,
                                       p_trx_rec.sold_to_contact_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.customer_reference, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.customer_reference,
                        AR_TEXT_DUMMY, trx.customer_reference,
                                       p_trx_rec.customer_reference),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(TRUNC(trx.customer_reference_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.customer_reference_date),
                        AR_DATE_DUMMY, TRUNC(trx.customer_reference_date),
                                     TRUNC(p_trx_rec.customer_reference_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.credit_method_for_installments, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.credit_method_for_installments,
                        AR_TEXT_DUMMY, trx.credit_method_for_installments,
                                     p_trx_rec.credit_method_for_installments),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.credit_method_for_rules, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.credit_method_for_rules,
                        AR_TEXT_DUMMY, trx.credit_method_for_rules,
                                       p_trx_rec.credit_method_for_rules),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(TRUNC(trx.start_date_commitment), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.start_date_commitment),
                        AR_DATE_DUMMY, TRUNC(trx.start_date_commitment),
                                       TRUNC(p_trx_rec.start_date_commitment)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(TRUNC(trx.end_date_commitment), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.end_date_commitment),
                        AR_DATE_DUMMY, TRUNC(trx.end_date_commitment),
                                       TRUNC(p_trx_rec.end_date_commitment)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(TRUNC(trx.exchange_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.exchange_date),
                        AR_DATE_DUMMY, TRUNC(trx.exchange_date),
                                       TRUNC(p_trx_rec.exchange_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.exchange_rate, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.exchange_rate,
                        AR_NUMBER_DUMMY, trx.exchange_rate,
                                       p_trx_rec.exchange_rate),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.exchange_rate_type, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.exchange_rate_type,
                        AR_TEXT_DUMMY, trx.exchange_rate_type,
                                       p_trx_rec.exchange_rate_type),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.customer_bank_account_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.customer_bank_account_id,
                        AR_NUMBER_DUMMY, trx.customer_bank_account_id,
                                       p_trx_rec.customer_bank_account_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.finance_charges, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.finance_charges,
                        AR_FLAG_DUMMY, trx.finance_charges,
                                       p_trx_rec.finance_charges),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.fob_point, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.fob_point,
                        AR_TEXT_DUMMY, trx.fob_point,
                                       p_trx_rec.fob_point),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.comments, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.comments,
                        AR_TEXT_DUMMY, trx.comments,
                                       p_trx_rec.comments),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.internal_notes, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.internal_notes,
                        AR_TEXT_DUMMY, trx.internal_notes,
                                       p_trx_rec.internal_notes),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.invoice_currency_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.invoice_currency_code,
                        AR_TEXT_DUMMY, trx.invoice_currency_code,
                                       p_trx_rec.invoice_currency_code),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.invoicing_rule_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.invoicing_rule_id,
                        AR_NUMBER_DUMMY, trx.invoicing_rule_id,
                                       p_trx_rec.invoicing_rule_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.last_printed_sequence_num, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.last_printed_sequence_num,
                        AR_NUMBER_DUMMY, trx.last_printed_sequence_num,
                                       p_trx_rec.last_printed_sequence_num),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.orig_system_batch_name, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.orig_system_batch_name,
                        AR_TEXT_DUMMY, trx.orig_system_batch_name,
                                       p_trx_rec.orig_system_batch_name),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.primary_salesrep_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.primary_salesrep_id,
                        AR_NUMBER_DUMMY, trx.primary_salesrep_id,
                                       p_trx_rec.primary_salesrep_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.printing_count, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.printing_count,
                        AR_NUMBER_DUMMY, trx.printing_count,
                                       p_trx_rec.printing_count),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.printing_last_printed), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.printing_last_printed),
                        AR_DATE_DUMMY, TRUNC(trx.printing_last_printed),
                                       TRUNC(p_trx_rec.printing_last_printed)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.printing_option, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.printing_option,
                        AR_TEXT_DUMMY, trx.printing_option,
                                       p_trx_rec.printing_option),
                 AR_TEXT_DUMMY
              )
       )
     AND
       (
           NVL(TRUNC(trx.printing_original_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.printing_original_date),
                        AR_DATE_DUMMY, TRUNC(trx.printing_original_date),
                                       TRUNC(p_trx_rec.printing_original_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.printing_pending, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.printing_pending,
                        AR_FLAG_DUMMY, trx.printing_pending,
                                       p_trx_rec.printing_pending),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.purchase_order, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.purchase_order,
                        AR_TEXT_DUMMY, trx.purchase_order,
                                       p_trx_rec.purchase_order),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(TRUNC(trx.purchase_order_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.purchase_order_date),
                        AR_DATE_DUMMY, TRUNC(trx.purchase_order_date),
                                       TRUNC(p_trx_rec.purchase_order_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.purchase_order_revision, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.purchase_order_revision,
                        AR_TEXT_DUMMY, trx.purchase_order_revision,
                                       p_trx_rec.purchase_order_revision),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.receipt_method_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.receipt_method_id,
                        AR_NUMBER_DUMMY, trx.receipt_method_id,
                                       p_trx_rec.receipt_method_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.remit_to_address_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.remit_to_address_id,
                        AR_NUMBER_DUMMY, trx.remit_to_address_id,
                                       p_trx_rec.remit_to_address_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.shipment_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.shipment_id,
                        AR_NUMBER_DUMMY, trx.shipment_id,
                                       p_trx_rec.shipment_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(TRUNC(trx.ship_date_actual), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.ship_date_actual),
                        AR_DATE_DUMMY, TRUNC(trx.ship_date_actual),
                                       TRUNC(p_trx_rec.ship_date_actual)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.ship_via, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_via,
                        AR_TEXT_DUMMY, trx.ship_via,
                                       p_trx_rec.ship_via),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(TRUNC(trx.term_due_date), AR_DATE_DUMMY) =
           NVL(
                 DECODE(TRUNC(p_trx_rec.term_due_date),
                        AR_DATE_DUMMY, TRUNC(trx.term_due_date),
                                       TRUNC(p_trx_rec.term_due_date)),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.term_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.term_id,
                        AR_NUMBER_DUMMY, trx.term_id,
                                       p_trx_rec.term_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.territory_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.territory_id,
                        AR_NUMBER_DUMMY, trx.territory_id,
                                       p_trx_rec.territory_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.waybill_number, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.waybill_number,
                        AR_TEXT_DUMMY, trx.waybill_number,
                                       p_trx_rec.waybill_number),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.status_trx, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.status_trx,
                        AR_TEXT_DUMMY, trx.status_trx,
                                       p_trx_rec.status_trx),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.reason_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.reason_code,
                        AR_TEXT_DUMMY, trx.reason_code,
                                       p_trx_rec.reason_code),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.doc_sequence_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.doc_sequence_id,
                        AR_NUMBER_DUMMY, trx.doc_sequence_id,
                                       p_trx_rec.doc_sequence_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.doc_sequence_value, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.doc_sequence_value,
                        AR_NUMBER_DUMMY, trx.doc_sequence_value,
                                       p_trx_rec.doc_sequence_value),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.paying_customer_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.paying_customer_id,
                        AR_NUMBER_DUMMY, trx.paying_customer_id,
                                       p_trx_rec.paying_customer_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.paying_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.paying_site_use_id,
                        AR_NUMBER_DUMMY, trx.paying_site_use_id,
                                       p_trx_rec.paying_site_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.related_batch_source_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.related_batch_source_id,
                        AR_NUMBER_DUMMY, trx.related_batch_source_id,
                                       p_trx_rec.related_batch_source_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.default_tax_exempt_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.default_tax_exempt_flag,
                        AR_FLAG_DUMMY, trx.default_tax_exempt_flag,
                                       p_trx_rec.default_tax_exempt_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.created_from, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.created_from,
                        AR_TEXT_DUMMY, trx.created_from,
                                       p_trx_rec.created_from),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.default_ussgl_trx_code_context, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.default_ussgl_trx_code_context,
                        AR_TEXT_DUMMY, trx.default_ussgl_trx_code_context,
                                     p_trx_rec.default_ussgl_trx_code_context),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.default_ussgl_transaction_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.default_ussgl_transaction_code,
                        AR_TEXT_DUMMY, trx.default_ussgl_transaction_code,
                                     p_trx_rec.default_ussgl_transaction_code),
                 AR_TEXT_DUMMY
              )
	AND
           NVL(trx.old_trx_number, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.old_trx_number,
                        AR_TEXT_DUMMY, trx.old_trx_number,
                                       p_trx_rec.old_trx_number),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_context, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_context,
                        AR_TEXT_DUMMY, trx.interface_header_context,
                                       p_trx_rec.interface_header_context),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute1, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute1,
                        AR_TEXT_DUMMY, trx.interface_header_attribute1,
                                       p_trx_rec.interface_header_attribute1),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute2, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute2,
                        AR_TEXT_DUMMY, trx.interface_header_attribute2,
                                       p_trx_rec.interface_header_attribute2),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute3, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute3,
                        AR_TEXT_DUMMY, trx.interface_header_attribute3,
                                       p_trx_rec.interface_header_attribute3),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute4, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute4,
                        AR_TEXT_DUMMY, trx.interface_header_attribute4,
                                       p_trx_rec.interface_header_attribute4),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute5, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute5,
                        AR_TEXT_DUMMY, trx.interface_header_attribute5,
                                       p_trx_rec.interface_header_attribute5),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute6, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute6,
                        AR_TEXT_DUMMY, trx.interface_header_attribute6,
                                       p_trx_rec.interface_header_attribute6),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute7, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute7,
                        AR_TEXT_DUMMY, trx.interface_header_attribute7,
                                       p_trx_rec.interface_header_attribute7),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute8, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute8,
                        AR_TEXT_DUMMY, trx.interface_header_attribute8,
                                       p_trx_rec.interface_header_attribute8),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute9, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute9,
                        AR_TEXT_DUMMY, trx.interface_header_attribute9,
                                       p_trx_rec.interface_header_attribute9),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute10, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute10,
                        AR_TEXT_DUMMY, trx.interface_header_attribute10,
                                       p_trx_rec.interface_header_attribute10),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute11, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute11,
                        AR_TEXT_DUMMY, trx.interface_header_attribute11,
                                       p_trx_rec.interface_header_attribute11),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute12, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute12,
                        AR_TEXT_DUMMY, trx.interface_header_attribute12,
                                       p_trx_rec.interface_header_attribute12),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute13, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute13,
                        AR_TEXT_DUMMY, trx.interface_header_attribute13,
                                       p_trx_rec.interface_header_attribute13),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute14, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute14,
                        AR_TEXT_DUMMY, trx.interface_header_attribute14,
                                       p_trx_rec.interface_header_attribute14),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.interface_header_attribute15, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.interface_header_attribute15,
                        AR_TEXT_DUMMY, trx.interface_header_attribute15,
                                       p_trx_rec.interface_header_attribute15),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute_category, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute_category,
                        AR_TEXT_DUMMY, trx.attribute_category,
                                       p_trx_rec.attribute_category),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute1, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute1,
                        AR_TEXT_DUMMY, trx.attribute1,
                                       p_trx_rec.attribute1),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute2, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute2,
                        AR_TEXT_DUMMY, trx.attribute2,
                                       p_trx_rec.attribute2),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute3, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute3,
                        AR_TEXT_DUMMY, trx.attribute3,
                                       p_trx_rec.attribute3),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute4, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute4,
                        AR_TEXT_DUMMY, trx.attribute4,
                                       p_trx_rec.attribute4),
                 AR_TEXT_DUMMY
              )
       )
     AND
       (
           NVL(trx.attribute5, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute5,
                        AR_TEXT_DUMMY, trx.attribute5,
                                       p_trx_rec.attribute5),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute6, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute6,
                        AR_TEXT_DUMMY, trx.attribute6,
                                       p_trx_rec.attribute6),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute7, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute7,
                        AR_TEXT_DUMMY, trx.attribute7,
                                       p_trx_rec.attribute7),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute8, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute8,
                        AR_TEXT_DUMMY, trx.attribute8,
                                       p_trx_rec.attribute8),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute9, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute9,
                        AR_TEXT_DUMMY, trx.attribute9,
                                       p_trx_rec.attribute9),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute10, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute10,
                        AR_TEXT_DUMMY, trx.attribute10,
                                       p_trx_rec.attribute10),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute11, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute11,
                        AR_TEXT_DUMMY, trx.attribute11,
                                       p_trx_rec.attribute11),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute12, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute12,
                        AR_TEXT_DUMMY, trx.attribute12,
                                       p_trx_rec.attribute12),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute13, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute13,
                        AR_TEXT_DUMMY, trx.attribute13,
                                       p_trx_rec.attribute13),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute14, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute14,
                        AR_TEXT_DUMMY, trx.attribute14,
                                       p_trx_rec.attribute14),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.attribute15, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.attribute15,
                        AR_TEXT_DUMMY, trx.attribute15,
                                       p_trx_rec.attribute15),
                 AR_TEXT_DUMMY
              )

         AND
           NVL(trx.br_amount, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.br_amount,
                        AR_NUMBER_DUMMY, trx.br_amount,
                                         p_trx_rec.br_amount),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.br_unpaid_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.br_unpaid_flag,
                        AR_FLAG_DUMMY, trx.br_unpaid_flag,
                                         p_trx_rec.br_unpaid_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.br_on_hold_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.br_on_hold_flag,
                        AR_FLAG_DUMMY, trx.br_on_hold_flag,
                                         p_trx_rec.br_on_hold_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.drawee_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.drawee_id,
                        AR_NUMBER_DUMMY, trx.drawee_id,
                                         p_trx_rec.drawee_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.drawee_contact_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.drawee_contact_id,
                        AR_NUMBER_DUMMY, trx.drawee_contact_id,
                                         p_trx_rec.drawee_contact_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.drawee_site_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.drawee_site_use_id,
                        AR_NUMBER_DUMMY, trx.drawee_site_use_id,
                                         p_trx_rec.drawee_site_use_id),
                 AR_NUMBER_DUMMY
              )
/*Bug7313869, Removed the check for drawee_bank_account_id*/
         AND
           NVL(trx.remit_bank_acct_use_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.remit_bank_acct_use_id,
                        AR_NUMBER_DUMMY, trx.remit_bank_acct_use_id,
                                         p_trx_rec.remit_bank_acct_use_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.override_remit_account_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.override_remit_account_flag,
                        AR_FLAG_DUMMY, trx.override_remit_account_flag,
                                         p_trx_rec.override_remit_account_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.special_instructions, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.special_instructions,
                        AR_TEXT_DUMMY, trx.special_instructions,
                                         p_trx_rec.special_instructions),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.remittance_batch_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.remittance_batch_id,
                        AR_NUMBER_DUMMY, trx.remittance_batch_id,
                                         p_trx_rec.remittance_batch_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.address_verification_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.address_verification_code,
                        AR_TEXT_DUMMY, trx.address_verification_code,
                                         p_trx_rec.address_verification_code),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.approval_code, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.approval_code,
                        AR_TEXT_DUMMY, trx.approval_code,
                                         p_trx_rec.approval_code),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.bill_to_address_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.bill_to_address_id,
                        AR_NUMBER_DUMMY, trx.bill_to_address_id,
                                         p_trx_rec.bill_to_address_id),
                 AR_NUMBER_DUMMY
              )
          AND
           NVL(trx.edi_processed_flag, AR_FLAG_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.edi_processed_flag,
                        AR_FLAG_DUMMY, trx.edi_processed_flag,
                                         p_trx_rec.edi_processed_flag),
                 AR_FLAG_DUMMY
              )
         AND
           NVL(trx.edi_processed_status, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.edi_processed_status,
                        AR_TEXT_DUMMY, trx.edi_processed_status,
                                         p_trx_rec.edi_processed_status),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.payment_server_order_num, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.payment_server_order_num,
                        AR_TEXT_DUMMY, trx.payment_server_order_num,
                                         p_trx_rec.payment_server_order_num),
                 AR_TEXT_DUMMY
              )
          AND
           NVL(trx.post_request_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.post_request_id,
                        AR_NUMBER_DUMMY, trx.post_request_id,
                                         p_trx_rec.post_request_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.request_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.request_id,
                        AR_NUMBER_DUMMY, trx.request_id,
                                         p_trx_rec.request_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.ship_to_address_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.ship_to_address_id,
                        AR_NUMBER_DUMMY, trx.ship_to_address_id,
                                         p_trx_rec.ship_to_address_id),
                 AR_NUMBER_DUMMY
              )
         AND
           NVL(trx.wh_update_date, AR_DATE_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.wh_update_date,
                        AR_DATE_DUMMY, trx.wh_update_date,
                                         p_trx_rec.wh_update_date),
                 AR_DATE_DUMMY
              )
         AND
           NVL(trx.global_attribute_category, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute_category,
                        AR_TEXT_DUMMY, trx.global_attribute_category,
                                       p_trx_rec.global_attribute_category),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute1, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute1,
                        AR_TEXT_DUMMY, trx.global_attribute1,
                                       p_trx_rec.global_attribute1),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute2, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute2,
                        AR_TEXT_DUMMY, trx.global_attribute2,
                                       p_trx_rec.global_attribute2),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute3, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute3,
                        AR_TEXT_DUMMY, trx.global_attribute3,
                                       p_trx_rec.global_attribute3),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute4, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute4,
                        AR_TEXT_DUMMY, trx.global_attribute4,
                                       p_trx_rec.global_attribute4),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute5, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute5,
                        AR_TEXT_DUMMY, trx.global_attribute5,
                                       p_trx_rec.global_attribute5),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute6, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute6,
                        AR_TEXT_DUMMY, trx.global_attribute6,
                                       p_trx_rec.global_attribute6),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute7, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute7,
                        AR_TEXT_DUMMY, trx.global_attribute7,
                                       p_trx_rec.global_attribute7),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute8, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute8,
                        AR_TEXT_DUMMY, trx.global_attribute8,
                                       p_trx_rec.global_attribute8),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute9, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute9,
                        AR_TEXT_DUMMY, trx.global_attribute9,
                                       p_trx_rec.global_attribute9),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute10, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute10,
                        AR_TEXT_DUMMY, trx.global_attribute10,
                                       p_trx_rec.global_attribute10),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute11, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute11,
                        AR_TEXT_DUMMY, trx.global_attribute11,
                                       p_trx_rec.global_attribute11),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute12, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute12,
                        AR_TEXT_DUMMY, trx.global_attribute12,
                                       p_trx_rec.global_attribute12),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute13, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute13,
                        AR_TEXT_DUMMY, trx.global_attribute13,
                                       p_trx_rec.global_attribute13),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute14, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute14,
                        AR_TEXT_DUMMY, trx.global_attribute14,
                                       p_trx_rec.global_attribute14),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute15, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute15,
                        AR_TEXT_DUMMY, trx.global_attribute15,
                                       p_trx_rec.global_attribute15),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute16, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute16,
                        AR_TEXT_DUMMY, trx.global_attribute16,
                                       p_trx_rec.global_attribute16),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute17, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute17,
                        AR_TEXT_DUMMY, trx.global_attribute17,
                                       p_trx_rec.global_attribute17),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute18, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute18,
                        AR_TEXT_DUMMY, trx.global_attribute18,
                                       p_trx_rec.global_attribute18),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute19, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute19,
                        AR_TEXT_DUMMY, trx.global_attribute19,
                                       p_trx_rec.global_attribute19),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute20, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute20,
                        AR_TEXT_DUMMY, trx.global_attribute20,
                                       p_trx_rec.global_attribute20),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute21, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute21,
                        AR_TEXT_DUMMY, trx.global_attribute21,
                                       p_trx_rec.global_attribute21),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute22, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute22,
                        AR_TEXT_DUMMY, trx.global_attribute22,
                                       p_trx_rec.global_attribute22),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute23, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute23,
                        AR_TEXT_DUMMY, trx.global_attribute23,
                                       p_trx_rec.global_attribute23),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute24, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute24,
                        AR_TEXT_DUMMY, trx.global_attribute24,
                                       p_trx_rec.global_attribute24),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute25, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute25,
                        AR_TEXT_DUMMY, trx.global_attribute25,
                                       p_trx_rec.global_attribute25),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute26, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute26,
                        AR_TEXT_DUMMY, trx.global_attribute26,
                                       p_trx_rec.global_attribute26),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute27, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute27,
                        AR_TEXT_DUMMY, trx.global_attribute27,
                                       p_trx_rec.global_attribute27),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute28, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute28,
                        AR_TEXT_DUMMY, trx.global_attribute28,
                                       p_trx_rec.global_attribute28),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute29, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute29,
                        AR_TEXT_DUMMY, trx.global_attribute29,
                                       p_trx_rec.global_attribute29),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.global_attribute30, AR_TEXT_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.global_attribute30,
                        AR_TEXT_DUMMY, trx.global_attribute30,
                                       p_trx_rec.global_attribute30),
                 AR_TEXT_DUMMY
              )
         AND
           NVL(trx.legal_entity_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.legal_entity_id,
                        AR_NUMBER_DUMMY, trx.legal_entity_id,
                                       p_trx_rec.legal_entity_id),
                 AR_NUMBER_DUMMY
              )
      )
        AND
           NVL(trx.payment_trxn_extension_id, AR_NUMBER_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.payment_trxn_extension_id,
                        AR_NUMBER_DUMMY, trx.payment_trxn_extension_id,
                                       p_trx_rec.payment_trxn_extension_id),
                 AR_NUMBER_DUMMY
              )  /* PAYMENT_UPAKE */
        AND
           NVL(trx.billing_date, AR_DATE_DUMMY) =
           NVL(
                 DECODE(p_trx_rec.billing_date,
                        AR_DATE_DUMMY, trx.billing_date,
                                       p_trx_rec.billing_date),
                 AR_DATE_DUMMY
              );

Line: 4732

    SELECT *
    INTO   p_trx_rec
    FROM   ra_customer_trx
    WHERE  customer_trx_id = p_customer_trx_id;

Line: 4747

 |    delete_p								     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    This procedure deletes the ra_customeR_trx row identified by the 	     |
 |    p_customer_trx_id parameter.					     |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    p_customer_trx_id	- identifies the row to delete	     |
 |              OUT:                                                         |
 |                    None						     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     07-JUN-95  Charlie Tomberg     Created                                |
 |     08-NOV-01  Debbie Jancis       Added calls to MRC engine for          |
 |                                    RA_CUSTOMER_TRX processing             |
 |                                                                           |
 +===========================================================================*/

procedure delete_p( p_customer_trx_id  IN ra_customer_trx.customer_trx_id%type)
       IS


BEGIN


   arp_util.debug('arp_ct_pkg.delete_p()+');

Line: 4783

   DELETE FROM ra_customer_trx
   WHERE       customer_trx_id = p_customer_trx_id;

Line: 4798

   arp_util.debug('arp_ct_pkg.delete_p()-');

Line: 4802

        arp_util.debug('EXCEPTION:  arp_ct_pkg.delete_p()');

Line: 4810

 |    update_p								     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    This procedure updates the ra_customer_trx row identified by the       |
 |    p_customer_trx_id parameter.					     |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    p_customer_trx_id	- identifies the row to update	     |
 |                    p_trx_rec       - contains the new column values       |
 |              OUT:                                                         |
 |                    None						     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |     set_to_dummy must be called before the values in p_trx_rec are        |
 |     changed and this function is called.				     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     06-JUN-95  Charlie Tomberg     Created                                |
 |                                                                           |
 +===========================================================================*/

PROCEDURE update_p( p_trx_rec IN ra_customer_trx%rowtype,
                    p_customer_trx_id  IN
                                ra_customer_trx.customer_trx_id%type) IS

--2528261 begin
l_ct_reference   varchar2(150);

Line: 4847

   arp_util.debug('arp_ct_pkg.update_p()+  ' ||
                      to_char(sysdate, 'HH:MI:SS'));

Line: 4850

   arp_ct_pkg.generic_update(  pg_cursor1,
			       ' WHERE customer_trx_id = :where_1',
                               p_customer_trx_id,
                               p_trx_rec);

Line: 4855

   arp_util.debug('arp_ct_pkg.update_p()-  ' ||
                      to_char(sysdate, 'HH:MI:SS'));

Line: 4859

        SELECT DECODE(DEFAULT_REFERENCE,
                      '1',  p_trx_rec.interface_header_attribute1,
                      '2',  p_trx_rec.interface_header_attribute2,
                      '3',  p_trx_rec.interface_header_attribute3,
                      '4',  p_trx_rec.interface_header_attribute4,
                      '5',  p_trx_rec.interface_header_attribute5,
                      '6',  p_trx_rec.interface_header_attribute6,
                      '7',  p_trx_rec.interface_header_attribute7,
                      '8',  p_trx_rec.interface_header_attribute8,
                      '9',  p_trx_rec.interface_header_attribute9,
                      '10', p_trx_rec.interface_header_attribute10,
                      '11', p_trx_rec.interface_header_attribute11,
                      '12', p_trx_rec.interface_header_attribute12,
                      '13', p_trx_rec.interface_header_attribute13,
                      '14', p_trx_rec.interface_header_attribute14,
                      '15', p_trx_rec.interface_header_attribute15,
                      NULL, p_trx_rec.ct_reference,
                      NULL ) /* Bug fix 5330712 */
        INTO   l_ct_reference
        FROM   ra_batch_sources
        WHERE batch_source_id = p_trx_rec.batch_source_id;

Line: 4887

       update ra_customer_trx
        set ct_reference =l_ct_reference
       where customer_trx_id = p_trx_rec.customer_trx_id;

Line: 4898

        arp_util.debug('EXCEPTION:  arp_ct_pkg.update_p()');

Line: 4904

 |    update_p_print					     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    This procedure updates the ra_customer_trx row identified by the       |
 |    p_customer_trx_id parameter.  It calls update_p, then
 |    arp_etax_util.global_document_update.				     |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    p_customer_trx_id	- identifies the row to update	     |
 |                    p_trx_rec       - contains the new column values       |
 |              OUT:                                                         |
 |                    None						     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |     set_to_dummy must be called before the values in p_trx_rec are        |
 |     changed and this function is called.  This function is
 |     specifically intended for use by outside products that are
 |     updating the ra_customer_trx.print-related fields to
 |     indicate a 'print' event.
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     24-JAN-06  M Raymond           Created                                |
 |                                                                           |
 +===========================================================================*/

PROCEDURE update_p_print( p_trx_rec IN ra_customer_trx%rowtype,
                          p_customer_trx_id  IN
                                   ra_customer_trx.customer_trx_id%type) IS
BEGIN
   /* Call update_p to carry out the actual update */
   update_p(p_trx_rec, p_customer_trx_id);

Line: 4944

   arp_etax_util.global_document_update(p_customer_trx_id,
                                        null,
                                        'PRINT');

Line: 4949

        arp_util.debug('EXCEPTION:  arp_ct_pkg.update_p_print()');

Line: 4957

 |    insert_p								     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    This procedure inserts a row into ra_customer_trx that contains the    |
 |    column values specified in the p_trx_rec parameter. 		     |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |    arp_global.set_of_books_id					     |
 |                                                                           |
 | ARGUMENTS  :  IN:                                                         |
 |                    p_trx_rec            - contains the new column values  |
 |              OUT:                                                         |
 |                    p_trx_number         - transaction number of new row   |
 |                    p_customer_trx_id    - unique ID of the new row        |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 | 06-JUN-95    Charlie Tomberg Created                                      |
 | 12-JUL-95    Martin Johnson  Added OUT NOCOPY parameter p_trx_number.            |
 | 20-MAR-2000  J Rautiainen    Added BR project related columns             |
 |                              BR_AMOUNT, BR_UNPAID_FLAG,BR_ON_HOLD_FLAG,   |
 |                              DRAWEE_ID, DRAWEE_CONTACT_ID,                |
 |                              DRAWEE_SITE_USE_ID   		             |
 |                              DRAWEE_BANK_ACCOUNT_ID,                      |
 |                              REMITTANCE_BANK_ACCOUNT_ID,		     |
 |                              OVERRIDE_REMIT_ACCOUNT_FLAG and              |
 |                              SPECIAL_INSTRUCTIONSinto table handlers      |
 | 24-JUL-2000  J Rautiainen    Added BR project related column              |
 |                              REMITTANCE_BATCH_ID		             |
 | 31-OCT-2000 Y Rakotonirainy	Bug 1243304 : Added columns                  |
 |                              address_verification_code and	             |
 |				approval_code	and			     |
 |				bill_to_address_id and			     |
 |				edi_processed_flag and			     |
 |				edi_processed_status and		     |
 |				payment_server_order_num and		     |
 |				post_request_id and			     |
 |				request_id and				     |
 |				ship_to_address_id			     |
 |				wh_update_date				     |
 | 				into the table handlers.  		     |
 | 6-Jul-2001 yreddy            Bug1738914 - Added 'Copy doc num to          |
 |                              Trx Number'                                  |
 |                              functionality for chargebacks.               |
 | 08-NOV-01  Debbie Jancis     Added calls to MRC engine for                |
 |                              RA_CUSTOMER_TRX processing                   |
 |                                                                           |
 | 20-Jun-02  Sahana            Bug2427456: Added global attribute columns   |
 | 18-May-05  Debbie Jancis     Added Legal Entity ID for LE project         |
 +===========================================================================*/

PROCEDURE insert_p(
                    p_trx_rec          IN ra_customer_trx%rowtype,
                    p_trx_number      OUT NOCOPY ra_customer_trx.trx_number%type,
                    p_customer_trx_id OUT NOCOPY ra_customer_trx.customer_trx_id%type
                  ) IS


    l_customer_trx_id  ra_customer_trx.customer_trx_id%type;

Line: 5035

    arp_util.debug('arp_ct_pkg.insert_p()+');

Line: 5059

        SELECT RA_CUSTOMER_TRX_S.NEXTVAL
        INTO   l_customer_trx_id
        FROM   DUAL;

Line: 5069

          SELECT MIN(org_id)
          INTO   l_org_id
          FROM   ar_system_parameters;

Line: 5081

    /* Bug 1738914 : Selecting copy_doc_number_flag. Chargebacks are always
     numbered automatically , so this piece of code gets executed all the time */

       l_trx_str :=  'select ra_trx_number_' ||
                               REPLACE(p_trx_rec.batch_source_id, '-', 'N') ||
                          l_org_str||
                          '_s.nextval trx_number,copy_doc_number_flag ' ||
                          'from ra_batch_sources ' ||
                          'where batch_source_id = ' ||
                               p_trx_rec.batch_source_id ||
                         ' and auto_trx_numbering_flag = ''Y''';

Line: 5100

                          'select ra_trx_number_' ||
                               REPLACE(p_trx_rec.batch_source_id, '-', 'N') ||
                          l_org_str||
                          '_s.nextval trx_number ' ||
                          'from ra_batch_sources ' ||
                          'where batch_source_id = ' ||
                               p_trx_rec.batch_source_id ||
                         ' and auto_trx_numbering_flag = ''Y''',
                         dbms_sql.v7);

Line: 5139

        SELECT DECODE(DEFAULT_REFERENCE,
                      '1',  p_trx_rec.interface_header_attribute1,
                      '2',  p_trx_rec.interface_header_attribute2,
                      '3',  p_trx_rec.interface_header_attribute3,
                      '4',  p_trx_rec.interface_header_attribute4,
                      '5',  p_trx_rec.interface_header_attribute5,
                      '6',  p_trx_rec.interface_header_attribute6,
                      '7',  p_trx_rec.interface_header_attribute7,
                      '8',  p_trx_rec.interface_header_attribute8,
                      '9',  p_trx_rec.interface_header_attribute9,
                      '10', p_trx_rec.interface_header_attribute10,
                      '11', p_trx_rec.interface_header_attribute11,
                      '12', p_trx_rec.interface_header_attribute12,
                      '13', p_trx_rec.interface_header_attribute13,
                      '14', p_trx_rec.interface_header_attribute14,
                      '15', p_trx_rec.interface_header_attribute15,
                      NULL,p_trx_rec.ct_reference, /* Bug fix 5330712*/
                      NULL )
        INTO   l_ct_reference
        FROM   ra_batch_sources
        WHERE batch_source_id = p_trx_rec.batch_source_id;

Line: 5168

     | Insert the record |
     *-------------------*/

   INSERT INTO ra_customer_trx
               (
                 customer_trx_id,
                 trx_number,
                 created_by,
                 creation_date,
                 last_updated_by,
                 last_update_date,
                 last_update_login,
                 set_of_books_id,
                 program_application_id,
                 program_id,
                 program_update_date,
                 posting_control_id,
                 ra_post_loop_number,
                 complete_flag,
                 initial_customer_trx_id,
                 previous_customer_trx_id,
                 related_customer_trx_id,
                 recurred_from_trx_number,
                 cust_trx_type_id,
                 batch_id,
                 batch_source_id,
                 agreement_id,
                 trx_date,
                 bill_to_customer_id,
                 bill_to_contact_id,
                 bill_to_site_use_id,
                 ship_to_customer_id,
                 ship_to_contact_id,
                 ship_to_site_use_id,
                 sold_to_customer_id,
                 sold_to_site_use_id,
                 sold_to_contact_id,
                 customer_reference,
                 customer_reference_date,
                 credit_method_for_installments,
                 credit_method_for_rules,
                 start_date_commitment,
                 end_date_commitment,
                 exchange_date,
                 exchange_rate,
                 exchange_rate_type,
                 customer_bank_account_id,
                 finance_charges,
                 fob_point,
                 comments,
                 internal_notes,
                 invoice_currency_code,
                 invoicing_rule_id,
                 last_printed_sequence_num,
                 orig_system_batch_name,
                 primary_salesrep_id,
                 printing_count,
                 printing_last_printed,
                 printing_option,
                 printing_original_date,
                 printing_pending,
                 purchase_order,
                 purchase_order_date,
                 purchase_order_revision,
                 receipt_method_id,
                 remit_to_address_id,
                 shipment_id,
                 ship_date_actual,
                 ship_via,
                 term_due_date,
                 term_id,
                 territory_id,
                 waybill_number,
                 status_trx,
                 reason_code,
                 doc_sequence_id,
                 doc_sequence_value,
                 paying_customer_id,
                 paying_site_use_id,
                 related_batch_source_id,
                 default_tax_exempt_flag,
                 created_from,
                 default_ussgl_trx_code_context,
                 default_ussgl_transaction_code,
                 old_trx_number,
                 interface_header_context,
                 interface_header_attribute1,
                 interface_header_attribute2,
                 interface_header_attribute3,
                 interface_header_attribute4,
                 interface_header_attribute5,
                 interface_header_attribute6,
                 interface_header_attribute7,
                 interface_header_attribute8,
                 interface_header_attribute9,
                 interface_header_attribute10,
                 interface_header_attribute11,
                 interface_header_attribute12,
                 interface_header_attribute13,
                 interface_header_attribute14,
                 interface_header_attribute15,
                 attribute_category,
                 attribute1,
                 attribute2,
                 attribute3,
                 attribute4,
                 attribute5,
                 attribute6,
                 attribute7,
                 attribute8,
                 attribute9,
                 attribute10,
                 attribute11,
                 attribute12,
                 attribute13,
                 attribute14,
                 attribute15,
                 br_amount,
                 br_unpaid_flag,
                 br_on_hold_flag,
                 drawee_id,
                 drawee_contact_id,
                 drawee_site_use_id,
                 drawee_bank_account_id,
                 remit_bank_acct_use_id,
                 override_remit_account_flag,
                 special_instructions,
                 remittance_batch_id,
                 address_verification_code,
                 approval_code,
                 bill_to_address_id,
                 edi_processed_flag,
                 edi_processed_status,
                 payment_server_order_num,
                 post_request_id,
                 request_id,
                 ship_to_address_id,
                 wh_update_date,
                 global_attribute_category,
                 global_attribute1,
                 global_attribute2,
                 global_attribute3,
                 global_attribute4,
                 global_attribute5,
                 global_attribute6,
                 global_attribute7,
                 global_attribute8,
                 global_attribute9,
                 global_attribute10,
                 global_attribute11,
                 global_attribute12,
                 global_attribute13,
                 global_attribute14,
                 global_attribute15,
                 global_attribute16,
                 global_attribute17,
                 global_attribute18,
                 global_attribute19,
                 global_attribute20,
                 global_attribute21,
                 global_attribute22,
                 global_attribute23,
                 global_attribute24,
                 global_attribute25,
                 global_attribute26,
                 global_attribute27,
                 global_attribute28,
                 global_attribute29,
                 global_attribute30
                 ,ct_reference
                 ,org_id
                 ,legal_entity_id -- LE
                 ,payment_trxn_extension_id   /* PAYMENT_UPTAKE */
                 ,billing_date
               )
         VALUES
               (
                 l_customer_trx_id,
                 l_trx_number,
                 pg_user_id,			/* created_by */
                 sysdate, 			/* creation_date */
                 pg_user_id,			/* last_updated_by */
                 sysdate,			/* last_update_date */
                 nvl(pg_conc_login_id,
                     pg_login_id),		/* last_update_login */
                 arp_global.set_of_books_id,	/* set_of_books_id */
                 pg_prog_appl_id,		/* program_application_id */
                 pg_conc_program_id,		/* program_id */
                 sysdate,			/* program_update_date */
                 p_trx_rec.posting_control_id,
                 p_trx_rec.ra_post_loop_number,
                 p_trx_rec.complete_flag,
                 p_trx_rec.initial_customer_trx_id,
                 p_trx_rec.previous_customer_trx_id,
                 p_trx_rec.related_customer_trx_id,
                 p_trx_rec.recurred_from_trx_number,
                 p_trx_rec.cust_trx_type_id,
                 p_trx_rec.batch_id,
                 p_trx_rec.batch_source_id,
                 p_trx_rec.agreement_id,
                 p_trx_rec.trx_date,
                 p_trx_rec.bill_to_customer_id,
                 p_trx_rec.bill_to_contact_id,
                 p_trx_rec.bill_to_site_use_id,
                 p_trx_rec.ship_to_customer_id,
                 p_trx_rec.ship_to_contact_id,
                 p_trx_rec.ship_to_site_use_id,
                 p_trx_rec.sold_to_customer_id,
                 p_trx_rec.sold_to_site_use_id,
                 p_trx_rec.sold_to_contact_id,
                 p_trx_rec.customer_reference,
                 p_trx_rec.customer_reference_date,
                 p_trx_rec.credit_method_for_installments,
                 p_trx_rec.credit_method_for_rules,
                 p_trx_rec.start_date_commitment,
                 p_trx_rec.end_date_commitment,
                 p_trx_rec.exchange_date,
                 p_trx_rec.exchange_rate,
                 p_trx_rec.exchange_rate_type,
                 p_trx_rec.customer_bank_account_id,
                 p_trx_rec.finance_charges,
                 p_trx_rec.fob_point,
                 p_trx_rec.comments,
                 p_trx_rec.internal_notes,
                 p_trx_rec.invoice_currency_code,
                 p_trx_rec.invoicing_rule_id,
                 p_trx_rec.last_printed_sequence_num,
                 p_trx_rec.orig_system_batch_name,
                 p_trx_rec.primary_salesrep_id,
                 p_trx_rec.printing_count,
                 p_trx_rec.printing_last_printed,
                 p_trx_rec.printing_option,
                 p_trx_rec.printing_original_date,
                 decode(p_trx_rec.printing_option,
                        'PRI', 'Y',
                        'NOT', 'N',
                               p_trx_rec.printing_pending),
                 p_trx_rec.purchase_order,
                 p_trx_rec.purchase_order_date,
                 p_trx_rec.purchase_order_revision,
                 p_trx_rec.receipt_method_id,
                 p_trx_rec.remit_to_address_id,
                 p_trx_rec.shipment_id,
                 p_trx_rec.ship_date_actual,
                 p_trx_rec.ship_via,
                 p_trx_rec.term_due_date,
                 p_trx_rec.term_id,
                 p_trx_rec.territory_id,
                 p_trx_rec.waybill_number,
                 p_trx_rec.status_trx,
                 p_trx_rec.reason_code,
                 p_trx_rec.doc_sequence_id,
                 p_trx_rec.doc_sequence_value,
                 p_trx_rec.paying_customer_id,
                 p_trx_rec.paying_site_use_id,
                 p_trx_rec.related_batch_source_id,
                 p_trx_rec.default_tax_exempt_flag,
                 p_trx_rec.created_from,
                 p_trx_rec.default_ussgl_trx_code_context,
                 p_trx_rec.default_ussgl_transaction_code,
                 l_old_trx_number,                         --Bug1738914
                 p_trx_rec.interface_header_context,
                 p_trx_rec.interface_header_attribute1,
                 p_trx_rec.interface_header_attribute2,
                 p_trx_rec.interface_header_attribute3,
                 p_trx_rec.interface_header_attribute4,
                 p_trx_rec.interface_header_attribute5,
                 p_trx_rec.interface_header_attribute6,
                 p_trx_rec.interface_header_attribute7,
                 p_trx_rec.interface_header_attribute8,
                 p_trx_rec.interface_header_attribute9,
                 p_trx_rec.interface_header_attribute10,
                 p_trx_rec.interface_header_attribute11,
                 p_trx_rec.interface_header_attribute12,
                 p_trx_rec.interface_header_attribute13,
                 p_trx_rec.interface_header_attribute14,
                 p_trx_rec.interface_header_attribute15,
                 p_trx_rec.attribute_category,
                 p_trx_rec.attribute1,
                 p_trx_rec.attribute2,
                 p_trx_rec.attribute3,
                 p_trx_rec.attribute4,
                 p_trx_rec.attribute5,
                 p_trx_rec.attribute6,
                 p_trx_rec.attribute7,
                 p_trx_rec.attribute8,
                 p_trx_rec.attribute9,
                 p_trx_rec.attribute10,
                 p_trx_rec.attribute11,
                 p_trx_rec.attribute12,
                 p_trx_rec.attribute13,
                 p_trx_rec.attribute14,
                 p_trx_rec.attribute15,
                 p_trx_rec.br_amount,
                 p_trx_rec.br_unpaid_flag,
                 p_trx_rec.br_on_hold_flag,
                 p_trx_rec.drawee_id,
                 p_trx_rec.drawee_contact_id,
                 p_trx_rec.drawee_site_use_id,
                 p_trx_rec.drawee_bank_account_id,
                 p_trx_rec.remit_bank_acct_use_id,
                 p_trx_rec.override_remit_account_flag,
                 p_trx_rec.special_instructions,
                 p_trx_rec.remittance_batch_id,
                 p_trx_rec.address_verification_code,
                 p_trx_rec.approval_code,
                 p_trx_rec.bill_to_address_id,
                 p_trx_rec.edi_processed_flag,
                 p_trx_rec.edi_processed_status,
                 p_trx_rec.payment_server_order_num,
                 p_trx_rec.post_request_id,
                 p_trx_rec.request_id,
                 p_trx_rec.ship_to_address_id,
                 p_trx_rec.wh_update_date,
                 p_trx_rec.global_attribute_category,
                 p_trx_rec.global_attribute1,
                 p_trx_rec.global_attribute2,
                 p_trx_rec.global_attribute3,
                 p_trx_rec.global_attribute4,
                 p_trx_rec.global_attribute5,
                 p_trx_rec.global_attribute6,
                 p_trx_rec.global_attribute7,
                 p_trx_rec.global_attribute8,
                 p_trx_rec.global_attribute9,
                 p_trx_rec.global_attribute10,
                 p_trx_rec.global_attribute11,
                 p_trx_rec.global_attribute12,
                 p_trx_rec.global_attribute13,
                 p_trx_rec.global_attribute14,
                 p_trx_rec.global_attribute15,
                 p_trx_rec.global_attribute16,
                 p_trx_rec.global_attribute17,
                 p_trx_rec.global_attribute18,
                 p_trx_rec.global_attribute19,
                 p_trx_rec.global_attribute20,
                 p_trx_rec.global_attribute21,
                 p_trx_rec.global_attribute22,
                 p_trx_rec.global_attribute23,
                 p_trx_rec.global_attribute24,
                 p_trx_rec.global_attribute25,
                 p_trx_rec.global_attribute26,
                 p_trx_rec.global_attribute27,
                 p_trx_rec.global_attribute28,
                 p_trx_rec.global_attribute29,
                 p_trx_rec.global_attribute30,
                 l_ct_reference,
                 arp_standard.sysparm.org_id, /* SSA changes anuj */
                 p_trx_rec.legal_entity_id, --LE
                 p_trx_rec.payment_trxn_extension_id, /* PAYMENT_UPTAKE  */
                 p_trx_rec.billing_date
               );

Line: 5535

   arp_util.debug('arp_ct_pkg.insert_p()-');

Line: 5539

        arp_util.debug('EXCEPTION:  arp_ct_pkg.insert_p()');

Line: 5549

 |    last_update_date.                                                      |
 |                                                                           |
 | SCOPE - PRIVATE                                                           |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                       p_customer_trx_id                                   |
 |              OUT:                                                         |
 |          IN/ OUT:							     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     13-JUL-95  Martin Johnson      Created                                |
 |                                                                           |
 +===========================================================================*/

PROCEDURE display_header_p(
            p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) IS

   l_trx_rec ra_customer_trx%rowtype;

Line: 5598

 |    last_update_date.                                                     |
 |                                                                          |
 | SCOPE - PRIVATE                                                          |
 |                                                                          |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                  |
 |    arp_util.debug                                                        |
 |                                                                          |
 | ARGUMENTS  : IN:                                                         |
 |                       p_customer_trx_id                                  |
 |              OUT:                                                        |
 |          IN/ OUT:							    |
 |                                                                          |
 | RETURNS    : NONE                                                        |
 |                                                                          |
 | NOTES                                                                    |
 |                                                                          |
 | MODIFICATION HISTORY                                                     |
 | 19-JUL-95  Martin Johnson    Created                                     |
 | 20-MAR-2000  J Rautiainen    Added BR project related columns            |
 |                              BR_AMOUNT, BR_UNPAID_FLAG,BR_ON_HOLD_FLAG,  |
 |                              DRAWEE_ID, DRAWEE_CONTACT_ID,               |
 |                              DRAWEE_SITE_USE_ID,DRAWEE_BANK_ACCOUNT_ID,  |
 |                              REMITTANCE_BANK_ACCOUNT_ID,		    |
 |                              OVERRIDE_REMIT_ACCOUNT_FLAG and             |
 |                              SPECIAL_INSTRUCTIONSinto table handlers     |
 | 24-JUL-2000  J Rautiainen    Added BR project related column             |
 |                              REMITTANCE_BATCH_ID		            |
 | 31-OCT-2000 Y Rakotonirainy	Bug 1243304 : Added columns                 |
 |                              address_verification_code and	            |
 |				approval_code	and			    |
 |				bill_to_address_id and		            |
 |				edi_processed_flag and			    |
 |				edi_processed_status and		    |
 |				payment_server_order_num and		    |
 |				post_request_id and			    |
 |				request_id and				    |
 |				ship_to_address_id			    |
 |				wh_update_date				    |
 | 				into the table handlers.                    |
 +==========================================================================*/

PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype ) IS

BEGIN

   arp_util.debug('arp_ct_pkg.display_header_rec()+');

Line: 5649

   arp_util.debug('last_updated_by: '        || p_trx_rec.last_updated_by);

Line: 5650

   arp_util.debug('last_update_login: '      || p_trx_rec.last_update_login);

Line: 5655

   arp_util.debug('program_update_date: '    || p_trx_rec.program_update_date);

Line: 5814

   arp_util.debug('wh_update_date: '  	   	    || p_trx_rec.wh_update_date);

Line: 6735

 |    update_tax				          		     |
 |                                                                           |
 | DESCRIPTION                                                               |
 |    This procedure updates the ra_customer_trx row identified by the       |
 |    p_customer_trx_id parameter.					     |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    p_customer_trx_id	- identifies the row to update	     |
 |                    p_trx_rec       - contains the new column values       |
 |              OUT:                                                         |
 |                    None						     |
 |                                                                           |
 | RETURNS    : NONE                                                         |
 |                                                                           |
 | NOTES                                                                     |
 |     set_to_dummy must be called before the values in p_trx_rec are        |
 |     changed and this function is called.				     |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     20-DEC-96  Vikas Mahajan     Created                                  |
 |     13-AUG-97  Govind Jayanth    New parameter to check enforcement of tax|
 |                                  from Natural Account. If TRUE, call the  |
 |                                  new 'get_default_tax_code()' to default  |
 |                                  tax code from GL natural account.        |
 |     21-AUG-02 B Chatterjee       Bug2503883 Changed the nvl value of      |
 |                                  autotax to 'N'                           |
 |     07-FEB-07 M Raymond       5594741 - Updated parameters on
 |                                  get_default_tax_classification to
 |                                  correctly differentiate between org
 |                                  and warehouse_id
 +===========================================================================*/


PROCEDURE update_tax( p_ship_to_site_use_id IN ra_customer_trx.ship_to_site_use_id%type,
		      p_bill_to_site_use_id IN ra_customer_trx.bill_to_site_use_id%type,
		      p_trx_date IN ra_customer_trx.trx_date%type,
		      p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%type,
                      p_customer_trx_id  IN ra_customer_trx.customer_trx_id%type,
                      P_TAX_AFFECT_FLAG in varchar2,
                      p_enforce_nat_acc_flag IN BOOLEAN) IS

CURSOR  update_header_lines IS
        SELECT customer_trx_line_id,
               inventory_item_id,
               memo_line_id,
               warehouse_id
        FROM   ra_customer_trx_lines
        WHERE  customer_trx_id = p_customer_trx_id
        AND    line_type = 'LINE';--3872371

Line: 6809

   arp_util.debug('arp_ct_pkg.update_tax()+  ' ||
                      to_char(sysdate, 'HH:MI:SS'));

Line: 6831

      SELECT tax_calculation_flag
      INTO l_tax_calculation_flag
      FROM RA_CUST_TRX_TYPES
      WHERE cust_trx_type_id = p_cust_trx_type_id ;

Line: 6837

          arp_util.debug('arp_ct_pkd.update_tax - exception for select');

Line: 6842

                      p_action => 'UPDATE',
                      p_event_class_code => l_event_class_code,
                      p_event_type_code => l_event_type_code);

Line: 6851

            * including those with manually updated tax codes.
            */

	   For line in update_header_lines
	   LOOP
	     BEGIN

                /*------------------------------------------------+
                 | ETax:  get the event_class_code and then call  |
                 | get_default_tax_classification to get the      |
                 | tax code                                       |
                 +------------------------------------------------*/


                   arp_etax_util.get_default_tax_classification(
                           p_ship_to_site_use_id => p_ship_to_site_use_id,
                           p_bill_to_site_use_id => p_bill_to_site_use_id,
                           p_inv_item_id         => line.inventory_item_id,
                           p_org_id              => l_organization_id,
                           p_warehouse_id        =>
                               NVL(line.warehouse_id, l_warehouse_id),
                           p_sob_id              => l_sob_id,
                           p_trx_date            => p_trx_date,
                           p_trx_type_id         => p_cust_trx_type_id,
                           p_cust_trx_id         => p_customer_trx_id,
                           p_cust_trx_line_id    => line.customer_trx_line_id,
                           p_customer_id =>  NULL,
                           p_memo_line_id        => line.memo_line_id,
                           p_entity_code         => 'RA_CUSTOMER_TRX',
                           p_event_class_code    => l_event_class_code,
                           p_function_short_name => 'GL_ACCT_FIXUP',
                           p_tax_classification_code => l_tax_code );

Line: 6898

		---  UPDATE RA_CUSTOMER_TRX_LINES with  new
                ---  tax_code and autotax='Y'
		 update ra_customer_trx_lines
                 set tax_classification_code = l_tax_code,
		     autotax    = l_autotax
                 where customer_trx_line_id = line.customer_trx_line_id;

Line: 6908

	   For line in update_header_lines
	   LOOP
	     BEGIN
		/*------------------------------------------------+
		 |  Call Tax API to get the value of vat_tax_id   |
		 +------------------------------------------------*/

               IF (l_tax_calculation_flag = 'Y') THEN
                   arp_etax_util.get_default_tax_classification(
                           p_ship_to_site_use_id => p_ship_to_site_use_id,
                           p_bill_to_site_use_id => p_bill_to_site_use_id,
                           p_inv_item_id         => line.inventory_item_id,
                           p_org_id              => l_organization_id,
                           p_sob_id              => l_sob_id,
                           p_warehouse_id        =>
                             NVL(line.warehouse_id, l_warehouse_id),
                           p_trx_date            => p_trx_date,
                           p_trx_type_id         => p_cust_trx_type_id,
                           p_cust_trx_id         => p_customer_trx_id,
                           p_cust_trx_line_id    => line.customer_trx_line_id,
                           p_customer_id         =>  NULL,
                           p_memo_line_id        => line.memo_line_id,
                           p_entity_code         => 'RA_CUSTOMER_TRX',
                           p_event_class_code    => l_event_class_code,
                           p_function_short_name => 'ACCT_DIST',
                           p_tax_classification_code => l_tax_code );

Line: 6951

		 update ra_customer_trx_lines
                   set tax_classification_code = l_tax_code,
		       autotax    = l_autotax
		 where customer_trx_line_id = line.customer_trx_line_id;

Line: 6958

   arp_util.debug('arp_ct_pkg.update_tax()-  ' ||
                      to_char(sysdate, 'HH:MI:SS'));

Line: 6964

        arp_util.debug('EXCEPTION:  arp_ct_pkg.update_tax()');