APPS.MTL_COUNTRY_ASSIGNMENTS_PKG SQL Statements

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

Line: 42

PROCEDURE Insert_Row
( x_rowid                IN OUT NOCOPY VARCHAR2
, p_zone_code            IN     VARCHAR2
, p_territory_code       IN     VARCHAR2
, p_territory_short_name IN     VARCHAR2
, p_start_date           IN     DATE
, p_end_date             IN     DATE
, p_creation_date        IN     DATE
, p_created_by           IN     NUMBER
, p_last_update_date     IN     DATE
, p_last_updated_by      IN     NUMBER
, p_last_update_login    IN     NUMBER
)
IS
  CURSOR c IS
  SELECT
    rowid
  FROM
    mtl_country_assignments
  WHERE zone_code = p_zone_code
    AND territory_code = p_territory_code;

Line: 65

  INSERT INTO mtl_country_assignments
  ( zone_code
  , territory_code
  , start_date
  , end_date
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  )
  VALUES
  ( p_zone_code
  , p_territory_code
  , p_start_date
  , p_end_date
  , p_creation_date
  , p_created_by
  , p_last_update_date
  , p_last_updated_by
  , p_last_update_login
  );

Line: 101

      FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Insert_Row');

Line: 105

END Insert_Row;

Line: 122

    SELECT *
    FROM
      mtl_country_assignments
    WHERE
      rowid = p_rowid
    FOR UPDATE OF zone_code nowait;

Line: 137

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

Line: 172

PROCEDURE Update_Row
( p_rowid             IN VARCHAR2
, p_zone_code         IN VARCHAR2
, p_territory_code    IN VARCHAR2
, p_start_date        IN DATE
, p_end_date          IN DATE
, p_last_update_date  IN DATE
, p_last_updated_by   IN NUMBER
, p_last_update_login IN NUMBER
)
IS
BEGIN
  UPDATE mtl_country_assignments
  SET
    zone_code = p_zone_code
    , territory_code = p_territory_code
    , start_date = p_start_date
    , end_date = p_end_date
    , last_update_date = p_last_update_date
    , last_updated_by = p_last_updated_by
    , last_update_login = p_last_update_login
  WHERE rowid = p_rowid;

Line: 203

      FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Update_Row');

Line: 207

END Update_row;

Line: 215

PROCEDURE Delete_row
( p_rowid IN VARCHAR2
)
IS
BEGIN
  DELETE FROM
    mtl_country_assignments
  WHERE
    rowid = p_rowid;

Line: 233

      FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Delete_Row');

Line: 237

END Delete_row;