APPS.QA_CUSTOMER SQL Statements

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

Line: 23

            SELECT qr.customer_id
            FROM   qa_results qr, ra_customer_merges m
            WHERE  qr.customer_id = m.duplicate_id AND
                   m.process_flag = 'N' AND
                   m.request_id = req_id AND
                   m.set_number = set_number AND
                   m.duplicate_id <> m.customer_id AND
                   m.delete_duplicate_flag = 'Y';

Line: 33

	Veto_Reason varchar2(300) := 'During account merge an old customer ID is found in QA_RESULTS table. The table is used to store archival info of test data.  The customer name can be used for auditing purpose and cannot be deleted';

Line: 39

            null; -- no update will be allowed later

Line: 46

QA should only veto the merge delete request.  If just a simple merge w/o
deleting the actual record, QA should simply let it go.
*/
                -- RAISE MERGE_NOT_ALLOWED;

Line: 50

	        ARP_CMERGE_MASTER.veto_delete(
                      req_id            =>        req_id,
                      set_num           =>        set_number,
                      from_customer_id  =>	  from_cust_id,
                      veto_reason       =>	  Veto_Reason
                );

Line: 58

                arp_message.set_name('AR', 'AR_ROWS_UPDATED');