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