APPS.OKC_CA_UTIL_PVT dependencies on OE_TRANSACTION_TYPES_TL

Line 5: return oe_transaction_types_tl.name%type

1: package body okc_ca_util_pvt as
2: /* $Header: OKCCAUTLB.pls 120.7 2006/04/26 15:53 muteshev noship $ */
3:
4: function bsa_subtype( p_order_number in number)
5: return oe_transaction_types_tl.name%type
6: as
7: result oe_transaction_types_tl.name%type;
8: begin
9: select t.name into result

Line 7: result oe_transaction_types_tl.name%type;

3:
4: function bsa_subtype( p_order_number in number)
5: return oe_transaction_types_tl.name%type
6: as
7: result oe_transaction_types_tl.name%type;
8: begin
9: select t.name into result
10: from
11: oe_blanket_headers_all h,

Line 13: oe_transaction_types_tl t

9: select t.name into result
10: from
11: oe_blanket_headers_all h,
12: oe_transaction_types_all a,
13: oe_transaction_types_tl t
14: where t.transaction_type_id = h.order_type_id
15: and a.transaction_type_id = t.transaction_type_id
16: and t.language = USERENV('LANG')
17: and a.sales_document_type_code = 'B'

Line 24: return oe_transaction_types_tl.name%type

20: exception when others then return null;
21: end;
22:
23: function so_subtype( p_order_number in number)
24: return oe_transaction_types_tl.name%type
25: as
26: result oe_transaction_types_tl.name%type;
27: begin
28: select t.name into result

Line 26: result oe_transaction_types_tl.name%type;

22:
23: function so_subtype( p_order_number in number)
24: return oe_transaction_types_tl.name%type
25: as
26: result oe_transaction_types_tl.name%type;
27: begin
28: select t.name into result
29: from
30: oe_order_headers_all h,

Line 32: oe_transaction_types_tl t

28: select t.name into result
29: from
30: oe_order_headers_all h,
31: oe_transaction_types_all a,
32: oe_transaction_types_tl t
33: where t.transaction_type_id = h.order_type_id
34: and a.transaction_type_id = t.transaction_type_id
35: and t.language = USERENV('LANG')
36: and a.sales_document_type_code = 'O'