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_AGENT_GROUPS_PKG dependencies on WF_AGENT_GROUPS

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 3: m_table_name varchar2(255) := 'WF_AGENT_GROUPS';

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: -----------------------------------------------------------------------------
6: procedure INSERT_ROW (
7: X_ROWID in out nocopy varchar2,

Line 12: from wf_agent_groups

8: X_GROUP_GUID in raw,
9: X_MEMBER_GUID in raw
10: ) is
11: cursor C is select rowid
12: from wf_agent_groups
13: where group_guid = X_GROUP_GUID
14: and member_guid = X_MEMBER_GUID;
15: begin
16: insert into wf_agent_groups (

Line 16: insert into wf_agent_groups (

12: from wf_agent_groups
13: where group_guid = X_GROUP_GUID
14: and member_guid = X_MEMBER_GUID;
15: begin
16: insert into wf_agent_groups (
17: group_guid,
18: member_guid
19: ) values (
20: X_GROUP_GUID,

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 46: update wf_agent_groups set

42: X_GROUP_GUID in raw,
43: X_MEMBER_GUID in raw
44: ) is
45: begin
46: update wf_agent_groups set
47: group_guid = X_GROUP_GUID,
48: member_guid = X_MEMBER_GUID
49: where group_guid = X_GROUP_GUID
50: and member_guid = X_MEMBER_GUID;

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 97: delete from wf_agent_groups

93: ) is
94: begin
95: wf_event.raise('oracle.apps.wf.agent.group.delete',x_group_guid||'/'||x_member_guid);
96:
97: delete from wf_agent_groups
98: where group_guid = X_GROUP_GUID
99: and member_guid = X_MEMBER_GUID;
100:
101: if (sql%notfound) then

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 127: -- from wf_agent_groups

123:
124: begin
125: -- select DISPLAY_NAME, DESCRIPTION
126: -- into l_display_name, l_description
127: -- from wf_agent_groups
128: -- where group_guid = x_guid
129: -- and member_guid = x_member_guid;
130:
131: l_doc := xmldom.newDOMDocument;

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 167: -- from wf_agent_groups

163:
164: begin
165: -- select DISPLAY_NAME, DESCRIPTION
166: -- into l_display_name, l_description
167: -- from wf_agent_groups
168: -- where group_guid = x_guid
169: -- and member_guid = x_member_guid;
170:
171: l_doc := xmldom.newDOMDocument;

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;