APPS.OKC_SBCR_DT_PKG dependencies on XMLTYPE

Line 60: FUNCTION get_uda_single_attr_xml(p_contract_id NUMBER) RETURN XMLType IS

56:
57: RETURN(l_sql);
58: END get_uda_attr_desc_sql;
59:
60: FUNCTION get_uda_single_attr_xml(p_contract_id NUMBER) RETURN XMLType IS
61:
62: CURSOR C_ATTR_GRP IS
63: SELECT ag.descriptive_flex_context_code attr_group,
64: ag.attr_group_id attr_group_id,

Line 88: l_uda_xml XMLTYPE;

84:
85: l_sql VARCHAR2(32767);
86: l_op VARCHAR2(32767);
87: l_ctr NUMBER;
88: l_uda_xml XMLTYPE;
89:
90: BEGIN
91:
92: FOR rec IN C_ATTR_GRP LOOP

Line 129: FUNCTION get_setaside_recommendations(p_contract_id NUMBER) RETURN XMLTYPE IS

125: RETURN (l_uda_xml);
126:
127: END get_uda_single_attr_xml;
128:
129: FUNCTION get_setaside_recommendations(p_contract_id NUMBER) RETURN XMLTYPE IS
130:
131: l_rc SYS_REFCURSOR;
132: l_rec_type_col_name VARCHAR2(30);
133: l_rec_percent_col_name VARCHAR2(30);

Line 141: l_xml XMLTYPE;

137: l_attr_group_id NUMBER;
138: l_sql VARCHAR2(32567);
139: l_xml_sql VARCHAR2(32567);
140: l_final_sql VARCHAR2(32567);
141: l_xml XMLTYPE;
142:
143: BEGIN
144:
145: SELECT fcu.application_column_name INTO l_rec_type_col_name

Line 190: FUNCTION get_prev_acqs_history(p_contract_id NUMBER) RETURN XMLTYPE IS

186: WHEN OTHERS THEN
187: RAISE;
188: END get_setaside_recommendations;
189:
190: FUNCTION get_prev_acqs_history(p_contract_id NUMBER) RETURN XMLTYPE IS
191:
192: l_rc SYS_REFCURSOR;
193: l_prev_acq_type_col_name VARCHAR2(30);
194: l_prev_acq_cmt_col_name VARCHAR2(30);

Line 201: l_xml XMLTYPE;

197: l_attr_group_id NUMBER;
198: l_sql VARCHAR2(32567);
199: l_xml_sql VARCHAR2(32567);
200: l_final_sql VARCHAR2(32567);
201: l_xml XMLTYPE;
202:
203: BEGIN
204:
205: SELECT fcu.application_column_name INTO l_prev_acq_type_col_name