APPS.HZ_GEO_STRUCT_MAP_DTL_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_loc_seq_num                           IN            NUMBER,
    x_loc_component                         IN            VARCHAR2,
    x_geography_type                        IN            VARCHAR2,
    x_geo_element_col                       IN            VARCHAR2
) IS


BEGIN

      INSERT INTO HZ_GEO_STRUCT_MAP_DTL (
        map_id,
        loc_seq_num,
        loc_component,
        geography_type,
        geo_element_col,
        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_loc_seq_num,
               FND_API.G_MISS_NUM, NULL,
               x_loc_seq_num),
        DECODE(x_loc_component,
               FND_API.G_MISS_CHAR, NULL,
               x_loc_component),
        DECODE(x_geography_type,
               FND_API.G_MISS_CHAR, NULL,
               x_geography_type),
        DECODE(x_geo_element_col,
               FND_API.G_MISS_CHAR, NULL,
               x_geo_element_col),
        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: 54

END Insert_Row;

Line: 56

PROCEDURE Update_Row (
    x_rowid                                 IN OUT NOCOPY VARCHAR2,
    x_map_id                                IN     NUMBER,
    x_loc_seq_num                           IN     NUMBER,
    x_loc_component                         IN     VARCHAR2,
    x_geography_type                        IN     VARCHAR2,
    x_geo_element_col                       IN     VARCHAR2
) IS
BEGIN

    UPDATE HZ_GEO_STRUCT_MAP_DTL
    SET
      map_id =
        DECODE(x_map_id,
               NULL, map_id,
               FND_API.G_MISS_NUM, NULL,
               x_map_id),
      loc_seq_num =
        DECODE(x_loc_seq_num,
               NULL, loc_seq_num,
               FND_API.G_MISS_NUM, NULL,
               x_loc_seq_num),
      loc_component =
        DECODE(x_loc_component,
               NULL, loc_component,
               FND_API.G_MISS_CHAR, NULL,
               x_loc_component),
      geography_type =
        DECODE(x_geography_type,
               NULL, geography_type,
               FND_API.G_MISS_CHAR, NULL,
               x_geography_type),
      geo_element_col =
        DECODE(x_geo_element_col,
               NULL, geo_element_col,
               FND_API.G_MISS_CHAR, NULL,
               x_geo_element_col),
      last_updated_by = hz_utility_v2pub.last_updated_by,
      creation_date = creation_date,
      created_by = created_by,
      last_update_date = hz_utility_v2pub.last_update_date,
      last_update_login = hz_utility_v2pub.last_update_login
    WHERE rowid = x_rowid;

Line: 103

END Update_Row;

Line: 115

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

Line: 126

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

Line: 155

PROCEDURE Select_Row (
    x_map_id                                IN OUT NOCOPY NUMBER,
    x_loc_seq_num                           OUT    NOCOPY NUMBER,
    x_loc_component                         OUT    NOCOPY VARCHAR2,
    x_geography_type                        OUT    NOCOPY VARCHAR2,
    x_geo_element_col                       OUT    NOCOPY VARCHAR2
) IS
BEGIN

    SELECT
      NVL(map_id, FND_API.G_MISS_NUM),
      NVL(loc_seq_num, FND_API.G_MISS_NUM),
      NVL(loc_component, FND_API.G_MISS_CHAR),
      NVL(geography_type, FND_API.G_MISS_CHAR)
    INTO
      x_map_id,
      x_loc_seq_num,
      x_loc_component,
      x_geography_type
    FROM HZ_GEO_STRUCT_MAP_DTL
    WHERE map_id =  x_map_id;

Line: 185

END Select_Row;

Line: 187

PROCEDURE Delete_Row (
    x_map_id                        IN     NUMBER
) IS
BEGIN

  DELETE FROM hz_geo_struct_map_dtl
  WHERE map_id = x_map_id;

Line: 199

END Delete_Row;

Line: 202

PROCEDURE Delete_Row (
    x_map_id                        IN     NUMBER,
    x_geography_type                IN     VARCHAR2
) IS
BEGIN

  DELETE FROM hz_geo_struct_map_dtl
  WHERE map_id = x_map_id
  AND   geography_type = x_geography_type;

Line: 216

END Delete_Row;