DBA Data[Home] [Help]

APPS.INV_PP_DEBUG dependencies on DBMS_PIPE

Line 66: dbms_pipe.pack_message(p_message||g_line_feed);

62: RETURN;
63: END IF;
64: -- bug # 3133781
65: /*
66: dbms_pipe.pack_message(p_message||g_line_feed);
67: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);
68: dbms_pipe.pack_message('.'); -- message ending symbol
69: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);
70: */

Line 67: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);

63: END IF;
64: -- bug # 3133781
65: /*
66: dbms_pipe.pack_message(p_message||g_line_feed);
67: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);
68: dbms_pipe.pack_message('.'); -- message ending symbol
69: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);
70: */
71: RETURN;

Line 68: dbms_pipe.pack_message('.'); -- message ending symbol

64: -- bug # 3133781
65: /*
66: dbms_pipe.pack_message(p_message||g_line_feed);
67: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);
68: dbms_pipe.pack_message('.'); -- message ending symbol
69: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);
70: */
71: RETURN;
72: END send_message_to_pipe;

Line 69: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);

65: /*
66: dbms_pipe.pack_message(p_message||g_line_feed);
67: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);
68: dbms_pipe.pack_message('.'); -- message ending symbol
69: l_rval := dbms_pipe.send_message(g_pipename, 120, 10000000);
70: */
71: RETURN;
72: END send_message_to_pipe;
73: --

Line 137: l_rval := dbms_pipe.receive_message(p_pipename, 30);

133: , x_message OUT NOCOPY VARCHAR2
134: ) RETURN NUMBER IS
135: l_rval NUMBER := NULL;
136: BEGIN
137: l_rval := dbms_pipe.receive_message(p_pipename, 30);
138: IF l_rval = 0 THEN
139: dbms_pipe.unpack_message(x_message);
140: ELSE
141: x_message := NULL;

Line 139: dbms_pipe.unpack_message(x_message);

135: l_rval NUMBER := NULL;
136: BEGIN
137: l_rval := dbms_pipe.receive_message(p_pipename, 30);
138: IF l_rval = 0 THEN
139: dbms_pipe.unpack_message(x_message);
140: ELSE
141: x_message := NULL;
142: END IF;
143: --dbms_output.put_line('l_rval '|| l_rval);