DBA Data[Home] [Help]

APPS.IGS_GR_VENUE_ADDR_PKG SQL Statements

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

Line: 3

PROCEDURE INSERT_ROW (
    x_rowid IN OUT NOCOPY VARCHAR2,
    x_location_venue_addr_id IN OUT NOCOPY NUMBER,
    x_location_id IN OUT NOCOPY NUMBER,
    x_location_venue_cd IN VARCHAR2,
    x_start_dt IN DATE,
    x_end_dt IN DATE,
    x_country IN VARCHAR2,
    x_address_style IN VARCHAR2,
    x_addr_line_1 IN VARCHAR2,
    x_addr_line_2 IN VARCHAR2,
    x_addr_line_3 IN VARCHAR2,
    x_addr_line_4 IN VARCHAR2,
    x_date_last_verified IN DATE,
    x_correspondence IN VARCHAR2,
    x_city IN VARCHAR2,
    x_state IN VARCHAR2,
    x_province IN VARCHAR2,
    x_county IN VARCHAR2,
    x_postal_code IN VARCHAR2,
    x_address_lines_phonetic IN VARCHAR2,
    x_delivery_point_code IN VARCHAR2,
    x_other_details_1 IN VARCHAR2,
    x_other_details_2 IN VARCHAR2,
    x_other_details_3 IN VARCHAR2,
    x_source_type IN VARCHAR2,
    x_contact_person IN VARCHAR2 default NULL,
    x_msg_data OUT NOCOPY VARCHAR2,
    X_MODE IN VARCHAR2 DEFAULT 'R'
  ) AS

    p_location_rec_insert HZ_LOCATION_V2PUB.location_rec_type;
Line: 48

    p_location_rec_insert.country := x_country;
Line: 49

    p_location_rec_insert.address_style := x_address_style;
Line: 50

    p_location_rec_insert.address1 := x_addr_line_1;
Line: 51

    p_location_rec_insert.address2 := x_addr_line_2;
Line: 52

    p_location_rec_insert.address3 := x_addr_line_3;
Line: 53

    p_location_rec_insert.address4 := x_addr_line_4;
Line: 54

    p_location_rec_insert.city := x_city;
Line: 55

    p_location_rec_insert.state := x_state;
Line: 56

    p_location_rec_insert.province := x_province;
Line: 57

    p_location_rec_insert.county := x_county;
Line: 58

    p_location_rec_insert.postal_code := x_postal_code;
Line: 59

    p_location_rec_insert.address_lines_phonetic := x_address_lines_phonetic;
Line: 60

    p_location_rec_insert.address_effective_date := x_start_dt;
Line: 61

    p_location_rec_insert.address_expiration_date := x_end_dt;
Line: 62

    p_location_rec_insert.created_by_module := 'IGS';
Line: 63

    p_location_rec_insert.content_source_type := 'USER_ENTERED';
Line: 69

        p_location_rec => p_location_rec_insert,
        x_return_status => l_return_status,
        x_msg_count => l_msg_count,
        x_msg_data=> l_msg_data,
        x_location_id => l_location_id
	); */
Line: 79

                   p_location_rec   => p_location_rec_insert,
                   x_location_id    => l_location_id ,
                   x_return_status  => l_return_status,
                   x_msg_count      => l_msg_count,
                   x_msg_data       => l_msg_data
                   );
Line: 124

          IGS_PE_HZ_LOCATIONS_PKG.INSERT_ROW(
            x_rowid => lv_rowid,
            x_location_id => l_location_id,
            x_other_details_1 => x_other_details_1,
            x_other_details_2 => x_other_details_2,
            x_other_details_3 => x_other_details_3,
            -- x_correspondence => x_correspondence,
            x_date_last_verified => x_date_last_verified,
            x_contact_person => x_contact_person
          );
Line: 134

          IGS_AD_LOCVENUE_ADDR_PKG.INSERT_ROW(
            x_rowid => x_rowid,
            x_location_venue_addr_id => l_location_venue_addr_id,
            x_location_id => l_location_id,
            x_location_venue_cd => x_location_venue_cd,
            x_source_type => x_source_type,
            x_identifying_address_flag =>  NVL(x_correspondence,'N')
          );
Line: 146

END INSERT_ROW;
Line: 148

PROCEDURE UPDATE_ROW (
    x_rowid IN VARCHAR2,
    x_location_venue_addr_id IN NUMBER,
    x_location_id IN NUMBER,
    x_location_venue_cd IN VARCHAR2,
    x_start_dt IN DATE,
    x_end_dt IN DATE,
    x_country IN VARCHAR2,
    x_address_style IN VARCHAR2,
    x_addr_line_1 IN VARCHAR2,
    x_addr_line_2 IN VARCHAR2,
    x_addr_line_3 IN VARCHAR2,
    x_addr_line_4 IN VARCHAR2,
    x_date_last_verified IN DATE,
    x_correspondence IN VARCHAR2,
    x_city IN VARCHAR2,
    x_state IN VARCHAR2,
    x_province IN VARCHAR2,
    x_county IN VARCHAR2,
    x_postal_code IN VARCHAR2,
    x_address_lines_phonetic IN VARCHAR2,
    x_delivery_point_code IN VARCHAR2,
    x_other_details_1 IN VARCHAR2,
    x_other_details_2 IN VARCHAR2,
    x_other_details_3 IN VARCHAR2,
    x_source_type IN VARCHAR2,
    x_contact_person IN VARCHAR2 default NULL,
    x_msg_data OUT NOCOPY VARCHAR2,
    X_MODE IN VARCHAR2 DEFAULT 'R'
  ) AS

    p_location_rec_update Hz_Location_v2Pub.location_rec_type;
Line: 186

    l_last_update_date DATE;
Line: 193

      SELECT OBJECT_VERSION_NUMBER
      FROM hz_locations
      WHERE location_id = x_location_id;
Line: 200

    p_location_rec_update.location_id := x_location_id;
Line: 201

    p_location_rec_update.country := x_country;
Line: 202

    p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
Line: 203

    p_location_rec_update.address1 := x_addr_line_1;
Line: 204

    p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
Line: 205

    p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
Line: 206

    p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
Line: 207

    p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
Line: 208

    p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
Line: 209

    p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
Line: 210

    p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
Line: 211

    p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
Line: 212

    p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
Line: 213

    p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
Line: 214

    p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
Line: 220

       HZ_LOCATION_V2PUB.update_location(
                    p_location_rec     =>   p_location_rec_update,
                    p_object_version_number => loc_rec.object_version_number,
                    x_return_status     => l_return_status,
                    x_msg_count  => l_msg_count,
                    x_msg_data=> l_msg_data
                    );
Line: 240

    	HZ_TAX_ASSIGNMENT_V2PUB.UPDATE_LOC_ASSIGNMENT(
 	        p_location_id   => l_location_id,
		p_lock_flag     =>FND_API.G_FALSE,
		p_created_by_module  => 'IGS',
 	        x_return_status =>l_return_status,
 	        x_msg_count     => l_msg_count,
 	        x_msg_data      => l_msg_data,
 	        x_loc_id        => l_loc_id,
		p_application_id =>8405
 	        --p_lock_flag
		);
Line: 264

		  SELECT ROWID INTO lv_rowid FROM IGS_PE_HZ_LOCATIONS WHERE location_id = x_location_id;
Line: 266

          IGS_PE_HZ_LOCATIONS_PKG.UPDATE_ROW(
            x_rowid => lv_rowid,
            x_location_id => x_location_id,
            x_other_details_1 => x_other_details_1,
            x_other_details_2 => x_other_details_2,
            x_other_details_3 => x_other_details_3,
           --  x_correspondence => x_correspondence,
            x_date_last_verified => x_date_last_verified,
            x_contact_person => x_contact_person
          );
Line: 277

          IGS_AD_LOCVENUE_ADDR_PKG.UPDATE_ROW(
            x_rowid => x_rowid,
            x_location_venue_addr_id => x_location_venue_addr_id,
            x_location_id => x_location_id,
            x_location_venue_cd => x_location_venue_cd,
            x_source_type => x_source_type,
            x_identifying_address_flag => NVL(x_correspondence,'N')
          );
Line: 287

END UPDATE_ROW;