APPS.ICX_DATATEMPLATE_PKG dependencies on XMLTYPE

Line 71: FUNCTION GET_UDA_HEADER_XML RETURN XMLType IS

67: return(l_sql);
68: end get_uda_attr_desc_sql;
69:
70:
71: FUNCTION GET_UDA_HEADER_XML RETURN XMLType IS
72: CURSOR C_ATTR_GRP IS
73: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
74: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
75: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 110: l_uda_xml XMLTYPE;

106: L_OP VARCHAR2(32767);
107: L_ATTR_GRP NUMBER;
108: L_CTR NUMBER;
109: L_O_CTR NUMBER;
110: l_uda_xml XMLTYPE;
111: BEGIN
112:
113: L_O_CTR := 0;
114: FOR REC IN C_ATTR_GRP LOOP

Line 426: l_uda_xml XMLTYPE;

422: l_attr_grp_id number;
423: l_amount number;
424: l_op VARCHAR2(1000);
425: l_xml_sql varchar2(500) := '';
426: l_uda_xml XMLTYPE;
427: cnt NUMBER;
428: c_auth SYS_REFCURSOR;
429: l_funds_info VARCHAR2(20);
430:

Line 480: l_acc_xml XMLTYPE;

476:
477: l_reimbursement_flag varchar2(1) := 'N';
478: l_direct_citation_flag varchar2(1) := 'N';
479: l_both_flag varchar2(1):= 'N';
480: l_acc_xml XMLTYPE;
481: l_count number;
482: l_obligation_type varchar2(20);
483: l_sql VARCHAR2(1000);
484: