[Home] [Help]
31: begin
32: begin
33: select WRR.ROLE
34: into owner
35: from WF_ROUTING_RULES WRR
36: where WRR.RULE_ID = RuleOwner.ruleid;
37: exception
38: when no_data_found then
39: Wf_Core.Token('RULE', to_char(ruleid));
717: -- Delete this rule along with any child attributes
718: delete from WF_ROUTING_RULE_ATTRIBUTES
719: where RULE_ID = ruleid;
720:
721: delete from WF_ROUTING_RULES
722: where RULE_ID = ruleid;
723:
724: -- Return to opening page
725: Wf_Route.List(user, '--EDITSCREEN--');
786: -- Delete this rule along with any child attributes
787: delete from WF_ROUTING_RULE_ATTRIBUTES
788: where RULE_ID = nruleid;
789:
790: delete from WF_ROUTING_RULES
791: where RULE_ID = nruleid;
792: */
793: -- Cancel the operation and return to opening page
794: raise CANCEL_RECORD;
813: wf_core.raise('WFRTG_BAD_DATE_RANGE');
814: end if;
815:
816: -- Update columns in main table
817: update WF_ROUTING_RULES WRR set
818: ACTION = l_action,
819: ACTION_ARGUMENT = SubmitUpdate.forwardee,
820: BEGIN_DATE = SubmitUpdate.begdate,
821: END_DATE = SubmitUpdate.enddate,
893: WRR.ACTION_ARGUMENT,
894: WRR.RULE_COMMENT,
895: WIT.DISPLAY_NAME TYPE_DISPLAY,
896: WM.SUBJECT
897: from WF_ROUTING_RULES WRR, WF_ITEM_TYPES_VL WIT, WF_MESSAGES_VL WM,
898: WF_LOOKUPS WL
899: where WRR.RULE_ID = nruleid
900: and WRR.MESSAGE_TYPE = WIT.NAME (+)
901: and WRR.MESSAGE_TYPE = WM.TYPE (+)
922: decode(WMA.VALUE_TYPE, 'ITEMATTR', WIA.DATE_DEFAULT,
923: WMA.DATE_DEFAULT) DATE_VALUE,
924: WMA.TYPE,
925: WMA.FORMAT
926: from WF_ROUTING_RULES WRR,
927: WF_MESSAGE_ATTRIBUTES_VL WMA,
928: WF_ITEM_ATTRIBUTES WIA
929: where WRR.RULE_ID = nruleid
930: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1157: -- htp.formHidden('fmode', 'FORWARD');
1158:
1159: select MESSAGE_TYPE, MESSAGE_NAME
1160: into msg_type, msg_name
1161: from WF_ROUTING_RULES
1162: where RULE_ID = ruleid;
1163:
1164: -- Not a valid option when msg_type or msg_name is null
1165: if ((msg_type is not null) and (msg_name is not null)) then
1172: cattributes=>'id="i_wfrtg_close"');
1173: end if;
1174: -- Check existing of response
1175: select count(WMA.NAME) into rowcount
1176: from WF_ROUTING_RULES WRR,
1177: WF_MESSAGE_ATTRIBUTES_VL WMA,
1178: WF_ITEM_ATTRIBUTES WIA
1179: where WRR.RULE_ID = nruleid
1180: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1413: l_action := fmode;
1414: end if;
1415:
1416: -- Select new ruleid
1417: select WF_ROUTING_RULES_S.NEXTVAL
1418: into ruleid
1419: from SYS.DUAL;
1420:
1421: -- Insert new rule in table with data so far
1418: into ruleid
1419: from SYS.DUAL;
1420:
1421: -- Insert new rule in table with data so far
1422: insert into WF_ROUTING_RULES (
1423: RULE_ID,
1424: ROLE,
1425: ACTION,
1426: BEGIN_DATE,
1587: WIT.DISPLAY_NAME TYPE_DISPLAY,
1588: WM.DISPLAY_NAME MSG_DISPLAY,
1589: WM.SUBJECT,
1590: WL.MEANING ACTION_DISPLAY
1591: from WF_ROUTING_RULES WRR, WF_ITEM_TYPES_VL WIT, WF_MESSAGES_VL WM,
1592: WF_LOOKUPS WL
1593: where WRR.ROLE = username
1594: and WRR.MESSAGE_TYPE = WIT.NAME (+)
1595: and WRR.MESSAGE_TYPE = WM.TYPE (+)
1765:
1766: -- Check existing of response
1767: select count(WMA.NAME)
1768: into rowcount
1769: from WF_ROUTING_RULES WRR,
1770: WF_MESSAGE_ATTRIBUTES_VL WMA,
1771: WF_ITEM_ATTRIBUTES WIA
1772: where WRR.RULE_ID = rule.rule_id
1773: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1791: select WL.MEANING
1792: into att_tvalue
1793: from WF_LOOKUPS WL,
1794: WF_MESSAGE_ATTRIBUTES_VL WMA,
1795: WF_ROUTING_RULES WRR,
1796: WF_ROUTING_RULE_ATTRIBUTES WRA
1797: where WRA.RULE_ID = rule.rule_id
1798: and WRA.NAME = 'RESULT'
1799: and WRR.RULE_ID = WRA.RULE_ID
2011: procedure ChangeMessageName (p_itemType in varchar2,
2012: p_oldMessageName in varchar2,
2013: p_newMessageName in varchar2) is
2014: begin
2015: update WF_ROUTING_RULES
2016: set MESSAGE_NAME = upper(p_newMessageName)
2017: where MESSAGE_TYPE = p_itemType
2018: and MESSAGE_NAME = p_oldMessageName;
2019: end;