APPS.IEU_NONMEDIA_ACTION_PVT SQL Statements

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

Line: 38

    fnd_msg_pub.delete_msg();

Line: 48

    select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;

Line: 50

    EXECUTE immediate 'INSERT INTO  IEU_UWQ_NONMEDIA_ACTIONS '||
    '(   NONMEDIA_ACTION_ID, ' ||
    '    CREATED_BY, ' ||
    '    CREATION_DATE, ' ||
    '    LAST_UPDATED_BY,' ||
    '    LAST_UPDATE_DATE, ' ||
    '    LAST_UPDATE_LOGIN, ' ||
    '    ACTION_OBJECT_CODE, ' ||
    '    MACTION_DEF_ID, ' ||
    '    APPLICATION_ID, ' ||
    '    RESPONSIBILITY_ID, ' ||
    '    SOURCE_FOR_TASK_FLAG, ' ||
    '  OBJECT_VERSION_NUMBER,' ||
    '  SECURITY_GROUP_ID ' ||
    ' )VALUES ' ||
    '(:1 ,' ||
    ' :2, '||
    ' :3, '||
    ' :4, '||
    ' :5, '||
    ' :6, '||
    ' :7, '||
    ' :8, '||
    ' :9, '||
    ' :10, '||
    ' :11, '||
    ' :12, '||
    ' :13 '||
    ') '
     USING  l_nmedia_id,
       FND_GLOBAL.USER_ID,
        SYSDATE,
        FND_GLOBAL.USER_ID,
        SYSDATE,
        FND_GLOBAL.LOGIN_ID,
        LTRIM(RTRIM(p_docname)),
        p_mdef_id,
        696,
        p_resp_id,
        p_tflag,
        0,
        0;

Line: 115

PROCEDURE Update_NMediaAction(    x_return_status  OUT NOCOPY VARCHAR2,
                        x_msg_count OUT  NOCOPY NUMBER,
                       x_msg_data  OUT  NOCOPY VARCHAR2,
                       p_nmedia_id IN NUMBER,
                       p_docname IN VARCHAR2,
                       p_resp_id IN NUMBER,
                       p_tflag IN VARCHAR2,
                       p_mdef_id IN NUMBER
                       )as
    l_language             VARCHAR2(4);

Line: 138

    fnd_msg_pub.delete_msg();

Line: 148

        update IEU_UWQ_NONMEDIA_ACTIONS set
            LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
            LAST_UPDATE_DATE = SYSDATE,
            LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
            MACTION_DEF_ID = p_mdef_id,
            RESPONSIBILITY_ID = p_resp_id,
            SOURCE_FOR_TASK_FLAG = p_tflag,
            ACTION_OBJECT_CODE= p_docname
         where
          NONMEDIA_ACTION_ID = p_nmedia_id;

Line: 162

             select IEU_UWQ_NONMEDIA_ACTIONS_S1.nextval into l_nmedia_id from dual;

Line: 164

             EXECUTE immediate 'INSERT INTO  IEU_UWQ_NONMEDIA_ACTIONS '||
             '(   NONMEDIA_ACTION_ID, ' ||
             '    CREATED_BY, ' ||
             '    CREATION_DATE, ' ||
             '    LAST_UPDATED_BY,' ||
             '    LAST_UPDATE_DATE, ' ||
             '    LAST_UPDATE_LOGIN, ' ||
             '    ACTION_OBJECT_CODE, ' ||
             '    MACTION_DEF_ID, ' ||
             '    APPLICATION_ID, ' ||
             '    RESPONSIBILITY_ID, ' ||
             '    SOURCE_FOR_TASK_FLAG, ' ||
             '  OBJECT_VERSION_NUMBER,' ||
             '  SECURITY_GROUP_ID ' ||
             ' )VALUES ' ||
             '(:1 ,' ||
             ' :2, '||
             ' :3, '||
             ' :4, '||
             ' :5, '||
             ' :6, '||
             ' :7, '||
             ' :8, '||
             ' :9, '||
             ' :10, '||
             ' :11, '||
             ' :12, '||
             ' :13 '||
             ') '
              USING  l_nmedia_id,
                FND_GLOBAL.USER_ID,
                 SYSDATE,
                 FND_GLOBAL.USER_ID,
                 SYSDATE,
                 FND_GLOBAL.LOGIN_ID,
                 LTRIM(RTRIM(p_docname)),
                 p_mdef_id,
                 696,
                 p_resp_id,
                 p_tflag,
                 0,
                 0;

Line: 230

END Update_NMediaAction;

Line: 232

PROCEDURE Delete_NMediaAction(    x_return_status  OUT NOCOPY VARCHAR2,
                        x_msg_count OUT  NOCOPY NUMBER,
                       x_msg_data  OUT  NOCOPY VARCHAR2,
                       x_nmedia_id IN NUMBER
                       )as
    l_language             VARCHAR2(4);

Line: 251

    fnd_msg_pub.delete_msg();

Line: 261

    'delete from IEU_UWQ_NONMEDIA_ACTIONS '||
    ' where  NONMEDIA_ACTION_ID = :1'
    USING x_nmedia_id;

Line: 288

END Delete_NMediaAction;