APPS.OE_ERROR_WF dependencies on OE_PROCESSING_MSGS_TL

Line 1560: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl

1556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1557:
1558: CURSOR l_msg_cursor_1 IS
1559: SELECT tl.message_text
1560: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl
1561: WHERE msg.transaction_id = tl.transaction_id
1562: AND msg.header_id = to_number(p_item_key)
1563: AND nvl(msg.message_status_code, l_open) <> l_closed
1564: AND tl.language = USERENV('LANG')

Line 1570: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl

1566:
1567:
1568: CURSOR l_msg_cursor_2 IS
1569: SELECT tl.message_text
1570: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl
1571: WHERE msg.transaction_id = tl.transaction_id
1572: AND msg.header_id = p_header_id
1573: AND msg.line_id = to_number (p_item_key)
1574: AND nvl(msg.message_status_code, l_open) <> l_closed

Line 1580: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl

1576: ORDER BY msg.transaction_id;
1577:
1578: CURSOR l_msg_cursor_3 IS
1579: SELECT tl.message_text
1580: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl
1581: WHERE msg.transaction_id = tl.transaction_id
1582: AND msg.entity_id = to_number(p_item_key)
1583: AND msg.entity_code = l_entity_code
1584: AND nvl(msg.message_status_code, l_open) <> l_closed

Line 1590: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl

1586: ORDER BY msg.transaction_id;
1587:
1588: CURSOR l_msg_cursor_4 IS
1589: SELECT tl.message_text
1590: FROM oe_processing_msgs msg, oe_processing_msgs_tl tl
1591: WHERE msg.transaction_id = tl.transaction_id
1592: AND msg.entity_id = to_number(p_item_key)
1593: AND msg.entity_code = l_entity_code
1594: AND msg.order_source_id = p_order_source_id