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

APPS.ARW_CMREQ_COVER SQL Statements

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

Line: 65


      SELECT payment_schedule_id , due_date , dispute_date , amount_in_dispute
         FROM  ar_payment_schedules ps
         WHERE  ps.customer_trx_id = p_customer_trx_id;

Line: 72


      SELECT terms_sequence_number,payment_schedule_id , due_date , dispute_date , amount_in_dispute ,
	 amount_due_remaining,amount_due_original
         FROM  ar_payment_schedules ps
         WHERE  ps.customer_trx_id = p_customer_trx_id
         ORDER BY terms_sequence_number ;

Line: 98


 /* Insert Request information into Candidate table */

    /*-----------------------------------------+
     | Get the unique identifier for request_id|
     +-----------------------------------------*/

  select ra_cm_requests_s.nextval
  into l_request_id
  from sys.dual;

Line: 124


     | Insert Record into Request Table        |
     +-----------------------------------------*/

  /*4556000-4606558 added additional columns*/
  INSERT INTO ra_cm_requests
            (request_id,
             customer_trx_id,
             cm_customer_trx_id,
             url,
             line_credits_flag,
             line_amount,
             tax_amount,
             freight_amount,
             cm_reason_code,
             comments,
             status,
             approval_date,
             last_update_date,
             last_updated_by,
             creation_date,
             created_by,
             last_update_login,
             transaction_url,
	     activities_url,
             orig_trx_number,
 	     tax_ex_cert_num,
             org_id,
	     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,
	     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,
	     DISPUTE_DATE,
             INTERNAL_COMMENT,
	     RESPONSIBILITY_ID   /* Bug 8832584 */
            )
         VALUES
           (
            l_request_id,
            p_customer_trx_id,
            NULL,
            l_url,
            p_line_credits_flag,
            p_line_amount,
            p_tax_amount,
            p_freight_amount,
            p_cm_reason_code,
            p_comments,
            'PENDING_APPROVAL',
                 NULL,
	    arp_global.last_update_date,
	    arp_global.last_updated_by,
	    arp_global.creation_date,
	    arp_global.created_by,
	    arp_global.last_update_login,
            p_transaction_url,
	    p_trans_act_url,
	    p_orig_trx_number,
            p_tax_ex_cert_num,
            arp_standard.sysparm.org_id,
            pq_interface_attribute_rec.interface_header_context,
            pq_interface_attribute_rec.interface_header_attribute1,
            pq_interface_attribute_rec.interface_header_attribute2,
            pq_interface_attribute_rec.interface_header_attribute3,
            pq_interface_attribute_rec.interface_header_attribute4,
            pq_interface_attribute_rec.interface_header_attribute5,
            pq_interface_attribute_rec.interface_header_attribute6,
            pq_interface_attribute_rec.interface_header_attribute7,
            pq_interface_attribute_rec.interface_header_attribute8,
            pq_interface_attribute_rec.interface_header_attribute9,
            pq_interface_attribute_rec.interface_header_attribute10,
            pq_interface_attribute_rec.interface_header_attribute11,
            pq_interface_attribute_rec.interface_header_attribute12,
            pq_interface_attribute_rec.interface_header_attribute13,
            pq_interface_attribute_rec.interface_header_attribute14,
            pq_interface_attribute_rec.interface_header_attribute15,
	    pq_attribute_rec.attribute_category,
	    pq_attribute_rec.attribute1,
	    pq_attribute_rec.attribute2,
	    pq_attribute_rec.attribute3,
	    pq_attribute_rec.attribute4,
	    pq_attribute_rec.attribute5,
	    pq_attribute_rec.attribute6,
	    pq_attribute_rec.attribute7,
	    pq_attribute_rec.attribute8,
	    pq_attribute_rec.attribute9,
	    pq_attribute_rec.attribute10,
	    pq_attribute_rec.attribute11,
	    pq_attribute_rec.attribute12,
	    pq_attribute_rec.attribute13,
	    pq_attribute_rec.attribute14,
	    pq_attribute_rec.attribute15,
            pq_global_attribute_rec.global_attribute_category,
            pq_global_attribute_rec.global_attribute1,
            pq_global_attribute_rec.global_attribute2,
            pq_global_attribute_rec.global_attribute3,
            pq_global_attribute_rec.global_attribute4,
            pq_global_attribute_rec.global_attribute5,
            pq_global_attribute_rec.global_attribute6,
            pq_global_attribute_rec.global_attribute7,
            pq_global_attribute_rec.global_attribute8,
            pq_global_attribute_rec.global_attribute9,
            pq_global_attribute_rec.global_attribute10,
            pq_global_attribute_rec.global_attribute11,
            pq_global_attribute_rec.global_attribute12,
            pq_global_attribute_rec.global_attribute13,
            pq_global_attribute_rec.global_attribute14,
            pq_global_attribute_rec.global_attribute15,
            pq_global_attribute_rec.global_attribute16,
            pq_global_attribute_rec.global_attribute17,
            pq_global_attribute_rec.global_attribute18,
            pq_global_attribute_rec.global_attribute19,
            pq_global_attribute_rec.global_attribute20,
            pq_global_attribute_rec.global_attribute21,
            pq_global_attribute_rec.global_attribute22,
            pq_global_attribute_rec.global_attribute23,
            pq_global_attribute_rec.global_attribute24,
            pq_global_attribute_rec.global_attribute25,
            pq_global_attribute_rec.global_attribute26,
            pq_global_attribute_rec.global_attribute27,
            pq_global_attribute_rec.global_attribute28,
            pq_global_attribute_rec.global_attribute29,
            pq_global_attribute_rec.global_attribute30,
	    p_dispute_date,
	    p_internal_comment,
	    FND_GLOBAL.RESP_ID   /* Bug 8832584 */
	    );

Line: 318


             INSERT into ra_cm_request_lines
             ( request_id,
               customer_trx_line_id,
               extended_amount,
               last_update_date,
               last_updated_by,
               creation_date,
               created_by,
               last_update_login,
	       quantity,
	       price,
	       org_id,
	      INTERFACE_LINE_CONTEXT,
	      INTERFACE_LINE_ATTRIBUTE1,
	      INTERFACE_LINE_ATTRIBUTE2,
	      INTERFACE_LINE_ATTRIBUTE3,
	      INTERFACE_LINE_ATTRIBUTE4,
	      INTERFACE_LINE_ATTRIBUTE5,
	      INTERFACE_LINE_ATTRIBUTE6,
	      INTERFACE_LINE_ATTRIBUTE7,
	      INTERFACE_LINE_ATTRIBUTE8,
	      INTERFACE_LINE_ATTRIBUTE9,
	      INTERFACE_LINE_ATTRIBUTE10,
	      INTERFACE_LINE_ATTRIBUTE11,
	      INTERFACE_LINE_ATTRIBUTE12,
	      INTERFACE_LINE_ATTRIBUTE13,
	      INTERFACE_LINE_ATTRIBUTE14,
	      INTERFACE_LINE_ATTRIBUTE15,
	      ATTRIBUTE_CATEGORY        ,
	      ATTRIBUTE1                ,
	      ATTRIBUTE2                ,
	      ATTRIBUTE3                ,
	      ATTRIBUTE4                ,
	      ATTRIBUTE5                ,
	      ATTRIBUTE6                ,
	      ATTRIBUTE7                ,
	      ATTRIBUTE8                ,
	      ATTRIBUTE9                ,
	      ATTRIBUTE10               ,
	      ATTRIBUTE11               ,
	      ATTRIBUTE12               ,
	      ATTRIBUTE13               ,
	      ATTRIBUTE14               ,
	      ATTRIBUTE15               ,
	      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
	       )
             VALUES
              (l_request_id,
               p_cm_lines_tbl(i).customer_trx_line_id,
               p_cm_lines_tbl(i).extended_amount,
	       arp_global.last_update_date,
	       arp_global.last_updated_by,
	       arp_global.creation_date,
	       arp_global.created_by,
	       arp_global.last_update_login,
	       p_cm_lines_tbl(i).quantity_credited,
	       p_cm_lines_tbl(i).price,
               arp_standard.sysparm.org_id,
	      p_cm_lines_tbl(i).INTERFACE_LINE_CONTEXT,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE1,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE2,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE3,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE4,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE5,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE6,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE7,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE8,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE9,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE10,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE11,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE12,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE13,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE14,
	      p_cm_lines_tbl(i).INTERFACE_LINE_ATTRIBUTE15,
	      p_cm_lines_tbl(i).ATTRIBUTE_CATEGORY        ,
	      p_cm_lines_tbl(i).ATTRIBUTE1                ,
	      p_cm_lines_tbl(i).ATTRIBUTE2                ,
	      p_cm_lines_tbl(i).ATTRIBUTE3                ,
	      p_cm_lines_tbl(i).ATTRIBUTE4                ,
	      p_cm_lines_tbl(i).ATTRIBUTE5                ,
	      p_cm_lines_tbl(i).ATTRIBUTE6                ,
	      p_cm_lines_tbl(i).ATTRIBUTE7                ,
	      p_cm_lines_tbl(i).ATTRIBUTE8                ,
	      p_cm_lines_tbl(i).ATTRIBUTE9                ,
	      p_cm_lines_tbl(i).ATTRIBUTE10               ,
	      p_cm_lines_tbl(i).ATTRIBUTE11               ,
	      p_cm_lines_tbl(i).ATTRIBUTE12               ,
	      p_cm_lines_tbl(i).ATTRIBUTE13               ,
	      p_cm_lines_tbl(i).ATTRIBUTE14               ,
	      p_cm_lines_tbl(i).ATTRIBUTE15               ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE_CATEGORY ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE1         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE2         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE3         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE4         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE5         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE6         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE7         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE8         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE9         ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE10        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE11        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE12        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE13        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE14        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE15        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE16        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE17        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE18        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE19        ,
	      p_cm_lines_tbl(i).GLOBAL_ATTRIBUTE20
	       );

Line: 464


       UPDATE ra_cm_requests
       SET total_amount = l_dispute_amount
       WHERE request_id = l_request_id;

Line: 472


   SELECT max(terms_sequence_number) into l_max_seq FROM AR_PAYMENT_SCHEDULES
   WHERE customer_trx_id=p_customer_trx_id;

Line: 492


                   ps_rec.dispute_date := arp_global.last_update_date;

Line: 498


                ps_rec.dispute_date := arp_global.last_update_date;

Line: 503


							      UPDATE ar_payment_schedules set amount_in_dispute=l_run_dispute_amount,
										              dispute_date=arp_global.last_update_date
								     where customer_trx_id=p_customer_trx_id and
									   terms_sequence_number=ps_rec.terms_sequence_number;

Line: 516


                arp_process_cutil.update_ps
                     (p_ps_id=> ps_rec.payment_schedule_id,
	              p_due_date=> ps_rec.due_date,
	              --p_amount_in_dispute=> ps_rec.amount_in_dispute,
	              p_amount_in_dispute=> l_run_dispute_amount,     /*12998583*/
	              p_dispute_date=> ps_rec.dispute_date,
                      p_update_dff => 'N',
	              p_attribute_category=>NULL,
	              p_attribute1=>NULL,
	              p_attribute2=>NULL,
	              p_attribute3=>NULL,
	              p_attribute4=>NULL,
	              p_attribute5=>NULL,
	              p_attribute6=>NULL,
	              p_attribute7=>NULL,
	              p_attribute8=>NULL,
	              p_attribute9=>NULL,
	              p_attribute10=>NULL,
	              p_attribute11=>NULL,
	              p_attribute12=>NULL,
	              p_attribute13=>NULL,
	              p_attribute14=>NULL,
	              p_attribute15=>NULL );

Line: 563


        /*Bug 5481525 get if CM is created and update status accordingly*/
        l_credit_memo_id :=-99;

Line: 566


          select cm_customer_trx_id
          into l_credit_memo_id
          from ra_cm_requests
          where request_id = l_request_id;

Line: 575


        update ra_cm_requests
        set status= DECODE(nvl(l_credit_memo_id,-99),-99,'APPROVED_PEND_COMP','COMPLETE'),
            approval_date = SYSDATE,
            last_updated_by = arp_global.last_updated_by,
            last_update_date = arp_global.last_update_date,
            last_update_login = arp_global.last_update_login
        where request_id = l_request_id;

Line: 676


SELECT customer_trx_line_id, extended_amount, quantity, price,
	      INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2,
	      INTERFACE_LINE_ATTRIBUTE3, INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5,
	      INTERFACE_LINE_ATTRIBUTE6, INTERFACE_LINE_ATTRIBUTE7, INTERFACE_LINE_ATTRIBUTE8,
	      INTERFACE_LINE_ATTRIBUTE9, INTERFACE_LINE_ATTRIBUTE10, INTERFACE_LINE_ATTRIBUTE11,
	      INTERFACE_LINE_ATTRIBUTE12, INTERFACE_LINE_ATTRIBUTE13, INTERFACE_LINE_ATTRIBUTE14,
	      INTERFACE_LINE_ATTRIBUTE15, ATTRIBUTE_CATEGORY        , ATTRIBUTE1                ,
	      ATTRIBUTE2                , ATTRIBUTE3                , ATTRIBUTE4                ,
	      ATTRIBUTE5                , ATTRIBUTE6                , ATTRIBUTE7                ,
	      ATTRIBUTE8                , ATTRIBUTE9                , ATTRIBUTE10               ,
	      ATTRIBUTE11               , ATTRIBUTE12               , ATTRIBUTE13               ,
	      ATTRIBUTE14               , ATTRIBUTE15               , 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
FROM ra_cm_request_lines
WHERE request_id=p_request_id;

Line: 720


  select customer_trx_id,
	  line_credits_flag,
          line_amount,
          tax_amount,
          freight_amount,
          cm_reason_code,
          comments ,
	  /*4556000-4606558 added few columns in our select statement*/
	  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, 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, DISPUTE_DATE, RESPONSIBILITY_ID
  into   l_customer_trx_id,l_line_credits_flag, l_line_amount,l_tax_amount,l_freight_amount,l_reason_code,
         l_comments,
	 /*4556000-4606558 added few columns*/
        pqa_interface_attribute_rec.interface_header_context,
        pqa_interface_attribute_rec.interface_header_attribute1,
        pqa_interface_attribute_rec.interface_header_attribute2,
        pqa_interface_attribute_rec.interface_header_attribute3,
        pqa_interface_attribute_rec.interface_header_attribute4,
        pqa_interface_attribute_rec.interface_header_attribute5,
        pqa_interface_attribute_rec.interface_header_attribute6,
        pqa_interface_attribute_rec.interface_header_attribute7,
        pqa_interface_attribute_rec.interface_header_attribute8,
        pqa_interface_attribute_rec.interface_header_attribute9,
        pqa_interface_attribute_rec.interface_header_attribute10,
        pqa_interface_attribute_rec.interface_header_attribute11,
        pqa_interface_attribute_rec.interface_header_attribute12,
        pqa_interface_attribute_rec.interface_header_attribute13,
        pqa_interface_attribute_rec.interface_header_attribute14,
        pqa_interface_attribute_rec.interface_header_attribute15,
	pqa_attribute_rec.attribute_category, pqa_attribute_rec.attribute1,
	pqa_attribute_rec.attribute2, pqa_attribute_rec.attribute3, pqa_attribute_rec.attribute4,
	pqa_attribute_rec.attribute5,pqa_attribute_rec.attribute6, pqa_attribute_rec.attribute7,
	pqa_attribute_rec.attribute8, pqa_attribute_rec.attribute9,pqa_attribute_rec.attribute10,
	pqa_attribute_rec.attribute11,pqa_attribute_rec.attribute12,pqa_attribute_rec.attribute13,
	pqa_attribute_rec.attribute14, pqa_attribute_rec.attribute15,
        pqa_global_attribute_rec.global_attribute_category, pqa_global_attribute_rec.global_attribute1,
        pqa_global_attribute_rec.global_attribute2, pqa_global_attribute_rec.global_attribute3,
        pqa_global_attribute_rec.global_attribute4, pqa_global_attribute_rec.global_attribute5,
        pqa_global_attribute_rec.global_attribute6, pqa_global_attribute_rec.global_attribute7,
        pqa_global_attribute_rec.global_attribute8, pqa_global_attribute_rec.global_attribute9,
        pqa_global_attribute_rec.global_attribute10, pqa_global_attribute_rec.global_attribute11,
        pqa_global_attribute_rec.global_attribute12, pqa_global_attribute_rec.global_attribute13,
        pqa_global_attribute_rec.global_attribute14, pqa_global_attribute_rec.global_attribute15,
        pqa_global_attribute_rec.global_attribute16, pqa_global_attribute_rec.global_attribute17,
        pqa_global_attribute_rec.global_attribute18, pqa_global_attribute_rec.global_attribute19,
        pqa_global_attribute_rec.global_attribute20, pqa_global_attribute_rec.global_attribute21,
        pqa_global_attribute_rec.global_attribute22, pqa_global_attribute_rec.global_attribute23,
        pqa_global_attribute_rec.global_attribute24, pqa_global_attribute_rec.global_attribute25,
 	pqa_global_attribute_rec.global_attribute26, pqa_global_attribute_rec.global_attribute27,
	pqa_global_attribute_rec.global_attribute28, pqa_global_attribute_rec.global_attribute29,
	pqa_global_attribute_rec.global_attribute30, l_dispute_date, l_responsibility_id /*Bug 8832584*/
  from   ra_cm_requests
  where  request_id = p_request_id;

Line: 815


  select *
  into l_trx_header_rec
  from ra_customer_trx
  where customer_trx_id = l_customer_trx_id;

Line: 825


    select batch_source_id
    into   l_batch_source_id
    from   ra_batch_sources
    where  name = p_batch_source_name
    and    org_id = l_trx_header_rec.org_id;

Line: 1206


	UPDATE ra_cm_requests
	SET    cm_customer_trx_id = l_cm_customer_trx_id
	WHERE  request_id = p_request_id;

Line: 1239


        update ra_cm_requests_all
           set status = 'CANCELLED'
         where request_id = l_itemkey;