APPS.GML_REPROCESS_RCPTS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 11: | RCV_TRANSACTIONS_INTERFACE to PENDING and the |

7: | PROCEDURE NAME update_records |
8: | |
9: | DESCRIPTION Procedure to Update the PROCESSING_STATUS_CODE and |
10: | TRANSACTION_STATUS_CODE in RCV_HEADERS_INTERFACE and |
11: | RCV_TRANSACTIONS_INTERFACE to PENDING and the |
12: | VALIDATION_FLAG in both tables to 'Y' so that the |
13: | receiving transaction processor will pick these |
14: | records up next time its run |
15: | |

Line 28: | status is 'PRINT' in rcv_headers_interface and rcv_transactions_interface.

24: | NULL header_interface_id are also processed.
25: | 24-JUL-02 Lakshmi Swamy B2462033. Included delete statements to po_interface_errors
26: | so that multiple error messages for the same interface id are avoided.
27: | 12-AUG-02 Uday Phadtare B2470051. Update the status to 'PENDING' even if the
28: | status is 'PRINT' in rcv_headers_interface and rcv_transactions_interface.
29: | 29-OCT-02 Uday Phadtare B2647879. Do not update the status to 'PENDING'
30: | in rcv_headers_interface if the status is 'SUCCESS'.
31: =========================================================================*/
32:

Line 40: FROM rcv_headers_interface h, rcv_transactions_interface d

36: CURSOR Cr_get_rcpts IS
37: SELECT h.header_interface_id hid,
38: h.processing_status_code psc,
39: d.interface_transaction_id tid
40: FROM rcv_headers_interface h, rcv_transactions_interface d
41: WHERE h.header_interface_id(+) = d.header_interface_id
42: AND ( h.processing_Status_code IN('ERROR','PRINT') OR d.processing_Status_code IN('ERROR','PRINT')
43: OR d.transaction_status_code IN('ERROR','PRINT') )
44: AND d.comments LIKE 'OPM%';

Line 68: Update RCV_TRANSACTIONS_INTERFACE RT

64: END IF;
65:
66:
67:
68: Update RCV_TRANSACTIONS_INTERFACE RT
69: Set PROCESSING_STATUS_CODE = 'PENDING',
70: TRANSACTION_STATUS_CODE = 'PENDING',
71: VALIDATION_FLAG = 'Y',
72: PO_REVISION_NUM = (select revision_num from po_headers_all where

Line 94: | RCV_TRANSACTIONS_INTERFACE to PENDING and the |

90: | PROCEDURE NAME reprocess_adjust_errors |
91: | |
92: | DESCRIPTION Procedure to Update the PROCESSING_STATUS_CODE and |
93: | TRANSACTION_STATUS_CODE in RCV_HEADERS_INTERFACE and |
94: | RCV_TRANSACTIONS_INTERFACE to PENDING and the |
95: | VALIDATION_FLAG in both tables to 'Y' so that the |
96: | receiving transaction processor will pick these |
97: | records up next time its run |
98: | |