DBA Data[Home] [Help]

APPS.FND_CONC_PRIVATE_UTILS dependencies on WF_NOTIFICATION

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

326:
327: begin
328:
329: if ( requrl is not NULL ) then
330: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
331: end if;
332:
333: wf_notification.setattrnumber(nid, 'REQID', req_id);
334: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));

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

329: if ( requrl is not NULL ) then
330: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
331: end if;
332:
333: wf_notification.setattrnumber(nid, 'REQID', req_id);
334: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
335: wf_notification.setattrtext(nid, 'PROGNAME', pname);
336: wf_notification.setattrdate(nid, 'TIME', completion);
337: wf_notification.setattrdate(nid, 'DATE', completion);

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

330: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
331: end if;
332:
333: wf_notification.setattrnumber(nid, 'REQID', req_id);
334: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
335: wf_notification.setattrtext(nid, 'PROGNAME', pname);
336: wf_notification.setattrdate(nid, 'TIME', completion);
337: wf_notification.setattrdate(nid, 'DATE', completion);
338: wf_notification.setattrtext(nid, 'SUBMITTER', user);

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

331: end if;
332:
333: wf_notification.setattrnumber(nid, 'REQID', req_id);
334: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
335: wf_notification.setattrtext(nid, 'PROGNAME', pname);
336: wf_notification.setattrdate(nid, 'TIME', completion);
337: wf_notification.setattrdate(nid, 'DATE', completion);
338: wf_notification.setattrtext(nid, 'SUBMITTER', user);
339: wf_notification.setattrtext(nid, '#FROM_ROLE', user);

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

332:
333: wf_notification.setattrnumber(nid, 'REQID', req_id);
334: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
335: wf_notification.setattrtext(nid, 'PROGNAME', pname);
336: wf_notification.setattrdate(nid, 'TIME', completion);
337: wf_notification.setattrdate(nid, 'DATE', completion);
338: wf_notification.setattrtext(nid, 'SUBMITTER', user);
339: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
340: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);

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

333: wf_notification.setattrnumber(nid, 'REQID', req_id);
334: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
335: wf_notification.setattrtext(nid, 'PROGNAME', pname);
336: wf_notification.setattrdate(nid, 'TIME', completion);
337: wf_notification.setattrdate(nid, 'DATE', completion);
338: wf_notification.setattrtext(nid, 'SUBMITTER', user);
339: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
340: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
341: wf_notification.denormalize_notification(nid);

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

334: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
335: wf_notification.setattrtext(nid, 'PROGNAME', pname);
336: wf_notification.setattrdate(nid, 'TIME', completion);
337: wf_notification.setattrdate(nid, 'DATE', completion);
338: wf_notification.setattrtext(nid, 'SUBMITTER', user);
339: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
340: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
341: wf_notification.denormalize_notification(nid);
342: exception

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

335: wf_notification.setattrtext(nid, 'PROGNAME', pname);
336: wf_notification.setattrdate(nid, 'TIME', completion);
337: wf_notification.setattrdate(nid, 'DATE', completion);
338: wf_notification.setattrtext(nid, 'SUBMITTER', user);
339: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
340: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
341: wf_notification.denormalize_notification(nid);
342: exception
343: when others then

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

336: wf_notification.setattrdate(nid, 'TIME', completion);
337: wf_notification.setattrdate(nid, 'DATE', completion);
338: wf_notification.setattrtext(nid, 'SUBMITTER', user);
339: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
340: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
341: wf_notification.denormalize_notification(nid);
342: exception
343: when others then
344: raise wf_error;

Line 341: wf_notification.denormalize_notification(nid);

337: wf_notification.setattrdate(nid, 'DATE', completion);
338: wf_notification.setattrtext(nid, 'SUBMITTER', user);
339: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
340: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
341: wf_notification.denormalize_notification(nid);
342: exception
343: when others then
344: raise wf_error;
345: end;

Line 379: from wf_notifications

375: notify_id number;
376:
377: cursor nids_cursor is
378: select notification_id
379: from wf_notifications
380: where group_id = nid;
381: -- code for bug 4172657 ends
382:
383: begin

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

434: fnd_profile.get('CONC_NOTIFY_GROUP', profbuf);
435:
436: begin
437: if profbuf = 'Y' then
438: nid := wf_notification.sendgroup(recip, msgtype, msgname);
439: open nids_cursor;
440: LOOP
441: fetch nids_cursor into notify_id;
442: -- Get a unique file name each time

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

451: end LOOP;
452:
453: close nids_cursor;
454: else
455: nid := wf_notification.send(recip, msgtype, msgname);
456:
457: -- Get a unique file name each time
458: if (send_url) then
459: requrl := fnd_webfile.get_url( fnd_webfile.request_out,