514: buf pls_integer;
515: begin
516: select count(1),max(NA.TEXT_VALUE)
517: into urlcnt, urlstrg
518: from WF_NOTIFICATION_ATTRIBUTES NA,
519: WF_MESSAGE_ATTRIBUTES MA,
520: WF_NOTIFICATIONS N
521: where N.NOTIFICATION_ID = nid
522: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
548: buf varchar2(4000);
549: begin
550: select text_value
551: into buf
552: from WF_NOTIFICATION_ATTRIBUTES NA,
553: WF_MESSAGE_ATTRIBUTES_VL MA,
554: WF_NOTIFICATIONS N
555: where N.NOTIFICATION_ID = nid
556: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID