DBA Data[Home] [Help]

APPS.WF_ENGINE dependencies on WF_EVENT

Line 1063: event in wf_event_t)

1059: procedure SetItemAttrEvent(
1060: itemtype in varchar2,
1061: itemkey in varchar2,
1062: name in varchar2,
1063: event in wf_event_t)
1064: is
1065: nvalue Number;
1066: begin
1067: -- Check Arguments

Line 1993: return wf_event_t

1989: function GetItemAttrEvent(
1990: itemtype in varchar2,
1991: itemkey in varchar2,
1992: name in varchar2)
1993: return wf_event_t
1994: is
1995: lvalue wf_event_t;
1996: l_value number;
1997: begin

Line 1995: lvalue wf_event_t;

1991: itemkey in varchar2,
1992: name in varchar2)
1993: return wf_event_t
1994: is
1995: lvalue wf_event_t;
1996: l_value number;
1997: begin
1998: -- Check Arguments
1999: if ((itemtype is null) or

Line 2024: Wf_Event_T.Initialize(lvalue);

2020: and NAME = GetItemAttrEvent.name;
2021:
2022: --Initialization done only if event_value is null
2023: if lvalue is null then
2024: Wf_Event_T.Initialize(lvalue);
2025: end if;
2026: return(lvalue);
2027:
2028: exception

Line 2044: Wf_Event_T.Initialize(lvalue);

2040: from WF_ITEM_ATTRIBUTES WIA
2041: where WIA.ITEM_TYPE = GetItemAttrEvent.itemtype
2042: and WIA.NAME = GetItemAttrEvent.name;
2043:
2044: Wf_Event_T.Initialize(lvalue);
2045:
2046: return(lvalue);
2047: else
2048: raise no_data_found;

Line 2799: return wf_event_t

2795: itemtype in varchar2,
2796: itemkey in varchar2,
2797: actid in number,
2798: name in varchar2)
2799: return wf_event_t
2800: is
2801: waavIND NUMBER;
2802: status PLS_INTEGER;
2803:

Line 3141: event_value in out nocopy wf_event_t)

3137: attr_type in varchar2,
3138: text_value in out NOCOPY varchar2,
3139: number_value in out NOCOPY number,
3140: date_value in out NOCOPY date,
3141: event_value in out nocopy wf_event_t)
3142: is
3143: firstcolon pls_integer;
3144: secondcolon pls_integer;
3145:

Line 3422: event_value wf_event_t;

3418: text_value in out NOCOPY varchar2,
3419: number_value in out NOCOPY number,
3420: date_value in out NOCOPY date)
3421: is
3422: event_value wf_event_t;
3423: begin
3424:
3425: Wf_Engine.CB(command, context, attr_name, attr_type, text_value, number_value, date_value, event_value);
3426:

Line 4025: l_event wf_event_t; -- Buffer for initing event itemattrs

4021: actdate date;
4022: typ varchar2(8);
4023: rootid pls_integer;
4024: status varchar2(8);
4025: l_event wf_event_t; -- Buffer for initing event itemattrs
4026:
4027: -- All event item attrs to be initialized
4028: -- Initialization is now deferred until GetItemAttrEvent
4029: /* cursor evtcurs is

Line 4135: Wf_Event_T.Initialize(l_event);

4131:
4132: -- Initialize all EVENT-type item attributes
4133: -- Not done here, it is deferred until GetItemAttrEvent
4134: /* for evtattr in evtcurs loop
4135: Wf_Event_T.Initialize(l_event);
4136: Wf_Engine.SetItemAttrEvent(
4137: itemtype => itemtype,
4138: itemkey => itemkey,
4139: name => evtattr.name,

Line 4536: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);

4532: end loop;
4533:
4534: --Include the information of the aborted process in the events
4535: --parameter list.
4536: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
4537: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
4538: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4539: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4540:

Line 4537: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);

4533:
4534: --Include the information of the aborted process in the events
4535: --parameter list.
4536: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
4537: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
4538: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4539: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4540:
4541: -- Raise the event

Line 4538: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);

4534: --Include the information of the aborted process in the events
4535: --parameter list.
4536: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
4537: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
4538: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4539: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4540:
4541: -- Raise the event
4542: wf_event.Raise(p_event_name => 'oracle.apps.wf.engine.abort',

Line 4539: wf_event.AddParameterToList('RESULT', result, l_parameterlist);

4535: --parameter list.
4536: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
4537: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
4538: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4539: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4540:
4541: -- Raise the event
4542: wf_event.Raise(p_event_name => 'oracle.apps.wf.engine.abort',
4543: p_event_key => itemkey,

Line 4542: wf_event.Raise(p_event_name => 'oracle.apps.wf.engine.abort',

4538: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4539: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4540:
4541: -- Raise the event
4542: wf_event.Raise(p_event_name => 'oracle.apps.wf.engine.abort',
4543: p_event_key => itemkey,
4544: p_parameters => l_parameterlist);
4545:
4546: exception

Line 6075: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);

6071: Wf_Item_Activity_Status.Audit(itemtype, itemkey, actid, upper(command), null);
6072:
6073: --Pass the signature of the handle error API in the
6074: --parameter list
6075: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
6076: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
6077: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);
6078: if (result is NOT NULL) then
6079: wf_event.AddParameterToList('RESULT', result, l_parameterlist);

Line 6076: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);

6072:
6073: --Pass the signature of the handle error API in the
6074: --parameter list
6075: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
6076: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
6077: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);
6078: if (result is NOT NULL) then
6079: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
6080: end if;

Line 6077: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);

6073: --Pass the signature of the handle error API in the
6074: --parameter list
6075: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
6076: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
6077: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);
6078: if (result is NOT NULL) then
6079: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
6080: end if;
6081:

Line 6079: wf_event.AddParameterToList('RESULT', result, l_parameterlist);

6075: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
6076: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
6077: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);
6078: if (result is NOT NULL) then
6079: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
6080: end if;
6081:
6082: -- Raise the event
6083: wf_event.Raise(p_event_name => event_name,

Line 6083: wf_event.Raise(p_event_name => event_name,

6079: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
6080: end if;
6081:
6082: -- Raise the event
6083: wf_event.Raise(p_event_name => event_name,
6084: p_event_key => itemkey,
6085: p_parameters => l_parameterlist);
6086:
6087: exception

Line 6647: event_message in wf_event_t)

6643: procedure Event(
6644: itemtype in varchar2,
6645: itemkey in varchar2,
6646: process_name in varchar2,
6647: event_message in wf_event_t)
6648: is
6649: event_name varchar2(240);
6650: actdate date; -- Active date of item
6651: root varchar2(30); -- Root process name

Line 6680: FROM WF_EVENTS WE

6676: AND WA.DIRECTION = 'RECEIVE'
6677: AND (WA.EVENT_NAME is null
6678: OR WA.EVENT_NAME in
6679: (SELECT WE.NAME -- Single events
6680: FROM WF_EVENTS WE
6681: WHERE WE.TYPE = 'EVENT'
6682: AND WE.NAME = event.event_name
6683: UNION ALL
6684: SELECT GRP.NAME -- Groups containing event

Line 6685: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR

6681: WHERE WE.TYPE = 'EVENT'
6682: AND WE.NAME = event.event_name
6683: UNION ALL
6684: SELECT GRP.NAME -- Groups containing event
6685: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR
6686: WHERE GRP.TYPE = 'GROUP'
6687: AND GRP.GUID = WEG.GROUP_GUID
6688: AND WEG.MEMBER_GUID = MBR.GUID
6689: AND MBR.NAME = event.event_name));

Line 6889: event_message in wf_event_t)

6885: -- IN
6886: -- event_message - Event message payload
6887: --
6888: procedure Event2(
6889: event_message in wf_event_t)
6890: is
6891: event_name varchar2(240);
6892: actdate date; -- Active date of item
6893: root varchar2(30); -- Root process name

Line 6916: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR

6912: WA.EVENT_NAME = event2.event_name OR
6913: EXISTS
6914: (
6915: SELECT null -- Groups containing event
6916: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR
6917: WHERE GRP.TYPE = 'GROUP'
6918: AND GRP.GUID = WEG.GROUP_GUID
6919: AND WEG.MEMBER_GUID = MBR.GUID
6920: AND MBR.NAME = event2.event_name