APPS.HZ_EMAIL_DOMAINS_V2PUB dependencies on HZ_DQM_SEARCH_UTIL

Line 669: l_tok := HZ_DQM_SEARCH_UTIL.strtok(p_input_str,1,'.');

665: end if;
666:
667: l_leftover := p_input_str; -- = UK.ORACLE.TV
668: l_prev_tok := null;
669: l_tok := HZ_DQM_SEARCH_UTIL.strtok(p_input_str,1,'.');
670: -- UK
671: WHILE l_tok IS NOT NULL LOOP
672: BEGIN
673: SELECT 1 INTO tmp FROM AR_LOOKUPS WHERE

Line 685: l_tok := HZ_DQM_SEARCH_UTIL.strtok;

681: WHEN NO_DATA_FOUND THEN
682: l_prev_tok:=l_tok;
683:
684: l_leftover := replace(l_leftover,l_tok||'.');
685: l_tok := HZ_DQM_SEARCH_UTIL.strtok;
686:
687: END;
688: END LOOP;
689:

Line 791: l_tok := HZ_DQM_SEARCH_UTIL.strtok(treated_input_str,1,' ');

787:
788: -- build the return string by tokenization
789: -- tokenize the treated input string, with the delimiter
790: -- being a space.
791: l_tok := HZ_DQM_SEARCH_UTIL.strtok(treated_input_str,1,' ');
792:
793: -- cycle through the tokens and construct the return string
794: -- by appending the right part of the @ of each token
795: WHILE l_tok IS NOT NULL

Line 811: l_tok := HZ_DQM_SEARCH_UTIL.strtok;

807: and lookup_code = tempstr ;
808:
809: -- dbms_output.put_line('ISP validation fails');
810:
811: l_tok := HZ_DQM_SEARCH_UTIL.strtok;
812:
813: EXCEPTION
814: WHEN NO_DATA_FOUND THEN
815: retstr := retstr || ' '|| tempstr ;

Line 816: l_tok := HZ_DQM_SEARCH_UTIL.strtok;

812:
813: EXCEPTION
814: WHEN NO_DATA_FOUND THEN
815: retstr := retstr || ' '|| tempstr ;
816: l_tok := HZ_DQM_SEARCH_UTIL.strtok;
817: END;
818: END LOOP;
819:
820: -- final treatment to get rid of trailing/leading spaces, if any

Line 997: l_tok := HZ_DQM_SEARCH_UTIL.strtok(treated_input_str,1,' ');

993: END LOOP;
994:
995: -- build the return string by tokenization
996: -- with the delimiter being a space.
997: l_tok := HZ_DQM_SEARCH_UTIL.strtok(treated_input_str,1,' ');
998:
999: -- cycle through the tokens and construct the return string
1000: WHILE l_tok IS NOT NULL
1001: LOOP

Line 1004: l_tok := HZ_DQM_SEARCH_UTIL.strtok;

1000: WHILE l_tok IS NOT NULL
1001: LOOP
1002: extract_ext_and_segment(l_tok, x_first_seg, x_extension);
1003: retstr := retstr ||ltrim(x_first_seg||'.'||x_extension||' ','.');
1004: l_tok := HZ_DQM_SEARCH_UTIL.strtok;
1005: END LOOP;
1006:
1007: -- final treatment to get rid of trailing/leading spaces, if any
1008: retstr := ltrim(rtrim(retstr));