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_ITEM_INSTANCES_PKG dependencies on FND_API

Line 86: p_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,

82: p_LAST_TXN_LINE_DETAIL_ID NUMBER,
83: p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
84: p_INSTALL_LOCATION_ID NUMBER,
85: P_INSTANCE_USAGE_CODE VARCHAR2,
86: p_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
87: p_CONFIG_INST_HDR_ID NUMBER,
88: p_CONFIG_INST_REV_NUM NUMBER,
89: p_CONFIG_INST_ITEM_ID NUMBER,
90: p_CONFIG_VALID_STATUS VARCHAR2,

Line 139: IF (px_INSTANCE_ID IS NULL) OR (px_INSTANCE_ID = FND_API.G_MISS_NUM) THEN

135:
136: IS
137: CURSOR C2 IS SELECT CSI_ITEM_INSTANCES_S.NEXTVAL FROM sys.dual;
138: BEGIN
139: IF (px_INSTANCE_ID IS NULL) OR (px_INSTANCE_ID = FND_API.G_MISS_NUM) THEN
140: OPEN C2;
141: FETCH C2 INTO px_INSTANCE_ID;
142: CLOSE C2;
143: END IF;

Line 267: decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_NUMBER),

263: SOURCE_CODE -- Added Code for Siebel Genesis Project
264: )
265: VALUES (
266: px_INSTANCE_ID,
267: decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_NUMBER),
268: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
269: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),

Line 268: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),

264: )
265: VALUES (
266: px_INSTANCE_ID,
267: decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_NUMBER),
268: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
269: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),

Line 269: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),

265: VALUES (
266: px_INSTANCE_ID,
267: decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_NUMBER),
268: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
269: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),

Line 270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),

266: px_INSTANCE_ID,
267: decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_NUMBER),
268: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
269: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),

Line 271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),

267: decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_NUMBER),
268: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
269: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),

Line 272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),

268: decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_EXTERNAL_REFERENCE),
269: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),

Line 273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),

269: decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),

Line 274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),

270: decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, NULL, p_INVENTORY_REVISION),
271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),

Line 275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),

271: decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_MASTER_ORGANIZATION_ID),
272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),

Line 276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),

272: decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER),
273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),

Line 277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),

273: decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, NULL, p_MFG_SERIAL_NUMBER_FLAG),
274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),

Line 278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),

274: decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LOT_NUMBER),
275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),

Line 279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),

275: decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),

Line 280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),

276: decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, NULL, p_UNIT_OF_MEASURE),
277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),

Line 281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),

277: decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, NULL, p_ACCOUNTING_CLASS_CODE),
278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),

Line 282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),

278: decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_CONDITION_ID),
279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),

Line 283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),

279: decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_STATUS_ID),
280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),

Line 284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),

280: decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_CUSTOMER_VIEW_FLAG),
281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),

Line 285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),

281: decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, NULL, p_MERCHANT_VIEW_FLAG),
282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),

Line 286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),

282: decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SELLABLE_FLAG),
283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),

Line 287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),

283: decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SYSTEM_ID),
284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),

Line 288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),

284: decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_TYPE_CODE),
285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),

Line 289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),

285: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),

Line 290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),

286: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),

Line 291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),

287: decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_LOCATION_TYPE_CODE),
288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),

Line 292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),

288: decode( p_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LOCATION_ID),
289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),

Line 293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),

289: decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_INV_ORGANIZATION_ID),
290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),

Line 294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),

290: decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, NULL, p_INV_SUBINVENTORY_NAME),
291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),

Line 295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),

291: decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, p_INV_LOCATOR_ID),
292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),

Line 296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),

292: decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_ID),
293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),

Line 297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),

293: decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, NULL, p_PA_PROJECT_TASK_ID),
294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),

Line 298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),

294: decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_IN_TRANSIT_ORDER_LINE_ID),
295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),

Line 299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),

295: decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_WIP_JOB_ID),
296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),

Line 300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),

296: decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PO_ORDER_LINE_ID),
297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),

Line 301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),

297: decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_ORDER_LINE_ID),
298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),

Line 302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),

298: decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_RMA_LINE_ID),
299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),

Line 303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),

299: decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PO_PO_LINE_ID),
300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),

Line 304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),

300: decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, NULL, p_LAST_OE_PO_NUMBER),
301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),

Line 305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),

301: decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, NULL, p_LAST_WIP_JOB_ID),
302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),

Line 306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),

302: decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_PROJECT_ID),
303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),

Line 307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),

303: decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, NULL, p_LAST_PA_TASK_ID),
304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),

Line 308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),

304: decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_LAST_OE_AGREEMENT_ID),
305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

Line 309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),

305: decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_INSTALL_DATE),
306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

Line 310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),

306: decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANUALLY_CREATED_FLAG),
307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),

307: decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_RETURN_BY_DATE),
308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

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

308: decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTUAL_RETURN_DATE),
309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

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

309: decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATION_COMPLETE_FLAG),
310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

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

310: decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETENESS_FLAG),
311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

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

311: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

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

312: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

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

313: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

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

314: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

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

315: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

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

316: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

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

317: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

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

318: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),

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

319: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

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

320: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),

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

321: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

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

322: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),

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

323: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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

324: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),

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

325: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),

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

326: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),

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

327: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),

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

328: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),

Line 333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),

329: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),

Line 334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),

330: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),

Line 335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),

331: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),

Line 336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),

332: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),

Line 337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),

333: decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, NULL, p_LAST_TXN_LINE_DETAIL_ID),
334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),

Line 338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),

334: decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTALL_LOCATION_TYPE_CODE),
335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),

Line 339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),

335: decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_INSTALL_LOCATION_ID),
336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),

Line 340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),

336: decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, NULL, p_INSTANCE_USAGE_CODE),
337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),

Line 341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),

337: decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, NULL, p_last_vld_organization_id),
338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),

Line 342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),

338: decode( p_CONFIG_INST_HDR_ID , FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_HDR_ID),
339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),

Line 343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),

339: decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_REV_NUM),
340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
347: --start of eam integration changes--

Line 344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),

340: decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL,p_CONFIG_INST_ITEM_ID),
341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
347: --start of eam integration changes--
348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),

Line 345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),

341: decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, NULL,p_CONFIG_VALID_STATUS),
342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
347: --start of eam integration changes--
348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),

Line 346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),

342: decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,p_INSTANCE_DESCRIPTION),
343: decode( p_request_id, fnd_api.g_miss_num, NULL, p_request_id),
344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
347: --start of eam integration changes--
348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),

Line 348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),

344: decode( p_program_application_id, fnd_api.g_miss_num, NULL, p_program_application_id),
345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
347: --start of eam integration changes--
348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),

Line 349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),

345: decode( p_program_id, fnd_api.g_miss_num, NULL, p_program_id),
346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
347: --start of eam integration changes--
348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),

Line 350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),

346: decode( p_program_update_date, fnd_api.g_miss_date, to_date(NULL), p_program_update_date),
347: --start of eam integration changes--
348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),

Line 351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),

347: --start of eam integration changes--
348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),

Line 352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),

348: decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NULL, p_NETWORK_ASSET_FLAG),
349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),

Line 353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),

349: decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_MAINTAINABLE_FLAG),
350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),

Line 354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),

350: decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_PN_LOCATION_ID),
351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),

Line 355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),

351: decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSET_CRITICALITY_CODE),
352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),

Line 356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),

352: decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID),
353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),

Line 357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),

353: decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_EQUIPMENT_GEN_OBJECT_ID),
354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),

Line 358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),

354: decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_INSTANTIATION_FLAG),
355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),

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

355: decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, NULL, p_LINEAR_LOCATION_ID),
356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),

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

356: decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_LOG_FLAG),
357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),

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

357: decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, NULL, p_CHECKIN_STATUS),
358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),

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

358: decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_SUPPLIER_WARRANTY_EXP_DATE),
359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),

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

359: decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),

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

360: decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),

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

361: decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),

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

362: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370: decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),

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

363: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370: decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
371: decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),

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

364: decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21),
365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370: decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
371: decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),
372: decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),

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

365: decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22),
366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370: decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
371: decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),
372: decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),
373: decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),

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

366: decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23),
367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370: decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
371: decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),
372: decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),
373: decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),
374: --end of eam integration changes--

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

367: decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24),
368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370: decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
371: decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),
372: decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),
373: decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),
374: --end of eam integration changes--
375: -- Addition of columns for FA Integration

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

368: decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25),
369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370: decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
371: decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),
372: decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),
373: decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),
374: --end of eam integration changes--
375: -- Addition of columns for FA Integration
376: decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),

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

369: decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26),
370: decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27),
371: decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28),
372: decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),
373: decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),
374: --end of eam integration changes--
375: -- Addition of columns for FA Integration
376: decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),
377: decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),

Line 376: decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),

372: decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29),
373: decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),
374: --end of eam integration changes--
375: -- Addition of columns for FA Integration
376: decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),
377: decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),
378: decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
379: decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),

Line 377: decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),

373: decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30),
374: --end of eam integration changes--
375: -- Addition of columns for FA Integration
376: decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),
377: decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),
378: decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
379: decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
381: decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),

Line 378: decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),

374: --end of eam integration changes--
375: -- Addition of columns for FA Integration
376: decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),
377: decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),
378: decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
379: decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
381: decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),
382: decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),

Line 379: decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),

375: -- Addition of columns for FA Integration
376: decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),
377: decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),
378: decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
379: decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
381: decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),
382: decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),
383: -- End addition of columns for FA Integration

Line 380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),

376: decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PURCHASE_UNIT_PRICE),
377: decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),
378: decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
379: decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
381: decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),
382: decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),
383: -- End addition of columns for FA Integration
384: decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE) -- Added Code for Siebel Genesis Project

Line 381: decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),

377: decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PURCHASE_CURRENCY_CODE),
378: decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
379: decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
381: decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),
382: decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),
383: -- End addition of columns for FA Integration
384: decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
385: );

Line 382: decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),

378: decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_PAYABLES_UNIT_PRICE),
379: decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_PAYABLES_CURRENCY_CODE),
380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
381: decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),
382: decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),
383: -- End addition of columns for FA Integration
384: decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
385: );
386: END Insert_Row;

Line 384: decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE) -- Added Code for Siebel Genesis Project

380: decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, NULL, p_SALES_UNIT_PRICE),
381: decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CURRENCY_CODE),
382: decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_OPERATIONAL_STATUS_CODE),
383: -- End addition of columns for FA Integration
384: decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
385: );
386: END Insert_Row;
387:
388: PROCEDURE Update_Row(

Line 460: P_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,

456: p_LAST_TXN_LINE_DETAIL_ID NUMBER,
457: p_INSTALL_LOCATION_TYPE_CODE VARCHAR2,
458: p_INSTALL_LOCATION_ID NUMBER,
459: P_INSTANCE_USAGE_CODE VARCHAR2,
460: P_last_vld_organization_id NUMBER :=fnd_api.g_miss_num,
461: p_CONFIG_INST_HDR_ID NUMBER ,
462: p_CONFIG_INST_REV_NUM NUMBER ,
463: p_CONFIG_INST_ITEM_ID NUMBER ,
464: p_CONFIG_VALID_STATUS VARCHAR2 ,

Line 514: INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),

510: BEGIN
511:
512: UPDATE CSI_ITEM_INSTANCES
513: SET
514: INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),
515: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),

Line 515: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),

511:
512: UPDATE CSI_ITEM_INSTANCES
513: SET
514: INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),
515: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),

Line 516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),

512: UPDATE CSI_ITEM_INSTANCES
513: SET
514: INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),
515: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),

Line 517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),

513: SET
514: INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),
515: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),

Line 518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),

514: INSTANCE_NUMBER = decode( p_INSTANCE_NUMBER, FND_API.G_MISS_CHAR, INSTANCE_NUMBER, p_INSTANCE_NUMBER),
515: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),

Line 519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),

515: EXTERNAL_REFERENCE = decode( p_EXTERNAL_REFERENCE, FND_API.G_MISS_CHAR, EXTERNAL_REFERENCE, p_EXTERNAL_REFERENCE),
516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),

Line 520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),

516: INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),

Line 521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),

517: INVENTORY_REVISION = decode( p_INVENTORY_REVISION, FND_API.G_MISS_CHAR, INVENTORY_REVISION, p_INVENTORY_REVISION),
518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),

Line 522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),

518: INV_MASTER_ORGANIZATION_ID = decode( p_INV_MASTER_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_MASTER_ORGANIZATION_ID, p_INV_MASTER_ORGANIZATION_ID),
519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),

Line 523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),

519: SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),

Line 524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),

520: MFG_SERIAL_NUMBER_FLAG = decode( p_MFG_SERIAL_NUMBER_FLAG, FND_API.G_MISS_CHAR, MFG_SERIAL_NUMBER_FLAG, p_MFG_SERIAL_NUMBER_FLAG),
521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),

Line 525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),

521: LOT_NUMBER = decode( p_LOT_NUMBER, FND_API.G_MISS_CHAR, LOT_NUMBER, p_LOT_NUMBER),
522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),

Line 526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),

522: QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),

Line 527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),

523: UNIT_OF_MEASURE = decode( p_UNIT_OF_MEASURE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE, p_UNIT_OF_MEASURE),
524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),

Line 528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),

524: ACCOUNTING_CLASS_CODE = decode( p_ACCOUNTING_CLASS_CODE, FND_API.G_MISS_CHAR, ACCOUNTING_CLASS_CODE, p_ACCOUNTING_CLASS_CODE),
525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),

Line 529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),

525: INSTANCE_CONDITION_ID = decode( p_INSTANCE_CONDITION_ID, FND_API.G_MISS_NUM, INSTANCE_CONDITION_ID, p_INSTANCE_CONDITION_ID),
526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),

Line 530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),

526: INSTANCE_STATUS_ID = decode( p_INSTANCE_STATUS_ID, FND_API.G_MISS_NUM, INSTANCE_STATUS_ID, p_INSTANCE_STATUS_ID),
527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),

Line 531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),

527: CUSTOMER_VIEW_FLAG = decode( p_CUSTOMER_VIEW_FLAG, FND_API.G_MISS_CHAR, CUSTOMER_VIEW_FLAG, p_CUSTOMER_VIEW_FLAG),
528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),

Line 532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),

528: MERCHANT_VIEW_FLAG = decode( p_MERCHANT_VIEW_FLAG, FND_API.G_MISS_CHAR, MERCHANT_VIEW_FLAG, p_MERCHANT_VIEW_FLAG),
529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),

Line 533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),

529: SELLABLE_FLAG = decode( p_SELLABLE_FLAG, FND_API.G_MISS_CHAR, SELLABLE_FLAG, p_SELLABLE_FLAG),
530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),

Line 534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),

530: SYSTEM_ID = decode( p_SYSTEM_ID, FND_API.G_MISS_NUM, SYSTEM_ID, p_SYSTEM_ID),
531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),

Line 535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),

531: INSTANCE_TYPE_CODE = decode( p_INSTANCE_TYPE_CODE, FND_API.G_MISS_CHAR, INSTANCE_TYPE_CODE, p_INSTANCE_TYPE_CODE),
532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),

Line 536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),

532: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),

Line 537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),

533: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),

Line 538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),

534: LOCATION_TYPE_CODE = decode( p_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, LOCATION_TYPE_CODE, p_LOCATION_TYPE_CODE),
535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),

Line 539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),

535: LOCATION_ID = decode( p_LOCATION_ID, FND_API.G_MISS_NUM, LOCATION_ID, p_LOCATION_ID),
536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),

Line 540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),

536: INV_ORGANIZATION_ID = decode( p_INV_ORGANIZATION_ID, FND_API.G_MISS_NUM, INV_ORGANIZATION_ID, p_INV_ORGANIZATION_ID),
537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),

Line 541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),

537: INV_SUBINVENTORY_NAME = decode( p_INV_SUBINVENTORY_NAME, FND_API.G_MISS_CHAR, INV_SUBINVENTORY_NAME, p_INV_SUBINVENTORY_NAME),
538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),

Line 542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),

538: INV_LOCATOR_ID = decode( p_INV_LOCATOR_ID, FND_API.G_MISS_NUM, INV_LOCATOR_ID, p_INV_LOCATOR_ID),
539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),

Line 543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),

539: PA_PROJECT_ID = decode( p_PA_PROJECT_ID, FND_API.G_MISS_NUM, PA_PROJECT_ID, p_PA_PROJECT_ID),
540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),

Line 544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),

540: PA_PROJECT_TASK_ID = decode( p_PA_PROJECT_TASK_ID, FND_API.G_MISS_NUM, PA_PROJECT_TASK_ID, p_PA_PROJECT_TASK_ID),
541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),

Line 545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),

541: IN_TRANSIT_ORDER_LINE_ID = decode( p_IN_TRANSIT_ORDER_LINE_ID, FND_API.G_MISS_NUM, IN_TRANSIT_ORDER_LINE_ID, p_IN_TRANSIT_ORDER_LINE_ID),
542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),

Line 546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),

542: WIP_JOB_ID = decode( p_WIP_JOB_ID, FND_API.G_MISS_NUM, WIP_JOB_ID, p_WIP_JOB_ID),
543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),

Line 547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),

543: PO_ORDER_LINE_ID = decode( p_PO_ORDER_LINE_ID, FND_API.G_MISS_NUM, PO_ORDER_LINE_ID, p_PO_ORDER_LINE_ID),
544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),

Line 548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),

544: LAST_OE_ORDER_LINE_ID = decode( p_LAST_OE_ORDER_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_ORDER_LINE_ID, p_LAST_OE_ORDER_LINE_ID),
545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),

Line 549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),

545: LAST_OE_RMA_LINE_ID = decode( p_LAST_OE_RMA_LINE_ID, FND_API.G_MISS_NUM, LAST_OE_RMA_LINE_ID, p_LAST_OE_RMA_LINE_ID),
546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),

Line 550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),

546: LAST_PO_PO_LINE_ID = decode( p_LAST_PO_PO_LINE_ID, FND_API.G_MISS_NUM, LAST_PO_PO_LINE_ID, p_LAST_PO_PO_LINE_ID),
547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),

Line 551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),

547: LAST_OE_PO_NUMBER = decode( p_LAST_OE_PO_NUMBER, FND_API.G_MISS_CHAR, LAST_OE_PO_NUMBER, p_LAST_OE_PO_NUMBER),
548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),

Line 552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),

548: LAST_WIP_JOB_ID = decode( p_LAST_WIP_JOB_ID, FND_API.G_MISS_NUM, LAST_WIP_JOB_ID, p_LAST_WIP_JOB_ID),
549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),

Line 553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),

549: LAST_PA_PROJECT_ID = decode( p_LAST_PA_PROJECT_ID, FND_API.G_MISS_NUM, LAST_PA_PROJECT_ID, p_LAST_PA_PROJECT_ID),
550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),

Line 554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),

550: LAST_PA_TASK_ID = decode( p_LAST_PA_TASK_ID, FND_API.G_MISS_NUM, LAST_PA_TASK_ID, p_LAST_PA_TASK_ID),
551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),

Line 555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),

551: LAST_OE_AGREEMENT_ID = decode( p_LAST_OE_AGREEMENT_ID, FND_API.G_MISS_NUM, LAST_OE_AGREEMENT_ID, p_LAST_OE_AGREEMENT_ID),
552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),

552: INSTALL_DATE = decode( p_INSTALL_DATE, FND_API.G_MISS_DATE, INSTALL_DATE, p_INSTALL_DATE),
553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

Line 557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),

553: MANUALLY_CREATED_FLAG = decode( p_MANUALLY_CREATED_FLAG, FND_API.G_MISS_CHAR, MANUALLY_CREATED_FLAG, p_MANUALLY_CREATED_FLAG),
554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

Line 558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),

554: RETURN_BY_DATE = decode( p_RETURN_BY_DATE, FND_API.G_MISS_DATE, RETURN_BY_DATE, p_RETURN_BY_DATE),
555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

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

555: ACTUAL_RETURN_DATE = decode( p_ACTUAL_RETURN_DATE, FND_API.G_MISS_DATE, ACTUAL_RETURN_DATE, p_ACTUAL_RETURN_DATE),
556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

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

556: CREATION_COMPLETE_FLAG = decode( p_CREATION_COMPLETE_FLAG, FND_API.G_MISS_CHAR, CREATION_COMPLETE_FLAG, p_CREATION_COMPLETE_FLAG),
557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

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

557: COMPLETENESS_FLAG = decode( p_COMPLETENESS_FLAG, FND_API.G_MISS_CHAR, COMPLETENESS_FLAG, p_COMPLETENESS_FLAG),
558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

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

558: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

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

559: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

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

560: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

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

561: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

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

562: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

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

563: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

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

564: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

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

565: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),

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

566: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

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

567: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

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

568: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

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

569: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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

570: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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

571: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),

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

572: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),

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

573: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),

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

574: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),

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

575: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),

Line 580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),

576: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),

Line 581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),

577: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),

Line 582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),

578: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),

Line 583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),

579: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),

Line 584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),

580: LAST_TXN_LINE_DETAIL_ID = decode( p_LAST_TXN_LINE_DETAIL_ID, FND_API.G_MISS_NUM, LAST_TXN_LINE_DETAIL_ID, p_LAST_TXN_LINE_DETAIL_ID),
581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),

Line 585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),

581: INSTALL_LOCATION_TYPE_CODE = decode( p_INSTALL_LOCATION_TYPE_CODE, FND_API.G_MISS_CHAR, INSTALL_LOCATION_TYPE_CODE, p_INSTALL_LOCATION_TYPE_CODE),
582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),

Line 586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),

582: INSTALL_LOCATION_ID = decode( p_INSTALL_LOCATION_ID, FND_API.G_MISS_NUM, INSTALL_LOCATION_ID, p_INSTALL_LOCATION_ID),
583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),

Line 587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),

583: INSTANCE_USAGE_CODE = decode( p_INSTANCE_USAGE_CODE, FND_API.G_MISS_CHAR, INSTANCE_USAGE_CODE, p_INSTANCE_USAGE_CODE),
584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),

Line 588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),

584: last_vld_organization_id = decode( p_last_vld_organization_id, FND_API.G_MISS_NUM, last_vld_organization_id, p_last_vld_organization_id),
585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),

Line 589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),

585: CONFIG_INST_HDR_ID= decode( p_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, CONFIG_INST_HDR_ID, p_CONFIG_INST_HDR_ID),
586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),

Line 590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),

586: CONFIG_INST_REV_NUM=decode( p_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, CONFIG_INST_REV_NUM, p_CONFIG_INST_REV_NUM),
587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
594: --start of eam integration changes--

Line 591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),

587: CONFIG_INST_ITEM_ID=decode( p_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_INST_ITEM_ID, p_CONFIG_INST_ITEM_ID),
588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
594: --start of eam integration changes--
595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),

Line 592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),

588: CONFIG_VALID_STATUS= decode( p_CONFIG_VALID_STATUS, FND_API.G_MISS_CHAR, CONFIG_VALID_STATUS, p_CONFIG_VALID_STATUS),
589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
594: --start of eam integration changes--
595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),

Line 593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),

589: INSTANCE_DESCRIPTION= decode( p_INSTANCE_DESCRIPTION, FND_API.G_MISS_CHAR, INSTANCE_DESCRIPTION, p_INSTANCE_DESCRIPTION),
590: request_id = decode(p_request_id,fnd_api.g_miss_num,request_id,p_request_id),
591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
594: --start of eam integration changes--
595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),

Line 595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),

591: program_application_id = decode(p_program_application_id,fnd_api.g_miss_num,program_application_id,p_program_application_id),
592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
594: --start of eam integration changes--
595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),

Line 596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),

592: program_id = decode(p_program_id,fnd_api.g_miss_num,program_id,p_program_id),
593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
594: --start of eam integration changes--
595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),

Line 597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),

593: program_update_date = decode( p_program_update_date, fnd_api.g_miss_date, program_update_date, p_program_update_date),
594: --start of eam integration changes--
595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),

Line 598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),

594: --start of eam integration changes--
595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),

Line 599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),

595: NETWORK_ASSET_FLAG = decode( p_NETWORK_ASSET_FLAG, FND_API.G_MISS_CHAR, NETWORK_ASSET_FLAG, p_NETWORK_ASSET_FLAG),
596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),

Line 600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),

596: MAINTAINABLE_FLAG = decode( p_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, MAINTAINABLE_FLAG, p_MAINTAINABLE_FLAG),
597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),

Line 601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),

597: PN_LOCATION_ID = decode( p_PN_LOCATION_ID, FND_API.G_MISS_NUM, PN_LOCATION_ID, p_PN_LOCATION_ID),
598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),

Line 602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),

598: ASSET_CRITICALITY_CODE = decode( p_ASSET_CRITICALITY_CODE, FND_API.G_MISS_CHAR, ASSET_CRITICALITY_CODE, p_ASSET_CRITICALITY_CODE),
599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),

Line 603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),

599: CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID),
600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),

Line 604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),

600: EQUIPMENT_GEN_OBJECT_ID = decode( p_EQUIPMENT_GEN_OBJECT_ID, FND_API.G_MISS_NUM, EQUIPMENT_GEN_OBJECT_ID, p_EQUIPMENT_GEN_OBJECT_ID),
601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),

Line 605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),

601: INSTANTIATION_FLAG = decode( p_INSTANTIATION_FLAG, FND_API.G_MISS_CHAR, INSTANTIATION_FLAG, p_INSTANTIATION_FLAG),
602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),

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

602: LINEAR_LOCATION_ID = decode( p_LINEAR_LOCATION_ID, FND_API.G_MISS_NUM, LINEAR_LOCATION_ID, p_LINEAR_LOCATION_ID),
603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),

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

603: OPERATIONAL_LOG_FLAG = decode( p_OPERATIONAL_LOG_FLAG, FND_API.G_MISS_CHAR, OPERATIONAL_LOG_FLAG, p_OPERATIONAL_LOG_FLAG),
604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),

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

604: CHECKIN_STATUS = decode( p_CHECKIN_STATUS, FND_API.G_MISS_NUM, CHECKIN_STATUS, p_CHECKIN_STATUS),
605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),

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

605: SUPPLIER_WARRANTY_EXP_DATE = decode( p_SUPPLIER_WARRANTY_EXP_DATE, FND_API.G_MISS_DATE, SUPPLIER_WARRANTY_EXP_DATE, p_SUPPLIER_WARRANTY_EXP_DATE),
606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),

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

606: ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),

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

607: ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),

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

608: ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),

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

609: ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617: ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),

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

610: ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617: ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
618: ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),

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

611: ATTRIBUTE21 = decode( p_ATTRIBUTE21, FND_API.G_MISS_CHAR, ATTRIBUTE21, p_ATTRIBUTE21),
612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617: ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
618: ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),
619: ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),

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

612: ATTRIBUTE22 = decode( p_ATTRIBUTE22, FND_API.G_MISS_CHAR, ATTRIBUTE22, p_ATTRIBUTE22),
613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617: ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
618: ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),
619: ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),
620: ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),

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

613: ATTRIBUTE23 = decode( p_ATTRIBUTE23, FND_API.G_MISS_CHAR, ATTRIBUTE23, p_ATTRIBUTE23),
614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617: ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
618: ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),
619: ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),
620: ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),
621: --end of eam integration changes--

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

614: ATTRIBUTE24 = decode( p_ATTRIBUTE24, FND_API.G_MISS_CHAR, ATTRIBUTE24, p_ATTRIBUTE24),
615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617: ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
618: ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),
619: ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),
620: ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),
621: --end of eam integration changes--
622: -- Addition of columns for FA Integration

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

615: ATTRIBUTE25 = decode( p_ATTRIBUTE25, FND_API.G_MISS_CHAR, ATTRIBUTE25, p_ATTRIBUTE25),
616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617: ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
618: ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),
619: ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),
620: ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),
621: --end of eam integration changes--
622: -- Addition of columns for FA Integration
623: PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),

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

616: ATTRIBUTE26 = decode( p_ATTRIBUTE26, FND_API.G_MISS_CHAR, ATTRIBUTE26, p_ATTRIBUTE26),
617: ATTRIBUTE27 = decode( p_ATTRIBUTE27, FND_API.G_MISS_CHAR, ATTRIBUTE27, p_ATTRIBUTE27),
618: ATTRIBUTE28 = decode( p_ATTRIBUTE28, FND_API.G_MISS_CHAR, ATTRIBUTE28, p_ATTRIBUTE28),
619: ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),
620: ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),
621: --end of eam integration changes--
622: -- Addition of columns for FA Integration
623: PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),
624: PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),

Line 623: PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),

619: ATTRIBUTE29 = decode( p_ATTRIBUTE29, FND_API.G_MISS_CHAR, ATTRIBUTE29, p_ATTRIBUTE29),
620: ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),
621: --end of eam integration changes--
622: -- Addition of columns for FA Integration
623: PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),
624: PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),
625: PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
626: PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),

Line 624: PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),

620: ATTRIBUTE30 = decode( p_ATTRIBUTE30, FND_API.G_MISS_CHAR, ATTRIBUTE30, p_ATTRIBUTE30),
621: --end of eam integration changes--
622: -- Addition of columns for FA Integration
623: PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),
624: PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),
625: PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
626: PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
628: SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),

Line 625: PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),

621: --end of eam integration changes--
622: -- Addition of columns for FA Integration
623: PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),
624: PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),
625: PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
626: PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
628: SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),
629: OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),

Line 626: PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),

622: -- Addition of columns for FA Integration
623: PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),
624: PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),
625: PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
626: PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
628: SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),
629: OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),
630: -- End addition of columns for FA Integration

Line 627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),

623: PURCHASE_UNIT_PRICE = decode( p_PURCHASE_UNIT_PRICE, FND_API.G_MISS_NUM, PURCHASE_UNIT_PRICE, p_PURCHASE_UNIT_PRICE),
624: PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),
625: PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
626: PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
628: SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),
629: OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),
630: -- End addition of columns for FA Integration
631: SOURCE_CODE = decode(p_SOURCE_CODE,fnd_api.g_miss_char,SOURCE_CODE,p_SOURCE_CODE) -- Added Code for Siebel Genesis Project

Line 628: SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),

624: PURCHASE_CURRENCY_CODE = decode( p_PURCHASE_CURRENCY_CODE, FND_API.G_MISS_CHAR, PURCHASE_CURRENCY_CODE, p_PURCHASE_CURRENCY_CODE),
625: PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
626: PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
628: SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),
629: OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),
630: -- End addition of columns for FA Integration
631: SOURCE_CODE = decode(p_SOURCE_CODE,fnd_api.g_miss_char,SOURCE_CODE,p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
632: where INSTANCE_ID = p_INSTANCE_ID;

Line 629: OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),

625: PAYABLES_UNIT_PRICE = decode( p_PAYABLES_UNIT_PRICE, FND_API.G_MISS_NUM, PAYABLES_UNIT_PRICE, p_PAYABLES_UNIT_PRICE),
626: PAYABLES_CURRENCY_CODE = decode( p_PAYABLES_CURRENCY_CODE, FND_API.G_MISS_CHAR, PAYABLES_CURRENCY_CODE, p_PAYABLES_CURRENCY_CODE),
627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
628: SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),
629: OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),
630: -- End addition of columns for FA Integration
631: SOURCE_CODE = decode(p_SOURCE_CODE,fnd_api.g_miss_char,SOURCE_CODE,p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
632: where INSTANCE_ID = p_INSTANCE_ID;
633:

Line 631: SOURCE_CODE = decode(p_SOURCE_CODE,fnd_api.g_miss_char,SOURCE_CODE,p_SOURCE_CODE) -- Added Code for Siebel Genesis Project

627: SALES_UNIT_PRICE = decode( p_SALES_UNIT_PRICE, FND_API.G_MISS_NUM, SALES_UNIT_PRICE, p_SALES_UNIT_PRICE),
628: SALES_CURRENCY_CODE = decode( p_SALES_CURRENCY_CODE, FND_API.G_MISS_CHAR, SALES_CURRENCY_CODE, p_SALES_CURRENCY_CODE),
629: OPERATIONAL_STATUS_CODE = decode( p_OPERATIONAL_STATUS_CODE, FND_API.G_MISS_CHAR, OPERATIONAL_STATUS_CODE, p_OPERATIONAL_STATUS_CODE),
630: -- End addition of columns for FA Integration
631: SOURCE_CODE = decode(p_SOURCE_CODE,fnd_api.g_miss_char,SOURCE_CODE,p_SOURCE_CODE) -- Added Code for Siebel Genesis Project
632: where INSTANCE_ID = p_INSTANCE_ID;
633:
634: IF (SQL%NOTFOUND) THEN
635: RAISE NO_DATA_FOUND;