DBA Data[Home] [Help]

APPS.IGW_PROP_PERSON_QUESTIONS_PVT SQL Statements

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

Line: 31

Procedure update_prop_person_question (
  p_init_msg_list                IN 	VARCHAR2   := FND_API.G_FALSE
 ,p_commit                       IN 	VARCHAR2   := FND_API.G_FALSE
 ,p_validate_only                IN 	VARCHAR2   := FND_API.G_FALSE
 ,x_rowid 		         IN 	VARCHAR2
 ,p_proposal_id			 IN 	NUMBER
 ,p_proposal_number		 IN	VARCHAR2
 ,p_person_id               	 IN 	NUMBER
 ,p_party_id               	 IN 	NUMBER
 ,p_person_name			 IN	VARCHAR2
 ,p_question_number     	 IN	VARCHAR2
 ,p_answer       	 	 IN	VARCHAR2
 ,p_explanation		 	 IN     VARCHAR2
 ,p_review_date   		 IN	DATE
 ,p_record_version_number        IN 	NUMBER
 ,x_return_status                OUT NOCOPY 	VARCHAR2
 ,x_msg_count                    OUT NOCOPY 	NUMBER
 ,x_msg_data                     OUT NOCOPY 	VARCHAR2)  is

BEGIN
null;
Line: 53

END  update_prop_person_question;
Line: 56

Procedure delete_prop_person_question (
  p_init_msg_list                IN   		VARCHAR2   := FND_API.G_FALSE
 ,p_commit                       IN   		VARCHAR2   := FND_API.G_FALSE
 ,p_validate_only                IN   		VARCHAR2   := FND_API.G_FALSE
 ,x_rowid 			 IN 		VARCHAR2
 ,p_record_version_number        IN   		NUMBER
 ,x_return_status                OUT NOCOPY  		VARCHAR2
 ,x_msg_count                    OUT NOCOPY  		NUMBER
 ,x_msg_data                     OUT NOCOPY  		VARCHAR2)  is

BEGIN
null;
Line: 70

END delete_prop_person_question;