581: sql_stmt_str VARCHAR2(2000);
582: l_data_set_name VARCHAR2(40);
583: BEGIN
584:
585: l_data_set_name := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
586: IF (l_data_set_name = 'N' OR l_data_set_name IS NULL) THEN
587: l_data_set_name := ' ';
588: ELSE
589: l_data_set_name := fnd_profile.VALUE('CSF_EMAP_DATASET_NAME') ;
585: l_data_set_name := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
586: IF (l_data_set_name = 'N' OR l_data_set_name IS NULL) THEN
587: l_data_set_name := ' ';
588: ELSE
589: l_data_set_name := fnd_profile.VALUE('CSF_EMAP_DATASET_NAME') ;
590: IF (l_data_set_name = 'NONE' OR l_data_set_name IS NULL) THEN
591: l_data_set_name := ' ';
592: END IF;
593: END IF;
616: sql_stmt_str VARCHAR2(2000);
617: l_data_set_name VARCHAR2(40);
618: BEGIN
619:
620: l_data_set_name := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
621: IF (l_data_set_name = 'N' OR l_data_set_name IS NULL) THEN
622: l_data_set_name := ' ';
623: ELSE
624: l_data_set_name := p_dataset;