APPS.OKC_CODE_HOOK SQL Statements

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

Line: 218

      SELECT template_id
        INTO l_template_id
        FROM okc_template_usages
       WHERE document_type = p_doc_type AND document_id = p_doc_id;

Line: 229

      SELECT  intent, org_id,   xprt_clause_mandatory_flag

       INTO  l_intent, l_org_id, l_tmp_lvl_mandatory_flag
      FROM   okc.okc_terms_templates_all

      WHERE  template_id = l_template_id;

Line: 243

      SELECT  outcome.object_value_id,outcome.mandatory_yn, outcome.mandatory_rwa
        bulk COLLECT INTO  l_outcome_tbl
        FROM (SELECT rule.rule_id rule_id
                FROM okc_xprt_rule_hdrs rule,
                     okc_xprt_template_rules trule,
                     fnd_lookups lkup,
                     fnd_lookups ruletypelkup
               WHERE rule.rule_id = trule.rule_id
                 AND trule.template_id = l_template_id
                 AND rule.status_code = lkup.lookup_code
                 AND lkup.lookup_type = 'OKC_XPRT_RULE_STATUS'
                 AND rule.status_code  =  'ACTIVE'
                 AND ruletypelkup.lookup_type = 'OKC_XPRT_RULE_TYPE'
                 AND rule.rule_type = ruletypelkup.lookup_code
              UNION ALL
              -- Get the org wide rules
              SELECT rule.rule_id rule_id
                FROM okc_xprt_rule_hdrs rule,
                     fnd_lookups lkup,
                     fnd_lookups ruletypelkup
               WHERE rule.status_code = lkup.lookup_code
                 AND lkup.lookup_type = 'OKC_XPRT_RULE_STATUS'
                 AND rule.status_code = 'ACTIVE'
                 AND ruletypelkup.lookup_type = 'OKC_XPRT_RULE_TYPE'
                 AND rule.rule_type = ruletypelkup.lookup_code
                 AND org_id = l_org_id
                 AND intent = l_intent
                 AND org_wide_flag = 'Y') rule,
                 okc_xprt_rule_outcomes outcome
           WHERE outcome.rule_id     = rule.rule_id
             AND outcome.object_type = 'CLAUSE';

Line: 297

                 l_outcome_tbl.DELETE(i);

Line: 309

                 UPDATE okc_k_articles_b
                    SET   mandatory_yn  = Nvl(l_outcome_tbl(i).mandatory_yn,l_tmp_lvl_mandatory_flag)
                         ,mandatory_rwa = l_outcome_tbl(i).mandatory_rwa
                 WHERE  document_type = p_doc_type
                  AND   document_id   = p_doc_id
                  AND   sav_sae_id    = l_outcome_tbl(i).clause_id ;

Line: 394

		SELECT id, scn_id from
		(SELECT id,scn_id,article_number,
		Decode(InStr(article_number,'.'),0,Decode(InStr(article_number,' '),0,Decode(regexp_instr(article_number,'[a-zA-Z]'),0,article_number,NULL),SubStr(article_number,1, InStr(article_number,' ')-1)),
		SubStr(article_number,1, InStr(article_number,'.')-1)) col1,
		Decode(InStr(article_number,'-'),0,Decode(InStr(article_number,' '),0,Decode(InStr(article_number,'.'),0,0,SubStr(article_number,InStr(article_number,'.')+1)),decode(instr(article_number,'.'),0,0,
		SubStr(article_number,InStr(article_number,'.')+1,InStr(article_number,' ')-InStr(article_number,'.')))),SubStr(article_number,InStr(article_number,'.')+1, InStr(article_number,'-')-InStr(article_number,'.')-1)) col2,
		Decode(InStr(article_number,' '),0,Decode(InStr(article_number,'-'),0,0,SubStr(article_number,InStr(article_number,'-')+1)),
		Decode(InStr(article_number,'-'),0,0,SubStr(article_number,InStr(article_number,'-')+1, InStr(article_number,' ')-InStr(article_number,'-')-1))) col3,
		Decode(InStr(article_number,' '),0,' ',SubStr(article_number,InStr(article_number,' ')+1)) col4
		FROM okc_k_articles_b,okc_articles_all
		WHERE document_type=p_doc_type AND
		document_id=p_doc_id AND
		sav_sae_id=article_id
		ORDER BY scn_id,To_Number(col1),To_Number(col2),To_Number(col3),col4);

Line: 411

		SELECT id,scn_id
		FROM okc_k_articles_b,okc_articles_all
		WHERE document_type=p_doc_type AND
		document_id=p_doc_id AND
		sav_sae_id=article_id
		ORDER BY scn_id,article_number;