1 package gl_ci_data_transfer_pkg AUTHID CURRENT_USER as
2 /* $Header: glucitrs.pls 120.8.12010000.2 2010/03/12 09:39:32 sommukhe ship $ */
3
4 procedure Get_Domain_Name(
5 l_dblink IN varchar2);
6 procedure Get_Schema_Name(
7 l_dblink IN varchar2);
8 --+ a place to keep COA attributes
9 function Get_Source_Group_ID(
10 cons_id IN number,
11 cons_run_id IN number) return number;
12 function Get_Ledger_ID(
13 user_id IN number,
14 resp_id IN number,
15 app_id IN number,
16 dblink IN varchar2,
17 access_set_id OUT NOCOPY number,
18 access_set OUT NOCOPY varchar2,
19 access_code OUT NOCOPY varchar2,
20 l_to_ledger_name IN VARCHAR2) return number;
21 function Get_Budget_Version_ID(
22 user_id IN number,
23 resp_id IN number,
24 app_id IN number,
25 dblink IN varchar2,
26 budget_name IN varchar2) return number;
27 FUNCTION Remote_Data_Validation(
28 dblink IN varchar2,
29 p_resp_name IN varchar2,
30 p_pd_name IN varchar2,
31 p_ledger IN number,
32 p_j_import IN varchar2,
33 p_j_post IN varchar2) RETURN varchar2;
34 procedure Remote_Data_Map(
35 p_name IN varchar2,
36 p_resp_name IN OUT NOCOPY varchar2,
37 p_user_name IN OUT NOCOPY varchar2,
38 p_db_name IN OUT NOCOPY varchar2);
39 procedure Remote_Data_Map_Set(
40 p_name IN varchar2,
41 p_resp_name IN OUT NOCOPY varchar2,
42 p_user_name IN OUT NOCOPY varchar2,
43 p_db_name IN OUT NOCOPY varchar2);
44 function Remote_Data_transfer(
45 actual_flag IN varchar2,
46 user_id IN number,
47 resp_id IN number,
48 app_id IN number,
49 dblink IN varchar2,
50 source_ledger_id IN number,
51 pd_name IN varchar2,
52 budget_name IN varchar2,
53 group_id IN number,
54 request_id IN number,
55 p_dblink IN varchar2,
56 p_target_ledger_id IN number,
57 avg_flag IN OUT NOCOPY varchar2,
58 balanced_flag IN OUT NOCOPY varchar2,
59 errbuf IN OUT NOCOPY varchar2
60 ) return number;
61 procedure run_CI_transfer(
62 errbuf in out NOCOPY varchar2,
63 retcode in out NOCOPY varchar2,
64 p_resp_name IN varchar2,
65 p_user_name IN varchar2,
66 p_dblink IN varchar2,
67 from_group_id IN number,
68 from_ledger_id IN number,
69 p_pd_name IN varchar2,
70 p_budget_name IN varchar2,
71 p_j_import IN VARCHAR2,
72 p_j_post IN varchar2,
73 p_actual_flag IN varchar2,
74 p_request_id IN number,
75 p_csj_flag IN VARCHAR2,
76 p_debug IN varchar2);
77
78 procedure initialize_over_dblink(
79 user_id IN NUMBER,
80 resp_id IN NUMBER,
81 app_id IN NUMBER,
82 v_temp_db IN VARCHAR2);
83 end GL_CI_DATA_TRANSFER_PKG;