1 package gl_ci_data_transfer_pkg AUTHID CURRENT_USER as
2 /* $Header: glucitrs.pls 120.8 2005/12/08 10:32:07 mikeward noship $ */
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) return number;
20 function Get_Budget_Version_ID(
21 user_id IN number,
22 resp_id IN number,
23 app_id IN number,
24 dblink IN varchar2,
25 budget_name IN varchar2) return number;
26 FUNCTION Remote_Data_Validation(
27 dblink IN varchar2,
28 p_resp_name IN varchar2,
29 p_pd_name IN varchar2,
30 p_ledger IN number,
31 p_j_import IN varchar2,
32 p_j_post IN varchar2) RETURN varchar2;
33 procedure Remote_Data_Map(
34 p_name IN varchar2,
35 p_resp_name IN OUT NOCOPY varchar2,
36 p_user_name IN OUT NOCOPY varchar2,
37 p_db_name IN OUT NOCOPY varchar2);
38 procedure Remote_Data_Map_Set(
39 p_name IN varchar2,
40 p_resp_name IN OUT NOCOPY varchar2,
41 p_user_name IN OUT NOCOPY varchar2,
42 p_db_name IN OUT NOCOPY varchar2);
43 function Remote_Data_transfer(
44 actual_flag IN varchar2,
45 user_id IN number,
46 resp_id IN number,
47 app_id IN number,
48 dblink IN varchar2,
49 source_ledger_id IN number,
50 pd_name IN varchar2,
51 budget_name IN varchar2,
52 group_id IN number,
53 request_id IN number,
54 p_dblink IN varchar2,
55 p_target_ledger_id IN number,
56 avg_flag IN OUT NOCOPY varchar2,
57 balanced_flag IN OUT NOCOPY varchar2,
58 errbuf IN OUT NOCOPY varchar2
59 ) return number;
60 procedure run_CI_transfer(
61 errbuf in out NOCOPY varchar2,
62 retcode in out NOCOPY varchar2,
63 p_resp_name IN varchar2,
64 p_user_name IN varchar2,
65 p_dblink IN varchar2,
66 from_group_id IN number,
67 from_ledger_id IN number,
68 p_pd_name IN varchar2,
69 p_budget_name IN varchar2,
70 p_j_import IN VARCHAR2,
71 p_j_post IN varchar2,
72 p_actual_flag IN varchar2,
73 p_request_id IN number,
74 p_csj_flag IN VARCHAR2,
75 p_debug IN varchar2);
76 end GL_CI_DATA_TRANSFER_PKG;