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 1066: insert into WF_NOTIFICATION_ATTRIBUTES (

1062: end;
1063:
1064: -- Insert new attribute
1065: begin
1066: insert into WF_NOTIFICATION_ATTRIBUTES (
1067: NOTIFICATION_ID,
1068: NAME,
1069: TEXT_VALUE,
1070: NUMBER_VALUE,

Line 1127: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

1123: -- This is used for translating number/date strings.
1124: begin
1125: select WMA.TYPE, WMA.FORMAT
1126: into atype, format
1127: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1128: WF_MESSAGE_ATTRIBUTES WMA
1129: where WNA.NOTIFICATION_ID = nid
1130: and WNA.NAME = aname
1131: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID

Line 1145: update WF_NOTIFICATION_ATTRIBUTES

1141: end;
1142:
1143: -- Update attribute value in appropriate type column.
1144: if (atype = 'NUMBER') then
1145: update WF_NOTIFICATION_ATTRIBUTES
1146: set NUMBER_VALUE = decode(format,
1147: '', to_number(avalue),
1148: to_number(avalue, format))
1149: where NOTIFICATION_ID = nid

Line 1155: update WF_NOTIFICATION_ATTRIBUTES

1151: elsif (atype = 'DATE') then
1152: -- 4477386 gscc date format requirement change
1153: -- do not use a cached value, this allows nls change within the
1154: -- same session to be seen right away.
1155: update WF_NOTIFICATION_ATTRIBUTES
1156: set DATE_VALUE = decode(format,
1157: '',to_date(avalue,SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')),
1158: to_date(avalue, format))
1159: where NOTIFICATION_ID = nid

Line 1165: update WF_NOTIFICATION_ATTRIBUTES

1161: elsif (atype = 'VARCHAR2') then
1162: -- VARCHAR2
1163: -- Set the text value directly with no translation.
1164: -- bug 1996299 - JWSMITH , changes substr to substrb for korean char
1165: update WF_NOTIFICATION_ATTRIBUTES
1166: set TEXT_VALUE = decode(format,
1167: '', avalue,
1168: substrb(avalue, 1, to_number(format)))
1169: where NOTIFICATION_ID = nid

Line 1200: update WF_NOTIFICATION_ATTRIBUTES

1196: end if;
1197: end if;
1198:
1199: -- Set the text value with internal role name
1200: update WF_NOTIFICATION_ATTRIBUTES
1201: set TEXT_VALUE = rname
1202: where NOTIFICATION_ID = nid
1203: and NAME = aname;
1204: else

Line 1207: update WF_NOTIFICATION_ATTRIBUTES

1203: and NAME = aname;
1204: else
1205: -- LOOKUP, FORM, URL, DOCUMENT, misc type.
1206: -- Set the text value.
1207: update WF_NOTIFICATION_ATTRIBUTES
1208: set TEXT_VALUE = avalue
1209: where NOTIFICATION_ID = nid
1210: and NAME = aname;
1211: end if;

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

1220: if (aname = '#FROM_ROLE') then
1221: Wf_Notification.Denormalize_Notification(nid);
1222: end if;
1223:
1224: -- Bug 2437347 raising event after DML operation on WF_NOTIFICATION_ATTRIBUTES
1225: if (aname = 'SENDER') then
1226: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
1227: wf_event.AddParameterToList(aname, avalue, l_parameterlist);
1228:

Line 1285: update WF_NOTIFICATION_ATTRIBUTES

1281: wf_core.raise('WFSQL_ARGS');
1282: end if;
1283:
1284: -- Update attribute value
1285: update WF_NOTIFICATION_ATTRIBUTES
1286: set NUMBER_VALUE = avalue
1287: where NOTIFICATION_ID = nid and NAME = aname;
1288:
1289: if (SQL%NOTFOUND) then

Line 1323: update WF_NOTIFICATION_ATTRIBUTES

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

Line 1481: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

1477: -- of another.
1478: cursor notification_attrs_cursor(nid number) is
1479: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
1480: WNA.TEXT_VALUE, WNA.NUMBER_VALUE, WNA.DATE_VALUE
1481: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1482: WF_MESSAGE_ATTRIBUTES_VL WMA
1483: where WNA.NOTIFICATION_ID = nid
1484: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1485: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1795: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

1791: -- of another.
1792: cursor notification_attrs_cursor(nid number) is
1793: select WNA.NAME, WMA.TYPE, WMA.FORMAT, WMA.DISPLAY_NAME,
1794: WNA.TEXT_VALUE, WNA.NUMBER_VALUE, WNA.DATE_VALUE
1795: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1796: WF_MESSAGE_ATTRIBUTES_VL WMA
1797: where WNA.NOTIFICATION_ID = nid
1798: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1799: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 2160: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

2156:
2157: begin
2158: select WMA.TYPE, WMA.SUBTYPE, WMA.FORMAT
2159: into atype, subtype, format
2160: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2161: WF_MESSAGE_ATTRIBUTES WMA
2162: where WNA.NOTIFICATION_ID = nid
2163: and WNA.NAME = aname
2164: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID

Line 2215: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

2211: -- This is used for translating number/date strings.
2212: begin
2213: select WMA.TYPE, WMA.FORMAT
2214: into atype, format
2215: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2216: WF_MESSAGE_ATTRIBUTES WMA
2217: where WNA.NOTIFICATION_ID = nid
2218: and WNA.NAME = aname
2219: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID

Line 2238: from WF_NOTIFICATION_ATTRIBUTES WNA

2234: select decode(format,
2235: '', to_char(WNA.NUMBER_VALUE),
2236: to_char(WNA.NUMBER_VALUE, format))
2237: into lvalue
2238: from WF_NOTIFICATION_ATTRIBUTES WNA
2239: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2240: elsif (atype = 'DATE') then
2241: -- apply format precedence to get date text
2242: select DATE_VALUE into l_valDate

Line 2243: from WF_NOTIFICATION_ATTRIBUTES WNA

2239: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2240: elsif (atype = 'DATE') then
2241: -- apply format precedence to get date text
2242: select DATE_VALUE into l_valDate
2243: from WF_NOTIFICATION_ATTRIBUTES WNA
2244: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2245:
2246: lvalue := wf_notification_util.GetCalendarDate(nid, l_valDate, format, false);
2247:

Line 2252: from WF_NOTIFICATION_ATTRIBUTES WNA

2248: else
2249: -- VARCHAR2, LOOKUP, FORM, or URL type.
2250: select WNA.TEXT_VALUE
2251: into lvalue
2252: from WF_NOTIFICATION_ATTRIBUTES WNA
2253: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2254:
2255: -- Recursively substitute attributes in parameter portion of
2256: -- FORM and URL type attributes.

Line 2319: from WF_NOTIFICATION_ATTRIBUTES WNA

2315:
2316: begin
2317: select WNA.NUMBER_VALUE
2318: into lvalue
2319: from WF_NOTIFICATION_ATTRIBUTES WNA
2320: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2321: exception
2322: when no_data_found then
2323: wf_core.token('NID', to_char(nid));

Line 2359: from WF_NOTIFICATION_ATTRIBUTES WNA

2355:
2356: begin
2357: select WNA.DATE_VALUE
2358: into lvalue
2359: from WF_NOTIFICATION_ATTRIBUTES WNA
2360: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
2361: exception
2362: when no_data_found then
2363: wf_core.token('NID', to_char(nid));

Line 2536: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

2532: -- This is used for translating number/date strings.
2533: begin
2534: select WMATL.DISPLAY_NAME, NVL(WMA.FORMAT, '_blank')
2535: into display_name, target
2536: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
2537: WF_MESSAGE_ATTRIBUTES_TL WMATL, WF_MESSAGE_ATTRIBUTES WMA
2538: where WNA.NOTIFICATION_ID = nid
2539: and WNA.NAME = aname
2540: and WNA.NOTIFICATION_ID = WN.NOTIFICATION_ID

Line 3362: wf_notification_attributes wna,

3358: wna.date_value
3359: from wf_ntf_rules wnr,
3360: wf_ntf_rule_maps wnrm,
3361: wf_ntf_rule_criteria wnrc,
3362: wf_notification_attributes wna,
3363: wf_notifications wn
3364: where wnr.rule_name = wnrc.rule_name
3365: and wnrc.message_type = wn.message_type
3366: and wnr.status = 'ENABLED'

Line 3759: insert into WF_NOTIFICATION_ATTRIBUTES (

3755: --
3756: -- Insert notification attribute
3757: -- Bug 2376033 insert the event value
3758: --
3759: insert into WF_NOTIFICATION_ATTRIBUTES (
3760: NOTIFICATION_ID,
3761: NAME,
3762: TEXT_VALUE,
3763: NUMBER_VALUE,

Line 3855: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

3851: -- wf_xml.EnqueueNotification(nid);
3852:
3853: --Bug 2283697
3854: --To raise an EVENT whenever DML operation is performed on
3855: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
3856: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
3857: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
3858: wf_event.AddParameterToList('GROUP_ID',nvl(group_id,nid),l_parameterlist);
3859:

Line 4384: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

4380: end if;
4381:
4382: --Bug 2283697
4383: --To raise an EVENT whenever DML operation is performed on
4384: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4385: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4386: wf_event.AddParameterToList('NEW_ROLE',new_role,l_parameterlist);
4387: wf_event.AddParameterToList('MODE',fmode,l_parameterlist);
4388: if (user is not null) then

Line 4617: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

4613: -- wf_xml.EnqueueNotification(nid);
4614:
4615: --Bug 2283697
4616: --To raise an EVENT whenever DML operation is performed on
4617: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4618: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4619: wf_event.AddParameterToList('ROLE',role,l_parameterlist);
4620: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type || ':'||
4621: l_msg_name, l_parameterlist);

Line 4759: from WF_NOTIFICATION_ATTRIBUTES WNA,

4755:
4756: cursor notification_attrs_cursor(nid number) is
4757: select WNA.NAME, WMA.TYPE, WNA.TEXT_VALUE, WNA.NUMBER_VALUE,
4758: WNA.DATE_VALUE
4759: from WF_NOTIFICATION_ATTRIBUTES WNA,
4760: WF_MESSAGE_ATTRIBUTES WMA,
4761: WF_NOTIFICATIONS WN
4762: where WNA.NOTIFICATION_ID = nid
4763: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 4970: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

4966: action_source, respond_comment);
4967:
4968: --Bug 2283697
4969: --To raise an EVENT whenever DML operation is performed on
4970: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
4971: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
4972: wf_event.AddParameterToList('RESPONDER',respond.responder,l_parameterlist);
4973:
4974: -- AppSearch

Line 5207: wf_notification_attributes wfna

5203: --
5204: select count(*)
5205: into l_code_count
5206: from wf_notifications wfn,
5207: wf_notification_attributes wfna
5208: where wfn.group_id = Gid
5209: and wfn.notification_id = wfna.notification_id
5210: and wfn.status = 'CLOSED'
5211: and wfna.name = 'RESULT'

Line 5349: from WF_NOTIFICATION_ATTRIBUTES NA,

5345:
5346: -- Any existence of response attribute constitutes a response required.
5347: cursor attrs(mnid in number) is
5348: select MA.NAME
5349: from WF_NOTIFICATION_ATTRIBUTES NA,
5350: WF_MESSAGE_ATTRIBUTES_VL MA,
5351: WF_NOTIFICATIONS N
5352: where N.NOTIFICATION_ID = mnid
5353: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID

Line 5418: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

5414: -- wf_xml.RemoveNotification(nid);
5415:
5416: --Bug 2283697
5417: --To raise an EVENT whenever DML operation is performed on
5418: --WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
5419: wf_event.AddParameterToList('NOTIFICATION_ID',nid,l_parameterlist);
5420: wf_event.AddParameterToList('RESPONDER',close.responder,l_parameterlist);
5421:
5422: -- AppSearch

Line 5859: WF_NOTIFICATION_ATTRIBUTES NA

5855: select NAME into aname from
5856: (select WMA.NAME
5857: from WF_NOTIFICATIONS WN,
5858: WF_MESSAGE_ATTRIBUTES WMA,
5859: WF_NOTIFICATION_ATTRIBUTES NA
5860: where WN.NOTIFICATION_ID = nid
5861: and wn.notification_id = na.notification_id
5862: and wma.name = na.name
5863: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 7067: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

7063: -- wf_xml.EnqueueNotification(nid);
7064:
7065: -- Bug 2283697
7066: -- To raise an EVENT whenever DML operation is performed on
7067: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7068: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7069: wf_event.AddParameterToList('ROLE', username, l_parameterlist);
7070: wf_event.AddParameterToList('GROUP_ID', nvl(l_groupId, nid), l_parameterlist);
7071: wf_event.addParameterToList('Q_CORRELATION_ID', l_messageType||':'||

Line 7545: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

7541: -- wf_xml.EnqueueNotification(nid);
7542:
7543: -- Bug 2283697
7544: -- To raise an EVENT whenever DML operation is performed on
7545: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7546: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7547:
7548: -- username MAY be a display name
7549: wf_event.AddParameterToList('ROLE', nvl(l_username, username), l_parameterlist);

Line 7704: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.

7700: -- wf_xml.EnqueueNotification(nid);
7701:
7702: -- Bug 2283697
7703: -- To raise an EVENT whenever DML operation is performed on
7704: -- WF_NOTIFICATIONS and WF_NOTIFICATION_ATTRIBUTES table.
7705: wf_event.AddParameterToList('NOTIFICATION_ID', nid, l_parameterlist);
7706: -- skilaru 12-MAR-04 In UpdateInfo2 username would be null in Answer mode
7707: -- to keep the behaviour same just pass null as ROLE..
7708: wf_event.AddParameterToList('ROLE', null, l_parameterlist);

Line 8169: FROM wf_notification_attributes

8165: if (l_note = '#WF_NOTE#') then
8166: begin
8167: SELECT text_value
8168: INTO l_note
8169: FROM wf_notification_attributes
8170: WHERE notification_id = l_comm_rec.h_notification_id
8171: AND name = 'WF_NOTE';
8172: exception
8173: when no_data_found then

Line 8419: WF_NOTIFICATION_ATTRIBUTES NA

8415: select NAME into aname from
8416: (select WMA.NAME
8417: from WF_NOTIFICATIONS WN,
8418: WF_MESSAGE_ATTRIBUTES WMA,
8419: WF_NOTIFICATION_ATTRIBUTES NA
8420: where WN.NOTIFICATION_ID = nid
8421: and wn.notification_id = na.notification_id
8422: and wma.name = na.name
8423: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 8572: from WF_NOTIFICATION_ATTRIBUTES WNA,

8568: lv_token_start number;
8569:
8570: cursor cur_hdr_region is
8571: select WNA.NAME, WNA.TEXT_VALUE
8572: from WF_NOTIFICATION_ATTRIBUTES WNA,
8573: WF_MESSAGE_ATTRIBUTES_VL WMA
8574: where WNA.NOTIFICATION_ID = nid
8575: and WMA.NAME = WNA.NAME
8576: and WMA.TYPE = 'DOCUMENT'

Line 8717: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

8713:
8714: -- Cursur to check for each message Attribute
8715: cursor cur_msg_attrs(nid number, msgToken varchar2) is
8716: select WNA.NAME, WNA.TEXT_VALUE, WMA.TYPE
8717: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
8718: WF_MESSAGE_ATTRIBUTES_VL WMA
8719: where WNA.NOTIFICATION_ID = nid
8720: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
8721: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

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

9380: is
9381: --Get the nids in curs_nid which have the attribute document_id
9382: cursor curs_nid(l_doc_id varchar2,l_item_type varchar2,l_item_key varchar2) is
9383: select wfn.notification_id
9384: from wf_item_activity_statuses wfas, wf_notifications wfn , wf_notification_attributes wfna
9385: where wfna.name = '#DOCUMENT_ID'
9386: and wfna.text_value = l_doc_id
9387: and wfas.item_type = l_item_type
9388: and wfas.item_key = l_item_key