set define '^' set verify off prompt ...wwv_speling create or replace package body wwv_speling wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 9200000 1 4 0 125 2 :e: 1PACKAGE: 1BODY: 1WWV_SPELING: 1IGNORE_WORD: 1CONSTANT: 1BINARY_INTEGER: 1-: 11: 1VALID: 10: 1NOT_FOUND: 1DUP_ENTRY: 12: 1BUTTON_DONE: 1VARCHAR2: 1255: 1WWV_FLOW_LANG: 1SYSTEM_MESSAGE: 1wwv_speling.button_done: 1BUTTON_CANCEL: 1wwv_speling.button_cancel: 1BUTTON_APPLY_CHANGES: 1wwv_speling.button_apply_changes: 1BUTTON_ADD_TO_DICTIONARY: 1wwv_speling.button_add_to_dictionary: 1TYPE: 1SPELL_REC: 1RECORD: 1WORD: 14000: 1LEN: 1IDX: 1STATUS: 1SPELL_ARR: 1FUNCTION: 1ITE: 1B: 1BOOLEAN: 1T: 1F: 1RETURN: 1URLENCODE: 1P_STR: 1L_TMP: 112000: 1L_LEN: 1NUMBER: 1LENGTH: 1L_BAD: 1100: 1 >%}\~];?@&<#{|^[`/::=$+'": 1||: 1CHR: 110: 1L_CHAR: 1CHAR: 1IS NULL: 1I: 1LOOP: 1SUBSTR: 1INSTR: 1>: 1%: 1TO_CHAR: 1ASCII: 1fm0X: 1WRITE_SCRIPT_OPEN: 1HTP: 1P: 1: 1WRITE_GLOBAL_VARS_JS: 1:nvar fieldName;:nvar headerProc;:nvar footerProc;:nvar searchType;:n: 1WRITE_SET_UP_SUBMIT_JS: 1:n document.forms[0].p_text.value = eval( "parent.opener." + parent.opener.f+ 1ieldName ).value;:n document.forms[0].p_field_name.value = parent.window.ope+ 1ner.fieldName;:n document.forms[0].p_search_type.value = parent.window.opene+ 1r.searchType;:n document.forms[0].p_header_proc.value = parent.window.opener+ 1.headerProc;:n document.forms[0].p_footer_proc.value = parent.window.opener.+ 1footerProc;:n: 1WRITE_NEWSPELWINDOW_JS: 1P_HEADER_PROC: 1P_FOOTER_PROC: 1P_WINDOW_HEIGHT: 1500: 1P_WINDOW_WIDTH: 1600: 1:nfunction newSpelWindow( field, sType, s, u, l ):n{:n fieldName = field;:n+ 1 searchType = sType;:n headerProc = ": 1";:n footerProc = ": 1";:n:n f = eval( field );:n w = open( "wwv_speling.correction_window?p_sg+ 1id="+s+"&p_user="+u+"&p_lang="+l,:n "SpelWin" + f.name,:n "scrollbars=1+ 1,resizable=1,width=: 1,height=: 1" );:n if ( w.opener == null ):n w.opener = self;:n w.focus();:n}:n: 1WRITE_APPLYSPELINGCHANGES_JS: 1:nfunction applySpelingChanges( field, value ):n{:n f = eval( field );:n f.+ 1value = value;:n f.focus();:n}:n: 1WRITE_CHECKADDNEW_JS: 1:nfunction checkAddNew( f ):n{:n if ( !(f.selectedIndex) ):n {:n newWord+ 1 = prompt( ": 1wwv_speling.enter_new_word: 1", "" );:n if ( newWord != null && newWord != "" ):n {:n o = new O+ 1ption( newWord );:n f.options[f.length] = o;:n f.selectedIndex = f.+ 1length-1;:n }:n }:n}:n: 1WRITE_POPWORDCHOICE_JS: 1:nfunction popWordChoice( field, s, u, l ):n{f = eval( field ); w = open( "ww+ 1v_speling.small_correction_window" +:n "?p_field_name=" + field +:n + 1 "&p_text=" + f.value+"&p_sgid="+s+"&p_user="+u+"&p_lang="+l,:n "Small+ 1SpelWin" + f.name,:n "scrollbars=1,resizable=1,width=325,height=150" );:n + 1 if ( w.opener == null ):n w.opener = self;:n w.focus();:n}:n: 1WRITE_ADD_DICTIONARY_ENTRY_JS: 1:nfunction addDictionaryEntry( word ):n{:n window.hidden_frame.document.fo+ 1rms[0].p_word.value = word;:n window.hidden_frame.document.forms[0].submit+ 1();:n}:n: 1BUILD_ERR_LIST: 1P_SGID: 1P_USER: 1P_LANG: 1L_START: 1L_END: 1L_WORD: 1L_CNT: 1L_IDX: 1L_SPELL_ARR: 1L_SPECIAL: 10123456789!@#$%^&*()_-+={[}]|\"::;?/>.<,: 1L_PUNCTUATION: 1.?!::;-: 1 : 1+: 1EXIT: 1=: 1!=: 1IS NOT NULL: 1NVL: 1REPLACE: 1TRANSLATE: 1RPAD: 1@: 1: 1COUNT: 1DUAL: 1WWV_FLOW_DICTIONARY$: 1WORDS: 1LANGUAGE: 1OWNER: 1WORDS_CAPITALIZED: 1DECODE: 1UPPER: 1LOWER: 1SECURITY_GROUP_ID: 1SELECT count(*):n into l_cnt:n from dual:n wh+ 1ere exists( select null:n from wwv_flow_dictionary$+ 1:n where words = l_word :n + 1 and language = p_lang:n and owner = 'PUBLIC' ):n+ 1 or exists( select null:n from wwv_flo+ 1w_dictionary$:n where words_capitalized = decode( l_+ 1word, upper( l_word ), :n + 1upper( substr( l_word, 1, 1 ) ) || lower( substr( l_word, 2 ) ),:n + 1 l_word ):n + 1 and language = p_lang:n and owner = 'PUBLIC' ):n+ 1 or exists( select null:n from wwv_flo+ 1w_dictionary$:n where words = l_word :n + 1 and language = p_lang:n and owner =+ 1 p_user:n and security_group_id = p_sgid ):n + 1 or exists( select null:n from wwv_flow_dict+ 1ionary$:n where words_capitalized = decode( l_word, + 1upper( l_word ), :n upper(+ 1 substr( l_word, 1, 1 ) ) || lower( substr( l_word, 2 ) ),:n + 1 l_word ):n and + 1language = p_lang:n and owner = p_user:n + 1 and security_group_id = p_sgid ): 1ELSIF: 1SHOW_CORRECTIONS: 1P_TEXT: 1P_FIELD_NAME: 1P_SPELL_ARR: 1P_SEARCH_TYPE: 1L_TXT: 1LONG: 1FORMOPEN: 1wwv_speling.accept_corrections: 1FORMHIDDEN: 1p_field_name: 1p_text: 1HTF: 1ESCAPE_SC: 1p_words: 1p_lens: 1p_idxs: 1PRN: 113: 1
: 1SELECT_LIST: 1FORMSELECTOPEN: 1CATTRIBUTES: 1onChange="checkAddNew(this)": 1