eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_COUNTER_TEMPLATE_PKG dependencies on FND_API

Line 91: IF (px_COUNTER_ID IS NULL) OR (px_COUNTER_ID = FND_API.G_MISS_NUM) then

87: CURSOR C1 IS
88: SELECT CSI_COUNTERS_B_S.nextval
89: FROM dual;
90: BEGIN
91: IF (px_COUNTER_ID IS NULL) OR (px_COUNTER_ID = FND_API.G_MISS_NUM) then
92: OPEN C1;
93: FETCH C1 INTO px_COUNTER_ID;
94: CLOSE C1;
95: END IF;

Line 176: ,decode(p_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_GROUP_ID)

172: ,EAM_REQUIRED_FLAG
173: )
174: VALUES(
175: px_COUNTER_ID
176: ,decode(p_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_GROUP_ID)
177: ,decode(p_COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_COUNTER_TYPE)
178: ,decode(p_INITIAL_READING, FND_API.G_MISS_NUM, NULL,p_INITIAL_READING)
179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)
180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)

Line 177: ,decode(p_COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_COUNTER_TYPE)

173: )
174: VALUES(
175: px_COUNTER_ID
176: ,decode(p_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_GROUP_ID)
177: ,decode(p_COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_COUNTER_TYPE)
178: ,decode(p_INITIAL_READING, FND_API.G_MISS_NUM, NULL,p_INITIAL_READING)
179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)
180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)
181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)

Line 178: ,decode(p_INITIAL_READING, FND_API.G_MISS_NUM, NULL,p_INITIAL_READING)

174: VALUES(
175: px_COUNTER_ID
176: ,decode(p_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_GROUP_ID)
177: ,decode(p_COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_COUNTER_TYPE)
178: ,decode(p_INITIAL_READING, FND_API.G_MISS_NUM, NULL,p_INITIAL_READING)
179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)
180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)
181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)
182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)

Line 179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)

175: px_COUNTER_ID
176: ,decode(p_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_GROUP_ID)
177: ,decode(p_COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_COUNTER_TYPE)
178: ,decode(p_INITIAL_READING, FND_API.G_MISS_NUM, NULL,p_INITIAL_READING)
179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)
180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)
181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)
182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)
183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)

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

176: ,decode(p_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_GROUP_ID)
177: ,decode(p_COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_COUNTER_TYPE)
178: ,decode(p_INITIAL_READING, FND_API.G_MISS_NUM, NULL,p_INITIAL_READING)
179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)
180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)
181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)
182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)
183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)
184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)

Line 181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)

177: ,decode(p_COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_COUNTER_TYPE)
178: ,decode(p_INITIAL_READING, FND_API.G_MISS_NUM, NULL,p_INITIAL_READING)
179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)
180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)
181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)
182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)
183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)
184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)
185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)

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

178: ,decode(p_INITIAL_READING, FND_API.G_MISS_NUM, NULL,p_INITIAL_READING)
179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)
180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)
181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)
182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)
183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)
184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)
185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)
186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)

Line 183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)

179: ,decode(p_INITIAL_READING_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_INITIAL_READING_DATE)
180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)
181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)
182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)
183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)
184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)
185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)
186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)
187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)

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

180: ,decode(p_TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_PLUS)
181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)
182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)
183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)
184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)
185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)
186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)
187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)
188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)

Line 185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)

181: ,decode(p_TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL,p_TOLERANCE_MINUS)
182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)
183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)
184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)
185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)
186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)
187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)
188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)
189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)

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

182: ,decode(p_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_UOM_CODE)
183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)
184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)
185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)
186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)
187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)
188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)
189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)
190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)

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

183: ,decode(p_DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_COUNTER_ID)
184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)
185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)
186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)
187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)
188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)
189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)
190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)
191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)

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

184: ,decode(p_DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL,p_DERIVE_FUNCTION)
185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)
186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)
187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)
188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)
189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)
190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)
191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)
192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)

Line 189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)

185: ,decode(p_DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL,p_DERIVE_PROPERTY_ID)
186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)
187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)
188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)
189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)
190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)
191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)
192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)
193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)

Line 190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)

186: ,decode(p_VALID_FLAG, FND_API.G_MISS_CHAR, NULL,p_VALID_FLAG)
187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)
188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)
189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)
190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)
191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)
192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)
193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)
194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)

Line 191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)

187: ,decode(p_FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL,p_FORMULA_INCOMPLETE_FLAG)
188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)
189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)
190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)
191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)
192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)
193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)
194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)
195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)

Line 192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)

188: ,decode(p_FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL,p_FORMULA_TEXT)
189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)
190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)
191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)
192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)
193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)
194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)
195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)

Line 193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)

189: ,decode(p_ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_LAST_READING)
190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)
191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)
192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)
193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)
194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)
195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)

Line 194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)

190: ,decode(p_ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL,p_ROLLOVER_FIRST_READING)
191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)
192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)
193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)
194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)
195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)

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

191: ,decode(p_USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_USAGE_ITEM_ID)
192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)
193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)
194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)
195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)

Line 196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)

192: ,decode(p_CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, NULL,p_CTR_VAL_MAX_SEQ_NO)
193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)
194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)
195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)

Line 197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)

193: ,decode(p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_START_DATE_ACTIVE)
194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)
195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)

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

194: ,decode(p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_END_DATE_ACTIVE)
195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)

Line 199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)

195: ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)

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

196: ,decode(p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_SECURITY_GROUP_ID)
197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)

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

197: ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)

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

198: ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)

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

199: ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)

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

200: ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)

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

201: ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)

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

202: ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)

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

203: ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)

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

204: ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)

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

205: ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)

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

206: ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)

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

207: ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)

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

208: ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)

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

209: ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)

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

210: ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)

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

211: ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)

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

212: ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)

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

213: ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)

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

214: ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)

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

215: ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)

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

216: ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)

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

217: ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)

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

218: ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)

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

219: ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)

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

220: ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)

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

221: ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)

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

222: ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)

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

223: ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)

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

224: ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)

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

225: ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)

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

226: ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)
234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)

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

227: ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)
234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)
235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)

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

228: ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)
234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)
235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)
236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)

Line 233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)

229: ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)
234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)
235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)
236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)
237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)

Line 234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)

230: ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)
234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)
235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)
236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)
237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)
238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)

Line 235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)

231: ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)
234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)
235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)
236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)
237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)
238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)
239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)

Line 236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)

232: ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)
234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)
235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)
236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)
237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)
238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)
239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)
240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)

Line 237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)

233: ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG)
234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)
235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)
236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)
237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)
238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)
239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)
240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)
241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)

Line 238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)

234: ,decode(p_CUSTOMER_VIEW, FND_API.G_MISS_CHAR, NULL,p_CUSTOMER_VIEW)
235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)
236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)
237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)
238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)
239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)
240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)
241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)
242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)

Line 239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)

235: ,decode(p_DIRECTION, FND_API.G_MISS_CHAR, NULL,p_DIRECTION)
236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)
237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)
238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)
239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)
240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)
241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)
242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)
243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)

Line 240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)

236: ,decode(p_FILTER_TYPE, FND_API.G_MISS_CHAR, NULL,p_FILTER_TYPE)
237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)
238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)
239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)
240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)
241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)
242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)
243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)
244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)

Line 241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)

237: ,decode(p_FILTER_READING_COUNT, FND_API.G_MISS_NUM, NULL,p_FILTER_READING_COUNT)
238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)
239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)
240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)
241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)
242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)
243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)
244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)
245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)

Line 242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)

238: ,decode(p_FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL,p_FILTER_TIME_UOM)
239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)
240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)
241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)
242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)
243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)
244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)
245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)
246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)

Line 243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)

239: ,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL,p_ESTIMATION_ID)
240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)
241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)
242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)
243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)
244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)
245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)
246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)
247: ,decode(p_STEP_VALUE, FND_API.G_MISS_NUM, NULL,p_STEP_VALUE)

Line 244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)

240: ,decode(p_ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL,p_ASSOCIATION_TYPE)
241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)
242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)
243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)
244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)
245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)
246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)
247: ,decode(p_STEP_VALUE, FND_API.G_MISS_NUM, NULL,p_STEP_VALUE)
248: ,decode(p_TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL,p_TIME_BASED_MANUAL_ENTRY)

Line 245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)

241: ,decode(p_READING_TYPE, FND_API.G_MISS_NUM, NULL,p_READING_TYPE)
242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)
243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)
244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)
245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)
246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)
247: ,decode(p_STEP_VALUE, FND_API.G_MISS_NUM, NULL,p_STEP_VALUE)
248: ,decode(p_TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL,p_TIME_BASED_MANUAL_ENTRY)
249: ,decode(p_EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL,p_EAM_REQUIRED_FLAG)

Line 246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)

242: ,decode(p_AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR, NULL,p_AUTOMATIC_ROLLOVER)
243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)
244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)
245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)
246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)
247: ,decode(p_STEP_VALUE, FND_API.G_MISS_NUM, NULL,p_STEP_VALUE)
248: ,decode(p_TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL,p_TIME_BASED_MANUAL_ENTRY)
249: ,decode(p_EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL,p_EAM_REQUIRED_FLAG)
250: );

Line 247: ,decode(p_STEP_VALUE, FND_API.G_MISS_NUM, NULL,p_STEP_VALUE)

243: ,decode(p_DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM, NULL,p_DEFAULT_USAGE_RATE)
244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)
245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)
246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)
247: ,decode(p_STEP_VALUE, FND_API.G_MISS_NUM, NULL,p_STEP_VALUE)
248: ,decode(p_TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL,p_TIME_BASED_MANUAL_ENTRY)
249: ,decode(p_EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL,p_EAM_REQUIRED_FLAG)
250: );
251:

Line 248: ,decode(p_TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL,p_TIME_BASED_MANUAL_ENTRY)

244: ,decode(p_USE_PAST_READING, FND_API.G_MISS_NUM, NULL,p_USE_PAST_READING)
245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)
246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)
247: ,decode(p_STEP_VALUE, FND_API.G_MISS_NUM, NULL,p_STEP_VALUE)
248: ,decode(p_TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL,p_TIME_BASED_MANUAL_ENTRY)
249: ,decode(p_EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL,p_EAM_REQUIRED_FLAG)
250: );
251:
252: INSERT INTO CSI_COUNTER_TEMPLATE_TL(

Line 249: ,decode(p_EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL,p_EAM_REQUIRED_FLAG)

245: ,decode(p_USED_IN_SCHEDULING, FND_API.G_MISS_CHAR, NULL,p_USED_IN_SCHEDULING)
246: ,decode(p_DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL,p_DEFAULTED_GROUP_ID)
247: ,decode(p_STEP_VALUE, FND_API.G_MISS_NUM, NULL,p_STEP_VALUE)
248: ,decode(p_TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL,p_TIME_BASED_MANUAL_ENTRY)
249: ,decode(p_EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL,p_EAM_REQUIRED_FLAG)
250: );
251:
252: INSERT INTO CSI_COUNTER_TEMPLATE_TL(
253: COUNTER_ID

Line 265: ,decode(p_name, fnd_api.g_miss_char, NULL, p_name)

261: ,LAST_UPDATE_DATE
262: ,LAST_UPDATE_LOGIN
263: )
264: SELECT px_counter_id
265: ,decode(p_name, fnd_api.g_miss_char, NULL, p_name)
266: ,decode(p_description, fnd_api.g_miss_char, NULL, p_description)
267: ,l.language_code
268: ,userenv('LANG')
269: ,decode(p_created_by, fnd_api.g_miss_num, NULL, p_created_by)

Line 266: ,decode(p_description, fnd_api.g_miss_char, NULL, p_description)

262: ,LAST_UPDATE_LOGIN
263: )
264: SELECT px_counter_id
265: ,decode(p_name, fnd_api.g_miss_char, NULL, p_name)
266: ,decode(p_description, fnd_api.g_miss_char, NULL, p_description)
267: ,l.language_code
268: ,userenv('LANG')
269: ,decode(p_created_by, fnd_api.g_miss_num, NULL, p_created_by)
270: ,decode(p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date)

Line 269: ,decode(p_created_by, fnd_api.g_miss_num, NULL, p_created_by)

265: ,decode(p_name, fnd_api.g_miss_char, NULL, p_name)
266: ,decode(p_description, fnd_api.g_miss_char, NULL, p_description)
267: ,l.language_code
268: ,userenv('LANG')
269: ,decode(p_created_by, fnd_api.g_miss_num, NULL, p_created_by)
270: ,decode(p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date)
271: ,decode(p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by)
272: ,decode(p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date)
273: ,decode(p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)

Line 270: ,decode(p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date)

266: ,decode(p_description, fnd_api.g_miss_char, NULL, p_description)
267: ,l.language_code
268: ,userenv('LANG')
269: ,decode(p_created_by, fnd_api.g_miss_num, NULL, p_created_by)
270: ,decode(p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date)
271: ,decode(p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by)
272: ,decode(p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date)
273: ,decode(p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
274: FROM fnd_languages l

Line 271: ,decode(p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by)

267: ,l.language_code
268: ,userenv('LANG')
269: ,decode(p_created_by, fnd_api.g_miss_num, NULL, p_created_by)
270: ,decode(p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date)
271: ,decode(p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by)
272: ,decode(p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date)
273: ,decode(p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
274: FROM fnd_languages l
275: WHERE l.installed_flag IN ('I','B')

Line 272: ,decode(p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date)

268: ,userenv('LANG')
269: ,decode(p_created_by, fnd_api.g_miss_num, NULL, p_created_by)
270: ,decode(p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date)
271: ,decode(p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by)
272: ,decode(p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date)
273: ,decode(p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
274: FROM fnd_languages l
275: WHERE l.installed_flag IN ('I','B')
276: AND NOT EXISTS (SELECT 'x'

Line 273: ,decode(p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)

269: ,decode(p_created_by, fnd_api.g_miss_num, NULL, p_created_by)
270: ,decode(p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date)
271: ,decode(p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by)
272: ,decode(p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date)
273: ,decode(p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login)
274: FROM fnd_languages l
275: WHERE l.installed_flag IN ('I','B')
276: AND NOT EXISTS (SELECT 'x'
277: FROM csi_counter_template_tl cct

Line 362: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)

358: ,p_TIME_BASED_MANUAL_ENTRY VARCHAR2
359: ,p_EAM_REQUIRED_FLAG VARCHAR2) IS
360: BEGIN
361: UPDATE CSI_COUNTER_TEMPLATE_B
362: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)
363: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)
364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)
366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)

Line 363: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)

359: ,p_EAM_REQUIRED_FLAG VARCHAR2) IS
360: BEGIN
361: UPDATE CSI_COUNTER_TEMPLATE_B
362: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)
363: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)
364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)
366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)
367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)

Line 364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)

360: BEGIN
361: UPDATE CSI_COUNTER_TEMPLATE_B
362: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)
363: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)
364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)
366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)
367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)
368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)

Line 365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)

361: UPDATE CSI_COUNTER_TEMPLATE_B
362: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)
363: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)
364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)
366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)
367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)
368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)
369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)

Line 366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)

362: SET GROUP_ID = decode(p_GROUP_ID, NULL, GROUP_ID, FND_API.G_MISS_NUM, NULL, p_GROUP_ID)
363: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)
364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)
366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)
367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)
368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)
369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)
370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)

Line 367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)

363: ,COUNTER_TYPE = decode(p_COUNTER_TYPE, NULL, COUNTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_COUNTER_TYPE)
364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)
366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)
367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)
368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)
369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)
370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)
371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)

Line 368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)

364: ,INITIAL_READING = decode(p_INITIAL_READING, NULL, INITIAL_READING, FND_API.G_MISS_NUM, NULL, p_INITIAL_READING)
365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)
366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)
367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)
368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)
369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)
370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)
371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)
372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)

Line 369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)

365: ,INITIAL_READING_DATE = decode(p_INITIAL_READING_DATE, NULL, INITIAL_READING_DATE, FND_API.G_MISS_DATE, NULL, p_INITIAL_READING_DATE)
366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)
367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)
368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)
369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)
370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)
371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)
372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)
373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)

Line 370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)

366: ,TOLERANCE_PLUS = decode(p_TOLERANCE_PLUS, NULL, TOLERANCE_PLUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PLUS)
367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)
368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)
369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)
370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)
371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)
372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)
373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)
374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)

Line 371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)

367: ,TOLERANCE_MINUS = decode(p_TOLERANCE_MINUS, NULL, TOLERANCE_MINUS, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_MINUS)
368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)
369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)
370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)
371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)
372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)
373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)
374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)
375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)

Line 372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)

368: ,UOM_CODE = decode(p_UOM_CODE, NULL, UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE)
369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)
370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)
371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)
372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)
373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)
374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)
375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)
376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)

Line 373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)

369: ,DERIVE_COUNTER_ID = decode(p_DERIVE_COUNTER_ID, NULL, DERIVE_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_COUNTER_ID)
370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)
371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)
372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)
373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)
374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)
375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)
376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)
377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)

Line 374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)

370: ,DERIVE_FUNCTION = decode(p_DERIVE_FUNCTION, NULL, DERIVE_FUNCTION, FND_API.G_MISS_CHAR, NULL, p_DERIVE_FUNCTION)
371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)
372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)
373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)
374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)
375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)
376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)
377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)
378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)

Line 375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)

371: ,DERIVE_PROPERTY_ID = decode(p_DERIVE_PROPERTY_ID, NULL, DERIVE_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_DERIVE_PROPERTY_ID)
372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)
373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)
374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)
375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)
376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)
377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)
378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)
379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)

Line 376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)

372: ,VALID_FLAG = decode(p_VALID_FLAG, NULL, VALID_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_FLAG)
373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)
374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)
375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)
376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)
377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)
378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)
379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)

Line 377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)

373: ,FORMULA_INCOMPLETE_FLAG = decode(p_FORMULA_INCOMPLETE_FLAG, NULL, FORMULA_INCOMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORMULA_INCOMPLETE_FLAG)
374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)
375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)
376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)
377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)
378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)
379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)
381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)

Line 378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)

374: ,FORMULA_TEXT = decode(p_FORMULA_TEXT, NULL, FORMULA_TEXT, FND_API.G_MISS_CHAR, NULL, p_FORMULA_TEXT)
375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)
376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)
377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)
378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)
379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)
381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)

Line 379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)

375: ,ROLLOVER_LAST_READING = decode(p_ROLLOVER_LAST_READING, NULL, ROLLOVER_LAST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_LAST_READING)
376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)
377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)
378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)
379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)
381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)

Line 380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)

376: ,ROLLOVER_FIRST_READING = decode(p_ROLLOVER_FIRST_READING, NULL, ROLLOVER_FIRST_READING, FND_API.G_MISS_NUM, NULL, p_ROLLOVER_FIRST_READING)
377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)
378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)
379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)
381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)

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

377: ,USAGE_ITEM_ID = decode(p_USAGE_ITEM_ID, NULL, USAGE_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_USAGE_ITEM_ID)
378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)
379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)
381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

Line 382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)

378: ,CTR_VAL_MAX_SEQ_NO = decode(p_CTR_VAL_MAX_SEQ_NO, NULL, CTR_VAL_MAX_SEQ_NO, FND_API.G_MISS_NUM, CTR_VAL_MAX_SEQ_NO, p_CTR_VAL_MAX_SEQ_NO)
379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)
381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)

Line 383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)

379: ,START_DATE_ACTIVE = decode(p_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE)
380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)
381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)
387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

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

380: ,END_DATE_ACTIVE = decode(p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL,p_END_DATE_ACTIVE)
381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)
387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

Line 385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

381: ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)
387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

Line 386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)

382: ,SECURITY_GROUP_ID = decode(p_SECURITY_GROUP_ID, NULL, SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)
387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

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

383: ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)
387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

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

384: ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)
387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

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

385: ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)
387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

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

386: ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_CREATED_BY)
387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

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

387: ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

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

388: ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

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

389: ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

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

390: ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

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

391: ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

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

392: ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

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

393: ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

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

394: ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

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

395: ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)

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

396: ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)

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

397: ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)

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

398: ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)

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

399: ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)

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

400: ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)

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

401: ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)

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

402: ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)

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

403: ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)

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

404: ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)

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

405: ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)

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

406: ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)

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

407: ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)

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

408: ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)

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

409: ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)

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

410: ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)

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

411: ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)

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

412: ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)

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

413: ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)
421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)

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

414: ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)
421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)
422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)

Line 419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)

415: ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)
421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)
422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)
423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)

Line 420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)

416: ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)
421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)
422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)
423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)
424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)

Line 421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)

417: ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)
421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)
422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)
423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)
424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)
425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)

Line 422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)

418: ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)
421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)
422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)
423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)
424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)
425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)

Line 423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)

419: ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)
421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)
422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)
423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)
424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)
425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)
427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)

Line 424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)

420: ,CUSTOMER_VIEW = decode(p_CUSTOMER_VIEW, NULL, CUSTOMER_VIEW, FND_API.G_MISS_CHAR,NULL, p_CUSTOMER_VIEW)
421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)
422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)
423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)
424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)
425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)
427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)
428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)

Line 425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)

421: ,DIRECTION = decode(p_DIRECTION, NULL, DIRECTION, FND_API.G_MISS_CHAR, NULL, p_DIRECTION)
422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)
423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)
424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)
425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)
427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)
428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)
429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)

Line 426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)

422: ,FILTER_TYPE = decode(p_FILTER_TYPE, NULL, FILTER_TYPE, FND_API.G_MISS_CHAR, NULL, p_FILTER_TYPE)
423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)
424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)
425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)
427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)
428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)
429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)
430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)

Line 427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)

423: ,FILTER_READING_COUNT = decode(p_FILTER_READING_COUNT, NULL, FILTER_READING_COUNT, FND_API.G_MISS_NUM,NULL, p_FILTER_READING_COUNT)
424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)
425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)
427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)
428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)
429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)
430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)
431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)

Line 428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)

424: ,FILTER_TIME_UOM = decode(p_FILTER_TIME_UOM, NULL, FILTER_TIME_UOM, FND_API.G_MISS_CHAR, NULL, p_FILTER_TIME_UOM)
425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)
427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)
428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)
429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)
430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)
431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)
432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)

Line 429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)

425: ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)
427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)
428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)
429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)
430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)
431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)
432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)
433: ,STEP_VALUE = decode(p_STEP_VALUE, NULL, STEP_VALUE, FND_API.G_MISS_NUM, NULL, p_STEP_VALUE)

Line 430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)

426: ,ASSOCIATION_TYPE = decode(p_ASSOCIATION_TYPE, NULL, ASSOCIATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ASSOCIATION_TYPE)
427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)
428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)
429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)
430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)
431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)
432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)
433: ,STEP_VALUE = decode(p_STEP_VALUE, NULL, STEP_VALUE, FND_API.G_MISS_NUM, NULL, p_STEP_VALUE)
434: ,TIME_BASED_MANUAL_ENTRY = decode(p_TIME_BASED_MANUAL_ENTRY, NULL, TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL, p_TIME_BASED_MANUAL_ENTRY)

Line 431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)

427: ,READING_TYPE = decode(p_READING_TYPE, NULL, READING_TYPE, FND_API.G_MISS_NUM, NULL, p_READING_TYPE)
428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)
429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)
430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)
431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)
432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)
433: ,STEP_VALUE = decode(p_STEP_VALUE, NULL, STEP_VALUE, FND_API.G_MISS_NUM, NULL, p_STEP_VALUE)
434: ,TIME_BASED_MANUAL_ENTRY = decode(p_TIME_BASED_MANUAL_ENTRY, NULL, TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL, p_TIME_BASED_MANUAL_ENTRY)
435: ,EAM_REQUIRED_FLAG = decode(p_EAM_REQUIRED_FLAG, NULL, EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_EAM_REQUIRED_FLAG)

Line 432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)

428: ,AUTOMATIC_ROLLOVER = decode(p_AUTOMATIC_ROLLOVER, NULL, AUTOMATIC_ROLLOVER, FND_API.G_MISS_CHAR,NULL, p_AUTOMATIC_ROLLOVER)
429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)
430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)
431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)
432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)
433: ,STEP_VALUE = decode(p_STEP_VALUE, NULL, STEP_VALUE, FND_API.G_MISS_NUM, NULL, p_STEP_VALUE)
434: ,TIME_BASED_MANUAL_ENTRY = decode(p_TIME_BASED_MANUAL_ENTRY, NULL, TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL, p_TIME_BASED_MANUAL_ENTRY)
435: ,EAM_REQUIRED_FLAG = decode(p_EAM_REQUIRED_FLAG, NULL, EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_EAM_REQUIRED_FLAG)
436: WHERE COUNTER_ID = p_COUNTER_ID;

Line 433: ,STEP_VALUE = decode(p_STEP_VALUE, NULL, STEP_VALUE, FND_API.G_MISS_NUM, NULL, p_STEP_VALUE)

429: ,DEFAULT_USAGE_RATE = decode(p_DEFAULT_USAGE_RATE, NULL, DEFAULT_USAGE_RATE, FND_API.G_MISS_NUM,NULL, p_DEFAULT_USAGE_RATE)
430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)
431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)
432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)
433: ,STEP_VALUE = decode(p_STEP_VALUE, NULL, STEP_VALUE, FND_API.G_MISS_NUM, NULL, p_STEP_VALUE)
434: ,TIME_BASED_MANUAL_ENTRY = decode(p_TIME_BASED_MANUAL_ENTRY, NULL, TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL, p_TIME_BASED_MANUAL_ENTRY)
435: ,EAM_REQUIRED_FLAG = decode(p_EAM_REQUIRED_FLAG, NULL, EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_EAM_REQUIRED_FLAG)
436: WHERE COUNTER_ID = p_COUNTER_ID;
437:

Line 434: ,TIME_BASED_MANUAL_ENTRY = decode(p_TIME_BASED_MANUAL_ENTRY, NULL, TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL, p_TIME_BASED_MANUAL_ENTRY)

430: ,USE_PAST_READING = decode(p_USE_PAST_READING, NULL, USE_PAST_READING, FND_API.G_MISS_NUM, NULL, p_USE_PAST_READING)
431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)
432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)
433: ,STEP_VALUE = decode(p_STEP_VALUE, NULL, STEP_VALUE, FND_API.G_MISS_NUM, NULL, p_STEP_VALUE)
434: ,TIME_BASED_MANUAL_ENTRY = decode(p_TIME_BASED_MANUAL_ENTRY, NULL, TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL, p_TIME_BASED_MANUAL_ENTRY)
435: ,EAM_REQUIRED_FLAG = decode(p_EAM_REQUIRED_FLAG, NULL, EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_EAM_REQUIRED_FLAG)
436: WHERE COUNTER_ID = p_COUNTER_ID;
437:
438: UPDATE csi_counter_template_tl

Line 435: ,EAM_REQUIRED_FLAG = decode(p_EAM_REQUIRED_FLAG, NULL, EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_EAM_REQUIRED_FLAG)

431: ,USED_IN_SCHEDULING = decode(p_USED_IN_SCHEDULING, NULL, USED_IN_SCHEDULING, FND_API.G_MISS_CHAR,NULL, p_USED_IN_SCHEDULING)
432: ,DEFAULTED_GROUP_ID = decode(p_DEFAULTED_GROUP_ID, NULL, DEFAULTED_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_DEFAULTED_GROUP_ID)
433: ,STEP_VALUE = decode(p_STEP_VALUE, NULL, STEP_VALUE, FND_API.G_MISS_NUM, NULL, p_STEP_VALUE)
434: ,TIME_BASED_MANUAL_ENTRY = decode(p_TIME_BASED_MANUAL_ENTRY, NULL, TIME_BASED_MANUAL_ENTRY, FND_API.G_MISS_CHAR, NULL, p_TIME_BASED_MANUAL_ENTRY)
435: ,EAM_REQUIRED_FLAG = decode(p_EAM_REQUIRED_FLAG, NULL, EAM_REQUIRED_FLAG, FND_API.G_MISS_CHAR, NULL, p_EAM_REQUIRED_FLAG)
436: WHERE COUNTER_ID = p_COUNTER_ID;
437:
438: UPDATE csi_counter_template_tl
439: SET source_lang = userenv('LANG'),

Line 440: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),

436: WHERE COUNTER_ID = p_COUNTER_ID;
437:
438: UPDATE csi_counter_template_tl
439: SET source_lang = userenv('LANG'),
440: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
441: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),
443: creation_date = decode( p_creation_date, NULL, creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
444: last_updated_by = decode( p_last_updated_by, NULL, last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 441: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),

437:
438: UPDATE csi_counter_template_tl
439: SET source_lang = userenv('LANG'),
440: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
441: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),
443: creation_date = decode( p_creation_date, NULL, creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
444: last_updated_by = decode( p_last_updated_by, NULL, last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
445: last_update_date = decode( p_last_update_date, NULL, last_update_date, fnd_api.g_miss_date, NULL, p_last_update_date),

Line 442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),

438: UPDATE csi_counter_template_tl
439: SET source_lang = userenv('LANG'),
440: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
441: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),
443: creation_date = decode( p_creation_date, NULL, creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
444: last_updated_by = decode( p_last_updated_by, NULL, last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
445: last_update_date = decode( p_last_update_date, NULL, last_update_date, fnd_api.g_miss_date, NULL, p_last_update_date),
446: last_update_login = decode( p_last_update_login, NULL, last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)

Line 443: creation_date = decode( p_creation_date, NULL, creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

439: SET source_lang = userenv('LANG'),
440: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
441: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),
443: creation_date = decode( p_creation_date, NULL, creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
444: last_updated_by = decode( p_last_updated_by, NULL, last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
445: last_update_date = decode( p_last_update_date, NULL, last_update_date, fnd_api.g_miss_date, NULL, p_last_update_date),
446: last_update_login = decode( p_last_update_login, NULL, last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)
447: WHERE counter_id = p_counter_id

Line 444: last_updated_by = decode( p_last_updated_by, NULL, last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),

440: name = decode( p_name, NULL, name, fnd_api.g_miss_char, NULL, p_name),
441: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),
443: creation_date = decode( p_creation_date, NULL, creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
444: last_updated_by = decode( p_last_updated_by, NULL, last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
445: last_update_date = decode( p_last_update_date, NULL, last_update_date, fnd_api.g_miss_date, NULL, p_last_update_date),
446: last_update_login = decode( p_last_update_login, NULL, last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)
447: WHERE counter_id = p_counter_id
448: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);

Line 445: last_update_date = decode( p_last_update_date, NULL, last_update_date, fnd_api.g_miss_date, NULL, p_last_update_date),

441: description = decode( p_description, NULL, description, fnd_api.g_miss_char, NULL, p_description),
442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),
443: creation_date = decode( p_creation_date, NULL, creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
444: last_updated_by = decode( p_last_updated_by, NULL, last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
445: last_update_date = decode( p_last_update_date, NULL, last_update_date, fnd_api.g_miss_date, NULL, p_last_update_date),
446: last_update_login = decode( p_last_update_login, NULL, last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)
447: WHERE counter_id = p_counter_id
448: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);
449:

Line 446: last_update_login = decode( p_last_update_login, NULL, last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)

442: created_by = decode( p_created_by, NULL, created_by, fnd_api.g_miss_num, created_by, p_created_by),
443: creation_date = decode( p_creation_date, NULL, creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
444: last_updated_by = decode( p_last_updated_by, NULL, last_updated_by, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by),
445: last_update_date = decode( p_last_update_date, NULL, last_update_date, fnd_api.g_miss_date, NULL, p_last_update_date),
446: last_update_login = decode( p_last_update_login, NULL, last_update_login, fnd_api.g_miss_num, FND_GLOBAL.USER_ID, p_last_update_login)
447: WHERE counter_id = p_counter_id
448: AND userenv('LANG') IN (LANGUAGE,SOURCE_LANG);
449:
450: If (SQL%NOTFOUND) then