APPS.HZ_MOBILE_PREFIXES_PKG SQL Statements

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

Line: 3

PROCEDURE Insert_Row(
                    p_rowid                IN OUT          NOCOPY VARCHAR2,
                    p_TERRITORY_CODE                       VARCHAR2,
                    p_MOBILE_PREFIX                        VARCHAR2,
                    p_PHONE_COUNTRY_CODE                   VARCHAR2,
                    p_DESCRIPTION                          VARCHAR2,
                    p_CREATED_BY                           NUMBER,
                    p_CREATION_DATE                        DATE,
                    p_LAST_UPDATE_LOGIN                    NUMBER,
                    p_LAST_UPDATE_DATE                     DATE,
                    p_LAST_UPDATED_BY                      NUMBER,
                    p_OBJECT_VERSION_NUMBER                NUMBER) IS

 CURSOR C IS SELECT rowid FROM HZ_MOBILE_PREFIXES
            WHERE TERRITORY_CODE     = p_TERRITORY_CODE
            AND   MOBILE_PREFIX      =  p_MOBILE_PREFIX;

Line: 23

   insert into HZ_MOBILE_PREFIXES(
   TERRITORY_CODE,
   MOBILE_PREFIX,
   PHONE_COUNTRY_CODE,
   DESCRIPTION ,
   CREATED_BY,
   CREATION_DATE,
   LAST_UPDATE_LOGIN,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   OBJECT_VERSION_NUMBER ) VALUES(
   p_TERRITORY_CODE,
   decode(p_MOBILE_PREFIX,    FND_API.G_MISS_CHAR, NULL, p_MOBILE_PREFIX),
   decode(p_PHONE_COUNTRY_CODE,    FND_API.G_MISS_CHAR, NULL,
          p_PHONE_COUNTRY_CODE),
   decode(p_DESCRIPTION,    FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
   decode(p_created_by,       FND_API.G_MISS_NUM,  NULL, p_created_by),
   decode(p_creation_date,    FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
   decode(p_last_update_login,FND_API.G_MISS_NUM,  NULL, p_last_update_login),
   decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
   decode(p_last_updated_by,  FND_API.G_MISS_NUM,  NULL, p_last_updated_by),
   1
     );

Line: 55

PROCEDURE Update_Row(
                    p_rowid                                VARCHAR2,
                    p_TERRITORY_CODE                       VARCHAR2,
                    p_MOBILE_PREFIX                        VARCHAR2,
                    p_PHONE_COUNTRY_CODE                   VARCHAR2,
                    p_DESCRIPTION                          VARCHAR2,
                    p_CREATED_BY                           NUMBER,
                    p_CREATION_DATE                        DATE,
                    p_LAST_UPDATE_LOGIN                    NUMBER,
                    p_LAST_UPDATE_DATE                     DATE,
                    p_LAST_UPDATED_BY                      NUMBER,
                    p_OBJECT_VERSION_NUMBER IN OUT         NOCOPY NUMBER) IS
l_object_version_number number;

Line: 72

 UPDATE HZ_MOBILE_PREFIXES
  SET
  TERRITORY_CODE = decode(p_TERRITORY_CODE,  FND_API.G_MISS_CHAR,
                             TERRITORY_CODE, p_TERRITORY_CODE),
  MOBILE_PREFIX = decode(p_MOBILE_PREFIX,  FND_API.G_MISS_CHAR,
                             MOBILE_PREFIX, p_MOBILE_PREFIX),
   PHONE_COUNTRY_CODE = decode(p_PHONE_COUNTRY_CODE,    FND_API.G_MISS_CHAR,
                                 PHONE_COUNTRY_CODE, p_PHONE_COUNTRY_CODE),
   DESCRIPTION    = decode(p_DESCRIPTION,    FND_API.G_MISS_CHAR,
                             DESCRIPTION, p_DESCRIPTION),
   -- Bug 3032780
   /*
   CREATED_BY     = decode(p_created_by,FND_API.G_MISS_NUM,
                             CREATED_BY, p_created_by),
 CREATION_DATE    = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
                             CREATION_DATE,p_CREATION_DATE),
 */
 LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
                              LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
 LAST_UPDATE_DATE  = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
                              LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
 LAST_UPDATED_BY   = decode(p_LAST_UPDATED_BY,  FND_API.G_MISS_NUM,
                              LAST_UPDATED_BY,p_LAST_UPDATED_BY),
 OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER,  FND_API.G_MISS_NUM,
                                  OBJECT_VERSION_NUMBER,l_object_version_number)
WHERE ROWID   = P_ROWID;

Line: 104

 END Update_Row;

Line: 113

 SELECT OBJECT_VERSION_NUMBER
 FROM HZ_MOBILE_PREFIXES
 WHERE TERRITORY_CODE  = p_TERRITORY_CODE
 AND MOBILE_PREFIX = p_MOBILE_PREFIX
 FOR UPDATE OF TERRITORY_CODE , MOBILE_PREFIX NOWAIT;

Line: 124

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

Line: 137

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

Line: 142

PROCEDURE Delete_Row(p_TERRITORY_CODE VARCHAR2, P_MOBILE_PREFIX VARCHAR2 ) IS
BEGIN
   DELETE FROM HZ_MOBILE_PREFIXES
   WHERE TERRITORY_CODE  = p_TERRITORY_CODE
   AND MOBILE_PREFIX = p_MOBILE_PREFIX;

Line: 151

 END Delete_Row;