APPS.IGS_PE_CONTACT_POINT_PKG SQL Statements

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

Line: 15

                 p_last_update_date     IN OUT NOCOPY DATE ,
                 p_contact_point_id     IN OUT NOCOPY NUMBER,
                 p_contact_point_ovn    IN OUT NOCOPY NUMBER,
                 p_attribute_category   IN VARCHAR2,
                 p_attribute1           IN VARCHAR2,
   		 p_attribute2           IN VARCHAR2,
   		 p_attribute3           IN VARCHAR2,
  		 p_attribute4           IN VARCHAR2,
   		 p_attribute5           IN VARCHAR2,
   		 p_attribute6           IN VARCHAR2,
   		 p_attribute7           IN VARCHAR2,
   		 p_attribute8           IN VARCHAR2,
   		 p_attribute9           IN VARCHAR2,
  		 p_attribute10 	    IN VARCHAR2,
   		 p_attribute11 	    IN VARCHAR2,
   		 p_attribute12 	    IN VARCHAR2,
   		 p_attribute13 	    IN VARCHAR2,
   		 p_attribute14 	    IN VARCHAR2,
   		 p_attribute15 	    IN VARCHAR2,
   		 p_attribute16 	    IN VARCHAR2,
   		 p_attribute17          IN VARCHAR2,
   		 p_attribute18 	    IN VARCHAR2,
   		 p_attribute19 	    IN VARCHAR2,
   		 p_attribute20 	    IN VARCHAR2

) AS
  /*************************************************************
  Created By : kumaravel
  Date Created By : Sep 15 2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

 		p_api_version 		      NUMBER(15)   := 1.0;

Line: 58

		l_last_update_date        hz_contact_points.last_update_date%TYPE;

Line: 65

            SELECT  last_update_date
            FROM    hz_contact_points
            WHERE   contact_point_id = p_contact_point_id;

Line: 71

     IF p_action = 'INSERT' THEN
                           l_CONTACT_POINT_REC.CONTACT_POINT_ID	        := p_contact_point_id;

Line: 129

 ELSIF p_action = 'UPDATE' THEN


                  l_CONTACT_POINT_REC.CONTACT_POINT_ID	     :=  p_contact_point_id;

Line: 165

          HZ_CONTACT_POINT_V2PUB.update_contact_point(
                              p_init_msg_list         => p_init_msg_list ,
                              p_contact_point_rec     => l_contact_point_rec ,
                              p_email_rec             => l_EMAIL_REC ,
                              p_object_version_number => p_contact_point_ovn,
                              x_return_status         => p_return_status,
                              x_msg_count             => l_msg_count ,
                              x_msg_data              => p_msg_data

                                                     );

Line: 208

 		 p_last_update_date	IN OUT NOCOPY DATE,
        	 p_contact_point_id     IN OUT NOCOPY NUMBER,
                 p_contact_point_ovn    IN OUT NOCOPY NUMBER,
        	 p_attribute_category   IN VARCHAR2,
        	 p_attribute1       	IN VARCHAR2,
   		 p_attribute2       	IN VARCHAR2,
   		 p_attribute3       	IN VARCHAR2,
  		 p_attribute4       	IN VARCHAR2,
   		 p_attribute5       	IN VARCHAR2,
   		 p_attribute6       	IN VARCHAR2,
   		 p_attribute7       	IN VARCHAR2,
   		 p_attribute8       	IN VARCHAR2,
   		 p_attribute9       	IN VARCHAR2,
   		 p_attribute10 		IN VARCHAR2,
   		 p_attribute11 		IN VARCHAR2,
   		 p_attribute12 		IN VARCHAR2,
   		 p_attribute13 		IN VARCHAR2,
   		 p_attribute14 		IN VARCHAR2,
   		 p_attribute15 		IN VARCHAR2,
   		 p_attribute16 		IN VARCHAR2,
   		 p_attribute17 		IN VARCHAR2,
   		 p_attribute18 		IN VARCHAR2,
   		 p_attribute19 		IN VARCHAR2,
   		 p_attribute20 		IN VARCHAR2
) AS
  /*************************************************************
  Created By : Kumaravel
  Date Created By : Sep 15 2000
  Purpose :
  Know limitations, enhancements or remarks
  Change History
  Who             When            What

  (reverse chronological order - newest change first)
  ***************************************************************/

 		p_api_version 		NUMBER(15)   := 1.0;

Line: 248

		l_last_update_date  hz_contact_points.last_update_date%TYPE;

Line: 255

        SELECT  last_update_date
        FROM    hz_contact_points
        WHERE   contact_point_id = p_contact_point_id;

Line: 265

IF p_action = 'INSERT' THEN
                        l_CONTACT_POINT_REC.CONTACT_POINT_ID	:=  p_contact_point_id;

Line: 328

 ELSIF p_action = 'UPDATE' THEN


                  l_CONTACT_POINT_REC.CONTACT_POINT_ID	      :=  p_contact_point_id;

Line: 368

                 HZ_CONTACT_POINT_V2PUB.update_contact_point(
		                     p_init_msg_list         => p_init_msg_list ,
                                     p_contact_point_rec     => l_contact_point_rec ,
                                     p_phone_rec	     =>  l_PHONE_REC,
                                     p_object_version_number => p_contact_point_ovn,
                                     x_return_status         => p_return_status,
                                     x_msg_count             => l_msg_count ,
                                     x_msg_data              => p_msg_data

                                                            );