PACKAGE: APPS.PON_SGD_PKG

Source

1 PACKAGE PON_SGD_PKG AUTHID CURRENT_USER AS
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;
11 
12 FUNCTION getDiffXML(p_document_type VARCHAR2,
13 			p_entity_name VARCHAR2,
14 			p_mod_pk1_value NUMBER,
15 			p_mod_pk2_value NUMBER default null,
16 			p_mod_pk3_value NUMBER default null,
17 			p_mod_pk4_value NUMBER default null,
18 			p_mod_pk5_value NUMBER default null,
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,
28 				mod_pk2_value NUMBER default null,
29 				mod_pk3_value NUMBER default null,
30 				mod_pk4_value NUMBER default null,
31 				mod_pk5_value NUMBER default null,
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,
41 			base_pk2_value NUMBER,
42 			base_pk3_value NUMBER,
43 			base_pk4_value NUMBER,
44 			base_pk5_value NUMBER,
45 			mod_pk1_value NUMBER,
46 			mod_pk2_value NUMBER,
47 			mod_pk3_value NUMBER,
48 			mod_pk4_value NUMBER,
49 			mod_pk5_value NUMBER );
50 
51 PROCEDURE generate_rollup (p_document_type VARCHAR2,
52 			   p_entity_name VARCHAR2,
53 			   p_base_doc_source VARCHAR2,
54      			   base_pk1_value NUMBER,
55 			   base_pk2_value NUMBER,
56 			   base_pk3_value NUMBER,
57 			   base_pk4_value NUMBER,
58 			   base_pk5_value NUMBER,
59 			   p_mod_doc_source VARCHAR2,
60 			   mod_pk1_value NUMBER,
61 			   mod_pk2_value NUMBER,
62 			   mod_pk3_value NUMBER,
63 			   mod_pk4_value NUMBER,
64 			   mod_pk5_value NUMBER );
65 
66 END;
67