APPS.PON_DATATEMPLATE_PKG dependencies on XMLTYPE

Line 5: FUNCTION GET_UDA_HEADER_XML RETURN XMLType IS

1: PACKAGE BODY PON_DATATEMPLATE_PKG AS
2: /* $Header: PON_DATATEMPLATE_PKG.plb 120.4 2011/02/17 09:23:13 nbingi ship $ */
3:
4:
5: FUNCTION GET_UDA_HEADER_XML RETURN XMLType IS
6: CURSOR C_ATTR_GRP IS
7: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
8: ATTR_GROUP_ID,
9: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW

Line 46: l_uda_xml XMLTYPE;

42: L_OP VARCHAR2(32767);
43: L_ATTR_GRP NUMBER;
44: L_CTR NUMBER;
45: L_O_CTR NUMBER;
46: l_uda_xml XMLTYPE;
47:
48: p_application_id number := 201;
49: p_attr_internal_str_value varchar2(100);
50:

Line 152: FUNCTION GET_UDA_LINES_XML(p_line_id NUMBER) RETURN XMLTYPE IS

148: END;
149:
150:
151:
152: FUNCTION GET_UDA_LINES_XML(p_line_id NUMBER) RETURN XMLTYPE IS
153: CURSOR C_ATTR_GRP IS
154: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
155: ATTR_GROUP_ID,
156: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW

Line 194: l_uda_xml XMLTYPE;

190: L_OP VARCHAR2(32767);
191: L_ATTR_GRP NUMBER;
192: L_CTR NUMBER;
193: L_O_CTR NUMBER;
194: l_uda_xml XMLTYPE;
195:
196: p_application_id number := 201;
197: p_attr_internal_str_value varchar2(100);
198: