1*eeb7e5b3SAdam Hornáček<?xml version="1.0" encoding="UTF-8"?> 2*eeb7e5b3SAdam Hornáček<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" 3*eeb7e5b3SAdam Hornáček "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 4*eeb7e5b3SAdam Hornáček<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" 5*eeb7e5b3SAdam Hornáček class="xref"> 6*eeb7e5b3SAdam Hornáček<head> 7*eeb7e5b3SAdam Hornáček<title>sampleFile - OpenGrok cross reference for /sampleFile</title></head><body> 8*eeb7e5b3SAdam Hornáček<script type="text/javascript">/* <![CDATA[ */ 9*eeb7e5b3SAdam Hornáčekfunction get_sym_list(){return [["Variable","xv",[["ex_invalid_path_format",64],["ex_invalid_rep_event_name",78],["ex_invalid_rep_event_time",73],["ex_invalid_version_no",88],["ex_path_list_is_empty",60],["ex_some_tests_failed",83],["ex_suite_package_not_found",68],["ex_unsupported_rollback_type",56],["gc_after_all",36],["gc_after_each",35],["gc_after_test",34],["gc_before_all",29],["gc_before_each",30],["gc_before_test",31],["gc_date_format",98],["gc_invalid_path_format",65],["gc_invalid_rep_event_name",79],["gc_invalid_rep_event_time",74],["gc_invalid_version_no",89],["gc_max_input_string_length",94],["gc_max_output_string_length",93],["gc_max_storage_varchar2_len",92],["gc_more_data_string",95],["gc_null_string",101],["gc_number_format",97],["gc_overflow_substr_len",96],["gc_path_list_is_empty",61],["gc_rollback_auto",52],["gc_rollback_manual",53],["gc_run",27],["gc_some_tests_failed",84],["gc_suite",28],["gc_suite_package_not_found",69],["gc_test",32],["gc_test_execute",33],["gc_timestamp_format",99],["gc_timestamp_tz_format",100],["gc_unsupported_rollback_type",57],["gc_version",24],["tr_disabled",39],["tr_disabled_char",44],["tr_error",42],["tr_error_char",47],["tr_failure",41],["tr_failure_char",46],["tr_success",40],["tr_success_char",45]]],["Package","xp",[["ut_suite_builder",287],["ut_utils",1]]],["Function","xf",[["build_schema_suites",506],["build_suites",482],["build_suites_hierarchy",439],["create_suite",307],["is_last_annotation_for_proc",332]]]];} /* ]]> */</script><a class="l" name="1" href="#1">1</a><b>create</b> <b>or</b> <a href="/source/s?defs=replace" class="intelliWindow-symbol" data-definition-place="undefined-in-file">replace</a> <a href="/source/s?defs=package" class="intelliWindow-symbol" data-definition-place="undefined-in-file">package</a> <a class="xp" name="ut_utils"/><a href="/source/s?refs=ut_utils" class="xp intelliWindow-symbol" data-definition-place="def">ut_utils</a> <a href="/source/s?defs=authid" class="intelliWindow-symbol" data-definition-place="undefined-in-file">authid</a> <a href="/source/s?defs=definer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">definer</a> <b>is</b> 10*eeb7e5b3SAdam Hornáček<a class="l" name="2" href="#2">2</a> <span class="c">/* 11*eeb7e5b3SAdam Hornáček<a class="l" name="3" href="#3">3</a> utPLSQL - Version 3 12*eeb7e5b3SAdam Hornáček<a class="l" name="4" href="#4">4</a> Copyright 2016 - 2017 utPLSQL Project 13*eeb7e5b3SAdam Hornáček<a class="l" name="5" href="#5">5</a> 14*eeb7e5b3SAdam Hornáček<a class="l" name="6" href="#6">6</a> Licensed under the Apache License, Version 2.0 (the "License"): 15*eeb7e5b3SAdam Hornáček<a class="l" name="7" href="#7">7</a> you may not use this file except in compliance with the License. 16*eeb7e5b3SAdam Hornáček<a class="l" name="8" href="#8">8</a> You may obtain a copy of the License at 17*eeb7e5b3SAdam Hornáček<a class="l" name="9" href="#9">9</a> 18*eeb7e5b3SAdam Hornáček<a class="hl" name="10" href="#10">10</a> <a href="http://www.apache.org/licenses/LICENSE-2.0">http://www.apache.org/licenses/LICENSE-2.0</a> 19*eeb7e5b3SAdam Hornáček<a class="l" name="11" href="#11">11</a> 20*eeb7e5b3SAdam Hornáček<a class="l" name="12" href="#12">12</a> Unless required by applicable law or agreed to in writing, software 21*eeb7e5b3SAdam Hornáček<a class="l" name="13" href="#13">13</a> distributed under the License is distributed on an "AS IS" BASIS, 22*eeb7e5b3SAdam Hornáček<a class="l" name="14" href="#14">14</a> WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 23*eeb7e5b3SAdam Hornáček<a class="l" name="15" href="#15">15</a> See the License for the specific language governing permissions and 24*eeb7e5b3SAdam Hornáček<a class="l" name="16" href="#16">16</a> limitations under the License. 25*eeb7e5b3SAdam Hornáček<a class="l" name="17" href="#17">17</a> */</span> 26*eeb7e5b3SAdam Hornáček<a class="l" name="18" href="#18">18</a> 27*eeb7e5b3SAdam Hornáček<a class="l" name="19" href="#19">19</a> <span class="c">/** 28*eeb7e5b3SAdam Hornáček<a class="hl" name="20" href="#20">20</a> * Common utilities and constants used throughout utPLSQL framework 29*eeb7e5b3SAdam Hornáček<a class="l" name="21" href="#21">21</a> * 30*eeb7e5b3SAdam Hornáček<a class="l" name="22" href="#22">22</a> */</span> 31*eeb7e5b3SAdam Hornáček<a class="l" name="23" href="#23">23</a> 32*eeb7e5b3SAdam Hornáček<a class="l" name="24" href="#24">24</a> <a class="xv" name="gc_version"/><a href="/source/s?refs=gc_version" class="xv intelliWindow-symbol" data-definition-place="def">gc_version</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">50</span>) := <span class="s">'v3.0.4.1461-develop'</span>; 33*eeb7e5b3SAdam Hornáček<a class="l" name="25" href="#25">25</a> 34*eeb7e5b3SAdam Hornáček<a class="l" name="26" href="#26">26</a> <span class="c">/* Constants: Event names */</span> 35*eeb7e5b3SAdam Hornáček<a class="l" name="27" href="#27">27</a> <a class="xv" name="gc_run"/><a href="/source/s?refs=gc_run" class="xv intelliWindow-symbol" data-definition-place="def">gc_run</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'run'</span>; 36*eeb7e5b3SAdam Hornáček<a class="l" name="28" href="#28">28</a> <a class="xv" name="gc_suite"/><a href="/source/s?refs=gc_suite" class="xv intelliWindow-symbol" data-definition-place="def">gc_suite</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'suite'</span>; 37*eeb7e5b3SAdam Hornáček<a class="l" name="29" href="#29">29</a> <a class="xv" name="gc_before_all"/><a href="/source/s?refs=gc_before_all" class="xv intelliWindow-symbol" data-definition-place="def">gc_before_all</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'before_all'</span>; 38*eeb7e5b3SAdam Hornáček<a class="hl" name="30" href="#30">30</a> <a class="xv" name="gc_before_each"/><a href="/source/s?refs=gc_before_each" class="xv intelliWindow-symbol" data-definition-place="def">gc_before_each</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'before_each'</span>; 39*eeb7e5b3SAdam Hornáček<a class="l" name="31" href="#31">31</a> <a class="xv" name="gc_before_test"/><a href="/source/s?refs=gc_before_test" class="xv intelliWindow-symbol" data-definition-place="def">gc_before_test</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'before_test'</span>; 40*eeb7e5b3SAdam Hornáček<a class="l" name="32" href="#32">32</a> <a class="xv" name="gc_test"/><a href="/source/s?refs=gc_test" class="xv intelliWindow-symbol" data-definition-place="def">gc_test</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'test'</span>; 41*eeb7e5b3SAdam Hornáček<a class="l" name="33" href="#33">33</a> <a class="xv" name="gc_test_execute"/><a href="/source/s?refs=gc_test_execute" class="xv intelliWindow-symbol" data-definition-place="def">gc_test_execute</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'test_execute'</span>; 42*eeb7e5b3SAdam Hornáček<a class="l" name="34" href="#34">34</a> <a class="xv" name="gc_after_test"/><a href="/source/s?refs=gc_after_test" class="xv intelliWindow-symbol" data-definition-place="def">gc_after_test</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">10</span>) := <span class="s">'after_test'</span>; 43*eeb7e5b3SAdam Hornáček<a class="l" name="35" href="#35">35</a> <a class="xv" name="gc_after_each"/><a href="/source/s?refs=gc_after_each" class="xv intelliWindow-symbol" data-definition-place="def">gc_after_each</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'after_each'</span>; 44*eeb7e5b3SAdam Hornáček<a class="l" name="36" href="#36">36</a> <a class="xv" name="gc_after_all"/><a href="/source/s?refs=gc_after_all" class="xv intelliWindow-symbol" data-definition-place="def">gc_after_all</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">12</span>) := <span class="s">'after_all'</span>; 45*eeb7e5b3SAdam Hornáček<a class="l" name="37" href="#37">37</a> 46*eeb7e5b3SAdam Hornáček<a class="l" name="38" href="#38">38</a> <span class="c">/* Constants: Test Results */</span> 47*eeb7e5b3SAdam Hornáček<a class="l" name="39" href="#39">39</a> <a class="xv" name="tr_disabled"/><a href="/source/s?refs=tr_disabled" class="xv intelliWindow-symbol" data-definition-place="def">tr_disabled</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>(<span class="n">1</span>) := <span class="n">0</span>; <span class="c">-- test/suite was disabled</span> 48*eeb7e5b3SAdam Hornáček<a class="hl" name="40" href="#40">40</a> <a class="xv" name="tr_success"/><a href="/source/s?refs=tr_success" class="xv intelliWindow-symbol" data-definition-place="def">tr_success</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>(<span class="n">1</span>) := <span class="n">1</span>; <span class="c">-- test passed</span> 49*eeb7e5b3SAdam Hornáček<a class="l" name="41" href="#41">41</a> <a class="xv" name="tr_failure"/><a href="/source/s?refs=tr_failure" class="xv intelliWindow-symbol" data-definition-place="def">tr_failure</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>(<span class="n">1</span>) := <span class="n">2</span>; <span class="c">-- one or more expectations failed</span> 50*eeb7e5b3SAdam Hornáček<a class="l" name="42" href="#42">42</a> <a class="xv" name="tr_error"/><a href="/source/s?refs=tr_error" class="xv intelliWindow-symbol" data-definition-place="def">tr_error</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>(<span class="n">1</span>) := <span class="n">3</span>; <span class="c">-- exception was raised</span> 51*eeb7e5b3SAdam Hornáček<a class="l" name="43" href="#43">43</a> 52*eeb7e5b3SAdam Hornáček<a class="l" name="44" href="#44">44</a> <a class="xv" name="tr_disabled_char"/><a href="/source/s?refs=tr_disabled_char" class="xv intelliWindow-symbol" data-definition-place="def">tr_disabled_char</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">8</span>) := <span class="s">'Disabled'</span>; <span class="c">-- test/suite was disabled</span> 53*eeb7e5b3SAdam Hornáček<a class="l" name="45" href="#45">45</a> <a class="xv" name="tr_success_char"/><a href="/source/s?refs=tr_success_char" class="xv intelliWindow-symbol" data-definition-place="def">tr_success_char</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">7</span>) := <span class="s">'Success'</span>; <span class="c">-- test passed</span> 54*eeb7e5b3SAdam Hornáček<a class="l" name="46" href="#46">46</a> <a class="xv" name="tr_failure_char"/><a href="/source/s?refs=tr_failure_char" class="xv intelliWindow-symbol" data-definition-place="def">tr_failure_char</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">7</span>) := <span class="s">'Failure'</span>; <span class="c">-- one or more expectations failed</span> 55*eeb7e5b3SAdam Hornáček<a class="l" name="47" href="#47">47</a> <a class="xv" name="tr_error_char"/><a href="/source/s?refs=tr_error_char" class="xv intelliWindow-symbol" data-definition-place="def">tr_error_char</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">5</span>) := <span class="s">'Error'</span>; <span class="c">-- exception was raised</span> 56*eeb7e5b3SAdam Hornáček<a class="l" name="48" href="#48">48</a> 57*eeb7e5b3SAdam Hornáček<a class="l" name="49" href="#49">49</a> <span class="c">/* 58*eeb7e5b3SAdam Hornáček<a class="hl" name="50" href="#50">50</a> Constants: Rollback type for ut_test_object 59*eeb7e5b3SAdam Hornáček<a class="l" name="51" href="#51">51</a> */</span> 60*eeb7e5b3SAdam Hornáček<a class="l" name="52" href="#52">52</a> <a class="xv" name="gc_rollback_auto"/><a href="/source/s?refs=gc_rollback_auto" class="xv intelliWindow-symbol" data-definition-place="def">gc_rollback_auto</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>(<span class="n">1</span>) := <span class="n">0</span>; <span class="c">-- rollback after each test and suite</span> 61*eeb7e5b3SAdam Hornáček<a class="l" name="53" href="#53">53</a> <a class="xv" name="gc_rollback_manual"/><a href="/source/s?refs=gc_rollback_manual" class="xv intelliWindow-symbol" data-definition-place="def">gc_rollback_manual</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>(<span class="n">1</span>) := <span class="n">1</span>; <span class="c">-- leave transaction control manual</span> 62*eeb7e5b3SAdam Hornáček<a class="l" name="54" href="#54">54</a> <span class="c">--gc_rollback_on_error constant number(1) := 2; -- rollback tests only on error</span> 63*eeb7e5b3SAdam Hornáček<a class="l" name="55" href="#55">55</a> 64*eeb7e5b3SAdam Hornáček<a class="l" name="56" href="#56">56</a> <a class="xv" name="ex_unsupported_rollback_type"/><a href="/source/s?refs=ex_unsupported_rollback_type" class="xv intelliWindow-symbol" data-definition-place="def">ex_unsupported_rollback_type</a> <a href="/source/s?defs=exception" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception</a>; 65*eeb7e5b3SAdam Hornáček<a class="l" name="57" href="#57">57</a> <a class="xv" name="gc_unsupported_rollback_type"/><a href="/source/s?refs=gc_unsupported_rollback_type" class="xv intelliWindow-symbol" data-definition-place="def">gc_unsupported_rollback_type</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=pls_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pls_integer</a> := <span class="n">-20200</span>; 66*eeb7e5b3SAdam Hornáček<a class="l" name="58" href="#58">58</a> <a href="/source/s?defs=pragma" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pragma</a> <a href="/source/s?defs=exception_init" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception_init</a>(<a class="d intelliWindow-symbol" href="#ex_unsupported_rollback_type" data-definition-place="defined-in-file">ex_unsupported_rollback_type</a>, <span class="n">-20200</span>); 67*eeb7e5b3SAdam Hornáček<a class="l" name="59" href="#59">59</a> 68*eeb7e5b3SAdam Hornáček<a class="hl" name="60" href="#60">60</a> <a class="xv" name="ex_path_list_is_empty"/><a href="/source/s?refs=ex_path_list_is_empty" class="xv intelliWindow-symbol" data-definition-place="def">ex_path_list_is_empty</a> <a href="/source/s?defs=exception" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception</a>; 69*eeb7e5b3SAdam Hornáček<a class="l" name="61" href="#61">61</a> <a class="xv" name="gc_path_list_is_empty"/><a href="/source/s?refs=gc_path_list_is_empty" class="xv intelliWindow-symbol" data-definition-place="def">gc_path_list_is_empty</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=pls_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pls_integer</a> := <span class="n">-20201</span>; 70*eeb7e5b3SAdam Hornáček<a class="l" name="62" href="#62">62</a> <a href="/source/s?defs=pragma" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pragma</a> <a href="/source/s?defs=exception_init" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception_init</a>(<a class="d intelliWindow-symbol" href="#ex_path_list_is_empty" data-definition-place="defined-in-file">ex_path_list_is_empty</a>, <span class="n">-20201</span>); 71*eeb7e5b3SAdam Hornáček<a class="l" name="63" href="#63">63</a> 72*eeb7e5b3SAdam Hornáček<a class="l" name="64" href="#64">64</a> <a class="xv" name="ex_invalid_path_format"/><a href="/source/s?refs=ex_invalid_path_format" class="xv intelliWindow-symbol" data-definition-place="def">ex_invalid_path_format</a> <a href="/source/s?defs=exception" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception</a>; 73*eeb7e5b3SAdam Hornáček<a class="l" name="65" href="#65">65</a> <a class="xv" name="gc_invalid_path_format"/><a href="/source/s?refs=gc_invalid_path_format" class="xv intelliWindow-symbol" data-definition-place="def">gc_invalid_path_format</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=pls_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pls_integer</a> := <span class="n">-20202</span>; 74*eeb7e5b3SAdam Hornáček<a class="l" name="66" href="#66">66</a> <a href="/source/s?defs=pragma" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pragma</a> <a href="/source/s?defs=exception_init" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception_init</a>(<a class="d intelliWindow-symbol" href="#ex_invalid_path_format" data-definition-place="defined-in-file">ex_invalid_path_format</a>, <span class="n">-20202</span>); 75*eeb7e5b3SAdam Hornáček<a class="l" name="67" href="#67">67</a> 76*eeb7e5b3SAdam Hornáček<a class="l" name="68" href="#68">68</a> <a class="xv" name="ex_suite_package_not_found"/><a href="/source/s?refs=ex_suite_package_not_found" class="xv intelliWindow-symbol" data-definition-place="def">ex_suite_package_not_found</a> <a href="/source/s?defs=exception" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception</a>; 77*eeb7e5b3SAdam Hornáček<a class="l" name="69" href="#69">69</a> <a class="xv" name="gc_suite_package_not_found"/><a href="/source/s?refs=gc_suite_package_not_found" class="xv intelliWindow-symbol" data-definition-place="def">gc_suite_package_not_found</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=pls_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pls_integer</a> := <span class="n">-20204</span>; 78*eeb7e5b3SAdam Hornáček<a class="hl" name="70" href="#70">70</a> <a href="/source/s?defs=pragma" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pragma</a> <a href="/source/s?defs=exception_init" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception_init</a>(<a class="d intelliWindow-symbol" href="#ex_suite_package_not_found" data-definition-place="defined-in-file">ex_suite_package_not_found</a>, <span class="n">-20204</span>); 79*eeb7e5b3SAdam Hornáček<a class="l" name="71" href="#71">71</a> 80*eeb7e5b3SAdam Hornáček<a class="l" name="72" href="#72">72</a> <span class="c">-- Reporting event time not supported</span> 81*eeb7e5b3SAdam Hornáček<a class="l" name="73" href="#73">73</a> <a class="xv" name="ex_invalid_rep_event_time"/><a href="/source/s?refs=ex_invalid_rep_event_time" class="xv intelliWindow-symbol" data-definition-place="def">ex_invalid_rep_event_time</a> <a href="/source/s?defs=exception" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception</a>; 82*eeb7e5b3SAdam Hornáček<a class="l" name="74" href="#74">74</a> <a class="xv" name="gc_invalid_rep_event_time"/><a href="/source/s?refs=gc_invalid_rep_event_time" class="xv intelliWindow-symbol" data-definition-place="def">gc_invalid_rep_event_time</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=pls_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pls_integer</a> := <span class="n">-20210</span>; 83*eeb7e5b3SAdam Hornáček<a class="l" name="75" href="#75">75</a> <a href="/source/s?defs=pragma" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pragma</a> <a href="/source/s?defs=exception_init" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception_init</a>(<a class="d intelliWindow-symbol" href="#ex_invalid_rep_event_time" data-definition-place="defined-in-file">ex_invalid_rep_event_time</a>, <span class="n">-20210</span>); 84*eeb7e5b3SAdam Hornáček<a class="l" name="76" href="#76">76</a> 85*eeb7e5b3SAdam Hornáček<a class="l" name="77" href="#77">77</a> <span class="c">-- Reporting event name not supported</span> 86*eeb7e5b3SAdam Hornáček<a class="l" name="78" href="#78">78</a> <a class="xv" name="ex_invalid_rep_event_name"/><a href="/source/s?refs=ex_invalid_rep_event_name" class="xv intelliWindow-symbol" data-definition-place="def">ex_invalid_rep_event_name</a> <a href="/source/s?defs=exception" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception</a>; 87*eeb7e5b3SAdam Hornáček<a class="l" name="79" href="#79">79</a> <a class="xv" name="gc_invalid_rep_event_name"/><a href="/source/s?refs=gc_invalid_rep_event_name" class="xv intelliWindow-symbol" data-definition-place="def">gc_invalid_rep_event_name</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=pls_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pls_integer</a> := <span class="n">-20211</span>; 88*eeb7e5b3SAdam Hornáček<a class="hl" name="80" href="#80">80</a> <a href="/source/s?defs=pragma" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pragma</a> <a href="/source/s?defs=exception_init" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception_init</a>(<a class="d intelliWindow-symbol" href="#ex_invalid_rep_event_name" data-definition-place="defined-in-file">ex_invalid_rep_event_name</a>, <span class="n">-20211</span>); 89*eeb7e5b3SAdam Hornáček<a class="l" name="81" href="#81">81</a> 90*eeb7e5b3SAdam Hornáček<a class="l" name="82" href="#82">82</a> <span class="c">-- Any of tests failed</span> 91*eeb7e5b3SAdam Hornáček<a class="l" name="83" href="#83">83</a> <a class="xv" name="ex_some_tests_failed"/><a href="/source/s?refs=ex_some_tests_failed" class="xv intelliWindow-symbol" data-definition-place="def">ex_some_tests_failed</a> <a href="/source/s?defs=exception" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception</a>; 92*eeb7e5b3SAdam Hornáček<a class="l" name="84" href="#84">84</a> <a class="xv" name="gc_some_tests_failed"/><a href="/source/s?refs=gc_some_tests_failed" class="xv intelliWindow-symbol" data-definition-place="def">gc_some_tests_failed</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=pls_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pls_integer</a> := <span class="n">-20213</span>; 93*eeb7e5b3SAdam Hornáček<a class="l" name="85" href="#85">85</a> <a href="/source/s?defs=pragma" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pragma</a> <a href="/source/s?defs=exception_init" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception_init</a>(<a class="d intelliWindow-symbol" href="#ex_some_tests_failed" data-definition-place="defined-in-file">ex_some_tests_failed</a>, <span class="n">-20213</span>); 94*eeb7e5b3SAdam Hornáček<a class="l" name="86" href="#86">86</a> 95*eeb7e5b3SAdam Hornáček<a class="l" name="87" href="#87">87</a> <span class="c">-- Any of tests failed</span> 96*eeb7e5b3SAdam Hornáček<a class="l" name="88" href="#88">88</a> <a class="xv" name="ex_invalid_version_no"/><a href="/source/s?refs=ex_invalid_version_no" class="xv intelliWindow-symbol" data-definition-place="def">ex_invalid_version_no</a> <a href="/source/s?defs=exception" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception</a>; 97*eeb7e5b3SAdam Hornáček<a class="l" name="89" href="#89">89</a> <a class="xv" name="gc_invalid_version_no"/><a href="/source/s?refs=gc_invalid_version_no" class="xv intelliWindow-symbol" data-definition-place="def">gc_invalid_version_no</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=pls_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pls_integer</a> := <span class="n">-20214</span>; 98*eeb7e5b3SAdam Hornáček<a class="hl" name="90" href="#90">90</a> <a href="/source/s?defs=pragma" class="intelliWindow-symbol" data-definition-place="undefined-in-file">pragma</a> <a href="/source/s?defs=exception_init" class="intelliWindow-symbol" data-definition-place="undefined-in-file">exception_init</a>(<a class="d intelliWindow-symbol" href="#ex_invalid_version_no" data-definition-place="defined-in-file">ex_invalid_version_no</a>, <span class="n">-20214</span>); 99*eeb7e5b3SAdam Hornáček<a class="l" name="91" href="#91">91</a> 100*eeb7e5b3SAdam Hornáček<a class="l" name="92" href="#92">92</a> <a class="xv" name="gc_max_storage_varchar2_len"/><a href="/source/s?refs=gc_max_storage_varchar2_len" class="xv intelliWindow-symbol" data-definition-place="def">gc_max_storage_varchar2_len</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <b>integer</b> := <span class="n">4000</span>; 101*eeb7e5b3SAdam Hornáček<a class="l" name="93" href="#93">93</a> <a class="xv" name="gc_max_output_string_length"/><a href="/source/s?refs=gc_max_output_string_length" class="xv intelliWindow-symbol" data-definition-place="def">gc_max_output_string_length</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <b>integer</b> := <span class="n">4000</span>; 102*eeb7e5b3SAdam Hornáček<a class="l" name="94" href="#94">94</a> <a class="xv" name="gc_max_input_string_length"/><a href="/source/s?refs=gc_max_input_string_length" class="xv intelliWindow-symbol" data-definition-place="def">gc_max_input_string_length</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <b>integer</b> := <a class="d intelliWindow-symbol" href="#gc_max_output_string_length" data-definition-place="defined-in-file">gc_max_output_string_length</a> - <span class="n">2</span>; <span class="c">--we need to remove 2 chars for quotes around string</span> 103*eeb7e5b3SAdam Hornáček<a class="l" name="95" href="#95">95</a> <a class="xv" name="gc_more_data_string"/><a href="/source/s?refs=gc_more_data_string" class="xv intelliWindow-symbol" data-definition-place="def">gc_more_data_string</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">5</span>) := <span class="s">'[...]'</span>; 104*eeb7e5b3SAdam Hornáček<a class="l" name="96" href="#96">96</a> <a class="xv" name="gc_overflow_substr_len"/><a href="/source/s?refs=gc_overflow_substr_len" class="xv intelliWindow-symbol" data-definition-place="def">gc_overflow_substr_len</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <b>integer</b> := <a class="d intelliWindow-symbol" href="#gc_max_input_string_length" data-definition-place="defined-in-file">gc_max_input_string_length</a> - <a href="/source/s?defs=length" class="intelliWindow-symbol" data-definition-place="undefined-in-file">length</a>(<a class="d intelliWindow-symbol" href="#gc_more_data_string" data-definition-place="defined-in-file">gc_more_data_string</a>); 105*eeb7e5b3SAdam Hornáček<a class="l" name="97" href="#97">97</a> <a class="xv" name="gc_number_format"/><a href="/source/s?refs=gc_number_format" class="xv intelliWindow-symbol" data-definition-place="def">gc_number_format</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">100</span>) := <span class="s">'TM9'</span>; 106*eeb7e5b3SAdam Hornáček<a class="l" name="98" href="#98">98</a> <a class="xv" name="gc_date_format"/><a href="/source/s?refs=gc_date_format" class="xv intelliWindow-symbol" data-definition-place="def">gc_date_format</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">100</span>) := <span class="s">'yyyy-mm-dd"T"hh24:mi:ss'</span>; 107*eeb7e5b3SAdam Hornáček<a class="l" name="99" href="#99">99</a> <a class="xv" name="gc_timestamp_format"/><a href="/source/s?refs=gc_timestamp_format" class="xv intelliWindow-symbol" data-definition-place="def">gc_timestamp_format</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">100</span>) := <span class="s">'yyyy-mm-dd"T"hh24:mi:ssxff'</span>; 108*eeb7e5b3SAdam Hornáček<a class="hl" name="100" href="#100">100</a> <a class="xv" name="gc_timestamp_tz_format"/><a href="/source/s?refs=gc_timestamp_tz_format" class="xv intelliWindow-symbol" data-definition-place="def">gc_timestamp_tz_format</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">100</span>) := <span class="s">'yyyy-mm-dd"T"hh24:mi:ssxff tzh:tzm'</span>; 109*eeb7e5b3SAdam Hornáček<a class="l" name="101" href="#101">101</a> <a class="xv" name="gc_null_string"/><a href="/source/s?refs=gc_null_string" class="xv intelliWindow-symbol" data-definition-place="def">gc_null_string</a> <a href="/source/s?defs=constant" class="intelliWindow-symbol" data-definition-place="undefined-in-file">constant</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">4</span>) := <span class="s">'NULL'</span>; 110*eeb7e5b3SAdam Hornáček<a class="l" name="102" href="#102">102</a> 111*eeb7e5b3SAdam Hornáček<a class="l" name="103" href="#103">103</a> <a href="/source/s?defs=type" class="intelliWindow-symbol" data-definition-place="undefined-in-file">type</a> <a href="/source/s?defs=t_version" class="intelliWindow-symbol" data-definition-place="undefined-in-file">t_version</a> <b>is</b> <a href="/source/s?defs=record" class="intelliWindow-symbol" data-definition-place="undefined-in-file">record</a>( 112*eeb7e5b3SAdam Hornáček<a class="l" name="104" href="#104">104</a> <a class="xfld" name="major"/><a href="/source/s?refs=major" class="xfld intelliWindow-symbol" data-definition-place="def">major</a> <b>natural</b>, 113*eeb7e5b3SAdam Hornáček<a class="l" name="105" href="#105">105</a> <a class="xfld" name="minor"/><a href="/source/s?refs=minor" class="xfld intelliWindow-symbol" data-definition-place="def">minor</a> <b>natural</b>, 114*eeb7e5b3SAdam Hornáček<a class="l" name="106" href="#106">106</a> <a class="xfld" name="bugfix"/><a href="/source/s?refs=bugfix" class="xfld intelliWindow-symbol" data-definition-place="def">bugfix</a> <b>natural</b>, 115*eeb7e5b3SAdam Hornáček<a class="l" name="107" href="#107">107</a> <a class="xfld" name="build"/><a href="/source/s?refs=build" class="xfld intelliWindow-symbol" data-definition-place="def">build</a> <b>natural</b> 116*eeb7e5b3SAdam Hornáček<a class="l" name="108" href="#108">108</a> ); 117*eeb7e5b3SAdam Hornáček<a class="l" name="109" href="#109">109</a> 118*eeb7e5b3SAdam Hornáček<a class="hl" name="110" href="#110">110</a> 119*eeb7e5b3SAdam Hornáček<a class="l" name="111" href="#111">111</a> <span class="c">/** 120*eeb7e5b3SAdam Hornáček<a class="l" name="112" href="#112">112</a> * Converts test results into strings 121*eeb7e5b3SAdam Hornáček<a class="l" name="113" href="#113">113</a> * 122*eeb7e5b3SAdam Hornáček<a class="l" name="114" href="#114">114</a> * @param a_test_result numeric representation of test result 123*eeb7e5b3SAdam Hornáček<a class="l" name="115" href="#115">115</a> * 124*eeb7e5b3SAdam Hornáček<a class="l" name="116" href="#116">116</a> * @return a string representation of a test_result. 125*eeb7e5b3SAdam Hornáček<a class="l" name="117" href="#117">117</a> */</span> 126*eeb7e5b3SAdam Hornáček<a class="l" name="118" href="#118">118</a> <b>function</b> <a href="/source/s?defs=test_result_to_char" class="intelliWindow-symbol" data-definition-place="undefined-in-file">test_result_to_char</a>(<a href="/source/s?defs=a_test_result" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_test_result</a> <b>integer</b>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 127*eeb7e5b3SAdam Hornáček<a class="l" name="119" href="#119">119</a> 128*eeb7e5b3SAdam Hornáček<a class="hl" name="120" href="#120">120</a> <b>function</b> <a href="/source/s?defs=to_test_result" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_test_result</a>(<a href="/source/s?defs=a_test" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_test</a> <b>boolean</b>) <b>return</b> <b>integer</b>; 129*eeb7e5b3SAdam Hornáček<a class="l" name="121" href="#121">121</a> 130*eeb7e5b3SAdam Hornáček<a class="l" name="122" href="#122">122</a> <span class="c">/** 131*eeb7e5b3SAdam Hornáček<a class="l" name="123" href="#123">123</a> * Generates a unique name for a savepoint 132*eeb7e5b3SAdam Hornáček<a class="l" name="124" href="#124">124</a> * Uses sys_guid, as timestamp gives only miliseconds on Windows and is not unique 133*eeb7e5b3SAdam Hornáček<a class="l" name="125" href="#125">125</a> * Issue: #506 for details on the implementation approach 134*eeb7e5b3SAdam Hornáček<a class="l" name="126" href="#126">126</a> */</span> 135*eeb7e5b3SAdam Hornáček<a class="l" name="127" href="#127">127</a> <b>function</b> <a href="/source/s?defs=gen_savepoint_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">gen_savepoint_name</a> <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 136*eeb7e5b3SAdam Hornáček<a class="l" name="128" href="#128">128</a> 137*eeb7e5b3SAdam Hornáček<a class="l" name="129" href="#129">129</a> <b>procedure</b> <a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<a href="/source/s?defs=a_message" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_message</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>); 138*eeb7e5b3SAdam Hornáček<a class="hl" name="130" href="#130">130</a> 139*eeb7e5b3SAdam Hornáček<a class="l" name="131" href="#131">131</a> <b>procedure</b> <a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<a href="/source/s?defs=a_message" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_message</a> <b>clob</b>); 140*eeb7e5b3SAdam Hornáček<a class="l" name="132" href="#132">132</a> 141*eeb7e5b3SAdam Hornáček<a class="l" name="133" href="#133">133</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>, <a href="/source/s?defs=a_qoute_char" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_qoute_char</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a> := <span class="s">''''</span>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 142*eeb7e5b3SAdam Hornáček<a class="l" name="134" href="#134">134</a> 143*eeb7e5b3SAdam Hornáček<a class="l" name="135" href="#135">135</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <b>clob</b>, <a href="/source/s?defs=a_qoute_char" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_qoute_char</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a> := <span class="s">''''</span>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 144*eeb7e5b3SAdam Hornáček<a class="l" name="136" href="#136">136</a> 145*eeb7e5b3SAdam Hornáček<a class="l" name="137" href="#137">137</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <b>blob</b>, <a href="/source/s?defs=a_qoute_char" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_qoute_char</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a> := <span class="s">''''</span>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 146*eeb7e5b3SAdam Hornáček<a class="l" name="138" href="#138">138</a> 147*eeb7e5b3SAdam Hornáček<a class="l" name="139" href="#139">139</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <b>boolean</b>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 148*eeb7e5b3SAdam Hornáček<a class="hl" name="140" href="#140">140</a> 149*eeb7e5b3SAdam Hornáček<a class="l" name="141" href="#141">141</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 150*eeb7e5b3SAdam Hornáček<a class="l" name="142" href="#142">142</a> 151*eeb7e5b3SAdam Hornáček<a class="l" name="143" href="#143">143</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <b>date</b>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 152*eeb7e5b3SAdam Hornáček<a class="l" name="144" href="#144">144</a> 153*eeb7e5b3SAdam Hornáček<a class="l" name="145" href="#145">145</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <a href="/source/s?defs=timestamp_unconstrained" class="intelliWindow-symbol" data-definition-place="undefined-in-file">timestamp_unconstrained</a>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 154*eeb7e5b3SAdam Hornáček<a class="l" name="146" href="#146">146</a> 155*eeb7e5b3SAdam Hornáček<a class="l" name="147" href="#147">147</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <a href="/source/s?defs=timestamp_tz_unconstrained" class="intelliWindow-symbol" data-definition-place="undefined-in-file">timestamp_tz_unconstrained</a>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 156*eeb7e5b3SAdam Hornáček<a class="l" name="148" href="#148">148</a> 157*eeb7e5b3SAdam Hornáček<a class="l" name="149" href="#149">149</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <a href="/source/s?defs=timestamp_ltz_unconstrained" class="intelliWindow-symbol" data-definition-place="undefined-in-file">timestamp_ltz_unconstrained</a>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 158*eeb7e5b3SAdam Hornáček<a class="hl" name="150" href="#150">150</a> 159*eeb7e5b3SAdam Hornáček<a class="l" name="151" href="#151">151</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <a href="/source/s?defs=yminterval_unconstrained" class="intelliWindow-symbol" data-definition-place="undefined-in-file">yminterval_unconstrained</a>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 160*eeb7e5b3SAdam Hornáček<a class="l" name="152" href="#152">152</a> 161*eeb7e5b3SAdam Hornáček<a class="l" name="153" href="#153">153</a> <b>function</b> <a href="/source/s?defs=to_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_string</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <a href="/source/s?defs=dsinterval_unconstrained" class="intelliWindow-symbol" data-definition-place="undefined-in-file">dsinterval_unconstrained</a>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 162*eeb7e5b3SAdam Hornáček<a class="l" name="154" href="#154">154</a> 163*eeb7e5b3SAdam Hornáček<a class="l" name="155" href="#155">155</a> <b>function</b> <a href="/source/s?defs=boolean_to_int" class="intelliWindow-symbol" data-definition-place="undefined-in-file">boolean_to_int</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <b>boolean</b>) <b>return</b> <b>integer</b>; 164*eeb7e5b3SAdam Hornáček<a class="l" name="156" href="#156">156</a> 165*eeb7e5b3SAdam Hornáček<a class="l" name="157" href="#157">157</a> <b>function</b> <a href="/source/s?defs=int_to_boolean" class="intelliWindow-symbol" data-definition-place="undefined-in-file">int_to_boolean</a>(<a href="/source/s?defs=a_value" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_value</a> <b>integer</b>) <b>return</b> <b>boolean</b>; 166*eeb7e5b3SAdam Hornáček<a class="l" name="158" href="#158">158</a> 167*eeb7e5b3SAdam Hornáček<a class="l" name="159" href="#159">159</a> <span class="c">/** 168*eeb7e5b3SAdam Hornáček<a class="hl" name="160" href="#160">160</a> * Validates passed value against supported rollback types 169*eeb7e5b3SAdam Hornáček<a class="l" name="161" href="#161">161</a> */</span> 170*eeb7e5b3SAdam Hornáček<a class="l" name="162" href="#162">162</a> <b>procedure</b> <a href="/source/s?defs=validate_rollback_type" class="intelliWindow-symbol" data-definition-place="undefined-in-file">validate_rollback_type</a>(<a href="/source/s?defs=a_rollback_type" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_rollback_type</a> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>); 171*eeb7e5b3SAdam Hornáček<a class="l" name="163" href="#163">163</a> 172*eeb7e5b3SAdam Hornáček<a class="l" name="164" href="#164">164</a> 173*eeb7e5b3SAdam Hornáček<a class="l" name="165" href="#165">165</a> <span class="c">/** 174*eeb7e5b3SAdam Hornáček<a class="l" name="166" href="#166">166</a> * 175*eeb7e5b3SAdam Hornáček<a class="l" name="167" href="#167">167</a> * Splits a given string into table of string by delimiter. 176*eeb7e5b3SAdam Hornáček<a class="l" name="168" href="#168">168</a> * The delimiter gets removed. 177*eeb7e5b3SAdam Hornáček<a class="l" name="169" href="#169">169</a> * If null passed as any of the parameters, empty table is returned. 178*eeb7e5b3SAdam Hornáček<a class="hl" name="170" href="#170">170</a> * If no occurence of a_delimiter found in a_text then text is returned as a single row of the table. 179*eeb7e5b3SAdam Hornáček<a class="l" name="171" href="#171">171</a> * If no text between delimiters found then an empty row is returned, example: 180*eeb7e5b3SAdam Hornáček<a class="l" name="172" href="#172">172</a> * string_to_table( 'a,,b', ',' ) gives table ut_varchar2_list( 'a', null, 'b' ); 181*eeb7e5b3SAdam Hornáček<a class="l" name="173" href="#173">173</a> * 182*eeb7e5b3SAdam Hornáček<a class="l" name="174" href="#174">174</a> * @param a_string the text to be split. 183*eeb7e5b3SAdam Hornáček<a class="l" name="175" href="#175">175</a> * @param a_delimiter the delimiter character or string 184*eeb7e5b3SAdam Hornáček<a class="l" name="176" href="#176">176</a> * @param a_skip_leading_delimiter determines if the leading delimiter should be ignored, used by clob_to_table 185*eeb7e5b3SAdam Hornáček<a class="l" name="177" href="#177">177</a> * 186*eeb7e5b3SAdam Hornáček<a class="l" name="178" href="#178">178</a> * @return table of varchar2 values 187*eeb7e5b3SAdam Hornáček<a class="l" name="179" href="#179">179</a> */</span> 188*eeb7e5b3SAdam Hornáček<a class="hl" name="180" href="#180">180</a> <b>function</b> <a href="/source/s?defs=string_to_table" class="intelliWindow-symbol" data-definition-place="undefined-in-file">string_to_table</a>(<a href="/source/s?defs=a_string" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_string</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>, <a href="/source/s?defs=a_delimiter" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_delimiter</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>:= <a href="/source/s?defs=chr" class="intelliWindow-symbol" data-definition-place="undefined-in-file">chr</a>(<span class="n">10</span>), <a href="/source/s?defs=a_skip_leading_delimiter" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_skip_leading_delimiter</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a> := <span class="s">'N'</span>) <b>return</b> <a href="/source/s?defs=ut_varchar2_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_varchar2_list</a>; 189*eeb7e5b3SAdam Hornáček<a class="l" name="181" href="#181">181</a> 190*eeb7e5b3SAdam Hornáček<a class="l" name="182" href="#182">182</a> <span class="c">/** 191*eeb7e5b3SAdam Hornáček<a class="l" name="183" href="#183">183</a> * Splits a given string into table of string by delimiter. 192*eeb7e5b3SAdam Hornáček<a class="l" name="184" href="#184">184</a> * Default value of a_max_amount is 8191 because of code can contains multibyte character. 193*eeb7e5b3SAdam Hornáček<a class="l" name="185" href="#185">185</a> * The delimiter gets removed. 194*eeb7e5b3SAdam Hornáček<a class="l" name="186" href="#186">186</a> * If null passed as any of the parameters, empty table is returned. 195*eeb7e5b3SAdam Hornáček<a class="l" name="187" href="#187">187</a> * If split text is longer than a_max_amount it gets split into pieces of a_max_amount. 196*eeb7e5b3SAdam Hornáček<a class="l" name="188" href="#188">188</a> * If no text between delimiters found then an empty row is returned, example: 197*eeb7e5b3SAdam Hornáček<a class="l" name="189" href="#189">189</a> * string_to_table( 'a,,b', ',' ) gives table ut_varchar2_list( 'a', null, 'b' ); 198*eeb7e5b3SAdam Hornáček<a class="hl" name="190" href="#190">190</a> * 199*eeb7e5b3SAdam Hornáček<a class="l" name="191" href="#191">191</a> * @param a_clob the text to be split. 200*eeb7e5b3SAdam Hornáček<a class="l" name="192" href="#192">192</a> * @param a_delimiter the delimiter character or string (default chr(10) ) 201*eeb7e5b3SAdam Hornáček<a class="l" name="193" href="#193">193</a> * @param a_max_amount the maximum length of returned string (default 8191) 202*eeb7e5b3SAdam Hornáček<a class="l" name="194" href="#194">194</a> * @return table of varchar2 values 203*eeb7e5b3SAdam Hornáček<a class="l" name="195" href="#195">195</a> */</span> 204*eeb7e5b3SAdam Hornáček<a class="l" name="196" href="#196">196</a> <b>function</b> <a href="/source/s?defs=clob_to_table" class="intelliWindow-symbol" data-definition-place="undefined-in-file">clob_to_table</a>(<a href="/source/s?defs=a_clob" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_clob</a> <b>clob</b>, <a href="/source/s?defs=a_max_amount" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_max_amount</a> <b>integer</b> := <span class="n">8191</span>, <a href="/source/s?defs=a_delimiter" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_delimiter</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>:= <a href="/source/s?defs=chr" class="intelliWindow-symbol" data-definition-place="undefined-in-file">chr</a>(<span class="n">10</span>)) <b>return</b> <a href="/source/s?defs=ut_varchar2_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_varchar2_list</a>; 205*eeb7e5b3SAdam Hornáček<a class="l" name="197" href="#197">197</a> 206*eeb7e5b3SAdam Hornáček<a class="l" name="198" href="#198">198</a> <b>function</b> <a href="/source/s?defs=table_to_clob" class="intelliWindow-symbol" data-definition-place="undefined-in-file">table_to_clob</a>(<a href="/source/s?defs=a_text_table" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_text_table</a> <a href="/source/s?defs=ut_varchar2_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_varchar2_list</a>, <a href="/source/s?defs=a_delimiter" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_delimiter</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>:= <a href="/source/s?defs=chr" class="intelliWindow-symbol" data-definition-place="undefined-in-file">chr</a>(<span class="n">10</span>)) <b>return</b> <b>clob</b>; 207*eeb7e5b3SAdam Hornáček<a class="l" name="199" href="#199">199</a> 208*eeb7e5b3SAdam Hornáček<a class="hl" name="200" href="#200">200</a> <span class="c">/** 209*eeb7e5b3SAdam Hornáček<a class="l" name="201" href="#201">201</a> * Returns time difference in seconds (with miliseconds) between given timestamps 210*eeb7e5b3SAdam Hornáček<a class="l" name="202" href="#202">202</a> */</span> 211*eeb7e5b3SAdam Hornáček<a class="l" name="203" href="#203">203</a> <b>function</b> <a href="/source/s?defs=time_diff" class="intelliWindow-symbol" data-definition-place="undefined-in-file">time_diff</a>(<a href="/source/s?defs=a_start_time" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_start_time</a> <b>timestamp</b> <b>with</b> <b>time</b> <a href="/source/s?defs=zone" class="intelliWindow-symbol" data-definition-place="undefined-in-file">zone</a>, <a href="/source/s?defs=a_end_time" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_end_time</a> <b>timestamp</b> <b>with</b> <b>time</b> <a href="/source/s?defs=zone" class="intelliWindow-symbol" data-definition-place="undefined-in-file">zone</a>) <b>return</b> <a href="/source/s?defs=number" class="intelliWindow-symbol" data-definition-place="undefined-in-file">number</a>; 212*eeb7e5b3SAdam Hornáček<a class="l" name="204" href="#204">204</a> 213*eeb7e5b3SAdam Hornáček<a class="l" name="205" href="#205">205</a> <span class="c">/** 214*eeb7e5b3SAdam Hornáček<a class="l" name="206" href="#206">206</a> * Returns a text indented with spaces except the first line. 215*eeb7e5b3SAdam Hornáček<a class="l" name="207" href="#207">207</a> */</span> 216*eeb7e5b3SAdam Hornáček<a class="l" name="208" href="#208">208</a> <b>function</b> <a href="/source/s?defs=indent_lines" class="intelliWindow-symbol" data-definition-place="undefined-in-file">indent_lines</a>(<a href="/source/s?defs=a_text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_text</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>, <a href="/source/s?defs=a_indent_size" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_indent_size</a> <b>integer</b> := <span class="n">4</span>, <a href="/source/s?defs=a_include_first_line" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_include_first_line</a> <b>boolean</b> := <b>false</b>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 217*eeb7e5b3SAdam Hornáček<a class="l" name="209" href="#209">209</a> 218*eeb7e5b3SAdam Hornáček<a class="hl" name="210" href="#210">210</a> 219*eeb7e5b3SAdam Hornáček<a class="l" name="211" href="#211">211</a> <span class="c">/** 220*eeb7e5b3SAdam Hornáček<a class="l" name="212" href="#212">212</a> * Returns a list of object that are part of utPLSQL framework 221*eeb7e5b3SAdam Hornáček<a class="l" name="213" href="#213">213</a> */</span> 222*eeb7e5b3SAdam Hornáček<a class="l" name="214" href="#214">214</a> <b>function</b> <a href="/source/s?defs=get_utplsql_objects_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">get_utplsql_objects_list</a> <b>return</b> <a href="/source/s?defs=ut_object_names" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_object_names</a>; 223*eeb7e5b3SAdam Hornáček<a class="l" name="215" href="#215">215</a> 224*eeb7e5b3SAdam Hornáček<a class="l" name="216" href="#216">216</a> <span class="c">/** 225*eeb7e5b3SAdam Hornáček<a class="l" name="217" href="#217">217</a> * Append a line to the end of ut_varchar2_lst 226*eeb7e5b3SAdam Hornáček<a class="l" name="218" href="#218">218</a> */</span> 227*eeb7e5b3SAdam Hornáček<a class="l" name="219" href="#219">219</a> <b>procedure</b> <a href="/source/s?defs=append_to_varchar2_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">append_to_varchar2_list</a>(<a href="/source/s?defs=a_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_list</a> <b>in</b> <b>out</b> <a href="/source/s?defs=nocopy" class="intelliWindow-symbol" data-definition-place="undefined-in-file">nocopy</a> <a href="/source/s?defs=ut_varchar2_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_varchar2_list</a>, <a href="/source/s?defs=a_line" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_line</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>); 228*eeb7e5b3SAdam Hornáček<a class="hl" name="220" href="#220">220</a> 229*eeb7e5b3SAdam Hornáček<a class="l" name="221" href="#221">221</a> <b>procedure</b> <a href="/source/s?defs=append_to_clob" class="intelliWindow-symbol" data-definition-place="undefined-in-file">append_to_clob</a>(<a href="/source/s?defs=a_src_clob" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_src_clob</a> <b>in</b> <b>out</b> <a href="/source/s?defs=nocopy" class="intelliWindow-symbol" data-definition-place="undefined-in-file">nocopy</a> <b>clob</b>, <a href="/source/s?defs=a_new_data" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_new_data</a> <b>clob</b>); 230*eeb7e5b3SAdam Hornáček<a class="l" name="222" href="#222">222</a> <b>procedure</b> <a href="/source/s?defs=append_to_clob" class="intelliWindow-symbol" data-definition-place="undefined-in-file">append_to_clob</a>(<a href="/source/s?defs=a_src_clob" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_src_clob</a> <b>in</b> <b>out</b> <a href="/source/s?defs=nocopy" class="intelliWindow-symbol" data-definition-place="undefined-in-file">nocopy</a> <b>clob</b>, <a href="/source/s?defs=a_new_data" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_new_data</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>); 231*eeb7e5b3SAdam Hornáček<a class="l" name="223" href="#223">223</a> 232*eeb7e5b3SAdam Hornáček<a class="l" name="224" href="#224">224</a> <b>function</b> <a href="/source/s?defs=convert_collection" class="intelliWindow-symbol" data-definition-place="undefined-in-file">convert_collection</a>(<a href="/source/s?defs=a_collection" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_collection</a> <a href="/source/s?defs=ut_varchar2_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_varchar2_list</a>) <b>return</b> <a href="/source/s?defs=ut_varchar2_rows" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_varchar2_rows</a>; 233*eeb7e5b3SAdam Hornáček<a class="l" name="225" href="#225">225</a> 234*eeb7e5b3SAdam Hornáček<a class="l" name="226" href="#226">226</a> <span class="c">/** 235*eeb7e5b3SAdam Hornáček<a class="l" name="227" href="#227">227</a> * Set session's action and module using dbms_application_info 236*eeb7e5b3SAdam Hornáček<a class="l" name="228" href="#228">228</a> */</span> 237*eeb7e5b3SAdam Hornáček<a class="l" name="229" href="#229">229</a> <b>procedure</b> <a href="/source/s?defs=set_action" class="intelliWindow-symbol" data-definition-place="undefined-in-file">set_action</a>(<a href="/source/s?defs=a_text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_text</a> <b>in</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>); 238*eeb7e5b3SAdam Hornáček<a class="hl" name="230" href="#230">230</a> 239*eeb7e5b3SAdam Hornáček<a class="l" name="231" href="#231">231</a> <span class="c">/** 240*eeb7e5b3SAdam Hornáček<a class="l" name="232" href="#232">232</a> * Set session's client info using dbms_application_info 241*eeb7e5b3SAdam Hornáček<a class="l" name="233" href="#233">233</a> */</span> 242*eeb7e5b3SAdam Hornáček<a class="l" name="234" href="#234">234</a> <b>procedure</b> <a href="/source/s?defs=set_client_info" class="intelliWindow-symbol" data-definition-place="undefined-in-file">set_client_info</a>(<a href="/source/s?defs=a_text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_text</a> <b>in</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>); 243*eeb7e5b3SAdam Hornáček<a class="l" name="235" href="#235">235</a> 244*eeb7e5b3SAdam Hornáček<a class="l" name="236" href="#236">236</a> <b>function</b> <a href="/source/s?defs=to_xpath" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_xpath</a>(<a href="/source/s?defs=a_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_list</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>, <a href="/source/s?defs=a_ancestors" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_ancestors</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a> := <span class="s">'/*/'</span>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 245*eeb7e5b3SAdam Hornáček<a class="l" name="237" href="#237">237</a> 246*eeb7e5b3SAdam Hornáček<a class="l" name="238" href="#238">238</a> <b>function</b> <a href="/source/s?defs=to_xpath" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_xpath</a>(<a href="/source/s?defs=a_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_list</a> <a href="/source/s?defs=ut_varchar2_list" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_varchar2_list</a>, <a href="/source/s?defs=a_ancestors" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_ancestors</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a> := <span class="s">'/*/'</span>) <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 247*eeb7e5b3SAdam Hornáček<a class="l" name="239" href="#239">239</a> 248*eeb7e5b3SAdam Hornáček<a class="hl" name="240" href="#240">240</a> <b>procedure</b> <a href="/source/s?defs=cleanup_temp_tables" class="intelliWindow-symbol" data-definition-place="undefined-in-file">cleanup_temp_tables</a>; 249*eeb7e5b3SAdam Hornáček<a class="l" name="241" href="#241">241</a> 250*eeb7e5b3SAdam Hornáček<a class="l" name="242" href="#242">242</a> <span class="c">/** 251*eeb7e5b3SAdam Hornáček<a class="l" name="243" href="#243">243</a> * Converts version string into version record 252*eeb7e5b3SAdam Hornáček<a class="l" name="244" href="#244">244</a> * 253*eeb7e5b3SAdam Hornáček<a class="l" name="245" href="#245">245</a> * @param a_version_no string representation of version in format vX.X.X.X where X is a positive integer 254*eeb7e5b3SAdam Hornáček<a class="l" name="246" href="#246">246</a> * @return t_version record with up to four positive numbers containing version 255*eeb7e5b3SAdam Hornáček<a class="l" name="247" href="#247">247</a> * @throws 20214 if passed version string is not matching version pattern 256*eeb7e5b3SAdam Hornáček<a class="l" name="248" href="#248">248</a> */</span> 257*eeb7e5b3SAdam Hornáček<a class="l" name="249" href="#249">249</a> <b>function</b> <a href="/source/s?defs=to_version" class="intelliWindow-symbol" data-definition-place="undefined-in-file">to_version</a>(<a href="/source/s?defs=a_version_no" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_version_no</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>) <b>return</b> <a href="/source/s?defs=t_version" class="intelliWindow-symbol" data-definition-place="undefined-in-file">t_version</a>; 258*eeb7e5b3SAdam Hornáček<a class="hl" name="250" href="#250">250</a> 259*eeb7e5b3SAdam Hornáček<a class="l" name="251" href="#251">251</a> 260*eeb7e5b3SAdam Hornáček<a class="l" name="252" href="#252">252</a> <span class="c">/** 261*eeb7e5b3SAdam Hornáček<a class="l" name="253" href="#253">253</a> * Saves data from dbms_output buffer into a global temporary table (cache) 262*eeb7e5b3SAdam Hornáček<a class="l" name="254" href="#254">254</a> * used to store dbms_output buffer captured before the run 263*eeb7e5b3SAdam Hornáček<a class="l" name="255" href="#255">255</a> * 264*eeb7e5b3SAdam Hornáček<a class="l" name="256" href="#256">256</a> */</span> 265*eeb7e5b3SAdam Hornáček<a class="l" name="257" href="#257">257</a> <b>procedure</b> <a href="/source/s?defs=save_dbms_output_to_cache" class="intelliWindow-symbol" data-definition-place="undefined-in-file">save_dbms_output_to_cache</a>; 266*eeb7e5b3SAdam Hornáček<a class="l" name="258" href="#258">258</a> 267*eeb7e5b3SAdam Hornáček<a class="l" name="259" href="#259">259</a> <span class="c">/** 268*eeb7e5b3SAdam Hornáček<a class="hl" name="260" href="#260">260</a> * Reads data from global temporary table (cache) abd puts it back into dbms_output 269*eeb7e5b3SAdam Hornáček<a class="l" name="261" href="#261">261</a> * used to recover dbms_output buffer data after a run is complete 270*eeb7e5b3SAdam Hornáček<a class="l" name="262" href="#262">262</a> * 271*eeb7e5b3SAdam Hornáček<a class="l" name="263" href="#263">263</a> */</span> 272*eeb7e5b3SAdam Hornáček<a class="l" name="264" href="#264">264</a> <b>procedure</b> <a href="/source/s?defs=read_cache_to_dbms_output" class="intelliWindow-symbol" data-definition-place="undefined-in-file">read_cache_to_dbms_output</a>; 273*eeb7e5b3SAdam Hornáček<a class="l" name="265" href="#265">265</a> 274*eeb7e5b3SAdam Hornáček<a class="l" name="266" href="#266">266</a> 275*eeb7e5b3SAdam Hornáček<a class="l" name="267" href="#267">267</a> <span class="c">/** 276*eeb7e5b3SAdam Hornáček<a class="l" name="268" href="#268">268</a> * Function is used to reference to utPLSQL owned objects in dynamic sql statements executed from packages with invoker rights 277*eeb7e5b3SAdam Hornáček<a class="l" name="269" href="#269">269</a> * 278*eeb7e5b3SAdam Hornáček<a class="hl" name="270" href="#270">270</a> * @return the name of the utPSQL schema owner 279*eeb7e5b3SAdam Hornáček<a class="l" name="271" href="#271">271</a> */</span> 280*eeb7e5b3SAdam Hornáček<a class="l" name="272" href="#272">272</a> <b>function</b> <a href="/source/s?defs=ut_owner" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_owner</a> <b>return</b> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>; 281*eeb7e5b3SAdam Hornáček<a class="l" name="273" href="#273">273</a> 282*eeb7e5b3SAdam Hornáček<a class="l" name="274" href="#274">274</a> 283*eeb7e5b3SAdam Hornáček<a class="l" name="275" href="#275">275</a> <span class="c">/** 284*eeb7e5b3SAdam Hornáček<a class="l" name="276" href="#276">276</a> * Used in dynamic sql select statements to maintain balance between 285*eeb7e5b3SAdam Hornáček<a class="l" name="277" href="#277">277</a> * number of hard-parses and optimiser accurancy for cardinality of collections 286*eeb7e5b3SAdam Hornáček<a class="l" name="278" href="#278">278</a> * 287*eeb7e5b3SAdam Hornáček<a class="l" name="279" href="#279">279</a> * 288*eeb7e5b3SAdam Hornáček<a class="hl" name="280" href="#280">280</a> * @return 3, for inputs of: 1-9; 33 for input of 10 - 99; 333 for (100 - 999) 289*eeb7e5b3SAdam Hornáček<a class="l" name="281" href="#281">281</a> */</span> 290*eeb7e5b3SAdam Hornáček<a class="l" name="282" href="#282">282</a> <b>function</b> <a href="/source/s?defs=scale_cardinality" class="intelliWindow-symbol" data-definition-place="undefined-in-file">scale_cardinality</a>(<a href="/source/s?defs=a_cardinality" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_cardinality</a> <b>natural</b>) <b>return</b> <b>natural</b>; 291*eeb7e5b3SAdam Hornáček<a class="l" name="283" href="#283">283</a> 292*eeb7e5b3SAdam Hornáček<a class="l" name="284" href="#284">284</a><b>end</b> <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>; 293*eeb7e5b3SAdam Hornáček<a class="l" name="285" href="#285">285</a>/ 294*eeb7e5b3SAdam Hornáček<a class="l" name="286" href="#286">286</a> 295*eeb7e5b3SAdam Hornáček<a class="l" name="287" href="#287">287</a><b>create</b> <b>or</b> <a href="/source/s?defs=replace" class="intelliWindow-symbol" data-definition-place="undefined-in-file">replace</a> <a href="/source/s?defs=package" class="intelliWindow-symbol" data-definition-place="undefined-in-file">package</a> <a href="/source/s?defs=body" class="intelliWindow-symbol" data-definition-place="undefined-in-file">body</a> <a class="xp" name="ut_suite_builder"/><a href="/source/s?refs=ut_suite_builder" class="xp intelliWindow-symbol" data-definition-place="def">ut_suite_builder</a> <b>is</b> 296*eeb7e5b3SAdam Hornáček<a class="l" name="288" href="#288">288</a> <span class="c">/* 297*eeb7e5b3SAdam Hornáček<a class="l" name="289" href="#289">289</a> utPLSQL - Version 3 298*eeb7e5b3SAdam Hornáček<a class="hl" name="290" href="#290">290</a> Copyright 2016 - 2017 utPLSQL Project 299*eeb7e5b3SAdam Hornáček<a class="l" name="291" href="#291">291</a> 300*eeb7e5b3SAdam Hornáček<a class="l" name="292" href="#292">292</a> Licensed under the Apache License, Version 2.0 (the "License"): 301*eeb7e5b3SAdam Hornáček<a class="l" name="293" href="#293">293</a> you may not use this file except in compliance with the License. 302*eeb7e5b3SAdam Hornáček<a class="l" name="294" href="#294">294</a> You may obtain a copy of the License at 303*eeb7e5b3SAdam Hornáček<a class="l" name="295" href="#295">295</a> 304*eeb7e5b3SAdam Hornáček<a class="l" name="296" href="#296">296</a> <a href="http://www.apache.org/licenses/LICENSE-2.0">http://www.apache.org/licenses/LICENSE-2.0</a> 305*eeb7e5b3SAdam Hornáček<a class="l" name="297" href="#297">297</a> 306*eeb7e5b3SAdam Hornáček<a class="l" name="298" href="#298">298</a> Unless required by applicable law or agreed to in writing, software 307*eeb7e5b3SAdam Hornáček<a class="l" name="299" href="#299">299</a> distributed under the License is distributed on an "AS IS" BASIS, 308*eeb7e5b3SAdam Hornáček<a class="hl" name="300" href="#300">300</a> WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 309*eeb7e5b3SAdam Hornáček<a class="l" name="301" href="#301">301</a> See the License for the specific language governing permissions and 310*eeb7e5b3SAdam Hornáček<a class="l" name="302" href="#302">302</a> limitations under the License. 311*eeb7e5b3SAdam Hornáček<a class="l" name="303" href="#303">303</a> */</span> 312*eeb7e5b3SAdam Hornáček<a class="l" name="304" href="#304">304</a> 313*eeb7e5b3SAdam Hornáček<a class="l" name="305" href="#305">305</a> <span class="c">------------------</span> 314*eeb7e5b3SAdam Hornáček<a class="l" name="306" href="#306">306</a> 315*eeb7e5b3SAdam Hornáček<a class="l" name="307" href="#307">307</a> <b>function</b> <a class="xf" name="create_suite"/><a href="/source/s?refs=create_suite" class="xf intelliWindow-symbol" data-definition-place="def">create_suite</a>(<a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a> <a href="/source/s?defs=ut_annotated_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_annotated_object</a>) <b>return</b> <a href="/source/s?defs=ut_logical_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_logical_suite</a> <b>is</b> 316*eeb7e5b3SAdam Hornáček<a class="l" name="308" href="#308">308</a> <a class="xl" name="l_is_suite"/><a href="/source/s?refs=l_is_suite" class="xl intelliWindow-symbol" data-definition-place="def">l_is_suite</a> <b>boolean</b> := <b>false</b>; 317*eeb7e5b3SAdam Hornáček<a class="l" name="309" href="#309">309</a> <a class="xl" name="l_is_test"/><a href="/source/s?refs=l_is_test" class="xl intelliWindow-symbol" data-definition-place="def">l_is_test</a> <b>boolean</b> := <b>false</b>; 318*eeb7e5b3SAdam Hornáček<a class="hl" name="310" href="#310">310</a> <a class="xl" name="l_suite_disabled"/><a href="/source/s?refs=l_suite_disabled" class="xl intelliWindow-symbol" data-definition-place="def">l_suite_disabled</a> <b>boolean</b> := <b>false</b>; 319*eeb7e5b3SAdam Hornáček<a class="l" name="311" href="#311">311</a> <a class="xl" name="l_test_disabled"/><a href="/source/s?refs=l_test_disabled" class="xl intelliWindow-symbol" data-definition-place="def">l_test_disabled</a> <b>boolean</b> := <b>false</b>; 320*eeb7e5b3SAdam Hornáček<a class="l" name="312" href="#312">312</a> <a class="xl" name="l_suite_items"/><a href="/source/s?refs=l_suite_items" class="xl intelliWindow-symbol" data-definition-place="def">l_suite_items</a> <a href="/source/s?defs=ut_suite_items" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_suite_items</a> := <a href="/source/s?defs=ut_suite_items" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_suite_items</a>(); 321*eeb7e5b3SAdam Hornáček<a class="l" name="313" href="#313">313</a> <a class="xl" name="l_suite_name"/><a href="/source/s?refs=l_suite_name" class="xl intelliWindow-symbol" data-definition-place="def">l_suite_name</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">4000</span>); 322*eeb7e5b3SAdam Hornáček<a class="l" name="314" href="#314">314</a> 323*eeb7e5b3SAdam Hornáček<a class="l" name="315" href="#315">315</a> <a class="xl" name="l_default_setup_proc"/><a href="/source/s?refs=l_default_setup_proc" class="xl intelliWindow-symbol" data-definition-place="def">l_default_setup_proc</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">250</span> <b>char</b>); 324*eeb7e5b3SAdam Hornáček<a class="l" name="316" href="#316">316</a> <a class="xl" name="l_default_teardown_proc"/><a href="/source/s?refs=l_default_teardown_proc" class="xl intelliWindow-symbol" data-definition-place="def">l_default_teardown_proc</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">250</span> <b>char</b>); 325*eeb7e5b3SAdam Hornáček<a class="l" name="317" href="#317">317</a> <a class="xl" name="l_suite_setup_proc"/><a href="/source/s?refs=l_suite_setup_proc" class="xl intelliWindow-symbol" data-definition-place="def">l_suite_setup_proc</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">250</span> <b>char</b>); 326*eeb7e5b3SAdam Hornáček<a class="l" name="318" href="#318">318</a> <a class="xl" name="l_suite_teardown_proc"/><a href="/source/s?refs=l_suite_teardown_proc" class="xl intelliWindow-symbol" data-definition-place="def">l_suite_teardown_proc</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">250</span> <b>char</b>); 327*eeb7e5b3SAdam Hornáček<a class="l" name="319" href="#319">319</a> <a class="xl" name="l_suite_path"/><a href="/source/s?refs=l_suite_path" class="xl intelliWindow-symbol" data-definition-place="def">l_suite_path</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">4000</span> <b>char</b>); 328*eeb7e5b3SAdam Hornáček<a class="hl" name="320" href="#320">320</a> 329*eeb7e5b3SAdam Hornáček<a class="l" name="321" href="#321">321</a> <a class="xl" name="l_proc_name"/><a href="/source/s?refs=l_proc_name" class="xl intelliWindow-symbol" data-definition-place="def">l_proc_name</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">250</span> <b>char</b>); 330*eeb7e5b3SAdam Hornáček<a class="l" name="322" href="#322">322</a> 331*eeb7e5b3SAdam Hornáček<a class="l" name="323" href="#323">323</a> <a class="xl" name="l_suite"/><a href="/source/s?refs=l_suite" class="xl intelliWindow-symbol" data-definition-place="def">l_suite</a> <a href="/source/s?defs=ut_logical_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_logical_suite</a>; 332*eeb7e5b3SAdam Hornáček<a class="l" name="324" href="#324">324</a> <a class="xl" name="l_test"/><a href="/source/s?refs=l_test" class="xl intelliWindow-symbol" data-definition-place="def">l_test</a> <a href="/source/s?defs=ut_test" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_test</a>; 333*eeb7e5b3SAdam Hornáček<a class="l" name="325" href="#325">325</a> 334*eeb7e5b3SAdam Hornáček<a class="l" name="326" href="#326">326</a> <a class="xl" name="l_suite_rollback"/><a href="/source/s?refs=l_suite_rollback" class="xl intelliWindow-symbol" data-definition-place="def">l_suite_rollback</a> <b>integer</b>; 335*eeb7e5b3SAdam Hornáček<a class="l" name="327" href="#327">327</a> 336*eeb7e5b3SAdam Hornáček<a class="l" name="328" href="#328">328</a> <a class="xl" name="l_beforetest_procedure"/><a href="/source/s?refs=l_beforetest_procedure" class="xl intelliWindow-symbol" data-definition-place="def">l_beforetest_procedure</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">250</span> <b>char</b>); 337*eeb7e5b3SAdam Hornáček<a class="l" name="329" href="#329">329</a> <a class="xl" name="l_aftertest_procedure"/><a href="/source/s?refs=l_aftertest_procedure" class="xl intelliWindow-symbol" data-definition-place="def">l_aftertest_procedure</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">250</span> <b>char</b>); 338*eeb7e5b3SAdam Hornáček<a class="hl" name="330" href="#330">330</a> <a class="xl" name="l_rollback_type"/><a href="/source/s?refs=l_rollback_type" class="xl intelliWindow-symbol" data-definition-place="def">l_rollback_type</a> <b>integer</b>; 339*eeb7e5b3SAdam Hornáček<a class="l" name="331" href="#331">331</a> <a class="xl" name="l_displayname"/><a href="/source/s?refs=l_displayname" class="xl intelliWindow-symbol" data-definition-place="def">l_displayname</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">4000</span>); 340*eeb7e5b3SAdam Hornáček<a class="l" name="332" href="#332">332</a> <b>function</b> <a class="xf" name="is_last_annotation_for_proc"/><a href="/source/s?refs=is_last_annotation_for_proc" class="xf intelliWindow-symbol" data-definition-place="def">is_last_annotation_for_proc</a>(<a href="/source/s?defs=a_annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_annotations</a> <a href="/source/s?defs=ut_annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_annotations</a>, <a href="/source/s?defs=a_index" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_index</a> <a href="/source/s?defs=binary_integer" class="intelliWindow-symbol" data-definition-place="undefined-in-file">binary_integer</a>) <b>return</b> <b>boolean</b> <b>is</b> 341*eeb7e5b3SAdam Hornáček<a class="l" name="333" href="#333">333</a> <b>begin</b> 342*eeb7e5b3SAdam Hornáček<a class="l" name="334" href="#334">334</a> <b>return</b> <a href="/source/s?defs=a_index" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_index</a> = <a href="/source/s?defs=a_annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_annotations</a>.<b>count</b> <b>or</b> <a href="/source/s?defs=a_annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_annotations</a>(<a href="/source/s?defs=a_index" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_index</a>).<a href="/source/s?defs=subobject_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">subobject_name</a> != <a href="/source/s?defs=nvl" class="intelliWindow-symbol" data-definition-place="undefined-in-file">nvl</a>(<a href="/source/s?defs=a_annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_annotations</a>(<a href="/source/s?defs=a_index" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_index</a><span class="n">+1</span>).<a href="/source/s?defs=subobject_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">subobject_name</a>, <span class="s">' '</span>); 343*eeb7e5b3SAdam Hornáček<a class="l" name="335" href="#335">335</a> <b>end</b>; 344*eeb7e5b3SAdam Hornáček<a class="l" name="336" href="#336">336</a> <b>begin</b> 345*eeb7e5b3SAdam Hornáček<a class="l" name="337" href="#337">337</a> <a class="d intelliWindow-symbol" href="#l_suite_rollback" data-definition-place="defined-in-file">l_suite_rollback</a> := <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a class="d intelliWindow-symbol" href="#gc_rollback_auto" data-definition-place="defined-in-file">gc_rollback_auto</a>; 346*eeb7e5b3SAdam Hornáček<a class="l" name="338" href="#338">338</a> <b>for</b> <a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a> <b>in</b> <span class="n">1</span> .. <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>.<b>count</b> <a href="/source/s?defs=loop" class="intelliWindow-symbol" data-definition-place="undefined-in-file">loop</a> 347*eeb7e5b3SAdam Hornáček<a class="l" name="339" href="#339">339</a> 348*eeb7e5b3SAdam Hornáček<a class="hl" name="340" href="#340">340</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=subobject_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">subobject_name</a> <b>is</b> <b>null</b> <b>then</b> 349*eeb7e5b3SAdam Hornáček<a class="l" name="341" href="#341">341</a> 350*eeb7e5b3SAdam Hornáček<a class="l" name="342" href="#342">342</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> <b>in</b> (<span class="s">'suite'</span>,<span class="s">'displayname'</span>) <b>then</b> 351*eeb7e5b3SAdam Hornáček<a class="l" name="343" href="#343">343</a> <a class="d intelliWindow-symbol" href="#l_suite_name" data-definition-place="defined-in-file">l_suite_name</a> := <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a>; 352*eeb7e5b3SAdam Hornáček<a class="l" name="344" href="#344">344</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'suite'</span> <b>then</b> 353*eeb7e5b3SAdam Hornáček<a class="l" name="345" href="#345">345</a> <a class="d intelliWindow-symbol" href="#l_is_suite" data-definition-place="defined-in-file">l_is_suite</a> := <b>true</b>; 354*eeb7e5b3SAdam Hornáček<a class="l" name="346" href="#346">346</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 355*eeb7e5b3SAdam Hornáček<a class="l" name="347" href="#347">347</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'disabled'</span> <b>then</b> 356*eeb7e5b3SAdam Hornáček<a class="l" name="348" href="#348">348</a> <a class="d intelliWindow-symbol" href="#l_suite_disabled" data-definition-place="defined-in-file">l_suite_disabled</a> := <b>true</b>; 357*eeb7e5b3SAdam Hornáček<a class="l" name="349" href="#349">349</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'suitepath'</span> <b>and</b> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a> <b>is</b> <b>not</b> <b>null</b> <b>then</b> 358*eeb7e5b3SAdam Hornáček<a class="hl" name="350" href="#350">350</a> <a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a> := <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a> || <span class="s">'.'</span> || <b>lower</b>(<a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=object_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">object_name</a>); 359*eeb7e5b3SAdam Hornáček<a class="l" name="351" href="#351">351</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'rollback'</span> <b>then</b> 360*eeb7e5b3SAdam Hornáček<a class="l" name="352" href="#352">352</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <b>lower</b>(<a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a>) = <span class="s">'manual'</span> <b>then</b> 361*eeb7e5b3SAdam Hornáček<a class="l" name="353" href="#353">353</a> <a class="d intelliWindow-symbol" href="#l_suite_rollback" data-definition-place="defined-in-file">l_suite_rollback</a> := <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a class="d intelliWindow-symbol" href="#gc_rollback_manual" data-definition-place="defined-in-file">gc_rollback_manual</a>; 362*eeb7e5b3SAdam Hornáček<a class="l" name="354" href="#354">354</a> <b>else</b> 363*eeb7e5b3SAdam Hornáček<a class="l" name="355" href="#355">355</a> <a class="d intelliWindow-symbol" href="#l_suite_rollback" data-definition-place="defined-in-file">l_suite_rollback</a> := <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a class="d intelliWindow-symbol" href="#gc_rollback_auto" data-definition-place="defined-in-file">gc_rollback_auto</a>; 364*eeb7e5b3SAdam Hornáček<a class="l" name="356" href="#356">356</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 365*eeb7e5b3SAdam Hornáček<a class="l" name="357" href="#357">357</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 366*eeb7e5b3SAdam Hornáček<a class="l" name="358" href="#358">358</a> 367*eeb7e5b3SAdam Hornáček<a class="l" name="359" href="#359">359</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a class="d intelliWindow-symbol" href="#l_is_suite" data-definition-place="defined-in-file">l_is_suite</a> <b>then</b> 368*eeb7e5b3SAdam Hornáček<a class="hl" name="360" href="#360">360</a> 369*eeb7e5b3SAdam Hornáček<a class="l" name="361" href="#361">361</a> <a class="d intelliWindow-symbol" href="#l_proc_name" data-definition-place="defined-in-file">l_proc_name</a> := <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=subobject_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">subobject_name</a>; 370*eeb7e5b3SAdam Hornáček<a class="l" name="362" href="#362">362</a> 371*eeb7e5b3SAdam Hornáček<a class="l" name="363" href="#363">363</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'beforeeach'</span> <b>and</b> <a class="d intelliWindow-symbol" href="#l_default_setup_proc" data-definition-place="defined-in-file">l_default_setup_proc</a> <b>is</b> <b>null</b> <b>then</b> 372*eeb7e5b3SAdam Hornáček<a class="l" name="364" href="#364">364</a> <a class="d intelliWindow-symbol" href="#l_default_setup_proc" data-definition-place="defined-in-file">l_default_setup_proc</a> := <a class="d intelliWindow-symbol" href="#l_proc_name" data-definition-place="defined-in-file">l_proc_name</a>; 373*eeb7e5b3SAdam Hornáček<a class="l" name="365" href="#365">365</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'aftereach'</span> <b>and</b> <a class="d intelliWindow-symbol" href="#l_default_teardown_proc" data-definition-place="defined-in-file">l_default_teardown_proc</a> <b>is</b> <b>null</b> <b>then</b> 374*eeb7e5b3SAdam Hornáček<a class="l" name="366" href="#366">366</a> <a class="d intelliWindow-symbol" href="#l_default_teardown_proc" data-definition-place="defined-in-file">l_default_teardown_proc</a> := <a class="d intelliWindow-symbol" href="#l_proc_name" data-definition-place="defined-in-file">l_proc_name</a>; 375*eeb7e5b3SAdam Hornáček<a class="l" name="367" href="#367">367</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'beforeall'</span> <b>and</b> <a class="d intelliWindow-symbol" href="#l_suite_setup_proc" data-definition-place="defined-in-file">l_suite_setup_proc</a> <b>is</b> <b>null</b> <b>then</b> 376*eeb7e5b3SAdam Hornáček<a class="l" name="368" href="#368">368</a> <a class="d intelliWindow-symbol" href="#l_suite_setup_proc" data-definition-place="defined-in-file">l_suite_setup_proc</a> := <a class="d intelliWindow-symbol" href="#l_proc_name" data-definition-place="defined-in-file">l_proc_name</a>; 377*eeb7e5b3SAdam Hornáček<a class="l" name="369" href="#369">369</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'afterall'</span> <b>and</b> <a class="d intelliWindow-symbol" href="#l_suite_teardown_proc" data-definition-place="defined-in-file">l_suite_teardown_proc</a> <b>is</b> <b>null</b> <b>then</b> 378*eeb7e5b3SAdam Hornáček<a class="hl" name="370" href="#370">370</a> <a class="d intelliWindow-symbol" href="#l_suite_teardown_proc" data-definition-place="defined-in-file">l_suite_teardown_proc</a> := <a class="d intelliWindow-symbol" href="#l_proc_name" data-definition-place="defined-in-file">l_proc_name</a>; 379*eeb7e5b3SAdam Hornáček<a class="l" name="371" href="#371">371</a> 380*eeb7e5b3SAdam Hornáček<a class="l" name="372" href="#372">372</a> 381*eeb7e5b3SAdam Hornáček<a class="l" name="373" href="#373">373</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'disabled'</span> <b>then</b> 382*eeb7e5b3SAdam Hornáček<a class="l" name="374" href="#374">374</a> <a class="d intelliWindow-symbol" href="#l_test_disabled" data-definition-place="defined-in-file">l_test_disabled</a> := <b>true</b>; 383*eeb7e5b3SAdam Hornáček<a class="l" name="375" href="#375">375</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'beforetest'</span> <b>then</b> 384*eeb7e5b3SAdam Hornáček<a class="l" name="376" href="#376">376</a> <a class="d intelliWindow-symbol" href="#l_beforetest_procedure" data-definition-place="defined-in-file">l_beforetest_procedure</a> := <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a>; 385*eeb7e5b3SAdam Hornáček<a class="l" name="377" href="#377">377</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'aftertest'</span> <b>then</b> 386*eeb7e5b3SAdam Hornáček<a class="l" name="378" href="#378">378</a> <a class="d intelliWindow-symbol" href="#l_aftertest_procedure" data-definition-place="defined-in-file">l_aftertest_procedure</a> := <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a>; 387*eeb7e5b3SAdam Hornáček<a class="l" name="379" href="#379">379</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> <b>in</b> (<span class="s">'displayname'</span>,<span class="s">'test'</span>) <b>then</b> 388*eeb7e5b3SAdam Hornáček<a class="hl" name="380" href="#380">380</a> <a class="d intelliWindow-symbol" href="#l_displayname" data-definition-place="defined-in-file">l_displayname</a> := <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a>; 389*eeb7e5b3SAdam Hornáček<a class="l" name="381" href="#381">381</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'test'</span> <b>then</b> 390*eeb7e5b3SAdam Hornáček<a class="l" name="382" href="#382">382</a> <a class="d intelliWindow-symbol" href="#l_is_test" data-definition-place="defined-in-file">l_is_test</a> := <b>true</b>; 391*eeb7e5b3SAdam Hornáček<a class="l" name="383" href="#383">383</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 392*eeb7e5b3SAdam Hornáček<a class="l" name="384" href="#384">384</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a> = <span class="s">'rollback'</span> <b>then</b> 393*eeb7e5b3SAdam Hornáček<a class="l" name="385" href="#385">385</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <b>lower</b>(<a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a>) = <span class="s">'manual'</span> <b>then</b> 394*eeb7e5b3SAdam Hornáček<a class="l" name="386" href="#386">386</a> <a class="d intelliWindow-symbol" href="#l_rollback_type" data-definition-place="defined-in-file">l_rollback_type</a> := <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a class="d intelliWindow-symbol" href="#gc_rollback_manual" data-definition-place="defined-in-file">gc_rollback_manual</a>; 395*eeb7e5b3SAdam Hornáček<a class="l" name="387" href="#387">387</a> <a href="/source/s?defs=elsif" class="intelliWindow-symbol" data-definition-place="undefined-in-file">elsif</a> <b>lower</b>(<a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>).<a href="/source/s?defs=text" class="intelliWindow-symbol" data-definition-place="undefined-in-file">text</a>) = <span class="s">'auto'</span> <b>then</b> 396*eeb7e5b3SAdam Hornáček<a class="l" name="388" href="#388">388</a> <a class="d intelliWindow-symbol" href="#l_rollback_type" data-definition-place="defined-in-file">l_rollback_type</a> := <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a class="d intelliWindow-symbol" href="#gc_rollback_auto" data-definition-place="defined-in-file">gc_rollback_auto</a>; 397*eeb7e5b3SAdam Hornáček<a class="l" name="389" href="#389">389</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 398*eeb7e5b3SAdam Hornáček<a class="hl" name="390" href="#390">390</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 399*eeb7e5b3SAdam Hornáček<a class="l" name="391" href="#391">391</a> 400*eeb7e5b3SAdam Hornáček<a class="l" name="392" href="#392">392</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a class="d intelliWindow-symbol" href="#l_is_test" data-definition-place="defined-in-file">l_is_test</a> <b>and</b> <a class="d intelliWindow-symbol" href="#is_last_annotation_for_proc" data-definition-place="defined-in-file">is_last_annotation_for_proc</a>(<a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=annotations" class="intelliWindow-symbol" data-definition-place="undefined-in-file">annotations</a>, <a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>) <b>then</b> 401*eeb7e5b3SAdam Hornáček<a class="l" name="393" href="#393">393</a> <a class="d intelliWindow-symbol" href="#l_suite_items" data-definition-place="defined-in-file">l_suite_items</a>.<a href="/source/s?defs=extend" class="intelliWindow-symbol" data-definition-place="undefined-in-file">extend</a>; 402*eeb7e5b3SAdam Hornáček<a class="l" name="394" href="#394">394</a> <a class="d intelliWindow-symbol" href="#l_suite_items" data-definition-place="defined-in-file">l_suite_items</a>(<a class="d intelliWindow-symbol" href="#l_suite_items" data-definition-place="defined-in-file">l_suite_items</a>.<a href="/source/s?defs=last" class="intelliWindow-symbol" data-definition-place="undefined-in-file">last</a>) := 403*eeb7e5b3SAdam Hornáček<a class="l" name="395" href="#395">395</a> <a href="/source/s?defs=ut_test" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_test</a>(<a href="/source/s?defs=a_object_owner" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object_owner</a> => <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=object_owner" class="intelliWindow-symbol" data-definition-place="undefined-in-file">object_owner</a> 404*eeb7e5b3SAdam Hornáček<a class="l" name="396" href="#396">396</a> ,<a href="/source/s?defs=a_object_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object_name</a> => <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=object_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">object_name</a> 405*eeb7e5b3SAdam Hornáček<a class="l" name="397" href="#397">397</a> ,<a href="/source/s?defs=a_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_name</a> => <a class="d intelliWindow-symbol" href="#l_proc_name" data-definition-place="defined-in-file">l_proc_name</a> 406*eeb7e5b3SAdam Hornáček<a class="l" name="398" href="#398">398</a> ,<a href="/source/s?defs=a_description" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_description</a> => <a class="d intelliWindow-symbol" href="#l_displayname" data-definition-place="defined-in-file">l_displayname</a> 407*eeb7e5b3SAdam Hornáček<a class="l" name="399" href="#399">399</a> ,<a href="/source/s?defs=a_rollback_type" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_rollback_type</a> => <b>coalesce</b>(<a class="d intelliWindow-symbol" href="#l_rollback_type" data-definition-place="defined-in-file">l_rollback_type</a>, <a class="d intelliWindow-symbol" href="#l_suite_rollback" data-definition-place="defined-in-file">l_suite_rollback</a>) 408*eeb7e5b3SAdam Hornáček<a class="hl" name="400" href="#400">400</a> ,<a href="/source/s?defs=a_disabled_flag" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_disabled_flag</a> => <a class="d intelliWindow-symbol" href="#l_test_disabled" data-definition-place="defined-in-file">l_test_disabled</a> 409*eeb7e5b3SAdam Hornáček<a class="l" name="401" href="#401">401</a> ,<a href="/source/s?defs=a_before_test_proc_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_before_test_proc_name</a> => <a class="d intelliWindow-symbol" href="#l_beforetest_procedure" data-definition-place="defined-in-file">l_beforetest_procedure</a> 410*eeb7e5b3SAdam Hornáček<a class="l" name="402" href="#402">402</a> ,<a href="/source/s?defs=a_after_test_proc_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_after_test_proc_name</a> => <a class="d intelliWindow-symbol" href="#l_aftertest_procedure" data-definition-place="defined-in-file">l_aftertest_procedure</a>); 411*eeb7e5b3SAdam Hornáček<a class="l" name="403" href="#403">403</a> 412*eeb7e5b3SAdam Hornáček<a class="l" name="404" href="#404">404</a> <a class="d intelliWindow-symbol" href="#l_is_test" data-definition-place="defined-in-file">l_is_test</a> := <b>false</b>; 413*eeb7e5b3SAdam Hornáček<a class="l" name="405" href="#405">405</a> <a class="d intelliWindow-symbol" href="#l_test_disabled" data-definition-place="defined-in-file">l_test_disabled</a> := <b>false</b>; 414*eeb7e5b3SAdam Hornáček<a class="l" name="406" href="#406">406</a> <a class="d intelliWindow-symbol" href="#l_aftertest_procedure" data-definition-place="defined-in-file">l_aftertest_procedure</a> := <b>null</b>; 415*eeb7e5b3SAdam Hornáček<a class="l" name="407" href="#407">407</a> <a class="d intelliWindow-symbol" href="#l_beforetest_procedure" data-definition-place="defined-in-file">l_beforetest_procedure</a> := <b>null</b>; 416*eeb7e5b3SAdam Hornáček<a class="l" name="408" href="#408">408</a> <a class="d intelliWindow-symbol" href="#l_rollback_type" data-definition-place="defined-in-file">l_rollback_type</a> := <b>null</b>; 417*eeb7e5b3SAdam Hornáček<a class="l" name="409" href="#409">409</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 418*eeb7e5b3SAdam Hornáček<a class="hl" name="410" href="#410">410</a> 419*eeb7e5b3SAdam Hornáček<a class="l" name="411" href="#411">411</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 420*eeb7e5b3SAdam Hornáček<a class="l" name="412" href="#412">412</a> <b>end</b> <a href="/source/s?defs=loop" class="intelliWindow-symbol" data-definition-place="undefined-in-file">loop</a>; 421*eeb7e5b3SAdam Hornáček<a class="l" name="413" href="#413">413</a> 422*eeb7e5b3SAdam Hornáček<a class="l" name="414" href="#414">414</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a class="d intelliWindow-symbol" href="#l_is_suite" data-definition-place="defined-in-file">l_is_suite</a> <b>then</b> 423*eeb7e5b3SAdam Hornáček<a class="l" name="415" href="#415">415</a> <a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a> := <a href="/source/s?defs=ut_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_suite</a> ( 424*eeb7e5b3SAdam Hornáček<a class="l" name="416" href="#416">416</a> <a href="/source/s?defs=a_object_owner" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object_owner</a> => <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=object_owner" class="intelliWindow-symbol" data-definition-place="undefined-in-file">object_owner</a>, 425*eeb7e5b3SAdam Hornáček<a class="l" name="417" href="#417">417</a> <a href="/source/s?defs=a_object_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object_name</a> => <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=object_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">object_name</a>, 426*eeb7e5b3SAdam Hornáček<a class="l" name="418" href="#418">418</a> <a href="/source/s?defs=a_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_name</a> => <a href="/source/s?defs=a_object" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object</a>.<a href="/source/s?defs=object_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">object_name</a>, <span class="c">--this could be different for sub-suite (context)</span> 427*eeb7e5b3SAdam Hornáček<a class="l" name="419" href="#419">419</a> <a href="/source/s?defs=a_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_path</a> => <a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>, <span class="c">--a patch for this suite (excluding the package name of current suite)</span> 428*eeb7e5b3SAdam Hornáček<a class="hl" name="420" href="#420">420</a> <a href="/source/s?defs=a_description" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_description</a> => <a class="d intelliWindow-symbol" href="#l_suite_name" data-definition-place="defined-in-file">l_suite_name</a>, 429*eeb7e5b3SAdam Hornáček<a class="l" name="421" href="#421">421</a> <a href="/source/s?defs=a_rollback_type" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_rollback_type</a> => <a class="d intelliWindow-symbol" href="#l_suite_rollback" data-definition-place="defined-in-file">l_suite_rollback</a>, 430*eeb7e5b3SAdam Hornáček<a class="l" name="422" href="#422">422</a> <a href="/source/s?defs=a_disabled_flag" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_disabled_flag</a> => <a class="d intelliWindow-symbol" href="#l_suite_disabled" data-definition-place="defined-in-file">l_suite_disabled</a>, 431*eeb7e5b3SAdam Hornáček<a class="l" name="423" href="#423">423</a> <a href="/source/s?defs=a_before_all_proc_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_before_all_proc_name</a> => <a class="d intelliWindow-symbol" href="#l_suite_setup_proc" data-definition-place="defined-in-file">l_suite_setup_proc</a>, 432*eeb7e5b3SAdam Hornáček<a class="l" name="424" href="#424">424</a> <a href="/source/s?defs=a_after_all_proc_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_after_all_proc_name</a> => <a class="d intelliWindow-symbol" href="#l_suite_teardown_proc" data-definition-place="defined-in-file">l_suite_teardown_proc</a> 433*eeb7e5b3SAdam Hornáček<a class="l" name="425" href="#425">425</a> ); 434*eeb7e5b3SAdam Hornáček<a class="l" name="426" href="#426">426</a> <b>for</b> <a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a> <b>in</b> <span class="n">1</span> .. <a class="d intelliWindow-symbol" href="#l_suite_items" data-definition-place="defined-in-file">l_suite_items</a>.<b>count</b> <a href="/source/s?defs=loop" class="intelliWindow-symbol" data-definition-place="undefined-in-file">loop</a> 435*eeb7e5b3SAdam Hornáček<a class="l" name="427" href="#427">427</a> <a class="d intelliWindow-symbol" href="#l_test" data-definition-place="defined-in-file">l_test</a> := <b>treat</b>(<a class="d intelliWindow-symbol" href="#l_suite_items" data-definition-place="defined-in-file">l_suite_items</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>) <b>as</b> <a href="/source/s?defs=ut_test" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_test</a>); 436*eeb7e5b3SAdam Hornáček<a class="l" name="428" href="#428">428</a> <a class="d intelliWindow-symbol" href="#l_test" data-definition-place="defined-in-file">l_test</a>.<a href="/source/s?defs=set_beforeeach" class="intelliWindow-symbol" data-definition-place="undefined-in-file">set_beforeeach</a>(<a class="d intelliWindow-symbol" href="#l_default_setup_proc" data-definition-place="defined-in-file">l_default_setup_proc</a>); 437*eeb7e5b3SAdam Hornáček<a class="l" name="429" href="#429">429</a> <a class="d intelliWindow-symbol" href="#l_test" data-definition-place="defined-in-file">l_test</a>.<a href="/source/s?defs=set_aftereach" class="intelliWindow-symbol" data-definition-place="undefined-in-file">set_aftereach</a>(<a class="d intelliWindow-symbol" href="#l_default_teardown_proc" data-definition-place="defined-in-file">l_default_teardown_proc</a>); 438*eeb7e5b3SAdam Hornáček<a class="hl" name="430" href="#430">430</a> <a class="d intelliWindow-symbol" href="#l_test" data-definition-place="defined-in-file">l_test</a>.<a href="/source/s?defs=path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">path</a> := <a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a>.<a href="/source/s?defs=path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">path</a> || <span class="s">'.'</span> || <a class="d intelliWindow-symbol" href="#l_test" data-definition-place="defined-in-file">l_test</a>.<a href="/source/s?defs=name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">name</a>; 439*eeb7e5b3SAdam Hornáček<a class="l" name="431" href="#431">431</a> <a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a>.<a href="/source/s?defs=add_item" class="intelliWindow-symbol" data-definition-place="undefined-in-file">add_item</a>(<a class="d intelliWindow-symbol" href="#l_test" data-definition-place="defined-in-file">l_test</a>); 440*eeb7e5b3SAdam Hornáček<a class="l" name="432" href="#432">432</a> <b>end</b> <a href="/source/s?defs=loop" class="intelliWindow-symbol" data-definition-place="undefined-in-file">loop</a>; 441*eeb7e5b3SAdam Hornáček<a class="l" name="433" href="#433">433</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 442*eeb7e5b3SAdam Hornáček<a class="l" name="434" href="#434">434</a> 443*eeb7e5b3SAdam Hornáček<a class="l" name="435" href="#435">435</a> <b>return</b> <a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a>; 444*eeb7e5b3SAdam Hornáček<a class="l" name="436" href="#436">436</a> 445*eeb7e5b3SAdam Hornáček<a class="l" name="437" href="#437">437</a> <b>end</b> <a class="d intelliWindow-symbol" href="#create_suite" data-definition-place="defined-in-file">create_suite</a>; 446*eeb7e5b3SAdam Hornáček<a class="l" name="438" href="#438">438</a> 447*eeb7e5b3SAdam Hornáček<a class="l" name="439" href="#439">439</a> <b>function</b> <a class="xf" name="build_suites_hierarchy"/><a href="/source/s?refs=build_suites_hierarchy" class="xf intelliWindow-symbol" data-definition-place="def">build_suites_hierarchy</a>(<a href="/source/s?defs=a_suites_by_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_suites_by_path</a> <a href="/source/s?defs=tt_schema_suites" class="intelliWindow-symbol" data-definition-place="undefined-in-file">tt_schema_suites</a>) <b>return</b> <a href="/source/s?defs=tt_schema_suites" class="intelliWindow-symbol" data-definition-place="undefined-in-file">tt_schema_suites</a> <b>is</b> 448*eeb7e5b3SAdam Hornáček<a class="hl" name="440" href="#440">440</a> <a class="xl" name="l_result"/><a href="/source/s?refs=l_result" class="xl intelliWindow-symbol" data-definition-place="def">l_result</a> <a href="/source/s?defs=tt_schema_suites" class="intelliWindow-symbol" data-definition-place="undefined-in-file">tt_schema_suites</a>; 449*eeb7e5b3SAdam Hornáček<a class="l" name="441" href="#441">441</a> <a class="xl" name="l_suite_path"/><a href="/source/s?refs=l_suite_path" class="xl intelliWindow-symbol" data-definition-place="def">l_suite_path</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">4000</span> <b>char</b>); 450*eeb7e5b3SAdam Hornáček<a class="l" name="442" href="#442">442</a> <a class="xl" name="l_parent_path"/><a href="/source/s?refs=l_parent_path" class="xl intelliWindow-symbol" data-definition-place="def">l_parent_path</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">4000</span> <b>char</b>); 451*eeb7e5b3SAdam Hornáček<a class="l" name="443" href="#443">443</a> <a class="xl" name="l_name"/><a href="/source/s?refs=l_name" class="xl intelliWindow-symbol" data-definition-place="def">l_name</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>(<span class="n">4000</span> <b>char</b>); 452*eeb7e5b3SAdam Hornáček<a class="l" name="444" href="#444">444</a> <a class="xl" name="l_suites_by_path"/><a href="/source/s?refs=l_suites_by_path" class="xl intelliWindow-symbol" data-definition-place="def">l_suites_by_path</a> <a href="/source/s?defs=tt_schema_suites" class="intelliWindow-symbol" data-definition-place="undefined-in-file">tt_schema_suites</a>; 453*eeb7e5b3SAdam Hornáček<a class="l" name="445" href="#445">445</a> <b>begin</b> 454*eeb7e5b3SAdam Hornáček<a class="l" name="446" href="#446">446</a> <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a> := <a href="/source/s?defs=a_suites_by_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_suites_by_path</a>; 455*eeb7e5b3SAdam Hornáček<a class="l" name="447" href="#447">447</a> <span class="c">--were iterating in reverse order of the index by path table</span> 456*eeb7e5b3SAdam Hornáček<a class="l" name="448" href="#448">448</a> <span class="c">-- so the first paths will be the leafs of hierarchy and next will their parents</span> 457*eeb7e5b3SAdam Hornáček<a class="l" name="449" href="#449">449</a> <a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a> := <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>.<a href="/source/s?defs=last" class="intelliWindow-symbol" data-definition-place="undefined-in-file">last</a>; 458*eeb7e5b3SAdam Hornáček<a class="hl" name="450" href="#450">450</a> <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<span class="s">'Input suites to process = '</span>||<a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>.<b>count</b>); 459*eeb7e5b3SAdam Hornáček<a class="l" name="451" href="#451">451</a> 460*eeb7e5b3SAdam Hornáček<a class="l" name="452" href="#452">452</a> <a href="/source/s?defs=while" class="intelliWindow-symbol" data-definition-place="undefined-in-file">while</a> <a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a> <b>is</b> <b>not</b> <b>null</b> <a href="/source/s?defs=loop" class="intelliWindow-symbol" data-definition-place="undefined-in-file">loop</a> 461*eeb7e5b3SAdam Hornáček<a class="l" name="453" href="#453">453</a> <a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a> := <a href="/source/s?defs=substr" class="intelliWindow-symbol" data-definition-place="undefined-in-file">substr</a>( <a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>, <span class="n">1</span>, <a href="/source/s?defs=instr" class="intelliWindow-symbol" data-definition-place="undefined-in-file">instr</a>(<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>,<span class="s">'.'</span>,<span class="n">-1</span>)<span class="n">-1</span>); 462*eeb7e5b3SAdam Hornáček<a class="l" name="454" href="#454">454</a> <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<span class="s">'Processing l_suite_path = "'</span>||<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>||<span class="s">'", l_parent_path = "'</span>||<a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>||<span class="s">'"'</span>); 463*eeb7e5b3SAdam Hornáček<a class="l" name="455" href="#455">455</a> <span class="c">--no parent => I'm a root element</span> 464*eeb7e5b3SAdam Hornáček<a class="l" name="456" href="#456">456</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a> <b>is</b> <b>null</b> <b>then</b> 465*eeb7e5b3SAdam Hornáček<a class="l" name="457" href="#457">457</a> <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<span class="s">' suite "'</span>||<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>||<span class="s">'" is a root element - adding to return list.'</span>); 466*eeb7e5b3SAdam Hornáček<a class="l" name="458" href="#458">458</a> <a href="/source/s?defs=l_result" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_result</a>(<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>) := <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>(<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>); 467*eeb7e5b3SAdam Hornáček<a class="l" name="459" href="#459">459</a> <span class="c">-- not a root suite - need to add it to a parent suite</span> 468*eeb7e5b3SAdam Hornáček<a class="hl" name="460" href="#460">460</a> <b>else</b> 469*eeb7e5b3SAdam Hornáček<a class="l" name="461" href="#461">461</a> <span class="c">--parent does not exist and needs to be added</span> 470*eeb7e5b3SAdam Hornáček<a class="l" name="462" href="#462">462</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <b>not</b> <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>.<b>exists</b>(<a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>) <b>then</b> 471*eeb7e5b3SAdam Hornáček<a class="l" name="463" href="#463">463</a> <a class="d intelliWindow-symbol" href="#l_name" data-definition-place="defined-in-file">l_name</a> := <a href="/source/s?defs=substr" class="intelliWindow-symbol" data-definition-place="undefined-in-file">substr</a>( <a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>, <a href="/source/s?defs=instr" class="intelliWindow-symbol" data-definition-place="undefined-in-file">instr</a>(<a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>,<span class="s">'.'</span>,<span class="n">-1</span>)<span class="n">+1</span>); 472*eeb7e5b3SAdam Hornáček<a class="l" name="464" href="#464">464</a> <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<span class="s">' Parent suite "'</span>||<a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>||<span class="s">'" not found in the list - Adding suite "'</span>||<a class="d intelliWindow-symbol" href="#l_name" data-definition-place="defined-in-file">l_name</a>||<span class="s">'"'</span>); 473*eeb7e5b3SAdam Hornáček<a class="l" name="465" href="#465">465</a> <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>(<a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>) := 474*eeb7e5b3SAdam Hornáček<a class="l" name="466" href="#466">466</a> <a href="/source/s?defs=ut_logical_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_logical_suite</a>( 475*eeb7e5b3SAdam Hornáček<a class="l" name="467" href="#467">467</a> <a href="/source/s?defs=a_object_owner" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object_owner</a> => <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>(<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>).<a href="/source/s?defs=object_owner" class="intelliWindow-symbol" data-definition-place="undefined-in-file">object_owner</a>, 476*eeb7e5b3SAdam Hornáček<a class="l" name="468" href="#468">468</a> <a href="/source/s?defs=a_object_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_object_name</a> => <a class="d intelliWindow-symbol" href="#l_name" data-definition-place="defined-in-file">l_name</a>, <a href="/source/s?defs=a_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_name</a> => <a class="d intelliWindow-symbol" href="#l_name" data-definition-place="defined-in-file">l_name</a>, <a href="/source/s?defs=a_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_path</a> => <a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a> 477*eeb7e5b3SAdam Hornáček<a class="l" name="469" href="#469">469</a> ); 478*eeb7e5b3SAdam Hornáček<a class="hl" name="470" href="#470">470</a> <b>else</b> 479*eeb7e5b3SAdam Hornáček<a class="l" name="471" href="#471">471</a> <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<span class="s">' Parent suite "'</span>||<a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>||<span class="s">'" found in list of suites'</span>); 480*eeb7e5b3SAdam Hornáček<a class="l" name="472" href="#472">472</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 481*eeb7e5b3SAdam Hornáček<a class="l" name="473" href="#473">473</a> <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<span class="s">' adding suite "'</span>||<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>||<span class="s">'" to "'</span>||<a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>||<span class="s">'" items'</span>); 482*eeb7e5b3SAdam Hornáček<a class="l" name="474" href="#474">474</a> <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>(<a class="d intelliWindow-symbol" href="#l_parent_path" data-definition-place="defined-in-file">l_parent_path</a>).<a href="/source/s?defs=add_item" class="intelliWindow-symbol" data-definition-place="undefined-in-file">add_item</a>( <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>(<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>) ); 483*eeb7e5b3SAdam Hornáček<a class="l" name="475" href="#475">475</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 484*eeb7e5b3SAdam Hornáček<a class="l" name="476" href="#476">476</a> <a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a> := <a class="d intelliWindow-symbol" href="#l_suites_by_path" data-definition-place="defined-in-file">l_suites_by_path</a>.<a href="/source/s?defs=prior" class="intelliWindow-symbol" data-definition-place="undefined-in-file">prior</a>(<a href="/source/s?defs=l_suite_path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite_path</a>); 485*eeb7e5b3SAdam Hornáček<a class="l" name="477" href="#477">477</a> <b>end</b> <a href="/source/s?defs=loop" class="intelliWindow-symbol" data-definition-place="undefined-in-file">loop</a>; 486*eeb7e5b3SAdam Hornáček<a class="l" name="478" href="#478">478</a> <a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a href="/source/s?defs=debug_log" class="intelliWindow-symbol" data-definition-place="undefined-in-file">debug_log</a>(<a href="/source/s?defs=l_result" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_result</a>.<b>count</b>||<span class="s">' root suites created.'</span>); 487*eeb7e5b3SAdam Hornáček<a class="l" name="479" href="#479">479</a> <b>return</b> <a href="/source/s?defs=l_result" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_result</a>; 488*eeb7e5b3SAdam Hornáček<a class="hl" name="480" href="#480">480</a> <b>end</b>; 489*eeb7e5b3SAdam Hornáček<a class="l" name="481" href="#481">481</a> 490*eeb7e5b3SAdam Hornáček<a class="l" name="482" href="#482">482</a> <b>function</b> <a class="xf" name="build_suites"/><a href="/source/s?refs=build_suites" class="xf intelliWindow-symbol" data-definition-place="def">build_suites</a>(<a href="/source/s?defs=a_annotated_objects" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_annotated_objects</a> <a href="/source/s?defs=sys_refcursor" class="intelliWindow-symbol" data-definition-place="undefined-in-file">sys_refcursor</a>) <b>return</b> <a href="/source/s?defs=t_schema_suites_info" class="intelliWindow-symbol" data-definition-place="undefined-in-file">t_schema_suites_info</a> <b>is</b> 491*eeb7e5b3SAdam Hornáček<a class="l" name="483" href="#483">483</a> <a class="xl" name="l_suite"/><a href="/source/s?refs=l_suite" class="xl intelliWindow-symbol" data-definition-place="def">l_suite</a> <a href="/source/s?defs=ut_logical_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_logical_suite</a>; 492*eeb7e5b3SAdam Hornáček<a class="l" name="484" href="#484">484</a> <a class="xl" name="l_annotated_objects"/><a href="/source/s?refs=l_annotated_objects" class="xl intelliWindow-symbol" data-definition-place="def">l_annotated_objects</a> <a href="/source/s?defs=ut_annotated_objects" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_annotated_objects</a>; 493*eeb7e5b3SAdam Hornáček<a class="l" name="485" href="#485">485</a> <a class="xl" name="l_all_suites"/><a href="/source/s?refs=l_all_suites" class="xl intelliWindow-symbol" data-definition-place="def">l_all_suites</a> <a href="/source/s?defs=tt_schema_suites" class="intelliWindow-symbol" data-definition-place="undefined-in-file">tt_schema_suites</a>; 494*eeb7e5b3SAdam Hornáček<a class="l" name="486" href="#486">486</a> <a class="xl" name="l_result"/><a href="/source/s?refs=l_result" class="xl intelliWindow-symbol" data-definition-place="def">l_result</a> <a href="/source/s?defs=t_schema_suites_info" class="intelliWindow-symbol" data-definition-place="undefined-in-file">t_schema_suites_info</a>; 495*eeb7e5b3SAdam Hornáček<a class="l" name="487" href="#487">487</a> <b>begin</b> 496*eeb7e5b3SAdam Hornáček<a class="l" name="488" href="#488">488</a> <b>fetch</b> <a href="/source/s?defs=a_annotated_objects" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_annotated_objects</a> <a href="/source/s?defs=bulk" class="intelliWindow-symbol" data-definition-place="undefined-in-file">bulk</a> <b>collect</b> <b>into</b> <a class="d intelliWindow-symbol" href="#l_annotated_objects" data-definition-place="defined-in-file">l_annotated_objects</a>; 497*eeb7e5b3SAdam Hornáček<a class="l" name="489" href="#489">489</a> <b>close</b> <a href="/source/s?defs=a_annotated_objects" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_annotated_objects</a>; 498*eeb7e5b3SAdam Hornáček<a class="hl" name="490" href="#490">490</a> 499*eeb7e5b3SAdam Hornáček<a class="l" name="491" href="#491">491</a> <b>for</b> <a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a> <b>in</b> <span class="n">1</span> .. <a class="d intelliWindow-symbol" href="#l_annotated_objects" data-definition-place="defined-in-file">l_annotated_objects</a>.<b>count</b> <a href="/source/s?defs=loop" class="intelliWindow-symbol" data-definition-place="undefined-in-file">loop</a> 500*eeb7e5b3SAdam Hornáček<a class="l" name="492" href="#492">492</a> <a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a> := <a class="d intelliWindow-symbol" href="#create_suite" data-definition-place="defined-in-file">create_suite</a>(<a class="d intelliWindow-symbol" href="#l_annotated_objects" data-definition-place="defined-in-file">l_annotated_objects</a>(<a href="/source/s?defs=i" class="intelliWindow-symbol" data-definition-place="undefined-in-file">i</a>)); 501*eeb7e5b3SAdam Hornáček<a class="l" name="493" href="#493">493</a> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a> <a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a> <b>is</b> <b>not</b> <b>null</b> <b>then</b> 502*eeb7e5b3SAdam Hornáček<a class="l" name="494" href="#494">494</a> <a class="d intelliWindow-symbol" href="#l_all_suites" data-definition-place="defined-in-file">l_all_suites</a>(<a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a>.<a href="/source/s?defs=path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">path</a>) := <a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a>; 503*eeb7e5b3SAdam Hornáček<a class="l" name="495" href="#495">495</a> <a href="/source/s?defs=l_result" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_result</a>.<a href="/source/s?defs=suite_paths" class="intelliWindow-symbol" data-definition-place="undefined-in-file">suite_paths</a>(<a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a>.<a href="/source/s?defs=object_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">object_name</a>) := <a href="/source/s?defs=l_suite" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_suite</a>.<a href="/source/s?defs=path" class="intelliWindow-symbol" data-definition-place="undefined-in-file">path</a>; 504*eeb7e5b3SAdam Hornáček<a class="l" name="496" href="#496">496</a> <b>end</b> <a href="/source/s?defs=if" class="intelliWindow-symbol" data-definition-place="undefined-in-file">if</a>; 505*eeb7e5b3SAdam Hornáček<a class="l" name="497" href="#497">497</a> <b>end</b> <a href="/source/s?defs=loop" class="intelliWindow-symbol" data-definition-place="undefined-in-file">loop</a>; 506*eeb7e5b3SAdam Hornáček<a class="l" name="498" href="#498">498</a> 507*eeb7e5b3SAdam Hornáček<a class="l" name="499" href="#499">499</a> <span class="c">--build hierarchical structure of the suite</span> 508*eeb7e5b3SAdam Hornáček<a class="hl" name="500" href="#500">500</a> <span class="c">-- Restructure single-dimension list into hierarchy of suites by the value of %suitepath attribute value</span> 509*eeb7e5b3SAdam Hornáček<a class="l" name="501" href="#501">501</a> <a href="/source/s?defs=l_result" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_result</a>.<a href="/source/s?defs=schema_suites" class="intelliWindow-symbol" data-definition-place="undefined-in-file">schema_suites</a> := <a class="d intelliWindow-symbol" href="#build_suites_hierarchy" data-definition-place="defined-in-file">build_suites_hierarchy</a>(<a class="d intelliWindow-symbol" href="#l_all_suites" data-definition-place="defined-in-file">l_all_suites</a>); 510*eeb7e5b3SAdam Hornáček<a class="l" name="502" href="#502">502</a> 511*eeb7e5b3SAdam Hornáček<a class="l" name="503" href="#503">503</a> <b>return</b> <a href="/source/s?defs=l_result" class="intelliWindow-symbol" data-definition-place="undefined-in-file">l_result</a>; 512*eeb7e5b3SAdam Hornáček<a class="l" name="504" href="#504">504</a> <b>end</b>; 513*eeb7e5b3SAdam Hornáček<a class="l" name="505" href="#505">505</a> 514*eeb7e5b3SAdam Hornáček<a class="l" name="506" href="#506">506</a> <b>function</b> <a class="xf" name="build_schema_suites"/><a href="/source/s?refs=build_schema_suites" class="xf intelliWindow-symbol" data-definition-place="def">build_schema_suites</a>(<a href="/source/s?defs=a_owner_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_owner_name</a> <a href="/source/s?defs=varchar2" class="intelliWindow-symbol" data-definition-place="undefined-in-file">varchar2</a>) <b>return</b> <a href="/source/s?defs=t_schema_suites_info" class="intelliWindow-symbol" data-definition-place="undefined-in-file">t_schema_suites_info</a> <b>is</b> 515*eeb7e5b3SAdam Hornáček<a class="l" name="507" href="#507">507</a> <a class="xl" name="l_annotations_cursor"/><a href="/source/s?refs=l_annotations_cursor" class="xl intelliWindow-symbol" data-definition-place="def">l_annotations_cursor</a> <a href="/source/s?defs=sys_refcursor" class="intelliWindow-symbol" data-definition-place="undefined-in-file">sys_refcursor</a>; 516*eeb7e5b3SAdam Hornáček<a class="l" name="508" href="#508">508</a> <b>begin</b> 517*eeb7e5b3SAdam Hornáček<a class="l" name="509" href="#509">509</a> <span class="c">-- form the single-dimension list of suites constructed from parsed packages</span> 518*eeb7e5b3SAdam Hornáček<a class="hl" name="510" href="#510">510</a> <b>open</b> <a class="d intelliWindow-symbol" href="#l_annotations_cursor" data-definition-place="defined-in-file">l_annotations_cursor</a> <b>for</b> 519*eeb7e5b3SAdam Hornáček<a class="l" name="511" href="#511">511</a> <a href="/source/s?defs=q" class="intelliWindow-symbol" data-definition-place="undefined-in-file">q</a><span class="s">'[select value(x) 520*eeb7e5b3SAdam Hornáček<a class="l" name="512" href="#512">512</a> from table( 521*eeb7e5b3SAdam Hornáček<a class="l" name="513" href="#513">513</a> ]'</span>||<a class="d intelliWindow-symbol" href="#ut_utils" data-definition-place="defined-in-file">ut_utils</a>.<a href="/source/s?defs=ut_owner" class="intelliWindow-symbol" data-definition-place="undefined-in-file">ut_owner</a>||<a href="/source/s?defs=q" class="intelliWindow-symbol" data-definition-place="undefined-in-file">q</a><span class="s">'[.ut_annotation_manager.get_annotated_objects(:a_owner_name, '</span><a href="/source/s?defs=PACKAGE" class="intelliWindow-symbol" data-definition-place="undefined-in-file">PACKAGE</a><span class="s">') 522*eeb7e5b3SAdam Hornáček<a class="l" name="514" href="#514">514</a> )x ]'</span> 523*eeb7e5b3SAdam Hornáček<a class="l" name="515" href="#515">515</a> <b>using</b> <a href="/source/s?defs=a_owner_name" class="intelliWindow-symbol" data-definition-place="undefined-in-file">a_owner_name</a>; 524*eeb7e5b3SAdam Hornáček<a class="l" name="516" href="#516">516</a> 525*eeb7e5b3SAdam Hornáček<a class="l" name="517" href="#517">517</a> <b>return</b> <a class="d intelliWindow-symbol" href="#build_suites" data-definition-place="defined-in-file">build_suites</a>(<a class="d intelliWindow-symbol" href="#l_annotations_cursor" data-definition-place="defined-in-file">l_annotations_cursor</a>); 526*eeb7e5b3SAdam Hornáček<a class="l" name="518" href="#518">518</a> <b>end</b>; 527*eeb7e5b3SAdam Hornáček<a class="l" name="519" href="#519">519</a> 528*eeb7e5b3SAdam Hornáček<a class="hl" name="520" href="#520">520</a><b>end</b> <a class="d intelliWindow-symbol" href="#ut_suite_builder" data-definition-place="defined-in-file">ut_suite_builder</a>; 529*eeb7e5b3SAdam Hornáček<a class="l" name="521" href="#521">521</a>/ 530*eeb7e5b3SAdam Hornáček<a class="l" name="522" href="#522">522</a><span class="c">/*<a href="http://example.com">http://example.com</a>.*/</span> 531*eeb7e5b3SAdam Hornáček<a class="l" name="523" href="#523">523</a><span class="c">/* comment /* comment */ 532*eeb7e5b3SAdam Hornáček<a class="l" name="524" href="#524">524</a>comment 533*eeb7e5b3SAdam Hornáček<a class="l" name="525" href="#525">525</a>*/</span> 534*eeb7e5b3SAdam Hornáček<a class="l" name="526" href="#526">526</a></body> 535*eeb7e5b3SAdam Hornáček</html> 536