[Home] [Help]
PACKAGE: APPS.RG_XFER_UTILS_PKG
Source
1 PACKAGE RG_XFER_UTILS_PKG as
2 /* $Header: rgixutls.pls 120.4 2003/04/29 00:48:07 djogg ship $ */
3
4 /*** Variables ***/
5
6 FoundError BOOLEAN;
7 FoundWarning BOOLEAN;
8
9 G_Error NUMBER;
10 G_Warning NUMBER;
11 G_NoCOA NUMBER;
12 G_NoError NUMBER;
13
14 /* Message Levels */
15 G_ML_Minimal NUMBER;
16 G_ML_Normal NUMBER;
17 G_ML_Full NUMBER;
18
19 TYPE ListType IS TABLE OF VARCHAR2(100)
20 INDEX BY BINARY_INTEGER;
21
22 copy_error EXCEPTION;
23
24
25 /*** Routines ***/
26
27 FUNCTION ping_link(LinkName VARCHAR2) RETURN BOOLEAN;
28
29 FUNCTION create_link(LinkName VARCHAR2,
30 Username VARCHAR2,
31 Password VARCHAR2,
32 ConnectString VARCHAR2) RETURN NUMBER;
33
34 FUNCTION drop_link(LinkName VARCHAR2) RETURN BOOLEAN;
35
36 PROCEDURE display_string(
37 InputStr VARCHAR2
38 );
39
40 PROCEDURE display_message(
41 MsgName VARCHAR2,
42 Token1 VARCHAR2 DEFAULT NULL,
43 Token1Val VARCHAR2 DEFAULT NULL,
44 Token1Xlate BOOLEAN DEFAULT FALSE,
45 Token2 VARCHAR2 DEFAULT NULL,
46 Token2Val VARCHAR2 DEFAULT NULL,
47 Token2Xlate BOOLEAN DEFAULT FALSE,
48 Token3 VARCHAR2 DEFAULT NULL,
49 Token3Val VARCHAR2 DEFAULT NULL,
50 Token3Xlate BOOLEAN DEFAULT FALSE,
51 Token4 VARCHAR2 DEFAULT NULL,
52 Token4Val VARCHAR2 DEFAULT NULL,
53 Token4Xlate BOOLEAN DEFAULT FALSE,
54 Token5 VARCHAR2 DEFAULT NULL,
55 Token5Val VARCHAR2 DEFAULT NULL,
56 Token5Xlate BOOLEAN DEFAULT FALSE
57 );
58
59 PROCEDURE display_log(
60 MsgLevel NUMBER,
61 MsgName VARCHAR2,
62 Token1 VARCHAR2 DEFAULT NULL,
63 Token1Val VARCHAR2 DEFAULT NULL,
64 Token1Xlate BOOLEAN DEFAULT FALSE,
65 Token2 VARCHAR2 DEFAULT NULL,
66 Token2Val VARCHAR2 DEFAULT NULL,
67 Token2Xlate BOOLEAN DEFAULT FALSE,
68 Token3 VARCHAR2 DEFAULT NULL,
69 Token3Val VARCHAR2 DEFAULT NULL,
70 Token3Xlate BOOLEAN DEFAULT FALSE,
71 Token4 VARCHAR2 DEFAULT NULL,
72 Token4Val VARCHAR2 DEFAULT NULL,
73 Token4Xlate BOOLEAN DEFAULT FALSE
74 );
75
76 PROCEDURE display_error(
77 MsgName VARCHAR2,
78 Token1 VARCHAR2 DEFAULT NULL,
79 Token1Val VARCHAR2 DEFAULT NULL,
80 Token1Xlate BOOLEAN DEFAULT FALSE,
81 Token2 VARCHAR2 DEFAULT NULL,
82 Token2Val VARCHAR2 DEFAULT NULL,
83 Token2Xlate BOOLEAN DEFAULT FALSE,
84 Token3 VARCHAR2 DEFAULT NULL,
85 Token3Val VARCHAR2 DEFAULT NULL,
86 Token3Xlate BOOLEAN DEFAULT FALSE
87 );
88
89 PROCEDURE display_warning(
90 MsgName VARCHAR2,
91 Token1 VARCHAR2 DEFAULT NULL,
92 Token1Val VARCHAR2 DEFAULT NULL,
93 Token1Xlate BOOLEAN DEFAULT FALSE,
94 Token2 VARCHAR2 DEFAULT NULL,
95 Token2Val VARCHAR2 DEFAULT NULL,
96 Token2Xlate BOOLEAN DEFAULT FALSE,
97 Token3 VARCHAR2 DEFAULT NULL,
98 Token3Val VARCHAR2 DEFAULT NULL,
99 Token3Xlate BOOLEAN DEFAULT FALSE,
100 Token4 VARCHAR2 DEFAULT NULL,
101 Token4Val VARCHAR2 DEFAULT NULL,
102 Token4Xlate BOOLEAN DEFAULT FALSE
103 );
104
105 PROCEDURE display_exception(
106 ErrorNum NUMBER,
107 ErrorMsg VARCHAR2
108 );
109
110 PROCEDURE init(
111 SourceCOAId NUMBER,
112 TargetCOAId NUMBER,
113 LinkName VARCHAR2
114 );
115
116 PROCEDURE insert_into_list(
117 ListName IN OUT NOCOPY ListType,
118 ListCount IN OUT NOCOPY BINARY_INTEGER,
119 Name VARCHAR2
120 );
121
122 FUNCTION search_list(
123 ListName ListType,
124 ListCount BINARY_INTEGER,
125 Name VARCHAR2
126 ) RETURN BINARY_INTEGER;
127
128 PROCEDURE copy_adjust_string(
129 TargetStr IN OUT NOCOPY VARCHAR2,
130 SourceStr VARCHAR2);
131
132 FUNCTION get_source_id(
133 TableName VARCHAR2,
134 IdName VARCHAR2,
135 CompName VARCHAR2,
136 WhereClause VARCHAR2 DEFAULT NULL
137 ) RETURN NUMBER;
138
139 FUNCTION get_new_id(SequenceName VARCHAR2) RETURN NUMBER;
140
141 PROCEDURE insert_rows(
142 SQLStmt VARCHAR2,
143 Id NUMBER,
144 UseCOAId BOOLEAN DEFAULT FALSE,
145 UseRowId BOOLEAN DEFAULT FALSE,
146 RecRowId ROWID DEFAULT NULL
147 );
148
149 PROCEDURE execute_sql_statement(SQLStmt VARCHAR2);
150
151 PROCEDURE substitute_tokens(
152 InputStr IN OUT NOCOPY VARCHAR2,
153 Token1 VARCHAR2 DEFAULT NULL,
154 Token1Val VARCHAR2 DEFAULT NULL,
155 Token2 VARCHAR2 DEFAULT NULL,
156 Token2Val VARCHAR2 DEFAULT NULL,
157 Token3 VARCHAR2 DEFAULT NULL,
158 Token3Val VARCHAR2 DEFAULT NULL,
159 Token4 VARCHAR2 DEFAULT NULL,
160 Token4Val VARCHAR2 DEFAULT NULL,
161 Token5 VARCHAR2 DEFAULT NULL,
162 Token5Val VARCHAR2 DEFAULT NULL,
163 Token6 VARCHAR2 DEFAULT NULL,
164 Token6Val VARCHAR2 DEFAULT NULL,
165 Token7 VARCHAR2 DEFAULT NULL,
166 Token7Val VARCHAR2 DEFAULT NULL,
167 Token8 VARCHAR2 DEFAULT NULL,
168 Token8Val VARCHAR2 DEFAULT NULL,
169 Token9 VARCHAR2 DEFAULT NULL,
170 Token9Val VARCHAR2 DEFAULT NULL
171 );
172
173 FUNCTION check_coa_id(
174 TableName VARCHAR2,
175 CompName VARCHAR2,
176 WhereString VARCHAR2 DEFAULT NULL
177 ) RETURN NUMBER;
178
179 FUNCTION check_target_coa_id(
180 TableName VARCHAR2,
181 CompName VARCHAR2,
182 WhereString VARCHAR2 DEFAULT NULL
183 ) RETURN NUMBER;
184
185 FUNCTION source_component_exists(
186 ComponentType VARCHAR2,
187 CompName VARCHAR2
188 ) RETURN BOOLEAN;
189
190 FUNCTION component_exists(SelectString VARCHAR2) RETURN NUMBER;
191
192 FUNCTION get_source_ref_object_name(
193 MainTableName VARCHAR2,
194 RefTableName VARCHAR2,
195 ColumnName VARCHAR2,
196 ColumnValue VARCHAR2,
197 MainIdName VARCHAR2,
198 RefIdName VARCHAR2,
199 CharColumn BOOLEAN DEFAULT TRUE
200 ) RETURN VARCHAR2;
201
202 PROCEDURE get_target_id_from_source_id(
203 TableName VARCHAR2,
204 NameColumn VARCHAR2,
205 IdColumnName VARCHAR2,
206 IdValue IN OUT NOCOPY NUMBER,
207 IdName IN OUT NOCOPY VARCHAR2
208 );
209
210 PROCEDURE get_target_ldg_from_source_ldg(
211 LedgerId IN OUT NOCOPY NUMBER,
212 LedgerName IN OUT NOCOPY VARCHAR2,
213 LedgerCurrency IN OUT NOCOPY VARCHAR2);
214
215 FUNCTION token_from_id(Id NUMBER) RETURN VARCHAR2;
216
217 FUNCTION currency_exists(CurrencyCode VARCHAR2) RETURN BOOLEAN;
218
219 FUNCTION ro_column_exists(ColumnName VARCHAR2) RETURN BOOLEAN;
220
221 FUNCTION get_varchar2(
222 SQLString VARCHAR2,
223 ColumnSize NUMBER
224 ) RETURN VARCHAR2;
225
226 END RG_XFER_UTILS_PKG;