APPS.EAM_ITEM_PVT SQL Statements

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

Line: 7

PROCEDURE insert_item
(
	p_commit	    		IN  	VARCHAR2:= FND_API.G_FALSE
	, x_return_status		OUT 	NOCOPY VARCHAR2
	, x_msg_count			OUT 	NOCOPY NUMBER
	, x_msg_data	    		OUT 	NOCOPY VARCHAR2
	, x_item_id			OUT	NOCOPY NUMBER
	, p_asset_group		    	IN	VARCHAR2
	, p_segment1			IN	VARCHAR2
	, p_segment2			IN	VARCHAR2
	, p_segment3			IN	VARCHAR2
	, p_segment4			IN	VARCHAR2
	, p_segment5			IN	VARCHAR2
	, p_segment6			IN	VARCHAR2
	, p_segment7			IN	VARCHAR2
	, p_segment8			IN	VARCHAR2
	, p_segment9			IN	VARCHAR2
	, p_segment10			IN	VARCHAR2
	, p_segment11			IN	VARCHAR2
	, p_segment12			IN	VARCHAR2
	, p_segment13			IN	VARCHAR2
	, p_segment14			IN	VARCHAR2
	, p_segment15			IN	VARCHAR2
	, p_segment16			IN	VARCHAR2
	, p_segment17			IN	VARCHAR2
	, p_segment18			IN	VARCHAR2
	, p_segment19			IN	VARCHAR2
	, p_segment20			IN	VARCHAR2
	, P_SOURCE_TMPL_ID		IN	NUMBER
    	, p_template_name       	IN  	VARCHAR2
    	, p_organization_id     	IN  	NUMBER
    	, p_description         	IN  	VARCHAR2
    	, p_serial_generation   	IN  	NUMBER
    	, p_prefix_text         	IN  	VARCHAR2
    	, p_prefix_number       	IN  	VARCHAR2
    	, p_eam_item_type       	IN  	NUMBER
)
IS

	l_create_item_ver		NUMBER := 1.0;

Line: 55

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

Line: 85

		'==================== Entered EAM_ITEM_PVT.Insert_item ===================='
		|| 'p_organization_id = ' || p_organization_id
		|| 'p_eam_item_type = ' || p_eam_item_type||
		'Comms_NL_Trackable_Flag: '||l_asset_group.comms_nl_trackable_flag||
		' Inventory_Item_Flag: '||l_asset_group.Inventory_item_flag);

Line: 139

    select master_organization_id into l_master_org_id
    from mtl_parameters
    where organization_id = p_organization_id;

Line: 258

		'==================== Exiting EAM_ITEM_PVT.Insert_item ====================');

Line: 260

END INSERT_ITEM;

Line: 262

PROCEDURE update_item
(
	p_commit	    		IN  	VARCHAR2:= FND_API.G_FALSE
	, x_return_status		OUT NOCOPY VARCHAR2
	, x_msg_count			OUT NOCOPY NUMBER
	, x_msg_data	    		OUT NOCOPY VARCHAR2
    	, p_inventory_item_id     	IN NUMBER
	, P_SOURCE_TMPL_ID		IN	NUMBER
    	, p_template_name       IN  VARCHAR2
    	, p_organization_id             IN NUMBER
    	, p_description         	IN  VARCHAR2
    	, p_serial_generation   	IN  NUMBER
    	, p_prefix_text         	IN  VARCHAR2
    	, p_prefix_number       	IN  VARCHAR2
)

IS

	l_update_item_ver		NUMBER := 1.0;

Line: 289

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

Line: 319

		'==================== Entered EAM_ITEM_PVT.Update_item ===================='||
		'Comms_NL_Trackable_Flag: '||l_asset_group.comms_nl_trackable_flag||
		' Inventory_Item_Flag: '||l_asset_group.Inventory_item_flag);

Line: 324

		'Calling INV_ITEM_GRP.Update_Item...');

Line: 330

    	select master_organization_id into l_master_org_id
    	from mtl_parameters
    	where organization_id = p_organization_id;

Line: 336

    	INV_ITEM_GRP.Update_Item
    	(
        	p_Item_rec      =>  l_asset_group,
		p_Template_Id   =>  p_source_tmpl_id,
		p_Template_Name =>  p_template_name,
        	x_Item_rec      =>  l_x_curr_item_rec,
        	x_return_status =>  l_x_return_status,
        	x_Error_tbl     =>  l_x_curr_item_error_tbl
    	);

Line: 365

    	INV_ITEM_GRP.Update_Item
    	(
        	p_Item_rec      =>  l_asset_group,
        	x_Item_rec      =>  l_x_curr_item_rec,
        	x_return_status =>  l_x_return_status,
        	x_Error_tbl     =>  l_x_curr_item_error_tbl
    	);

Line: 375

		'Returned from INV_ITEM_GRP.Update_Item...'||
		'Comms_NL_Trackable_Flag: '||l_x_curr_item_rec.comms_nl_trackable_flag||
		' Inventory_Item_Flag: '||l_x_curr_item_rec.Inventory_item_flag);

Line: 403

		'==================== Exiting EAM_ITEM_PVT.Update_item ====================');

Line: 405

END UPDATE_ITEM;