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 4040: l_event wf_event_t; -- Buffer for initing event itemattrs

4036: actdate date;
4037: typ varchar2(8);
4038: rootid pls_integer;
4039: status varchar2(8);
4040: l_event wf_event_t; -- Buffer for initing event itemattrs
4041: l_pkg_name varchar2(20) := 'WF_ENGINE';
4042: l_prc_name varchar2(20) := '.CreateProcess';
4043:
4044: -- All event item attrs to be initialized

Line 4182: Wf_Event_T.Initialize(l_event);

4178:
4179: -- Initialize all EVENT-type item attributes
4180: -- Not done here, it is deferred until GetItemAttrEvent
4181: /* for evtattr in evtcurs loop
4182: Wf_Event_T.Initialize(l_event);
4183: Wf_Engine.SetItemAttrEvent(
4184: itemtype => itemtype,
4185: itemkey => itemkey,
4186: name => evtattr.name,

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

4581: end loop;
4582:
4583: --Include the information of the aborted process in the events
4584: --parameter list.
4585: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
4586: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
4587: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4588: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4589:

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

4582:
4583: --Include the information of the aborted process in the events
4584: --parameter list.
4585: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
4586: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
4587: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4588: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4589:
4590: -- Raise the event

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

4583: --Include the information of the aborted process in the events
4584: --parameter list.
4585: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
4586: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
4587: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4588: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4589:
4590: -- Raise the event
4591: wf_event.Raise(p_event_name => 'oracle.apps.wf.engine.abort',

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

4584: --parameter list.
4585: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
4586: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
4587: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4588: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4589:
4590: -- Raise the event
4591: wf_event.Raise(p_event_name => 'oracle.apps.wf.engine.abort',
4592: p_event_key => itemkey,

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

4587: wf_event.AddParameterToList('PROCESS', process, l_parameterlist);
4588: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
4589:
4590: -- Raise the event
4591: wf_event.Raise(p_event_name => 'oracle.apps.wf.engine.abort',
4592: p_event_key => itemkey,
4593: p_parameters => l_parameterlist);
4594:
4595: exception

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

6137: Wf_Item_Activity_Status.Audit(itemtype, itemkey, actid, upper(command), null);
6138:
6139: --Pass the signature of the handle error API in the
6140: --parameter list
6141: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
6142: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
6143: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);
6144: if (result is NOT NULL) then
6145: wf_event.AddParameterToList('RESULT', result, l_parameterlist);

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

6138:
6139: --Pass the signature of the handle error API in the
6140: --parameter list
6141: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
6142: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
6143: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);
6144: if (result is NOT NULL) then
6145: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
6146: end if;

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

6139: --Pass the signature of the handle error API in the
6140: --parameter list
6141: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
6142: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
6143: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);
6144: if (result is NOT NULL) then
6145: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
6146: end if;
6147:

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

6141: wf_event.AddParameterToList('ITMETYPE', itemtype, l_parameterlist);
6142: wf_event.AddParameterToList('ITEMKEY', itemkey, l_parameterlist);
6143: wf_event.AddParameterToList('ACTIVITY', activity, l_parameterlist);
6144: if (result is NOT NULL) then
6145: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
6146: end if;
6147:
6148: -- Raise the event
6149: wf_event.Raise(p_event_name => event_name,

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

6145: wf_event.AddParameterToList('RESULT', result, l_parameterlist);
6146: end if;
6147:
6148: -- Raise the event
6149: wf_event.Raise(p_event_name => event_name,
6150: p_event_key => itemkey,
6151: p_parameters => l_parameterlist);
6152:
6153: exception

Line 6716: event_message in wf_event_t)

6712: procedure Event(
6713: itemtype in varchar2,
6714: itemkey in varchar2,
6715: process_name in varchar2,
6716: event_message in wf_event_t)
6717: is
6718: event_name varchar2(240);
6719: actdate date; -- Active date of item
6720: root varchar2(30); -- Root process name

Line 6749: FROM WF_EVENTS WE

6745: AND WA.DIRECTION = 'RECEIVE'
6746: AND (WA.EVENT_NAME is null
6747: OR WA.EVENT_NAME in
6748: (SELECT WE.NAME -- Single events
6749: FROM WF_EVENTS WE
6750: WHERE WE.TYPE = 'EVENT'
6751: AND WE.NAME = event.event_name
6752: UNION ALL
6753: SELECT GRP.NAME -- Groups containing event

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

6750: WHERE WE.TYPE = 'EVENT'
6751: AND WE.NAME = event.event_name
6752: UNION ALL
6753: SELECT GRP.NAME -- Groups containing event
6754: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR
6755: WHERE GRP.TYPE = 'GROUP'
6756: AND GRP.GUID = WEG.GROUP_GUID
6757: AND WEG.MEMBER_GUID = MBR.GUID
6758: AND MBR.NAME = event.event_name));

Line 6959: event_message in wf_event_t)

6955: -- IN
6956: -- event_message - Event message payload
6957: --
6958: procedure Event2(
6959: event_message in wf_event_t)
6960: is
6961: event_name varchar2(240);
6962: actdate date; -- Active date of item
6963: root varchar2(30); -- Root process name

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

6982: WA.EVENT_NAME = event2.event_name OR
6983: EXISTS
6984: (
6985: SELECT null -- Groups containing event
6986: FROM WF_EVENTS GRP, WF_EVENT_GROUPS WEG, WF_EVENTS MBR
6987: WHERE GRP.TYPE = 'GROUP'
6988: AND GRP.GUID = WEG.GROUP_GUID
6989: AND WEG.MEMBER_GUID = MBR.GUID
6990: AND MBR.NAME = event2.event_name