APPS.CSP_CMERGE SQL Statements

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

Line: 4

/* Call all the blocks to update all the table for Service merge.
   Below is a diagram of the calling sequence.

    CSP_CMERGE.MERGE ( all tables for CS )
               |
               |---CSP_CMERGE_BB1.MERGE ( table cs_access_control_templates )
               |             |
               |              CS_MERGE_SYS_INSTALL_SITE_ID
	       |	      CS_MERGE_SYS_SHIP_USE_ID
	       |	      CS_MERGE_CP_INSTALL_SITE_ID
      	       |              CS_MERGE_CP_SHIP_SITE_ID
               |              CS_MERGE_CUSTOMER_ID
               |              CS_CHECK_MERGE_DATA
	       |
               |---CSP_CMERGE_BB2.MERGE ( table cs_customer_products )
               |              |
               |               CS_MERGE_BILL_TO_SITE_ID
	       |	       CS_MERGE_INSTALL_SITE_ID
               |               CS_MERGE_SHIP_TO_SITE_ID
	       |	       CS_MERGE_ORDER_BILL_TO_SITE_ID
      	       |	       CS_MERGE_ORDER_SHIP_TO_SITE_ID
               |               CS_MERGE_CUSTOMER_ID
               |
               |---CSP_CMERGE_BB3.MERGE ( table cs_systems )
               |              |
               |               CS_MERGE_BILL_TO_SITE_ID
	       |	       CS_MERGE_INSTALL_SITE_ID
               |               CS_MERGE_SHIP_TO_SITE_ID
               |               CS_MERGE_CUSTOMER_ID
               |               CS_CHECK_MERGE_DATA
	       |
               |---CSP_CMERGE_BB4.MERGE ( table cs_templates_interface )
               |              |
               |               CS_MERGE_SYS_INSTALL_SITE_ID
               |               CS_MERGE_SYS_SHIP_TO_SITE_ID
	          |	           CS_MERGE_CP_INSTALL_SITE_ID
               |               CS_MERGE_CP_SHIP_TO_SITE_ID

               |               CS_MERGE_CUSTOMER_ID
               |               CS_CHECK_MERGE_DATA
               |
               |---CSP_CMERGE_BB5.MERGE ( table cs_mass_notification_txns_temp )
               |              |
               |              CS_MERGE_CUSTOMER_ID
               |
               |---CSP_CMERGE_BB6.MERGE ( table cs_mass_service_txns_temp )
                              |
               |              CS_MERGE_CUSTOMER_ID
			|
	          |---CSP_CMERGE_BB7.MERGE (table cs_repairs)
			|			|
		     |			RMA_CUSTOMER_ID
               |
               |---CSP_CMERGE_BB8.MERGE (table cs_incidents)
			|              |
	          |			CUSTOMER_ID
		     |			SHIP_TO_SITE_USE_ID
		     | 			BILL_TO_SITE_USE_ID
		     |			INSTALL_TO_SITE_USE_ID



                      								    */

PROCEDURE MERGE ( req_id       IN NUMBER,
                  set_number   IN NUMBER,
                  process_mode IN VARCHAR2 ) IS

/* used to store a free form text to be written to the log file */

        message_text          VARCHAR2(255);

Line: 81

	updates record in CS_SYSTEM table now this table is a view on
	CS_SYSTEM_B and CS_SYSTEM_TL. This endup in failing customer merge
	in one of the AR's customer merge program. To avoid such kind of
	problems before CS release return is added.
   */

   RETURN;