APPS.PON_DATATEMPLATE_PKG dependencies on DUAL

Line 144: l_op := ' select XMLConcat(' || l_sql || ') from dual';

140:
141: L_O_CTR := L_O_CTR + 1;
142: END LOOP;
143:
144: l_op := ' select XMLConcat(' || l_sql || ') from dual';
145: execute immediate l_op into l_uda_xml;
146:
147: RETURN (l_uda_xml);
148: END;

Line 298: l_op := ' select XMLConcat(' || l_sql || ') from dual';

294:
295: L_O_CTR := L_O_CTR + 1;
296: END LOOP;
297:
298: l_op := ' select XMLConcat(' || l_sql || ') from dual';
299: execute immediate l_op into l_uda_xml;
300:
301: RETURN (l_uda_xml);
302: END;

Line 486: select '' into clob_addr from dual;

482: begin
483: execute immediate l_sql into clob_addr using p_auction_header_id,p_line_id,l_attr_grp_id ;
484: exception
485: when others then
486: select '' into clob_addr from dual;
487: end;
488: end if;
489: return(clob_addr);
490: end get_shipaddressxml;