DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on WF_NOTIFICATION

Line 410: wf_notification.setAttrText(p_notificationIdIn,

406: open getDocIdList(l_person_id,l_doc_type);
407: fetch getDocIdList bulk collect into l_doc_ids;
408: close getDocIdList;
409: for i in 1..l_doc_ids.count loop
410: wf_notification.setAttrText(p_notificationIdIn,
411: 'IRC_ATTACHMENT_'||to_char(i),
412: 'plsqlblob:irc_notification_workflow_pkg.attatchDoc/'||l_doc_ids(i));
413: end loop;
414: end if;

Line 532: l_notificationId:=wf_notification.send( l_nextApprovers(1).name

528: l_ntf_message_type := 'IRC_MESSAGE_WITH_ATTACHMENT';
529: else
530: l_ntf_message_type := 'IRC_MESSAGE';
531: end if;
532: l_notificationId:=wf_notification.send( l_nextApprovers(1).name
533: , l_message_type
534: , l_ntf_message_type
535: );
536: hr_utility.set_location('Notification ID : ' || l_notificationId,180);

Line 537: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');

533: , l_message_type
534: , l_ntf_message_type
535: );
536: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
537: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
538: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
539: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_messageBody);
540: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_messageBody);
541: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then

Line 538: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);

534: , l_ntf_message_type
535: );
536: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
537: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
538: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
539: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_messageBody);
540: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_messageBody);
541: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then
542: l_candidatePersonId := wf_engine.GetItemAttrText( itemtype => p_itemType

Line 539: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_messageBody);

535: );
536: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
537: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
538: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
539: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_messageBody);
540: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_messageBody);
541: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then
542: l_candidatePersonId := wf_engine.GetItemAttrText( itemtype => p_itemType
543: , itemkey => p_itemKey

Line 540: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_messageBody);

536: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
537: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
538: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
539: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_messageBody);
540: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_messageBody);
541: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then
542: l_candidatePersonId := wf_engine.GetItemAttrText( itemtype => p_itemType
543: , itemkey => p_itemKey
544: , aname => 'IRC_CAND_PER_ID');

Line 547: wf_notification.denormalize_notification(l_notificationId);

543: , itemkey => p_itemKey
544: , aname => 'IRC_CAND_PER_ID');
545: attachDocument(l_notificationId,l_candidatePersonId,l_eventName,p_itemKey);
546: end if;
547: wf_notification.denormalize_notification(l_notificationId);
548: result := 'COMPLETE:IRC_E';
549: hr_utility.set_location('Recipients Exist - Exiting:'|| g_package||'.'||l_proc, 200);
550: end if;
551: else