APPS.OKC_TERMS_DISP_PVT SQL Statements

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

Line: 11

  G_RECORD_DELETED             CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

Line: 13

  G_RECORD_LOGICALLY_DELETED   CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line: 51

    SELECT terms_display_order
    FROM okc_terms_artsec_disp_temp
    WHERE terms_id = p_terms_id
    AND terms_type = p_terms_type
    AND processed_flag = 'Y';

Line: 80

     SELECT document_id,
             document_type,
             terms_type,
             terms_id,
             parent_id,
             terms_display_sequence,
             terms_display_level,
             LPAD(ROWNUM,5,'0') disp_order,
             'Y',
             runid
     FROM    okc_terms_artsec_disp_temp
    WHERE  document_id = p_document_id
    AND    document_type = p_document_type
    AND    processed_flag = 'N'
    AND    parent_id IS null
    AND    terms_type = 'SECTION'
    ORDER BY terms_display_sequence ;

Line: 103

    SELECT document_id,
           document_type,
           terms_type,
           terms_id,
           parent_id,
           terms_display_level,
           terms_display_sequence,
           runid
   FROM    okc_terms_artsec_disp_temp t
    WHERE  document_id = lc_document_id
    AND    document_type = lc_document_type
    AND    processed_flag = 'N'
    AND    exists (SELECT 1
                   FROM okc_terms_artsec_disp_temp t1
                   WHERE t1.terms_type = 'SECTION'
                   AND t1.terms_id = t.parent_id
                   AND t1.document_id = lc_document_id
                   AND t1.document_type = lc_document_type
                   AND t1.terms_display_level = lc_level)
    ORDER BY parent_id,terms_display_sequence;

Line: 127

     SELECT NVL(MAX(terms_display_level),0)
     FROM okc_terms_artsec_disp_temp
     WHERE  document_id = lc_document_id
     AND    document_type = lc_document_type
     AND    processed_flag = 'N';

Line: 135

  DELETE FROM okc_terms_artsec_disp_temp
  WHERE document_id = p_document_id
  AND document_type = p_document_type;

Line: 139

  INSERT INTO okc_terms_artsec_disp_temp
  (document_id,
   document_type,
   terms_type,
   terms_id,
   parent_id,
   terms_display_sequence,
   terms_display_level,
   terms_display_order,
   processed_flag,
   runid
  )
  (select document_id,
          document_type,
          'SECTION',
          id,
          scn_id,
          section_sequence,
          level,
          '',
          'N',
          p_run_id
   from okc_sections_b
   where document_id = p_document_id
   and document_type = p_document_type
   connect by prior id = scn_id
   start with scn_id is null
   and document_id = p_document_id
   and document_type = p_document_type);

Line: 169

  INSERT INTO okc_terms_artsec_disp_temp
  (document_id,
   document_type,
   terms_type,
   terms_id,
   parent_id,
   terms_display_sequence,
   terms_display_level,
   terms_display_order,
   processed_flag,
   runid
  )
  (select document_id,
          document_type,
          'ARTICLE',
          id,
          scn_id,
          display_sequence,
          null,
          '',
          'N',
          p_run_id
   from okc_k_articles_b
   where document_id = p_document_id
   and document_type = p_document_type);

Line: 201

     insert into okc_terms_artsec_disp_temp
     (document_id,
      document_type,
      terms_type,
      terms_id,
      parent_id,
      terms_display_sequence,
      terms_display_level,
      terms_display_order,
      processed_flag
     )
     SELECT document_id,
             document_type,
             terms_type,
             terms_id,
             parent_id,
             terms_display_sequence,
             terms_display_level,
             LPAD(ROWNUM,5,'0'),
             'Y'
     FROM    okc_terms_artsec_disp_temp
    WHERE  document_id = p_document_id
    AND    document_type = p_document_type
    AND    processed_flag = 'N'
    AND    parent_id IS null
    AND    terms_type = 'SECTION'
    ORDER BY terms_display_sequence ;

Line: 233

     insert into okc_terms_artsec_disp_temp
     (document_id,
      document_type,
      terms_type,
      terms_id,
      parent_id,
      terms_display_sequence,
      terms_display_level,
      terms_display_order,
      processed_flag,
      runid
     )
     VALUES
     ( rec.document_id,
             rec.document_type,
             rec.terms_type,
             rec.terms_id,
             rec.parent_id,
             rec.terms_display_sequence,
             rec.terms_display_level,
             LPAD(l_display_order,5,'0'),
             'Y',
             rec.runid);

Line: 280

             insert into okc_terms_artsec_disp_temp
             ( document_id,
               document_type,
               terms_type,
               terms_id,
               parent_id,
               terms_display_sequence,
               terms_display_level,
               terms_display_order,
               processed_flag,
               runid
              )
             VALUES
             ( rec.document_id,
               rec.document_type,
               rec.terms_type,
               rec.terms_id,
               rec.parent_id,
               rec.terms_display_sequence,
               rec.terms_display_level,
               l_parent_disp_order||'.'||LPAD(l_display_order,5,'0'),
               'Y',
               rec.runid
              );

Line: 310

    DELETE FROM okc_terms_artsec_disp_temp
    WHERE document_id = p_document_id
    AND document_type = p_document_type
    AND processed_flag = 'N';

Line: 331

    SELECT '1'
    FROM OKC_TERMS_ARTSEC_DISP_TEMP
    WHERE document_type = p_document_type
    AND document_id = p_document_id
    AND runid = p_run_id;

Line: 377

    SELECT '1'
    FROM OKC_TERMS_ARTSEC_DISP_TEMP
    WHERE document_type = p_document_type
    AND document_id = p_document_id;