eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CLASS_CODE_RELATIONS_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_CLASS_CODE                            IN     VARCHAR2,
    X_SUB_CLASS_CODE                        IN     VARCHAR2,
    X_START_DATE_ACTIVE                     IN     DATE,
    X_END_DATE_ACTIVE                       IN     DATE,
    X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
    X_CREATED_BY_MODULE                     IN     VARCHAR2,
    X_APPLICATION_ID                        IN     NUMBER
) IS

BEGIN

    INSERT INTO HZ_CLASS_CODE_RELATIONS (
        CLASS_CATEGORY,
        CLASS_CODE,
        SUB_CLASS_CODE,
        START_DATE_ACTIVE,
        END_DATE_ACTIVE,
        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_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_CLASS_CODE ),
        DECODE( X_SUB_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, X_SUB_CLASS_CODE ),
        DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_START_DATE_ACTIVE ),
        DECODE( X_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_END_DATE_ACTIVE ),
        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: 48


END Insert_Row;

Line: 50


PROCEDURE Update_Row (
    X_CLASS_CATEGORY                        IN     VARCHAR2,
    X_CLASS_CODE                            IN     VARCHAR2,
    X_SUB_CLASS_CODE                        IN     VARCHAR2,
    X_START_DATE_ACTIVE                     IN     DATE,
    X_END_DATE_ACTIVE                       IN     DATE,
    X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
    X_CREATED_BY_MODULE                     IN     VARCHAR2,
    X_APPLICATION_ID                        IN     NUMBER
) IS

BEGIN

    UPDATE HZ_CLASS_CODE_RELATIONS SET
        END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
        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   CLASS_CODE = X_CLASS_CODE
    AND   SUB_CLASS_CODE = X_SUB_CLASS_CODE
    AND   START_DATE_ACTIVE = X_START_DATE_ACTIVE;

Line: 80


END Update_Row;

Line: 91


    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_CODE_RELATIONS
        WHERE  ROWID = x_Rowid
        FOR UPDATE NOWAIT;

Line: 111


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

Line: 138


    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: 159


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

Line: 165


PROCEDURE Select_Row (
    X_CLASS_CATEGORY                        IN OUT NOCOPY VARCHAR2,
    X_CLASS_CODE                            IN OUT NOCOPY VARCHAR2,
    X_SUB_CLASS_CODE                        IN OUT NOCOPY VARCHAR2,
    X_START_DATE_ACTIVE                     IN OUT NOCOPY DATE,
    X_END_DATE_ACTIVE                       OUT NOCOPY    DATE,
    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( CLASS_CODE, FND_API.G_MISS_CHAR ),
        NVL( SUB_CLASS_CODE, FND_API.G_MISS_CHAR ),
        NVL( START_DATE_ACTIVE, FND_API.G_MISS_DATE ),
        NVL( END_DATE_ACTIVE, FND_API.G_MISS_DATE ),
        NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
        NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
    INTO
        X_CLASS_CATEGORY,
        X_CLASS_CODE,
        X_SUB_CLASS_CODE,
        X_START_DATE_ACTIVE,
        X_END_DATE_ACTIVE,
        X_CREATED_BY_MODULE,
        X_APPLICATION_ID
    FROM  HZ_CLASS_CODE_RELATIONS
    WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
    AND   CLASS_CODE = X_CLASS_CODE
    AND   SUB_CLASS_CODE = X_SUB_CLASS_CODE
    AND   START_DATE_ACTIVE = X_START_DATE_ACTIVE;

Line: 207


END Select_Row;

Line: 209


PROCEDURE Delete_Row (
    X_CLASS_CATEGORY                        IN     VARCHAR2,
    X_CLASS_CODE                            IN     VARCHAR2,
    X_SUB_CLASS_CODE                        IN     VARCHAR2,
    X_START_DATE_ACTIVE                     IN     DATE

) IS

BEGIN

    DELETE FROM HZ_CLASS_CODE_RELATIONS
    WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
    AND   CLASS_CODE = X_CLASS_CODE
    AND   SUB_CLASS_CODE = X_SUB_CLASS_CODE
    AND   START_DATE_ACTIVE = X_START_DATE_ACTIVE;

Line: 229


END Delete_Row;