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.WF_AGENTS_PKG dependencies on WF_AGENTS

Line 1: package body WF_AGENTS_PKG as

1: package body WF_AGENTS_PKG as
2: /* $Header: WFEVAGTB.pls 120.2 2005/09/02 15:20:58 vshanmug ship $ */
3: m_table_name varchar2(255) := 'WF_AGENTS';
4: m_package_version varchar2(30) := '1.0';
5: -----------------------------------------------------------------------------

Line 3: m_table_name varchar2(255) := 'WF_AGENTS';

1: package body WF_AGENTS_PKG as
2: /* $Header: WFEVAGTB.pls 120.2 2005/09/02 15:20:58 vshanmug ship $ */
3: m_table_name varchar2(255) := 'WF_AGENTS';
4: m_package_version varchar2(30) := '1.0';
5: -----------------------------------------------------------------------------
6: procedure INSERT_ROW (
7: X_ROWID in out nocopy varchar2,

Line 22: cursor C is select rowid from wf_agents where guid = X_GUID;

18: X_DESCRIPTION in varchar2,
19: X_TYPE in varchar2,
20: X_JAVA_QUEUE_HANDLER in varchar2
21: ) is
22: cursor C is select rowid from wf_agents where guid = X_GUID;
23: begin
24: insert into wf_agents (
25: guid,
26: name,

Line 24: insert into wf_agents (

20: X_JAVA_QUEUE_HANDLER in varchar2
21: ) is
22: cursor C is select rowid from wf_agents where guid = X_GUID;
23: begin
24: insert into wf_agents (
25: guid,
26: name,
27: system_guid,
28: protocol,

Line 66: wf_core.context('Wf_Agents_Pkg', 'Insert_Row', x_guid,

62: close c;
63:
64: exception
65: when others then
66: wf_core.context('Wf_Agents_Pkg', 'Insert_Row', x_guid,
67: x_protocol );
68: raise;
69: end INSERT_ROW;
70: -----------------------------------------------------------------------------

Line 88: update wf_agents set

84: X_JAVA_QUEUE_HANDLER in varchar2
85: ) is
86: begin
87: if (x_type is null) then
88: update wf_agents set
89: name = X_NAME,
90: system_guid = X_SYSTEM_GUID,
91: protocol = X_PROTOCOL,
92: address = X_ADDRESS,

Line 102: update wf_agents set

98: description = X_DESCRIPTION,
99: java_queue_handler = X_JAVA_QUEUE_HANDLER
100: where guid = X_GUID;
101: else
102: update wf_agents set
103: name = X_NAME,
104: system_guid = X_SYSTEM_GUID,
105: protocol = X_PROTOCOL,
106: address = X_ADDRESS,

Line 126: wf_core.context('Wf_Agents_Pkg', 'Update_Row', x_guid,

122: end if;
123:
124: exception
125: when others then
126: wf_core.context('Wf_Agents_Pkg', 'Update_Row', x_guid,
127: x_protocol );
128: raise;
129: end UPDATE_ROW;
130: -----------------------------------------------------------------------------

Line 150: WF_AGENTS_PKG.UPDATE_ROW (

146: row_id varchar2(64);
147: begin
148: begin
149: if (x_type is null) then
150: WF_AGENTS_PKG.UPDATE_ROW (
151: X_GUID => X_GUID,
152: X_NAME => X_NAME,
153: X_SYSTEM_GUID => X_SYSTEM_GUID,
154: X_PROTOCOL => X_PROTOCOL,

Line 165: WF_AGENTS_PKG.UPDATE_ROW (

161: X_DESCRIPTION => X_DESCRIPTION,
162: X_JAVA_QUEUE_HANDLER => X_JAVA_QUEUE_HANDLER
163: );
164: else
165: WF_AGENTS_PKG.UPDATE_ROW (
166: X_GUID => X_GUID,
167: X_NAME => X_NAME,
168: X_SYSTEM_GUID => X_SYSTEM_GUID,
169: X_PROTOCOL => X_PROTOCOL,

Line 188: WF_AGENTS_PKG.INSERT_ROW(

184: exception
185: when no_data_found then
186: wf_core.clear;
187: if (x_type is null) then
188: WF_AGENTS_PKG.INSERT_ROW(
189: X_ROWID => row_id,
190: X_GUID => X_GUID,
191: X_NAME => X_NAME,
192: X_SYSTEM_GUID => X_SYSTEM_GUID,

Line 204: WF_AGENTS_PKG.INSERT_ROW(

200: X_DESCRIPTION => X_DESCRIPTION,
201: X_JAVA_QUEUE_HANDLER => X_JAVA_QUEUE_HANDLER
202: );
203: else
204: WF_AGENTS_PKG.INSERT_ROW(
205: X_ROWID => row_id,
206: X_GUID => X_GUID,
207: X_NAME => X_NAME,
208: X_SYSTEM_GUID => X_SYSTEM_GUID,

Line 225: wf_core.context('Wf_Agents_Pkg', 'Load_Row', x_guid,

221: end;
222:
223: exception
224: when others then
225: wf_core.context('Wf_Agents_Pkg', 'Load_Row', x_guid,
226: x_protocol );
227: raise;
228: end LOAD_ROW;
229: -----------------------------------------------------------------------------

Line 236: delete from wf_agents where guid = X_GUID;

232: ) is
233: begin
234: wf_event.raise('oracle.apps.wf.event.agent.delete',x_guid);
235:
236: delete from wf_agents where guid = X_GUID;
237:
238: if (sql%notfound) then
239: raise no_data_found;
240: end if;

Line 246: wf_core.context('Wf_Agents_Pkg', 'Delete_Row', x_guid);

242: -- Invalidate cache
243: wf_bes_cache.SetMetaDataUploaded();
244: exception
245: when others then
246: wf_core.context('Wf_Agents_Pkg', 'Delete_Row', x_guid);
247: raise;
248: end DELETE_ROW;
249: -----------------------------------------------------------------------------
250: function GENERATE (

Line 280: from wf_agents

276: type,java_queue_handler
277: into l_name, l_system_guid, l_protocol, l_address, l_queue_handler,
278: l_queue_name, l_direction, l_status, l_display_name, l_description,
279: l_type,l_javaqhandler
280: from wf_agents
281: where guid = x_guid;
282:
283: l_doc := xmldom.newDOMDocument;
284: l_root := xmldom.makeNode(l_doc);

Line 325: wf_core.context('Wf_Agents_Pkg', 'Generate', x_guid);

321:
322: return buf;
323: exception
324: when others then
325: wf_core.context('Wf_Agents_Pkg', 'Generate', x_guid);
326: raise;
327: end GENERATE;
328: -----------------------------------------------------------------------------
329: procedure RECEIVE (

Line 362: from WF_AGENTS

358: ** A row is considered identical if it has the same agent name.
359: */
360: cursor identical_row is
361: select GUID
362: from WF_AGENTS
363: where NAME = l_name;
364:
365: begin
366:

Line 437: wf_agents_pkg.load_row(

433: else
434: l_guid := hextoraw(l_agent_guid);
435: end if;
436:
437: wf_agents_pkg.load_row(
438: X_GUID => l_guid,
439: X_NAME => l_name,
440: X_SYSTEM_GUID => l_system_guid,
441: X_PROTOCOL => l_protocol,

Line 454: wf_core.context('Wf_Agents_Pkg', 'Receive', x_message);

450: X_JAVA_QUEUE_HANDLER => l_javaqhandler);
451:
452: exception
453: when others then
454: wf_core.context('Wf_Agents_Pkg', 'Receive', x_message);
455: raise;
456: end RECEIVE;
457: -------------------------------------------------------------------------
458: end WF_AGENTS_PKG;

Line 458: end WF_AGENTS_PKG;

454: wf_core.context('Wf_Agents_Pkg', 'Receive', x_message);
455: raise;
456: end RECEIVE;
457: -------------------------------------------------------------------------
458: end WF_AGENTS_PKG;