DBA Data[Home] [Help]

APPS.WF_PUB_ICC dependencies on WF_PUB_ICC

Line 1: PACKAGE BODY WF_PUB_ICC AS

1: PACKAGE BODY WF_PUB_ICC AS
2: /* $Header: EGOPICNB.pls 120.0.12020000.1 2013/01/09 10:43:57 jewen noship $ */
3: function CONVERT_PERFORMER(
4: p_mail_to varchar2
5: )RETURN VARCHAR2

Line 74: *start workflow process 'WF_PUB_ICC_NOTIFICATION' to send notification.

70: /**
71: *This custom rule function was used to get subscription parameters and set value for item attributes of
72: *item type 'WFPUBICC'.
73: *If the systems to which the icc is published contain the system defined in susbcription paramter 'PUB_SYSTEM',
74: *start workflow process 'WF_PUB_ICC_NOTIFICATION' to send notification.
75: */
76: FUNCTION SEND_NOTIFICATION(p_subscription in RAW,
77: p_event in out NOCOPY WF_EVENT_T)return varchar2
78: IS

Line 86: wfname varchar2(30) :='WF_PUB_ICC_NOTIFICATION';

82: l_wf_admin VARCHAR2(320);
83: l_system VARCHAR2(30);
84: l_subparams varchar2(4000);
85: wftype varchar2(15) :='WFPUBICC';
86: wfname varchar2(30) :='WF_PUB_ICC_NOTIFICATION';
87: BEGIN
88: l_batch_id:=p_event.GetValueForParameter('batch_id');
89:
90: /**

Line 122: wf_core.context('WF_PUB_ICC',

118: end if;
119: return('SUCCESS');
120: EXCEPTION
121: WHEN OTHERS THEN
122: wf_core.context('WF_PUB_ICC',
123: 'SEND_NOTIFICATION',
124: p_event.geteventname(),
125: p_subscription,
126: SQLERRM);

Line 323: END WF_PUB_ICC;

319: itemtype, itemkey, to_char(actid), funcmode,SQLERRM);
320: raise;
321: END UPDATE_SYS_STATUS;
322:
323: END WF_PUB_ICC;
324: