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_ACTIVITYSUPN_PUB SQL Statements

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

Line: 16


This procedure inserts a record in the eam_suppression_relations table
     Parameters      :
     IN              :          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	,
				P_PARENT_ASSOCIATION_ID IN	NUMBER    ,
				P_CHILD_ASSOCIATION_ID  IN	NUMBER    ,
				P_TMPL_FLAG		IN	VARCHAR2 DEFAULT NULL,
				P_DESCRIPTION		IN	VARCHAR2 DEFAULT NULL,
				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,

		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 Insert_ActivitySupn
(
	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_parent_association_id IN	NUMBER    ,
	p_child_association_id  IN	NUMBER    ,
	p_tmpl_flag		IN	VARCHAR2 DEFAULT NULL,
	p_description		IN	VARCHAR2 DEFAULT NULL,
	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
)
IS
l_api_name			CONSTANT VARCHAR2(30)	:='insert activity suppression';

Line: 89


	SAVEPOINT Insert_ActivitySupn_PUB;

Line: 194


		INSERT INTO eam_suppression_relations
		(
			parent_association_id   ,
			child_association_id	,
/*	(ignored)	day_tolerance		,
	(ignored)	runtime_tolerance	,
*/
			tmpl_flag	,
			description     ,
			created_by      ,
			creation_date   ,
			last_update_login     ,
			last_update_date      ,
			last_updated_by       ,
			attribute_category    ,
			attribute1	,
			attribute2	,
			attribute3	,
			attribute4	,
			attribute5	,
			attribute6	,
			attribute7	,
			attribute8	,
			attribute9	,
			attribute10	,
			attribute11	,
			attribute12	,
			attribute13	,
			attribute14	,
			attribute15
		)
		VALUES
		(
			p_parent_association_id	,
			p_child_association_id  ,
			p_tmpl_flag		,
			p_description		,
			FND_GLOBAL.USER_ID	,
			SYSDATE			,
			FND_GLOBAL.LOGIN_ID	,
			SYSDATE			,
			FND_GLOBAL.USER_ID	,
			p_attribute_category    ,
			p_attribute1            ,
			p_attribute2            ,
			p_attribute3            ,
			p_attribute4            ,
			p_attribute5            ,
			p_attribute6            ,
			p_attribute7            ,
			p_attribute8            ,
			p_attribute9            ,
			p_attribute10           ,
			p_attribute11           ,
			p_attribute12           ,
			p_attribute13           ,
			p_attribute14           ,
			p_attribute15
		);

Line: 266


		ROLLBACK TO Insert_ActivitySupn_PUB;

Line: 274


		ROLLBACK TO Insert_ActivitySupn_PUB;

Line: 282


		ROLLBACK TO Insert_ActivitySupn_PUB;

Line: 299


END Insert_ActivitySupn;

Line: 303


This procedure updates a record in the eam_asset_meters table
      Parameters      :
      IN              :         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_PARENT_ASSOCIATION_ID IN    NUMBER    ,
				P_CHILD_ASSOCIATION_ID  IN    NUMBER    ,
				P_TMPL_FLAG	    IN	VARCHAR2 DEFAULT NULL,
				P_DESCRIPTION	    IN    VARCHAR2 DEFAULT NULL,
				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


      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_ActivitySupn
(
	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_parent_association_id IN	NUMBER    ,
	p_child_association_id  IN	NUMBER    ,
	p_tmpl_flag		IN	VARCHAR2 DEFAULT NULL,
	p_description		IN	VARCHAR2 DEFAULT NULL,
	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
)
IS
l_api_name			CONSTANT VARCHAR2(30)	:='update activity suppression';

Line: 379


	SAVEPOINT Update_ActivitySupn_PUB;

Line: 402


		--raise_error('NO_RECORD FOR UPDATE');

Line: 448


		UPDATE
			eam_suppression_relations
		SET
			description		= p_description	,
			attribute_category	= p_attribute_category	,
			attribute1		= p_attribute1	,
			attribute2		= p_attribute2	,
			attribute3		= p_attribute3	,
			attribute4		= p_attribute4	,
			attribute5		= p_attribute5	,
			attribute6		= p_attribute6	,
			attribute7		= p_attribute7	,
			attribute8		= p_attribute8	,
			attribute9		= p_attribute9	,
			attribute10		= p_attribute10	,
			attribute11		= p_attribute11	,
			attribute12		= p_attribute12	,
			attribute13		= p_attribute13	,
			attribute14		= p_attribute14	,
			attribute15		= p_attribute15
		WHERE
			parent_association_id = p_parent_association_id
		AND
			child_association_id  = p_child_association_id ;

Line: 484


		ROLLBACK TO Update_ActivitySupn_PUB;

Line: 492


		ROLLBACK TO Update_ActivitySupn_PUB;

Line: 500


		ROLLBACK TO Update_ActivitySupn_PUB;

Line: 517


END Update_ActivitySupn;

Line: 532


	/*SELECT 'Enabled' INTO l_status
	FROM mtl_parameters
	WHERE organization_id = p_organization_id
	AND NVL(EAM_ENABLED_FLAG, 'N') = 'Y';

Line: 561


/* CHECK THE SUPPRESSION RECORD EXISTS, FOR UPDATE CASE */
FUNCTION Validate_SuppressionRecord (p_parent_association_id NUMBER,
					p_child_association_id NUMBER)
	RETURN boolean
IS
	l_status varchar2(10);

Line: 568


	SELECT 'Exists' INTO l_status
	FROM eam_suppression_relations
	WHERE parent_association_id = p_parent_association_id
	AND child_association_id = p_child_association_id;

Line: 593


	SELECT count(*) INTO l_count
	FROM eam_suppression_relations a, eam_suppression_relations b
	WHERE a.parent_association_id = b.child_association_id
	AND a.child_association_id = b.parent_association_id
	AND a.parent_association_id = p_parent_association_id
	AND a.child_association_id  = p_child_association_id;

Line: 618


	SELECT 'Exists' INTO l_status
	FROM  mtl_eam_asset_activities
	WHERE ACTIVITY_ASSOCIATION_ID = p_association_id;

Line: 661


		SELECT inventory_item_id , organization_id , tmpl_flag
		INTO l_parent_assoc , l_parent_organization_id, l_tmpl_flag_p
		FROM mtl_eam_asset_activities
		WHERE activity_association_id = p_parent_association_id;

Line: 666


		SELECT inventory_item_id , organization_id , tmpl_flag
		INTO l_child_assoc , l_child_organization_id, l_tmpl_flag_c
		FROM mtl_eam_asset_activities
		WHERE activity_association_id = p_child_association_id;

Line: 671


		SELECT inventory_item_id , serial_number , organization_id, tmpl_flag
		INTO l_parent_assoc , l_parent_ser_num , l_parent_organization_id, l_tmpl_flag_p
		FROM mtl_eam_asset_activities
		WHERE activity_association_id = p_parent_association_id;

Line: 676


		SELECT inventory_item_id , serial_number , organization_id, tmpl_flag
		INTO l_child_assoc , l_child_ser_num , l_child_organization_id, l_tmpl_flag_c
		FROM mtl_eam_asset_activities
		WHERE activity_association_id = p_child_association_id;

Line: 708


	select maintenance_object_id, maintenance_object_type, tmpl_flag
	into l_parent_object_id, l_parent_object_type, l_tmpl_flag_p
	from  mtl_eam_asset_activities
	WHERE activity_association_id = p_parent_association_id;

Line: 713


	select maintenance_object_id, maintenance_object_type, tmpl_flag
	into l_child_object_id, l_child_object_type, l_tmpl_flag_c
	from  mtl_eam_asset_activities
	WHERE activity_association_id = p_child_association_id;

Line: 764


	INSERT into temp_isetup_api(msg,sr_no)
	VALUES (info,g_sr_no);