eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_REPROCESS_RCPTS dependencies on RCV_HEADERS_INTERFACE

Line 10: | TRANSACTION_STATUS_CODE in RCV_HEADERS_INTERFACE and |

6: | |
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 |

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 30: | in rcv_headers_interface if the status is 'SUCCESS'.

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:
33: PROCEDURE Update_Records(errbufx OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2)
34: IS

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 53: Update RCV_HEADERS_INTERFACE

49: For Cr_get_rcpts_rec in Cr_get_rcpts
50: Loop
51: IF Cr_get_rcpts_rec.hid IS NOT NULL THEN
52: IF Cr_get_rcpts_rec.psc <> 'SUCCESS' THEN
53: Update RCV_HEADERS_INTERFACE
54: Set PROCESSING_STATUS_CODE = 'PENDING',
55: VALIDATION_FLAG = 'Y'
56: Where HEADER_INTERFACE_ID = Cr_get_rcpts_rec.hid;
57: END IF;

Line 93: | TRANSACTION_STATUS_CODE in RCV_HEADERS_INTERFACE and |

89: | |
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 |