APPS.CS_COST_DETAILS_PUB SQL Statements

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

Line: 239

Public Procedure Body Update_Cost_Details
**************************************************/


PROCEDURE Update_Cost_Details
	(
	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_object_version_number OUT NOCOPY NUMBER,
	x_msg_data OUT NOCOPY VARCHAR2,
	p_resp_appl_id IN NUMBER          := FND_GLOBAL.RESP_APPL_ID,
	p_resp_id IN NUMBER               := FND_GLOBAL.RESP_ID,
	p_user_id IN NUMBER               := FND_GLOBAL.USER_ID,
	p_login_id IN NUMBER              := NULL,
	p_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
	p_Cost_Rec IN Cost_Rec_Type       :=G_MISS_COST_REC

	) IS

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

Line: 282

	SAVEPOINT update_cost_details_pub ;

Line: 364

	CS_COST_DETAILS_PVT.UPDATE_COST_DETAILS
	(
	p_api_version          =>1.0,
	p_init_msg_list        => p_init_msg_list,
	p_commit               => p_commit ,
	p_validation_level     => FND_API.G_VALID_LEVEL_FULL,
	x_return_status        => l_return_status,
	x_msg_count            => x_msg_count,
	x_object_version_number=> x_object_version_number,
	x_msg_data             => x_msg_data,
	p_resp_appl_id         => l_resp_appl_id,
	p_resp_id              => l_resp_id,
	p_user_id              => l_user_id,
	p_login_id             => l_login_id,
	p_transaction_control  => p_transaction_control,
	p_Cost_Rec             => p_cost_rec
	);

Line: 413

	'After calling the update_cost_details'||l_return_status
	);

Line: 423

	ROLLBACK TO update_cost_details_pub;

Line: 435

	ROLLBACK TO update_cost_details_pub;

Line: 446

	ROLLBACK TO update_cost_details_pub;

Line: 460

END Update_Cost_Details;

Line: 464

Public Procedure Body Delete_Cost_Details
**************************************************/
PROCEDURE Delete_Cost_details
	(
	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_transaction_control IN VARCHAR2 := FND_API.G_TRUE,
	p_cost_id IN NUMBER               := NULL
	) IS

	l_api_name CONSTANT VARCHAR2(30)      :='Delete_Cost_Details Public API' ;

Line: 495

	SAVEPOINT Delete_Cost_Details_PUB ;

Line: 556

	CS_COST_DETAILS_PVT.DELETE_COST_DETAILS
	(
	p_api_version         =>1.0,
	p_init_msg_list       => p_init_msg_list,
	p_commit              => p_commit,
	p_validation_level    => FND_API.G_VALID_LEVEL_FULL,
	x_return_status       => l_return_status,
	x_msg_count           => x_msg_count,
	x_msg_data            => x_msg_data,
	p_transaction_control => p_transaction_control,
	p_cost_id             => p_cost_id
	);

Line: 598

	'After calling the Delete_cost_details'||l_return_status
	);

Line: 611

	ROLLBACK TO Delete_Cost_Details_PUB;

Line: 623

	ROLLBACK TO Delete_Cost_Details_PUB;

Line: 634

	ROLLBACK TO Delete_Cost_Details_PUB;

Line: 649

END Delete_Cost_details;