APPS.PON_SGD_PKG dependencies on DUAL

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

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

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

403:
404: L_O_CTR := L_O_CTR + 1;
405: END LOOP;
406:
407: l_op := ' select XMLConcat(' || l_sql || ') from dual';
408: execute immediate l_op into l_uda_xml;
409:
410: RETURN (l_uda_xml);
411: END;

Line 464: select '' into clob_addr from dual;

460: begin
461: execute immediate l_sql into clob_addr using p_auction_header_id,p_line_id,l_attr_grp_id ;
462: exception
463: when others then
464: select '' into clob_addr from dual;
465: end;
466: end if;
467: return(clob_addr);
468: END get_shipaddressxml;

Line 546: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';

542: ) diff;
543: ELSE
544: --if document_type or entity_name is not passed, then we have to pass empty xml instead of null
545: --becasue getClobVal() on this return XML is used, if it is null getClobVal() function will error out.
546: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';
547: execute immediate l_sql_stmt into l_finalXML;
548: END IF;
549:
550: RETURN l_finalXML;

Line 684: INTO l_finalXML from dual;

680: XMLElement("mod_id", r_change.mod_value),
681: XMLElement("orig_value", r_change.orig_value_desc),
682: XMLElement("mod_value", r_change.mod_value_desc),
683: XMLElement("printable_pks", fnd_message.get_string('PON', 'PON_FED_AMEND_LINE_TITLE_MSG') || ' ' || rollup_pk )))
684: INTO l_finalXML from dual;
685: END LOOP;
686: ELSE
687: --if document_type or entity_name is not passed, then we have to pass empty xml instead of null
688: --becasue getClobVal() on this return XML is used, if it is null getClobVal() function will error out.

Line 689: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';

685: END LOOP;
686: ELSE
687: --if document_type or entity_name is not passed, then we have to pass empty xml instead of null
688: --becasue getClobVal() on this return XML is used, if it is null getClobVal() function will error out.
689: l_sql_stmt := 'select XMLConcat(' || l_sql_stmt || ') from dual';
690: execute immediate l_sql_stmt into l_finalXML;
691: END IF;
692:
693: RETURN l_finalXML;