eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_NOTIFICATION dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 342: WF_NOTIFICATION_ATTRIBUTES NA,

338: NA.NUMBER_VALUE,
339: NA.DATE_VALUE
340: into l_dispname, l_type, l_format, l_textv, l_numberv, l_datev
341: from WF_MESSAGE_ATTRIBUTES_VL MA,
342: WF_NOTIFICATION_ATTRIBUTES NA,
343: WF_NOTIFICATIONS N
344: where NA.NAME = l_attr
345: and NA.NOTIFICATION_ID = nid
346: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 1105: insert into WF_NOTIFICATION_ATTRIBUTES (

1101: end;
1102:
1103: -- Insert new attribute
1104: begin
1105: insert into WF_NOTIFICATION_ATTRIBUTES (
1106: NOTIFICATION_ID,
1107: NAME,
1108: TEXT_VALUE,
1109: NUMBER_VALUE,

Line 1166: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

1162: -- This is used for translating number/date strings.
1163: begin
1164: select WMA.TYPE, WMA.FORMAT
1165: into atype, format
1166: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1167: WF_MESSAGE_ATTRIBUTES WMA
1168: where WNA.NOTIFICATION_ID = nid
1169: and WNA.NAME = aname
1170: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID

Line 1184: update WF_NOTIFICATION_ATTRIBUTES

1180: end;
1181:
1182: -- Update attribute value in appropriate type column.
1183: if (atype = 'NUMBER') then
1184: update WF_NOTIFICATION_ATTRIBUTES
1185: set NUMBER_VALUE = decode(format,
1186: '', to_number(avalue),
1187: to_number(avalue, format))
1188: where NOTIFICATION_ID = nid

Line 1194: update WF_NOTIFICATION_ATTRIBUTES

1190: elsif (atype = 'DATE') then
1191: -- 4477386 gscc date format requirement change
1192: -- do not use a cached value, this allows nls change within the
1193: -- same session to be seen right away.
1194: update WF_NOTIFICATION_ATTRIBUTES
1195: set DATE_VALUE = decode(format,
1196: '',to_date(avalue,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')),
1197: to_date(avalue, format))
1198: where NOTIFICATION_ID = nid

Line 1204: update WF_NOTIFICATION_ATTRIBUTES

1200: elsif (atype = 'VARCHAR2') then
1201: -- VARCHAR2
1202: -- Set the text value directly with no translation.
1203: -- bug 1996299 - JWSMITH , changes substr to substrb for korean char
1204: update WF_NOTIFICATION_ATTRIBUTES
1205: set TEXT_VALUE = decode(format,
1206: '', avalue,
1207: substrb(avalue, 1, to_number(format)))
1208: where NOTIFICATION_ID = nid

Line 1239: update WF_NOTIFICATION_ATTRIBUTES

1235: end if;
1236: end if;
1237:
1238: -- Set the text value with internal role name
1239: update WF_NOTIFICATION_ATTRIBUTES
1240: set TEXT_VALUE = rname
1241: where NOTIFICATION_ID = nid
1242: and NAME = aname;
1243: else

Line 1246: update WF_NOTIFICATION_ATTRIBUTES

1242: and NAME = aname;
1243: else
1244: -- LOOKUP, FORM, URL, DOCUMENT, misc type.
1245: -- Set the text value.
1246: update WF_NOTIFICATION_ATTRIBUTES
1247: set TEXT_VALUE = avalue
1248: where NOTIFICATION_ID = nid
1249: and NAME = aname;
1250: end if;

Line 1263: -- Bug 2437347 raising event after DML operation on WF_NOTIFICATION_ATTRIBUTES

1259: if (aname = '#FROM_ROLE') then
1260: Wf_Notification.Denormalize_Notification(nid);
1261: end if;
1262:
1263: -- Bug 2437347 raising event after DML operation on WF_NOTIFICATION_ATTRIBUTES
1264: if (aname = 'SENDER') then
1265: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
1266: wf_event.AddParameterToList(aname, avalue, l_parameterlist);
1267:

Line 1324: update WF_NOTIFICATION_ATTRIBUTES

1320: wf_core.raise('WFSQL_ARGS');
1321: end if;
1322:
1323: -- Update attribute value
1324: update WF_NOTIFICATION_ATTRIBUTES
1325: set NUMBER_VALUE = avalue
1326: where NOTIFICATION_ID = nid and NAME = aname;
1327:
1328: if (SQL%NOTFOUND) then

Line 1362: update WF_NOTIFICATION_ATTRIBUTES

1358: wf_core.raise('WFSQL_ARGS');
1359: end if;
1360:
1361: -- Update attribute value
1362: update WF_NOTIFICATION_ATTRIBUTES
1363: set DATE_VALUE = avalue
1364: where NOTIFICATION_ID = nid and NAME = aname;
1365:
1366: if (SQL%NOTFOUND) then

Line 1521: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

1517: -- of another.
1518: cursor notification_attrs_cursor(nid number) is
1519: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
1520: WNA.TEXT_VALUE, WNA.NUMBER_VALUE, WNA.DATE_VALUE
1521: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1522: WF_MESSAGE_ATTRIBUTES_VL WMA
1523: where WNA.NOTIFICATION_ID = nid
1524: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1525: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1862: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

1858: -- of another.
1859: cursor notification_attrs_cursor(nid number) is
1860: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
1861: WNA.TEXT_VALUE, WNA.NUMBER_VALUE, WNA.DATE_VALUE
1862: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1863: WF_MESSAGE_ATTRIBUTES_VL WMA
1864: where WNA.NOTIFICATION_ID = nid
1865: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1866: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2227: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

2223:
2224: begin
2225: select WMA.TYPE, WMA.SUBTYPE, WMA.FORMAT
2226: into atype, subtype, format
2227: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2228: WF_MESSAGE_ATTRIBUTES WMA
2229: where WNA.NOTIFICATION_ID = nid
2230: and WNA.NAME = aname
2231: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID

Line 2282: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

2278: -- This is used for translating number/date strings.
2279: begin
2280: select WMA.TYPE, WMA.FORMAT
2281: into atype, format
2282: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2283: WF_MESSAGE_ATTRIBUTES WMA
2284: where WNA.NOTIFICATION_ID = nid
2285: and WNA.NAME = aname
2286: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID

Line 2305: from WF_NOTIFICATION_ATTRIBUTES WNA

2301: select decode(format,
2302: '', to_char(WNA.NUMBER_VALUE),
2303: to_char(WNA.NUMBER_VALUE, format))
2304: into lvalue
2305: from WF_NOTIFICATION_ATTRIBUTES WNA
2306: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2307: elsif (atype = 'DATE') then
2308: -- apply format precedence to get date text
2309: select DATE_VALUE into l_valDate

Line 2310: from WF_NOTIFICATION_ATTRIBUTES WNA

2306: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2307: elsif (atype = 'DATE') then
2308: -- apply format precedence to get date text
2309: select DATE_VALUE into l_valDate
2310: from WF_NOTIFICATION_ATTRIBUTES WNA
2311: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2312:
2313: lvalue := wf_notification_util.GetCalendarDate(nid, l_valDate, format, false);
2314:

Line 2319: from WF_NOTIFICATION_ATTRIBUTES WNA

2315: else
2316: -- VARCHAR2, LOOKUP, FORM, or URL type.
2317: select WNA.TEXT_VALUE
2318: into lvalue
2319: from WF_NOTIFICATION_ATTRIBUTES WNA
2320: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2321:
2322: -- Recursively substitute attributes in parameter portion of
2323: -- FORM and URL type attributes.

Line 2386: from WF_NOTIFICATION_ATTRIBUTES WNA

2382:
2383: begin
2384: select WNA.NUMBER_VALUE
2385: into lvalue
2386: from WF_NOTIFICATION_ATTRIBUTES WNA
2387: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2388: exception
2389: when no_data_found then
2390: wf_core.token('NID', to_char(nid));

Line 2426: from WF_NOTIFICATION_ATTRIBUTES WNA

2422:
2423: begin
2424: select WNA.DATE_VALUE
2425: into lvalue
2426: from WF_NOTIFICATION_ATTRIBUTES WNA
2427: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2428: exception
2429: when no_data_found then
2430: wf_core.token('NID', to_char(nid));

Line 2622: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

2618: -- This is used for translating number/date strings.
2619: begin
2620: select WMATL.DISPLAY_NAME, NVL(WMA.FORMAT, '_blank')
2621: into display_name, target
2622: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2623: WF_MESSAGE_ATTRIBUTES_TL WMATL, WF_MESSAGE_ATTRIBUTES WMA
2624: where WNA.NOTIFICATION_ID = nid
2625: and WNA.NAME = aname
2626: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID

Line 3476: wf_notification_attributes wna,

3472: wna.date_value
3473: from wf_ntf_rules wnr,
3474: wf_ntf_rule_maps wnrm,
3475: wf_ntf_rule_criteria wnrc,
3476: wf_notification_attributes wna,
3477: wf_notifications wn
3478: where wnr.rule_name = wnrc.rule_name
3479: and wnrc.message_type = wn.message_type
3480: and wnr.status = 'ENABLED'

Line 3879: insert into WF_NOTIFICATION_ATTRIBUTES (

3875: --
3876: -- Insert notification attribute
3877: -- Bug 2376033 insert the event value
3878: --
3879: insert into WF_NOTIFICATION_ATTRIBUTES (
3880: NOTIFICATION_ID,
3881: NAME,
3882: TEXT_VALUE,
3883: NUMBER_VALUE,

Line 3985: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

3981: -- wf_xml.EnqueueNotification(nid);
3982:
3983: --Bug 2283697
3984: --To raise an EVENT whenever DML operation is performed on
3985: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
3986: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3987: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3988: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3989:

Line 4549: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

4545: end if;
4546:
4547: --Bug 2283697
4548: --To raise an EVENT whenever DML operation is performed on
4549: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4550: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4551: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4552: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4553: if (user is not null) then

Line 4782: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

4778: -- wf_xml.EnqueueNotification(nid);
4779:
4780: --Bug 2283697
4781: --To raise an EVENT whenever DML operation is performed on
4782: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4783: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4784: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
4785: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||
4786: l_msg_name, l_parameterlist);

Line 5048: wf_notification_attributes wfna

5044: --
5045: select count(*)
5046: into l_code_count
5047: from wf_notifications wfn,
5048: wf_notification_attributes wfna
5049: where wfn.group_id = Gid
5050: and wfn.notification_id = wfna.notification_id
5051: and wfn.status = 'CLOSED'
5052: and wfna.name = 'RESULT'

Line 5185: from WF_NOTIFICATION_ATTRIBUTES NA,

5181:
5182: -- Any existence of response attribute constitutes a response required.
5183: cursor attrs(mnid in number) is
5184: select MA.NAME
5185: from WF_NOTIFICATION_ATTRIBUTES NA,
5186: WF_MESSAGE_ATTRIBUTES_VL MA,
5187: WF_NOTIFICATIONS N
5188: where N.NOTIFICATION_ID = mnid
5189: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 5255: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

5251: -- wf_xml.RemoveNotification(nid);
5252:
5253: --Bug 2283697
5254: --To raise an EVENT whenever DML operation is performed on
5255: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
5256: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
5257: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);
5258:
5259: -- AppSearch

Line 5701: WF_NOTIFICATION_ATTRIBUTES NA

5697: select NAME into aname from
5698: (select WMA.NAME
5699: from WF_NOTIFICATIONS WN,
5700: WF_MESSAGE_ATTRIBUTES WMA,
5701: WF_NOTIFICATION_ATTRIBUTES NA
5702: where WN.NOTIFICATION_ID = nid
5703: and wn.notification_id = na.notification_id
5704: and wma.name = na.name
5705: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 6867: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

6863: -- wf_xml.EnqueueNotification(nid);
6864:
6865: -- Bug 2283697
6866: -- To raise an EVENT whenever DML operation is performed on
6867: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
6868: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
6869: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
6870: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
6871: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||

Line 7125: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

7121: -- notification entirely
7122: wf_notification.clob_exists := null;
7123:
7124: -- To raise an EVENT whenever DML operation is performed on
7125: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7126: wf_event.AddParameterToList('NOTIFICATION_ID', p_nid, l_parameterlist);
7127: wf_event.AddParameterToList('ROLE', p_new_user, l_parameterlist);
7128: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, p_nid), l_parameterlist);
7129: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||

Line 7771: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

7767: -- wf_xml.EnqueueNotification(nid);
7768:
7769: -- Bug 2283697
7770: -- To raise an EVENT whenever DML operation is performed on
7771: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7772: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7773:
7774: -- username MAY be a display name
7775: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);

Line 7930: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

7926: -- wf_xml.EnqueueNotification(nid);
7927:
7928: -- Bug 2283697
7929: -- To raise an EVENT whenever DML operation is performed on
7930: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7931: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7932: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7933: -- to keep the behaviour same just pass null as ROLE..
7934: wf_event.AddParameterToList('ROLE', null, l_parameterlist);

Line 8400: FROM wf_notification_attributes

8396: if (l_note = '#WF_NOTE#') then
8397: begin
8398: SELECT text_value
8399: INTO l_note
8400: FROM wf_notification_attributes
8401: WHERE notification_id = l_comm_rec.h_notification_id
8402: AND name = 'WF_NOTE';
8403: exception
8404: when no_data_found then

Line 8655: WF_NOTIFICATION_ATTRIBUTES NA

8651: select NAME into aname from
8652: (select WMA.NAME
8653: from WF_NOTIFICATIONS WN,
8654: WF_MESSAGE_ATTRIBUTES WMA,
8655: WF_NOTIFICATION_ATTRIBUTES NA
8656: where WN.NOTIFICATION_ID = nid
8657: and wn.notification_id = na.notification_id
8658: and wma.name = na.name
8659: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 8822: from WF_NOTIFICATION_ATTRIBUTES WNA,

8818: lv_token_start number;
8819:
8820: cursor cur_hdr_region is
8821: select WNA.NAME, WNA.TEXT_VALUE
8822: from WF_NOTIFICATION_ATTRIBUTES WNA,
8823: WF_MESSAGE_ATTRIBUTES_VL WMA
8824: where WNA.NOTIFICATION_ID = nid
8825: and WMA.NAME = WNA.NAME
8826: and WMA.TYPE = 'DOCUMENT'

Line 8967: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

8963:
8964: -- Cursur to check for each message Attribute
8965: cursor cur_msg_attrs(nid number, msgToken varchar2) is
8966: select WNA.NAME, WNA.TEXT_VALUE, WMA.TYPE
8967: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
8968: WF_MESSAGE_ATTRIBUTES_VL WMA
8969: where WNA.NOTIFICATION_ID = nid
8970: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
8971: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 9632: from wf_item_activity_statuses wfas, wf_notifications wfn , wf_notification_attributes wfna

9628: is
9629: --Get the nids in curs_nid which have the attribute document_id
9630: cursor curs_nid(l_doc_id varchar2,l_item_type varchar2,l_item_key varchar2) is
9631: select wfn.notification_id
9632: from wf_item_activity_statuses wfas, wf_notifications wfn , wf_notification_attributes wfna
9633: where wfna.name = '#DOCUMENT_ID'
9634: and wfna.text_value = l_doc_id
9635: and wfas.item_type = l_item_type
9636: and wfas.item_key = l_item_key

Line 9869: from WF_NOTIFICATION_ATTRIBUTES WNA,

9865:
9866: cursor notification_attrs_cursor(nid number) is
9867: select WNA.NAME, WMA.TYPE, WNA.TEXT_VALUE, WNA.NUMBER_VALUE,
9868: WNA.DATE_VALUE
9869: from WF_NOTIFICATION_ATTRIBUTES WNA,
9870: WF_MESSAGE_ATTRIBUTES WMA,
9871: WF_NOTIFICATIONS WN
9872: where WNA.NOTIFICATION_ID = nid
9873: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 10083: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

10079: action_source, respond_comment);
10080:
10081: --Bug 2283697
10082: --To raise an EVENT whenever DML operation is performed on
10083: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
10084: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
10085: wf_event.AddParameterToList('RESPONDER',respond2.responder,l_parameterlist);
10086:
10087: -- AppSearch