APPS.OE_MESSAGE_PURGE_PVT dependencies on OE_PROCESSING_MSGS

Line 47: FROM oe_processing_msgs m, oe_order_headers_all o

43: o.order_number,
44: o.order_type_id,
45: o.sold_to_org_id,
46: m.message_status_code
47: FROM oe_processing_msgs m, oe_order_headers_all o
48: WHERE m.header_id = o.header_id (+)
49: AND NVL(m.message_source_code, 'NULL') =
50: NVL(p_message_source, NVL(m.message_source_code, 'NULL'))
51: AND TRUNC(m.creation_date) BETWEEN NVL(l_start, TRUNC(m.creation_date))

Line 122: DELETE oe_processing_msgs_tl

118: IF l_cnt >= l_commit THEN
119: COMMIT;
120: l_cnt := 0;
121: END IF;
122: DELETE oe_processing_msgs_tl
123: WHERE transaction_id = c_msg.transaction_id;
124: DELETE oe_processing_msgs
125: WHERE ROWID = c_msg.rowid;
126: l_cnt := l_cnt + 1;

Line 124: DELETE oe_processing_msgs

120: l_cnt := 0;
121: END IF;
122: DELETE oe_processing_msgs_tl
123: WHERE transaction_id = c_msg.transaction_id;
124: DELETE oe_processing_msgs
125: WHERE ROWID = c_msg.rowid;
126: l_cnt := l_cnt + 1;
127: END IF;
128: END LOOP;