APPS.IEX_WF_NEW_DEL_STATUS_PUB SQL Statements

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

Line: 43

        SELECT b.user_id, b.user_name
          FROM JTF_RS_RESOURCE_EXTNS a
              ,JTF_RS_RESOURCE_EXTNS b
          WHERE b.source_id = a.source_mgr_id
            AND a.user_id = p_user_id;

Line: 97

    SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;

Line: 152

    l_parameter_list.DELETE;

Line: 199

      l_event_name            varchar2(240); -- fix a bug 3975142  := 'oracle.apps.iex.delstatus.update';

Line: 214

      l_action_type         varchar2(7); -- fix a bug 3975142  := 'updated';

Line: 219

        SELECT b.user_id, b.user_name
          FROM JTF_RS_RESOURCE_EXTNS a
              ,JTF_RS_RESOURCE_EXTNS b
          WHERE b.source_id = a.source_mgr_id
            AND a.user_id = p_user_id;

Line: 230

    l_event_name   := 'oracle.apps.iex.delstatus.update';

Line: 232

    l_action_type  := 'updated';

Line: 266

    SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;

Line: 311

      l_parameter_list.DELETE;