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.35.12020000.12 2013/03/19 05:12:55 pshreera ship $ */
3: --+
4: --+ loadWorkflowAttributes
5: --+

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

573: end if;
574: if p_eventName is not null and p_eventName in ('INTVCRE','INTVUPD','APLFORJOB') then
575: if p_eventName in ('INTVCRE','INTVUPD') then
576: begin
577: l_intw_id := to_number(IRC_NOTIFICATION_WORKFLOW_PKG.getWFAttrValue(p_itemKey,'IRC_INTVW_ID'));
578: if l_intw_id is not null then
579: open getInterViewStatus(l_intw_id);
580: fetch getInterViewStatus into l_intw_status;
581: close getInterViewStatus;

Line 593: 'plsqlblob:irc_notification_workflow_pkg.attatchICDoc/'||p_itemKey||':'||p_notificationIdIn);

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;
596: if p_roleType <> 'CAND' then
597: open getDocIdList(l_person_id,l_doc_type);

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

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;
606: end if;
607: hr_utility.set_location('Exiting attatchDocument:'|| g_package||'.'||l_proc, 60);

Line 1028: end IRC_NOTIFICATION_WORKFLOW_PKG;

1024: hr_utility.set_location('Error:'|| g_package||'.'||l_proc, 50);
1025: hr_utility.set_location('Error:'|| sqlerrm, 50);
1026: end attatchICDoc;
1027: --+
1028: end IRC_NOTIFICATION_WORKFLOW_PKG;