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.CSM_COUNTER_EVENT_PKG SQL Statements

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

Line: 43


SELECT cval.counter_value_id
FROM   csm_counter_values_acc acc,
       CSI_COUNTER_READINGS   cval
WHERE  acc.user_id 			= p_user_id
AND    acc.counter_value_id = cval.counter_value_id
AND    cval.counter_id 		= p_counter_id;

Line: 59


          CSM_ACC_PKG.Delete_Acc
                    ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
                     ,P_ACC_TABLE_NAME         => g_counter_val_acc_table_name
                     ,P_PK1_NAME               => g_counter_val_pk1_name
                     ,P_PK1_NUM_VALUE          => r_counter_value_rec.counter_value_id
                     ,P_USER_ID                => l_user_id
                    );

Line: 68


		 --bug 5253769 DELETE COUNTER  PROPERTY READINGS property for the user
		  CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL
		  			(P_COUNTER_VALUE_ID => r_counter_value_rec.counter_value_id,
					 P_USER_ID    => l_user_id,
					 P_ERROR_MSG  => p_error_msg,
					 X_RETURN_STATUS => x_return_status
					 );

Line: 97


SELECT acc.user_id
FROM   CSI_COUNTERS_B 		    counters
  ,    CS_CSI_COUNTER_GROUPS    counter_groups
  ,    csm_item_instances_acc   acc
  ,	   CSI_COUNTER_ASSOCIATIONS ass
WHERE  counters.counter_id 	   = ass.counter_id
AND	   ass.source_object_code  = 'CP'
AND    counters.counter_type   = 'REGULAR'
AND    ass.source_object_id    = acc.instance_id
AND    counters.counter_id 	   = b_counter_id
AND    counter_groups.counter_group_id(+) = counters.group_id;

Line: 118


    CSM_ACC_PKG.Delete_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
      ,P_ACC_TABLE_NAME         => g_counters_acc_table_name
      ,P_PK1_NAME               => g_counters_pk1_name
      ,P_PK1_NUM_VALUE          => p_counter_id
      ,P_USER_ID                => l_user_id
     );

Line: 126


	--bug 5253769 DELETE COUNTER property for the user
		  CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL
		  			(P_COUNTER_ID => p_counter_id,
					 P_USER_ID    => l_user_id,
					 P_ERROR_MSG  => p_error_msg,
					 X_RETURN_STATUS => x_return_status
					 );

Line: 172


    CSM_ACC_PKG.Delete_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
      ,P_ACC_TABLE_NAME         => g_counters_acc_table_name
      ,P_PK1_NAME               => g_counters_pk1_name
      ,P_PK1_NUM_VALUE          => p_counter_id
      ,P_USER_ID                => p_user_id
     );

Line: 180


	--bug 5253769 DELETE COUNTER property for the user
		  CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_DEL
		  			(P_COUNTER_ID => p_counter_id,
					 P_USER_ID    => p_user_id,
					 P_ERROR_MSG  => p_error_msg,
					 X_RETURN_STATUS => x_return_status
					 );

Line: 214


SELECT cval.counter_value_id
FROM   CSI_COUNTERS_B       	  cntrs,
	   CSI_COUNTER_READINGS		  cval,
	   CSI_COUNTER_ASSOCIATIONS   cas,
	   csm_item_instances_acc 	  acc
WHERE  cntrs.counter_id 		  = cas.counter_id
AND	   cas.source_object_code 	  = 'CP'
AND    cas.source_object_id 	  = p_instance_id
AND    cntrs.counter_id 		  = cval.counter_id
AND	   cas.source_object_id 	  = acc.instance_id
AND	   acc.user_id 			  	  = p_user_id
AND    cval.counter_id 			  = p_counter_id
AND 	EXISTS
(SELECT 1
 FROM 	csm_counter_values_acc vacc
 WHERE 	vacc.counter_value_id  = cval.counter_value_id
 AND 	vacc.user_id 		   = acc.user_id
 );

Line: 242


          CSM_ACC_PKG.Delete_Acc
                    ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
                     ,P_ACC_TABLE_NAME         => g_counter_val_acc_table_name
                     ,P_PK1_NAME               => g_counter_val_pk1_name
                     ,P_PK1_NUM_VALUE          => r_counter_value_rec.counter_value_id
                     ,P_USER_ID                => l_user_id
                    );

Line: 250


			 --bug 5253769 DELETE COUNTER  PROPERTY READINGS property for the user
		  CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL
		  			(P_COUNTER_VALUE_ID => r_counter_value_rec.counter_value_id,
					 P_USER_ID    => l_user_id,
					 P_ERROR_MSG  => p_error_msg,
					 X_RETURN_STATUS => x_return_status
					 );

Line: 286


SELECT acc.user_id,
       acc.access_id
FROM   csm_counters_acc acc
WHERE  acc.counter_id = p_counter_id;

Line: 316


 	--bug 5253769 UPDATE COUNTER property for the user
	  CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_UPD
		  			(P_COUNTER_ID => p_counter_id,
					 P_USER_ID    => l_resource_list,
					 P_ERROR_MSG  => p_error_msg,
					 X_RETURN_STATUS => x_return_status
					 );

Line: 356


SELECT  acc.user_id
FROM 	CSI_COUNTERS_B           ctr
   , 	CS_CSI_COUNTER_GROUPS    cgrp
   , 	csm_item_instances_acc   acc
   , 	CSI_COUNTER_ASSOCIATIONS cas
WHERE   ctr.counter_id 		    = cas.counter_id
AND	    cas.source_object_code  = 'CP'
AND     ctr.counter_type		= 'REGULAR'
AND     cgrp.counter_group_id(+)= ctr.group_id
AND     cas.source_object_id    = acc.instance_id
AND		ctr.counter_id      	= p_counter_id;

Line: 376


      CSM_ACC_PKG.Insert_Acc
             ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
              ,P_ACC_TABLE_NAME         => g_counters_acc_table_name
              ,P_SEQ_NAME               => g_counters_seq_name
              ,P_PK1_NAME               => g_counters_pk1_name
              ,P_PK1_NUM_VALUE          => p_counter_id
              ,P_USER_ID                => r_user_id_rec.user_id
             );

Line: 384


	  --R12 Inserting Relationship for each user
	  CSM_CNTR_RELATION_EVENT_PKG.COUNTER_RELATION_INS(p_counter_id,r_user_id_rec.user_id);

Line: 387


	   	--bug 5253769 INSERT COUNTER property for the user
	  CSM_COUNTER_PROPERTY_EVENT_PKG.COUNTER_PROPERTY_INS
		  			(P_COUNTER_ID => p_counter_id,
					 P_USER_ID    => r_user_id_rec.user_id,
					 P_ERROR_MSG  => p_error_msg,
					 X_RETURN_STATUS => x_return_status
					 );

Line: 425


SELECT  acc.user_id,
        cval.counter_value_id,
       	ctr.counter_id,
       	acc.instance_id
FROM 	CSI_COUNTER_READINGS	 cval,
		csi_counter_associations cas,
		csi_counters_b 			 ctr,
        csm_counters_acc 		 cnt_acc,
     	csm_item_instances_acc 	 acc
WHERE 	cval.transaction_id 	= p_counter_grp_log_id
AND 	cas.source_object_code 	= 'CP'
AND 	ctr.counter_id 			= cas.counter_id
AND 	acc.instance_id 		= cas.source_object_id
AND 	cnt_acc.user_id 		= acc.user_id
AND 	cnt_acc.counter_id 		= cval.counter_id
AND 	ctr.counter_id 			= cnt_acc.counter_id
AND  	ctr.counter_type 		= 'REGULAR';

Line: 448


SELECT cval.counter_value_id,
	   cval.value_timestamp
FROM   CSI_COUNTERS_B       	  cntrs,
	   CSI_COUNTER_READINGS		  cval,
	   CSI_COUNTER_ASSOCIATIONS   cas,
	   csm_item_instances_acc 	  iacc,
	   csm_counters_acc 		  acc
WHERE  acc.user_id 			  	  = p_user_id
AND    acc.counter_id 			  = p_counter_id
AND    iacc.user_id 			  = acc.user_id
AND	   cntrs.counter_id 		  = acc.counter_id
AND	   cntrs.counter_id 		  = cas.counter_id
AND	   cas.source_object_code 	  = 'CP'
AND    cas.source_object_id 	  = p_instance_id
AND    cntrs.counter_id 		  = cval.counter_id
AND	   cas.source_object_id 	  = iacc.instance_id
AND    cval.counter_id 			  = p_counter_id
AND EXISTS
	(SELECT 1
 	FROM 	csm_counter_values_acc cv_acc
 	WHERE 	cv_acc.user_id = acc.user_id
 	AND 	cv_acc.counter_value_id = cval.counter_value_id
	)
ORDER BY cval.value_timestamp desc;

Line: 488


      CSM_ACC_PKG.Insert_Acc
                ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
                 ,P_ACC_TABLE_NAME         => g_counter_val_acc_table_name
                 ,P_SEQ_NAME               => g_counters_seq_name
                 ,P_PK1_NAME               => g_counter_val_pk1_name
                 ,P_PK1_NUM_VALUE          => l_counter_value_id
                 ,P_USER_ID                => l_user_id
                );

Line: 497


	 --bug 5253769 INSERT COUNTER  PROPERTY READINGS property for the user
	  CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS
		  			(P_COUNTER_VALUE_ID => l_counter_value_id,
					 P_USER_ID    		=> l_user_id,
					 P_ERROR_MSG  		=> p_error_msg,
					 X_RETURN_STATUS 	=> x_return_status
					 );

Line: 516


          CSM_ACC_PKG.Delete_Acc
                    ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
                     ,P_ACC_TABLE_NAME         => g_counter_val_acc_table_name
                     ,P_PK1_NAME               => g_counter_val_pk1_name
                     ,P_PK1_NUM_VALUE          => l_max_counter_readings_rec.counter_value_id
                     ,P_USER_ID                => l_user_id
                    );

Line: 523


	 	--bug 5253769 DELETE COUNTER  PROPERTY READINGS property for the user
	  	 CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_DEL
		  			(P_COUNTER_VALUE_ID => l_max_counter_readings_rec.counter_value_id,
					 P_USER_ID    		=> l_user_id,
					 P_ERROR_MSG  		=> p_error_msg,
					 X_RETURN_STATUS 	=> x_return_status
					 );

Line: 573


SELECT acc.user_id,
       acc.access_id,
       cv.counter_value_id
FROM   csm_counter_values_acc acc,
       CSI_COUNTER_READINGS   cv
WHERE  acc.counter_value_id = cv.counter_value_id
AND    cv.transaction_id 	= p_counter_grp_log_id;

Line: 610


   	 	--bug 5253769 DELETE COUNTER  PROPERTY READINGS property for the user
	  	 CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_UPD
		  			(P_COUNTER_VALUE_ID => l_counter_value_id,
					 P_USER_ID    		=> r_user_id_rec.user_id,
					 P_ERROR_MSG  		=> p_error_msg,
					 X_RETURN_STATUS 	=> x_return_status
					 );

Line: 648


  CSM_ACC_PKG.Insert_Acc
    ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
     ,P_ACC_TABLE_NAME         => g_counters_acc_table_name
     ,P_SEQ_NAME               => g_counters_seq_name
     ,P_PK1_NAME               => g_counters_pk1_name
     ,P_PK1_NUM_VALUE          => p_counter_id
     ,P_USER_ID                => p_user_id
    );

Line: 692


SELECT cval.value_timestamp,
	   cval.counter_value_id
FROM   CSI_COUNTERS_B       	  cntrs,
	   CSI_COUNTER_READINGS		  cval,
	   CSI_COUNTER_ASSOCIATIONS   cas,
	   csm_counters_acc 		  cnt_acc,
	   csm_item_instances_acc 	  acc
WHERE  cntrs.counter_id 		  = cas.counter_id
AND	   cas.source_object_code 	  = 'CP'
AND    cas.source_object_id 	  = p_instance_id
AND    cntrs.counter_id 		  = cval.counter_id
AND	   cas.source_object_id 	  = acc.instance_id
AND	   acc.user_id 			  	  = p_user_id
AND	   acc.user_id 			  	  = cnt_acc.user_id
AND    cval.counter_id 			  = p_counter_id
AND    cval.counter_id 			  = cnt_acc.counter_id
ORDER  BY cval.value_timestamp desc;

Line: 725


        CSM_ACC_PKG.Insert_Acc
                ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
                 ,P_ACC_TABLE_NAME         => g_counter_val_acc_table_name
                 ,P_SEQ_NAME               => g_counters_seq_name
                 ,P_PK1_NAME               => g_counter_val_pk1_name
                 ,P_PK1_NUM_VALUE          => l_counter_value_id
                 ,P_USER_ID                => p_user_id
                );

Line: 734


  		--bug 5253769 INSERT COUNTER property Readings for the user
		  CSM_CTR_PROP_READ_EVENT_PKG.CTR_PROPERTY_READ_INS
		  			(P_COUNTER_VALUE_ID    => l_counter_value_id,
					 P_USER_ID       	   => p_user_id,
					 P_ERROR_MSG     	   => p_error_msg,
					 X_RETURN_STATUS 	   => x_return_status
					 );