eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_ITEM_ACTIVITY_STATUS dependencies on WF_ITEM_ACTIVITY_STATUS

Line 1: package body WF_ITEM_ACTIVITY_STATUS as

1: package body WF_ITEM_ACTIVITY_STATUS as
2: /* $Header: wfengb.pls 120.25.12010000.3 2008/10/28 15:19:48 alepe ship $ */
3:
4: -- Runtime cache
5: c_itemtype varchar2(8);

Line 29: wf_item_activity_status.c_itemtype := '';

25: --
26: procedure ClearCache
27: is
28: begin
29: wf_item_activity_status.c_itemtype := '';
30: wf_item_activity_status.c_itemkey := '';
31: wf_item_activity_status.c_actid := '';
32: wf_item_activity_status.c_status := '';
33: wf_item_activity_status.c_result := '';

Line 30: wf_item_activity_status.c_itemkey := '';

26: procedure ClearCache
27: is
28: begin
29: wf_item_activity_status.c_itemtype := '';
30: wf_item_activity_status.c_itemkey := '';
31: wf_item_activity_status.c_actid := '';
32: wf_item_activity_status.c_status := '';
33: wf_item_activity_status.c_result := '';
34: wf_item_activity_status.c_assigned_user := '';

Line 31: wf_item_activity_status.c_actid := '';

27: is
28: begin
29: wf_item_activity_status.c_itemtype := '';
30: wf_item_activity_status.c_itemkey := '';
31: wf_item_activity_status.c_actid := '';
32: wf_item_activity_status.c_status := '';
33: wf_item_activity_status.c_result := '';
34: wf_item_activity_status.c_assigned_user := '';
35: wf_item_activity_status.c_notification_id := '';

Line 32: wf_item_activity_status.c_status := '';

28: begin
29: wf_item_activity_status.c_itemtype := '';
30: wf_item_activity_status.c_itemkey := '';
31: wf_item_activity_status.c_actid := '';
32: wf_item_activity_status.c_status := '';
33: wf_item_activity_status.c_result := '';
34: wf_item_activity_status.c_assigned_user := '';
35: wf_item_activity_status.c_notification_id := '';
36: wf_item_activity_status.c_begindate := to_date(NULL);

Line 33: wf_item_activity_status.c_result := '';

29: wf_item_activity_status.c_itemtype := '';
30: wf_item_activity_status.c_itemkey := '';
31: wf_item_activity_status.c_actid := '';
32: wf_item_activity_status.c_status := '';
33: wf_item_activity_status.c_result := '';
34: wf_item_activity_status.c_assigned_user := '';
35: wf_item_activity_status.c_notification_id := '';
36: wf_item_activity_status.c_begindate := to_date(NULL);
37: wf_item_activity_status.c_enddate := to_date(NULL);

Line 34: wf_item_activity_status.c_assigned_user := '';

30: wf_item_activity_status.c_itemkey := '';
31: wf_item_activity_status.c_actid := '';
32: wf_item_activity_status.c_status := '';
33: wf_item_activity_status.c_result := '';
34: wf_item_activity_status.c_assigned_user := '';
35: wf_item_activity_status.c_notification_id := '';
36: wf_item_activity_status.c_begindate := to_date(NULL);
37: wf_item_activity_status.c_enddate := to_date(NULL);
38: wf_item_activity_status.c_duedate := to_date(NULL);

Line 35: wf_item_activity_status.c_notification_id := '';

31: wf_item_activity_status.c_actid := '';
32: wf_item_activity_status.c_status := '';
33: wf_item_activity_status.c_result := '';
34: wf_item_activity_status.c_assigned_user := '';
35: wf_item_activity_status.c_notification_id := '';
36: wf_item_activity_status.c_begindate := to_date(NULL);
37: wf_item_activity_status.c_enddate := to_date(NULL);
38: wf_item_activity_status.c_duedate := to_date(NULL);
39: wf_item_activity_status.c_errname := '';

Line 36: wf_item_activity_status.c_begindate := to_date(NULL);

32: wf_item_activity_status.c_status := '';
33: wf_item_activity_status.c_result := '';
34: wf_item_activity_status.c_assigned_user := '';
35: wf_item_activity_status.c_notification_id := '';
36: wf_item_activity_status.c_begindate := to_date(NULL);
37: wf_item_activity_status.c_enddate := to_date(NULL);
38: wf_item_activity_status.c_duedate := to_date(NULL);
39: wf_item_activity_status.c_errname := '';
40: wf_item_activity_status.c_errmsg := '';

Line 37: wf_item_activity_status.c_enddate := to_date(NULL);

33: wf_item_activity_status.c_result := '';
34: wf_item_activity_status.c_assigned_user := '';
35: wf_item_activity_status.c_notification_id := '';
36: wf_item_activity_status.c_begindate := to_date(NULL);
37: wf_item_activity_status.c_enddate := to_date(NULL);
38: wf_item_activity_status.c_duedate := to_date(NULL);
39: wf_item_activity_status.c_errname := '';
40: wf_item_activity_status.c_errmsg := '';
41: wf_item_activity_status.c_errstack := '';

Line 38: wf_item_activity_status.c_duedate := to_date(NULL);

34: wf_item_activity_status.c_assigned_user := '';
35: wf_item_activity_status.c_notification_id := '';
36: wf_item_activity_status.c_begindate := to_date(NULL);
37: wf_item_activity_status.c_enddate := to_date(NULL);
38: wf_item_activity_status.c_duedate := to_date(NULL);
39: wf_item_activity_status.c_errname := '';
40: wf_item_activity_status.c_errmsg := '';
41: wf_item_activity_status.c_errstack := '';
42: exception

Line 39: wf_item_activity_status.c_errname := '';

35: wf_item_activity_status.c_notification_id := '';
36: wf_item_activity_status.c_begindate := to_date(NULL);
37: wf_item_activity_status.c_enddate := to_date(NULL);
38: wf_item_activity_status.c_duedate := to_date(NULL);
39: wf_item_activity_status.c_errname := '';
40: wf_item_activity_status.c_errmsg := '';
41: wf_item_activity_status.c_errstack := '';
42: exception
43: when others then

Line 40: wf_item_activity_status.c_errmsg := '';

36: wf_item_activity_status.c_begindate := to_date(NULL);
37: wf_item_activity_status.c_enddate := to_date(NULL);
38: wf_item_activity_status.c_duedate := to_date(NULL);
39: wf_item_activity_status.c_errname := '';
40: wf_item_activity_status.c_errmsg := '';
41: wf_item_activity_status.c_errstack := '';
42: exception
43: when others then
44: Wf_Core.Context('Wf_Item_Activity_Status', 'ClearCache');

Line 41: wf_item_activity_status.c_errstack := '';

37: wf_item_activity_status.c_enddate := to_date(NULL);
38: wf_item_activity_status.c_duedate := to_date(NULL);
39: wf_item_activity_status.c_errname := '';
40: wf_item_activity_status.c_errmsg := '';
41: wf_item_activity_status.c_errstack := '';
42: exception
43: when others then
44: Wf_Core.Context('Wf_Item_Activity_Status', 'ClearCache');
45: raise;

Line 44: Wf_Core.Context('Wf_Item_Activity_Status', 'ClearCache');

40: wf_item_activity_status.c_errmsg := '';
41: wf_item_activity_status.c_errstack := '';
42: exception
43: when others then
44: Wf_Core.Context('Wf_Item_Activity_Status', 'ClearCache');
45: raise;
46: end ClearCache;
47:
48: --

Line 61: if ((itemtype = wf_item_activity_status.c_itemtype) and

57:
58: is
59: begin
60: -- Check for refresh
61: if ((itemtype = wf_item_activity_status.c_itemtype) and
62: (itemkey = wf_item_activity_status.c_itemkey) and
63: (actid = wf_item_activity_status.c_actid)) then
64: return;
65: end if;

Line 62: (itemkey = wf_item_activity_status.c_itemkey) and

58: is
59: begin
60: -- Check for refresh
61: if ((itemtype = wf_item_activity_status.c_itemtype) and
62: (itemkey = wf_item_activity_status.c_itemkey) and
63: (actid = wf_item_activity_status.c_actid)) then
64: return;
65: end if;
66:

Line 63: (actid = wf_item_activity_status.c_actid)) then

59: begin
60: -- Check for refresh
61: if ((itemtype = wf_item_activity_status.c_itemtype) and
62: (itemkey = wf_item_activity_status.c_itemkey) and
63: (actid = wf_item_activity_status.c_actid)) then
64: return;
65: end if;
66:
67: -- SYNCHMODE: Error if this is not current activity.

Line 83: into wf_item_activity_status.c_status, wf_item_activity_status.c_result,

79: WIAS.BEGIN_DATE, WIAS.END_DATE,
80: WIAS.DUE_DATE,
81: WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE,
82: WIAS.ERROR_STACK
83: into wf_item_activity_status.c_status, wf_item_activity_status.c_result,
84: wf_item_activity_status.c_assigned_user,
85: wf_item_activity_status.c_notification_id,
86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,
87: wf_item_activity_status.c_duedate,

Line 84: wf_item_activity_status.c_assigned_user,

80: WIAS.DUE_DATE,
81: WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE,
82: WIAS.ERROR_STACK
83: into wf_item_activity_status.c_status, wf_item_activity_status.c_result,
84: wf_item_activity_status.c_assigned_user,
85: wf_item_activity_status.c_notification_id,
86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,
87: wf_item_activity_status.c_duedate,
88: wf_item_activity_status.c_errname, wf_item_activity_status.c_errmsg,

Line 85: wf_item_activity_status.c_notification_id,

81: WIAS.ERROR_NAME, WIAS.ERROR_MESSAGE,
82: WIAS.ERROR_STACK
83: into wf_item_activity_status.c_status, wf_item_activity_status.c_result,
84: wf_item_activity_status.c_assigned_user,
85: wf_item_activity_status.c_notification_id,
86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,
87: wf_item_activity_status.c_duedate,
88: wf_item_activity_status.c_errname, wf_item_activity_status.c_errmsg,
89: wf_item_activity_status.c_errstack

Line 86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,

82: WIAS.ERROR_STACK
83: into wf_item_activity_status.c_status, wf_item_activity_status.c_result,
84: wf_item_activity_status.c_assigned_user,
85: wf_item_activity_status.c_notification_id,
86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,
87: wf_item_activity_status.c_duedate,
88: wf_item_activity_status.c_errname, wf_item_activity_status.c_errmsg,
89: wf_item_activity_status.c_errstack
90: from WF_ITEM_ACTIVITY_STATUSES WIAS

Line 87: wf_item_activity_status.c_duedate,

83: into wf_item_activity_status.c_status, wf_item_activity_status.c_result,
84: wf_item_activity_status.c_assigned_user,
85: wf_item_activity_status.c_notification_id,
86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,
87: wf_item_activity_status.c_duedate,
88: wf_item_activity_status.c_errname, wf_item_activity_status.c_errmsg,
89: wf_item_activity_status.c_errstack
90: from WF_ITEM_ACTIVITY_STATUSES WIAS
91: where WIAS.ITEM_TYPE = itemtype

Line 88: wf_item_activity_status.c_errname, wf_item_activity_status.c_errmsg,

84: wf_item_activity_status.c_assigned_user,
85: wf_item_activity_status.c_notification_id,
86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,
87: wf_item_activity_status.c_duedate,
88: wf_item_activity_status.c_errname, wf_item_activity_status.c_errmsg,
89: wf_item_activity_status.c_errstack
90: from WF_ITEM_ACTIVITY_STATUSES WIAS
91: where WIAS.ITEM_TYPE = itemtype
92: and WIAS.ITEM_KEY = itemkey

Line 89: wf_item_activity_status.c_errstack

85: wf_item_activity_status.c_notification_id,
86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,
87: wf_item_activity_status.c_duedate,
88: wf_item_activity_status.c_errname, wf_item_activity_status.c_errmsg,
89: wf_item_activity_status.c_errstack
90: from WF_ITEM_ACTIVITY_STATUSES WIAS
91: where WIAS.ITEM_TYPE = itemtype
92: and WIAS.ITEM_KEY = itemkey
93: and WIAS.PROCESS_ACTIVITY = actid;

Line 90: from WF_ITEM_ACTIVITY_STATUSES WIAS

86: wf_item_activity_status.c_begindate, wf_item_activity_status.c_enddate,
87: wf_item_activity_status.c_duedate,
88: wf_item_activity_status.c_errname, wf_item_activity_status.c_errmsg,
89: wf_item_activity_status.c_errstack
90: from WF_ITEM_ACTIVITY_STATUSES WIAS
91: where WIAS.ITEM_TYPE = itemtype
92: and WIAS.ITEM_KEY = itemkey
93: and WIAS.PROCESS_ACTIVITY = actid;
94:

Line 96: wf_item_activity_status.c_itemtype := itemtype;

92: and WIAS.ITEM_KEY = itemkey
93: and WIAS.PROCESS_ACTIVITY = actid;
94:
95: -- Save cache key values
96: wf_item_activity_status.c_itemtype := itemtype;
97: wf_item_activity_status.c_itemkey := itemkey;
98: wf_item_activity_status.c_actid := actid;
99:
100: exception

Line 97: wf_item_activity_status.c_itemkey := itemkey;

93: and WIAS.PROCESS_ACTIVITY = actid;
94:
95: -- Save cache key values
96: wf_item_activity_status.c_itemtype := itemtype;
97: wf_item_activity_status.c_itemkey := itemkey;
98: wf_item_activity_status.c_actid := actid;
99:
100: exception
101:

Line 98: wf_item_activity_status.c_actid := actid;

94:
95: -- Save cache key values
96: wf_item_activity_status.c_itemtype := itemtype;
97: wf_item_activity_status.c_itemkey := itemkey;
98: wf_item_activity_status.c_actid := actid;
99:
100: exception
101:
102: when NO_DATA_FOUND then

Line 104: WF_ITEM_ACTIVITY_STATUS.ClearCache;

100: exception
101:
102: when NO_DATA_FOUND then
103: if (ignore_notfound) then
104: WF_ITEM_ACTIVITY_STATUS.ClearCache;
105:
106: else
107:
108: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',

Line 108: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',

104: WF_ITEM_ACTIVITY_STATUS.ClearCache;
105:
106: else
107:
108: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',
109: itemtype, itemkey, to_char(actid));
110: raise;
111:
112: end if;

Line 115: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',

111:
112: end if;
113:
114: when others then
115: Wf_Core.Context('Wf_Item_Activity_Status', 'InitCache',
116: itemtype, itemkey, to_char(actid));
117: raise;
118: end InitCache;
119:

Line 122: -- Update the notification id and assigned user in WF_ITEM_ACTIVITY_STATUSES

118: end InitCache;
119:
120: --
121: -- Update_Notification (PRIVATE)
122: -- Update the notification id and assigned user in WF_ITEM_ACTIVITY_STATUSES
123: -- table for a given item activity.
124: -- IN
125: -- itemtype - Activity item type.
126: -- itemkey - The item key.

Line 139: WF_ITEM_ACTIVITY_STATUSES set

135: user in varchar2)
136: is
137: begin
138: update
139: WF_ITEM_ACTIVITY_STATUSES set
140: NOTIFICATION_ID = notid,
141: ASSIGNED_USER = user
142: where ITEM_TYPE = itemtype
143: and ITEM_KEY = itemkey

Line 147: if ((wf_item_activity_status.c_itemtype = itemtype) and

143: and ITEM_KEY = itemkey
144: and PROCESS_ACTIVITY = actid;
145:
146: -- Update runtime cache if this is the current row
147: if ((wf_item_activity_status.c_itemtype = itemtype) and
148: (wf_item_activity_status.c_itemkey = itemkey) and
149: (wf_item_activity_status.c_actid = actid)) then
150: wf_item_activity_status.c_assigned_user := user;
151: wf_item_activity_status.c_notification_id := notid;

Line 148: (wf_item_activity_status.c_itemkey = itemkey) and

144: and PROCESS_ACTIVITY = actid;
145:
146: -- Update runtime cache if this is the current row
147: if ((wf_item_activity_status.c_itemtype = itemtype) and
148: (wf_item_activity_status.c_itemkey = itemkey) and
149: (wf_item_activity_status.c_actid = actid)) then
150: wf_item_activity_status.c_assigned_user := user;
151: wf_item_activity_status.c_notification_id := notid;
152: end if;

Line 149: (wf_item_activity_status.c_actid = actid)) then

145:
146: -- Update runtime cache if this is the current row
147: if ((wf_item_activity_status.c_itemtype = itemtype) and
148: (wf_item_activity_status.c_itemkey = itemkey) and
149: (wf_item_activity_status.c_actid = actid)) then
150: wf_item_activity_status.c_assigned_user := user;
151: wf_item_activity_status.c_notification_id := notid;
152: end if;
153:

Line 150: wf_item_activity_status.c_assigned_user := user;

146: -- Update runtime cache if this is the current row
147: if ((wf_item_activity_status.c_itemtype = itemtype) and
148: (wf_item_activity_status.c_itemkey = itemkey) and
149: (wf_item_activity_status.c_actid = actid)) then
150: wf_item_activity_status.c_assigned_user := user;
151: wf_item_activity_status.c_notification_id := notid;
152: end if;
153:
154: if (Wf_Engine.Debug) then

Line 151: wf_item_activity_status.c_notification_id := notid;

147: if ((wf_item_activity_status.c_itemtype = itemtype) and
148: (wf_item_activity_status.c_itemkey = itemkey) and
149: (wf_item_activity_status.c_actid = actid)) then
150: wf_item_activity_status.c_assigned_user := user;
151: wf_item_activity_status.c_notification_id := notid;
152: end if;
153:
154: if (Wf_Engine.Debug) then
155: commit;

Line 159: Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Notification', itemtype,

155: commit;
156: end if;
157: exception
158: when OTHERS then
159: Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Notification', itemtype,
160: itemkey, to_char(actid), to_char(notid), user);
161: raise;
162: end Update_Notification;
163:

Line 201: Wf_Item_Activity_Status.Result(itemtype, itemkey, rootid, status, result);

197: Wf_Core.Raise('WFENG_PROCESS_RUNNABLE');
198: end if;
199:
200: -- Get status
201: Wf_Item_Activity_Status.Result(itemtype, itemkey, rootid, status, result);
202:
203: exception
204: when others then
205: Wf_Core.Context('Wf_Item_Activity_Status', 'Root_Status',

Line 205: Wf_Core.Context('Wf_Item_Activity_Status', 'Root_Status',

201: Wf_Item_Activity_Status.Result(itemtype, itemkey, rootid, status, result);
202:
203: exception
204: when others then
205: Wf_Core.Context('Wf_Item_Activity_Status', 'Root_Status',
206: itemtype, itemkey);
207: raise;
208: end Root_Status;
209:

Line 232: if ((itemtype <> nvl(wf_item_activity_status.c_itemtype, 'x')) or

228: result out NOCOPY varchar2)
229: is
230: begin
231: -- Check that the item matches one in the cache
232: if ((itemtype <> nvl(wf_item_activity_status.c_itemtype, 'x')) or
233: (itemkey <> nvl(wf_item_activity_status.c_itemkey, 'x'))) then
234: Wf_Core.Token('ITEMTYPE', itemtype);
235: Wf_Core.Token('ITEMKEY', itemkey);
236: Wf_Core.Raise('WFENG_SYNCH_ITEM');

Line 233: (itemkey <> nvl(wf_item_activity_status.c_itemkey, 'x'))) then

229: is
230: begin
231: -- Check that the item matches one in the cache
232: if ((itemtype <> nvl(wf_item_activity_status.c_itemtype, 'x')) or
233: (itemkey <> nvl(wf_item_activity_status.c_itemkey, 'x'))) then
234: Wf_Core.Token('ITEMTYPE', itemtype);
235: Wf_Core.Token('ITEMKEY', itemkey);
236: Wf_Core.Raise('WFENG_SYNCH_ITEM');
237: end if;

Line 239: actid := wf_item_activity_status.c_actid;

235: Wf_Core.Token('ITEMKEY', itemkey);
236: Wf_Core.Raise('WFENG_SYNCH_ITEM');
237: end if;
238:
239: actid := wf_item_activity_status.c_actid;
240: status := wf_item_activity_status.c_status;
241: result := wf_item_activity_status.c_result;
242: exception
243: when others then

Line 240: status := wf_item_activity_status.c_status;

236: Wf_Core.Raise('WFENG_SYNCH_ITEM');
237: end if;
238:
239: actid := wf_item_activity_status.c_actid;
240: status := wf_item_activity_status.c_status;
241: result := wf_item_activity_status.c_result;
242: exception
243: when others then
244: Wf_Core.Context('Wf_Item_Activity_Status', 'LastResult',

Line 241: result := wf_item_activity_status.c_result;

237: end if;
238:
239: actid := wf_item_activity_status.c_actid;
240: status := wf_item_activity_status.c_status;
241: result := wf_item_activity_status.c_result;
242: exception
243: when others then
244: Wf_Core.Context('Wf_Item_Activity_Status', 'LastResult',
245: itemtype, itemkey);

Line 244: Wf_Core.Context('Wf_Item_Activity_Status', 'LastResult',

240: status := wf_item_activity_status.c_status;
241: result := wf_item_activity_status.c_result;
242: exception
243: when others then
244: Wf_Core.Context('Wf_Item_Activity_Status', 'LastResult',
245: itemtype, itemkey);
246: raise;
247: end LastResult;
248:

Line 252: -- the WF_ITEM_ACTIVITY_STATUSES table, the status out variable will be null.

248:
249: --
250: -- Status (PRIVATE)
251: -- Returns the status for this item activity. If there is no row in
252: -- the WF_ITEM_ACTIVITY_STATUSES table, the status out variable will be null.
253: -- IN
254: -- itemtype - Activity item type.
255: -- itemkey - The item key.
256: -- actid - Process activity (instance id).

Line 267: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,

263: status out NOCOPY varchar2)
264: is
265: begin
266:
267: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,
268: ignore_notfound=>TRUE);
269: status := wf_item_activity_status.c_status;
270: return;
271:

Line 269: status := wf_item_activity_status.c_status;

265: begin
266:
267: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,
268: ignore_notfound=>TRUE);
269: status := wf_item_activity_status.c_status;
270: return;
271:
272: exception
273: when OTHERS then

Line 274: Wf_Core.Context('Wf_Item_Activity_Status', 'Status', itemtype,

270: return;
271:
272: exception
273: when OTHERS then
274: Wf_Core.Context('Wf_Item_Activity_Status', 'Status', itemtype,
275: itemkey, to_char(actid));
276: raise;
277: end Status;
278:

Line 282: -- row in the WF_ITEM_ACTIVITY_STATUSES table, both status and result

278:
279: --
280: -- Result (PRIVATE)
281: -- Returns the status and result for this item activity. If there is no
282: -- row in the WF_ITEM_ACTIVITY_STATUSES table, both status and result
283: -- out variables will be null.
284: -- IN
285: -- itemtype - Activity item type.
286: -- itemkey - The item key.

Line 300: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,

296: result out NOCOPY varchar2) is
297:
298: begin
299:
300: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,
301: ignore_notfound=>TRUE);
302:
303: status := wf_item_activity_status.c_status;
304: result := wf_item_activity_status.c_result;

Line 303: status := wf_item_activity_status.c_status;

299:
300: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,
301: ignore_notfound=>TRUE);
302:
303: status := wf_item_activity_status.c_status;
304: result := wf_item_activity_status.c_result;
305: return;
306:
307: exception

Line 304: result := wf_item_activity_status.c_result;

300: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,
301: ignore_notfound=>TRUE);
302:
303: status := wf_item_activity_status.c_status;
304: result := wf_item_activity_status.c_result;
305: return;
306:
307: exception
308: when NO_DATA_FOUND then

Line 312: Wf_Core.Context('Wf_Item_Activity_Status', 'Result', itemtype,

308: when NO_DATA_FOUND then
309: status := '';
310: result := '';
311: when OTHERS then
312: Wf_Core.Context('Wf_Item_Activity_Status', 'Result', itemtype,
313: itemkey, to_char(actid));
314: raise;
315: end Result;
316:

Line 335: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid);

331: return date
332: is
333: begin
334:
335: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid);
336: return(wf_item_activity_status.c_duedate);
337:
338: exception
339: when others then

Line 336: return(wf_item_activity_status.c_duedate);

332: is
333: begin
334:
335: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid);
336: return(wf_item_activity_status.c_duedate);
337:
338: exception
339: when others then
340: Wf_Core.Context('Wf_Item_Activity_Status', 'Due_Date', itemtype,

Line 340: Wf_Core.Context('Wf_Item_Activity_Status', 'Due_Date', itemtype,

336: return(wf_item_activity_status.c_duedate);
337:
338: exception
339: when others then
340: Wf_Core.Context('Wf_Item_Activity_Status', 'Due_Date', itemtype,
341: itemkey, to_char(actid));
342: raise;
343: end Due_Date;
344:

Line 348: -- If there is no row in the WF_ITEM_ACTIVITY_STATUSES table, the notid

344:
345: --
346: -- Notification_Status (PRIVATE)
347: -- Returns the notification id and assigned user for this item activity.
348: -- If there is no row in the WF_ITEM_ACTIVITY_STATUSES table, the notid
349: -- and user out variables will contain null.
350: -- IN
351: -- itemtype - Activity item type.
352: -- itemkey - The item key.

Line 366: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,

362: user out NOCOPY varchar2)
363: is
364: begin
365:
366: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,
367: ignore_notfound=>TRUE);
368: notid := wf_item_activity_status.c_notification_id;
369: user := wf_item_activity_status.c_assigned_user;
370: return;

Line 368: notid := wf_item_activity_status.c_notification_id;

364: begin
365:
366: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,
367: ignore_notfound=>TRUE);
368: notid := wf_item_activity_status.c_notification_id;
369: user := wf_item_activity_status.c_assigned_user;
370: return;
371:
372: exception

Line 369: user := wf_item_activity_status.c_assigned_user;

365:
366: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid,
367: ignore_notfound=>TRUE);
368: notid := wf_item_activity_status.c_notification_id;
369: user := wf_item_activity_status.c_assigned_user;
370: return;
371:
372: exception
373: when OTHERS then

Line 374: Wf_Core.Context('Wf_Item_Activity_Status', 'Notification_Status', itemtype,

370: return;
371:
372: exception
373: when OTHERS then
374: Wf_Core.Context('Wf_Item_Activity_Status', 'Notification_Status', itemtype,
375: itemkey, to_char(actid));
376: raise;
377: end Notification_Status;
378:

Line 400: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid);

396: errstack out NOCOPY varchar2)
397: is
398: begin
399:
400: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid);
401: errname := wf_item_activity_status.c_errname;
402: errmsg := wf_item_activity_status.c_errmsg;
403: errstack := wf_item_activity_status.c_errstack;
404: return;

Line 401: errname := wf_item_activity_status.c_errname;

397: is
398: begin
399:
400: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid);
401: errname := wf_item_activity_status.c_errname;
402: errmsg := wf_item_activity_status.c_errmsg;
403: errstack := wf_item_activity_status.c_errstack;
404: return;
405:

Line 402: errmsg := wf_item_activity_status.c_errmsg;

398: begin
399:
400: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid);
401: errname := wf_item_activity_status.c_errname;
402: errmsg := wf_item_activity_status.c_errmsg;
403: errstack := wf_item_activity_status.c_errstack;
404: return;
405:
406: exception

Line 403: errstack := wf_item_activity_status.c_errstack;

399:
400: Wf_Item_Activity_Status.InitCache(itemtype, itemkey, actid);
401: errname := wf_item_activity_status.c_errname;
402: errmsg := wf_item_activity_status.c_errmsg;
403: errstack := wf_item_activity_status.c_errstack;
404: return;
405:
406: exception
407: when NO_DATA_FOUND then

Line 408: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,

404: return;
405:
406: exception
407: when NO_DATA_FOUND then
408: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
409: itemkey, to_char(actid));
410: Wf_Core.Token('TYPE', itemtype);
411: Wf_Core.Token('KEY', itemkey);
412: Wf_Core.Token('ACTID', to_char(actid));

Line 415: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,

411: Wf_Core.Token('KEY', itemkey);
412: Wf_Core.Token('ACTID', to_char(actid));
413: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
414: when OTHERS then
415: Wf_Core.Context('Wf_Item_Activity_Status', 'Error_Info', itemtype,
416: itemkey, to_char(actid));
417: raise;
418: end Error_Info;
419:

Line 466: 'Wf_Item_Activity_Status.Set_Error(error_process)');

462: -- SYNCHMODE: This should NEVER happen in synchmode, since
463: -- error processes are not allowed.
464: if (itemkey = wf_engine.eng_synch) then
465: wf_core.token('OPERATION',
466: 'Wf_Item_Activity_Status.Set_Error(error_process)');
467: wf_core.raise('WFENG_SYNCH_DISABLED');
468: end if;
469:
470: prefix := substrb(' ['||Wf_Core.Translate('WFENG_ERR_PROC_ERROR')||': ',

Line 476: from WF_ITEM_ACTIVITY_STATUSES

472:
473: select
474: error_name,error_message,error_stack
475: into l_errname,l_errmsg,l_errstack
476: from WF_ITEM_ACTIVITY_STATUSES
477: where ITEM_TYPE = itemtype
478: and ITEM_KEY = itemkey
479: and PROCESS_ACTIVITY = actid;
480:

Line 485: WF_ITEM_ACTIVITY_STATUSES set

481: l_errname:= substrb(l_errname||prefix||errname||']', 1, 30);
482: l_errmsg:=substrb(l_errmsg||prefix||errmsg||']', 1, 2000);
483: l_errstack:=substrb(l_errstack||prefix||errstack||']', 1, 4000);
484: update
485: WF_ITEM_ACTIVITY_STATUSES set
486: ERROR_NAME=l_errname,
487: ERROR_MESSAGE = l_errmsg,
488: ERROR_STACK = l_errstack
489: where ITEM_TYPE = itemtype

Line 495: if ((wf_item_activity_status.c_itemtype = itemtype) and

491: and PROCESS_ACTIVITY = actid;
492:
493:
494: -- Update runtime cache
495: if ((wf_item_activity_status.c_itemtype = itemtype) and
496: (wf_item_activity_status.c_itemkey = itemkey) and
497: (wf_item_activity_status.c_actid = actid)) then
498:
499: wf_item_activity_status.c_errname :=

Line 496: (wf_item_activity_status.c_itemkey = itemkey) and

492:
493:
494: -- Update runtime cache
495: if ((wf_item_activity_status.c_itemtype = itemtype) and
496: (wf_item_activity_status.c_itemkey = itemkey) and
497: (wf_item_activity_status.c_actid = actid)) then
498:
499: wf_item_activity_status.c_errname :=
500: substrb(wf_item_activity_status.c_errname||prefix||errname||']',

Line 497: (wf_item_activity_status.c_actid = actid)) then

493:
494: -- Update runtime cache
495: if ((wf_item_activity_status.c_itemtype = itemtype) and
496: (wf_item_activity_status.c_itemkey = itemkey) and
497: (wf_item_activity_status.c_actid = actid)) then
498:
499: wf_item_activity_status.c_errname :=
500: substrb(wf_item_activity_status.c_errname||prefix||errname||']',
501: 1, 30);

Line 499: wf_item_activity_status.c_errname :=

495: if ((wf_item_activity_status.c_itemtype = itemtype) and
496: (wf_item_activity_status.c_itemkey = itemkey) and
497: (wf_item_activity_status.c_actid = actid)) then
498:
499: wf_item_activity_status.c_errname :=
500: substrb(wf_item_activity_status.c_errname||prefix||errname||']',
501: 1, 30);
502: wf_item_activity_status.c_errmsg :=
503: substrb(wf_item_activity_status.c_errmsg||prefix||errmsg||']',

Line 500: substrb(wf_item_activity_status.c_errname||prefix||errname||']',

496: (wf_item_activity_status.c_itemkey = itemkey) and
497: (wf_item_activity_status.c_actid = actid)) then
498:
499: wf_item_activity_status.c_errname :=
500: substrb(wf_item_activity_status.c_errname||prefix||errname||']',
501: 1, 30);
502: wf_item_activity_status.c_errmsg :=
503: substrb(wf_item_activity_status.c_errmsg||prefix||errmsg||']',
504: 1, 2000);

Line 502: wf_item_activity_status.c_errmsg :=

498:
499: wf_item_activity_status.c_errname :=
500: substrb(wf_item_activity_status.c_errname||prefix||errname||']',
501: 1, 30);
502: wf_item_activity_status.c_errmsg :=
503: substrb(wf_item_activity_status.c_errmsg||prefix||errmsg||']',
504: 1, 2000);
505: wf_item_activity_status.c_errstack :=
506: substrb(wf_item_activity_status.c_errstack||prefix||errstack||']',

Line 503: substrb(wf_item_activity_status.c_errmsg||prefix||errmsg||']',

499: wf_item_activity_status.c_errname :=
500: substrb(wf_item_activity_status.c_errname||prefix||errname||']',
501: 1, 30);
502: wf_item_activity_status.c_errmsg :=
503: substrb(wf_item_activity_status.c_errmsg||prefix||errmsg||']',
504: 1, 2000);
505: wf_item_activity_status.c_errstack :=
506: substrb(wf_item_activity_status.c_errstack||prefix||errstack||']',
507: 1, 4000);

Line 505: wf_item_activity_status.c_errstack :=

501: 1, 30);
502: wf_item_activity_status.c_errmsg :=
503: substrb(wf_item_activity_status.c_errmsg||prefix||errmsg||']',
504: 1, 2000);
505: wf_item_activity_status.c_errstack :=
506: substrb(wf_item_activity_status.c_errstack||prefix||errstack||']',
507: 1, 4000);
508:
509: end if;

Line 506: substrb(wf_item_activity_status.c_errstack||prefix||errstack||']',

502: wf_item_activity_status.c_errmsg :=
503: substrb(wf_item_activity_status.c_errmsg||prefix||errmsg||']',
504: 1, 2000);
505: wf_item_activity_status.c_errstack :=
506: substrb(wf_item_activity_status.c_errstack||prefix||errstack||']',
507: 1, 4000);
508:
509: end if;
510:

Line 513: if ((wf_item_activity_status.c_itemtype = itemtype) and

509: end if;
510:
511: else
512: -- Update runtime cache
513: if ((wf_item_activity_status.c_itemtype = itemtype) and
514: (wf_item_activity_status.c_itemkey = itemkey) and
515: (wf_item_activity_status.c_actid = actid)) then
516:
517: wf_item_activity_status.c_errname := errname;

Line 514: (wf_item_activity_status.c_itemkey = itemkey) and

510:
511: else
512: -- Update runtime cache
513: if ((wf_item_activity_status.c_itemtype = itemtype) and
514: (wf_item_activity_status.c_itemkey = itemkey) and
515: (wf_item_activity_status.c_actid = actid)) then
516:
517: wf_item_activity_status.c_errname := errname;
518: wf_item_activity_status.c_errmsg := errmsg;

Line 515: (wf_item_activity_status.c_actid = actid)) then

511: else
512: -- Update runtime cache
513: if ((wf_item_activity_status.c_itemtype = itemtype) and
514: (wf_item_activity_status.c_itemkey = itemkey) and
515: (wf_item_activity_status.c_actid = actid)) then
516:
517: wf_item_activity_status.c_errname := errname;
518: wf_item_activity_status.c_errmsg := errmsg;
519: wf_item_activity_status.c_errstack := errstack;

Line 517: wf_item_activity_status.c_errname := errname;

513: if ((wf_item_activity_status.c_itemtype = itemtype) and
514: (wf_item_activity_status.c_itemkey = itemkey) and
515: (wf_item_activity_status.c_actid = actid)) then
516:
517: wf_item_activity_status.c_errname := errname;
518: wf_item_activity_status.c_errmsg := errmsg;
519: wf_item_activity_status.c_errstack := errstack;
520: wf_item_activity_status.c_status := wf_engine.eng_error;
521: wf_item_activity_status.c_result := errcode;

Line 518: wf_item_activity_status.c_errmsg := errmsg;

514: (wf_item_activity_status.c_itemkey = itemkey) and
515: (wf_item_activity_status.c_actid = actid)) then
516:
517: wf_item_activity_status.c_errname := errname;
518: wf_item_activity_status.c_errmsg := errmsg;
519: wf_item_activity_status.c_errstack := errstack;
520: wf_item_activity_status.c_status := wf_engine.eng_error;
521: wf_item_activity_status.c_result := errcode;
522:

Line 519: wf_item_activity_status.c_errstack := errstack;

515: (wf_item_activity_status.c_actid = actid)) then
516:
517: wf_item_activity_status.c_errname := errname;
518: wf_item_activity_status.c_errmsg := errmsg;
519: wf_item_activity_status.c_errstack := errstack;
520: wf_item_activity_status.c_status := wf_engine.eng_error;
521: wf_item_activity_status.c_result := errcode;
522:
523: end if;

Line 520: wf_item_activity_status.c_status := wf_engine.eng_error;

516:
517: wf_item_activity_status.c_errname := errname;
518: wf_item_activity_status.c_errmsg := errmsg;
519: wf_item_activity_status.c_errstack := errstack;
520: wf_item_activity_status.c_status := wf_engine.eng_error;
521: wf_item_activity_status.c_result := errcode;
522:
523: end if;
524:

Line 521: wf_item_activity_status.c_result := errcode;

517: wf_item_activity_status.c_errname := errname;
518: wf_item_activity_status.c_errmsg := errmsg;
519: wf_item_activity_status.c_errstack := errstack;
520: wf_item_activity_status.c_status := wf_engine.eng_error;
521: wf_item_activity_status.c_result := errcode;
522:
523: end if;
524:
525: -- SYNCHMODE: In synch mode stop after updating internal cache.

Line 536: WF_ITEM_ACTIVITY_STATUSES set

532:
533: -- Store error info and set status/result
534:
535: update
536: WF_ITEM_ACTIVITY_STATUSES set
537: ACTIVITY_STATUS = wf_engine.eng_error,
538: ACTIVITY_RESULT_CODE = errcode,
539: ERROR_NAME = errname,
540: ERROR_MESSAGE = errmsg,

Line 550: -- No record was found in WF_ITEM_ACTIVITY_STATUSES. We will check

546:
547: end if;
548:
549: -- Bug 3960517
550: -- No record was found in WF_ITEM_ACTIVITY_STATUSES. We will check
551: -- the history table. If record exists in WF_ITEM_ACTIVITY_STATUSES_H,
552: -- we may have re-entered a node causing engine to prepare for looping.
553: -- But instead of going through all the activities along the loop, it has
554: -- progressed through a different path. Since there maybe multiple records

Line 551: -- the history table. If record exists in WF_ITEM_ACTIVITY_STATUSES_H,

547: end if;
548:
549: -- Bug 3960517
550: -- No record was found in WF_ITEM_ACTIVITY_STATUSES. We will check
551: -- the history table. If record exists in WF_ITEM_ACTIVITY_STATUSES_H,
552: -- we may have re-entered a node causing engine to prepare for looping.
553: -- But instead of going through all the activities along the loop, it has
554: -- progressed through a different path. Since there maybe multiple records
555: -- in the history table with the same item type, item key and actid, we may

Line 559: from WF_ITEM_ACTIVITY_STATUSES_H

555: -- in the history table with the same item type, item key and actid, we may
556: -- not be able to mark the error accordingly, so we just simply ignore the error.
557: if (SQL%NOTFOUND) then
558: select 1 into l_exist
559: from WF_ITEM_ACTIVITY_STATUSES_H
560: where ITEM_TYPE = itemtype
561: and ITEM_KEY= itemkey
562: and process_activity = actid
563: and rownum < 2;

Line 572: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',

568: commit;
569: end if;
570: exception
571: when NO_DATA_FOUND then
572: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
573: itemtype, itemkey, to_char(actid), errcode);
574: Wf_Core.Token('TYPE', itemtype);
575: Wf_Core.Token('KEY', itemkey);
576: Wf_Core.Token('ACTID', to_char(actid));

Line 579: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',

575: Wf_Core.Token('KEY', itemkey);
576: Wf_Core.Token('ACTID', to_char(actid));
577: Wf_Core.Raise('WFENG_ITEM_ACTIVITY_STATUS');
578: when OTHERS then
579: Wf_Core.Context('Wf_Item_Activity_Status', 'Set_Error',
580: itemtype, itemkey, to_char(actid), errcode);
581:
582: raise;
583: end Set_Error;

Line 587: -- Deletes the row for this item activity from WF_ITEM_ACTIVITY_STATUSES.

583: end Set_Error;
584:
585: --
586: -- Delete_Status (PRIVATE)
587: -- Deletes the row for this item activity from WF_ITEM_ACTIVITY_STATUSES.
588: -- IN
589: -- itemtype - Activity item type.
590: -- itemkey - The item key.
591: -- actid - Process activity (instance id).

Line 599: from WF_ITEM_ACTIVITY_STATUSES

595: actid in number)
596: is
597: begin
598: delete
599: from WF_ITEM_ACTIVITY_STATUSES
600: where ITEM_TYPE = itemtype
601: and ITEM_KEY = itemkey
602: and PROCESS_ACTIVITY = actid;
603:

Line 605: if ((wf_item_activity_status.c_itemtype = itemtype) and

601: and ITEM_KEY = itemkey
602: and PROCESS_ACTIVITY = actid;
603:
604: -- Clear runtime cache if needed
605: if ((wf_item_activity_status.c_itemtype = itemtype) and
606: (wf_item_activity_status.c_itemkey = itemkey) and
607: (wf_item_activity_status.c_actid = actid)) then
608: wf_item_activity_status.c_itemtype := '';
609: wf_item_activity_status.c_itemkey := '';

Line 606: (wf_item_activity_status.c_itemkey = itemkey) and

602: and PROCESS_ACTIVITY = actid;
603:
604: -- Clear runtime cache if needed
605: if ((wf_item_activity_status.c_itemtype = itemtype) and
606: (wf_item_activity_status.c_itemkey = itemkey) and
607: (wf_item_activity_status.c_actid = actid)) then
608: wf_item_activity_status.c_itemtype := '';
609: wf_item_activity_status.c_itemkey := '';
610: wf_item_activity_status.c_actid := '';

Line 607: (wf_item_activity_status.c_actid = actid)) then

603:
604: -- Clear runtime cache if needed
605: if ((wf_item_activity_status.c_itemtype = itemtype) and
606: (wf_item_activity_status.c_itemkey = itemkey) and
607: (wf_item_activity_status.c_actid = actid)) then
608: wf_item_activity_status.c_itemtype := '';
609: wf_item_activity_status.c_itemkey := '';
610: wf_item_activity_status.c_actid := '';
611: end if;

Line 608: wf_item_activity_status.c_itemtype := '';

604: -- Clear runtime cache if needed
605: if ((wf_item_activity_status.c_itemtype = itemtype) and
606: (wf_item_activity_status.c_itemkey = itemkey) and
607: (wf_item_activity_status.c_actid = actid)) then
608: wf_item_activity_status.c_itemtype := '';
609: wf_item_activity_status.c_itemkey := '';
610: wf_item_activity_status.c_actid := '';
611: end if;
612:

Line 609: wf_item_activity_status.c_itemkey := '';

605: if ((wf_item_activity_status.c_itemtype = itemtype) and
606: (wf_item_activity_status.c_itemkey = itemkey) and
607: (wf_item_activity_status.c_actid = actid)) then
608: wf_item_activity_status.c_itemtype := '';
609: wf_item_activity_status.c_itemkey := '';
610: wf_item_activity_status.c_actid := '';
611: end if;
612:
613: if (Wf_Engine.Debug) then

Line 610: wf_item_activity_status.c_actid := '';

606: (wf_item_activity_status.c_itemkey = itemkey) and
607: (wf_item_activity_status.c_actid = actid)) then
608: wf_item_activity_status.c_itemtype := '';
609: wf_item_activity_status.c_itemkey := '';
610: wf_item_activity_status.c_actid := '';
611: end if;
612:
613: if (Wf_Engine.Debug) then
614: commit;

Line 618: Wf_Core.Context('Wf_Item_Activity_Status', 'Delete_Status', itemtype,

614: commit;
615: end if;
616: exception
617: when OTHERS then
618: Wf_Core.Context('Wf_Item_Activity_Status', 'Delete_Status', itemtype,
619: itemkey, to_char(actid));
620: raise;
621: end Delete_Status;
622:

Line 673: if ((wf_item_activity_status.c_itemtype = itemtype) and

669: begin
670: if (itemkey = wf_engine.eng_synch) then
671:
672: -- SYNCHMODE: Only update runtime cache.
673: if ((wf_item_activity_status.c_itemtype = itemtype) and
674: (wf_item_activity_status.c_itemkey = itemkey) and
675: (wf_item_activity_status.c_actid = actid)) then
676: -- Existing row. Only update relevant parts
677: wf_item_activity_status.c_status := status;

Line 674: (wf_item_activity_status.c_itemkey = itemkey) and

670: if (itemkey = wf_engine.eng_synch) then
671:
672: -- SYNCHMODE: Only update runtime cache.
673: if ((wf_item_activity_status.c_itemtype = itemtype) and
674: (wf_item_activity_status.c_itemkey = itemkey) and
675: (wf_item_activity_status.c_actid = actid)) then
676: -- Existing row. Only update relevant parts
677: wf_item_activity_status.c_status := status;
678: if (result is not null) then

Line 675: (wf_item_activity_status.c_actid = actid)) then

671:
672: -- SYNCHMODE: Only update runtime cache.
673: if ((wf_item_activity_status.c_itemtype = itemtype) and
674: (wf_item_activity_status.c_itemkey = itemkey) and
675: (wf_item_activity_status.c_actid = actid)) then
676: -- Existing row. Only update relevant parts
677: wf_item_activity_status.c_status := status;
678: if (result is not null) then
679: wf_item_activity_status.c_result := result;

Line 677: wf_item_activity_status.c_status := status;

673: if ((wf_item_activity_status.c_itemtype = itemtype) and
674: (wf_item_activity_status.c_itemkey = itemkey) and
675: (wf_item_activity_status.c_actid = actid)) then
676: -- Existing row. Only update relevant parts
677: wf_item_activity_status.c_status := status;
678: if (result is not null) then
679: wf_item_activity_status.c_result := result;
680: end if;
681: if (beginning is not null) then

Line 679: wf_item_activity_status.c_result := result;

675: (wf_item_activity_status.c_actid = actid)) then
676: -- Existing row. Only update relevant parts
677: wf_item_activity_status.c_status := status;
678: if (result is not null) then
679: wf_item_activity_status.c_result := result;
680: end if;
681: if (beginning is not null) then
682: wf_item_activity_status.c_begindate := beginning;
683: end if;

Line 682: wf_item_activity_status.c_begindate := beginning;

678: if (result is not null) then
679: wf_item_activity_status.c_result := result;
680: end if;
681: if (beginning is not null) then
682: wf_item_activity_status.c_begindate := beginning;
683: end if;
684: if (ending is not null) then
685: wf_item_activity_status.c_enddate := ending;
686: end if;

Line 685: wf_item_activity_status.c_enddate := ending;

681: if (beginning is not null) then
682: wf_item_activity_status.c_begindate := beginning;
683: end if;
684: if (ending is not null) then
685: wf_item_activity_status.c_enddate := ending;
686: end if;
687: else
688: -- Fresh new row. Re-initialize everything.
689: wf_item_activity_status.c_itemtype := itemtype;

Line 689: wf_item_activity_status.c_itemtype := itemtype;

685: wf_item_activity_status.c_enddate := ending;
686: end if;
687: else
688: -- Fresh new row. Re-initialize everything.
689: wf_item_activity_status.c_itemtype := itemtype;
690: wf_item_activity_status.c_itemkey := itemkey;
691: wf_item_activity_status.c_actid := actid;
692: wf_item_activity_status.c_status := status;
693: wf_item_activity_status.c_result := result;

Line 690: wf_item_activity_status.c_itemkey := itemkey;

686: end if;
687: else
688: -- Fresh new row. Re-initialize everything.
689: wf_item_activity_status.c_itemtype := itemtype;
690: wf_item_activity_status.c_itemkey := itemkey;
691: wf_item_activity_status.c_actid := actid;
692: wf_item_activity_status.c_status := status;
693: wf_item_activity_status.c_result := result;
694: wf_item_activity_status.c_begindate := beginning;

Line 691: wf_item_activity_status.c_actid := actid;

687: else
688: -- Fresh new row. Re-initialize everything.
689: wf_item_activity_status.c_itemtype := itemtype;
690: wf_item_activity_status.c_itemkey := itemkey;
691: wf_item_activity_status.c_actid := actid;
692: wf_item_activity_status.c_status := status;
693: wf_item_activity_status.c_result := result;
694: wf_item_activity_status.c_begindate := beginning;
695: wf_item_activity_status.c_enddate := ending;

Line 692: wf_item_activity_status.c_status := status;

688: -- Fresh new row. Re-initialize everything.
689: wf_item_activity_status.c_itemtype := itemtype;
690: wf_item_activity_status.c_itemkey := itemkey;
691: wf_item_activity_status.c_actid := actid;
692: wf_item_activity_status.c_status := status;
693: wf_item_activity_status.c_result := result;
694: wf_item_activity_status.c_begindate := beginning;
695: wf_item_activity_status.c_enddate := ending;
696: wf_item_activity_status.c_duedate := to_date(NULL);

Line 693: wf_item_activity_status.c_result := result;

689: wf_item_activity_status.c_itemtype := itemtype;
690: wf_item_activity_status.c_itemkey := itemkey;
691: wf_item_activity_status.c_actid := actid;
692: wf_item_activity_status.c_status := status;
693: wf_item_activity_status.c_result := result;
694: wf_item_activity_status.c_begindate := beginning;
695: wf_item_activity_status.c_enddate := ending;
696: wf_item_activity_status.c_duedate := to_date(NULL);
697: wf_item_activity_status.c_assigned_user := '';

Line 694: wf_item_activity_status.c_begindate := beginning;

690: wf_item_activity_status.c_itemkey := itemkey;
691: wf_item_activity_status.c_actid := actid;
692: wf_item_activity_status.c_status := status;
693: wf_item_activity_status.c_result := result;
694: wf_item_activity_status.c_begindate := beginning;
695: wf_item_activity_status.c_enddate := ending;
696: wf_item_activity_status.c_duedate := to_date(NULL);
697: wf_item_activity_status.c_assigned_user := '';
698: wf_item_activity_status.c_notification_id := '';

Line 695: wf_item_activity_status.c_enddate := ending;

691: wf_item_activity_status.c_actid := actid;
692: wf_item_activity_status.c_status := status;
693: wf_item_activity_status.c_result := result;
694: wf_item_activity_status.c_begindate := beginning;
695: wf_item_activity_status.c_enddate := ending;
696: wf_item_activity_status.c_duedate := to_date(NULL);
697: wf_item_activity_status.c_assigned_user := '';
698: wf_item_activity_status.c_notification_id := '';
699: wf_item_activity_status.c_errname := '';

Line 696: wf_item_activity_status.c_duedate := to_date(NULL);

692: wf_item_activity_status.c_status := status;
693: wf_item_activity_status.c_result := result;
694: wf_item_activity_status.c_begindate := beginning;
695: wf_item_activity_status.c_enddate := ending;
696: wf_item_activity_status.c_duedate := to_date(NULL);
697: wf_item_activity_status.c_assigned_user := '';
698: wf_item_activity_status.c_notification_id := '';
699: wf_item_activity_status.c_errname := '';
700: wf_item_activity_status.c_errmsg := '';

Line 697: wf_item_activity_status.c_assigned_user := '';

693: wf_item_activity_status.c_result := result;
694: wf_item_activity_status.c_begindate := beginning;
695: wf_item_activity_status.c_enddate := ending;
696: wf_item_activity_status.c_duedate := to_date(NULL);
697: wf_item_activity_status.c_assigned_user := '';
698: wf_item_activity_status.c_notification_id := '';
699: wf_item_activity_status.c_errname := '';
700: wf_item_activity_status.c_errmsg := '';
701: wf_item_activity_status.c_errstack := '';

Line 698: wf_item_activity_status.c_notification_id := '';

694: wf_item_activity_status.c_begindate := beginning;
695: wf_item_activity_status.c_enddate := ending;
696: wf_item_activity_status.c_duedate := to_date(NULL);
697: wf_item_activity_status.c_assigned_user := '';
698: wf_item_activity_status.c_notification_id := '';
699: wf_item_activity_status.c_errname := '';
700: wf_item_activity_status.c_errmsg := '';
701: wf_item_activity_status.c_errstack := '';
702: end if;

Line 699: wf_item_activity_status.c_errname := '';

695: wf_item_activity_status.c_enddate := ending;
696: wf_item_activity_status.c_duedate := to_date(NULL);
697: wf_item_activity_status.c_assigned_user := '';
698: wf_item_activity_status.c_notification_id := '';
699: wf_item_activity_status.c_errname := '';
700: wf_item_activity_status.c_errmsg := '';
701: wf_item_activity_status.c_errstack := '';
702: end if;
703:

Line 700: wf_item_activity_status.c_errmsg := '';

696: wf_item_activity_status.c_duedate := to_date(NULL);
697: wf_item_activity_status.c_assigned_user := '';
698: wf_item_activity_status.c_notification_id := '';
699: wf_item_activity_status.c_errname := '';
700: wf_item_activity_status.c_errmsg := '';
701: wf_item_activity_status.c_errstack := '';
702: end if;
703:
704: else

Line 701: wf_item_activity_status.c_errstack := '';

697: wf_item_activity_status.c_assigned_user := '';
698: wf_item_activity_status.c_notification_id := '';
699: wf_item_activity_status.c_errname := '';
700: wf_item_activity_status.c_errmsg := '';
701: wf_item_activity_status.c_errstack := '';
702: end if;
703:
704: else
705: -- NORMAL mode:

Line 792: Wf_Item_Activity_Status.Create_Status(itemtype, itemkey, actid,

788: end if;
789: exception
790: when others then
791: -- If any error while enqueing, set the activity status to ERROR
792: Wf_Item_Activity_Status.Create_Status(itemtype, itemkey, actid,
793: wf_engine.eng_error, wf_engine.eng_exception,
794: sysdate, null, newStatus=>TRUE);
795: Wf_Item_Activity_Status.Set_Error(itemtype, itemkey, actid,
796: wf_engine.eng_exception, FALSE);

Line 795: Wf_Item_Activity_Status.Set_Error(itemtype, itemkey, actid,

791: -- If any error while enqueing, set the activity status to ERROR
792: Wf_Item_Activity_Status.Create_Status(itemtype, itemkey, actid,
793: wf_engine.eng_error, wf_engine.eng_exception,
794: sysdate, null, newStatus=>TRUE);
795: Wf_Item_Activity_Status.Set_Error(itemtype, itemkey, actid,
796: wf_engine.eng_exception, FALSE);
797: Wf_Engine_Util.Execute_Error_Process(itemtype, itemkey, actid,
798: wf_engine.eng_exception);
799: return;

Line 813: WF_ITEM_ACTIVITY_STATUSES set

809: -- not yet set (activity has been aborted without being executed).
810:
811: if not (newStatus) then
812: update
813: WF_ITEM_ACTIVITY_STATUSES set
814: ACTIVITY_STATUS = create_status.status,
815: ACTIVITY_RESULT_CODE = nvl(create_status.result, ACTIVITY_RESULT_CODE),
816: BEGIN_DATE = nvl(create_status.beginning, BEGIN_DATE),
817: END_DATE = nvl(create_status.ending, END_DATE),

Line 837: into WF_ITEM_ACTIVITY_STATUSES (

833: -- Create the status if not found
834: if ((newStatus) or (SQL%ROWCOUNT = 0)) then
835: begin
836: insert
837: into WF_ITEM_ACTIVITY_STATUSES (
838: ITEM_TYPE,
839: ITEM_KEY,
840: PROCESS_ACTIVITY,
841: ACTIVITY_STATUS,

Line 870: wf_item_activity_status.c_itemtype := itemtype;

866: create_status.msg_id
867: );
868:
869: -- Initialize runtime cache with new row
870: wf_item_activity_status.c_itemtype := itemtype;
871: wf_item_activity_status.c_itemkey := itemkey;
872: wf_item_activity_status.c_actid := actid;
873: wf_item_activity_status.c_status := status;
874: wf_item_activity_status.c_result := result;

Line 871: wf_item_activity_status.c_itemkey := itemkey;

867: );
868:
869: -- Initialize runtime cache with new row
870: wf_item_activity_status.c_itemtype := itemtype;
871: wf_item_activity_status.c_itemkey := itemkey;
872: wf_item_activity_status.c_actid := actid;
873: wf_item_activity_status.c_status := status;
874: wf_item_activity_status.c_result := result;
875: wf_item_activity_status.c_begindate := beginning;

Line 872: wf_item_activity_status.c_actid := actid;

868:
869: -- Initialize runtime cache with new row
870: wf_item_activity_status.c_itemtype := itemtype;
871: wf_item_activity_status.c_itemkey := itemkey;
872: wf_item_activity_status.c_actid := actid;
873: wf_item_activity_status.c_status := status;
874: wf_item_activity_status.c_result := result;
875: wf_item_activity_status.c_begindate := beginning;
876: wf_item_activity_status.c_enddate := ending;

Line 873: wf_item_activity_status.c_status := status;

869: -- Initialize runtime cache with new row
870: wf_item_activity_status.c_itemtype := itemtype;
871: wf_item_activity_status.c_itemkey := itemkey;
872: wf_item_activity_status.c_actid := actid;
873: wf_item_activity_status.c_status := status;
874: wf_item_activity_status.c_result := result;
875: wf_item_activity_status.c_begindate := beginning;
876: wf_item_activity_status.c_enddate := ending;
877: wf_item_activity_status.c_duedate := duedate;

Line 874: wf_item_activity_status.c_result := result;

870: wf_item_activity_status.c_itemtype := itemtype;
871: wf_item_activity_status.c_itemkey := itemkey;
872: wf_item_activity_status.c_actid := actid;
873: wf_item_activity_status.c_status := status;
874: wf_item_activity_status.c_result := result;
875: wf_item_activity_status.c_begindate := beginning;
876: wf_item_activity_status.c_enddate := ending;
877: wf_item_activity_status.c_duedate := duedate;
878: wf_item_activity_status.c_assigned_user := '';

Line 875: wf_item_activity_status.c_begindate := beginning;

871: wf_item_activity_status.c_itemkey := itemkey;
872: wf_item_activity_status.c_actid := actid;
873: wf_item_activity_status.c_status := status;
874: wf_item_activity_status.c_result := result;
875: wf_item_activity_status.c_begindate := beginning;
876: wf_item_activity_status.c_enddate := ending;
877: wf_item_activity_status.c_duedate := duedate;
878: wf_item_activity_status.c_assigned_user := '';
879: wf_item_activity_status.c_notification_id := '';

Line 876: wf_item_activity_status.c_enddate := ending;

872: wf_item_activity_status.c_actid := actid;
873: wf_item_activity_status.c_status := status;
874: wf_item_activity_status.c_result := result;
875: wf_item_activity_status.c_begindate := beginning;
876: wf_item_activity_status.c_enddate := ending;
877: wf_item_activity_status.c_duedate := duedate;
878: wf_item_activity_status.c_assigned_user := '';
879: wf_item_activity_status.c_notification_id := '';
880: wf_item_activity_status.c_errname := '';

Line 877: wf_item_activity_status.c_duedate := duedate;

873: wf_item_activity_status.c_status := status;
874: wf_item_activity_status.c_result := result;
875: wf_item_activity_status.c_begindate := beginning;
876: wf_item_activity_status.c_enddate := ending;
877: wf_item_activity_status.c_duedate := duedate;
878: wf_item_activity_status.c_assigned_user := '';
879: wf_item_activity_status.c_notification_id := '';
880: wf_item_activity_status.c_errname := '';
881: wf_item_activity_status.c_errmsg := '';

Line 878: wf_item_activity_status.c_assigned_user := '';

874: wf_item_activity_status.c_result := result;
875: wf_item_activity_status.c_begindate := beginning;
876: wf_item_activity_status.c_enddate := ending;
877: wf_item_activity_status.c_duedate := duedate;
878: wf_item_activity_status.c_assigned_user := '';
879: wf_item_activity_status.c_notification_id := '';
880: wf_item_activity_status.c_errname := '';
881: wf_item_activity_status.c_errmsg := '';
882: wf_item_activity_status.c_errstack := '';

Line 879: wf_item_activity_status.c_notification_id := '';

875: wf_item_activity_status.c_begindate := beginning;
876: wf_item_activity_status.c_enddate := ending;
877: wf_item_activity_status.c_duedate := duedate;
878: wf_item_activity_status.c_assigned_user := '';
879: wf_item_activity_status.c_notification_id := '';
880: wf_item_activity_status.c_errname := '';
881: wf_item_activity_status.c_errmsg := '';
882: wf_item_activity_status.c_errstack := '';
883:

Line 880: wf_item_activity_status.c_errname := '';

876: wf_item_activity_status.c_enddate := ending;
877: wf_item_activity_status.c_duedate := duedate;
878: wf_item_activity_status.c_assigned_user := '';
879: wf_item_activity_status.c_notification_id := '';
880: wf_item_activity_status.c_errname := '';
881: wf_item_activity_status.c_errmsg := '';
882: wf_item_activity_status.c_errstack := '';
883:
884: l_newStatus := TRUE;

Line 881: wf_item_activity_status.c_errmsg := '';

877: wf_item_activity_status.c_duedate := duedate;
878: wf_item_activity_status.c_assigned_user := '';
879: wf_item_activity_status.c_notification_id := '';
880: wf_item_activity_status.c_errname := '';
881: wf_item_activity_status.c_errmsg := '';
882: wf_item_activity_status.c_errstack := '';
883:
884: l_newStatus := TRUE;
885:

Line 882: wf_item_activity_status.c_errstack := '';

878: wf_item_activity_status.c_assigned_user := '';
879: wf_item_activity_status.c_notification_id := '';
880: wf_item_activity_status.c_errname := '';
881: wf_item_activity_status.c_errmsg := '';
882: wf_item_activity_status.c_errstack := '';
883:
884: l_newStatus := TRUE;
885:
886: exception

Line 893: WF_ITEM_ACTIVITY_STATUSES set

889: -- automatically update to ensure fault tolerance.
890: l_newStatus := FALSE;
891:
892: update
893: WF_ITEM_ACTIVITY_STATUSES set
894: ACTIVITY_STATUS = create_status.status,
895: ACTIVITY_RESULT_CODE = nvl(create_status.result,
896: ACTIVITY_RESULT_CODE),
897: BEGIN_DATE = nvl(create_status.beginning, BEGIN_DATE),

Line 919: if ((wf_item_activity_status.c_itemtype = itemtype) and

915:
916:
917: if (not l_newStatus) then
918: -- Update runtime cache with new data, if current row
919: if ((wf_item_activity_status.c_itemtype = itemtype) and
920: (wf_item_activity_status.c_itemkey = itemkey) and
921: (wf_item_activity_status.c_actid = actid)) then
922: wf_item_activity_status.c_status := status;
923: if (result is not null) then

Line 920: (wf_item_activity_status.c_itemkey = itemkey) and

916:
917: if (not l_newStatus) then
918: -- Update runtime cache with new data, if current row
919: if ((wf_item_activity_status.c_itemtype = itemtype) and
920: (wf_item_activity_status.c_itemkey = itemkey) and
921: (wf_item_activity_status.c_actid = actid)) then
922: wf_item_activity_status.c_status := status;
923: if (result is not null) then
924: wf_item_activity_status.c_result := result;

Line 921: (wf_item_activity_status.c_actid = actid)) then

917: if (not l_newStatus) then
918: -- Update runtime cache with new data, if current row
919: if ((wf_item_activity_status.c_itemtype = itemtype) and
920: (wf_item_activity_status.c_itemkey = itemkey) and
921: (wf_item_activity_status.c_actid = actid)) then
922: wf_item_activity_status.c_status := status;
923: if (result is not null) then
924: wf_item_activity_status.c_result := result;
925: end if;

Line 922: wf_item_activity_status.c_status := status;

918: -- Update runtime cache with new data, if current row
919: if ((wf_item_activity_status.c_itemtype = itemtype) and
920: (wf_item_activity_status.c_itemkey = itemkey) and
921: (wf_item_activity_status.c_actid = actid)) then
922: wf_item_activity_status.c_status := status;
923: if (result is not null) then
924: wf_item_activity_status.c_result := result;
925: end if;
926: if (beginning is not null) then

Line 924: wf_item_activity_status.c_result := result;

920: (wf_item_activity_status.c_itemkey = itemkey) and
921: (wf_item_activity_status.c_actid = actid)) then
922: wf_item_activity_status.c_status := status;
923: if (result is not null) then
924: wf_item_activity_status.c_result := result;
925: end if;
926: if (beginning is not null) then
927: wf_item_activity_status.c_begindate := beginning;
928: wf_item_activity_status.c_duedate := duedate;

Line 927: wf_item_activity_status.c_begindate := beginning;

923: if (result is not null) then
924: wf_item_activity_status.c_result := result;
925: end if;
926: if (beginning is not null) then
927: wf_item_activity_status.c_begindate := beginning;
928: wf_item_activity_status.c_duedate := duedate;
929: end if;
930: if (ending is not null) then
931: wf_item_activity_status.c_enddate := ending;

Line 928: wf_item_activity_status.c_duedate := duedate;

924: wf_item_activity_status.c_result := result;
925: end if;
926: if (beginning is not null) then
927: wf_item_activity_status.c_begindate := beginning;
928: wf_item_activity_status.c_duedate := duedate;
929: end if;
930: if (ending is not null) then
931: wf_item_activity_status.c_enddate := ending;
932: end if;

Line 931: wf_item_activity_status.c_enddate := ending;

927: wf_item_activity_status.c_begindate := beginning;
928: wf_item_activity_status.c_duedate := duedate;
929: end if;
930: if (ending is not null) then
931: wf_item_activity_status.c_enddate := ending;
932: end if;
933: end if;
934: end if;
935:

Line 963: Wf_Core.Context('Wf_Item_Activity_Status', 'Create_Status', itemtype,

959: commit;
960: end if;
961: exception
962: when OTHERS then
963: Wf_Core.Context('Wf_Item_Activity_Status', 'Create_Status', itemtype,
964: itemkey, to_char(actid), status, result);
965: raise;
966: end Create_Status;
967:

Line 994: UPDATE wf_item_activity_statuses

990: l_username := performer;
991: end if;
992:
993: -- update the status record with the action and performer
994: UPDATE wf_item_activity_statuses
995: SET action = Audit.action,
996: performed_by = l_username
997: WHERE item_type = Audit.itemtype
998: AND item_key = Audit.itemkey

Line 1003: --wf_item_activity_statuses table, hence we should not throw an

999: AND process_activity = Audit.actid;
1000:
1001: --Bug 3361746
1002: --The existing handleerror API does not mandatorily require an entry in
1003: --wf_item_activity_statuses table, hence we should not throw an
1004: --exception if no row is found for the activity.
1005:
1006: exception
1007: when others then

Line 1008: Wf_Core.Context('Wf_Item_Activity_Status', 'Audit', itemtype, itemkey, to_char(actid));

1004: --exception if no row is found for the activity.
1005:
1006: exception
1007: when others then
1008: Wf_Core.Context('Wf_Item_Activity_Status', 'Audit', itemtype, itemkey, to_char(actid));
1009: raise;
1010: end Audit;
1011:
1012: -- 3966635 Workflow Provisioning Project

Line 1029: -- UPDATE wf_item_activity_statuses

1025: -- prov_request_id in number)
1026: -- is
1027: -- begin
1028: --
1029: -- UPDATE wf_item_activity_statuses
1030: -- SET prov_request_id = Update_Prov_Request.prov_request_id
1031: -- WHERE item_type = Update_Prov_Request.itemtype
1032: -- AND item_key = Update_Prov_Request.itemkey
1033: -- AND process_activity = Update_Prov_Request.actid;

Line 1037: -- Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Prov_Request', itemtype, itemkey, to_char(actid));

1033: -- AND process_activity = Update_Prov_Request.actid;
1034: --
1035: -- exception
1036: -- when others then
1037: -- Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Prov_Request', itemtype, itemkey, to_char(actid));
1038: -- raise;
1039: -- end Update_Prov_Request;
1040: --
1041: end WF_ITEM_ACTIVITY_STATUS;

Line 1041: end WF_ITEM_ACTIVITY_STATUS;

1037: -- Wf_Core.Context('Wf_Item_Activity_Status', 'Update_Prov_Request', itemtype, itemkey, to_char(actid));
1038: -- raise;
1039: -- end Update_Prov_Request;
1040: --
1041: end WF_ITEM_ACTIVITY_STATUS;