APPS.HZ_TIMEZONE_MAPPING_PKG SQL Statements

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

Line: 5

PROCEDURE Insert_Row(
                  x_Rowid                         VARCHAR2,
                  x_MAPPING_ID                    NUMBER,
                  x_AREA_CODE                     VARCHAR2,
                  x_POSTAL_CODE                   VARCHAR2,
                  x_CITY                          VARCHAR2,
                  x_STATE                         VARCHAR2,
                  x_PROVINCE                      VARCHAR2,
                  x_COUNTRY                       VARCHAR2,
                  x_TIMEZONE_ID                   NUMBER,
                  x_CREATION_DATE                 DATE,
                  x_CREATED_BY                    NUMBER,
                  x_LAST_UPDATE_DATE              DATE,
                  x_LAST_UPDATED_BY               NUMBER,
                  x_LAST_UPDATE_LOGIN             NUMBER
 ) IS
   CURSOR C IS SELECT rowid FROM HZ_TIMEZONE_MAPPING
            WHERE MAPPING_ID = x_MAPPING_ID;

Line: 23

   CURSOR C2 IS SELECT HZ_TIMEZONE_MAP_s.nextval FROM sys.dual;

Line: 32

   INSERT INTO HZ_TIMEZONE_MAPPING(
           MAPPING_ID,
           AREA_CODE,
           POSTAL_CODE,
           CITY,
           STATE,
           PROVINCE,
           COUNTRY,
           TIMEZONE_ID,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_LOGIN
          ) VALUES (
          v_MAPPING_ID,
           decode( x_AREA_CODE, FND_API.G_MISS_CHAR, NULL,x_AREA_CODE),
           decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR, NULL,x_POSTAL_CODE),
           decode( x_CITY, FND_API.G_MISS_CHAR, NULL,x_CITY),
           decode( x_STATE, FND_API.G_MISS_CHAR, NULL,x_STATE),
           decode( x_PROVINCE, FND_API.G_MISS_CHAR, NULL,x_PROVINCE),
           decode( x_COUNTRY, FND_API.G_MISS_CHAR, NULL,x_COUNTRY),
           decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,x_TIMEZONE_ID),
           decode( x_CREATION_DATE, FND_API.G_MISS_DATE, NULL,x_CREATION_DATE),
           decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
           decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,x_LAST_UPDATE_DATE),
           decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
           decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN));

Line: 66

End Insert_Row;

Line: 70

PROCEDURE Delete_Row(                  x_MAPPING_ID                    NUMBER
 ) IS
 BEGIN
   DELETE FROM HZ_TIMEZONE_MAPPING
    WHERE MAPPING_ID = x_MAPPING_ID;

Line: 78

 END Delete_Row;

Line: 82

PROCEDURE Update_Row(
                  x_Rowid                         VARCHAR2,
                  x_MAPPING_ID                    NUMBER,
                  x_AREA_CODE                     VARCHAR2,
                  x_POSTAL_CODE                   VARCHAR2,
                  x_CITY                          VARCHAR2,
                  x_STATE                         VARCHAR2,
                  x_PROVINCE                      VARCHAR2,
                  x_COUNTRY                       VARCHAR2,
                  x_TIMEZONE_ID                   NUMBER,
                  x_CREATION_DATE                 DATE,
                  x_CREATED_BY                    NUMBER,
                  x_LAST_UPDATE_DATE              DATE,
                  x_LAST_UPDATED_BY               NUMBER,
                  x_LAST_UPDATE_LOGIN             NUMBER
 ) IS
 BEGIN
    Update HZ_TIMEZONE_MAPPING
    SET
             MAPPING_ID = decode( x_MAPPING_ID, FND_API.G_MISS_NUM,MAPPING_ID,x_MAPPING_ID),
             AREA_CODE = decode( x_AREA_CODE, FND_API.G_MISS_CHAR,AREA_CODE,x_AREA_CODE),
             POSTAL_CODE = decode( x_POSTAL_CODE, FND_API.G_MISS_CHAR,POSTAL_CODE,x_POSTAL_CODE),
             CITY = decode( x_CITY, FND_API.G_MISS_CHAR,CITY,x_CITY),
             STATE = decode( x_STATE, FND_API.G_MISS_CHAR,STATE,x_STATE),
             PROVINCE = decode( x_PROVINCE, FND_API.G_MISS_CHAR,PROVINCE,x_PROVINCE),
             COUNTRY = decode( x_COUNTRY, FND_API.G_MISS_CHAR,COUNTRY,x_COUNTRY),
             TIMEZONE_ID = decode( x_TIMEZONE_ID, FND_API.G_MISS_NUM,TIMEZONE_ID,x_TIMEZONE_ID),
             -- Bug 3032780
             /*
             CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
             CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
             */
             LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
             LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
             LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN)
    where rowid = X_RowId;

Line: 122

 END Update_Row;

Line: 138

                  x_LAST_UPDATE_DATE              DATE,
                  x_LAST_UPDATED_BY               NUMBER,
                  x_LAST_UPDATE_LOGIN             NUMBER
 ) IS
   CURSOR C IS
        SELECT *
          FROM HZ_TIMEZONE_MAPPING
         WHERE rowid = x_Rowid
         FOR UPDATE of MAPPING_ID NOWAIT;

Line: 153

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

Line: 188

       AND (    ( Recinfo.LAST_UPDATE_DATE = x_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE = NULL )
                AND (  x_LAST_UPDATE_DATE = NULL )))
       AND (    ( Recinfo.LAST_UPDATED_BY = x_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY = NULL )
                AND (  x_LAST_UPDATED_BY = NULL )))
       AND (    ( Recinfo.LAST_UPDATE_LOGIN = x_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN = NULL )
                AND (  x_LAST_UPDATE_LOGIN = NULL )))
       ) then
       return;

Line: 200

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