APPS.ASG_NOTIFY dependencies on DBMS_PIPE

Line 28: V_STATUS := DBMS_PIPE.RECEIVE_MESSAGE ('MIDDLE_TIER_MTS_CONTROL');

24: ret integer;
25: text varchar2(32000);
26: begin
27: ret := 0; /* assume ok */
28: V_STATUS := DBMS_PIPE.RECEIVE_MESSAGE ('MIDDLE_TIER_MTS_CONTROL');
29: if (V_STATUS = 0 ) then
30: DBMS_PIPE.UNPACK_MESSAGE (text);
31: else
32: ret := v_status;

Line 30: DBMS_PIPE.UNPACK_MESSAGE (text);

26: begin
27: ret := 0; /* assume ok */
28: V_STATUS := DBMS_PIPE.RECEIVE_MESSAGE ('MIDDLE_TIER_MTS_CONTROL');
29: if (V_STATUS = 0 ) then
30: DBMS_PIPE.UNPACK_MESSAGE (text);
31: else
32: ret := v_status;
33: end if;
34: return text;

Line 63: DBMS_PIPE.PACK_MESSAGE (to_char (sysdate,'MMDD HH24:MI.SS')||' '||user||' '||m_SES_INFO||' '||location||' ' || text);

59:
60: begin
61: -- SELECT ' '||MACHINE|| ' ' ||PROGRAM||' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;
62: -- SELECT MACHINE|| ' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;
63: DBMS_PIPE.PACK_MESSAGE (to_char (sysdate,'MMDD HH24:MI.SS')||' '||user||' '||m_SES_INFO||' '||location||' ' || text);
64: V_STATUS:=DBMS_PIPE.send_message ('MIDDLE_TIER_MTS_CONTROL',1);
65: exception
66: when others then
67: /* This package is a debuging package therefore it should not raise any execptions */

Line 64: V_STATUS:=DBMS_PIPE.send_message ('MIDDLE_TIER_MTS_CONTROL',1);

60: begin
61: -- SELECT ' '||MACHINE|| ' ' ||PROGRAM||' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;
62: -- SELECT MACHINE|| ' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;
63: DBMS_PIPE.PACK_MESSAGE (to_char (sysdate,'MMDD HH24:MI.SS')||' '||user||' '||m_SES_INFO||' '||location||' ' || text);
64: V_STATUS:=DBMS_PIPE.send_message ('MIDDLE_TIER_MTS_CONTROL',1);
65: exception
66: when others then
67: /* This package is a debuging package therefore it should not raise any execptions */
68: null;

Line 82: DBMS_PIPE.PACK_MESSAGE ('STOP '||to_char (sysdate,'MMDD HH24:MI.SS')||' '||user||' '||m_SES_INFO);

78: v_ses_info varchar2 (80);
79:
80: begin
81: -- SELECT MACHINE|| ' ' ||PROGRAM||' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;
82: DBMS_PIPE.PACK_MESSAGE ('STOP '||to_char (sysdate,'MMDD HH24:MI.SS')||' '||user||' '||m_SES_INFO);
83: V_STATUS:=DBMS_PIPE.send_message ('MIDDLE_TIER_MTS_CONTROL',1);
84: exception
85: when others then
86: /* This package is a debuging package therefore it should not raise any execptions */

Line 83: V_STATUS:=DBMS_PIPE.send_message ('MIDDLE_TIER_MTS_CONTROL',1);

79:
80: begin
81: -- SELECT MACHINE|| ' ' ||PROGRAM||' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;
82: DBMS_PIPE.PACK_MESSAGE ('STOP '||to_char (sysdate,'MMDD HH24:MI.SS')||' '||user||' '||m_SES_INFO);
83: V_STATUS:=DBMS_PIPE.send_message ('MIDDLE_TIER_MTS_CONTROL',1);
84: exception
85: when others then
86: /* This package is a debuging package therefore it should not raise any execptions */
87: null;