DBA Data[Home] [Help]

APPS.FND_CONC_PRIVATE_UTILS dependencies on WF_NOTIFICATION

Line 299: wf_notification.setattrtext(nid, 'REQ_URL', requrl);

295:
296: begin
297:
298: if ( requrl is not NULL ) then
299: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
300: end if;
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));

Line 302: wf_notification.setattrnumber(nid, 'REQID', req_id);

298: if ( requrl is not NULL ) then
299: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
300: end if;
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);

Line 303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));

299: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
300: end if;
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);

Line 304: wf_notification.setattrtext(nid, 'PROGNAME', pname);

300: end if;
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);

Line 305: wf_notification.setattrdate(nid, 'TIME', completion);

301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);

Line 306: wf_notification.setattrdate(nid, 'DATE', completion);

302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);

Line 307: wf_notification.setattrtext(nid, 'SUBMITTER', user);

303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
311: exception

Line 308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);

304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
311: exception
312: when others then

Line 309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);

305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
311: exception
312: when others then
313: raise wf_error;

Line 310: wf_notification.denormalize_notification(nid);

306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
311: exception
312: when others then
313: raise wf_error;
314: end;

Line 348: from wf_notifications

344: notify_id number;
345:
346: cursor nids_cursor is
347: select notification_id
348: from wf_notifications
349: where group_id = nid;
350: -- code for bug 4172657 ends
351:
352: begin

Line 407: nid := wf_notification.sendgroup(recip, msgtype, msgname);

403: fnd_profile.get('CONC_NOTIFY_GROUP', profbuf);
404:
405: begin
406: if profbuf = 'Y' then
407: nid := wf_notification.sendgroup(recip, msgtype, msgname);
408: open nids_cursor;
409: LOOP
410: fetch nids_cursor into notify_id;
411: -- Get a unique file name each time

Line 424: nid := wf_notification.send(recip, msgtype, msgname);

420: end LOOP;
421:
422: close nids_cursor;
423: else
424: nid := wf_notification.send(recip, msgtype, msgname);
425:
426: -- Get a unique file name each time
427: if (send_url) then
428: requrl := fnd_webfile.get_url( fnd_webfile.request_out,