1 package gl_ci_remote_invoke_pkg AUTHID DEFINER as
2 /* $Header: glucirms.pls 120.7 2005/12/08 10:32:31 mikeward noship $ */
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) return number;
86
87 function Get_Budget_Version_ID(
88 p_user_id IN number,
89 p_resp_id IN number,
90 p_app_id IN number,
91 p_budget_name IN varchar2) return number;
92
93 function Apps_Initialize(
94 user_id IN number,
95 resp_id IN number,
96 app_id IN number,
97 ledger_id IN number,
98 group_id IN number,
99 pd_name IN varchar2,
100 actual_flag IN varchar2,
101 avg_flag IN varchar2)return number;
102 function Run_Journal_Import(
103 user_id IN number,
104 resp_id IN number,
105 app_id IN number,
106 inter_run_id IN number,
107 ledger_id IN number,
108 csj_flag IN VARCHAR2) return number;
109 PROCEDURE Verify_Journal_Import(
110 p_group_id IN number,
111 result OUT NOCOPY varchar2);
112 procedure Get_Postable_Rows(
113 ledger_id IN number,
114 pd_name IN varchar2,
115 batch_id IN number,
116 status IN varchar2,
117 actual_flag IN varchar2,
118 avg_flag IN varchar2,
119 postable_rows OUT NOCOPY number);
120 procedure Run_Journal_Post(
121 user_id IN number,
122 resp_id IN number,
123 app_id IN number,
124 ledger_id IN number,
125 pd_name IN varchar2,
126 group_id IN number,
127 import_request_id IN number,
128 batch_id IN number,
129 actual_flag IN varchar2,
130 access_set_id IN number,
131 post_run_id OUT NOCOPY number,
132 reqid OUT NOCOPY number);
133 PROCEDURE Verify_Journal_Post(
134 l_pd_name IN varchar2,
135 postable_rows IN number,
136 l_ledger_id IN number,
137 l_batch_id IN number,
138 actual_flag IN varchar2,
139 avg_flag IN varchar2,
140 result OUT NOCOPY varchar2);
141 procedure wait_for_request(
142 request_id IN number,
143 result OUT NOCOPY varchar2);
144 function get_request_status(
145 request_id IN number,
146 result OUT NOCOPY varchar2) return boolean;
147 procedure Test_run;
148
149 FUNCTION Get_Group_ID RETURN number;
150 procedure Create_Interface_Table(
151 group_id IN number,
152 db_username IN varchar2);
153
154 end GL_CI_REMOTE_INVOKE_PKG;