APPS.JTM_FND_DESC_FLEXS_ACC_PKG SQL Statements

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

Line: 31

PROCEDURE INSERT_ROW (
   X_BASE_APPLICATION_ID             IN NUMBER ,
   X_DESCRIPTIVE_FLEXFIELD_NAME      IN VARCHAR2 ,
   X_MOBILE_TABLE_NAME               IN VARCHAR2 ,
   X_APPLICATION_ID                  IN NUMBER ,
   X_ACCESS_ID                     OUT NOCOPY NUMBER
) IS

BEGIN

    SELECT JTM_FND_DESC_FLEXS_ACC_S.NEXTVAL
    INTO X_ACCESS_ID FROM DUAL;

Line: 44

    INSERT INTO JTM_FND_DESCR_FLEXS_ACC (
            ACCESS_ID  ,
            LAST_UPDATE_DATE ,
            LAST_UPDATED_BY  ,
            CREATION_DATE    ,
            CREATED_BY       ,
            BASE_APPLICATION_ID      ,
            DESCRIPTIVE_FLEXFIELD_NAME ,
            MOBILE_TABLE_NAME,
            APPLICATION_ID   ,
            COUNTER
     )
     VALUES (
            X_ACCESS_ID ,
            SYSDATE,
            1,
            SYSDATE,
            1,
            X_BASE_APPLICATION_ID,
            X_DESCRIPTIVE_FLEXFIELD_NAME,
            X_MOBILE_TABLE_NAME,
            X_APPLICATION_ID,
            1
    );

Line: 76

END  INSERT_ROW;

Line: 79

PROCEDURE UPDATE_ROW (
   X_BASE_APPLICATION_ID             IN NUMBER ,
   X_DESCRIPTIVE_FLEXFIELD_NAME      IN VARCHAR2 ,
   X_MOBILE_TABLE_NAME               IN VARCHAR2 ,
   X_APPLICATION_ID                  IN NUMBER
) IS

BEGIN
    UPDATE JTM_FND_DESCR_FLEXS_ACC
    SET LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATED_BY  = 1,
        CREATED_BY       = 1,
        CREATION_DATE    = CREATION_DATE,
        BASE_APPLICATION_ID = X_BASE_APPLICATION_ID ,
        DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME,
        MOBILE_TABLE_NAME = X_MOBILE_TABLE_NAME,
        APPLICATION_ID = X_APPLICATION_ID
    WHERE BASE_APPLICATION_ID = X_BASE_APPLICATION_ID
    AND   DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    AND   MOBILE_TABLE_NAME = X_MOBILE_TABLE_NAME
    AND   APPLICATION_ID    = X_APPLICATION_ID;

Line: 105

END UPDATE_ROW;

Line: 109

PROCEDURE DELETE_ROW (
   X_BASE_APPLICATION_ID             IN NUMBER ,
   X_DESCRIPTIVE_FLEXFIELD_NAME      IN VARCHAR2 ,
   X_MOBILE_TABLE_NAME               IN VARCHAR2 ,
   X_APPLICATION_ID                  IN NUMBER
) IS

BEGIN
    DELETE FROM JTM_FND_DESCR_FLEXS_ACC
    WHERE BASE_APPLICATION_ID = X_BASE_APPLICATION_ID
    AND   DESCRIPTIVE_FLEXFIELD_NAME = X_DESCRIPTIVE_FLEXFIELD_NAME
    AND   MOBILE_TABLE_NAME = X_MOBILE_TABLE_NAME
    AND   APPLICATION_ID = X_APPLICATION_ID;

Line: 127

END DELETE_ROW;