1 package gl_ci_remote_invoke_pkg AUTHID DEFINER as
2 /* $Header: glucirms.pls 120.7.12010000.2 2010/03/12 09:41:41 sommukhe ship $ */
3 --+ a place to keep batch names
4 type batch_record is RECORD (
5 batch_name gl_interface.reference1%TYPE,
6 postable_rows number,
7 reqid number);
8 type batch_table is table of batch_record index by binary_integer;
9 type coa_record is RECORD (
10 segment_num fnd_id_flex_segments.segment_num%TYPE,
11 application_column_name fnd_id_flex_segments.application_column_name%TYPE,
12 display_size fnd_id_flex_segments.display_size%TYPE);
13 type coa_table is table of coa_record index by binary_integer;
14 PROCEDURE drop_table(
15 p_table_name IN varchar2);
16 procedure coa_info (
17 p_coa_id NUMBER,
18 p_count IN OUT NOCOPY Number);
19 procedure Get_Detail_coa_info (
20 p_coa_id IN NUMBER,
21 p_count IN Number,
22 p_column_name IN OUT NOCOPY varchar2,
23 p_display_size IN OUT NOCOPY number);
24 function Get_eMAIL_Address(
25 p_user_name IN varchar2) return varchar2;
26 function Get_User_ID(
27 user_name IN varchar2) return number;
28 function Get_Resp_ID(
29 resp_name IN varchar2) return number;
30 function Get_Ledger_Name(
31 ledger_id IN number) return varchar2;
32 function Get_Suspense_Flag(
33 ledger_id IN number) return varchar2;
34 function Get_Daily_Balance_Flag(
35 ledger_id IN number) return varchar2;
36 function Get_Cons_ledger_Flag(
37 ledger_id IN number) return varchar2;
38 function Get_Currency_Code(
39 ledger_id IN number) return varchar2;
40 function Get_COA_Id(
41 ledger_id IN number) return number;
42 function Period_Exists(
43 ledger_id IN number,
44 period_name IN varchar2) return number;
45 PROCEDURE Get_Target_Je_source_Name(
46 p_adb_name OUT NOCOPY varchar2,
47 p_name OUT NOCOPY varchar2);
48
49 PROCEDURE Get_Period_Info(
50 ledger_id IN number,
51 period_name IN varchar2,
52 start_date OUT NOCOPY varchar2,
53 end_date OUT NOCOPY varchar2,
54 quarter_date OUT NOCOPY varchar2,
55 year_date OUT NOCOPY varchar2);
56
57 procedure GLOBAL_INITIALIZE(
58 user_id in number,
59 resp_id in number,
60 resp_appl_id in number,
61 security_group_id in number default 0);
62
63 function Get_Login_Ids(
64 p_user_name IN varchar2,
65 p_resp_name IN varchar2,
66 user_id OUT NOCOPY number,
67 resp_id OUT NOCOPY number) return number;
68
69 function Validate_Resp(
70 resp_name IN varchar2) return number;
71
72 function Menu_Validation(
73 user_id IN number,
74 resp_id IN number,
75 app_id IN number,
76 import_flag IN varchar2,
77 post_flag IN varchar2) return varchar2;
78
79 function Get_Ledger_ID(
80 p_user_id IN number,
81 p_resp_id IN number,
82 p_app_id IN number,
83 p_access_set_id OUT NOCOPY number,
84 p_access_set OUT NOCOPY varchar2,
85 p_access_code OUT NOCOPY varchar2,
86 p_to_ledger_name IN VARCHAR2) return number;
87
88 function Get_Budget_Version_ID(
89 p_user_id IN number,
90 p_resp_id IN number,
91 p_app_id IN number,
92 p_budget_name IN varchar2) return number;
93
94 function Apps_Initialize(
95 user_id IN number,
96 resp_id IN number,
97 app_id IN number,
98 ledger_id IN number,
99 group_id IN number,
100 pd_name IN varchar2,
101 actual_flag IN varchar2,
102 avg_flag IN varchar2)return number;
103 function Run_Journal_Import(
104 user_id IN number,
105 resp_id IN number,
106 app_id IN number,
107 inter_run_id IN number,
108 ledger_id IN number,
109 csj_flag IN VARCHAR2) return number;
110 PROCEDURE Verify_Journal_Import(
111 p_group_id IN number,
112 result OUT NOCOPY varchar2);
113 procedure Get_Postable_Rows(
114 ledger_id IN number,
115 pd_name IN varchar2,
116 batch_id IN number,
117 status IN varchar2,
118 actual_flag IN varchar2,
119 avg_flag IN varchar2,
120 postable_rows OUT NOCOPY number);
121 procedure Run_Journal_Post(
122 user_id IN number,
123 resp_id IN number,
124 app_id IN number,
125 ledger_id IN number,
126 pd_name IN varchar2,
127 group_id IN number,
128 import_request_id IN number,
129 batch_id IN number,
130 actual_flag IN varchar2,
131 access_set_id IN number,
132 post_run_id OUT NOCOPY number,
133 reqid OUT NOCOPY number);
134 PROCEDURE Verify_Journal_Post(
135 l_pd_name IN varchar2,
136 postable_rows IN number,
137 l_ledger_id IN number,
138 l_batch_id IN number,
139 actual_flag IN varchar2,
140 avg_flag IN varchar2,
141 result OUT NOCOPY varchar2);
142 procedure wait_for_request(
143 request_id IN number,
144 result OUT NOCOPY varchar2);
145 function get_request_status(
146 request_id IN number,
147 result OUT NOCOPY varchar2) return boolean;
148 procedure Test_run;
149
150 FUNCTION Get_Group_ID RETURN number;
151 procedure Create_Interface_Table(
152 group_id IN number,
153 db_username IN varchar2);
154
155 end GL_CI_REMOTE_INVOKE_PKG;