APPS.WF_ROUTE dependencies on WF_ROUTING_RULE_ATTRIBUTES

Line 121: from WF_ROUTING_RULE_ATTRIBUTES WRRA

117: is
118: begin
119: select WRRA.TEXT_VALUE, WRRA.NUMBER_VALUE, WRRA.DATE_VALUE
120: into tvalue, nvalue, dvalue
121: from WF_ROUTING_RULE_ATTRIBUTES WRRA
122: where WRRA.RULE_ID = GetAttrValue.ruleid
123: and WRRA.NAME = GetAttrValue.attrname;
124:
125: return(TRUE);

Line 668: update WF_ROUTING_RULE_ATTRIBUTES WRRA set

664: tvalue := attr_value;
665: end if;
666:
667: -- Update/Insert attributes table with new values
668: update WF_ROUTING_RULE_ATTRIBUTES WRRA set
669: TEXT_VALUE = SetAttribute.tvalue,
670: NUMBER_VALUE = SetAttribute.nvalue,
671: DATE_VALUE = SetAttribute.dvalue
672: where WRRA.RULE_ID = SetAttribute.ruleid

Line 677: insert into WF_ROUTING_RULE_ATTRIBUTES (

673: and WRRA.NAME = SetAttribute.attr_name;
674:
675: if (sql%rowcount = 0) then
676: -- Insert missing attribute row
677: insert into WF_ROUTING_RULE_ATTRIBUTES (
678: RULE_ID,
679: NAME,
680: TYPE,
681: TEXT_VALUE,

Line 718: delete from WF_ROUTING_RULE_ATTRIBUTES

714: -- Validate access
715: owner := Wf_Route.Authenticate(user);
716:
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;

Line 787: delete from WF_ROUTING_RULE_ATTRIBUTES

783: if (delete_button is not null) then
784: /*
785: -- Now delete rule in the List procedure instead of here
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;

Line 837: update WF_ROUTING_RULE_ATTRIBUTES WRRA set

833: end loop;
834: else
835: begin
836: -- Update attributes table with null values since this is not a response
837: update WF_ROUTING_RULE_ATTRIBUTES WRRA set
838: TEXT_VALUE = null,
839: NUMBER_VALUE = null,
840: DATE_VALUE = null
841: where WRRA.RULE_ID = nruleid;

Line 1787: from WF_ROUTING_RULE_ATTRIBUTES

1783: /* ### we should display the meaning instead of the underlying value.
1784:
1785: select TEXT_VALUE
1786: into att_tvalue
1787: from WF_ROUTING_RULE_ATTRIBUTES
1788: where RULE_ID = rule.rule_id
1789: and NAME = 'RESULT';
1790: */
1791: select WL.MEANING

Line 1796: WF_ROUTING_RULE_ATTRIBUTES WRA

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
1800: and WMA.NAME = WRA.NAME