APPS.PO_DATATEMPLATE_PKG dependencies on DUAL

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

333: ' and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
334: L_O_CTR := L_O_CTR + 1;
335: END LOOP;
336:
337: l_op := ' select XMLConcat(' || l_sql || ') from dual';
338: execute immediate l_op into l_uda_xml;
339: RETURN (l_uda_xml);
340: END GET_UDA_HEADER_XML_PVT;
341:

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

433: || ' and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
434: L_O_CTR := L_O_CTR + 1;
435: END LOOP;
436:
437: l_op := ' select XMLConcat(' || l_sql || ') from dual';
438: execute immediate l_op into l_uda_xml;
439: RETURN (l_uda_xml);
440:
441: end get_uda_llxml_pvt;

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

533: ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID || ')' ;
534: L_O_CTR := L_O_CTR + 1;
535: END LOOP;
536:
537: l_op := ' select XMLConcat(' || l_sql || ') from dual';
538: execute immediate l_op into l_uda_xml;
539: RETURN (l_uda_xml);
540: end get_uda_line_xml_pvt;
541:

Line 764: from dual;

760: execute immediate l_sql into clob_addr using p_line_location_id, p_draft_id,l_attr_grp_id ;
761: exception
762: when others then
763: select '' into clob_addr
764: from dual;
765: end;
766: end if;
767: return(clob_addr);
768: end get_shipaddressxml_pvt;

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

780: FUNCTION get_vendor_address_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB AS
781: v_clob_addr CLOB;
782: BEGIN
783: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
784: 'SUPPLIER_DTLS', NULL, 'HIDD_ADDRS_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;
785:
786: RETURN v_clob_addr;
787: END get_vendor_address_details;
788:

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

789: FUNCTION get_vendor_contact_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB AS
790: v_clob_addr CLOB;
791: BEGIN
792: SELECT PO_UDA_PUB.GET_SINGLE_ATTR_VALUE(uda_template_id, NULL, p_header_id, p_draft_id, NULL, NULL, NULL, NULL,
793: 'SUPPLIER_DTLS', NULL, 'HIDD_CNTCT_XML', 'INTERNAL_VALUE') INTO v_clob_addr FROM dual;
794:
795: RETURN v_clob_addr;
796: END get_vendor_contact_details;
797: