APPS.OKC_TASK_PUB SQL Statements

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

Line: 275

  PROCEDURE update_task(p_api_version 			IN NUMBER
			     ,p_init_msg_list 		IN VARCHAR2
			     ,p_commit			IN VARCHAR2
			     ,p_object_version_number   IN OUT NOCOPY NUMBER
			     ,p_task_id			IN NUMBER
			     ,p_task_number		IN NUMBER
			     ,p_workflow_process_id	IN NUMBER
			     ,p_actual_end_date       	IN DATE
			     ,p_alarm_fired_count       IN NUMBER
			     ,x_return_status   	OUT NOCOPY VARCHAR2
    			     ,x_msg_count       	OUT NOCOPY NUMBER
    			     ,x_msg_data        	OUT NOCOPY VARCHAR2) IS
	 l_api_name	 CONSTANT VARCHAR2(30) := 'update_task';

Line: 305

	--Call to private api to update a task
	okc_task_pvt.update_task(p_api_version 		=> p_api_version
			     ,p_init_msg_list 		=> p_init_msg_list
			     ,p_object_version_number   => p_object_version_number
			     ,p_task_id			=> p_task_id
			     ,p_task_number		=> p_task_number
			     ,p_workflow_process_id	=> p_workflow_process_id
			     ,p_actual_end_date       	=> p_actual_end_date
			     ,p_alarm_fired_count       => p_alarm_fired_count
			     ,x_return_status   	=> x_return_status
    			     ,x_msg_count       	=> x_msg_count
    			     ,x_msg_data        	=> x_msg_data);

Line: 362

  END update_task;

Line: 365

  PROCEDURE delete_task(p_api_version 			IN NUMBER
		       ,p_init_msg_list 		IN VARCHAR2
		       ,p_commit			IN VARCHAR2
		       ,p_tve_id			IN NUMBER
		       ,p_rtv_id			IN NUMBER
		       ,x_return_status   		OUT NOCOPY VARCHAR2
    		       ,x_msg_count       		OUT NOCOPY NUMBER
    		       ,x_msg_data        		OUT NOCOPY VARCHAR2) IS
	 l_api_name	 CONSTANT VARCHAR2(30) := 'delete_rule_task';

Line: 391

	--Call to private api to delete task/s
	okc_task_pvt.delete_task(p_api_version 		=> p_api_version
			     ,p_init_msg_list 		=> p_init_msg_list
			     ,p_tve_id			=> p_tve_id
			     ,p_rtv_id			=> p_rtv_id
			     ,x_return_status   	=> x_return_status
    			     ,x_msg_count       	=> x_msg_count
    			     ,x_msg_data        	=> x_msg_data);

Line: 443

  END delete_task;