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_PERSON_LANGUAGE_PKG SQL Statements

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

Line: 5


PROCEDURE Insert_Row (
    X_LANGUAGE_USE_REFERENCE_ID             IN OUT NOCOPY NUMBER,
    X_LANGUAGE_NAME                         IN     VARCHAR2,
    X_PARTY_ID                              IN     NUMBER,
    X_NATIVE_LANGUAGE                       IN     VARCHAR2,
    X_PRIMARY_LANGUAGE_INDICATOR            IN     VARCHAR2,
    X_READS_LEVEL                           IN     VARCHAR2,
    X_SPEAKS_LEVEL                          IN     VARCHAR2,
    X_WRITES_LEVEL                          IN     VARCHAR2,
    X_SPOKEN_COMPREHENSION_LEVEL            IN     VARCHAR2,
    X_STATUS                                IN     VARCHAR2,
    X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
    X_CREATED_BY_MODULE                     IN     VARCHAR2,
    X_APPLICATION_ID                        IN     NUMBER
) IS

    l_success                               VARCHAR2(1) := 'N';

Line: 27


        INSERT INTO HZ_PERSON_LANGUAGE (
            LANGUAGE_USE_REFERENCE_ID,
            LANGUAGE_NAME,
            PARTY_ID,
            NATIVE_LANGUAGE,
            PRIMARY_LANGUAGE_INDICATOR,
            READS_LEVEL,
            SPEAKS_LEVEL,
            WRITES_LEVEL,
            SPOKEN_COMPREHENSION_LEVEL,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATE_LOGIN,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            STATUS,
            OBJECT_VERSION_NUMBER,
            CREATED_BY_MODULE,
            APPLICATION_ID
        )
        VALUES (
            DECODE( X_LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM, HZ_PERSON_LANGUAGE_S.NEXTVAL, NULL, HZ_PERSON_LANGUAGE_S.NEXTVAL, X_LANGUAGE_USE_REFERENCE_ID ),
            DECODE( X_LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
            DECODE( X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
            DECODE( X_NATIVE_LANGUAGE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_NATIVE_LANGUAGE ),
            DECODE( X_PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
            DECODE( X_READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
            DECODE( X_SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
            DECODE( X_WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
            DECODE( X_SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
            HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
            HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
            HZ_UTILITY_V2PUB.CREATED_BY,
            HZ_UTILITY_V2PUB.CREATION_DATE,
            HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
            HZ_UTILITY_V2PUB.REQUEST_ID,
            HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
            HZ_UTILITY_V2PUB.PROGRAM_ID,
            HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
            DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
            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 ),
            HZ_UTILITY_V2PUB.APPLICATION_ID
        ) RETURNING
            LANGUAGE_USE_REFERENCE_ID
        INTO
            X_LANGUAGE_USE_REFERENCE_ID;

Line: 92


                    SELECT HZ_PERSON_LANGUAGE_S.NEXTVAL
                    INTO X_LANGUAGE_USE_REFERENCE_ID FROM dual;

Line: 95


                        SELECT 'Y' INTO l_dummy
                        FROM HZ_PERSON_LANGUAGE
                        WHERE LANGUAGE_USE_REFERENCE_ID = X_LANGUAGE_USE_REFERENCE_ID;

Line: 112


END Insert_Row;

Line: 115


PROCEDURE Update_Row (
    X_Rowid                                 IN OUT NOCOPY VARCHAR2,
    X_LANGUAGE_USE_REFERENCE_ID             IN     NUMBER,
    X_LANGUAGE_NAME                         IN     VARCHAR2,
    X_PARTY_ID                              IN     NUMBER,
    X_NATIVE_LANGUAGE                       IN     VARCHAR2,
    X_PRIMARY_LANGUAGE_INDICATOR            IN     VARCHAR2,
    X_READS_LEVEL                           IN     VARCHAR2,
    X_SPEAKS_LEVEL                          IN     VARCHAR2,
    X_WRITES_LEVEL                          IN     VARCHAR2,
    X_SPOKEN_COMPREHENSION_LEVEL            IN     VARCHAR2,
    X_STATUS                                IN     VARCHAR2,
    X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
    X_CREATED_BY_MODULE                     IN     VARCHAR2,
    X_APPLICATION_ID                        IN     NUMBER
) IS

BEGIN

    UPDATE HZ_PERSON_LANGUAGE SET
        LANGUAGE_USE_REFERENCE_ID = DECODE( X_LANGUAGE_USE_REFERENCE_ID, NULL, LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM, NULL, X_LANGUAGE_USE_REFERENCE_ID ),
        LANGUAGE_NAME = DECODE( X_LANGUAGE_NAME, NULL, LANGUAGE_NAME, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_NAME ),
        PARTY_ID = DECODE( X_PARTY_ID, NULL, PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID ),
        NATIVE_LANGUAGE = DECODE( X_NATIVE_LANGUAGE, NULL, NATIVE_LANGUAGE, FND_API.G_MISS_CHAR, 'N', X_NATIVE_LANGUAGE ),
        PRIMARY_LANGUAGE_INDICATOR = DECODE( X_PRIMARY_LANGUAGE_INDICATOR, NULL, PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_LANGUAGE_INDICATOR ),
        READS_LEVEL = DECODE( X_READS_LEVEL, NULL, READS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_READS_LEVEL ),
        SPEAKS_LEVEL = DECODE( X_SPEAKS_LEVEL, NULL, SPEAKS_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPEAKS_LEVEL ),
        WRITES_LEVEL = DECODE( X_WRITES_LEVEL, NULL, WRITES_LEVEL, FND_API.G_MISS_CHAR, NULL, X_WRITES_LEVEL ),
        SPOKEN_COMPREHENSION_LEVEL = DECODE( X_SPOKEN_COMPREHENSION_LEVEL, NULL, SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR, NULL, X_SPOKEN_COMPREHENSION_LEVEL ),
        LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
        LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
        -- Bug 3032780
        -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
        -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
        LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
        REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
        PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
        PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
        PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
        STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
        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 ROWID = X_RowId;

Line: 164


END Update_Row;

Line: 177


    X_LAST_UPDATE_DATE                      IN     DATE,
    X_LAST_UPDATED_BY                       IN     NUMBER,
    X_CREATED_BY                            IN     NUMBER,
    X_CREATION_DATE                         IN     DATE,
    X_LAST_UPDATE_LOGIN                     IN     NUMBER,
    X_REQUEST_ID                            IN     NUMBER,
    X_PROGRAM_APPLICATION_ID                IN     NUMBER,
    X_PROGRAM_ID                            IN     NUMBER,
    X_PROGRAM_UPDATE_DATE                   IN     DATE,
    X_STATUS                                IN     VARCHAR2,
    X_OBJECT_VERSION_NUMBER                 IN     NUMBER,
    X_CREATED_BY_MODULE                     IN     VARCHAR2,
    X_APPLICATION_ID                        IN     NUMBER
) IS

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

Line: 204


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

Line: 237


    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.CREATED_BY = X_CREATED_BY )
        OR ( ( Recinfo.CREATED_BY IS NULL )
            AND (  X_CREATED_BY IS NULL ) ) )
    AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
        OR ( ( Recinfo.CREATION_DATE IS NULL )
            AND (  X_CREATION_DATE IS NULL ) ) )
    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.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.STATUS = X_STATUS )
        OR ( ( Recinfo.STATUS IS NULL )
            AND (  X_STATUS 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: 279


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

Line: 285


PROCEDURE Select_Row (
    X_LANGUAGE_USE_REFERENCE_ID             IN OUT NOCOPY NUMBER,
    X_LANGUAGE_NAME                         OUT NOCOPY    VARCHAR2,
    X_PARTY_ID                              OUT NOCOPY    NUMBER,
    X_NATIVE_LANGUAGE                       OUT NOCOPY    VARCHAR2,
    X_PRIMARY_LANGUAGE_INDICATOR            OUT NOCOPY    VARCHAR2,
    X_READS_LEVEL                           OUT NOCOPY    VARCHAR2,
    X_SPEAKS_LEVEL                          OUT NOCOPY    VARCHAR2,
    X_WRITES_LEVEL                          OUT NOCOPY    VARCHAR2,
    X_SPOKEN_COMPREHENSION_LEVEL            OUT NOCOPY    VARCHAR2,
    X_STATUS                                OUT NOCOPY    VARCHAR2,
    X_CREATED_BY_MODULE                     OUT NOCOPY    VARCHAR2,
    X_APPLICATION_ID                        OUT NOCOPY    NUMBER
) IS

BEGIN

    SELECT
        NVL( LANGUAGE_USE_REFERENCE_ID, FND_API.G_MISS_NUM ),
        NVL( LANGUAGE_NAME, FND_API.G_MISS_CHAR ),
        NVL( PARTY_ID, FND_API.G_MISS_NUM ),
        NVL( NATIVE_LANGUAGE, FND_API.G_MISS_CHAR ),
        NVL( PRIMARY_LANGUAGE_INDICATOR, FND_API.G_MISS_CHAR ),
        NVL( READS_LEVEL, FND_API.G_MISS_CHAR ),
        NVL( SPEAKS_LEVEL, FND_API.G_MISS_CHAR ),
        NVL( WRITES_LEVEL, FND_API.G_MISS_CHAR ),
        NVL( SPOKEN_COMPREHENSION_LEVEL, FND_API.G_MISS_CHAR ),
        NVL( STATUS, FND_API.G_MISS_CHAR ),
        NVL( CREATED_BY_MODULE, FND_API.G_MISS_CHAR ),
        NVL( APPLICATION_ID, FND_API.G_MISS_NUM )
    INTO
        X_LANGUAGE_USE_REFERENCE_ID,
        X_LANGUAGE_NAME,
        X_PARTY_ID,
        X_NATIVE_LANGUAGE,
        X_PRIMARY_LANGUAGE_INDICATOR,
        X_READS_LEVEL,
        X_SPEAKS_LEVEL,
        X_WRITES_LEVEL,
        X_SPOKEN_COMPREHENSION_LEVEL,
        X_STATUS,
        X_CREATED_BY_MODULE,
        X_APPLICATION_ID
    FROM HZ_PERSON_LANGUAGE
    WHERE LANGUAGE_USE_REFERENCE_ID = X_LANGUAGE_USE_REFERENCE_ID;

Line: 339


END Select_Row;

Line: 341


PROCEDURE Delete_Row (
    X_LANGUAGE_USE_REFERENCE_ID             IN     NUMBER
) IS

BEGIN

    DELETE FROM HZ_PERSON_LANGUAGE
    WHERE LANGUAGE_USE_REFERENCE_ID = X_LANGUAGE_USE_REFERENCE_ID;

Line: 354


END Delete_Row;