APPS.PO_XML_FPDSNG_PKG dependencies on DUAL

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

220: ' and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
221: L_O_CTR := L_O_CTR + 1;
222: END LOOP;
223:
224: l_op := ' select XMLConcat(' || l_sql || ') from dual';
225: execute immediate l_op into l_uda_xml;
226: RETURN (l_uda_xml);
227: END GET_UDA_HEADER_XML_PVT;
228:

Line 377: 'SUPPLIER_DTLS', NULL, 'HIDD_ADDRS_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;

373: FUNCTION get_vendor_address_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB AS
374: v_clob_addr CLOB;
375: BEGIN
376: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
377: 'SUPPLIER_DTLS', NULL, 'HIDD_ADDRS_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;
378:
379: RETURN v_clob_addr;
380: END get_vendor_address_details;
381:

Line 386: 'SUPPLIER_DTLS', NULL, 'HIDD_CNTCT_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;

382: FUNCTION get_vendor_contact_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB AS
383: v_clob_addr CLOB;
384: BEGIN
385: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
386: 'SUPPLIER_DTLS', NULL, 'HIDD_CNTCT_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;
387:
388: RETURN v_clob_addr;
389: END get_vendor_contact_details;
390: