[Home] [Help]
PACKAGE: APPS.GCS_ELIM_RULES_PKG
Source
1 PACKAGE GCS_ELIM_RULES_PKG AS
2 /* $Header: gcselimruless.pls 120.1 2005/10/30 05:17:57 appldev noship $ */
3
4 -- Procedure
5 -- Insert_Row
6 -- Purpose
7 -- Inserts a row the
8 -- gcs_elim_rules_b and gcs_elim_rules_b table.
9 -- Arguments
10 -- row_id
11 -- RULE_ID
12 -- SEEDED_RULE_FLAG
13 -- TRANSACTION_TYPE_CODE
14 -- RULE_TYPE_CODE
15 -- FROM_TREATMENT_ID
16 -- TO_TREATMENT_ID
17 -- ENABLED_FLAG
18 -- OBJECT_VERSION_NUMBER
19 -- LAST_UPDATE_DATE
20 -- LAST_UPDATED_BY
21 -- CREATION_DATE
22 -- CREATED_BY
23 -- LAST_UPDATE_LOGIN
24 -- RULE_NAME
25 -- DESCRIPTION
26
27
28 -- Example
29 -- GCS_ELIM_RULES_PKG.Insert_Row(...);
30 -- Notes
31 --
32
33
34 PROCEDURE Insert_Row
35 (
36 row_id IN OUT NOCOPY VARCHAR2,
37 RULE_ID NUMBER,
38 SEEDED_RULE_FLAG VARCHAR2,
39 TRANSACTION_TYPE_CODE VARCHAR2,
40 RULE_TYPE_CODE VARCHAR2,
41 FROM_TREATMENT_ID NUMBER,
42 TO_TREATMENT_ID NUMBER,
43 ENABLED_FLAG VARCHAR2,
44 OBJECT_VERSION_NUMBER NUMBER,
45 LAST_UPDATE_DATE DATE,
46 LAST_UPDATED_BY NUMBER,
47 CREATION_DATE DATE,
48 CREATED_BY NUMBER,
49 LAST_UPDATE_LOGIN NUMBER,
50 RULE_NAME VARCHAR2,
51 DESCRIPTION VARCHAR2
52 );
53
54 --****************************************
55
56 -- Procedure
57 -- Translate_Row
58 -- Purpose
59 -- Updates a row in the
60 -- gcs_elim_rules_b table.
61 -- Arguments
62 -- row_id
63 -- RULE_ID
64 -- SEEDED_RULE_FLAG
65 -- TRANSACTION_TYPE_CODE
66 -- RULE_TYPE_CODE
67 -- FROM_TREATMENT_ID
68 -- TO_TREATMENT_ID
69 -- ENABLED_FLAG
70 -- OBJECT_VERSION_NUMBER
71 -- LAST_UPDATE_DATE
72 -- LAST_UPDATED_BY
73 -- CREATION_DATE
74 -- CREATED_BY
75 -- LAST_UPDATE_LOGIN
76 -- RULE_NAME
77 -- DESCRIPTION
78
79
80 -- Example
81 -- GCS_ELIM_RULES_PKG.Update_Row(...);
82 -- Notes
83 --
84
85 PROCEDURE Update_Row
86 (
87 row_id IN OUT NOCOPY VARCHAR2,
88 RULE_ID NUMBER,
89 SEEDED_RULE_FLAG VARCHAR2,
90 TRANSACTION_TYPE_CODE VARCHAR2,
91 RULE_TYPE_CODE VARCHAR2,
92 FROM_TREATMENT_ID NUMBER,
93 TO_TREATMENT_ID NUMBER,
94 ENABLED_FLAG VARCHAR2,
95 OBJECT_VERSION_NUMBER NUMBER,
96 LAST_UPDATE_DATE DATE,
97 LAST_UPDATED_BY NUMBER,
98 CREATION_DATE DATE,
99 CREATED_BY NUMBER,
100 LAST_UPDATE_LOGIN NUMBER,
101 RULE_NAME VARCHAR2,
102 DESCRIPTION VARCHAR2
103 );
104 --****************************************
105
106 -- Procedure
107 -- Load_Row
108 -- Purpose
109 -- loads a row in the
110 -- gcs_elim_rules_b table.
111 -- Arguments
112 -- row_id
113 -- RULE_ID
114 -- SEEDED_RULE_FLAG
115 -- TRANSACTION_TYPE_CODE
116 -- RULE_TYPE_CODE
117 -- FROM_TREATMENT_ID
118 -- TO_TREATMENT_ID
119 -- ENABLED_FLAG
120 -- OBJECT_VERSION_NUMBER
121 -- LAST_UPDATE_DATE
122 -- LAST_UPDATED_BY
123 -- CREATION_DATE
124 -- CREATED_BY
125 -- LAST_UPDATE_LOGIN
126 -- owner
127 -- custom_mode
128 -- RULE_NAME
129 -- DESCRIPTION
130
131
132 -- Example
133 -- GCS_ELIM_RULES_PKG.Load_Row(...);
134 -- Notes
135 --
136
137 PROCEDURE Load_Row
138 (
139 row_id IN OUT NOCOPY VARCHAR2,
140 RULE_ID NUMBER,
141 SEEDED_RULE_FLAG VARCHAR2,
142 TRANSACTION_TYPE_CODE VARCHAR2,
143 RULE_TYPE_CODE VARCHAR2,
144 FROM_TREATMENT_ID NUMBER,
145 TO_TREATMENT_ID NUMBER,
146 ENABLED_FLAG VARCHAR2,
147 OBJECT_VERSION_NUMBER NUMBER,
148 LAST_UPDATE_DATE DATE,
149 LAST_UPDATED_BY NUMBER,
150 CREATION_DATE DATE,
151 CREATED_BY NUMBER,
152 LAST_UPDATE_LOGIN NUMBER,
153 owner varchar2,
154 custom_mode varchar2,
155 RULE_NAME VARCHAR2,
156 DESCRIPTION VARCHAR2
157 );
158
159
160 -- Procedure
161 -- Translate_Row
162 -- Purpose
163 -- Updates translated infromation for a row in the
164 -- gcs_elim_rules_tl table.
165 -- Arguments
166 -- RULE_ID
167 -- LANGUAGE
168 -- SOURCE_LANG
169 -- RULE_NAME
170 -- DESCRIPTION
171 -- LAST_UPDATE_DATE
172 -- LAST_UPDATED_BY
173 -- CREATION_DATE
174 -- CREATED_BY
175 -- LAST_UPDATE_LOGIN
176 -- owner
177 -- custom_mode
178 -- RULE_NAME
179 -- DESCRIPTION
180
181 -- Example
182 -- GCS_ELIM_RULES_PKG.Translate_Row(...);
183 -- Notes
184 --
185
186
187 PROCEDURE Translate_Row
188 (
189 RULE_ID NUMBER,
190 RULE_NAME VARCHAR2,
191 DESCRIPTION VARCHAR2,
192 LAST_UPDATE_DATE DATE,
193 LAST_UPDATED_BY NUMBER,
194 CREATION_DATE DATE,
195 CREATED_BY NUMBER,
196 LAST_UPDATE_LOGIN NUMBER,
197 owner VARCHAR2,
198 custom_mode VARCHAR2
199 );
200
201 procedure ADD_LANGUAGE ;
202
203
204
205 END GCS_ELIM_RULES_PKG;