DBA Data[Home] [Help]

APPS.PON_SGD_PKG dependencies on XMLTYPE

Line 6: FUNCTION get_uda_header_xml RETURN XMLType;

2: /* $Header: PON_SGD_PKG.pls 120.1 2012/01/23 06:23:38 nbingi noship $ */
3:
4: p_auction_header_id NUMBER;
5:
6: FUNCTION get_uda_header_xml RETURN XMLType;
7: FUNCTION get_uda_lines_xml(p_line_id NUMBER) RETURN XMLTYPE;
8: FUNCTION get_shipaddressxml(p_line_id number) RETURN CLOB;
9: FUNCTION get_addressxml(p_header_id number) RETURN CLOB;
10: FUNCTION get_contactsxml(p_header_id number) RETURN CLOB;

Line 7: FUNCTION get_uda_lines_xml(p_line_id NUMBER) RETURN XMLTYPE;

3:
4: p_auction_header_id NUMBER;
5:
6: FUNCTION get_uda_header_xml RETURN XMLType;
7: FUNCTION get_uda_lines_xml(p_line_id NUMBER) RETURN XMLTYPE;
8: FUNCTION get_shipaddressxml(p_line_id number) RETURN CLOB;
9: FUNCTION get_addressxml(p_header_id number) RETURN CLOB;
10: FUNCTION get_contactsxml(p_header_id number) RETURN CLOB;
11:

Line 23: p_base_pk5_value NUMBER default null ) RETURN XMLType;

19: p_base_pk1_value NUMBER default null,
20: p_base_pk2_value NUMBER default null,
21: p_base_pk3_value NUMBER default null,
22: p_base_pk4_value NUMBER default null,
23: p_base_pk5_value NUMBER default null ) RETURN XMLType;
24:
25: FUNCTION getLineSummaryDiffXML(p_document_type VARCHAR2,
26: p_entity_name VARCHAR2,
27: mod_pk1_value NUMBER,

Line 36: base_pk5_value NUMBER default null ) RETURN XMLType;

32: base_pk1_value NUMBER default null,
33: base_pk2_value NUMBER default null,
34: base_pk3_value NUMBER default null,
35: base_pk4_value NUMBER default null,
36: base_pk5_value NUMBER default null ) RETURN XMLType;
37:
38: PROCEDURE find_rollup (p_document_type VARCHAR2,
39: p_entity_name VARCHAR2,
40: base_pk1_value NUMBER,