DBA Data[Home] [Help]

APPS.OE_ERROR_WF dependencies on OE_TRANSACTION_TYPES_TL

Line 97: FROM OE_TRANSACTION_TYPES_TL T

93: where header_id = err_itemkey;
94:
95: SELECT T.NAME
96: INTO l_order_type_name
97: FROM OE_TRANSACTION_TYPES_TL T
98: WHERE T.LANGUAGE = userenv('LANG')
99: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
100:
101: SELECT name

Line 495: FROM OE_TRANSACTION_TYPES_TL T

491: where header_id = err_itemkey;
492:
493: SELECT T.NAME
494: INTO l_order_type_name
495: FROM OE_TRANSACTION_TYPES_TL T
496: WHERE T.LANGUAGE = userenv('LANG')
497: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
498:
499: SELECT name

Line 598: FROM OE_TRANSACTION_TYPES_TL T

594: where header_id = l_header_id;
595:
596: SELECT T.NAME
597: INTO l_order_type_name
598: FROM OE_TRANSACTION_TYPES_TL T
599: WHERE T.LANGUAGE = userenv('LANG')
600: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
601:
602: SELECT name

Line 746: FROM OE_TRANSACTION_TYPES_TL T

742:
743: BEGIN
744: SELECT T.NAME
745: INTO l_order_type_name
746: FROM OE_TRANSACTION_TYPES_TL T
747: WHERE T.LANGUAGE = userenv('LANG')
748: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
749: EXCEPTION WHEN OTHERS THEN
750: l_order_type_name := NULL;