APPS.CCT_VALIDATION_PUB dependencies on DUAL

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

245: ELSIF l_temp1 is NULL THEN
246: --x_msg_data := 'l_temp1 is empty2';
247: NULL;
248: ELSE
249: select LENGTH(l_temp1) into l_length from DUAL;
250: LOOP
251:
252: IF l_length < l_begPos THEN EXIT;
253: END IF;

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

252: IF l_length < l_begPos THEN EXIT;
253: END IF;
254:
255: l_comma_str := ',';
256: select INSTR(l_temp1, l_comma_str , l_begPos, 1) into l_endPos from DUAL;
257:
258: IF l_endPos = 0 THEN
259: select SUBSTR(l_temp1, l_begPos) into l_currVal from DUAL;
260: IF l_currVal is NULL THEN

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

255: l_comma_str := ',';
256: select INSTR(l_temp1, l_comma_str , l_begPos, 1) into l_endPos from DUAL;
257:
258: IF l_endPos = 0 THEN
259: select SUBSTR(l_temp1, l_begPos) into l_currVal from DUAL;
260: IF l_currVal is NULL THEN
261: x_err_msgs.EXTEND;
262: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
263: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)

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

294: --dbms_output.put_line('l_endPos: ' || l_endPos);
295: --dbms_output.put_line('l_currVal: ' || l_currVal);
296: EXIT;
297: ELSE
298: select SUBSTR(l_temp1, l_begPos, l_endPos - l_begPos) into l_currVal from DUAL;
299: IF l_currVal is NULL THEN
300: x_err_msgs.EXTEND;
301: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';
302: SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)

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

426: FOR i IN l_rp_params.first..l_rp_params.last LOOP
427: l_temp := l_rp_params(i);
428: --dbms_output.put_line('Checking route point:' || l_temp || ' with mwconfig:' || l_mw_param);
429: -- 1) Check if route point selected is namespaced with the same mw config
430: select INSTR(l_temp, l_mw_param, 1, 1) into l_endPos from DUAL;
431: IF l_endPos = 0 THEN
432: --dbms_output.put_line('route pt and mw do not matched!!! rp param:' || l_rp_param_pos);
433: x_err_msgs.EXTEND;
434: l_msg_code := 'CCT_PARAM_ERR_ITS_RP_MISMATCH';