DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on WF_NOTIFICATION

Line 591: wf_notification.setAttrText(p_notificationIdIn,

587: when others then
588: hr_utility.set_location('error:'||sqlerrm, 30);
589: end;
590: if l_intw_status is not null and l_intw_status in ('CONFIRMED','RESCHEDULED') then
591: wf_notification.setAttrText(p_notificationIdIn,
592: 'IRC_CAL_ATTACHMENT',
593: 'plsqlblob:irc_notification_workflow_pkg.attatchICDoc/'||p_itemKey||':'||p_notificationIdIn);
594: end if;
595: end if;

Line 601: wf_notification.setAttrText(p_notificationIdIn,

597: open getDocIdList(l_person_id,l_doc_type);
598: fetch getDocIdList bulk collect into l_doc_ids;
599: close getDocIdList;
600: for i in 1..l_doc_ids.count loop
601: wf_notification.setAttrText(p_notificationIdIn,
602: 'IRC_ATTACHMENT_'||to_char(i),
603: 'plsqlblob:irc_notification_workflow_pkg.attatchDoc/'||l_doc_ids(i));
604: end loop;
605: end if;

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

796:
797: if ((l_person_type = 'CAND') and (l_eventName = 'APLSTACHG') and (l_oldExtStatus = l_newExtStatus)) then
798: null; --no operation
799: else
800: l_notificationId:=wf_notification.send( l_nextApprovers(1).name
801: , l_message_type
802: , l_ntf_message_type
803: );
804: end if;

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

804: end if;
805:
806:
807: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
808: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
809: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
810: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_textMessageBody);
811: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_htmlMessageBody);
812: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then

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

805:
806:
807: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
808: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
809: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
810: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_textMessageBody);
811: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_htmlMessageBody);
812: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then
813: l_candidatePersonId := wf_engine.GetItemAttrText( itemtype => p_itemType

Line 810: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_textMessageBody);

806:
807: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
808: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
809: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
810: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_textMessageBody);
811: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_htmlMessageBody);
812: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then
813: l_candidatePersonId := wf_engine.GetItemAttrText( itemtype => p_itemType
814: , itemkey => p_itemKey

Line 811: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_htmlMessageBody);

807: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
808: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
809: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
810: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_textMessageBody);
811: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_htmlMessageBody);
812: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then
813: l_candidatePersonId := wf_engine.GetItemAttrText( itemtype => p_itemType
814: , itemkey => p_itemKey
815: , aname => 'IRC_CAND_PER_ID');

Line 818: wf_notification.denormalize_notification(l_notificationId);

814: , itemkey => p_itemKey
815: , aname => 'IRC_CAND_PER_ID');
816: attachDocument(l_notificationId,l_candidatePersonId,l_eventName,p_itemKey,l_person_type);
817: end if;
818: wf_notification.denormalize_notification(l_notificationId);
819: if l_dft_lang <> l_user_lang then
820: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
821: end if;
822: result := 'COMPLETE:IRC_E';

Line 1004: l_subject := wf_notification.GetAttrText (nid => l_notification_id, aname => 'SUBJECT',ignore_notfound => true);

1000: if l_time_zone_code is null then
1001: l_ignore_time_zone := true;
1002: end if;
1003: end if;
1004: l_subject := wf_notification.GetAttrText (nid => l_notification_id, aname => 'SUBJECT',ignore_notfound => true);
1005: --l_description := wf_notification.GetAttrText (nid => l_notification_id, aname => 'TEXT_BODY',ignore_notfound => true);
1006: hr_utility.set_location('Contructing the ics file', 20);
1007: per_calendar_util.calendar_generate_ical
1008: (DTSTARTDATE => l_start_date

Line 1005: --l_description := wf_notification.GetAttrText (nid => l_notification_id, aname => 'TEXT_BODY',ignore_notfound => true);

1001: l_ignore_time_zone := true;
1002: end if;
1003: end if;
1004: l_subject := wf_notification.GetAttrText (nid => l_notification_id, aname => 'SUBJECT',ignore_notfound => true);
1005: --l_description := wf_notification.GetAttrText (nid => l_notification_id, aname => 'TEXT_BODY',ignore_notfound => true);
1006: hr_utility.set_location('Contructing the ics file', 20);
1007: per_calendar_util.calendar_generate_ical
1008: (DTSTARTDATE => l_start_date
1009: ,DTENDDATE => l_end_date