APPS.PA_PERCENT_COMPLETE_PKG SQL Statements

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

Line: 15

	, x_last_update_date	IN		DATE
	, x_last_updated_by	IN		NUMBER
	, x_creation_date		IN		DATE
	, x_created_by		IN		NUMBER
	, x_last_update_login	IN		NUMBER
	) IS

	CURSOR  l_percent_cmpl_csr
	IS
	SELECT	*
	FROM		pa_percent_completes
	WHERE		rowid = x_rowid
	FOR UPDATE	of  project_id NOWAIT;

Line: 39

		FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 70

PROCEDURE Insert_Row
            (
	 x_project_id		IN 	  	NUMBER
	, x_task_id		IN		NUMBER
	, x_percent_complete	IN		NUMBER
	, x_as_of_date		IN		DATE
	, x_description		IN		VARCHAR2
	, x_last_update_date	IN		DATE
	, x_last_updated_by	IN		NUMBER
	, x_creation_date		IN		DATE
	, x_created_by		IN		NUMBER
	, x_last_update_login	IN		NUMBER
	, x_return_status		OUT		NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
	, x_msg_data		OUT		NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
	) IS

	l_msg_count		NUMBER		:= 0;

Line: 90

PA_STATUS_PUB.Update_Progress
	( p_api_version_number  		=>	G_API_VERSION_NUMBER
	  , p_commit			=>	G_COMMIT
	  , p_msg_count			=>	l_msg_count
	  , p_msg_data			=>	x_msg_data
	  , p_init_msg_list		=>	G_INIT_MSG_LIST
	  , p_return_status			=>   	x_return_status
	  , p_project_id			=> 	x_project_id
	  , p_task_id			=> 	x_task_id
	  , p_as_of_date			=>  	x_as_of_date
	  , p_percent_complete		=>  	x_percent_complete
	  , p_description		=>	x_description
	  );

Line: 104

END Insert_Row;

Line: 107

PROCEDURE Delete_Row (x_rowid IN VARCHAR2)  IS

BEGIN

	DELETE FROM pa_percent_completes
	WHERE		rowid = x_rowid;

Line: 117

END Delete_Row;