DBA Data[Home] [Help]

APPS.PO_POXPRCLM_PKG dependencies on XMLTYPE

Line 20: FUNCTION GET_UDA_HEADER_XML( p_req_header_id NUMBER) RETURN XMLType IS

16:
17: return (TRUE);
18: end;
19:
20: FUNCTION GET_UDA_HEADER_XML( p_req_header_id NUMBER) RETURN XMLType IS
21: CURSOR C_ATTR_GRP IS
22: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
23: ATTR_GROUP_ID,
24: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW

Line 61: l_uda_xml XMLTYPE;

57: L_OP VARCHAR2(32767);
58: L_ATTR_GRP NUMBER;
59: L_CTR NUMBER;
60: L_O_CTR NUMBER;
61: l_uda_xml XMLTYPE;
62:
63: p_application_id number := 201;
64: p_attr_internal_str_value varchar2(100);
65:

Line 166: FUNCTION GET_UDA_LINES_XML(p_req_line_id NUMBER) RETURN XMLTYPE IS

162: RETURN (l_uda_xml);
163: END;
164:
165:
166: FUNCTION GET_UDA_LINES_XML(p_req_line_id NUMBER) RETURN XMLTYPE IS
167: CURSOR C_ATTR_GRP IS
168: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
169: ATTR_GROUP_ID,
170: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW

Line 207: l_uda_xml XMLTYPE;

203: L_OP VARCHAR2(32767);
204: L_ATTR_GRP NUMBER;
205: L_CTR NUMBER;
206: L_O_CTR NUMBER;
207: l_uda_xml XMLTYPE;
208:
209: p_application_id number := 201;
210: p_attr_internal_str_value varchar2(100);
211: