DBA Data[Home] [Help]

APPS.WF_AGENT_GROUPS_PKG dependencies on WF_AGENT_GROUPS_PKG

Line 1: package body WF_AGENT_GROUPS_PKG as

1: package body WF_AGENT_GROUPS_PKG as
2: /* $Header: WFEVAGPB.pls 120.3 2005/11/10 01:40:49 mputhiya ship $ */
3: m_table_name varchar2(255) := 'WF_AGENT_GROUPS';
4: m_package_version varchar2(30) := '1.0';
5: -----------------------------------------------------------------------------

Line 36: wf_core.context('Wf_Agent_Groups_Pkg', 'Insert_Row', x_group_guid, x_member_guid);

32: close c;
33:
34: exception
35: when others then
36: wf_core.context('Wf_Agent_Groups_Pkg', 'Insert_Row', x_group_guid, x_member_guid);
37: raise;
38:
39: end INSERT_ROW;
40: -----------------------------------------------------------------------------

Line 60: wf_core.context('Wf_Agent_Groups_Pkg', 'Update_Row', x_group_guid,

56: end if;
57:
58: exception
59: when others then
60: wf_core.context('Wf_Agent_Groups_Pkg', 'Update_Row', x_group_guid,
61: x_member_guid);
62: raise;
63: end UPDATE_ROW;
64: -----------------------------------------------------------------------------

Line 71: WF_AGENT_GROUPS_PKG.UPDATE_ROW (

67: X_MEMBER_GUID in raw
68: ) is
69: row_id varchar2(64);
70: begin
71: WF_AGENT_GROUPS_PKG.UPDATE_ROW (
72: X_GROUP_GUID => X_GROUP_GUID,
73: X_MEMBER_GUID => X_MEMBER_GUID
74: );
75:

Line 78: WF_AGENT_GROUPS_PKG.INSERT_ROW(

74: );
75:
76: exception
77: when no_data_found then
78: WF_AGENT_GROUPS_PKG.INSERT_ROW(
79: X_ROWID => row_id,
80: X_GROUP_GUID => X_GROUP_GUID,
81: X_MEMBER_GUID => X_MEMBER_GUID
82: );

Line 84: wf_core.context('Wf_Agent_Groups_Pkg', 'Load_Row', x_group_guid,

80: X_GROUP_GUID => X_GROUP_GUID,
81: X_MEMBER_GUID => X_MEMBER_GUID
82: );
83: when others then
84: wf_core.context('Wf_Agent_Groups_Pkg', 'Load_Row', x_group_guid,
85: x_member_guid);
86: raise;
87: end LOAD_ROW;
88: -----------------------------------------------------------------------------

Line 107: wf_core.context('Wf_Agent_Groups_Pkg', 'Delete_Row', x_group_guid,

103: end if;
104:
105: exception
106: when others then
107: wf_core.context('Wf_Agent_Groups_Pkg', 'Delete_Row', x_group_guid,
108: x_member_guid);
109: raise;
110:
111: end DELETE_ROW;

Line 148: wf_core.context('Wf_Agent_Groups_Pkg', 'Generate', x_group_guid,

144:
145: null;
146: exception
147: when others then
148: wf_core.context('Wf_Agent_Groups_Pkg', 'Generate', x_group_guid,
149: x_member_guid);
150: raise;
151: end GENERATE;
152: -----------------------------------------------------------------------------

Line 188: wf_core.context('Wf_Agent_Groups_Pkg', 'Generate1', x_group_guid,

184:
185: null;
186: exception
187: when others then
188: wf_core.context('Wf_Agent_Groups_Pkg', 'Generate1', x_group_guid,
189: x_member_guid);
190: raise;
191: end GENERATE1;
192: -----------------------------------------------------------------------------

Line 251: wf_agent_groups_pkg.load_row(

247: Wf_Core.Raise('WFSQL_INTERNAL');
248: end if;
249: end loop;
250:
251: wf_agent_groups_pkg.load_row(
252: X_GROUP_GUID => l_group_guid,
253: X_MEMBER_GUID => l_member_guid
254: );
255:

Line 258: wf_core.context('Wf_Agent_Groups_Pkg', 'Receive', x_message);

254: );
255:
256: exception
257: when others then
258: wf_core.context('Wf_Agent_Groups_Pkg', 'Receive', x_message);
259: raise;
260: end RECEIVE;
261: -----------------------------------------------------------------------------
262:

Line 263: end WF_AGENT_GROUPS_PKG;

259: raise;
260: end RECEIVE;
261: -----------------------------------------------------------------------------
262:
263: end WF_AGENT_GROUPS_PKG;