DBA Data[Home] [Help]

APPS.WFA_HTML dependencies on WF_MESSAGE_ATTRIBUTES

Line 579: WF_MESSAGE_ATTRIBUTES_VL WMA

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
583: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 596: WF_MESSAGE_ATTRIBUTES_VL WMA

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
600: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1103: WF_MESSAGE_ATTRIBUTES_VL MA,

1099: NA.DATE_VALUE,
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

Line 1125: WF_MESSAGE_ATTRIBUTES_VL MA,

1121: -- remove quotes for onmouse over java func
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

Line 1795: WF_MESSAGE_ATTRIBUTES_VL MA,

1791: MA.TYPE,
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

Line 1910: from WF_MESSAGE_ATTRIBUTES MA,

1906:
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

Line 1926: WF_MESSAGE_ATTRIBUTES MA,

1922: -- Count of all response fields
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

Line 1941: WF_MESSAGE_ATTRIBUTES MA,

1937: -- Count of multiline response fields
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