DBA Data[Home] [Help]

APPS.CSI_CTR_READING_INTERFACE_PKG dependencies on FND_API

Line 82: IF (px_COUNTER_INTERFACE_ID IS NULL) OR (px_COUNTER_INTERFACE_ID = FND_API.G_MISS_NUM) then

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;

Line 88: IF (px_COUNTER_VALUE_ID IS NULL) OR (px_COUNTER_VALUE_ID = FND_API.G_MISS_NUM) then

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;

Line 162: ,decode(p_PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL,p_PARALLEL_WORKER_ID)

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)

Line 163: ,decode(p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,p_BATCH_NAME)

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

Line 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)

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)

Line 165: ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)

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)

Line 166: ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)

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)

Line 168: ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)

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)

Line 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)

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)

Line 170: ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)

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)

Line 171: ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)

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)

Line 172: ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)

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)

Line 173: ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)

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)

Line 174: ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)

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)

Line 175: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)

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)

Line 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)

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)

Line 177: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)

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)

Line 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)

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)

Line 179: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)

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)

Line 180: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)

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)

Line 181: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)

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)

Line 182: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)

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)

Line 183: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)

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)

Line 184: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)

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)

Line 185: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)

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)

Line 186: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)

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)

Line 187: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)

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)

Line 188: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)

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)

Line 189: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)

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)

Line 190: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)

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)

Line 191: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)

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)

Line 192: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)

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)

Line 193: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)

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)

Line 194: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)

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)

Line 195: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)

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)

Line 196: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)

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)

Line 197: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)

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)

Line 198: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)

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)

Line 199: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)

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)

Line 200: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)

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)

Line 201: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)

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)

Line 202: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)

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)

Line 203: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)

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)

Line 204: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)

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)

Line 205: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)

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)

Line 206: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)

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)

Line 207: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)

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)

Line 208: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)

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)

Line 209: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)

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)

Line 210: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)

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)

Line 211: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)

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)

Line 212: ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)

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)

Line 213: ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)

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)

Line 214: ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_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)

Line 215: ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)

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)

Line 216: ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)

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)

Line 217: ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)

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)

Line 218: ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)

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)

Line 219: ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)

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)

Line 220: ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)

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));

Line 221: ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)

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;

Line 222: ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)

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:

Line 223: ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)

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:

Line 224: ,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID));

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(

Line 295: SET PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)

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)

Line 296: ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)

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)

Line 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)

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)

Line 298: ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)

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)

Line 299: ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)

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)

Line 300: ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_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)
304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)

Line 301: ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)

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)

Line 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)

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:

Line 303: ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)

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)

Line 304: ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)

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)

Line 305: ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)

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)

Line 307: ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)

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)

Line 308: ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_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)
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)

Line 309: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)

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)

Line 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)

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)

Line 311: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)

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)

Line 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)

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)

Line 313: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

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)

Line 314: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

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)

Line 315: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

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)

Line 316: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

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)

Line 317: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

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)

Line 318: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

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)

Line 319: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

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)

Line 320: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

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)

Line 321: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

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)

Line 322: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

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)

Line 323: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

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)

Line 324: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

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)

Line 325: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

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)

Line 326: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

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)

Line 327: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

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)

Line 328: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

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)

Line 329: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

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)

Line 330: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)

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)

Line 331: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)

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)

Line 332: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)

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)

Line 333: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)

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)

Line 334: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)

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)

Line 335: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)

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)

Line 336: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)

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)

Line 337: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)

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)

Line 338: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)

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)

Line 339: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)

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)

Line 340: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)

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)

Line 341: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)

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)

Line 342: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)

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)

Line 343: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)

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)

Line 344: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)

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)

Line 345: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)

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)

Line 346: ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)

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)

Line 347: ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)

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)

Line 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)

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)

Line 349: ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)

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)

Line 350: ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)

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)

Line 351: ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)

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)

Line 352: ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)

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)

Line 353: ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)

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)

Line 354: ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)

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)

Line 355: ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)

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;

Line 356: ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)

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;

Line 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)

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:

Line 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)

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: