APPS.WFA_HTML_UTIL dependencies on WF_NOTIFICATIONS

Line 520: WF_NOTIFICATIONS N

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
523: and MA.MESSAGE_NAME = N.MESSAGE_NAME
524: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 554: WF_NOTIFICATIONS N

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
557: and MA.MESSAGE_NAME = N.MESSAGE_NAME
558: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 628: -- Populate WF_NOTIFICATIONS with the needed values with supplied langcode.

624: end GetDisplayValue;
625:
626: --
627: -- GetDenormalizedValues
628: -- Populate WF_NOTIFICATIONS with the needed values with supplied langcode.
629: -- Then returns those values via the out variables.
630: -- IN:
631: -- nid - notification id
632: -- langcode - language code

Line 650: from WF_NOTIFICATIONS

646:
647: begin
648: select FROM_USER, TO_USER, SUBJECT
649: into from_user, to_user, subject
650: from WF_NOTIFICATIONS
651: where NOTIFICATION_ID = nid;
652: exception
653: when OTHERS then
654: from_user := null;