APPS.CSI_GIS_INSTANCE_LOC_UTL_PKG dependencies on DUAL

Line 83: FROM DUAL;

79: AND NVL(cii.maintainable_flag,'Y') = 'Y'
80: AND cii.instance_id = p_instance_id
81: ),'CSE' )
82: INTO l_instance_type
83: FROM DUAL;
84:
85: csi_t_gen_utility_pvt.add( 'Instance Type:'||l_instance_type);
86:
87: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 179: FROM DUAL;

175: l_length := LENGTH(l_value);
176:
177: SELECT decode(substr(l_value,l_length),'N','N','S','S','E','E','W','W','A')
178: INTO l_direction
179: FROM DUAL;
180:
181: SELECT decode(substr(l_value,1,1),'+','+','-','-','+')
182: INTO l_sign
183: FROM DUAL;

Line 183: FROM DUAL;

179: FROM DUAL;
180:
181: SELECT decode(substr(l_value,1,1),'+','+','-','-','+')
182: INTO l_sign
183: FROM DUAL;
184:
185: IF p_geocode_format = 'DMS' THEN
186: IF l_direction = 'S' AND instr(substr(l_value,1,l_length-1),'S') = 0 THEN
187: l_direction := 'A';

Line 334: FROM DUAL;

330: BEGIN
331:
332: SELECT to_number(nvl(substr(l_value,1,l_d_pos-1),-1))
333: INTO l_degrees
334: FROM DUAL;
335:
336: IF l_degrees - Trunc(l_degrees) > 0 THEN
337: RAISE Invalid_Decimal;
338: END IF;

Line 382: FROM DUAL;

378: BEGIN
379:
380: SELECT to_number(nvl(substr(l_value,l_d_pos+1,(l_m_pos-l_d_pos-1)),-1))
381: INTO l_minutes
382: FROM DUAL;
383:
384: IF p_geocode_format = 'DMS' THEN
385: IF l_minutes - Trunc(l_minutes) > 0 THEN
386: RAISE Invalid_Decimal;

Line 433: FROM DUAL;

429: BEGIN
430:
431: SELECT to_number(nvl(substr(l_value,l_m_pos+1,(l_s_pos-l_m_pos-1)),-1))
432: INTO l_seconds
433: FROM DUAL;
434:
435: IF l_seconds < 0 OR l_seconds > 59 THEN
436: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_SECONDS_VALUE');
437: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

Line 509: FROM DUAL;

505: l_longitude_length:= LENGTH(l_longitude);
506:
507: SELECT decode(substr(l_latitude,1,1),'+','+','-','-','+'),decode(substr(l_longitude,1,1),'+','+','-','-','+')
508: INTO l_latitude_sign,l_longitude_sign
509: FROM DUAL;
510:
511: /* Get the direction*/
512: SELECT decode(substr(l_latitude,l_latitude_length),'N','N','S','S','E','E','W','W','A')
513: ,decode(substr(l_longitude,l_longitude_length),'N','N','S','S','E','E','W','W','A')

Line 516: FROM DUAL;

512: SELECT decode(substr(l_latitude,l_latitude_length),'N','N','S','S','E','E','W','W','A')
513: ,decode(substr(l_longitude,l_longitude_length),'N','N','S','S','E','E','W','W','A')
514: INTO l_latitude_direction
515: ,l_longitude_direction
516: FROM DUAL;
517:
518: IF p_geocode_format = 'DMS' THEN
519: IF l_latitude_direction = 'S' AND instr(substr(l_latitude,1,l_latitude_length-1),'S') = 0 THEN
520: l_latitude_direction := 'A';

Line 532: FROM DUAL;

528:
529: BEGIN
530: SELECT to_number(l_latitude)
531: INTO l_latitude_value
532: FROM DUAL;
533: EXCEPTION
534: WHEN INVALID_NUMBER THEN
535: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_DD_VALUE');
536: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

Line 544: FROM DUAL;

540: END;
541: BEGIN
542: SELECT to_number(l_longitude)
543: INTO l_longitude_value
544: FROM DUAL;
545: EXCEPTION
546: WHEN INVALID_NUMBER THEN
547: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LONG_DD_VALUE');
548: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);