APPS.EAM_ASSETATTR_GRP_PUB SQL Statements

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

Line: 11

/* This procedure inserts a record in the mtl_eam_asset_attr_groups 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_APPLICATION_ID		IN NUMBER
--				P_DESCRIPTIVE_FLEXFIELD_NAME	IN VARCHAR2
--					DEFAULT NULL
--				P_DESC_FLEX_CONTEXT_CODE	IN VARCHAR2
--					DEFAULT NULL
--				P_ORGANIZATION_ID	IN NUMBER
--				P_INVENTORY_ITEM_ID	IN NUMBER
--				P_ENABLED_FLAG		IN VARCHAR2
--					DEFAULT NULL
--				P_CREATION_ORGANIZATION_ID IN 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
--
--      Notes
--
-- End of comments

*/
/* for de-bugging */
/*g_sr_no		number ;*/

Line: 45

PROCEDURE INSERT_ASSETATTR_GRP
(	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_APPLICATION_ID		IN		NUMBER	DEFAULT 401			,
	P_DESCRIPTIVE_FLEXFIELD_NAME	IN		VARCHAR2  DEFAULT 'MTL_EAM_ASSET_ATTR_VALUES',
	P_DESC_FLEX_CONTEXT_CODE	IN		VARCHAR2 ,
	P_ORGANIZATION_ID		IN		NUMBER				,
	P_INVENTORY_ITEM_ID		IN		NUMBER				,
	P_ENABLED_FLAG			IN		VARCHAR2 DEFAULT 'Y',
	P_CREATION_ORGANIZATION_ID	IN		NUMBER				,
	X_NEW_ASSOCIATION_ID		OUT NOCOPY	NUMBER
)

IS

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

Line: 79

	SAVEPOINT INSERT_ASSETATTR_GRP_PUB;

Line: 205

	SELECT MTL_EAM_ASSET_ATTR_GROUPS_S.NEXTVAL INTO L_ASSOCIATION_ID FROM DUAL;

Line: 210

	INSERT INTO MTL_EAM_ASSET_ATTR_GROUPS
	(
		ASSOCIATION_ID		       ,
		APPLICATION_ID		       ,
		DESCRIPTIVE_FLEXFIELD_NAME     ,
		DESCRIPTIVE_FLEX_CONTEXT_CODE  ,
		ORGANIZATION_ID                ,
		INVENTORY_ITEM_ID              ,
		LAST_UPDATED_BY		       ,
		LAST_UPDATE_DATE               ,
		CREATED_BY                     ,
		CREATION_DATE                  ,
		LAST_UPDATE_LOGIN              ,
		ENABLED_FLAG                   ,
		CREATION_ORGANIZATION_ID
	)
	VALUES
	(
		L_ASSOCIATION_ID		,
		P_APPLICATION_ID		,
		P_DESCRIPTIVE_FLEXFIELD_NAME	,
		P_DESC_FLEX_CONTEXT_CODE	,
		P_ORGANIZATION_ID		,
		P_INVENTORY_ITEM_ID		,
		FND_GLOBAL.USER_ID		,
	        SYSDATE				,
		FND_GLOBAL.LOGIN_ID		,
	        SYSDATE				,
		FND_GLOBAL.USER_ID		,
		P_ENABLED_FLAG			,
		p_creation_organization_id
	);

Line: 255

		ROLLBACK TO INSERT_ASSETATTR_GRP_PUB;

Line: 263

		ROLLBACK TO INSERT_ASSETATTR_GRP_PUB;

Line: 271

		ROLLBACK TO INSERT_ASSETATTR_GRP_PUB;

Line: 288

END INSERT_ASSETATTR_GRP;

Line: 291

This procedure updates a record in the mtl_eam_asset_attr_groups 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_APPLICATION_ID		IN NUMBER
--				P_DESCRIPTIVE_FLEXFIELD_NAME	IN VARCHAR2
--					DEFAULT NULL
--				P_DESC_FLEX_CONTEXT_CODE	IN VARCHAR2
--					DEFAULT NULL
--				P_ORGANIZATION_ID	IN NUMBER
--				P_INVENTORY_ITEM_ID	IN NUMBER
--				P_ENABLED_FLAG		IN VARCHAR2
--					DEFAULT NULL
--				P_CREATION_ORGANIZATION_ID IN 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
--
--      Notes
*/

PROCEDURE UPDATE_ASSETATTR_GRP
(	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_APPLICATION_ID		IN		NUMBER DEFAULT 401				,
	P_DESCRIPTIVE_FLEXFIELD_NAME	IN		VARCHAR2  DEFAULT 'MTL_EAM_ASSET_ATTR_VALUES',
	P_DESC_FLEX_CONTEXT_CODE	IN		VARCHAR2 ,
	P_ORGANIZATION_ID		IN		NUMBER				,
	P_INVENTORY_ITEM_ID		IN		NUMBER				,
	P_ENABLED_FLAG			IN		VARCHAR2 DEFAULT 'Y',
	P_CREATION_ORGANIZATION_ID	IN		NUMBER
)
IS
	l_validated boolean;

Line: 339

	l_api_name			CONSTANT VARCHAR2(30)	:='UPDATE asset attr';

Line: 349

	SAVEPOINT UPDATE_ASSETATTR_GRP_PUB;

Line: 456

UPDATE MTL_EAM_ASSET_ATTR_GROUPS SET
	APPLICATION_ID		= P_APPLICATION_ID			,
	DESCRIPTIVE_FLEXFIELD_NAME	= P_DESCRIPTIVE_FLEXFIELD_NAME	,
	DESCRIPTIVE_FLEX_CONTEXT_CODE	= P_DESC_FLEX_CONTEXT_CODE	,
/*	ORGANIZATION_ID		= P_ORGANIZATION_ID			,
*/	INVENTORY_ITEM_ID	= P_INVENTORY_ITEM_ID			,
	ENABLED_FLAG		= P_ENABLED_FLAG
/*,	CREATION_ORGANIZATION_ID= x_creation_organization_id
*/
WHERE
	ASSOCIATION_ID		= P_ASSOCIATION_ID
	and creation_organization_id=p_creation_organization_id
	and inventory_item_id=p_inventory_item_id
	and descriptive_flex_context_code=p_desc_flex_context_code;

Line: 484

		ROLLBACK TO UPDATE_ASSETATTR_GRP_PUB;

Line: 492

		ROLLBACK TO UPDATE_ASSETATTR_GRP_PUB;

Line: 500

		ROLLBACK TO UPDATE_ASSETATTR_GRP_PUB;

Line: 517

END UPDATE_ASSETATTR_GRP;

Line: 546

	SELECT
		count(*) INTO L_status
	FROM
		FND_DESCR_FLEX_CONTEXTS_VL
	WHERE
		DESCRIPTIVE_FLEXFIELD_NAME = 'MTL_EAM_ASSET_ATTR_VALUES'
	AND
		ENABLED_FLAG = 'Y'
	AND
		APPLICATION_ID = P_APPLICATION_ID
	AND
		DESCRIPTIVE_FLEX_CONTEXT_CODE = P_DESC_FLEX_CONTEXT_CODE;

Line: 579

	SELECT count(*) INTO L_status
	FROM wip_eam_PARAMETERS
	WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 619

	SELECT count(*) INTO L_status
	FROM
		MTL_SYSTEM_ITEMS_KFV
	WHERE
		INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
	AND
		ORGANIZATION_ID = P_ORGANIZATION_ID
	AND
		(EAM_ITEM_TYPE = 1 or EAM_ITEM_TYPE=3);

Line: 647

	select eam_item_type into l_eam_item_type
	from mtl_system_items
	where inventory_item_id=p_inventory_item_id
	and rownum=1;

Line: 671

		select association_id into l_association_id
		from mtl_eam_asset_attr_groups
		where creation_organization_id=p_creation_organization_id
		and inventory_item_id=p_inventory_item_id
		and descriptive_flex_context_code=p_desc_flex_context_code;

Line: 678

		select association_id into l_association_id
                from mtl_eam_asset_attr_groups
                where inventory_item_id=p_inventory_item_id
                and descriptive_flex_context_code=p_desc_flex_context_code;

Line: 721

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