1 PACKAGE gl_fusion_transfer_pkg AUTHID CURRENT_USER AS
2 /* $Header: glufutrs.pls 120.1 2011/01/28 13:23:16 bsrikant noship $ */
3
4 --
5 -- Parameters for use by BI Publisher
6 --
7 p_bi_from_ledger_shortname VARCHAR2(30);
8 p_bi_from_ledger_id NUMBER;
9 p_bi_transfer_mode VARCHAR2(1);
10 p_bi_from_period_name VARCHAR2(30);
11 p_bi_access_set_id NUMBER;
12 p_bi_debug_mode VARCHAR2(1);
13 p_conc_request_id NUMBER;
14 p_bi_retcode NUMBER;
15
16 g_request_id_str VARCHAR2(50);
17 g_system_id_str VARCHAR2(50);
18
19 -------------------------------------------------------------------------------
20 -- Public API
21 -------------------------------------------------------------------------------
22
23 -- BIP APIs
24 FUNCTION BeforeReport RETURN BOOLEAN;
25 FUNCTION AfterReport RETURN BOOLEAN;
26
27 --=============================================================================
28 -- The main procedure of the fusion transfer.
29 -- Parameters are:
30 -- p_errbuf Standard concurrent program parameter
31 -- p_retcode Standard concurrent program parameter
32 -- p_from_ledger_shortname Ledger shortname to transfer from (can be
33 -- ledger or reporting currency). Need to
34 -- pass ledger shortname to support balance level
35 -- reporting currencies.
36 -- p_from_ledger_id Ledger to transfer from
37 -- p_transfer_mode Type of transfer. Either:
38 -- 'F' - Full
39 -- 'I' - Incremental
40 -- p_from_period_name For full transfer, the period to transfer.
41 -- For incremental, should be null. Incremental
42 -- always transfers data for all periods that
43 -- have been transferred in full
44 -- p_access_set_id Access set id for security
45 -- p_debug_mode Debug mode on? (Y or N)
46 --=============================================================================
47 PROCEDURE do_transfer
48 (p_errbuf OUT NOCOPY VARCHAR2,
49 p_retcode OUT NOCOPY NUMBER,
50 p_from_ledger_shortname IN VARCHAR2,
51 p_from_ledger_id IN NUMBER,
52 p_transfer_mode IN VARCHAR2,
53 p_from_period_name IN VARCHAR2,
54 p_access_set_id IN NUMBER,
55 p_debug_mode IN VARCHAR2);
56
57 --=============================================================================
58 -- The purge routine to purge imported data.
59 -- Parameters are:
60 -- ** None **
61 --=============================================================================
62 PROCEDURE purge_data
63 (p_errbuf OUT NOCOPY VARCHAR2,
64 p_retcode OUT NOCOPY NUMBER);
65
66 END gl_fusion_transfer_pkg;