1 PACKAGE FUN_RECON_RPT_PKG AUTHID CURRENT_USER AS
2 /* $Header: funrecrpts.pls 120.5 2006/06/16 09:09:09 bsilveir noship $ */
3
4 PROCEDURE run_fun_report
5 (p_errbuf OUT NOCOPY VARCHAR2
6 ,p_retcode OUT NOCOPY NUMBER
7 ,p_trans_ledger_id IN NUMBER
8 ,p_trans_legal_entity_id IN NUMBER
9 ,p_trans_gl_period IN VARCHAR2
10 ,p_tp_ledger_id IN NUMBER
11 ,p_tp_legal_entity_id IN NUMBER
12 ,p_tp_gl_period IN VARCHAR2
13 ,p_currency IN VARCHAR2
14 ,p_rate_type IN VARCHAR2
15 ,p_rate_date IN VARCHAR2);
16
17 Function match_ap_ar_invoice(p_trans_le_id in number,
18 p_trans_ledger_id in number,
19 p_trans_gl_period in varchar2,
20 p_trad_le_id in number,
21 p_trad_ledger_id in number,
22 p_trad_gl_period in varchar2,
23 p_account_type in varchar2, -- this will be 'R', or 'P'
24 p_entity_code in varchar2,
25 p_ap_ar_invoice_id in number) return varchar2;
26
27 Function get_balance(p_balance_type varchar2,
28 p_column_name varchar2,
29 p_trans_ledger_id number,
30 p_trans_le_id number,
31 p_trans_gl_period varchar2,
32 p_trad_ledger_id number,
33 p_trad_le_id number,
34 p_trad_gl_period varchar2,
35 p_currency varchar2) return number;
36
37
38 --------------------------------------------------------------------------------
39 -- Function to Return Ledger Name from LE_ID
40 --------------------------------------------------------------------------------
41 FUNCTION get_legal_entity
42 (p_le_id IN NUMBER
43 )RETURN VARCHAR2;
44
45 --------------------------------------------------------------------------------
46 -- Procedure to write CLOB contents to file
47 --------------------------------------------------------------------------------
48 PROCEDURE clob_to_file
49 (p_xml_clob IN CLOB);
50
51 END FUN_RECON_RPT_PKG;