DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_LINES_PKG dependencies on FND_API

Line 181: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

177: x_msg_count => l_msg_count,
178: x_msg_data => l_msg_data
179: ) ;
180: --dbms_output.put_line('csf_debrief_lines_cuhk.Create_debrief_line_Pre Status '||l_return_status);
181: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
182: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
183: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
184: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
185: FND_MSG_PUB.Add;

Line 186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

182: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
183: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
184: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
185: FND_MSG_PUB.Add;
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188: END IF;
189:
190:

Line 206: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

202: x_msg_data => l_msg_data
203: ) ;
204:
205: --dbms_output.put_line('PRE CALLED STATUS '||l_return_status);
206: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
207: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
208: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
209: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
210: FND_MSG_PUB.Add;

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
208: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
209: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
210: FND_MSG_PUB.Add;
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213: END IF;
214: --dbms_output.put_line('csf_debrief_lines_iuhk ');
215:

Line 221: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

217: ( x_return_status => l_return_status
218: ) ;
219:
220: --dbms_output.put_line('csf_debrief_lines_iuhk status '||l_return_status);
221: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
222: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
223: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
224: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
225: FND_MSG_PUB.Add;

Line 226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

222: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
223: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
224: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
225: FND_MSG_PUB.Add;
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228:
229: end if;
230:

Line 233: If (l_debrief_line.DEBRIEF_LINE_ID IS NULL) OR (l_debrief_line.DEBRIEF_LINE_ID = FND_API.G_MISS_NUM) then

229: end if;
230:
231: --dbms_output.put_line('SOME IF ');
232: if l_dml_mode = 'BOTH' then
233: If (l_debrief_line.DEBRIEF_LINE_ID IS NULL) OR (l_debrief_line.DEBRIEF_LINE_ID = FND_API.G_MISS_NUM) then
234: OPEN C2;
235: FETCH C2 INTO px_DEBRIEF_LINE_ID;
236: CLOSE C2;
237: End If;

Line 316: decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_HEADER_ID),

312: TRANSACTION_TYPE_ID,
313: RETURN_DATE
314: ) VALUES (
315: px_DEBRIEF_LINE_ID,
316: decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_HEADER_ID),
317: decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_NUMBER),
318: decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.SERVICE_DATE),
319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),
320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),

Line 317: decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_NUMBER),

313: RETURN_DATE
314: ) VALUES (
315: px_DEBRIEF_LINE_ID,
316: decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_HEADER_ID),
317: decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_NUMBER),
318: decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.SERVICE_DATE),
319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),
320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),
321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),

Line 318: decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.SERVICE_DATE),

314: ) VALUES (
315: px_DEBRIEF_LINE_ID,
316: decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_HEADER_ID),
317: decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_NUMBER),
318: decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.SERVICE_DATE),
319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),
320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),
321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),
322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),

Line 319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),

315: px_DEBRIEF_LINE_ID,
316: decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_HEADER_ID),
317: decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_NUMBER),
318: decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.SERVICE_DATE),
319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),
320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),
321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),
322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),
323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),

Line 320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),

316: decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_HEADER_ID),
317: decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_NUMBER),
318: decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.SERVICE_DATE),
319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),
320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),
321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),
322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),
323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),

Line 321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),

317: decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_NUMBER),
318: decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.SERVICE_DATE),
319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),
320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),
321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),
322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),
323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),

Line 322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),

318: decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.SERVICE_DATE),
319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),
320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),
321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),
322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),
323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),

Line 323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),

319: decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.BUSINESS_PROCESS_ID),
320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),
321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),
322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),
323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),

Line 324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),

320: decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TXN_BILLING_TYPE_ID),
321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),
322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),
323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),
328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),

Line 325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),

321: decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INVENTORY_ITEM_ID),
322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),
323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),
328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),
329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),

Line 326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),

322: decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.INSTANCE_ID),
323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),
328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),
329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),
330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),

Line 327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),

323: decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),
328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),
329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),
330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),
331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),

Line 328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),

324: decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),
328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),
329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),
330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),
331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),
332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),

Line 329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),

325: decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),
328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),
329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),
330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),
331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),
332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),
333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),

Line 330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),

326: decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),
328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),
329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),
330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),
331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),
332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),
333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),
334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),

Line 331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),

327: decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.ISSUING_LOCATOR_ID),
328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),
329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),
330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),
331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),
332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),
333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),
334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),
335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),

Line 332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),

328: decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RECEIVING_LOCATOR_ID),
329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),
330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),
331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),
332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),
333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),
334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),
335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),
336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),

Line 333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),

329: decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.PARENT_PRODUCT_ID),
330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),
331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),
332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),
333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),
334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),
335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),
336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),
337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),

Line 334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),

330: decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.REMOVED_PRODUCT_ID),
331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),
332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),
333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),
334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),
335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),
336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),
337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),
338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),

Line 335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),

331: decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, NULL, l_debrief_line.STATUS_OF_RECEIVED_PART),
332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),
333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),
334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),
335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),
336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),
337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),
338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),
339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),

Line 336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),

332: decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_SERIAL_NUMBER),
333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),
334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),
335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),
336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),
337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),
338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),
339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),
340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),

Line 337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),

333: decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_REVISION),
334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),
335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),
336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),
337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),
338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),
339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),
340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),
341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),

Line 338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),

334: decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ITEM_LOTNUMBER),
335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),
336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),
337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),
338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),
339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),
340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),
341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),
342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),

Line 339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),

335: decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.UOM_CODE),
336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),
337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),
338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),
339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),
340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),
341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),
342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),
343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),

Line 340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),

336: decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, NULL, l_debrief_line.QUANTITY),
337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),
338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),
339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),
340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),
341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),
342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),
343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),
344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),

Line 341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),

337: decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.RMA_HEADER_ID),
338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),
339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),
340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),
341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),
342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),
343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),
344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),
345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),

Line 342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),

338: decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.DISPOSITION_CODE),
339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),
340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),
341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),
342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),
343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),
344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),
345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),
346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),

Line 343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),

339: decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.MATERIAL_REASON_CODE),
340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),
341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),
342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),
343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),
344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),
345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),
346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),
347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),

Line 344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),

340: decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.LABOR_REASON_CODE),
341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),
342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),
343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),
344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),
345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),
346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),
347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),
348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),

Line 345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),

341: decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.EXPENSE_REASON_CODE),
342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),
343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),
344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),
345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),
346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),
347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),
348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),

Line 346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),

342: decode( l_debrief_line.LABOR_START_DATE, FND_API.G_MISS_DATE, to_date(null),l_debrief_line.labor_start_date),
343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),
344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),
345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),
346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),
347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),
348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),
350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),

Line 347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),

343: decode( l_debrief_line.LABOR_END_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_line.labor_end_date),
344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),
345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),
346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),
347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),
348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),
350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),
351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),

Line 348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),

344: decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.STARTING_MILEAGE),
345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),
346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),
347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),
348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),
350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),
351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),
352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),

Line 349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),

345: decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, NULL, l_debrief_line.ENDING_MILEAGE),
346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),
347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),
348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),
350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),
351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),
352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),

Line 350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),

346: decode( l_debrief_line.EXPENSE_AMOUNT, FND_API.G_MISS_NUM, NULL, l_debrief_line.EXPENSE_AMOUNT),
347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),
348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),
350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),
351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),
352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),

Line 351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),

347: decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CURRENCY_CODE),
348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),
350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),
351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),
352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),
355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),

Line 352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),

348: decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),
350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),
351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),
352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),
355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),
356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),

Line 353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),

349: decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.RETURN_REASON_CODE),
350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),
351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),
352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),
355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),
356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),
357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),

Line 354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),

350: decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHANNEL_CODE),
351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),
352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),
355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),
356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),
357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),
358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),

Line 355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),

351: decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_STATUS),
352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),
355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),
356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),
357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),
358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),
359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),

Line 356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),

352: decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),
355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),
356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),
357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),
358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),
359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),
360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),

Line 357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),

353: decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),
355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),
356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),
357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),
358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),
359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),
360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),
361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),

Line 358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),

354: decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_STATUS),
355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),
356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),
357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),
358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),
359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),
360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),
361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),
362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),

Line 359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),

355: decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MSG_CODE),
356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),
357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),
358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),
359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),
360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),
361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),
362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),
363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),

Line 360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),

356: decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.IB_UPDATE_MESSAGE),
357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),
358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),
359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),
360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),
361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),
362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),
363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),
364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),

Line 361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),

357: decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_STATUS),
358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),
359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),
360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),
361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),
362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),
363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),
364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),
365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),

Line 362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),

358: decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MSG_CODE),
359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),
360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),
361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),
362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),
363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),
364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),
365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),
366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),

Line 363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),

359: decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, NULL, l_debrief_line.SPARE_UPDATE_MESSAGE),
360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),
361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),
362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),
363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),
364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),
365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),
366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),
367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),

Line 364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),

360: decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.CREATED_BY),
361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),
362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),
363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),
364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),
365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),
366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),
367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),
368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),

Line 365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),

361: decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_line.creation_date),
362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),
363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),
364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),
365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),
366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),
367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),
368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),
369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),

Line 366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),

362: decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_line.LAST_UPDATED_BY),
363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),
364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),
365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),
366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),
367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),
368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),
369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),
370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),

Line 367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),

363: decode( l_debrief_line.last_update_date, FND_API.G_MISS_DATE, sysdate, l_debrief_line.last_update_date),
364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),
365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),
366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),
367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),
368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),
369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),
370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),
371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),

Line 368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),

364: decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_line.LAST_UPDATE_LOGIN),
365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),
366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),
367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),
368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),
369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),
370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),
371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),
372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),

Line 369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),

365: decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE1),
366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),
367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),
368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),
369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),
370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),
371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),
372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),
373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),

Line 370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),

366: decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE2),
367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),
368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),
369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),
370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),
371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),
372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),
373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),
374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),

Line 371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),

367: decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE3),
368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),
369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),
370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),
371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),
372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),
373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),
374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),
375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),

Line 372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),

368: decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE4),
369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),
370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),
371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),
372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),
373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),
374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),
375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),
376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),

Line 373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),

369: decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE5),
370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),
371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),
372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),
373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),
374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),
375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),
376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),
377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),

Line 374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),

370: decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE6),
371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),
372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),
373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),
374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),
375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),
376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),
377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),
378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),

Line 375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),

371: decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE7),
372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),
373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),
374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),
375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),
376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),
377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),
378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),
379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),

Line 376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),

372: decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE8),
373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),
374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),
375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),
376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),
377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),
378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),
379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),
380: decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE_CATEGORY),

Line 377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),

373: decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE9),
374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),
375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),
376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),
377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),
378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),
379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),
380: decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE_CATEGORY),
381: decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TRANSACTION_TYPE_ID),

Line 378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),

374: decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE10),
375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),
376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),
377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),
378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),
379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),
380: decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE_CATEGORY),
381: decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TRANSACTION_TYPE_ID),
382: decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, NULL, l_debrief_line.RETURN_DATE)

Line 379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),

375: decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE11),
376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),
377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),
378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),
379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),
380: decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE_CATEGORY),
381: decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TRANSACTION_TYPE_ID),
382: decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, NULL, l_debrief_line.RETURN_DATE)
383: );

Line 380: decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE_CATEGORY),

376: decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE12),
377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),
378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),
379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),
380: decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE_CATEGORY),
381: decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TRANSACTION_TYPE_ID),
382: decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, NULL, l_debrief_line.RETURN_DATE)
383: );
384: end if;

Line 381: decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TRANSACTION_TYPE_ID),

377: decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE13),
378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),
379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),
380: decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE_CATEGORY),
381: decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TRANSACTION_TYPE_ID),
382: decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, NULL, l_debrief_line.RETURN_DATE)
383: );
384: end if;
385:

Line 382: decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, NULL, l_debrief_line.RETURN_DATE)

378: decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE14),
379: decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE15),
380: decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_line.ATTRIBUTE_CATEGORY),
381: decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_debrief_line.TRANSACTION_TYPE_ID),
382: decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, NULL, l_debrief_line.RETURN_DATE)
383: );
384: end if;
385:
386: -- dbms_output.put_line('INSERTED ');

Line 399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

395: x_msg_count => l_msg_count,
396: x_msg_data => l_msg_data
397: ) ;
398: --dbms_output.put_line('POST '||l_return_status);
399: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
400: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
401: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
402: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
403: FND_MSG_PUB.Add;

Line 404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

400: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
401: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
402: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
403: FND_MSG_PUB.Add;
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406: END IF;
407:
408:

Line 421: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

417: x_msg_count => l_msg_count,
418: x_msg_data => l_msg_data
419: ) ;
420:
421: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
422: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
423: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
424: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
425: FND_MSG_PUB.Add;

Line 426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
423: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
424: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
425: FND_MSG_PUB.Add;
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428: END IF;
429:
430: csf_debrief_lines_iuhk.Create_debrief_line_post

Line 434: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

430: csf_debrief_lines_iuhk.Create_debrief_line_post
431: ( x_return_status => l_return_status
432: ) ;
433:
434: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
435: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
436: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
437: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
438: FND_MSG_PUB.Add;

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

435: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
436: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
437: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
438: FND_MSG_PUB.Add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441: end if;
442: --dbms_output.put_line('END INSERT ROW ');
443: End Insert_Row;

Line 612: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

608: x_return_status => l_return_status,
609: x_msg_count => l_msg_count,
610: x_msg_data => l_msg_data
611: ) ;
612: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
613: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
614: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
615: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
616: FND_MSG_PUB.Add;

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
614: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
615: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
616: FND_MSG_PUB.Add;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619: END IF;
620:
621:

Line 634: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

630: x_msg_count => l_msg_count,
631: x_msg_data => l_msg_data
632: ) ;
633:
634: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
635: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
636: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
637: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
638: FND_MSG_PUB.Add;

Line 639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

635: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
636: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
637: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
640: END IF;
641: END IF;
642: user_hooks_rec.DEBRIEF_LINE_ID := l_debrief_line.DEBRIEF_LINE_ID;
643: csf_debrief_lines_iuhk.update_debrief_line_Pre

Line 647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

643: csf_debrief_lines_iuhk.update_debrief_line_Pre
644: ( x_return_status => l_return_status
645: ) ;
646:
647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
648: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
649: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
650: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
651: FND_MSG_PUB.Add;

Line 652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

648: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
649: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
650: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
651: FND_MSG_PUB.Add;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: end if;
656:

Line 661: DEBRIEF_HEADER_ID = decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, DEBRIEF_HEADER_ID, l_debrief_line.DEBRIEF_HEADER_ID),

657: if l_dml_mode = 'BOTH' then
658:
659: Update CSF_DEBRIEF_LINES
660: SET
661: DEBRIEF_HEADER_ID = decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, DEBRIEF_HEADER_ID, l_debrief_line.DEBRIEF_HEADER_ID),
662: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),
663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),
664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),
665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),

Line 662: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),

658:
659: Update CSF_DEBRIEF_LINES
660: SET
661: DEBRIEF_HEADER_ID = decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, DEBRIEF_HEADER_ID, l_debrief_line.DEBRIEF_HEADER_ID),
662: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),
663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),
664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),
665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),
666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),

Line 663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),

659: Update CSF_DEBRIEF_LINES
660: SET
661: DEBRIEF_HEADER_ID = decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, DEBRIEF_HEADER_ID, l_debrief_line.DEBRIEF_HEADER_ID),
662: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),
663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),
664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),
665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),
666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),
667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),

Line 664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),

660: SET
661: DEBRIEF_HEADER_ID = decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, DEBRIEF_HEADER_ID, l_debrief_line.DEBRIEF_HEADER_ID),
662: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),
663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),
664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),
665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),
666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),
667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),
668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),

Line 665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),

661: DEBRIEF_HEADER_ID = decode( l_debrief_line.DEBRIEF_HEADER_ID, FND_API.G_MISS_NUM, DEBRIEF_HEADER_ID, l_debrief_line.DEBRIEF_HEADER_ID),
662: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),
663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),
664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),
665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),
666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),
667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),
668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),

Line 666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),

662: DEBRIEF_LINE_NUMBER = decode( l_debrief_line.DEBRIEF_LINE_NUMBER, FND_API.G_MISS_NUM, DEBRIEF_LINE_NUMBER, l_debrief_line.DEBRIEF_LINE_NUMBER),
663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),
664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),
665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),
666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),
667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),
668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),

Line 667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),

663: SERVICE_DATE = decode( l_debrief_line.SERVICE_DATE, FND_API.G_MISS_DATE, SERVICE_DATE, l_debrief_line.SERVICE_DATE),
664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),
665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),
666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),
667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),
668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),

Line 668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),

664: BUSINESS_PROCESS_ID = decode( l_debrief_line.BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, l_debrief_line.BUSINESS_PROCESS_ID),
665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),
666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),
667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),
668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),

Line 669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),

665: TXN_BILLING_TYPE_ID = decode( l_debrief_line.TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, l_debrief_line.TXN_BILLING_TYPE_ID),
666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),
667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),
668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),
673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),

Line 670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),

666: INVENTORY_ITEM_ID = decode( l_debrief_line.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, l_debrief_line.INVENTORY_ITEM_ID),
667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),
668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),
673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),
674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),

Line 671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),

667: INSTANCE_ID = decode( l_debrief_line.INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, l_debrief_line.INSTANCE_ID),
668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),
673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),
674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),
675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),

Line 672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),

668: ISSUING_INVENTORY_ORG_ID = decode( l_debrief_line.ISSUING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, ISSUING_INVENTORY_ORG_ID, l_debrief_line.ISSUING_INVENTORY_ORG_ID),
669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),
673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),
674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),
675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),
676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),

Line 673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),

669: RECEIVING_INVENTORY_ORG_ID = decode( l_debrief_line.RECEIVING_INVENTORY_ORG_ID, FND_API.G_MISS_NUM, RECEIVING_INVENTORY_ORG_ID, l_debrief_line.RECEIVING_INVENTORY_ORG_ID),
670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),
673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),
674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),
675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),
676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),
677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),

Line 674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),

670: ISSUING_SUB_INVENTORY_CODE = decode( l_debrief_line.ISSUING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, ISSUING_SUB_INVENTORY_CODE, l_debrief_line.ISSUING_SUB_INVENTORY_CODE),
671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),
673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),
674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),
675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),
676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),
677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),
678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),

Line 675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),

671: RECEIVING_SUB_INVENTORY_CODE = decode( l_debrief_line.RECEIVING_SUB_INVENTORY_CODE, FND_API.G_MISS_CHAR, RECEIVING_SUB_INVENTORY_CODE, l_debrief_line.RECEIVING_SUB_INVENTORY_CODE),
672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),
673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),
674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),
675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),
676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),
677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),
678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),
679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),

Line 676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),

672: ISSUING_LOCATOR_ID = decode( l_debrief_line.ISSUING_LOCATOR_ID, FND_API.G_MISS_NUM, ISSUING_LOCATOR_ID, l_debrief_line.ISSUING_LOCATOR_ID),
673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),
674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),
675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),
676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),
677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),
678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),
679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),
680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),

Line 677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),

673: RECEIVING_LOCATOR_ID = decode( l_debrief_line.RECEIVING_LOCATOR_ID, FND_API.G_MISS_NUM, RECEIVING_LOCATOR_ID, l_debrief_line.RECEIVING_LOCATOR_ID),
674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),
675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),
676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),
677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),
678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),
679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),
680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),
681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),

Line 678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),

674: PARENT_PRODUCT_ID = decode( l_debrief_line.PARENT_PRODUCT_ID, FND_API.G_MISS_NUM, PARENT_PRODUCT_ID, l_debrief_line.PARENT_PRODUCT_ID),
675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),
676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),
677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),
678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),
679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),
680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),
681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),
682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),

Line 679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),

675: REMOVED_PRODUCT_ID = decode( l_debrief_line.REMOVED_PRODUCT_ID, FND_API.G_MISS_NUM, REMOVED_PRODUCT_ID, l_debrief_line.REMOVED_PRODUCT_ID),
676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),
677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),
678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),
679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),
680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),
681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),
682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),
683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),

Line 680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),

676: STATUS_OF_RECEIVED_PART = decode( l_debrief_line.STATUS_OF_RECEIVED_PART, FND_API.G_MISS_CHAR, STATUS_OF_RECEIVED_PART, l_debrief_line.STATUS_OF_RECEIVED_PART),
677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),
678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),
679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),
680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),
681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),
682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),
683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),
684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),

Line 681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),

677: ITEM_SERIAL_NUMBER = decode( l_debrief_line.ITEM_SERIAL_NUMBER, FND_API.G_MISS_CHAR, ITEM_SERIAL_NUMBER, l_debrief_line.ITEM_SERIAL_NUMBER),
678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),
679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),
680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),
681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),
682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),
683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),
684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),
685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),

Line 682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),

678: ITEM_REVISION = decode( l_debrief_line.ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, l_debrief_line.ITEM_REVISION),
679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),
680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),
681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),
682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),
683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),
684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),
685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),
686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),

Line 683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),

679: ITEM_LOTNUMBER = decode( l_debrief_line.ITEM_LOTNUMBER, FND_API.G_MISS_CHAR, ITEM_LOTNUMBER, l_debrief_line.ITEM_LOTNUMBER),
680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),
681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),
682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),
683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),
684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),
685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),
686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),
687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),

Line 684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),

680: UOM_CODE = decode( l_debrief_line.UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, l_debrief_line.UOM_CODE),
681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),
682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),
683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),
684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),
685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),
686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),
687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),
688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),

Line 685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),

681: QUANTITY = decode( l_debrief_line.QUANTITY, FND_API.G_MISS_NUM, QUANTITY, l_debrief_line.QUANTITY),
682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),
683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),
684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),
685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),
686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),
687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),
688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),
689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),

Line 686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),

682: RMA_HEADER_ID = decode( l_debrief_line.RMA_HEADER_ID, FND_API.G_MISS_NUM, RMA_HEADER_ID, l_debrief_line.RMA_HEADER_ID),
683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),
684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),
685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),
686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),
687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),
688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),
689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),
690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),

Line 687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),

683: DISPOSITION_CODE = decode( l_debrief_line.DISPOSITION_CODE, FND_API.G_MISS_CHAR, DISPOSITION_CODE, l_debrief_line.DISPOSITION_CODE),
684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),
685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),
686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),
687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),
688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),
689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),
690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),
691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),

Line 688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),

684: MATERIAL_REASON_CODE = decode( l_debrief_line.MATERIAL_REASON_CODE, FND_API.G_MISS_CHAR, MATERIAL_REASON_CODE, l_debrief_line.MATERIAL_REASON_CODE),
685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),
686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),
687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),
688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),
689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),
690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),
691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),
692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),

Line 689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),

685: LABOR_REASON_CODE = decode( l_debrief_line.LABOR_REASON_CODE, FND_API.G_MISS_CHAR, LABOR_REASON_CODE, l_debrief_line.LABOR_REASON_CODE),
686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),
687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),
688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),
689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),
690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),
691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),
692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),
693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),

Line 690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),

686: EXPENSE_REASON_CODE = decode( l_debrief_line.EXPENSE_REASON_CODE, FND_API.G_MISS_CHAR, EXPENSE_REASON_CODE, l_debrief_line.EXPENSE_REASON_CODE),
687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),
688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),
689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),
690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),
691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),
692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),
693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),

Line 691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),

687: LABOR_START_DATE = decode(l_debrief_line.LABOR_START_DATE,fnd_api.g_miss_date,labor_start_date,l_debrief_line.labor_start_date),
688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),
689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),
690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),
691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),
692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),
693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),
695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),

Line 692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),

688: LABOR_END_DATE = decode(l_debrief_line.LABOR_END_DATE,fnd_api.g_miss_date,labor_end_date,l_debrief_line.labor_end_date),
689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),
690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),
691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),
692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),
693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),
695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),
696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),

Line 693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),

689: STARTING_MILEAGE = decode( l_debrief_line.STARTING_MILEAGE, FND_API.G_MISS_NUM, STARTING_MILEAGE, l_debrief_line.STARTING_MILEAGE),
690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),
691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),
692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),
693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),
695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),
696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),
697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),

Line 694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),

690: ENDING_MILEAGE = decode( l_debrief_line.ENDING_MILEAGE, FND_API.G_MISS_NUM, ENDING_MILEAGE, l_debrief_line.ENDING_MILEAGE),
691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),
692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),
693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),
695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),
696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),
697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),

Line 695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),

691: EXPENSE_AMOUNT = decode( p_EXPENSE_AMOUNT, FND_API.G_MISS_NUM, EXPENSE_AMOUNT, l_debrief_line.EXPENSE_AMOUNT),
692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),
693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),
695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),
696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),
697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),

Line 696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),

692: CURRENCY_CODE = decode( l_debrief_line.CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, l_debrief_line.CURRENCY_CODE),
693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),
695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),
696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),
697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),
700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),

Line 697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),

693: DEBRIEF_LINE_STATUS_ID = decode( l_debrief_line.DEBRIEF_LINE_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_LINE_STATUS_ID, l_debrief_line.DEBRIEF_LINE_STATUS_ID),
694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),
695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),
696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),
697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),
700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),
701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),

Line 698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),

694: RETURN_REASON_CODE = decode( l_debrief_line.RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, l_debrief_line.return_reason_CODE),
695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),
696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),
697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),
700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),
701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),
702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),

Line 699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),

695: CHANNEL_CODE = decode( l_debrief_line.CHANNEL_CODE, FND_API.G_MISS_CHAR, CHANNEL_CODE, l_debrief_line.CHANNEL_CODE),
696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),
697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),
700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),
701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),
702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),
703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),

Line 700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),

696: CHARGE_UPLOAD_STATUS = decode( l_debrief_line.CHARGE_UPLOAD_STATUS, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_STATUS, l_debrief_line.CHARGE_UPLOAD_STATUS),
697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),
700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),
701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),
702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),
703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),
704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),

Line 701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),

697: CHARGE_UPLOAD_MSG_CODE = decode( l_debrief_line.CHARGE_UPLOAD_MSG_CODE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MSG_CODE, l_debrief_line.CHARGE_UPLOAD_MSG_CODE),
698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),
700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),
701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),
702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),
703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),
704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),
705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),

Line 702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),

698: CHARGE_UPLOAD_MESSAGE = decode( l_debrief_line.CHARGE_UPLOAD_MESSAGE, FND_API.G_MISS_CHAR, CHARGE_UPLOAD_MESSAGE, l_debrief_line.CHARGE_UPLOAD_MESSAGE),
699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),
700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),
701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),
702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),
703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),
704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),
705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),
706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),

Line 703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),

699: IB_UPDATE_STATUS = decode( l_debrief_line.IB_UPDATE_STATUS, FND_API.G_MISS_CHAR, IB_UPDATE_STATUS, l_debrief_line.IB_UPDATE_STATUS),
700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),
701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),
702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),
703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),
704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),
705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),
706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),
707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),

Line 704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),

700: IB_UPDATE_MSG_CODE = decode( l_debrief_line.IB_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, IB_UPDATE_MSG_CODE, l_debrief_line.IB_UPDATE_MSG_CODE),
701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),
702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),
703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),
704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),
705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),
706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),
707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),
708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),

Line 705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),

701: IB_UPDATE_MESSAGE = decode( l_debrief_line.IB_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, IB_UPDATE_MESSAGE, l_debrief_line.IB_UPDATE_MESSAGE),
702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),
703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),
704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),
705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),
706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),
707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),
708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),
709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),

Line 706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),

702: SPARE_UPDATE_STATUS = decode( l_debrief_line.SPARE_UPDATE_STATUS, FND_API.G_MISS_CHAR, SPARE_UPDATE_STATUS, l_debrief_line.SPARE_UPDATE_STATUS),
703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),
704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),
705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),
706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),
707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),
708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),
709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),
710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),

Line 707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),

703: SPARE_UPDATE_MSG_CODE = decode( l_debrief_line.SPARE_UPDATE_MSG_CODE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MSG_CODE, l_debrief_line.SPARE_UPDATE_MSG_CODE),
704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),
705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),
706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),
707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),
708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),
709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),
710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),
711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),

Line 708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),

704: SPARE_UPDATE_MESSAGE = decode( l_debrief_line.SPARE_UPDATE_MESSAGE, FND_API.G_MISS_CHAR, SPARE_UPDATE_MESSAGE, l_debrief_line.SPARE_UPDATE_MESSAGE),
705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),
706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),
707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),
708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),
709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),
710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),
711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),
712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),

Line 709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),

705: error_text = decode( l_debrief_line.error_text, FND_API.G_MISS_CHAR, error_text, l_debrief_line.error_text),
706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),
707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),
708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),
709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),
710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),
711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),
712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),
713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),

Line 710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),

706: CREATED_BY = decode( l_debrief_line.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_line.CREATED_BY),
707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),
708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),
709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),
710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),
711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),
712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),
713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),
714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),

Line 711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),

707: CREATION_DATE = decode( l_debrief_line.CREATION_DATE, FND_API.G_MISS_DATE,creation_date,l_debrief_line.creation_date),
708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),
709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),
710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),
711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),
712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),
713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),
714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),
715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),

Line 712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),

708: LAST_UPDATED_BY = decode( l_debrief_line.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_line.LAST_UPDATED_BY),
709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),
710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),
711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),
712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),
713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),
714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),
715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),
716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),

Line 713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),

709: LAST_UPDATE_DATE = decode(l_debrief_line.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_debrief_line.last_update_date),
710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),
711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),
712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),
713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),
714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),
715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),
716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),
717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),

Line 714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),

710: LAST_UPDATE_LOGIN = decode( l_debrief_line.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_line.LAST_UPDATE_LOGIN),
711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),
712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),
713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),
714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),
715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),
716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),
717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),
718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),

Line 715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),

711: ATTRIBUTE1 = decode( l_debrief_line.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_line.ATTRIBUTE1),
712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),
713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),
714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),
715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),
716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),
717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),
718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),
719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),

Line 716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),

712: ATTRIBUTE2 = decode( l_debrief_line.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_line.ATTRIBUTE2),
713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),
714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),
715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),
716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),
717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),
718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),
719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),
720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),

Line 717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),

713: ATTRIBUTE3 = decode( l_debrief_line.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_line.ATTRIBUTE3),
714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),
715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),
716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),
717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),
718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),
719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),
720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),
721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),

Line 718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),

714: ATTRIBUTE4 = decode( l_debrief_line.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_line.ATTRIBUTE4),
715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),
716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),
717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),
718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),
719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),
720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),
721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),
722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),

Line 719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),

715: ATTRIBUTE5 = decode( l_debrief_line.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_line.ATTRIBUTE5),
716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),
717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),
718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),
719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),
720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),
721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),
722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),
723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),

Line 720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),

716: ATTRIBUTE6 = decode( l_debrief_line.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_line.ATTRIBUTE6),
717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),
718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),
719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),
720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),
721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),
722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),
723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),
724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),

Line 721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),

717: ATTRIBUTE7 = decode( l_debrief_line.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_line.ATTRIBUTE7),
718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),
719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),
720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),
721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),
722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),
723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),
724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),
725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),

Line 722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),

718: ATTRIBUTE8 = decode( l_debrief_line.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_line.ATTRIBUTE8),
719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),
720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),
721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),
722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),
723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),
724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),
725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),
726: ATTRIBUTE_CATEGORY = decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_line.ATTRIBUTE_CATEGORY),

Line 723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),

719: ATTRIBUTE9 = decode( l_debrief_line.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_line.ATTRIBUTE9),
720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),
721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),
722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),
723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),
724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),
725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),
726: ATTRIBUTE_CATEGORY = decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_line.ATTRIBUTE_CATEGORY),
727: TRANSACTION_TYPE_ID = decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, l_debrief_line.TRANSACTION_TYPE_ID),

Line 724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),

720: ATTRIBUTE10 = decode( l_debrief_line.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_line.ATTRIBUTE10),
721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),
722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),
723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),
724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),
725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),
726: ATTRIBUTE_CATEGORY = decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_line.ATTRIBUTE_CATEGORY),
727: TRANSACTION_TYPE_ID = decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, l_debrief_line.TRANSACTION_TYPE_ID),
728: RETURN_DATE = decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, RETURN_DATE, l_debrief_line.RETURN_DATE)

Line 725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),

721: ATTRIBUTE11 = decode( l_debrief_line.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_line.ATTRIBUTE11),
722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),
723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),
724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),
725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),
726: ATTRIBUTE_CATEGORY = decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_line.ATTRIBUTE_CATEGORY),
727: TRANSACTION_TYPE_ID = decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, l_debrief_line.TRANSACTION_TYPE_ID),
728: RETURN_DATE = decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, RETURN_DATE, l_debrief_line.RETURN_DATE)
729:

Line 726: ATTRIBUTE_CATEGORY = decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_line.ATTRIBUTE_CATEGORY),

722: ATTRIBUTE12 = decode( l_debrief_line.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_line.ATTRIBUTE12),
723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),
724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),
725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),
726: ATTRIBUTE_CATEGORY = decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_line.ATTRIBUTE_CATEGORY),
727: TRANSACTION_TYPE_ID = decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, l_debrief_line.TRANSACTION_TYPE_ID),
728: RETURN_DATE = decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, RETURN_DATE, l_debrief_line.RETURN_DATE)
729:
730: where DEBRIEF_LINE_ID = l_debrief_line.DEBRIEF_LINE_ID;

Line 727: TRANSACTION_TYPE_ID = decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, l_debrief_line.TRANSACTION_TYPE_ID),

723: ATTRIBUTE13 = decode( l_debrief_line.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_line.ATTRIBUTE13),
724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),
725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),
726: ATTRIBUTE_CATEGORY = decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_line.ATTRIBUTE_CATEGORY),
727: TRANSACTION_TYPE_ID = decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, l_debrief_line.TRANSACTION_TYPE_ID),
728: RETURN_DATE = decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, RETURN_DATE, l_debrief_line.RETURN_DATE)
729:
730: where DEBRIEF_LINE_ID = l_debrief_line.DEBRIEF_LINE_ID;
731:

Line 728: RETURN_DATE = decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, RETURN_DATE, l_debrief_line.RETURN_DATE)

724: ATTRIBUTE14 = decode( l_debrief_line.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_line.ATTRIBUTE14),
725: ATTRIBUTE15 = decode( l_debrief_line.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_line.ATTRIBUTE15),
726: ATTRIBUTE_CATEGORY = decode( l_debrief_line.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_line.ATTRIBUTE_CATEGORY),
727: TRANSACTION_TYPE_ID = decode( l_debrief_line.TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, l_debrief_line.TRANSACTION_TYPE_ID),
728: RETURN_DATE = decode( l_debrief_line.RETURN_DATE, FND_API.G_MISS_DATE, RETURN_DATE, l_debrief_line.RETURN_DATE)
729:
730: where DEBRIEF_LINE_ID = l_debrief_line.DEBRIEF_LINE_ID;
731:
732: If (SQL%NOTFOUND) then

Line 750: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

746: x_return_status => l_return_status,
747: x_msg_count => l_msg_count,
748: x_msg_data => l_msg_data
749: ) ;
750: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
751: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
752: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
753: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
754: FND_MSG_PUB.Add;

Line 755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

751: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
752: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
753: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
754: FND_MSG_PUB.Add;
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757: END IF;
758:
759:

Line 772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

768: x_msg_count => l_msg_count,
769: x_msg_data => l_msg_data
770: ) ;
771:
772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
773: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
774: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
775: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
776: FND_MSG_PUB.Add;

Line 777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

773: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
774: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
775: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
776: FND_MSG_PUB.Add;
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779: END IF;
780:
781: csf_debrief_lines_iuhk.update_debrief_line_post

Line 785: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

781: csf_debrief_lines_iuhk.update_debrief_line_post
782: ( x_return_status => l_return_status
783: ) ;
784:
785: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
786: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
787: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
788: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
789: FND_MSG_PUB.Add;

Line 790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

786: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
787: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
788: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792:
793: end if;
794:

Line 823: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

819: x_return_status => l_return_status,
820: x_msg_count => l_msg_count,
821: x_msg_data => l_msg_data
822: ) ;
823: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
824: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
825: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
826: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
827: FND_MSG_PUB.Add;

Line 828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

824: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
825: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
826: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
827: FND_MSG_PUB.Add;
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830: END IF;
831:
832:

Line 845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

841: x_msg_count => l_msg_count,
842: x_msg_data => l_msg_data
843: ) ;
844:
845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
846: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
847: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
848: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
849: FND_MSG_PUB.Add;

Line 850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

846: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
847: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
848: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
849: FND_MSG_PUB.Add;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;
853: user_hooks_rec.DEBRIEF_LINE_ID := p_DEBRIEF_LINE_ID;
854: csf_debrief_lines_iuhk.delete_debrief_line_Pre

Line 858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

854: csf_debrief_lines_iuhk.delete_debrief_line_Pre
855: ( x_return_status => l_return_status
856: ) ;
857:
858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
859: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
860: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
861: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
862: FND_MSG_PUB.Add;

Line 863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

859: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
860: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
861: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
862: FND_MSG_PUB.Add;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:
866: end if;
867:

Line 889: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

885: x_return_status => l_return_status,
886: x_msg_count => l_msg_count,
887: x_msg_data => l_msg_data
888: ) ;
889: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
890: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
891: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
892: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
893: FND_MSG_PUB.Add;

Line 894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

890: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
891: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
892: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
893: FND_MSG_PUB.Add;
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END IF;
896: END IF;
897:
898:

Line 911: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

907: x_msg_count => l_msg_count,
908: x_msg_data => l_msg_data
909: ) ;
910:
911: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
912: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
913: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
914: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
915: FND_MSG_PUB.Add;

Line 916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

912: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
913: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
914: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
915: FND_MSG_PUB.Add;
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918: END IF;
919:
920: csf_debrief_lines_iuhk.delete_debrief_line_post

Line 924: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

920: csf_debrief_lines_iuhk.delete_debrief_line_post
921: ( x_return_status => l_return_status
922: ) ;
923:
924: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
925: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
926: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
927: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
928: FND_MSG_PUB.Add;

Line 929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

925: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
926: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
927: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
928: FND_MSG_PUB.Add;
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931: end if;
932:
933: END Delete_Row;