DBA Data[Home] [Help]

APPS.POS_INIT_SESSION_PKG SQL Statements

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

Line: 10

     UPDATE ICX_SESSIONS
        SET responsibility_id = to_number(p_resp_id),
            RESPONSIBILITY_APPLICATION_ID = 178
      WHERE session_id = icx_sec.getID(icx_sec.PV_SESSION_ID);
Line: 20

     UPDATE ICX_SESSIONS
        SET ORG_ID = fnd_profile.value('ORG_ID')
      WHERE session_id = icx_sec.getID(icx_sec.PV_SESSION_ID);