APPS.CCT_VALIDATION_PUB dependencies on DUAL

Line 241: select LENGTH(l_temp1) into l_length from DUAL;

237: ELSIF l_temp1 is NULL THEN
238: --x_msg_data := 'l_temp1 is empty2';
239: NULL;
240: ELSE
241: select LENGTH(l_temp1) into l_length from DUAL;
242: LOOP
243:
244: IF l_length < l_begPos THEN EXIT;
245: END IF;

Line 248: select INSTR(l_temp1, l_comma_str , l_begPos, 1) into l_endPos from DUAL;

244: IF l_length < l_begPos THEN EXIT;
245: END IF;
246:
247: l_comma_str := ',';
248: select INSTR(l_temp1, l_comma_str , l_begPos, 1) into l_endPos from DUAL;
249:
250: IF l_endPos = 0 THEN
251: select SUBSTR(l_temp1, l_begPos) into l_currVal from DUAL;
252: IF l_currVal is NULL THEN

Line 251: select SUBSTR(l_temp1, l_begPos) into l_currVal from DUAL;

247: l_comma_str := ',';
248: select INSTR(l_temp1, l_comma_str , l_begPos, 1) into l_endPos from DUAL;
249:
250: IF l_endPos = 0 THEN
251: select SUBSTR(l_temp1, l_begPos) into l_currVal from DUAL;
252: IF l_currVal is NULL THEN
253: x_err_msgs.EXTEND;
254: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
255: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)

Line 290: select SUBSTR(l_temp1, l_begPos, l_endPos - l_begPos) into l_currVal from DUAL;

286: --dbms_output.put_line('l_endPos: ' || l_endPos);
287: --dbms_output.put_line('l_currVal: ' || l_currVal);
288: EXIT;
289: ELSE
290: select SUBSTR(l_temp1, l_begPos, l_endPos - l_begPos) into l_currVal from DUAL;
291: IF l_currVal is NULL THEN
292: x_err_msgs.EXTEND;
293: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
294: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)

Line 422: select INSTR(l_temp, l_mw_param, 1, 1) into l_endPos from DUAL;

418: FOR i IN l_rp_params.first..l_rp_params.last LOOP
419: l_temp := l_rp_params(i);
420: --dbms_output.put_line('Checking route point:' || l_temp || ' with mwconfig:' || l_mw_param);
421: -- 1) Check if route point selected is namespaced with the same mw config
422: select INSTR(l_temp, l_mw_param, 1, 1) into l_endPos from DUAL;
423: IF l_endPos = 0 THEN
424: --dbms_output.put_line('route pt and mw do not matched!!! rp param:' || l_rp_param_pos);
425: x_err_msgs.EXTEND;
426: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';