APPS.HZ_BILLING_PREFERENCES_PKG SQL Statements

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

Line: 5

PROCEDURE Insert_Row(
                  x_Rowid           IN OUT NOCOPY        VARCHAR2,
                  x_BILLING_PREFERENCES_ID        NUMBER,
                  x_BILL_LANGUAGE                 VARCHAR2,
                  x_BILL_ROUND_NUMBER             VARCHAR2,
                  x_BILL_TYPE                     VARCHAR2,
                  x_MEDIA_FORMAT                  VARCHAR2,
                  x_SITE_USE_ID                   NUMBER,
                  x_MEDIA_TYPE                    VARCHAR2,
                  x_CUST_ACCOUNT_ID               NUMBER,
                  x_NUMBER_OF_COPIES              NUMBER,
                  x_CURRENCY_CODE                 VARCHAR2,
                  x_CREATED_BY                    NUMBER,
                  x_CREATION_DATE                 DATE,
                  x_LAST_UPDATE_LOGIN             NUMBER,
                  x_LAST_UPDATE_DATE              DATE,
                  x_LAST_UPDATED_BY               NUMBER,
                  x_REQUEST_ID                    NUMBER,
                  x_PROGRAM_APPLICATION_ID        NUMBER,
                  x_PROGRAM_ID                    NUMBER,
                  x_PROGRAM_UPDATE_DATE           DATE,
                  x_WH_UPDATE_DATE                DATE
 ) IS
   CURSOR C IS SELECT rowid FROM HZ_BILLING_PREFERENCES
            WHERE BILLING_PREFERENCES_ID = x_BILLING_PREFERENCES_ID;

Line: 31

   INSERT INTO HZ_BILLING_PREFERENCES(
           BILLING_PREFERENCES_ID,
           BILL_LANGUAGE,
           BILL_ROUND_NUMBER,
           BILL_TYPE,
           MEDIA_FORMAT,
           SITE_USE_ID,
           MEDIA_TYPE,
           CUST_ACCOUNT_ID,
           NUMBER_OF_COPIES,
           CURRENCY_CODE,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
           WH_UPDATE_DATE
          ) VALUES (
          x_BILLING_PREFERENCES_ID,
           decode( x_BILL_LANGUAGE, FND_API.G_MISS_CHAR, NULL,x_BILL_LANGUAGE),
           decode( x_BILL_ROUND_NUMBER, FND_API.G_MISS_CHAR, NULL,x_BILL_ROUND_NUMBER),
           decode( x_BILL_TYPE, FND_API.G_MISS_CHAR, NULL,x_BILL_TYPE),
           decode( x_MEDIA_FORMAT, FND_API.G_MISS_CHAR, NULL,x_MEDIA_FORMAT),
           decode( x_SITE_USE_ID, FND_API.G_MISS_NUM, NULL,x_SITE_USE_ID),
           decode( x_MEDIA_TYPE, FND_API.G_MISS_CHAR, NULL,x_MEDIA_TYPE),
           decode( x_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL,x_CUST_ACCOUNT_ID),
           decode( x_NUMBER_OF_COPIES, FND_API.G_MISS_NUM, NULL,x_NUMBER_OF_COPIES),
           decode( x_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL,x_CURRENCY_CODE),
           decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
           decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
           decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
           decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
           decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
           decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL,x_REQUEST_ID),
           decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_APPLICATION_ID),
           decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL,x_PROGRAM_ID),
           decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_PROGRAM_UPDATE_DATE),
           decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_WH_UPDATE_DATE));

Line: 79

End Insert_Row;

Line: 83

PROCEDURE Delete_Row(                  x_BILLING_PREFERENCES_ID        NUMBER
 ) IS
 BEGIN
   DELETE FROM HZ_BILLING_PREFERENCES
    WHERE BILLING_PREFERENCES_ID = x_BILLING_PREFERENCES_ID;

Line: 91

 END Delete_Row;

Line: 95

PROCEDURE Update_Row(
                  x_Rowid            IN OUT NOCOPY       VARCHAR2,
                  x_BILLING_PREFERENCES_ID        NUMBER,
                  x_BILL_LANGUAGE                 VARCHAR2,
                  x_BILL_ROUND_NUMBER             VARCHAR2,
                  x_BILL_TYPE                     VARCHAR2,
                  x_MEDIA_FORMAT                  VARCHAR2,
                  x_SITE_USE_ID                   NUMBER,
                  x_MEDIA_TYPE                    VARCHAR2,
                  x_CUST_ACCOUNT_ID               NUMBER,
                  x_NUMBER_OF_COPIES              NUMBER,
                  x_CURRENCY_CODE                 VARCHAR2,
                  x_CREATED_BY                    NUMBER,
                  x_CREATION_DATE                 DATE,
                  x_LAST_UPDATE_LOGIN             NUMBER,
                  x_LAST_UPDATE_DATE              DATE,
                  x_LAST_UPDATED_BY               NUMBER,
                  x_REQUEST_ID                    NUMBER,
                  x_PROGRAM_APPLICATION_ID        NUMBER,
                  x_PROGRAM_ID                    NUMBER,
                  x_PROGRAM_UPDATE_DATE           DATE,
                  x_WH_UPDATE_DATE                DATE
 ) IS
 BEGIN
    Update HZ_BILLING_PREFERENCES
    SET
             BILLING_PREFERENCES_ID = decode( x_BILLING_PREFERENCES_ID, FND_API.G_MISS_NUM,BILLING_PREFERENCES_ID,x_BILLING_PREFERENCES_ID),
             BILL_LANGUAGE = decode( x_BILL_LANGUAGE, FND_API.G_MISS_CHAR,BILL_LANGUAGE,x_BILL_LANGUAGE),
             BILL_ROUND_NUMBER = decode( x_BILL_ROUND_NUMBER, FND_API.G_MISS_CHAR,BILL_ROUND_NUMBER,x_BILL_ROUND_NUMBER),
             BILL_TYPE = decode( x_BILL_TYPE, FND_API.G_MISS_CHAR,BILL_TYPE,x_BILL_TYPE),
             MEDIA_FORMAT = decode( x_MEDIA_FORMAT, FND_API.G_MISS_CHAR,MEDIA_FORMAT,x_MEDIA_FORMAT),
             SITE_USE_ID = decode( x_SITE_USE_ID, FND_API.G_MISS_NUM,SITE_USE_ID,x_SITE_USE_ID),
             MEDIA_TYPE = decode( x_MEDIA_TYPE, FND_API.G_MISS_CHAR,MEDIA_TYPE,x_MEDIA_TYPE),
             CUST_ACCOUNT_ID = decode( x_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM,CUST_ACCOUNT_ID,x_CUST_ACCOUNT_ID),
             NUMBER_OF_COPIES = decode( x_NUMBER_OF_COPIES, FND_API.G_MISS_NUM,NUMBER_OF_COPIES,x_NUMBER_OF_COPIES),
             CURRENCY_CODE = decode( x_CURRENCY_CODE, FND_API.G_MISS_CHAR,CURRENCY_CODE,x_CURRENCY_CODE),
             -- Bug 3032780
             /*
             CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
             CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
             */
             LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
             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),
             REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,REQUEST_ID,x_REQUEST_ID),
             PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,PROGRAM_APPLICATION_ID,x_PROGRAM_APPLICATION_ID),
             PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,PROGRAM_ID,x_PROGRAM_ID),
             PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,PROGRAM_UPDATE_DATE,x_PROGRAM_UPDATE_DATE),
             WH_UPDATE_DATE = decode( x_WH_UPDATE_DATE, FND_API.G_MISS_DATE,WH_UPDATE_DATE,x_WH_UPDATE_DATE)
    where rowid = X_RowId;

Line: 149

 END Update_Row;

Line: 167

                  x_LAST_UPDATE_LOGIN             NUMBER,
                  x_LAST_UPDATE_DATE              DATE,
                  x_LAST_UPDATED_BY               NUMBER,
                  x_REQUEST_ID                    NUMBER,
                  x_PROGRAM_APPLICATION_ID        NUMBER,
                  x_PROGRAM_ID                    NUMBER,
                  x_PROGRAM_UPDATE_DATE           DATE,
                  x_WH_UPDATE_DATE                DATE
 ) IS
   CURSOR C IS
        SELECT *
          FROM HZ_BILLING_PREFERENCES
         WHERE rowid = x_Rowid
         FOR UPDATE of BILLING_PREFERENCES_ID NOWAIT;

Line: 187

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

Line: 228

       AND (    ( Recinfo.LAST_UPDATE_LOGIN = x_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
                AND (  x_LAST_UPDATE_LOGIN IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_DATE = x_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  x_LAST_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.LAST_UPDATED_BY = x_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
                AND (  x_LAST_UPDATED_BY IS NULL )))
       AND (    ( Recinfo.REQUEST_ID = x_REQUEST_ID)
            OR (    ( Recinfo.REQUEST_ID IS NULL )
                AND (  x_REQUEST_ID IS NULL )))
       AND (    ( Recinfo.PROGRAM_APPLICATION_ID = x_PROGRAM_APPLICATION_ID)
            OR (    ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
                AND (  x_PROGRAM_APPLICATION_ID IS NULL )))
       AND (    ( Recinfo.PROGRAM_ID = x_PROGRAM_ID)
            OR (    ( Recinfo.PROGRAM_ID IS NULL )
                AND (  x_PROGRAM_ID IS NULL )))
       AND (    ( Recinfo.PROGRAM_UPDATE_DATE = x_PROGRAM_UPDATE_DATE)
            OR (    ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
                AND (  x_PROGRAM_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.WH_UPDATE_DATE = x_WH_UPDATE_DATE)
            OR (    ( Recinfo.WH_UPDATE_DATE IS NULL )
                AND (  x_WH_UPDATE_DATE IS NULL )))
       ) then
       return;

Line: 255

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