[Home] [Help]
PACKAGE: APPS.GCS_INTERCO_RULES_PKG
Source
1 PACKAGE GCS_INTERCO_RULES_PKG AS
2 /* $Header: gcsintercorules.pls 120.1 2005/10/30 05:18:52 appldev noship $ */
3
4 -- Procedure
5 -- Insert_Row
6 -- Purpose
7 -- Inserts a row into the gcs_interco_rules_b table.
8 -- Arguments
9 --row_id
10 --RULE_ID
11 --ENABLED_FLAG
12 --THRESHOLD_AMOUNT
13 --THRESHOLD_CURRENCY
14 --OBJECT_VERSION_NUMBER
15 --CREATION_DATE
16 --CREATED_BY
17 --LAST_UPDATE_DATE
18 --LAST_UPDATED_BY
19 --LAST_UPDATE_LOGIN
20 --SUS_FINANCIAL_ELEM_ID
21 --SUS_PRODUCT_ID
22 --SUS_NATURAL_ACCOUNT_ID
23 --SUS_CHANNEL_ID
24 --SUS_LINE_ITEM_ID
25 --SUS_PROJECT_ID
26 --SUS_CUSTOMER_ID
27 --SUS_TASK_ID
28 --SUS_USER_DIM1_ID
29 --SUS_USER_DIM2_ID
30 --SUS_USER_DIM3_ID
31 --SUS_USER_DIM4_ID
32 --SUS_USER_DIM5_ID
33 --SUS_USER_DIM6_ID
34 --SUS_USER_DIM7_ID
35 --SUS_USER_DIM8_ID
36 --SUS_USER_DIM9_ID
37 --SUS_USER_DIM10_ID
38 --RULE_NAME
39 --DESCRIPTION
40
41 -- Example
42 -- GCS_INTERCO_RULES_PKG.Insert_Row(...);
43 -- Notes
44 --
45
46 PROCEDURE Insert_Row
47 (
48 row_id IN OUT NOCOPY VARCHAR2,
49 RULE_ID NUMBER,
50 ENABLED_FLAG VARCHAR2,
51 THRESHOLD_AMOUNT NUMBER,
52 THRESHOLD_CURRENCY VARCHAR2,
53 OBJECT_VERSION_NUMBER NUMBER,
54 CREATION_DATE DATE,
55 CREATED_BY NUMBER,
56 LAST_UPDATE_DATE DATE,
57 LAST_UPDATED_BY NUMBER,
58 LAST_UPDATE_LOGIN NUMBER,
59 SUS_FINANCIAL_ELEM_ID NUMBER,
60 SUS_PRODUCT_ID NUMBER,
61 SUS_NATURAL_ACCOUNT_ID NUMBER,
62 SUS_CHANNEL_ID NUMBER,
63 SUS_LINE_ITEM_ID NUMBER,
64 SUS_PROJECT_ID NUMBER,
65 SUS_CUSTOMER_ID NUMBER,
66 SUS_TASK_ID NUMBER,
67 SUS_USER_DIM1_ID NUMBER,
68 SUS_USER_DIM2_ID NUMBER,
69 SUS_USER_DIM3_ID NUMBER,
70 SUS_USER_DIM4_ID NUMBER,
71 SUS_USER_DIM5_ID NUMBER,
72 SUS_USER_DIM6_ID NUMBER,
73 SUS_USER_DIM7_ID NUMBER,
74 SUS_USER_DIM8_ID NUMBER,
75 SUS_USER_DIM9_ID NUMBER,
76 SUS_USER_DIM10_ID NUMBER,
77 RULE_NAME varchar2,
78 DESCRIPTION varchar2
79 );
80
81
82 -- Procedure
83 -- Update_Row
84 -- Purpose
85 -- Updates a row into the gcs_interco_rules_b table.
86 -- Arguments
87 -- row_id
88 -- RULE_ID
89 -- ENABLED_FLAG
90 -- THRESHOLD_AMOUNT
91 -- THRESHOLD_CURRENCY
92 -- CREATION_DATE
93 -- CREATED_BY
94 -- OBJECT_VERSION_NUMBER
95 -- LAST_UPDATE_DATE
96 -- LAST_UPDATED_BY
97 -- LAST_UPDATE_LOGIN
98 -- SUS_FINANCIAL_ELEM_ID
99 -- SUS_PRODUCT_ID
100 -- SUS_NATURAL_ACCOUNT_ID
101 -- SUS_CHANNEL_ID
102 -- SUS_LINE_ITEM_ID
103 -- SUS_PROJECT_ID
104 -- SUS_CUSTOMER_ID
105 -- SUS_TASK_ID
106 -- SUS_USER_DIM1_ID
107 -- SUS_USER_DIM2_ID
108 -- SUS_USER_DIM3_ID
109 -- SUS_USER_DIM4_ID
110 -- SUS_USER_DIM5_ID
111 -- SUS_USER_DIM6_ID
112 -- SUS_USER_DIM7_ID
113 -- SUS_USER_DIM8_ID
114 -- SUS_USER_DIM9_ID
115 -- SUS_USER_DIM10_ID
116 -- RULE_NAME
117 -- DESCRIPTION
118
119 -- Example
120 -- GCS_INTERCO_RULES_PKG.Update_Row(...);
121 -- Notes
122 --
123
124
125 PROCEDURE Update_Row
126 (
127 row_id IN OUT NOCOPY VARCHAR2,
128 RULE_ID NUMBER,
129 ENABLED_FLAG VARCHAR2,
130 THRESHOLD_AMOUNT NUMBER,
131 THRESHOLD_CURRENCY VARCHAR2,
132 CREATION_DATE DATE,
133 CREATED_BY NUMBER,
134 OBJECT_VERSION_NUMBER NUMBER,
135 LAST_UPDATE_DATE DATE,
136 LAST_UPDATED_BY NUMBER,
137 LAST_UPDATE_LOGIN NUMBER,
138 SUS_FINANCIAL_ELEM_ID NUMBER,
139 SUS_PRODUCT_ID NUMBER,
140 SUS_NATURAL_ACCOUNT_ID NUMBER,
141 SUS_CHANNEL_ID NUMBER,
142 SUS_LINE_ITEM_ID NUMBER,
143 SUS_PROJECT_ID NUMBER,
144 SUS_CUSTOMER_ID NUMBER,
145 SUS_TASK_ID NUMBER,
146 SUS_USER_DIM1_ID NUMBER,
147 SUS_USER_DIM2_ID NUMBER,
148 SUS_USER_DIM3_ID NUMBER,
149 SUS_USER_DIM4_ID NUMBER,
150 SUS_USER_DIM5_ID NUMBER,
151 SUS_USER_DIM6_ID NUMBER,
152 SUS_USER_DIM7_ID NUMBER,
153 SUS_USER_DIM8_ID NUMBER,
154 SUS_USER_DIM9_ID NUMBER,
155 SUS_USER_DIM10_ID NUMBER,
156 RULE_NAME varchar2,
157 DESCRIPTION varchar2
158 );
159
160
161
162 -- Procedure
163 -- Load_Row
164 -- Purpose
165 -- loads a row into the gcs_interco_rules_b table.
166 -- Arguments
167 -- row_id
168 -- RULE_ID
169 -- ENABLED_FLAG
170 -- THRESHOLD_AMOUNT
171 -- THRESHOLD_CURRENCY
172 -- CREATION_DATE
173 -- CREATED_BY
174 -- OBJECT_VERSION_NUMBER
175 -- LAST_UPDATE_DATE
176 -- LAST_UPDATED_BY
177 -- LAST_UPDATE_LOGIN
178 -- SUS_FINANCIAL_ELEM_ID
179 -- SUS_PRODUCT_ID
180 -- SUS_NATURAL_ACCOUNT_ID
181 -- SUS_CHANNEL_ID
182 -- SUS_LINE_ITEM_ID
183 -- SUS_PROJECT_ID
184 -- SUS_CUSTOMER_ID
185 -- SUS_TASK_ID
186 -- SUS_USER_DIM1_ID
187 -- SUS_USER_DIM2_ID
188 -- SUS_USER_DIM3_ID
189 -- SUS_USER_DIM4_ID
190 -- SUS_USER_DIM5_ID
191 -- SUS_USER_DIM6_ID
192 -- SUS_USER_DIM7_ID
193 -- SUS_USER_DIM8_ID
194 -- SUS_USER_DIM9_ID
195 -- SUS_USER_DIM10_ID
196 -- RULE_NAME
197 -- DESCRIPTION
198 -- owner
199 -- custom_mode
200
201 -- Example
202 -- GCS_INTERCO_RULES_PKG.Load_Row(...);
203 -- Notes
204 --
205 PROCEDURE Load_Row
206 (
207 row_id IN OUT NOCOPY VARCHAR2,
208 RULE_ID NUMBER,
209 ENABLED_FLAG VARCHAR2,
210 THRESHOLD_AMOUNT NUMBER,
211 THRESHOLD_CURRENCY VARCHAR2,
212 CREATION_DATE DATE,
213 CREATED_BY NUMBER,
214 OBJECT_VERSION_NUMBER NUMBER,
215 LAST_UPDATE_DATE DATE,
216 LAST_UPDATED_BY NUMBER,
217 LAST_UPDATE_LOGIN NUMBER,
218 SUS_FINANCIAL_ELEM_ID NUMBER,
219 SUS_PRODUCT_ID NUMBER,
220 SUS_NATURAL_ACCOUNT_ID NUMBER,
221 SUS_CHANNEL_ID NUMBER,
222 SUS_LINE_ITEM_ID NUMBER,
223 SUS_PROJECT_ID NUMBER,
224 SUS_CUSTOMER_ID NUMBER,
225 SUS_TASK_ID NUMBER,
226 SUS_USER_DIM1_ID NUMBER,
227 SUS_USER_DIM2_ID NUMBER,
228 SUS_USER_DIM3_ID NUMBER,
229 SUS_USER_DIM4_ID NUMBER,
230 SUS_USER_DIM5_ID NUMBER,
231 SUS_USER_DIM6_ID NUMBER,
232 SUS_USER_DIM7_ID NUMBER,
233 SUS_USER_DIM8_ID NUMBER,
234 SUS_USER_DIM9_ID NUMBER,
235 SUS_USER_DIM10_ID NUMBER,
236 RULE_NAME varchar2,
237 DESCRIPTION varchar2,
238 owner varchar2,
239 custom_mode varchar2
240 );
241
242
243 -- Procedure
244 -- Translate_Row
245 -- Purpose
246 -- Translates a row into the gcs_interco_rules_tl table.
247 -- Arguments
248 -- RULE_ID
249 -- LANGUAGE
250 -- SOURCE_LANG
251 -- RULE_NAME
252 -- OBJECT_VERSION_NUMBER
253 -- CREATION_DATE
254 -- CREATED_BY
255 -- LAST_UPDATE_DATE
256 -- LAST_UPDATED_BY
257 -- LAST_UPDATE_LOGIN
258 -- DESCRIPTION
259 -- owner
260 -- custom_mode
261
262 -- Example
263 -- GCS_INTERCO_RULES_PKG.Translate_Row(...);
264 -- Notes
265 --
266
267 PROCEDURE Translate_Row
268 (
269 RULE_ID NUMBER,
270 RULE_NAME VARCHAR2,
271 OBJECT_VERSION_NUMBER NUMBER,
272 CREATION_DATE DATE,
273 CREATED_BY NUMBER,
274 LAST_UPDATE_DATE DATE,
275 LAST_UPDATED_BY NUMBER,
276 LAST_UPDATE_LOGIN NUMBER,
277 DESCRIPTION VARCHAR2,
278 owner varchar2,
279 custom_mode varchar2
280
281 );
282
283 procedure ADD_LANGUAGE ;
284
285
286 END GCS_INTERCO_RULES_PKG;