APPS.HZ_GEO_STRUCT_MAP_PVT 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_map_id                                IN            NUMBER,
    x_country_code                          IN            VARCHAR2,
    x_loc_tbl_name                          IN            VARCHAR2,
    x_address_style                         IN            VARCHAR2
) IS


BEGIN

      INSERT INTO HZ_GEO_STRUCT_MAP (
        map_id,
        country_code,
        loc_tbl_name,
        address_style,
        last_updated_by,
        creation_date,
        created_by,
        last_update_date,
        last_update_login
      )
      VALUES (
        DECODE(x_map_id,
               FND_API.G_MISS_NUM, NULL,
               x_map_id),
        DECODE(x_country_code,
               FND_API.G_MISS_CHAR, NULL,
               x_country_code),
        DECODE(x_loc_tbl_name,
               FND_API.G_MISS_CHAR, NULL,
               x_loc_tbl_name),
        DECODE(x_address_style,
               FND_API.G_MISS_CHAR, NULL,
               x_address_style),
        hz_utility_v2pub.last_updated_by,
        hz_utility_v2pub.creation_date,
        hz_utility_v2pub.created_by,
        hz_utility_v2pub.last_update_date,
        hz_utility_v2pub.last_update_login
      ) RETURNING
        rowid
      INTO
        x_rowid;

Line: 49

END Insert_Row;

Line: 60

      SELECT * FROM hz_geo_struct_map
      WHERE rowid = x_rowid
      FOR UPDATE NOWAIT;

Line: 71

      FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 100

PROCEDURE Select_Row (
    x_map_id                                IN OUT NOCOPY NUMBER,
    x_country_code                          OUT    NOCOPY VARCHAR2,
    x_loc_tbl_name                          OUT    NOCOPY VARCHAR2,
    x_address_style                         OUT    NOCOPY VARCHAR2
) IS
BEGIN

    SELECT
      NVL(map_id, FND_API.G_MISS_NUM),
      NVL(country_code, FND_API.G_MISS_CHAR),
      NVL(loc_tbl_name, FND_API.G_MISS_CHAR),
      NVL(address_style, FND_API.G_MISS_CHAR)
    INTO
      x_map_id,
      x_country_code,
      x_loc_tbl_name,
      x_address_style
    FROM HZ_GEO_STRUCT_MAP
    WHERE map_id =  x_map_id;

Line: 129

END Select_Row;

Line: 131

PROCEDURE Delete_Row (
    x_map_id                        IN     NUMBER
) IS
BEGIN

  DELETE FROM hz_geo_struct_map
  WHERE map_id = x_map_id;

Line: 143

END Delete_Row;