APPS.IEC_RECORD_FILTER_PVT SQL Statements

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

Line: 42

   SELECT ORACLE_USERNAME
   INTO l_schema_name
   FROM FND_ORACLE_USERID
   WHERE READ_ONLY_FLAG = 'U';

Line: 99

      SELECT RETURNS_ID, ITM_CC_TZ_ID
      BULK COLLECT INTO l_returns_ids, l_itm_cc_tz_ids
      FROM IEC_G_RETURN_ENTRIES
      WHERE LIST_HEADER_ID = P_LIST_HEADER_ID AND DO_NOT_USE_FLAG = 'Y' AND DO_NOT_USE_REASON = P_DNU_REASON_CODE;

Line: 106

      SELECT RETURNS_ID, ITM_CC_TZ_ID
      BULK COLLECT INTO l_returns_ids, l_itm_cc_tz_ids
      FROM IEC_G_RETURN_ENTRIES
      WHERE LIST_HEADER_ID = P_LIST_HEADER_ID AND DO_NOT_USE_FLAG = 'Y';

Line: 116

         UPDATE IEC_G_RETURN_ENTRIES
         SET DO_NOT_USE_FLAG = 'N'
           , DO_NOT_USE_REASON = NULL
         WHERE RETURNS_ID = l_returns_ids(I);

Line: 122

         UPDATE IEC_G_MKTG_ITEM_CC_TZS
         SET RECORD_COUNT = NVL(RECORD_COUNT, 0) + 1
         WHERE ITM_CC_TZ_ID = l_itm_cc_tz_ids(I);

Line: 177

      EXECUTE IMMEDIATE ' SELECT STATUS ' ||
                        ' FROM ALL_OBJECTS ' ||
                        ' WHERE OWNER = :owner ' ||
                        ' AND OBJECT_NAME = :b1 ' ||
                        ' AND OBJECT_TYPE = ''VIEW'' '
      INTO l_status
      USING l_view_owner
          , l_view_name;

Line: 269

   l_create_as_str  CONSTANT VARCHAR2(100) := ' AS SELECT LIST_HEADER_ID, LIST_ENTRY_ID FROM ';

Line: 393

      SELECT 1
      INTO   l_ignore
      FROM   ALL_VIEWS
      WHERE  VIEW_NAME = UPPER(l_view_name)
      AND    OWNER = UPPER(l_view_owner);

Line: 533

         'SELECT B.TAG
          FROM IEC_O_RELEASE_CTLS_B A, IEC_LOOKUPS B
          WHERE A.RELEASE_CONTROL_ID = :record_filter_id
          AND B.LOOKUP_TYPE = ''IEC_SOURCE_VIEW_MAP''
          AND A.SOURCE_TYPE_CODE = B.LOOKUP_CODE'
      INTO x_source_type_view
      USING p_record_filter_id;

Line: 551

         'SELECT VIEW_NAME
          FROM ALL_VIEWS
          WHERE VIEW_NAME = UPPER(:source_type_view)
          AND OWNER = UPPER(:owner)'
      INTO l_ignore
      USING x_source_type_view
          , l_view_owner;

Line: 745

            'SELECT ''N''
             FROM ' || l_view_name || '
             WHERE LIST_HEADER_ID = :list_id
             AND LIST_ENTRY_ID = :list_entry_id
             AND ROWNUM <= 1'
         INTO x_callable_flag
         USING IN p_list_id
             , IN p_list_entry_id;

Line: 761

         iec_returns_util_pvt.Update_Entry( p_returns_id
                                          , -1
                                          , to_char(null)
                                          , to_char(null)
                                          , to_char(null)
                                          , 38
                                          , 0
                                          , 0
                                          , 'N');

Line: 798

      select list_header_id from ams_list_headers_all where release_control_alg_id = p_record_filter_id;