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 563: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL

559: WN.FROM_USER,
560: WN.TO_USER,
561: WN.SUBJECT,
562: WN.LANGUAGE
563: from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_VL WIT, WF_LOOKUPS WL
564: where WN.NOTIFICATION_ID = to_number(nid)
565: and WN.MESSAGE_TYPE = WIT.NAME
566: and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
567: and WN.STATUS = WL.LOOKUP_CODE;

Line 578: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

574: -- of another.
575: cursor notification_attrs_cursor(nid number) is
576: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
577: WNA.TEXT_VALUE
578: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
579: WF_MESSAGE_ATTRIBUTES_VL WMA
580: where WNA.NOTIFICATION_ID = nid
581: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
582: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 595: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

591: -- similar to the above except FORMS do not set ATTACH to Y
592: cursor ntf_forms_attrs_cursor(nid number) is
593: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
594: WNA.TEXT_VALUE
595: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
596: WF_MESSAGE_ATTRIBUTES_VL WMA
597: where WNA.NOTIFICATION_ID = nid
598: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
599: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1104: WF_NOTIFICATIONS N

1100: MA.TYPE,
1101: MA.FORMAT
1102: from WF_NOTIFICATION_ATTRIBUTES NA,
1103: WF_MESSAGE_ATTRIBUTES_VL MA,
1104: WF_NOTIFICATIONS N
1105: where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
1106: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1107: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1108: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1126: WF_NOTIFICATIONS N

1122: replace(MA.DESCRIPTION,'''') description2,
1123: NA.TEXT_VALUE
1124: from WF_NOTIFICATION_ATTRIBUTES NA,
1125: WF_MESSAGE_ATTRIBUTES_VL MA,
1126: WF_NOTIFICATIONS N
1127: where N.NOTIFICATION_ID = to_number(ResponseFrame.nid)
1128: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1129: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1130: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1796: WF_NOTIFICATIONS N

1792: MA.FORMAT
1793: into dispname, description, attrtype, format
1794: from WF_NOTIFICATION_ATTRIBUTES NA,
1795: WF_MESSAGE_ATTRIBUTES_VL MA,
1796: WF_NOTIFICATIONS N
1797: where N.NOTIFICATION_ID = to_number(AttributeInfo.nid)
1798: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1799: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1800: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1911: WF_NOTIFICATIONS N

1907: -- Count of multiline response fields
1908: select count(1)
1909: into urlcnt
1910: from WF_MESSAGE_ATTRIBUTES MA,
1911: WF_NOTIFICATIONS N
1912: where N.NOTIFICATION_ID = nid
1913: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1914: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
1915: and MA.SUBTYPE = 'RESPOND'

Line 1927: WF_NOTIFICATIONS N

1923: select count(1)
1924: into respcnt
1925: from WF_NOTIFICATION_ATTRIBUTES NA,
1926: WF_MESSAGE_ATTRIBUTES MA,
1927: WF_NOTIFICATIONS N
1928: where N.NOTIFICATION_ID = nid
1929: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1930: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1931: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 1942: WF_NOTIFICATIONS N

1938: select count(1)
1939: into longcnt
1940: from WF_NOTIFICATION_ATTRIBUTES NA,
1941: WF_MESSAGE_ATTRIBUTES MA,
1942: WF_NOTIFICATIONS N
1943: where N.NOTIFICATION_ID = nid
1944: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
1945: and MA.MESSAGE_NAME = N.MESSAGE_NAME
1946: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE