APPS.JTM_LOOKUPS_ACC_PKG SQL Statements

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

Line: 31

PROCEDURE INSERT_ROW (
   X_LOOKUP_TYPE                     IN VARCHAR2 ,
   X_VIEW_APPLICATION_ID             IN NUMBER ,
   X_SECURITY_GROUP_ID               IN NUMBER ,
   X_APPLICATION_ID                  IN NUMBER ,
   X_ACCESS_ID                     OUT NOCOPY NUMBER
) IS

BEGIN

    SELECT JTM_FND_LOOKUPS_ACC_S.NEXTVAL
    INTO X_ACCESS_ID FROM DUAL;

Line: 44

    INSERT INTO JTM_FND_LOOKUPS_ACC (
            ACCESS_ID  ,
            LAST_UPDATE_DATE ,
            LAST_UPDATED_BY  ,
            CREATION_DATE    ,
            CREATED_BY       ,
            LOOKUP_TYPE      ,
            VIEW_APPLICATION_ID ,
            SECURITY_GROUP_ID,
            APPLICATION_ID   ,
            COUNTER
     )
     VALUES (
            X_ACCESS_ID ,
            SYSDATE,
            1,
            SYSDATE,
            1,
            X_LOOKUP_TYPE,
            X_VIEW_APPLICATION_ID,
            X_SECURITY_GROUP_ID,
            X_APPLICATION_ID,
            1
    );

Line: 76

END  INSERT_ROW;

Line: 79

PROCEDURE UPDATE_ROW (
   X_LOOKUP_TYPE                     IN VARCHAR2 ,
   X_VIEW_APPLICATION_ID             IN NUMBER ,
   X_SECURITY_GROUP_ID               IN NUMBER ,
   X_APPLICATION_ID                  IN NUMBER
) IS

BEGIN
    UPDATE JTM_FND_LOOKUPS_ACC
    SET LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATED_BY  = 1,
        CREATED_BY       = 1,
        CREATION_DATE    = CREATION_DATE,
        LOOKUP_TYPE = X_LOOKUP_TYPE ,
        VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID,
        SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
        APPLICATION_ID = X_APPLICATION_ID
    WHERE LOOKUP_TYPE = X_LOOKUP_TYPE
    AND   VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
    AND   SECURITY_GROUP_ID   = X_SECURITY_GROUP_ID
    AND   APPLICATION_ID      = X_APPLICATION_ID;

Line: 105

END UPDATE_ROW;

Line: 110

PROCEDURE DELETE_ROW (
   X_LOOKUP_TYPE                     IN VARCHAR2 ,
   X_VIEW_APPLICATION_ID             IN NUMBER ,
   X_SECURITY_GROUP_ID               IN NUMBER ,
   X_APPLICATION_ID                  IN NUMBER
) IS

BEGIN
    DELETE FROM JTM_FND_LOOKUPS_ACC
    WHERE LOOKUP_TYPE = X_LOOKUP_TYPE
    AND   VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
    AND   SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
    AND   APPLICATION_ID = X_APPLICATION_ID;

Line: 128

END DELETE_ROW;