APPS.MTL_LE_ECONOMIC_ZONES_PKG SQL Statements

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

Line: 46

PROCEDURE Insert_Row
( p_rowid           IN OUT  VARCHAR2
, p_legal_entity_id         NUMBER
, p_zone_code               VARCHAR2
, p_last_update_date        DATE
, p_last_updated_by         NUMBER
, p_last_update_login       NUMBER
, p_created_by              NUMBER
, p_creation_date           DATE
)
IS
l_count NUMBER;

Line: 59

  SELECT
    rowid
  FROM
    MTL_LE_ECONOMIC_ZONES
  WHERE Legal_Entity_ID = p_legal_entity_id
    AND Zone_Code       = p_zone_code;

Line: 68

  SELECT
    COUNT(*)
  INTO
    l_count
  FROM
    MTL_LE_ECONOMIC_ZONES
  WHERE Legal_Entity_id = p_legal_entity_id
    AND Zone_Code       = p_zone_code;

Line: 78

    INSERT INTO MTL_LE_ECONOMIC_ZONES(
      Legal_Entity_ID
    , Zone_Code
    , Last_Update_Date
    , Last_Updated_By
    , Last_Update_Login
    , Created_By
    , Creation_Date
    )
    VALUES(
      p_legal_entity_id
    , p_zone_code
    , p_last_update_date
    , p_last_updated_by
    , p_last_update_login
    , p_created_by
    , p_creation_date
    );

Line: 106

END Insert_Row;

Line: 125

  SELECT *
    FROM MTL_LE_ECONOMIC_ZONES
   WHERE ROWID = p_rowid
   FOR UPDATE OF Legal_Entity_ID NOWAIT;

Line: 137

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

Line: 166

PROCEDURE Update_Row
( p_rowid           IN  VARCHAR2
, p_legal_entity_id     NUMBER
, p_zone_code           VARCHAR2
, p_last_update_date    DATE
, p_last_updated_by     NUMBER
, p_last_update_login   NUMBER
, p_created_by          NUMBER
, p_creation_date       DATE
)
IS
BEGIN

  UPDATE MTL_LE_ECONOMIC_ZONES
    SET
      Legal_Entity_ID         = p_legal_entity_id
    , zone_code               = p_zone_code
    , last_update_date        = p_last_update_date
    , last_updated_by         = p_last_updated_by
    , last_update_login       = p_last_update_login
    , created_by              = p_created_by
    , creation_date           = p_creation_date
  WHERE ROWID = p_rowid;

Line: 194

END Update_Row;

Line: 206

PROCEDURE Delete_Row
( p_rowid IN  VARCHAR2
)
IS
BEGIN

  DELETE FROM MTL_LE_ECONOMIC_ZONES
  WHERE ROWID = p_rowid;

Line: 219

END Delete_Row;