APPS.SR_UWQ_INTEG dependencies on DUAL

Line 931: select replace(s_sql_statement, to_char(p_resource_id),':OWNER_ID') into s_unbound_stat from dual;

927: l_node_count_view := l_node_detail_record.view_name;
928: end if;
929:
930: s_sql_statement := ' begin select count(1) into :n_count from '||l_node_count_view||' where '||l_node_detail_record.complete_where_clause||' ; end;';
931: select replace(s_sql_statement, to_char(p_resource_id),':OWNER_ID') into s_unbound_stat from dual;
932:
933: execute immediate s_unbound_stat
934: using out n_count, in p_resource_id;
935: sr_count := n_count;

Line 984: select cs_sr_uwq_nodes_s.nextval into l_node_id from dual;

980:
981: l_node_id :=0 ;
982: l_return_status := 'S';
983: if p_node_id is null OR p_node_id = -1 then
984: select cs_sr_uwq_nodes_s.nextval into l_node_id from dual;
985: else
986: l_node_id := p_node_id;
987: end if;
988:

Line 1311: v_sql_statement := ' begin select reverse(to_char('||p_parameter_value||')) into :v_transposed_phone_number from dual; end; ';

1307: p_parameter_value := 0;
1308: end if;
1309: p_parameter_value := nvl(p_parameter_value,0);
1310:
1311: v_sql_statement := ' begin select reverse(to_char('||p_parameter_value||')) into :v_transposed_phone_number from dual; end; ';
1312: execute immediate v_sql_statement
1313: using out v_transposed_phone_number;
1314:
1315: if p_param_action_val in ('CREATE_SR') then