[Home] [Help]
21: | 11-JUL-01 Uday Phadtare Procedure Update_Records modified as part of
22: | Bug# 1878034 fix.
23: | 02-MAY-02 Uday Phadtare B2350663. Cursor Cr_get_rcpts modified so that records with
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'
57: END IF;
58:
59: /* 2462033 - Included delete */
60:
61: DELETE from po_interface_errors
62: WHERE interface_header_id = Cr_get_rcpts_rec.hid;
63:
64: END IF;
65:
73: po_header_id = rt.po_header_id)
74: Where INTERFACE_TRANSACTION_ID= Cr_get_rcpts_rec.tid;
75:
76: /* 2462033 - Included delete */
77: DELETE from po_interface_errors
78: WHERE INTERFACE_TRANSACTION_ID= Cr_get_rcpts_rec.tid
79: OR INTERFACE_LINE_ID = Cr_get_rcpts_rec.tid ;
80:
81: End Loop;