DBA Data[Home] [Help]

APPS.WFA_HTML dependencies on WF_NOTIFICATIONS

Line 381: from WF_NOTIFICATIONS WN

377: -- Get recipient and original recipient of this notification
378: begin
379: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT
380: into recipient, orig_recipient
381: from WF_NOTIFICATIONS WN
382: where WN.NOTIFICATION_ID = nid;
383: exception
384: when no_data_found then
385: Wf_Core.Token('NID', nid);

Line 613: WF_NOTIFICATIONS N

609: -- Count of multiline response fields
610: select count(1)
611: into urlcnt
612: from WF_MESSAGE_ATTRIBUTES MA,
613: WF_NOTIFICATIONS N
614: where N.NOTIFICATION_ID = nid
615: and MA.MESSAGE_NAME = N.MESSAGE_NAME
616: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
617: and MA.SUBTYPE = 'RESPOND'

Line 629: WF_NOTIFICATIONS N

625: select count(1)
626: into respcnt
627: from WF_NOTIFICATION_ATTRIBUTES NA,
628: WF_MESSAGE_ATTRIBUTES MA,
629: WF_NOTIFICATIONS N
630: where N.NOTIFICATION_ID = nid
631: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
632: and MA.MESSAGE_NAME = N.MESSAGE_NAME
633: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 644: WF_NOTIFICATIONS N

640: select count(1)
641: into longcnt
642: from WF_NOTIFICATION_ATTRIBUTES NA,
643: WF_MESSAGE_ATTRIBUTES MA,
644: WF_NOTIFICATIONS N
645: where N.NOTIFICATION_ID = nid
646: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
647: and MA.MESSAGE_NAME = N.MESSAGE_NAME
648: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE