APPS.HZ_CLASS_CATEGORY_USES_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row (
    X_CLASS_CATEGORY                        IN     VARCHAR2,
    X_OWNER_TABLE                           IN     VARCHAR2,
    X_COLUMN_NAME                           IN     VARCHAR2,
    X_ADDITIONAL_WHERE_CLAUSE               IN     VARCHAR2,
    X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
    X_CREATED_BY_MODULE                     IN     VARCHAR2,
    X_APPLICATION_ID                        IN     NUMBER
) IS

BEGIN

    INSERT INTO HZ_CLASS_CATEGORY_USES (
        CLASS_CATEGORY,
        OWNER_TABLE,
        COLUMN_NAME,
        ADDITIONAL_WHERE_CLAUSE,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        OBJECT_VERSION_NUMBER,
        CREATED_BY_MODULE,
        APPLICATION_ID
    )
    VALUES (
        DECODE( X_CLASS_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CLASS_CATEGORY ),
        DECODE( X_OWNER_TABLE, FND_API.G_MISS_CHAR, NULL, X_OWNER_TABLE ),
        DECODE( X_COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),
        DECODE( X_ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
        HZ_UTILITY_V2PUB.CREATED_BY,
        HZ_UTILITY_V2PUB.CREATION_DATE,
        HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
        HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
        HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
        DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
        DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
        DECODE( X_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
    );

Line: 45

END Insert_Row;

Line: 47

PROCEDURE Update_Row (
    X_CLASS_CATEGORY                        IN     VARCHAR2,
    X_OWNER_TABLE                           IN     VARCHAR2,
    X_COLUMN_NAME                           IN     VARCHAR2,
    X_ADDITIONAL_WHERE_CLAUSE               IN     VARCHAR2,
    X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
    X_CREATED_BY_MODULE                     IN     VARCHAR2,
    X_APPLICATION_ID                        IN     NUMBER
) IS

BEGIN

    UPDATE HZ_CLASS_CATEGORY_USES SET
        COLUMN_NAME = DECODE( X_COLUMN_NAME, NULL, COLUMN_NAME, FND_API.G_MISS_CHAR, NULL, X_COLUMN_NAME ),
        ADDITIONAL_WHERE_CLAUSE = DECODE( X_ADDITIONAL_WHERE_CLAUSE, NULL, ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_WHERE_CLAUSE ),
        LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
        LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
        OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
        CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
        APPLICATION_ID = DECODE( X_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID )
    WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
    AND   OWNER_TABLE = X_OWNER_TABLE;

Line: 75

END Update_Row;

Line: 85

    X_LAST_UPDATE_LOGIN                     IN     NUMBER,
    X_LAST_UPDATE_DATE                      IN     DATE,
    X_LAST_UPDATED_BY                       IN     NUMBER,
    X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
    X_CREATED_BY_MODULE                     IN     VARCHAR2,
    X_APPLICATION_ID                        IN     NUMBER
) IS

    CURSOR C IS
        SELECT * FROM HZ_CLASS_CATEGORY_USES
        WHERE  ROWID = x_Rowid
        FOR UPDATE NOWAIT;

Line: 105

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

Line: 129

    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.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER )
        OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
            AND (  X_OBJECT_VERSION_NUMBER IS NULL ) ) )
    AND ( ( Recinfo.CREATED_BY_MODULE = X_CREATED_BY_MODULE )
        OR ( ( Recinfo.CREATED_BY_MODULE IS NULL )
            AND (  X_CREATED_BY_MODULE IS NULL ) ) )
    AND ( ( Recinfo.APPLICATION_ID = X_APPLICATION_ID )
        OR ( ( Recinfo.APPLICATION_ID IS NULL )
            AND (  X_APPLICATION_ID IS NULL ) ) )
    ) THEN
        RETURN;

Line: 150

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

Line: 156

PROCEDURE Select_Row (
    X_CLASS_CATEGORY                        IN OUT NOCOPY VARCHAR2,
    X_OWNER_TABLE                           IN OUT NOCOPY VARCHAR2,
    X_COLUMN_NAME                           OUT NOCOPY    VARCHAR2,
    X_ADDITIONAL_WHERE_CLAUSE               OUT NOCOPY    VARCHAR2,
    X_CREATED_BY_MODULE                     OUT NOCOPY    VARCHAR2,
    X_APPLICATION_ID                        OUT NOCOPY    NUMBER
) IS

BEGIN

    SELECT
        NVL( CLASS_CATEGORY, FND_API.G_MISS_CHAR ),
        NVL( OWNER_TABLE, FND_API.G_MISS_CHAR ),
        NVL( COLUMN_NAME, FND_API.G_MISS_CHAR ),
        NVL( ADDITIONAL_WHERE_CLAUSE, FND_API.G_MISS_CHAR ),
        NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
        NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
    INTO
        X_CLASS_CATEGORY,
        X_OWNER_TABLE,
        X_COLUMN_NAME,
        X_ADDITIONAL_WHERE_CLAUSE,
        X_CREATED_BY_MODULE,
        X_APPLICATION_ID
    FROM  HZ_CLASS_CATEGORY_USES
    WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
    AND   OWNER_TABLE = X_OWNER_TABLE;

Line: 193

END Select_Row;

Line: 195

PROCEDURE Delete_Row (
    X_CLASS_CATEGORY                        IN     VARCHAR2,
    X_OWNER_TABLE                           IN     VARCHAR2
) IS

BEGIN

    DELETE FROM HZ_CLASS_CATEGORY_USES
    WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
    AND   OWNER_TABLE = X_OWNER_TABLE;

Line: 210

END Delete_Row;