eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASG_NOTIFY dependencies on V$SESSION

Line 61: -- SELECT ' '||MACHINE|| ' ' ||PROGRAM||' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;

57: v_user varchar2(20);
58: --v_ses_info varchar2 (200);
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

Line 62: -- SELECT MACHINE|| ' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;

58: --v_ses_info varchar2 (200);
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

Line 81: -- SELECT MACHINE|| ' ' ||PROGRAM||' ' INTO V_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;

77: v_user varchar2(20);
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

Line 91: SELECT ' '||MACHINE|| ' ' ||PROGRAM||' ' INTO m_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;

87: null;
88: end STOP;
89:
90: begin
91: SELECT ' '||MACHINE|| ' ' ||PROGRAM||' ' INTO m_SES_INFO FROM V$SESSION WHERE AUDSID = USERENV('SESSIONID') and rownum = 1;
92:
93: END ASG_NOTIFY;