APPS.FEM_WEBADI_TABLES_UTILS_PVT dependencies on DUAL

Line 343: select 'Y' into l_integrator_exists from dual

339: end if;
340:
341: ---------------------- Checking if an integrator is already available for normal mode
342: begin
343: select 'Y' into l_integrator_exists from dual
344: where exists(select integrator_code from bne_integrators_b where
345: integrator_code = l_integrator_code);
346: exception
347: when NO_DATA_FOUND then null;

Line 389: select 'Y' into l_interface_exists from dual

385:
386: -------------------- creating an interface if its not available for the P_TABLE_NAME
387:
388: begin
389: select 'Y' into l_interface_exists from dual
390: where exists(select interface_code from bne_interfaces_b where
391: interface_code = l_object_code || '_INTF');
392: exception
393: when NO_DATA_FOUND then null;

Line 1990: select 'Y' into l_map_exists from dual

1986:
1987: begin
1988:
1989: begin
1990: select 'Y' into l_map_exists from dual
1991: where exists(select interface_table_name from FEM_WEBADI_TABLE_COLS_MAPS where
1992: interface_table_name = p_table_name);
1993: exception
1994: when NO_DATA_FOUND then null;

Line 2753: select to_number(l_column_value) into l_valid_number from dual;

2749: elsif(columns_values.data_type = 'DATE') then
2750: l_query_values := l_query_values || ',' || 'to_date(' || '''' ||l_column_value || '''' || ',' || '''' || l_adi_date_format || '''' || ')';
2751: else
2752: if(columns_values.data_type = 'NUMBER') then
2753: select to_number(l_column_value) into l_valid_number from dual;
2754: end if;
2755: l_query_values := l_query_values || ',' || '''' || l_column_value || '''';
2756: end if;
2757: