APPS.IGW_PROP_PERSON_BIOSKETCH_PVT SQL Statements

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

Line: 5

Procedure update_prop_person_biosketch (
 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_PERSON_BIOSKETCH_ID       	  IN		NUMBER,
 P_SHOW_FLAG 		     	  IN            VARCHAR2,
 P_LINE_SEQUENCE	     	  IN		NUMBER,
 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


  l_return_status            VARCHAR2(1);

Line: 30

        SAVEPOINT update_prop_person_biosketch;

Line: 64

                        igw_prop_person_biosketch_tbh.update_row (
                                    	 x_rowid			 =>	x_rowid
              				,P_PROPOSAL_ID       		 =>	P_PROPOSAL_ID
 					,P_PERSON_BIOSKETCH_ID         	=>	P_PERSON_BIOSKETCH_ID
 					,P_SHOW_FLAG      		 =>	P_SHOW_FLAG
 					,P_LINE_SEQUENCE     		 =>	P_LINE_SEQUENCE
              				,p_mode 			 =>	'R'
              				,p_record_version_number	 =>	p_record_version_number
              				,x_return_status		 =>	x_return_status);

Line: 92

              ROLLBACK TO update_prop_person_biosketch;

Line: 103

              ROLLBACK TO update_prop_person_biosketch;

Line: 109

                            p_procedure_name    =>    'UPDATE_PROP_PERSON_BIOSKETCH',
                            p_error_text        =>     SUBSTRB(SQLERRM,1,240));

Line: 116

END  update_prop_person_biosketch;

Line: 126

   select proposal_id
   into l_proposal_id
   from igw_prop_person_biosketch
   where rowid = x_rowid
   and record_version_number = p_record_version_number;