DBA Data[Home] [Help]

APPS.XNP_MSG_BUILDER dependencies on XNP_MSG_TYPES_B

Line 12: g_event_indr XNP_MSG_TYPES_B.msg_type%TYPE ;

8: g_mandatory_check BOOLEAN := FALSE ;
9: g_mandatory_list VARCHAR2(4000) ;
10: g_loop_counter NUMBER := 1 ;
11:
12: g_event_indr XNP_MSG_TYPES_B.msg_type%TYPE ;
13: g_dtd_url XNP_MSG_TYPES_B.dtd_url%TYPE ;
14: g_msg_priority XNP_MSG_TYPES_B.priority%TYPE ;
15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;
16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;

Line 13: g_dtd_url XNP_MSG_TYPES_B.dtd_url%TYPE ;

9: g_mandatory_list VARCHAR2(4000) ;
10: g_loop_counter NUMBER := 1 ;
11:
12: g_event_indr XNP_MSG_TYPES_B.msg_type%TYPE ;
13: g_dtd_url XNP_MSG_TYPES_B.dtd_url%TYPE ;
14: g_msg_priority XNP_MSG_TYPES_B.priority%TYPE ;
15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;
16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;
17: g_out_process_logic XNP_MSG_TYPES_B.out_process_logic%TYPE ;

Line 14: g_msg_priority XNP_MSG_TYPES_B.priority%TYPE ;

10: g_loop_counter NUMBER := 1 ;
11:
12: g_event_indr XNP_MSG_TYPES_B.msg_type%TYPE ;
13: g_dtd_url XNP_MSG_TYPES_B.dtd_url%TYPE ;
14: g_msg_priority XNP_MSG_TYPES_B.priority%TYPE ;
15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;
16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;
17: g_out_process_logic XNP_MSG_TYPES_B.out_process_logic%TYPE ;
18: g_dflt_process_logic XNP_MSG_TYPES_B.default_process_logic%TYPE ;

Line 15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;

11:
12: g_event_indr XNP_MSG_TYPES_B.msg_type%TYPE ;
13: g_dtd_url XNP_MSG_TYPES_B.dtd_url%TYPE ;
14: g_msg_priority XNP_MSG_TYPES_B.priority%TYPE ;
15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;
16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;
17: g_out_process_logic XNP_MSG_TYPES_B.out_process_logic%TYPE ;
18: g_dflt_process_logic XNP_MSG_TYPES_B.default_process_logic%TYPE ;
19: g_queue_name XNP_MSG_TYPES_B.queue_name%TYPE ;

Line 16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;

12: g_event_indr XNP_MSG_TYPES_B.msg_type%TYPE ;
13: g_dtd_url XNP_MSG_TYPES_B.dtd_url%TYPE ;
14: g_msg_priority XNP_MSG_TYPES_B.priority%TYPE ;
15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;
16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;
17: g_out_process_logic XNP_MSG_TYPES_B.out_process_logic%TYPE ;
18: g_dflt_process_logic XNP_MSG_TYPES_B.default_process_logic%TYPE ;
19: g_queue_name XNP_MSG_TYPES_B.queue_name%TYPE ;
20: g_temp_tab XDP_TYPES.VARCHAR2_4000_TAB ;

Line 17: g_out_process_logic XNP_MSG_TYPES_B.out_process_logic%TYPE ;

13: g_dtd_url XNP_MSG_TYPES_B.dtd_url%TYPE ;
14: g_msg_priority XNP_MSG_TYPES_B.priority%TYPE ;
15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;
16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;
17: g_out_process_logic XNP_MSG_TYPES_B.out_process_logic%TYPE ;
18: g_dflt_process_logic XNP_MSG_TYPES_B.default_process_logic%TYPE ;
19: g_queue_name XNP_MSG_TYPES_B.queue_name%TYPE ;
20: g_temp_tab XDP_TYPES.VARCHAR2_4000_TAB ;
21:

Line 18: g_dflt_process_logic XNP_MSG_TYPES_B.default_process_logic%TYPE ;

14: g_msg_priority XNP_MSG_TYPES_B.priority%TYPE ;
15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;
16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;
17: g_out_process_logic XNP_MSG_TYPES_B.out_process_logic%TYPE ;
18: g_dflt_process_logic XNP_MSG_TYPES_B.default_process_logic%TYPE ;
19: g_queue_name XNP_MSG_TYPES_B.queue_name%TYPE ;
20: g_temp_tab XDP_TYPES.VARCHAR2_4000_TAB ;
21:
22: CURSOR get_msg_type_data IS

Line 19: g_queue_name XNP_MSG_TYPES_B.queue_name%TYPE ;

15: g_validate_logic XNP_MSG_TYPES_B.validate_logic%TYPE ;
16: g_process_logic XNP_MSG_TYPES_B.in_process_logic%TYPE ;
17: g_out_process_logic XNP_MSG_TYPES_B.out_process_logic%TYPE ;
18: g_dflt_process_logic XNP_MSG_TYPES_B.default_process_logic%TYPE ;
19: g_queue_name XNP_MSG_TYPES_B.queue_name%TYPE ;
20: g_temp_tab XDP_TYPES.VARCHAR2_4000_TAB ;
21:
22: CURSOR get_msg_type_data IS
23: SELECT msg_type,

Line 31: FROM XNP_MSG_TYPES_B

27: default_process_logic,
28: validate_logic,
29: queue_name,
30: dtd_url
31: FROM XNP_MSG_TYPES_B
32: WHERE msg_code = g_message_code ;
33:
34: CURSOR get_compilation_errors ( l_proc_name VARCHAR2 )IS
35: SELECT text FROM user_errors

Line 805: SELECT 'X' FROM xnp_msg_types_b

801: l_sysdate DATE ;
802: l_flag VARCHAR2(1);
803:
804: CURSOR update_msg_type IS
805: SELECT 'X' FROM xnp_msg_types_b
806: WHERE msg_code = p_msg_code
807: FOR UPDATE OF status , last_compiled_date;
808:
809: BEGIN

Line 817: FROM xnp_msg_types_b

813:
814: /** VBhatia -- 05/02/2002 **/
815: SELECT protected_flag
816: INTO l_flag
817: FROM xnp_msg_types_b
818: WHERE msg_code = p_msg_code;
819:
820: IF l_flag <> 'Y' THEN /** -- end -- **/
821:

Line 860: UPDATE xnp_msg_types_b

856:
857: IF ( x_error_code = 0 ) THEN
858: FOR cur_rec IN update_msg_type LOOP
859:
860: UPDATE xnp_msg_types_b
861: SET status='COMPILED',
862: last_compiled_date = l_sysdate
863: WHERE CURRENT OF update_msg_type ;
864:

Line 2537: FROM xnp_msg_types_b

2533: l_msg_type VARCHAR2(10) ;
2534:
2535: CURSOR get_msg_type IS
2536: SELECT msg_type
2537: FROM xnp_msg_types_b
2538: WHERE msg_code = g_message_code ;
2539:
2540: CURSOR get_children ( parent_name IN VARCHAR2 ) IS
2541: SELECT MET.name,