78: CURSOR C2 IS
79: SELECT CSI_COUNTER_READINGS_S.nextval
80: FROM dual;
81: BEGIN
82: IF (px_COUNTER_INTERFACE_ID IS NULL) OR (px_COUNTER_INTERFACE_ID = FND_API.G_MISS_NUM) then
83: OPEN C1;
84: FETCH C1 INTO px_COUNTER_INTERFACE_ID;
85: CLOSE C1;
86: END IF;
84: FETCH C1 INTO px_COUNTER_INTERFACE_ID;
85: CLOSE C1;
86: END IF;
87:
88: IF (px_COUNTER_VALUE_ID IS NULL) OR (px_COUNTER_VALUE_ID = FND_API.G_MISS_NUM) then
89: OPEN c2;
90: FETCH c2 INTO px_COUNTER_VALUE_ID;
91: CLOSE c2;
92: END IF;
158: ,SOURCE_COUNTER_VALUE_ID
159: )
160: VALUES
161: (px_COUNTER_INTERFACE_ID
162: ,decode(p_PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL,p_PARALLEL_WORKER_ID)
163: ,decode(p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,p_BATCH_NAME)
164: ,decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_SOURCE_TRANSACTION_DATE)
165: ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)
166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
159: )
160: VALUES
161: (px_COUNTER_INTERFACE_ID
162: ,decode(p_PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL,p_PARALLEL_WORKER_ID)
163: ,decode(p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,p_BATCH_NAME)
164: ,decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_SOURCE_TRANSACTION_DATE)
165: ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)
166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
167: ,px_COUNTER_VALUE_ID
160: VALUES
161: (px_COUNTER_INTERFACE_ID
162: ,decode(p_PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL,p_PARALLEL_WORKER_ID)
163: ,decode(p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,p_BATCH_NAME)
164: ,decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_SOURCE_TRANSACTION_DATE)
165: ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)
166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
167: ,px_COUNTER_VALUE_ID
168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
161: (px_COUNTER_INTERFACE_ID
162: ,decode(p_PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL,p_PARALLEL_WORKER_ID)
163: ,decode(p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,p_BATCH_NAME)
164: ,decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_SOURCE_TRANSACTION_DATE)
165: ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)
166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
167: ,px_COUNTER_VALUE_ID
168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
169: ,decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_VALUE_TIMESTAMP)
162: ,decode(p_PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL,p_PARALLEL_WORKER_ID)
163: ,decode(p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,p_BATCH_NAME)
164: ,decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_SOURCE_TRANSACTION_DATE)
165: ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)
166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
167: ,px_COUNTER_VALUE_ID
168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
169: ,decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_VALUE_TIMESTAMP)
170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
164: ,decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_SOURCE_TRANSACTION_DATE)
165: ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)
166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
167: ,px_COUNTER_VALUE_ID
168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
169: ,decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_VALUE_TIMESTAMP)
170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
165: ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)
166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
167: ,px_COUNTER_VALUE_ID
168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
169: ,decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_VALUE_TIMESTAMP)
170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
167: ,px_COUNTER_VALUE_ID
168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
169: ,decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_VALUE_TIMESTAMP)
170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
167: ,px_COUNTER_VALUE_ID
168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
169: ,decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_VALUE_TIMESTAMP)
170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
169: ,decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_VALUE_TIMESTAMP)
170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
169: ,decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_VALUE_TIMESTAMP)
170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
176: ,decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_LAST_UPDATE_DATE)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
178: ,decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), TO_DATE(NULL),p_CREATION_DATE)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
222: ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
222: ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
223: ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
222: ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
223: ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
224: ,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID));
217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
222: ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
223: ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
224: ,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID));
225: END insert_row;
218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
222: ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
223: ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
224: ,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID));
225: END insert_row;
226:
219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
222: ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
223: ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
224: ,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID));
225: END insert_row;
226:
227:
220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
222: ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
223: ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
224: ,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID));
225: END insert_row;
226:
227:
228: PROCEDURE Update_Row(
291: ,p_LIFE_TO_DATE_READING NUMBER
292: ,p_SOURCE_COUNTER_VALUE_ID NUMBER) IS
293: BEGIN
294: UPDATE CSI_CTR_READINGS_INTERFACE
295: SET PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
296: ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)
297: ,SOURCE_TRANSACTION_DATE = decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), NULL, SOURCE_TRANSACTION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_SOURCE_TRANSACTION_DATE)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
292: ,p_SOURCE_COUNTER_VALUE_ID NUMBER) IS
293: BEGIN
294: UPDATE CSI_CTR_READINGS_INTERFACE
295: SET PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
296: ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)
297: ,SOURCE_TRANSACTION_DATE = decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), NULL, SOURCE_TRANSACTION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_SOURCE_TRANSACTION_DATE)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
293: BEGIN
294: UPDATE CSI_CTR_READINGS_INTERFACE
295: SET PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
296: ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)
297: ,SOURCE_TRANSACTION_DATE = decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), NULL, SOURCE_TRANSACTION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_SOURCE_TRANSACTION_DATE)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
294: UPDATE CSI_CTR_READINGS_INTERFACE
295: SET PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
296: ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)
297: ,SOURCE_TRANSACTION_DATE = decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), NULL, SOURCE_TRANSACTION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_SOURCE_TRANSACTION_DATE)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302: ,VALUE_TIMESTAMP = decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), NULL, VALUE_TIMESTAMP, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_VALUE_TIMESTAMP)
295: SET PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
296: ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)
297: ,SOURCE_TRANSACTION_DATE = decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), NULL, SOURCE_TRANSACTION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_SOURCE_TRANSACTION_DATE)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302: ,VALUE_TIMESTAMP = decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), NULL, VALUE_TIMESTAMP, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_VALUE_TIMESTAMP)
303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
296: ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)
297: ,SOURCE_TRANSACTION_DATE = decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), NULL, SOURCE_TRANSACTION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_SOURCE_TRANSACTION_DATE)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302: ,VALUE_TIMESTAMP = decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), NULL, VALUE_TIMESTAMP, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_VALUE_TIMESTAMP)
303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
297: ,SOURCE_TRANSACTION_DATE = decode(To_Char(p_SOURCE_TRANSACTION_DATE,'dd-mon-yyyy'), NULL, SOURCE_TRANSACTION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_SOURCE_TRANSACTION_DATE)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302: ,VALUE_TIMESTAMP = decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), NULL, VALUE_TIMESTAMP, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_VALUE_TIMESTAMP)
303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302: ,VALUE_TIMESTAMP = decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), NULL, VALUE_TIMESTAMP, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_VALUE_TIMESTAMP)
303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
306:
299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302: ,VALUE_TIMESTAMP = decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), NULL, VALUE_TIMESTAMP, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_VALUE_TIMESTAMP)
303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
306:
307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302: ,VALUE_TIMESTAMP = decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), NULL, VALUE_TIMESTAMP, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_VALUE_TIMESTAMP)
303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
306:
307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302: ,VALUE_TIMESTAMP = decode(To_Char(p_VALUE_TIMESTAMP,'dd-mon-yyyy'), NULL, VALUE_TIMESTAMP, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_VALUE_TIMESTAMP)
303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
306:
307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
306:
307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
310: ,LAST_UPDATE_DATE = decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), NULL, LAST_UPDATE_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL,p_LAST_UPDATE_DATE)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
306:
307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
310: ,LAST_UPDATE_DATE = decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), NULL, LAST_UPDATE_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL,p_LAST_UPDATE_DATE)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
306:
307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
310: ,LAST_UPDATE_DATE = decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), NULL, LAST_UPDATE_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL,p_LAST_UPDATE_DATE)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
306:
307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
310: ,LAST_UPDATE_DATE = decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), NULL, LAST_UPDATE_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL,p_LAST_UPDATE_DATE)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
310: ,LAST_UPDATE_DATE = decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), NULL, LAST_UPDATE_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL,p_LAST_UPDATE_DATE)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
310: ,LAST_UPDATE_DATE = decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), NULL, LAST_UPDATE_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL,p_LAST_UPDATE_DATE)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
310: ,LAST_UPDATE_DATE = decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), NULL, LAST_UPDATE_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL,p_LAST_UPDATE_DATE)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
310: ,LAST_UPDATE_DATE = decode(To_Char(p_LAST_UPDATE_DATE,'dd-mon-yyyy'), NULL, LAST_UPDATE_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL,p_LAST_UPDATE_DATE)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
312: ,CREATION_DATE = decode(To_Char(p_CREATION_DATE,'dd-mon-yyyy'), NULL, CREATION_DATE, To_Char(FND_API.G_MISS_DATE,'dd-mon-yyyy'), NULL, p_CREATION_DATE)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
348: ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
356: ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
356: ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
357: ,LIFE_TO_DATE_READING = decode(p_LIFE_TO_DATE_READING, NULL, LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
356: ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
357: ,LIFE_TO_DATE_READING = decode(p_LIFE_TO_DATE_READING, NULL, LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
358: ,SOURCE_COUNTER_VALUE_ID = decode(p_SOURCE_COUNTER_VALUE_ID, NULL, SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
356: ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
357: ,LIFE_TO_DATE_READING = decode(p_LIFE_TO_DATE_READING, NULL, LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
358: ,SOURCE_COUNTER_VALUE_ID = decode(p_SOURCE_COUNTER_VALUE_ID, NULL, SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
359: WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID;
352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
356: ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
357: ,LIFE_TO_DATE_READING = decode(p_LIFE_TO_DATE_READING, NULL, LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
358: ,SOURCE_COUNTER_VALUE_ID = decode(p_SOURCE_COUNTER_VALUE_ID, NULL, SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
359: WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID;
360: END update_row;
353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
356: ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
357: ,LIFE_TO_DATE_READING = decode(p_LIFE_TO_DATE_READING, NULL, LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
358: ,SOURCE_COUNTER_VALUE_ID = decode(p_SOURCE_COUNTER_VALUE_ID, NULL, SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
359: WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID;
360: END update_row;
361:
354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
356: ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
357: ,LIFE_TO_DATE_READING = decode(p_LIFE_TO_DATE_READING, NULL, LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
358: ,SOURCE_COUNTER_VALUE_ID = decode(p_SOURCE_COUNTER_VALUE_ID, NULL, SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
359: WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID;
360: END update_row;
361:
362: