APPS.IEM_IM_TOKENS_WRAPPERS_PVT dependencies on DUAL

Line 33: SELECT INSTR(p_token_str, '', 1,1) INTO l_loc_t FROM DUAL;

29:
30: --DBMS_OUTPUT.PUT_LINE('NUMBER OF TOKENS := '||p_index);
31: IF (p_index > 0) THEN
32: WHILE (l_bool) LOOP
33: SELECT INSTR(p_token_str, '', 1,1) INTO l_loc_t FROM DUAL;
34: SELECT SUBSTR(p_token_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;
35:
36: -- Build table from token_str returned from OES.
37: SELECT l_work_str INTO l_token_tab1(l_count).TOKEN FROM DUAL;

Line 34: SELECT SUBSTR(p_token_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;

30: --DBMS_OUTPUT.PUT_LINE('NUMBER OF TOKENS := '||p_index);
31: IF (p_index > 0) THEN
32: WHILE (l_bool) LOOP
33: SELECT INSTR(p_token_str, '', 1,1) INTO l_loc_t FROM DUAL;
34: SELECT SUBSTR(p_token_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;
35:
36: -- Build table from token_str returned from OES.
37: SELECT l_work_str INTO l_token_tab1(l_count).TOKEN FROM DUAL;
38: --INSERT INTO IEM_TOKENS(MSGID, TOKEN) VALUES(p_msgid,l_work_str);

Line 37: SELECT l_work_str INTO l_token_tab1(l_count).TOKEN FROM DUAL;

33: SELECT INSTR(p_token_str, '', 1,1) INTO l_loc_t FROM DUAL;
34: SELECT SUBSTR(p_token_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;
35:
36: -- Build table from token_str returned from OES.
37: SELECT l_work_str INTO l_token_tab1(l_count).TOKEN FROM DUAL;
38: --INSERT INTO IEM_TOKENS(MSGID, TOKEN) VALUES(p_msgid,l_work_str);
39: l_count := l_count+1;
40: SELECT SUBSTR(p_token_str,l_loc_t+3) INTO l_token_str FROM DUAL;
41: p_token_str := l_token_str;

Line 40: SELECT SUBSTR(p_token_str,l_loc_t+3) INTO l_token_str FROM DUAL;

36: -- Build table from token_str returned from OES.
37: SELECT l_work_str INTO l_token_tab1(l_count).TOKEN FROM DUAL;
38: --INSERT INTO IEM_TOKENS(MSGID, TOKEN) VALUES(p_msgid,l_work_str);
39: l_count := l_count+1;
40: SELECT SUBSTR(p_token_str,l_loc_t+3) INTO l_token_str FROM DUAL;
41: p_token_str := l_token_str;
42: p_index := p_index-1;
43: IF (p_index < 1) THEN
44: l_bool := FALSE;