APPS.OKC_CDRL_DT_PKG dependencies on XMLTYPE

Line 57: RETURN XMLType IS

53: return(l_sql);
54: end get_uda_attr_desc_sql;
55:
56: FUNCTION GET_UDA_XML(p_delId number, p_uda_template_id number)
57: RETURN XMLType IS
58: CURSOR C_ATTR_GRP IS
59: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
60: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
61: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,

Line 90: l_uda_xml XMLTYPE;

86: L_OP VARCHAR2(32767);
87: L_ATTR_GRP NUMBER;
88: L_CTR NUMBER;
89: L_O_CTR NUMBER;
90: l_uda_xml XMLTYPE;
91: BEGIN
92:
93: L_O_CTR := 0;
94: FOR REC IN C_ATTR_GRP LOOP

Line 149: RETURN XMLType is

145: RETURN (l_uda_xml);
146: END GET_UDA_XML;
147:
148: FUNCTION GET_ADDR_UDA_XML(p_delId number, p_uda_template_id number)
149: RETURN XMLType is
150: cursor c_attr is
151: select attr_name, database_column
152: from ego_attrs_v
153: where attr_group_name = 'CDRL_DIST_ADDR';

Line 170: l_addr_xml XMLType;

166: t_dbcol tbl_var;
167: l_ctr number := 0;
168: l_delctr number :=0;
169: l_sql CLOB;
170: l_addr_xml XMLType;
171:
172: begin
173: open c_attr;
174: fetch c_attr bulk collect into t_attr, t_dbcol;