eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_SGD_PKG dependencies on XMLTYPE

Line 6: FUNCTION get_uda_header_xml(p_headerId number, p_draft_id number) RETURN XMLType;

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;

Line 7: FUNCTION get_uda_line_xml(p_po_line_id NUMBER, p_draft_id number) RETURN XMLType;

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;

Line 8: FUNCTION get_uda_lineloc_xml(p_line_location_id number, p_draft_id number) RETURN XMLType;

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:

Line 24: base_pk5_value NUMBER default null ) RETURN XMLType;

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,

Line 37: base_pk5_value NUMBER default null ) RETURN XMLType;

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,

Line 50: base_pk5_value NUMBER default null ) RETURN XMLType;

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,

Line 63: base_pk5_value NUMBER default null ) RETURN XMLType ;

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,

Line 93: FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType;

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;

Line 94: FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number NUMBER) RETURN XMLType;

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;

Line 95: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType;

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;