DBA Data[Home] [Help]

APPS.CS_WF_ACTIVITIES_CUST dependencies on WF_ENGINE

Line 43: l_response_deadline := WF_ENGINE.GetActivityAttrDate(

39: BEGIN
40:
41: IF (funmode = 'RUN') THEN
42:
43: l_response_deadline := WF_ENGINE.GetActivityAttrDate(
44: itemtype => itemtype,
45: itemkey => itemkey,
46: actid => actid,
47: aname => 'RESPONSE_DEADLINE' );

Line 52: WF_ENGINE.SetItemAttrDate(

48:
49: IF (l_response_deadline IS NOT NULL) AND
50: (l_response_deadline > sysdate) THEN
51:
52: WF_ENGINE.SetItemAttrDate(
53: itemtype => itemtype,
54: itemkey => itemkey,
55: aname => 'RESPONSE_DEADLINE',
56: avalue => l_response_deadline );

Line 60: l_default_days := WF_ENGINE.GetActivityAttrNumber(

56: avalue => l_response_deadline );
57:
58: ELSE
59:
60: l_default_days := WF_ENGINE.GetActivityAttrNumber(
61: itemtype => itemtype,
62: itemkey => itemkey,
63: actid => actid,
64: aname => 'DEFAULT_DAYS' );

Line 70: WF_ENGINE.SetItemAttrDate(

66: IF (l_default_days IS NULL) THEN
67: l_default_days := 3;
68: END IF;
69:
70: WF_ENGINE.SetItemAttrDate(
71: itemtype => itemtype,
72: itemkey => itemkey,
73: aname => 'RESPONSE_DEADLINE',
74: avalue => sysdate + l_default_days );

Line 143: l_request_id := WF_ENGINE.GetItemAttrNumber(

139: BEGIN
140: IF (funmode = 'RUN') THEN
141:
142: -- Extract the service request record
143: l_request_id := WF_ENGINE.GetItemAttrNumber(
144: itemtype => itemtype,
145: itemkey => itemkey,
146: aname => 'REQUEST_ID' );
147:

Line 192: WF_ENGINE.SetItemAttrText(

188: l_escalation_history := cs_separator ||'
189: '|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') ||'
190: '|| l_escalation_history;
191:
192: WF_ENGINE.SetItemAttrText(
193: itemtype => 'SERVEREQ',
194: itemkey => itemkey,
195: aname => 'ESCALATION_HISTORY',
196: avalue => substrb(l_escalation_history, 1, 2000));

Line 237: l_escalation_comment := WF_ENGINE.GetActivityAttrText(

233: l_escalation_line VARCHAR2(2000);
234: BEGIN
235: IF (funmode = 'RUN') THEN
236:
237: l_escalation_comment := WF_ENGINE.GetActivityAttrText(
238: itemtype => itemtype,
239: itemkey => itemkey,
240: actid => actid,
241: aname => 'ESCALATION_COMMENT' );

Line 243: l_escalation_history := WF_ENGINE.GetItemAttrText(

239: itemkey => itemkey,
240: actid => actid,
241: aname => 'ESCALATION_COMMENT' );
242:
243: l_escalation_history := WF_ENGINE.GetItemAttrText(
244: itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'ESCALATION_HISTORY' );
247:

Line 248: l_owner_name := WF_ENGINE.GetActivityAttrText(

244: itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'ESCALATION_HISTORY' );
247:
248: l_owner_name := WF_ENGINE.GetActivityAttrText(
249: itemtype => itemtype,
250: itemkey => itemkey,
251: actid => actid,
252: aname => 'ESCALATED_TO' );

Line 277: WF_ENGINE.SetItemAttrText(

273: -- Make sure it doesn't exceed 2000 bytes
274: l_escalation_history := substrb(l_escalation_history, 1, 2000);
275:
276: -- Update item attribute
277: WF_ENGINE.SetItemAttrText(
278: itemtype => 'SERVEREQ',
279: itemkey => itemkey,
280: aname => 'ESCALATION_HISTORY',
281: avalue => l_escalation_history );

Line 284: WF_ENGINE.SetItemAttrText(

280: aname => 'ESCALATION_HISTORY',
281: avalue => l_escalation_history );
282:
283: -- Reset escalation comment
284: WF_ENGINE.SetItemAttrText(
285: itemtype => 'SERVEREQ',
286: itemkey => itemkey,
287: aname => 'LAST_ESCALATION_COMMENT',
288: avalue => l_escalation_comment );

Line 290: WF_ENGINE.SetItemAttrText(

286: itemkey => itemkey,
287: aname => 'LAST_ESCALATION_COMMENT',
288: avalue => l_escalation_comment );
289:
290: WF_ENGINE.SetItemAttrText(
291: itemtype => 'SERVEREQ',
292: itemkey => itemkey,
293: aname => 'ESCALATION_COMMENT',
294: avalue => '' );