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.XNP_SV_ORDERS$SOA_EVENTS dependencies on XNP_SV_ORDERS$

Line 1: package body xnp_sv_orders$soa_events as

1: package body xnp_sv_orders$soa_events as
2: /* $Header: XNPSVO3B.pls 120.0 2005/05/30 11:51:51 appldev noship $ */
3:
4:
5: function BuildSQL(

Line 57: -- Name: xnp_sv_orders$soa_events.InitialiseDomain

53: ZONE_SQL VARCHAR2(1100) := null;
54:
55: D_EVENT_TYPE XNP_WSGL.typDVRecord;
56: --------------------------------------------------------------------------------
57: -- Name: xnp_sv_orders$soa_events.InitialiseDomain
58: --
59: -- Description: Initialises the Domain Record for the given Column Usage
60: --
61: -- Parameters: P_ALIAS The alias of the column usage

Line 82: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.InitialseDomain');

78:
79: exception
80: when others then
81: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
82: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.InitialseDomain');
83: end;
84:
85: --------------------------------------------------------------------------------
86: -- Name: xnp_sv_orders$soa_events.Startup

Line 86: -- Name: xnp_sv_orders$soa_events.Startup

82: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.InitialseDomain');
83: end;
84:
85: --------------------------------------------------------------------------------
86: -- Name: xnp_sv_orders$soa_events.Startup
87: --
88: -- Description: Entry point for the 'SOA_EVENTS' module
89: -- component (Event History).
90: --

Line 100: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.startup');

96: Z_DIRECT_CALL in boolean,
97: Z_CHK in varchar2) is
98: begin
99:
100: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.startup');
101: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
102: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
103:
104: if not Z_DIRECT_CALL then

Line 121: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.Startup');

117:
118: exception
119: when others then
120: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
121: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.Startup');
122: end;
123:
124: --------------------------------------------------------------------------------
125: -- Name: xnp_sv_orders$soa_events.QueryHits

Line 125: -- Name: xnp_sv_orders$soa_events.QueryHits

121: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.Startup');
122: end;
123:
124: --------------------------------------------------------------------------------
125: -- Name: xnp_sv_orders$soa_events.QueryHits
126: --
127: -- Description: Returns the number or rows which matches the given search
128: -- criteria (if any).
129: --

Line 174: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.QueryHits');

170:
171: exception
172: when others then
173: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
174: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.QueryHits');
175: return -1;
176: end;--------------------------------------------------------------------------------
177: -- Name: xnp_sv_orders$soa_events.BuildSQL
178: --

Line 177: -- Name: xnp_sv_orders$soa_events.BuildSQL

173: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
174: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.QueryHits');
175: return -1;
176: end;--------------------------------------------------------------------------------
177: -- Name: xnp_sv_orders$soa_events.BuildSQL
178: --
179: -- Description: Builds the SQL for the 'SOA_EVENTS' module component (Event History).
180: -- This incorporates all query criteria and Foreign key columns.
181: --

Line 219: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.BuildSQL');

215:
216: exception
217: when others then
218: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
219: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.BuildSQL');
220: return false;
221: end;
222:
223:

Line 225: -- Name: xnp_sv_orders$soa_events.QueryList

221: end;
222:
223:
224: --------------------------------------------------------------------------------
225: -- Name: xnp_sv_orders$soa_events.QueryList
226: --
227: -- Description: This procedure builds the Record list for the 'SOA_EVENTS'
228: -- module component (Event History).
229: --

Line 262: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.querylist');

258: L_CHECKSUM varchar2(10);
259:
260: begin
261:
262: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.querylist');
263: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
264: XNP_WSGL.AddURLParam('Z_START', Z_START);
265: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
266: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 276: xnp_sv_orders$.TemplateHeader(TRUE,0);

272: end if;
273:
274: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Event History');
275: CreateListJavaScript;
276: xnp_sv_orders$.TemplateHeader(TRUE,0);
277: XNP_WSGL.ClosePageHead;
278:
279: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
280:

Line 427: htp.formOpen(curl => 'xnp_sv_orders$soa_events.querylist', cattributes => 'NAME="frmZero"');

423: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
424: dbms_sql.close_cursor(I_CURSOR);
425: end if;
426:
427: htp.formOpen(curl => 'xnp_sv_orders$soa_events.querylist', cattributes => 'NAME="frmZero"');
428: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);
429: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
430: htp.p ('