DBA Data[Home] [Help]

APPS.IGS_AD_LOCATION_ADDR_PKG SQL Statements

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

Line: 4

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,
    l_return_status  OUT NOCOPY VARCHAR2,
    x_object_version_number IN OUT NOCOPY NUMBER,
    X_MODE IN VARCHAR2 DEFAULT 'R'
  ) AS

	p_location_rec_insert    HZ_LOCATION_V2PUB.location_rec_type;
Line: 70

    p_location_rec_insert.country := x_country;
Line: 71

    p_location_rec_insert.address_style := x_address_style;
Line: 72

    p_location_rec_insert.address1 := x_addr_line_1;
Line: 73

    p_location_rec_insert.address2 := x_addr_line_2;
Line: 74

    p_location_rec_insert.address3 := x_addr_line_3;
Line: 75

    p_location_rec_insert.address4 := x_addr_line_4;
Line: 76

    p_location_rec_insert.city := x_city;
Line: 77

    p_location_rec_insert.state := x_state;
Line: 78

    p_location_rec_insert.province := x_province;
Line: 79

    p_location_rec_insert.county := x_county;
Line: 80

    p_location_rec_insert.postal_code := x_postal_code;
Line: 82

    p_location_rec_insert.delivery_point_code := x_delivery_point_code;
Line: 84

    p_location_rec_insert.address_lines_phonetic := x_address_lines_phonetic;
Line: 85

    p_location_rec_insert.address_effective_date := x_start_dt;
Line: 86

    p_location_rec_insert.address_expiration_date := x_end_dt;
Line: 87

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

    p_location_rec_insert.application_id            := 8405;
Line: 92

                 P_LOCATION_REC                         => p_location_rec_insert,
		 P_DO_ADDR_VAL				=> 'Y',
		 X_LOCATION_ID                          => l_location_id,
		 x_addr_val_status			=> l_addr_val_status,
		 x_addr_warn_msg			=> l_addr_warn_msg,
                 X_RETURN_STATUS                        => l_return_status,
                 X_MSG_COUNT                            => l_msg_count,
                 X_MSG_DATA                             => l_msg_data
                );
Line: 119

          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: 129

          IGS_AD_LOCVENUE_ADDR_PKG.INSERT_ROW(
            x_rowid => lv_rowid_locvenue,
            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: 148

END INSERT_ROW;
Line: 150

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,
    l_return_status  OUT NOCOPY VARCHAR2 ,
	x_object_version_number IN OUT NOCOPY NUMBER,
    X_MODE IN VARCHAR2 DEFAULT 'R'
  ) AS

    p_location_rec_update   HZ_LOCATION_V2PUB.location_rec_type;
Line: 197

SELECT ROWID
FROM igs_pe_hz_locations
WHERE location_id = x_location_id;
Line: 219

    p_location_rec_update.location_id := x_location_id;
Line: 220

    p_location_rec_update.country := x_country;
Line: 221

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

    p_location_rec_update.address1 := NVL(x_addr_line_1,FND_API.G_MISS_CHAR);
Line: 223

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

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

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

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

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

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

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

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

    p_location_rec_update.delivery_point_code := NVL(x_delivery_point_code,FND_API.G_MISS_CHAR);
Line: 234

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

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

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

    HZ_LOCATION_V2PUB.update_location(
         P_INIT_MSG_LIST                        => FND_API.G_TRUE,
         P_LOCATION_REC                         => p_location_rec_update,
	 p_do_addr_val				=> 'Y',
         p_object_version_number                => x_object_version_number,
	 x_addr_val_status			=> l_addr_val_status,
	 x_addr_warn_msg			=> l_addr_warn_msg,
	 X_RETURN_STATUS                        => l_return_status,
         X_MSG_COUNT                            => l_msg_count,
         X_MSG_DATA                             => l_msg_data
        );
Line: 269

          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: 279

          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: 293

END UPDATE_ROW;