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