DBA Data[Home] [Help]

APPS.JTF_MESSAGE dependencies on JTF_MSG_OBJ

Line 30: l_message_obj SYSTEM.JTF_MSG_OBJ := SYSTEM.JTF_MSG_OBJ( empty_clob() );

26: p_bus_obj_name varchar2,
27: p_correlation varchar2,
28: p_message CLOB ) as
29:
30: l_message_obj SYSTEM.JTF_MSG_OBJ := SYSTEM.JTF_MSG_OBJ( empty_clob() );
31: l_enqueue_options dbms_aq.enqueue_options_t;
32: l_message_properties dbms_aq.message_properties_t;
33: l_bo_Qname varchar2(55) := 'JTF_DEF_QUEUE';
34: l_msg_id RAW(16);

Line 40: from JTF_MSG_OBJ_ROUTE

36:
37: Begin
38: Begin
39: select queue_name into l_bo_Qname
40: from JTF_MSG_OBJ_ROUTE
41: where
42: PRODUCT_CODE = p_prod_code and
43: BUS_OBJ_CODE = p_bus_obj_code and
44: ACTIVE_FLAG = 'Y' and