DBA Data[Home] [Help]

APPS.PO_XML_FPDSNG_PKG dependencies on XMLTYPE

Line 131: RETURN XMLType IS

127: return(l_sql);
128: end get_uda_attr_desc_sql;
129:
130: FUNCTION GET_UDA_HEADER_XML_PVT(p_headerId number, p_draft_id number)
131: RETURN XMLType IS
132: CURSOR C_ATTR_GRP IS
133: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
134: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
135: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 172: l_uda_xml XMLTYPE;

168: L_OP VARCHAR2(32767);
169: L_ATTR_GRP NUMBER;
170: L_CTR NUMBER;
171: L_O_CTR NUMBER;
172: l_uda_xml XMLTYPE;
173: BEGIN
174:
175: L_O_CTR := 0;
176: FOR REC IN C_ATTR_GRP LOOP

Line 230: FUNCTION GET_UDA_HEADER_XML RETURN XMLType IS

226: RETURN (l_uda_xml);
227: END GET_UDA_HEADER_XML_PVT;
228:
229:
230: FUNCTION GET_UDA_HEADER_XML RETURN XMLType IS
231: begin
232: return(get_uda_header_xml_pvt(headerId, -1));
233: END GET_UDA_HEADER_XML;
234:

Line 235: FUNCTION GET_UDA_HEADER_DRAFTS_XML(p_headerid NUMBER) RETURN XMLType IS

231: begin
232: return(get_uda_header_xml_pvt(headerId, -1));
233: END GET_UDA_HEADER_XML;
234:
235: FUNCTION GET_UDA_HEADER_DRAFTS_XML(p_headerid NUMBER) RETURN XMLType IS
236: begin
237: return(get_uda_header_xml_pvt(p_headerid, p_draft_id));
238: END GET_UDA_HEADER_DRAFTS_XML;
239: