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

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

Line: 17


This procedure inserts a record in the eam_asset_meters table
--      Parameters      :
--      IN              :       P_API_VERSION	IN NUMBER	REQUIRED
--                              P_INIT_MSG_LIST IN VARCHAR2	OPTIONAL
--                                      DEFAULT = FND_API.G_FALSE
--                              P_COMMIT	IN VARCHAR2	OPTIONAL
--                                      DEFAULT = FND_API.G_FALSE
--                              P_VALIDATION_LEVEL IN NUMBER	OPTIONAL
--                                      DEFAULT = FND_API.G_VALID_LEVEL_FULL
--				p_meter_id		in	not null number ,
--				p_organization_id		in	not null number ,
--				p_asset_group_id		in	not null number ,
--				p_asset_number		in    varchar2 default null,
--				p_maintenance_object_type	in    number  default null,
--				p_maintenance_object_id	in    number  default null,
--
--      OUT             :       x_return_status    OUT NOCOPY    VARCHAR2(1)
--                              x_msg_count        OUT NOCOPY    NUMBER
--                              x_msg_data         OUT NOCOPY    VARCHAR2 (2000)
--				x_new_set_name_id	OUT	NOCOPY	NUMBER
--      Version :       Current version: 1.0
--                      Initial version: 1.0
*/

PROCEDURE Insert_AssetMeterAssoc
(
	p_api_version		           IN	          Number,
	p_init_msg_list		         IN	          VARCHAR2 := FND_API.G_FALSE,
	p_commit	    	           IN  	        VARCHAR2 := FND_API.G_FALSE,
	p_validation_level	       IN  	        NUMBER   := FND_API.G_VALID_LEVEL_FULL,
	x_return_status		         OUT	NOCOPY  VARCHAR2,
	x_msg_count		             OUT	NOCOPY  Number,
	x_msg_data		             OUT	NOCOPY  VARCHAR2,
	p_meter_id		             IN	          Number,
/*	The user can supply one of the following two combinations to identify the
maintained item / number: the (org_id, inventory_item_id, serial_number)
combination or (maintenance_object_type, maintenance_object_id,
creation_organization_id) combination. Thus all of these input parameters
should be default to null.*/
	p_organization_id	         IN	          NUMBER DEFAULT NULL,
	p_asset_group_id	         IN	          NUMBER DEFAULT NULL,
	p_asset_number		         IN	          VARCHAR2 DEFAULT NULL,
	p_maintenance_object_type  IN	          NUMBER  DEFAULT NULL,
	p_maintenance_object_id	   IN	          NUMBER  DEFAULT NULL,
	p_primary_failure_flag	   IN	          VARCHAR2  DEFAULT 'N',
  p_ATTRIBUTE_CATEGORY       IN           VARCHAR2 default null,
  p_ATTRIBUTE1               IN           VARCHAR2 default null,
  p_ATTRIBUTE2               IN           VARCHAR2 default null,
  p_ATTRIBUTE3               IN           VARCHAR2 default null,
  p_ATTRIBUTE4               IN           VARCHAR2 default null,
  p_ATTRIBUTE5               IN           VARCHAR2 default null,
  p_ATTRIBUTE6               IN           VARCHAR2 default null,
  p_ATTRIBUTE7               IN           VARCHAR2 default null,
  p_ATTRIBUTE8               IN           VARCHAR2 default null,
  p_ATTRIBUTE9               IN           VARCHAR2 default null,
  p_ATTRIBUTE10              IN           VARCHAR2 default null,
  p_ATTRIBUTE11              IN           VARCHAR2 default null,
  p_ATTRIBUTE12              IN           VARCHAR2 default null,
  p_ATTRIBUTE13              IN           VARCHAR2 default null,
  p_ATTRIBUTE14              IN           VARCHAR2 default null,
  p_ATTRIBUTE15              IN           VARCHAR2 default null,
  p_start_date_active        IN           DATE default NULL,
  p_end_date_active          IN           DATE default null
)
IS
l_api_name	CONSTANT VARCHAR2(30)	:='Insert_AssetMeterAssoc';

Line: 103


	SAVEPOINT Insert_AssetMeterAssoc_PUB;

Line: 110


		'==================== Entered EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');

Line: 148


    		select 'Y' into l_exists_primary_flag
    		from dual
    		where exists
    		(select * from csi_ctr_item_associations
    		 where inventory_item_id = p_asset_group_id
    		 and (end_date_active is null or end_date_active > sysdate)
    		 and nvl(primary_failure_flag, 'N') = 'Y');

Line: 221


				  SELECT instance_id
				  INTO l_maintenance_object_id
				FROM csi_item_instances
				WHERE serial_number = p_asset_number
				  AND inventory_item_id = p_asset_group_id;

Line: 242


    		select 'Y' into l_exists_primary_flag
    		from dual
    		where exists
    		(select * from csi_counter_associations
    		 where source_object_id = l_maintenance_object_id
    		 and (end_date_active is null or end_date_active > sysdate)
    		 and nvl(primary_failure_flag, 'N') = 'Y');

Line: 287


            select 1 into l_exists
            from csi_counter_associations
            where counter_id = p_meter_id AND source_object_id =l_maintenance_object_id;

Line: 305


	SELECT object_version_number, instance_association_id
        INTO l_object_version_number, l_association_id
		FROM csi_counter_associations
		WHERE source_object_id=l_maintenance_object_id and counter_id=p_meter_id;

Line: 314


      	csi_counter_pub.update_ctr_associations(p_api_version,
                                            p_commit,
                                            p_init_msg_list,
                                            p_validation_level,
                                            l_counter_associations_tbl,
                                            x_return_status,
                                            x_msg_count,
                                            x_msg_data);

Line: 372


		'==================== Exiting EAM_MeterAssoc_PUB.Insert_AssetMeterAssoc ====================');

Line: 377


		ROLLBACK TO Insert_AssetMeterAssoc_PUB;

Line: 380


		     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');

Line: 382


		        '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||
			'==================== Calling FND_MSG_PUB.get ====================');

Line: 395


		ROLLBACK TO Insert_AssetMeterAssoc_PUB;

Line: 398


		     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Insert_AssetMeterAssoc_PUB');

Line: 400


		        '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||
			'==================== Calling FND_MSG_PUB.get ====================');

Line: 413


		ROLLBACK TO Insert_AssetMeterAssoc_PUB;

Line: 416


		     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');

Line: 418


		        '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');

Line: 453


END Insert_AssetMeterAssoc;

Line: 457


This procedure updates a record in the eam_asset_meters table
--      Parameters      :
--      IN              :       p_api_version	IN NUMBER	REQUIRED
--                              P_INIT_MSG_LIST IN VARCHAR2	OPTIONAL
--                                      DEFAULT = FND_API.G_FALSE
--                              P_COMMIT	IN VARCHAR2	OPTIONAL
--                                      DEFAULT = FND_API.G_FALSE
--                              P_VALIDATION_LEVEL IN NUMBER	OPTIONAL
--                                      DEFAULT = FND_API.G_VALID_LEVEL_FULL
--				p_meter_id		in	not null number ,
--				p_organization_id		in	not null number
--
--
--      OUT             :       x_return_status    OUT NOCOPY    VARCHAR2(1)
--                              x_msg_count        OUT NOCOPY    NUMBER
--                              x_msg_data         OUT NOCOPY    VARCHAR2 (2000)
--      Version :       Current version: 1.0
--                      Initial version: 1.0
--
*/
PROCEDURE Update_AssetMeterAssoc
(
	p_api_version		           IN	          Number,
	p_init_msg_list		         IN	          VARCHAR2 := FND_API.G_FALSE,
	p_commit	    	           IN  	        VARCHAR2 := FND_API.G_FALSE,
	p_validation_level	       IN  	        NUMBER   := FND_API.G_VALID_LEVEL_FULL,
	x_return_status		         OUT	NOCOPY  VARCHAR2,
	x_msg_count		             OUT	NOCOPY  Number,
	x_msg_data		             OUT	NOCOPY  VARCHAR2,
  p_association_id           IN           Number,
  p_primary_failure_flag	   IN	          VARCHAR2  DEFAULT 'N',
  p_ATTRIBUTE_CATEGORY       IN           VARCHAR2 default null,
  p_ATTRIBUTE1               IN           VARCHAR2 default null,
  p_ATTRIBUTE2               IN           VARCHAR2 default null,
  p_ATTRIBUTE3               IN           VARCHAR2 default null,
  p_ATTRIBUTE4               IN           VARCHAR2 default null,
  p_ATTRIBUTE5               IN           VARCHAR2 default null,
  p_ATTRIBUTE6               IN           VARCHAR2 default null,
  p_ATTRIBUTE7               IN           VARCHAR2 default null,
  p_ATTRIBUTE8               IN           VARCHAR2 default null,
  p_ATTRIBUTE9               IN           VARCHAR2 default null,
  p_ATTRIBUTE10              IN           VARCHAR2 default null,
  p_ATTRIBUTE11              IN           VARCHAR2 default null,
  p_ATTRIBUTE12              IN           VARCHAR2 default null,
  p_ATTRIBUTE13              IN           VARCHAR2 default null,
  p_ATTRIBUTE14              IN           VARCHAR2 default null,
  p_ATTRIBUTE15              IN           VARCHAR2 default null,
  p_end_date_active          IN           DATE     DEFAULT NULL,
  p_tmpl_flag                IN           VARCHAR2 DEFAULT 'N'
)
IS
p_creation_organization_id NUMBER;

Line: 509


l_api_name			CONSTANT VARCHAR2(30)	:='update asset meter';

Line: 527


	SAVEPOINT Update_AssetMeterAssoc_PUB;

Line: 534


		'==================== Entered EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');

Line: 562


		SELECT ccia.object_version_number, inventory_item_id
		INTO l_object_version_number, l_asset_group_id
		FROM csi_ctr_item_associations ccia
		WHERE ccia.ctr_association_id = p_association_id;

Line: 577


		select 'Y' into l_exists_primary_flag
		from dual
		where exists
		(select * from csi_ctr_item_associations
		 where inventory_item_id = l_asset_group_id
		 and (end_date_active is null or end_date_active > sysdate)
		 and ctr_association_id <> p_association_id
		 and nvl(primary_failure_flag, 'N') = 'Y');

Line: 622


		'==================== Calling csi_counter_template_pub.update_item_association ===================='
		||'x_return_status:'||x_return_status
				||' x_msg_count:'||x_msg_count
				||'x_msg_data:'||x_msg_data);

Line: 627


  	csi_counter_template_pub.update_item_association(p_api_version,
                                                     p_commit,
                                                     p_init_msg_list,
                                                     p_validation_level,
                                                     l_ctr_item_association_rec,
                                                     x_return_status,
                                                     x_msg_count,
                                                     x_msg_data);

Line: 637


		'==================== Returned from csi_counter_template_pub.update_item_association ===================='
		||'x_return_status:'||x_return_status
				||' x_msg_count:'||x_msg_count
				||'x_msg_data:'||x_msg_data);

Line: 644


  	SELECT cca.object_version_number
		INTO l_object_version_number
		FROM csi_counter_associations cca
		WHERE cca.instance_association_id = p_association_id;

Line: 660


		select 'Y' into l_exists_primary_flag
		from dual
		where exists
		(select * from csi_counter_associations
		 where source_object_id = l_maint_object_id
		 and (end_date_active is null or end_date_active > sysdate)
		 and instance_association_id <> p_association_id
		 and nvl(primary_failure_flag, 'N') = 'Y');

Line: 704


		'==================== Calling csi_counter_template_pub.update_ctr_associations ===================='
		||'x_return_status:'||x_return_status
				||' x_msg_count:'||x_msg_count
				||'x_msg_data:'||x_msg_data);

Line: 709


  	csi_counter_pub.update_ctr_associations(p_api_version,
                                            p_commit,
                                            p_init_msg_list,
                                            p_validation_level,
                                            l_counter_associations_tbl,
                                            x_return_status,
                                            x_msg_count,
                                            x_msg_data);

Line: 719


		'==================== Returned from csi_counter_template_pub.update_ctr_associations ===================='
		||'x_return_status:'||x_return_status
				||' x_msg_count:'||x_msg_count
				||'x_msg_data:'||x_msg_data);

Line: 750


		'==================== Exiting EAM_MeterAssoc_PUB.Update_AssetMeterAssoc ====================');

Line: 754


		ROLLBACK TO Update_AssetMeterAssoc_PUB;

Line: 759


		     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');

Line: 761


		        '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: EXPECTED ERROR======='||
			'==================== Calling FND_MSG_PUB.get ====================');

Line: 777


		ROLLBACK TO Update_AssetMeterAssoc_PUB;

Line: 780


		     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');

Line: 782


		        '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: UNEXPECTED ERROR======='||
			'==================== Calling FND_MSG_PUB.get ====================');

Line: 795


		ROLLBACK TO Update_AssetMeterAssoc_PUB;

Line: 799


		     FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,'ROLLBACK TO Update_AssetMeterAssoc_PUB');

Line: 801


		        '===================EAM_MeterAssoc_PUB.Update_AssetMeterAssoc: OTHERS ERROR=======');

Line: 834


END Update_AssetMeterAssoc;

Line: 840


	l_api_name	CONSTANT VARCHAR2(30)	:='Insert_AssetMeterAssoc';