APPS.OE_MSG_PUB dependencies on OE_PROCESSING_MSGS_TL

Line 1359: INSERT INTO OE_PROCESSING_MSGS_TL

1355: );
1356:
1357: BEGIN
1358:
1359: INSERT INTO OE_PROCESSING_MSGS_TL
1360: (Transaction_id
1361: ,language
1362: ,source_lang
1363: ,message_text

Line 1385: FROM oe_processing_msgs_tl t

1381: WHERE l.installed_flag in ('I','B')
1382: AND language_code = USERENV('LANG')
1383: AND not exists
1384: (SELECT null
1385: FROM oe_processing_msgs_tl t
1386: WHERE t.transaction_id = l_transaction_id
1387: AND t.language = l.language_code);
1388:
1389: END;

Line 1699: -- from the caller and deletes data from OE_PROCESSING_MSGS_TL

1695: -- Usage Used by process message form to delete queried
1696: -- messages.
1697: --
1698: -- Desc This procedure accepts where clause parameters
1699: -- from the caller and deletes data from OE_PROCESSING_MSGS_TL
1700: -- and OE_PROCESSING_MSGS.
1701: --
1702:
1703: PROCEDURE DELETE_MESSAGE

Line 1966: from oe_processing_msgs_tl

1962: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
1963:
1964: FORALL J in 1..Transactionids.COUNT
1965: Delete
1966: from oe_processing_msgs_tl
1967: Where transaction_id = Transactionids(J);
1968:
1969: FORALL J in 1..Transactionids.COUNT
1970: Delete

Line 2065: from oe_processing_msgs_tl

2061:
2062: Replaced with the following to fix 1922443
2063: FORALL J in 1..Transactions_oi.COUNT
2064: Delete
2065: from oe_processing_msgs_tl
2066: Where transaction_id = Transactions_oi(J);
2067:
2068:
2069: FORALL J in 1..Transactions_oi.COUNT

Line 2079: from oe_processing_msgs_tl

2075:
2076:
2077: FORALL J in 1..Transactionids.COUNT
2078: Delete
2079: from oe_processing_msgs_tl
2080: Where transaction_id = Transactionids(J);
2081:
2082:
2083: FORALL J in 1..Transactionrowids.COUNT

Line 2208: from oe_processing_msgs_tl

2204: oe_debug_pub.add('Count: ' || Transactionids.COUNT,1);
2205:
2206: FORALL J in 1..Transactionids.COUNT
2207: Delete
2208: from oe_processing_msgs_tl
2209: Where transaction_id = Transactionids(J);
2210:
2211: FORALL J in 1..Transactionids.COUNT
2212: Delete