APPS.HZ_PHONE_FORMATS_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_PHONE_FORMAT_STYLE                   VARCHAR2,
                    p_COUNTRY_CODE_DISPLAY_FLAG            VARCHAR2,
                    p_AREA_CODE_SIZE                       NUMBER,
                    p_FORMAT_NAME                          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_PHONE_FORMATS
            WHERE TERRITORY_CODE     = p_TERRITORY_CODE
            AND   PHONE_FORMAT_STYLE =  p_PHONE_FORMAT_STYLE;

Line: 24

   insert into HZ_PHONE_FORMATS(
   TERRITORY_CODE,
   PHONE_FORMAT_STYLE,
   COUNTRY_CODE_DISPLAY_FLAG,
   AREA_CODE_SIZE,
   FORMAT_NAME,
   DESCRIPTION ,
   CREATED_BY,
   CREATION_DATE,
   LAST_UPDATE_LOGIN,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   OBJECT_VERSION_NUMBER ) VALUES(
   p_TERRITORY_CODE,
   decode(p_PHONE_FORMAT_STYLE,    FND_API.G_MISS_CHAR, NULL, p_PHONE_FORMAT_STYLE),
   decode(p_COUNTRY_CODE_DISPLAY_FLAG,    FND_API.G_MISS_CHAR, NULL,
          p_COUNTRY_CODE_DISPLAY_FLAG),
   decode(p_AREA_CODE_SIZE,    FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),
   decode(p_FORMAT_NAME,    FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),
   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: 61

PROCEDURE Update_Row(
                    p_rowid                                VARCHAR2,
                    p_TERRITORY_CODE                       VARCHAR2,
                    p_PHONE_FORMAT_STYLE                   VARCHAR2,
                    p_COUNTRY_CODE_DISPLAY_FLAG            VARCHAR2,
                    p_AREA_CODE_SIZE                       NUMBER,
                    p_FORMAT_NAME                          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: 80

 UPDATE HZ_PHONE_FORMATS
  SET
  TERRITORY_CODE = decode(p_TERRITORY_CODE,  FND_API.G_MISS_CHAR,
                             TERRITORY_CODE, p_TERRITORY_CODE),
  PHONE_FORMAT_STYLE = decode(p_PHONE_FORMAT_STYLE,  FND_API.G_MISS_CHAR,
                             PHONE_FORMAT_STYLE, p_PHONE_FORMAT_STYLE),
  COUNTRY_CODE_DISPLAY_FLAG = decode(p_COUNTRY_CODE_DISPLAY_FLAG,
                               FND_API.G_MISS_CHAR, COUNTRY_CODE_DISPLAY_FLAG,                                p_COUNTRY_CODE_DISPLAY_FLAG),
  AREA_CODE_SIZE = decode(p_AREA_CODE_SIZE,    FND_API.G_MISS_NUM,
                            AREA_CODE_SIZE,     p_AREA_CODE_SIZE),
  FORMAT_NAME    = decode(p_FORMAT_NAME,    FND_API.G_MISS_CHAR,
                             FORMAT_NAME, p_FORMAT_NAME),
  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: 118

 END Update_Row;

Line: 127

 SELECT OBJECT_VERSION_NUMBER
 FROM HZ_PHONE_FORMATS
 WHERE TERRITORY_CODE  = p_TERRITORY_CODE
 AND PHONE_FORMAT_STYLE = p_PHONE_FORMAT_STYLE
 FOR UPDATE OF TERRITORY_CODE , PHONE_FORMAT_STYLE NOWAIT;

Line: 138

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

Line: 151

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

Line: 156

PROCEDURE Delete_Row(p_TERRITORY_CODE VARCHAR2, P_PHONE_FORMAT_STYLE VARCHAR2 ) IS
BEGIN
   DELETE FROM HZ_PHONE_FORMATS
   WHERE TERRITORY_CODE  = p_TERRITORY_CODE
   AND PHONE_FORMAT_STYLE = p_PHONE_FORMAT_STYLE;

Line: 165

 END Delete_Row;