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: -----------------------------------------------------------------------------
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: -----------------------------------------------------------------------------
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: -----------------------------------------------------------------------------
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,
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,
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,
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,
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: -----------------------------------------------------------------------------
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 (
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 (
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,
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;
454: wf_core.context('Wf_Agents_Pkg', 'Receive', x_message);
455: raise;
456: end RECEIVE;
457: -------------------------------------------------------------------------
458: end WF_AGENTS_PKG;