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

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

Line: 5


PROCEDURE Insert_Row(
                 x_WORK_CLASS_ID             IN OUT NOCOPY    NUMBER,
	          x_LEVEL_OF_EXPERIENCE       IN    VARCHAR2,
	          x_WORK_CLASS_NAME           IN    VARCHAR2,
	          x_EMPLOYMENT_HISTORY_ID     IN    NUMBER,
	          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: 22


   INSERT INTO HZ_WORK_CLASS(
           WORK_CLASS_ID,
           LEVEL_OF_EXPERIENCE,
           WORK_CLASS_NAME,
           CREATED_BY,
           EMPLOYMENT_HISTORY_ID,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE,
           STATUS,
           OBJECT_VERSION_NUMBER,
           CREATED_BY_MODULE,
           APPLICATION_ID
          ) VALUES (
           DECODE( x_WORK_CLASS_ID, FND_API.G_MISS_NUM, HZ_WORK_CLASS_S.NEXTVAL, NULL, HZ_WORK_CLASS_S.NEXTVAL, X_WORK_CLASS_ID ),
           decode( x_LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL,x_LEVEL_OF_EXPERIENCE),
           decode( x_WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL,x_WORK_CLASS_NAME),
           HZ_UTILITY_V2PUB.CREATED_BY,
           decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYMENT_HISTORY_ID),
           HZ_UTILITY_V2PUB.CREATION_DATE,
           HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
           HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
           HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
           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
            WORK_CLASS_ID
        INTO
            X_WORK_CLASS_ID;

Line: 76


                    SELECT HZ_WORK_CLASS_S.NEXTVAL
                    INTO X_WORK_CLASS_ID FROM dual;

Line: 79


                        SELECT 'Y' INTO l_dummy
                        FROM HZ_WORK_CLASS
                        WHERE WORK_CLASS_ID = X_WORK_CLASS_ID;

Line: 96


END Insert_Row;

Line: 101


PROCEDURE Delete_Row(                  x_WORK_CLASS_ID                 NUMBER
 ) IS
 BEGIN
   DELETE FROM HZ_WORK_CLASS
    WHERE WORK_CLASS_ID = x_WORK_CLASS_ID;

Line: 109


 END Delete_Row;

Line: 113


PROCEDURE Update_Row(
                  x_Rowid         IN  OUT NOCOPY         VARCHAR2,
                  x_WORK_CLASS_ID             IN     NUMBER,
		  x_LEVEL_OF_EXPERIENCE       IN    VARCHAR2,
		  x_WORK_CLASS_NAME           IN    VARCHAR2,
		  x_EMPLOYMENT_HISTORY_ID     IN    NUMBER,
		  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_WORK_CLASS
    SET

            WORK_CLASS_ID = decode( x_WORK_CLASS_ID, NULL, WORK_CLASS_ID, FND_API.G_MISS_NUM, NULL, x_WORK_CLASS_ID),
             LEVEL_OF_EXPERIENCE = decode( x_LEVEL_OF_EXPERIENCE, NULL, LEVEL_OF_EXPERIENCE, FND_API.G_MISS_CHAR, NULL, x_LEVEL_OF_EXPERIENCE),
             WORK_CLASS_NAME = decode( x_WORK_CLASS_NAME, NULL, WORK_CLASS_NAME, FND_API.G_MISS_CHAR, NULL, x_WORK_CLASS_NAME),
             -- Bug 3032780
             -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
             EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, x_EMPLOYMENT_HISTORY_ID),
             -- Bug 3032780
             -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
             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,
             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,NULL,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=HZ_UTILITY_V2PUB.APPLICATION_ID
    where rowid = X_RowId;

Line: 152


 END Update_Row;

Line: 164


                  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_STATUS                        VARCHAR2
 ) IS
   CURSOR C IS
        SELECT *
          FROM HZ_WORK_CLASS
         WHERE rowid = x_Rowid
         FOR UPDATE of WORK_CLASS_ID NOWAIT;

Line: 184


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

Line: 207


       AND (    ( Recinfo.LAST_UPDATE_LOGIN = x_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN = NULL )
                AND (  x_LAST_UPDATE_LOGIN = NULL )))
       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.REQUEST_ID = x_REQUEST_ID)
            OR (    ( Recinfo.REQUEST_ID = NULL )
                AND (  x_REQUEST_ID = NULL )))
       AND (    ( Recinfo.PROGRAM_APPLICATION_ID = x_PROGRAM_APPLICATION_ID)
            OR (    ( Recinfo.PROGRAM_APPLICATION_ID = NULL )
                AND (  x_PROGRAM_APPLICATION_ID = NULL )))
       AND (    ( Recinfo.PROGRAM_ID = x_PROGRAM_ID)
            OR (    ( Recinfo.PROGRAM_ID = NULL )
                AND (  x_PROGRAM_ID = NULL )))
       AND (    ( Recinfo.PROGRAM_UPDATE_DATE = x_PROGRAM_UPDATE_DATE)
            OR (    ( Recinfo.PROGRAM_UPDATE_DATE = NULL )
                AND (  x_PROGRAM_UPDATE_DATE = NULL )))
       AND (    ( Recinfo.STATUS = x_STATUS)
            OR (    ( Recinfo.STATUS = NULL )
                AND (  x_STATUS = NULL )))
       ) then
       return;

Line: 234


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

Line: 239


PROCEDURE Select_Row (
    x_work_class_id                         IN OUT NOCOPY NUMBER,
    x_level_of_experience                   OUT    NOCOPY VARCHAR2,
    x_work_class_name                       OUT    NOCOPY VARCHAR2,
    x_employment_history_id                 OUT    NOCOPY NUMBER,
    x_status                                OUT    NOCOPY VARCHAR2,
    x_application_id                        OUT    NOCOPY NUMBER,
    x_created_by_module                     OUT    NOCOPY VARCHAR2
) IS
BEGIN

    SELECT
      NVL(work_class_id, FND_API.G_MISS_NUM),
      NVL(level_of_experience, FND_API.G_MISS_CHAR),
      NVL(work_class_name, FND_API.G_MISS_CHAR),
      NVL(employment_history_id, FND_API.G_MISS_NUM),
      NVL(status, FND_API.G_MISS_CHAR),
      NVL(application_id, FND_API.G_MISS_NUM),
      NVL(created_by_module, FND_API.G_MISS_CHAR)
    INTO
      x_work_class_id,
      x_level_of_experience,
      x_work_class_name,
      x_employment_history_id,
      x_status,
      x_application_id,
      x_created_by_module
    FROM HZ_WORK_CLASS
    WHERE work_class_id = x_work_class_id;

Line: 278


END Select_Row;