APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on IRC_NOTIFICATION_WORKFLOW_PKG

Line 1: PACKAGE BODY IRC_NOTIFICATION_WORKFLOW_PKG as

1: PACKAGE BODY IRC_NOTIFICATION_WORKFLOW_PKG as
2: /* $Header: irntfwfl.pkb 120.14.12010000.4 2009/01/19 13:48:31 prasashe ship $ */
3: --+
4: --+ loadWorkflowAttributes
5: --+

Line 392: l_intw_id := to_number(IRC_NOTIFICATION_WORKFLOW_PKG.getWFAttrValue(p_itemKey,'IRC_INTVW_ID'));

388: end if;
389: if p_eventName is not null and p_eventName in ('INTVCRE','INTVUPD','APLFORJOB') then
390: if p_eventName in ('INTVCRE','INTVUPD') then
391: begin
392: l_intw_id := to_number(IRC_NOTIFICATION_WORKFLOW_PKG.getWFAttrValue(p_itemKey,'IRC_INTVW_ID'));
393: if l_intw_id is not null then
394: open getInterViewStatus(l_intw_id);
395: fetch getInterViewStatus into l_intw_status;
396: close getInterViewStatus;

Line 412: 'plsqlblob:irc_notification_workflow_pkg.attatchDoc/'||l_doc_ids(i));

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;
415: hr_utility.set_location('Exiting attatchDocument:'|| g_package||'.'||l_proc, 60);
416: exception

Line 668: end IRC_NOTIFICATION_WORKFLOW_PKG;

664: ,p_documentType in out nocopy varchar2) is
665: begin
666: p_document := p_documentId;
667: end getDocument;
668: end IRC_NOTIFICATION_WORKFLOW_PKG;