99: ) VALUES (
100: x_WRITEOFF_OBJECT_ID
101: ,x_WRITEOFF_ID
102: ,x_OBJECT_VERSION_NUMBER
103: ,decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, x_CONTRACT_ID)
104: ,decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_ID)
105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)
106: ,x_TRANSACTION_ID
107: ,x_ADJUSTMENT_AMOUNT
100: x_WRITEOFF_OBJECT_ID
101: ,x_WRITEOFF_ID
102: ,x_OBJECT_VERSION_NUMBER
103: ,decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, x_CONTRACT_ID)
104: ,decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_ID)
105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)
106: ,x_TRANSACTION_ID
107: ,x_ADJUSTMENT_AMOUNT
108: ,x_ADJUSTMENT_REASON_CODE
101: ,x_WRITEOFF_ID
102: ,x_OBJECT_VERSION_NUMBER
103: ,decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, x_CONTRACT_ID)
104: ,decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_ID)
105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)
106: ,x_TRANSACTION_ID
107: ,x_ADJUSTMENT_AMOUNT
108: ,x_ADJUSTMENT_REASON_CODE
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
105: ,decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM, NULL, x_CONS_INVOICE_LINE_ID)
106: ,x_TRANSACTION_ID
107: ,x_ADJUSTMENT_AMOUNT
108: ,x_ADJUSTMENT_REASON_CODE
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
107: ,x_ADJUSTMENT_AMOUNT
108: ,x_ADJUSTMENT_REASON_CODE
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
108: ,x_ADJUSTMENT_REASON_CODE
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
109: ,decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
110: x_RECEVIABLES_ADJUSTMENT_ID),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
111: decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
112: decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
113: decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
114: decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_PROGRAM_UPDATE_DATE),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
115: decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE_CATEGORY),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
116: decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE1),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
117: decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE2),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
118: decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE3),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
119: decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE4),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
120: decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE5),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
121: decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE6),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
122: decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE7),
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
123: decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE8),
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
124: decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE9),
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
125: decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE10),
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
126: decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE11),
127: decode( x_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE12),
128: decode( x_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE13),
129: decode( x_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE14),
130: decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, x_ATTRIBUTE15)
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
131: ,x_CREATED_BY
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
132: ,x_CREATION_DATE
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
133: ,x_LAST_UPDATED_BY
134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
141: );
134: ,x_LAST_UPDATE_DATE
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
141: );
142:
135: ,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
141: );
142:
143: OPEN C;
136: ,decode( x_writeoff_status, FND_API.G_MISS_CHAR, NULL, x_writeoff_status)
137: ,decode( x_writeoff_type_id, FND_API.G_MISS_NUM, NULL, x_writeoff_type_id)
138: ,decode( x_writeoff_type, FND_API.G_MISS_CHAR, NULL, x_writeoff_type)
139: ,decode( x_customer_trx_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_id)
140: ,decode( x_customer_trx_line_id, FND_API.G_MISS_NUM, NULL, x_customer_trx_line_id)
141: );
142:
143: OPEN C;
144: FETCH C INTO x_rowid;
194: x_customer_trx_line_id in number)
195: IS
196: BEGIN
197: UPDATE IEX_WRITEOFF_OBJECTS SET
198: WRITEOFF_ID = decode( x_WRITEOFF_ID, FND_API.G_MISS_NUM, NULL,
199: NULL, WRITEOFF_ID, x_WRITEOFF_ID)
200: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,
201: NULL,OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
202:
196: BEGIN
197: UPDATE IEX_WRITEOFF_OBJECTS SET
198: WRITEOFF_ID = decode( x_WRITEOFF_ID, FND_API.G_MISS_NUM, NULL,
199: NULL, WRITEOFF_ID, x_WRITEOFF_ID)
200: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,
201: NULL,OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
202:
203: ,CONTRACT_ID = decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL,
204: NULL, CONTRACT_ID, x_CONTRACT_ID)
199: NULL, WRITEOFF_ID, x_WRITEOFF_ID)
200: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,
201: NULL,OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
202:
203: ,CONTRACT_ID = decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL,
204: NULL, CONTRACT_ID, x_CONTRACT_ID)
205:
206: ,CONS_INVOICE_ID = decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM,NULL,
207: NULL,CONS_INVOICE_ID, x_CONS_INVOICE_ID)
202:
203: ,CONTRACT_ID = decode( x_CONTRACT_ID, FND_API.G_MISS_NUM, NULL,
204: NULL, CONTRACT_ID, x_CONTRACT_ID)
205:
206: ,CONS_INVOICE_ID = decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM,NULL,
207: NULL,CONS_INVOICE_ID, x_CONS_INVOICE_ID)
208:
209: ,CONS_INVOICE_LINE_ID = decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM,NULL,
210: NULL,CONS_INVOICE_LINE_ID,x_CONS_INVOICE_LINE_ID)
205:
206: ,CONS_INVOICE_ID = decode( x_CONS_INVOICE_ID, FND_API.G_MISS_NUM,NULL,
207: NULL,CONS_INVOICE_ID, x_CONS_INVOICE_ID)
208:
209: ,CONS_INVOICE_LINE_ID = decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM,NULL,
210: NULL,CONS_INVOICE_LINE_ID,x_CONS_INVOICE_LINE_ID)
211:
212: ,TRANSACTION_ID = decode( x_TRANSACTION_ID, FND_API.G_MISS_NUM,NULL,
213: NULL,TRANSACTION_ID, x_TRANSACTION_ID)
208:
209: ,CONS_INVOICE_LINE_ID = decode( x_CONS_INVOICE_LINE_ID, FND_API.G_MISS_NUM,NULL,
210: NULL,CONS_INVOICE_LINE_ID,x_CONS_INVOICE_LINE_ID)
211:
212: ,TRANSACTION_ID = decode( x_TRANSACTION_ID, FND_API.G_MISS_NUM,NULL,
213: NULL,TRANSACTION_ID, x_TRANSACTION_ID)
214:
215: ,ADJUSTMENT_AMOUNT = decode( x_ADJUSTMENT_AMOUNT, FND_API.G_MISS_NUM,NULL,
216: NULL,ADJUSTMENT_AMOUNT, x_ADJUSTMENT_AMOUNT)
211:
212: ,TRANSACTION_ID = decode( x_TRANSACTION_ID, FND_API.G_MISS_NUM,NULL,
213: NULL,TRANSACTION_ID, x_TRANSACTION_ID)
214:
215: ,ADJUSTMENT_AMOUNT = decode( x_ADJUSTMENT_AMOUNT, FND_API.G_MISS_NUM,NULL,
216: NULL,ADJUSTMENT_AMOUNT, x_ADJUSTMENT_AMOUNT)
217:
218: ,ADJUSTMENT_REASON_CODE = decode( x_ADJUSTMENT_REASON_CODE, FND_API.G_MISS_CHAR,NULL,
219: NULL,ADJUSTMENT_REASON_CODE, x_ADJUSTMENT_REASON_CODE)
214:
215: ,ADJUSTMENT_AMOUNT = decode( x_ADJUSTMENT_AMOUNT, FND_API.G_MISS_NUM,NULL,
216: NULL,ADJUSTMENT_AMOUNT, x_ADJUSTMENT_AMOUNT)
217:
218: ,ADJUSTMENT_REASON_CODE = decode( x_ADJUSTMENT_REASON_CODE, FND_API.G_MISS_CHAR,NULL,
219: NULL,ADJUSTMENT_REASON_CODE, x_ADJUSTMENT_REASON_CODE)
220:
221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,
222: NULL,RECEVIABLES_ADJUSTMENT_ID, x_RECEVIABLES_ADJUSTMENT_ID)
217:
218: ,ADJUSTMENT_REASON_CODE = decode( x_ADJUSTMENT_REASON_CODE, FND_API.G_MISS_CHAR,NULL,
219: NULL,ADJUSTMENT_REASON_CODE, x_ADJUSTMENT_REASON_CODE)
220:
221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,
222: NULL,RECEVIABLES_ADJUSTMENT_ID, x_RECEVIABLES_ADJUSTMENT_ID)
223:
224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
220:
221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,
222: NULL,RECEVIABLES_ADJUSTMENT_ID, x_RECEVIABLES_ADJUSTMENT_ID)
223:
224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
226: NULL,PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID),
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
221: ,RECEVIABLES_ADJUSTMENT_ID = decode( x_RECEVIABLES_ADJUSTMENT_ID, FND_API.G_MISS_NUM,NULL,
222: NULL,RECEVIABLES_ADJUSTMENT_ID, x_RECEVIABLES_ADJUSTMENT_ID)
223:
224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
226: NULL,PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID),
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
223:
224: ,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM,NULL, NULL,REQUEST_ID, x_REQUEST_ID)
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
226: NULL,PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID),
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
230: NULL,PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE),
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
225: ,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,
226: NULL,PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID),
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
230: NULL,PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE),
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
232: NULL,ATTRIBUTE_CATEGORY, x_ATTRIBUTE_CATEGORY),
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
227: PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM,NULL,
228: NULL,PROGRAM_ID, x_PROGRAM_ID),
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
230: NULL,PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE),
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
232: NULL,ATTRIBUTE_CATEGORY, x_ATTRIBUTE_CATEGORY),
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
234: NULL,ATTRIBUTE1, x_ATTRIBUTE1),
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
229: PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
230: NULL,PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE),
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
232: NULL,ATTRIBUTE_CATEGORY, x_ATTRIBUTE_CATEGORY),
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
234: NULL,ATTRIBUTE1, x_ATTRIBUTE1),
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
236: NULL,ATTRIBUTE2, x_ATTRIBUTE2),
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
231: ATTRIBUTE_CATEGORY = decode( x_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,NULL,
232: NULL,ATTRIBUTE_CATEGORY, x_ATTRIBUTE_CATEGORY),
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
234: NULL,ATTRIBUTE1, x_ATTRIBUTE1),
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
236: NULL,ATTRIBUTE2, x_ATTRIBUTE2),
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
238: NULL,ATTRIBUTE3, x_ATTRIBUTE3),
239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,
233: ATTRIBUTE1 = decode( x_ATTRIBUTE1, FND_API.G_MISS_CHAR,NULL,
234: NULL,ATTRIBUTE1, x_ATTRIBUTE1),
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
236: NULL,ATTRIBUTE2, x_ATTRIBUTE2),
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
238: NULL,ATTRIBUTE3, x_ATTRIBUTE3),
239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,
240: NULL,ATTRIBUTE4, x_ATTRIBUTE4),
241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,
235: ATTRIBUTE2 = decode( x_ATTRIBUTE2, FND_API.G_MISS_CHAR,NULL,
236: NULL,ATTRIBUTE2, x_ATTRIBUTE2),
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
238: NULL,ATTRIBUTE3, x_ATTRIBUTE3),
239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,
240: NULL,ATTRIBUTE4, x_ATTRIBUTE4),
241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,
242: NULL,ATTRIBUTE5, x_ATTRIBUTE5),
243:
237: ATTRIBUTE3 = decode( x_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
238: NULL,ATTRIBUTE3, x_ATTRIBUTE3),
239: ATTRIBUTE4 = decode( x_ATTRIBUTE4, FND_API.G_MISS_CHAR,NULL,
240: NULL,ATTRIBUTE4, x_ATTRIBUTE4),
241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,
242: NULL,ATTRIBUTE5, x_ATTRIBUTE5),
243:
244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,
245: NULL,ATTRIBUTE6, x_ATTRIBUTE6),
240: NULL,ATTRIBUTE4, x_ATTRIBUTE4),
241: ATTRIBUTE5 = decode( x_ATTRIBUTE5, FND_API.G_MISS_CHAR,NULL,
242: NULL,ATTRIBUTE5, x_ATTRIBUTE5),
243:
244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,
245: NULL,ATTRIBUTE6, x_ATTRIBUTE6),
246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,
247: NULL,ATTRIBUTE7, x_ATTRIBUTE7),
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
242: NULL,ATTRIBUTE5, x_ATTRIBUTE5),
243:
244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,
245: NULL,ATTRIBUTE6, x_ATTRIBUTE6),
246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,
247: NULL,ATTRIBUTE7, x_ATTRIBUTE7),
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
249: NULL,ATTRIBUTE8, x_ATTRIBUTE8),
250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,
244: ATTRIBUTE6 = decode( x_ATTRIBUTE6, FND_API.G_MISS_CHAR,NULL,
245: NULL,ATTRIBUTE6, x_ATTRIBUTE6),
246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,
247: NULL,ATTRIBUTE7, x_ATTRIBUTE7),
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
249: NULL,ATTRIBUTE8, x_ATTRIBUTE8),
250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,
251: NULL,ATTRIBUTE9, x_ATTRIBUTE9),
252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
246: ATTRIBUTE7 = decode( x_ATTRIBUTE7, FND_API.G_MISS_CHAR,NULL,
247: NULL,ATTRIBUTE7, x_ATTRIBUTE7),
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
249: NULL,ATTRIBUTE8, x_ATTRIBUTE8),
250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,
251: NULL,ATTRIBUTE9, x_ATTRIBUTE9),
252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
253: NULL,ATTRIBUTE10, x_ATTRIBUTE10),
254:
248: ATTRIBUTE8 = decode( x_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
249: NULL,ATTRIBUTE8, x_ATTRIBUTE8),
250: ATTRIBUTE9= decode( x_ATTRIBUTE9, FND_API.G_MISS_CHAR,NULL,
251: NULL,ATTRIBUTE9, x_ATTRIBUTE9),
252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
253: NULL,ATTRIBUTE10, x_ATTRIBUTE10),
254:
255: ATTRIBUTE11 = decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR,NULL,
256: NULL,ATTRIBUTE11, x_ATTRIBUTE11),
251: NULL,ATTRIBUTE9, x_ATTRIBUTE9),
252: ATTRIBUTE10 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
253: NULL,ATTRIBUTE10, x_ATTRIBUTE10),
254:
255: ATTRIBUTE11 = decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR,NULL,
256: NULL,ATTRIBUTE11, x_ATTRIBUTE11),
257:
258: ATTRIBUTE12 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
259: NULL,ATTRIBUTE12, x_ATTRIBUTE12),
254:
255: ATTRIBUTE11 = decode( x_ATTRIBUTE11, FND_API.G_MISS_CHAR,NULL,
256: NULL,ATTRIBUTE11, x_ATTRIBUTE11),
257:
258: ATTRIBUTE12 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
259: NULL,ATTRIBUTE12, x_ATTRIBUTE12),
260:
261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
262: NULL,ATTRIBUTE13, x_ATTRIBUTE13),
257:
258: ATTRIBUTE12 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
259: NULL,ATTRIBUTE12, x_ATTRIBUTE12),
260:
261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
262: NULL,ATTRIBUTE13, x_ATTRIBUTE13),
263: ATTRIBUTE14 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
264: NULL,ATTRIBUTE14, x_ATTRIBUTE14),
265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,
259: NULL,ATTRIBUTE12, x_ATTRIBUTE12),
260:
261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
262: NULL,ATTRIBUTE13, x_ATTRIBUTE13),
263: ATTRIBUTE14 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
264: NULL,ATTRIBUTE14, x_ATTRIBUTE14),
265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,
266: NULL,ATTRIBUTE15, x_ATTRIBUTE15),
267:
261: ATTRIBUTE13 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
262: NULL,ATTRIBUTE13, x_ATTRIBUTE13),
263: ATTRIBUTE14 = decode( x_ATTRIBUTE10, FND_API.G_MISS_CHAR,NULL,
264: NULL,ATTRIBUTE14, x_ATTRIBUTE14),
265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,
266: NULL,ATTRIBUTE15, x_ATTRIBUTE15),
267:
268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,
269: NULL,LAST_UPDATED_BY, x_LAST_UPDATED_BY),
264: NULL,ATTRIBUTE14, x_ATTRIBUTE14),
265: ATTRIBUTE15 = decode( x_ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL,
266: NULL,ATTRIBUTE15, x_ATTRIBUTE15),
267:
268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,
269: NULL,LAST_UPDATED_BY, x_LAST_UPDATED_BY),
270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
271: NULL,LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
266: NULL,ATTRIBUTE15, x_ATTRIBUTE15),
267:
268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,
269: NULL,LAST_UPDATED_BY, x_LAST_UPDATED_BY),
270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
271: NULL,LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
273: NULL,LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
268: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,NULL,
269: NULL,LAST_UPDATED_BY, x_LAST_UPDATED_BY),
270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
271: NULL,LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
273: NULL,LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
275: NULL,WRITEOFF_STATUS, x_WRITEOFF_STATUS),
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
270: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,NULL,
271: NULL,LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
273: NULL,LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
275: NULL,WRITEOFF_STATUS, x_WRITEOFF_STATUS),
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
277: NULL,WRITEOFF_TYPE_ID, X_WRITEOFF_TYPE_ID),
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
272: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,NULL,
273: NULL,LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
275: NULL,WRITEOFF_STATUS, x_WRITEOFF_STATUS),
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
277: NULL,WRITEOFF_TYPE_ID, X_WRITEOFF_TYPE_ID),
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
279: NULL,WRITEOFF_TYPE, x_WRITEOFF_TYPE),
280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,
274: WRITEOFF_STATUS = decode( x_WRITEOFF_STATUS, FND_API.G_MISS_CHAR,NULL,
275: NULL,WRITEOFF_STATUS, x_WRITEOFF_STATUS),
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
277: NULL,WRITEOFF_TYPE_ID, X_WRITEOFF_TYPE_ID),
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
279: NULL,WRITEOFF_TYPE, x_WRITEOFF_TYPE),
280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,
281: NULL, customer_trx_id, x_customer_trx_id),
282: customer_trx_line_id = decode( x_customer_trx_line_id, FND_API.G_MISS_NUM,NULL,
276: WRITEOFF_TYPE_ID = decode( x_WRITEOFF_TYPE_ID, FND_API.G_MISS_NUM,NULL,
277: NULL,WRITEOFF_TYPE_ID, X_WRITEOFF_TYPE_ID),
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
279: NULL,WRITEOFF_TYPE, x_WRITEOFF_TYPE),
280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,
281: NULL, customer_trx_id, x_customer_trx_id),
282: customer_trx_line_id = decode( x_customer_trx_line_id, FND_API.G_MISS_NUM,NULL,
283: NULL, customer_trx_line_id, x_customer_trx_line_id)
284:
278: WRITEOFF_TYPE = decode( x_WRITEOFF_TYPE, FND_API.G_MISS_CHAR,NULL,
279: NULL,WRITEOFF_TYPE, x_WRITEOFF_TYPE),
280: customer_trx_id = decode( x_customer_trx_id, FND_API.G_MISS_NUM,NULL,
281: NULL, customer_trx_id, x_customer_trx_id),
282: customer_trx_line_id = decode( x_customer_trx_line_id, FND_API.G_MISS_NUM,NULL,
283: NULL, customer_trx_line_id, x_customer_trx_line_id)
284:
285: WHERE writeoff_object_id = x_WRITEOFF_OBJECT_ID;
286: