APPS.INV_RCV_MOBILE_PROCESS_TXN dependencies on RCV_TRANSACTIONS_INTERFACE

Line 31: FROM RCV_TRANSACTIONS_INTERFACE

27: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
28: BEGIN
29: SELECT COUNT(1)
30: INTO l_rec_count
31: FROM RCV_TRANSACTIONS_INTERFACE
32: WHERE group_id = p_group_id;
33:
34: IF (l_rec_count = 0) THEN
35: IF (l_debug = 1) THEN

Line 212: UPDATE RCV_TRANSACTIONS_INTERFACE

208: print_debug('rcv_online_request - timeout : '|| l_timeout, 1);
209: END IF;
210: Begin
211: print_debug('updating proceesing mode in rti for group id'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id,1);
212: UPDATE RCV_TRANSACTIONS_INTERFACE
213: SET PROCESSING_MODE_CODE = 'ONLINE'
214: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
215: AND PROCESSING_MODE_CODE <> 'ONLINE';
216: COMMIT;

Line 248: FROM rcv_transactions_interface

244: SELECT 'ERROR'
245: INTO l_outcome
246: FROM dual
247: WHERE EXISTS (SELECT 1
248: FROM rcv_transactions_interface
249: WHERE group_id = l_group_id
250: AND (transaction_status_code = 'ERROR' OR
251: processing_status_code = 'ERROR'));
252: EXCEPTION

Line 432: /* UPDATE rcv_transactions_interface

428: /* Bug# 6081470
429: * Commented out the below update statement as the same record set
430: * is getting deleted below
431: */
432: /* UPDATE rcv_transactions_interface
433: SET processing_status_code = 'COMPLETED'
434: , transaction_status_code = 'ERROR'
435: WHERE group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
436: */

Line 439: --delete from rcv_transactions_interface

435: WHERE group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
436: */
437:
438: --No need to delete the record in RTI. FPJ enhancement
439: --delete from rcv_transactions_interface
440: --where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
441:
442: /* Bug 4901912 -Deleting the errored RTIs */
443: IF (l_debug = 1) THEN

Line 448: delete from rcv_transactions_interface

444: print_debug('INV_RCV_MOBILE_PROCESS_TXN.rcv_online_request in delete rows for group_id:'
445: || inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id,4);
446: END IF;
447:
448: delete from rcv_transactions_interface
449: where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
450:
451: /* Bug# 6081470
452: * Added code to also delete the rcv_headers_interface records as the

Line 453: * corresponding rcv_transactions_interface records are being deleted above.

449: where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;
450:
451: /* Bug# 6081470
452: * Added code to also delete the rcv_headers_interface records as the
453: * corresponding rcv_transactions_interface records are being deleted above.
454: * Hence this becomes an orphan RHI record and there is no use of this record.
455: */
456: delete from rcv_headers_interface
457: where group_id = inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id;