[Home] [Help]
PACKAGE: APPS.PO_SGD_PKG
Source
1 PACKAGE PO_SGD_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_SGD_PKG.pls 120.0.12020000.3 2013/02/10 22:51:58 vegajula ship $ */
3
4 p_draft_id NUMBER;
5
6 FUNCTION get_uda_header_xml(p_headerId number, p_draft_id number) RETURN XMLType;
7 FUNCTION get_uda_line_xml(p_po_line_id NUMBER, p_draft_id number) RETURN XMLType;
8 FUNCTION get_uda_lineloc_xml(p_line_location_id number, p_draft_id number) RETURN XMLType;
9 FUNCTION get_shipaddressxml(p_line_location_id number, p_draft_id number) RETURN CLOB;
10 FUNCTION get_addressxml(p_header_id number, p_draft_id number) RETURN CLOB;
11 FUNCTION get_contactsxml(p_header_id number , p_draft_id number) RETURN CLOB;
12
13 FUNCTION getDiffXML(p_document_type VARCHAR2,
14 p_entity_name VARCHAR2,
15 mod_pk1_value NUMBER,
16 mod_pk2_value NUMBER,
17 mod_pk3_value NUMBER default null,
18 mod_pk4_value NUMBER default null,
19 mod_pk5_value NUMBER default null,
20 base_pk1_value NUMBER default null,
21 base_pk2_value NUMBER default null,
22 base_pk3_value NUMBER default null,
23 base_pk4_value NUMBER default null,
24 base_pk5_value NUMBER default null ) RETURN XMLType;
25
26 FUNCTION getLineSummaryDiffXML(p_document_type VARCHAR2,
27 p_entity_name VARCHAR2,
28 mod_pk1_value NUMBER,
29 mod_pk2_value NUMBER,
30 mod_pk3_value NUMBER default null,
31 mod_pk4_value NUMBER default null,
32 mod_pk5_value NUMBER default null,
33 base_pk1_value NUMBER default null,
34 base_pk2_value NUMBER default null,
35 base_pk3_value NUMBER default null,
36 base_pk4_value NUMBER default null,
37 base_pk5_value NUMBER default null ) RETURN XMLType;
38
39 FUNCTION getLineLocSummaryDiffXML(p_document_type VARCHAR2,
40 p_entity_name VARCHAR2,
41 mod_pk1_value NUMBER,
42 mod_pk2_value NUMBER,
43 mod_pk3_value NUMBER default null,
44 mod_pk4_value NUMBER default null,
45 mod_pk5_value NUMBER default null,
46 base_pk1_value NUMBER default null,
47 base_pk2_value NUMBER default null,
48 base_pk3_value NUMBER default null,
49 base_pk4_value NUMBER default null,
50 base_pk5_value NUMBER default null ) RETURN XMLType;
51
52 FUNCTION getDistSummaryDiffXML(p_document_type VARCHAR2,
53 p_entity_name VARCHAR2,
54 mod_pk1_value NUMBER,
55 mod_pk2_value NUMBER,
56 mod_pk3_value NUMBER default null,
57 mod_pk4_value NUMBER default null,
58 mod_pk5_value NUMBER default null,
59 base_pk1_value NUMBER default null,
60 base_pk2_value NUMBER default null,
61 base_pk3_value NUMBER default null,
62 base_pk4_value NUMBER default null,
63 base_pk5_value NUMBER default null ) RETURN XMLType ;
64
65 PROCEDURE find_rollup (p_document_type VARCHAR2,
66 p_entity_name VARCHAR2,
67 base_pk1_value NUMBER,
68 base_pk2_value NUMBER,
69 base_pk3_value NUMBER,
70 base_pk4_value NUMBER,
71 base_pk5_value NUMBER,
72 mod_pk1_value NUMBER,
73 mod_pk2_value NUMBER,
74 mod_pk3_value NUMBER,
75 mod_pk4_value NUMBER,
76 mod_pk5_value NUMBER);
77
78 PROCEDURE generate_rollup (p_document_type VARCHAR2,
79 p_entity_name VARCHAR2,
80 p_base_doc_source VARCHAR2,
81 base_pk1_value NUMBER,
82 base_pk2_value NUMBER,
83 base_pk3_value NUMBER,
84 base_pk4_value NUMBER,
85 base_pk5_value NUMBER,
86 p_mod_doc_source VARCHAR2,
87 mod_pk1_value NUMBER,
88 mod_pk2_value NUMBER,
89 mod_pk3_value NUMBER,
90 mod_pk4_value NUMBER,
91 mod_pk5_value NUMBER);
92
93 FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType;
94 FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number NUMBER) RETURN XMLType;
95 FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType;
96
97 END;