APPS.JTF_USR_HKS dependencies on JTF_MESSAGE

Line 323: JTF_Message.Queue_Message(

319: p_msg_XML clob ) is
320:
321: PRAGMA AUTONOMOUS_TRANSACTION;
322: Begin
323: JTF_Message.Queue_Message(
324: p_prod_code => p_prod_code,
325: p_bus_obj_code => p_bus_obj_code,
326: p_bus_obj_name => p_bus_obj_name,
327: p_correlation => p_correlation,

Line 357: from JTF_MESSAGE_OBJECTS

353:
354: Begin
355: select bus_obj_sql, nvl(msg_mode,1) , bus_obj_name
356: into l_msg_SQL, l_msg_mode, l_bus_obj_name
357: from JTF_MESSAGE_OBJECTS
358: where
359: PRODUCT_CODE = p_prod_code and
360: BUS_OBJ_CODE = p_bus_obj_code and
361: ACTION_CODE = p_action_code and

Line 443: from JTF_MESSAGE_OBJECTS

439:
440: Begin
441: select bus_obj_sql ,nvl(msg_mode,1) , bus_obj_name
442: into l_msg_SQL, l_msg_mode, l_bus_obj_name
443: from JTF_MESSAGE_OBJECTS
444: where
445: PRODUCT_CODE = p_prod_code and
446: BUS_OBJ_CODE = p_bus_obj_code and
447: ACTION_CODE = p_action_code and

Line 516: from JTF_MESSAGE_OBJECTS

512:
513: Begin
514: select bus_obj_sql ,nvl(msg_mode,1) , bus_obj_name
515: into l_msg_SQL, l_msg_mode, l_bus_obj_name
516: from JTF_MESSAGE_OBJECTS
517: where
518: PRODUCT_CODE = p_prod_code and
519: BUS_OBJ_CODE = p_bus_obj_code and
520: ACTION_CODE = p_action_code and

Line 639: JTF_Message.Queue_Message( p_prod_code => p_prod_code,

635: end if;
636:
637: if ( ( p_msg_type = 'P') OR ( p_timeout = 0 ) ) then
638:
639: JTF_Message.Queue_Message( p_prod_code => p_prod_code,
640: p_bus_obj_code => p_bus_obj_code,
641: p_bus_obj_name => p_bus_obj_name,
642: p_correlation => p_correlation,
643: p_message => p_message );

Line 879: from JTF_MESSAGE_OBJECTS

875:
876: Begin
877: select bus_obj_sql, nvl(msg_mode,1), bus_obj_name
878: into l_msg_SQL, l_msg_mode, l_bus_obj_name
879: from JTF_MESSAGE_OBJECTS
880: where
881: PRODUCT_CODE = p_prod_code and
882: BUS_OBJ_CODE = p_bus_obj_code and
883: ACTION_CODE = p_action_code and

Line 984: /* JTF_Message.Queue_Message routine enqueues the message in message queue */

980: */
981:
982: -- dbms_output.put_line(' before queue message');
983:
984: /* JTF_Message.Queue_Message routine enqueues the message in message queue */
985:
986: if ( p_timeout = 0 ) then
987:
988: JTF_Message.Queue_Message( p_prod_code => p_prod_code,

Line 988: JTF_Message.Queue_Message( p_prod_code => p_prod_code,

984: /* JTF_Message.Queue_Message routine enqueues the message in message queue */
985:
986: if ( p_timeout = 0 ) then
987:
988: JTF_Message.Queue_Message( p_prod_code => p_prod_code,
989: p_bus_obj_code => p_bus_obj_code,
990: p_bus_obj_name => p_bus_obj_name,
991: p_correlation => p_correlation,
992: p_message => l_msg_XML );