DBA Data[Home] [Help]

PACKAGE: APPS.FUN_RECON_RPT_PKG

Source


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;