[Home] [Help]
9: -- Liang Xia 01/10/2002 fix bug that if the number of rules for a classification is less than
10: -- that of classification with higher priority, this classification
11: -- is never satisfied. ( No bug logged, shipped with FP-M )
12: -- Liang Xia 06/05/2002 Added Dynamic Route function
13: -- Liang Xia 08/06/2002 Changed jtf_rs_roles_vl to jtf_rs_roles_b, jtf_rs_group_members_vl to jtf_rs_group_members for
14: -- performance issue.
15: -- Liang Xia 11/12/2002 Added All_email tag, which overwrite the rules
16: -- Fixed GSCC warning: NOCOPY, FND_API.G_MISS...
17: -- Liang Xia 11/26/2002 Not to route groups that are expired.
197: 3. At least one resource has the one of the 3 eMC Roles*
198: 4. At least one resource(agent) that has not requeued the message ( added for 11.59
199: and later version. For Tar 4021452.999./bug 3855036 )*/
200: FUNCTION validGroup(
201: groupIdToCheck IN jtf_rs_group_members.group_id%TYPE,
202: emailAccountId IN iem_mstemail_accounts.email_account_id%TYPE,
203: p_message_id IN number)
204: return Boolean is
205:
204: return Boolean is
205:
206: groupOK Boolean := TRUE;
207:
208: resourceId JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE;
209: roleTypeCode JTF_RS_ROLES_B.ROLE_TYPE_CODE%TYPE := 'ICENTER';
210: deleteFlag JTF_RS_ROLE_RELATIONS.DELETE_FLAG%TYPE := 'N';
211: groupUsage JTF_RS_GROUP_USAGES.usage%TYPE :='CALL';
212:
219: resourceId
220: from
221: jtf_rs_roles_b a,
222: jtf_rs_role_relations b,
223: jtf_rs_group_members c,
224: --jtf_rs_resource_values d,
225: iem_agents d,
226: JTF_RS_GROUPS_B e,
227: JTF_RS_RESOURCE_EXTNS f,