APPS.IGS_PE_PARTY_SITE_USE_PKG SQL Statements

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

Line: 13

                p_last_update_date	    IN OUT NOCOPY DATE,
 	        p_site_use_last_update_date IN OUT NOCOPY DATE,
 		P_profile_last_update_date  IN OUT NOCOPY DATE,
		p_hz_party_site_use_ovn      IN OUT NOCOPY   NUMBER
) 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: 47

     IF p_action = 'INSERT' THEN
--	 l_PARTY_SITE_USE_REC.BEGIN_DATE	       := SYSDATE;

Line: 84

   ELSIF p_action = 'UPDATE' THEN

                l_PARTY_SITE_USE_REC.PARTY_SITE_USE_ID	 :=  p_party_site_use_id;

Line: 93

      HZ_PARTY_SITE_V2PUB.update_party_site_use (
                   p_init_msg_list         =>  p_init_msg_list  ,
                   p_party_site_use_rec    =>  l_PARTY_SITE_USE_REC,
                   p_object_version_number =>  p_hz_party_site_use_ovn,
                   x_return_status         =>  p_return_status,
                   x_msg_count             =>  l_msg_count,
                   x_msg_data              =>  p_msg_data  );