APPS.EAM_ASSET_AREAS_PUB SQL Statements

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

Line: 64

        SELECT count(*) INTO l_count
	FROM   MTL_EAM_LOCATIONS
	WHERE  location_codes = p_location_codes
	  and  creation_organization_id = p_organization_id;

Line: 127

        SELECT COUNT(*) INTO l_count
	FROM MTL_EAM_LOCATIONS
	WHERE LOCATION_CODES = P_LOCATION_CODES AND
	      CREATION_ORGANIZATION_ID = P_CREATION_ORGANIZATION_ID;

Line: 151

PROCEDURE insert_asset_areas
( 	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_location_codes	        IN 	varchar2,
	p_start_date	        	IN 	date:=null,
	p_end_date		        IN 	date:=null,
	p_organization_id	        IN 	number,
	p_description	        	IN 	varchar2:=null,
	p_creation_organization_id	IN      number
)
IS
	l_api_name			CONSTANT VARCHAR2(30)	:= 'insert_asset_areas';

Line: 178

    SAVEPOINT	insert_asset_areas;

Line: 240

        INSERT INTO MTL_EAM_LOCATIONS
        (
		LOCATION_ID,
		LOCATION_CODES,
		START_DATE    ,
		END_DATE      ,
		ORGANIZATION_ID,
		DESCRIPTION    ,
		CREATION_ORGANIZATION_ID,

		CREATED_BY           ,
		CREATION_DATE       ,
		LAST_UPDATE_LOGIN  ,
		LAST_UPDATE_DATE  ,
		LAST_UPDATED_BY
	)
	VALUES
	(
		WIP_EAM_LOCATIONS_S.NEXTVAL,
		P_LOCATION_CODES ,
		P_START_DATE     ,
		P_END_DATE       ,
		P_ORGANIZATION_ID,
		P_DESCRIPTION    ,
		P_ORGANIZATION_ID,

		fnd_global.user_id,
		sysdate,
		fnd_global.login_id,
		sysdate    ,
		fnd_global.user_id
	);

Line: 285

		ROLLBACK TO insert_asset_areas;

Line: 292

		ROLLBACK TO insert_asset_areas;

Line: 299

		ROLLBACK TO insert_asset_areas;

Line: 313

END insert_asset_areas;

Line: 316

PROCEDURE update_asset_areas
( 	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_location_id	        	IN 	number,
	p_location_codes	        IN 	varchar2,
	p_start_date	        	IN 	date:=null,
	p_end_date		        IN 	date:=null,
	p_organization_id	        IN 	number,
	p_description	        	IN 	varchar2:=null,
	p_creation_organization_id	IN      number
)
IS
	l_api_name			CONSTANT VARCHAR2(30)	:= 'update_asset_areas';

Line: 346

    SAVEPOINT	update_asset_areas;

Line: 398

	SELECT COUNT(*) INTO l_count
	FROM MTL_EAM_LOCATIONS
	WHERE CREATION_ORGANIZATION_ID = P_CREATION_ORGANIZATION_ID
	AND LOCATION_ID = P_LOCATION_ID;

Line: 408

        SELECT COUNT(*) INTO l_count
	FROM MTL_EAM_LOCATIONS
	WHERE CREATION_ORGANIZATION_ID = P_CREATION_ORGANIZATION_ID
	AND LOCATION_ID <> P_LOCATION_ID
	AND LOCATION_CODES = P_LOCATION_CODES;

Line: 418

        UPDATE MTL_EAM_LOCATIONS
        SET
		LOCATION_CODES	=	P_LOCATION_CODES	,
		START_DATE	=	P_START_DATE	,
		END_DATE	=	P_END_DATE	,
		--ORGANIZATION_ID	=	P_ORGANIZATION_ID	, -- not for update
		DESCRIPTION	=	P_DESCRIPTION	,
		--CREATION_ORGANIZATION_ID = P_CREATION_ORGANIZATION_ID, --not to be updated as it is pk

		LAST_UPDATE_LOGIN = fnd_global.login_id ,
		LAST_UPDATE_DATE  = sysdate,
		LAST_UPDATED_BY   = fnd_global.user_id
	where
		LOCATION_ID = P_LOCATION_ID;

Line: 448

		ROLLBACK TO update_asset_areas;

Line: 455

		ROLLBACK TO update_asset_areas;

Line: 462

		ROLLBACK TO update_asset_areas;

Line: 476

END update_asset_areas;