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.OKC_ASYNC_PVT dependencies on WF_ENGINE

Line 53: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,

49: --
50: -- save apps context
51: --
52: begin
53: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,
54: itemkey => p_key,
55: aname => 'USER_ID',
56: avalue => fnd_global.user_id);
57: IF (l_debug = 'Y') THEN

Line 62: wf_engine.AddItemAttr (itemtype => p_wf_name,

58: okc_debug.Log('001 in set_env user_id:'||fnd_global.user_id,2);
59: END IF;
60: exception
61: when others then
62: wf_engine.AddItemAttr (itemtype => p_wf_name,
63: itemkey => p_key,
64: aname => 'USER_ID');
65: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
66: itemkey => p_key,

Line 65: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,

61: when others then
62: wf_engine.AddItemAttr (itemtype => p_wf_name,
63: itemkey => p_key,
64: aname => 'USER_ID');
65: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
66: itemkey => p_key,
67: aname => 'USER_ID',
68: avalue => fnd_global.user_id);
69: IF (l_debug = 'Y') THEN

Line 74: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,

70: okc_debug.Log('002 in set_env user_id:'||fnd_global.user_id,2);
71: END IF;
72: end;
73: begin
74: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,
75: itemkey => p_key,
76: aname => 'RESP_ID',
77: avalue => fnd_global.resp_id);
78: IF (l_debug = 'Y') THEN

Line 83: wf_engine.AddItemAttr (itemtype => p_wf_name,

79: okc_debug.Log('003 in set_env resp_id:'||fnd_global.resp_id,2);
80: END IF;
81: exception
82: when others then
83: wf_engine.AddItemAttr (itemtype => p_wf_name,
84: itemkey => p_key,
85: aname => 'RESP_ID');
86: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
87: itemkey => p_key,

Line 86: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,

82: when others then
83: wf_engine.AddItemAttr (itemtype => p_wf_name,
84: itemkey => p_key,
85: aname => 'RESP_ID');
86: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
87: itemkey => p_key,
88: aname => 'RESP_ID',
89: avalue => fnd_global.resp_id);
90: IF (l_debug = 'Y') THEN

Line 95: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,

91: okc_debug.Log('004 in set_env resp_id:'||fnd_global.resp_id,2);
92: END IF;
93: end;
94: begin
95: wf_engine.SetItemAttrNumber (itemtype => p_wf_name,
96: itemkey => p_key,
97: aname => 'RESP_APPL_ID',
98: avalue => fnd_global.RESP_APPL_id);
99: IF (l_debug = 'Y') THEN

Line 104: wf_engine.AddItemAttr (itemtype => p_wf_name,

100: okc_debug.Log('005 in set_env resp_id:'||fnd_global.resp_appl_id,2);
101: END IF;
102: exception
103: when others then
104: wf_engine.AddItemAttr (itemtype => p_wf_name,
105: itemkey => p_key,
106: aname => 'RESP_APPL_ID');
107: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
108: itemkey => p_key,

Line 107: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,

103: when others then
104: wf_engine.AddItemAttr (itemtype => p_wf_name,
105: itemkey => p_key,
106: aname => 'RESP_APPL_ID');
107: wf_engine.SetItemAttrNumber(itemtype => p_wf_name,
108: itemkey => p_key,
109: aname => 'RESP_APPL_ID',
110: avalue => fnd_global.RESP_APPL_id);
111: IF (l_debug = 'Y') THEN

Line 118: p_recipient := NVL( wf_engine.GetItemAttrText(p_wf_name,p_key,'P_RESOLVER'),

114: end;
115: --
116: -- save NLS/NTF preferences from P_RESOLVER/P_S_RECIPIENT/P_E_RECIPIENT/apps
117: --
118: p_recipient := NVL( wf_engine.GetItemAttrText(p_wf_name,p_key,'P_RESOLVER'),
119: NVL(wf_engine.GetItemAttrText(p_wf_name,p_key,'P_S_RECIPIENT'),
120: wf_engine.GetItemAttrText(p_wf_name,p_key,'P_E_RECIPIENT')));
121: select value into L_NLS_LANGUAGE
122: from NLS_SESSION_PARAMETERS

Line 119: NVL(wf_engine.GetItemAttrText(p_wf_name,p_key,'P_S_RECIPIENT'),

115: --
116: -- save NLS/NTF preferences from P_RESOLVER/P_S_RECIPIENT/P_E_RECIPIENT/apps
117: --
118: p_recipient := NVL( wf_engine.GetItemAttrText(p_wf_name,p_key,'P_RESOLVER'),
119: NVL(wf_engine.GetItemAttrText(p_wf_name,p_key,'P_S_RECIPIENT'),
120: wf_engine.GetItemAttrText(p_wf_name,p_key,'P_E_RECIPIENT')));
121: select value into L_NLS_LANGUAGE
122: from NLS_SESSION_PARAMETERS
123: where PARAMETER='NLS_LANGUAGE';

Line 120: wf_engine.GetItemAttrText(p_wf_name,p_key,'P_E_RECIPIENT')));

116: -- save NLS/NTF preferences from P_RESOLVER/P_S_RECIPIENT/P_E_RECIPIENT/apps
117: --
118: p_recipient := NVL( wf_engine.GetItemAttrText(p_wf_name,p_key,'P_RESOLVER'),
119: NVL(wf_engine.GetItemAttrText(p_wf_name,p_key,'P_S_RECIPIENT'),
120: wf_engine.GetItemAttrText(p_wf_name,p_key,'P_E_RECIPIENT')));
121: select value into L_NLS_LANGUAGE
122: from NLS_SESSION_PARAMETERS
123: where PARAMETER='NLS_LANGUAGE';
124: select value into L_NLS_TERRITORY

Line 132: wf_engine.SetItemAttrText (itemtype => p_wf_name,

128: fetch nls_csr into l_nls_language, l_nls_territory, l_ntf_pref;
129: close nls_csr;
130: --
131: if ( l_ntf_pref='MAILTEXT' ) then
132: wf_engine.SetItemAttrText (itemtype => p_wf_name,
133: itemkey => p_key,
134: aname => 'PREFORMAT',
135: avalue => '');
136: wf_engine.SetItemAttrText (itemtype => p_wf_name,

Line 136: wf_engine.SetItemAttrText (itemtype => p_wf_name,

132: wf_engine.SetItemAttrText (itemtype => p_wf_name,
133: itemkey => p_key,
134: aname => 'PREFORMAT',
135: avalue => '');
136: wf_engine.SetItemAttrText (itemtype => p_wf_name,
137: itemkey => p_key,
138: aname => 'PREFORMAT_',
139: avalue => '');
140: IF (l_debug = 'Y') THEN

Line 146: wf_engine.SetItemAttrText (itemtype => p_wf_name,

142: END IF;
143: end if;
144: --
145: begin
146: wf_engine.SetItemAttrText (itemtype => p_wf_name,
147: itemkey => p_key,
148: aname => 'NLS_LANGUAGE',
149: avalue => ''''||l_nls_language||'''');
150: exception

Line 152: wf_engine.AddItemAttr (itemtype => p_wf_name,

148: aname => 'NLS_LANGUAGE',
149: avalue => ''''||l_nls_language||'''');
150: exception
151: when others then
152: wf_engine.AddItemAttr (itemtype => p_wf_name,
153: itemkey => p_key,
154: aname => 'NLS_LANGUAGE');
155: wf_engine.SetItemAttrText(itemtype => p_wf_name,
156: itemkey => p_key,

Line 155: wf_engine.SetItemAttrText(itemtype => p_wf_name,

151: when others then
152: wf_engine.AddItemAttr (itemtype => p_wf_name,
153: itemkey => p_key,
154: aname => 'NLS_LANGUAGE');
155: wf_engine.SetItemAttrText(itemtype => p_wf_name,
156: itemkey => p_key,
157: aname => 'NLS_LANGUAGE',
158: avalue => ''''||l_nls_language||'''');
159: end;

Line 161: wf_engine.SetItemAttrText (itemtype => p_wf_name,

157: aname => 'NLS_LANGUAGE',
158: avalue => ''''||l_nls_language||'''');
159: end;
160: begin
161: wf_engine.SetItemAttrText (itemtype => p_wf_name,
162: itemkey => p_key,
163: aname => 'NLS_TERRITORY',
164: avalue => ''''||l_nls_territory||'''');
165: exception

Line 167: wf_engine.AddItemAttr (itemtype => p_wf_name,

163: aname => 'NLS_TERRITORY',
164: avalue => ''''||l_nls_territory||'''');
165: exception
166: when others then
167: wf_engine.AddItemAttr (itemtype => p_wf_name,
168: itemkey => p_key,
169: aname => 'NLS_TERRITORY');
170: wf_engine.SetItemAttrText(itemtype => p_wf_name,
171: itemkey => p_key,

Line 170: wf_engine.SetItemAttrText(itemtype => p_wf_name,

166: when others then
167: wf_engine.AddItemAttr (itemtype => p_wf_name,
168: itemkey => p_key,
169: aname => 'NLS_TERRITORY');
170: wf_engine.SetItemAttrText(itemtype => p_wf_name,
171: itemkey => p_key,
172: aname => 'NLS_TERRITORY',
173: avalue => ''''||l_nls_territory||'''');
174: end;

Line 176: wf_engine.SetItemAttrText (itemtype => p_wf_name,

172: aname => 'NLS_TERRITORY',
173: avalue => ''''||l_nls_territory||'''');
174: end;
175: begin
176: wf_engine.SetItemAttrText (itemtype => p_wf_name,
177: itemkey => p_key,
178: aname => 'NTF_PREF',
179: avalue => l_ntf_pref);
180: exception

Line 182: wf_engine.AddItemAttr (itemtype => p_wf_name,

178: aname => 'NTF_PREF',
179: avalue => l_ntf_pref);
180: exception
181: when others then
182: wf_engine.AddItemAttr (itemtype => p_wf_name,
183: itemkey => p_key,
184: aname => 'NTF_PREF');
185: wf_engine.SetItemAttrText (itemtype => p_wf_name,
186: itemkey => p_key,

Line 185: wf_engine.SetItemAttrText (itemtype => p_wf_name,

181: when others then
182: wf_engine.AddItemAttr (itemtype => p_wf_name,
183: itemkey => p_key,
184: aname => 'NTF_PREF');
185: wf_engine.SetItemAttrText (itemtype => p_wf_name,
186: itemkey => p_key,
187: aname => 'NTF_PREF',
188: avalue => l_ntf_pref);
189: IF (l_debug = 'Y') THEN

Line 281: wf_engine.CreateProcess( ItemType => G_WF_NAME,

277: IF (l_debug = 'Y') THEN
278: okc_debug.Log('30: l_key : '||l_key,2);
279: END IF;
280:
281: wf_engine.CreateProcess( ItemType => G_WF_NAME,
282: ItemKey => L_KEY,
283: process => G_PROCESS_NAME);
284: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
285: ItemKey => L_KEY,

Line 284: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,

280:
281: wf_engine.CreateProcess( ItemType => G_WF_NAME,
282: ItemKey => L_KEY,
283: process => G_PROCESS_NAME);
284: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
285: ItemKey => L_KEY,
286: UserKey => L_KEY);
287: --
288: -- design time attr !

Line 290: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

286: UserKey => L_KEY);
287: --
288: -- design time attr !
289: --
290: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
291: itemkey => L_KEY,
292: aname => 'P_PROC',
293: avalue => P_PROC);
294: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 294: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

290: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
291: itemkey => L_KEY,
292: aname => 'P_PROC',
293: avalue => P_PROC);
294: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
295: itemkey => L_KEY,
296: aname => 'P_SUBJ_FIRST_MSG',
297: avalue => P_SUBJ_FIRST_MSG);
298: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 298: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

294: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
295: itemkey => L_KEY,
296: aname => 'P_SUBJ_FIRST_MSG',
297: avalue => P_SUBJ_FIRST_MSG);
298: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
299: itemkey => L_KEY,
300: aname => 'P_NTF_TYPE',
301: avalue => P_NTF_TYPE);
302: --

Line 303: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

299: itemkey => L_KEY,
300: aname => 'P_NTF_TYPE',
301: avalue => P_NTF_TYPE);
302: --
303: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
304: itemkey => L_KEY,
305: aname => 'P_E_RECIPIENT',
306: avalue => P_E_RECIPIENT);
307: --

Line 309: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

305: aname => 'P_E_RECIPIENT',
306: avalue => P_E_RECIPIENT);
307: --
308: if (p_proc is NULL and p_s_recipient is NULL) then
309: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
310: itemkey => L_KEY,
311: aname => 'P_S_RECIPIENT',
312: avalue => fnd_global.user_name);
313: IF (l_debug = 'Y') THEN

Line 317: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

313: IF (l_debug = 'Y') THEN
314: okc_debug.Log('009 in wf_call p_s_recipient :'||fnd_global.user_name,2);
315: END IF;
316: else
317: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
318: itemkey => L_KEY,
319: aname => 'P_S_RECIPIENT',
320: avalue => P_S_RECIPIENT);
321: IF (l_debug = 'Y') THEN

Line 341: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

337: IF (l_debug = 'Y') THEN
338: okc_debug.Log('50: Inside Loop ',2);
339: END IF;
340: if ( (p_wf_par_tbl(i).par_type is NULL) or (p_wf_par_tbl(i).par_type = 'C') ) then
341: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
342: itemkey => L_KEY,
343: aname => p_wf_par_tbl(i).par_name,
344: avalue => p_wf_par_tbl(i).par_value);
345: IF (l_debug = 'Y') THEN

Line 356: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

352: okc_debug.Log('60: P_VERSION := 4 ',2);
353: END IF;
354: end if;
355: elsif (p_wf_par_tbl(i).par_type = 'N') then
356: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
357: itemkey => L_KEY,
358: aname => p_wf_par_tbl(i).par_name,
359: avalue => to_number(p_wf_par_tbl(i).par_value));
360: IF (l_debug = 'Y') THEN

Line 365: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,

361: okc_debug.Log('70: p_wf_par_tbl(i).par_name : '||p_wf_par_tbl(i).par_name,2);
362: okc_debug.Log('70: p_wf_par_tbl(i).par_value : '||p_wf_par_tbl(i).par_value,2);
363: END IF;
364: elsif (p_wf_par_tbl(i).par_type = 'D') then
365: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,
366: itemkey => L_KEY,
367: aname => p_wf_par_tbl(i).par_name,
368: avalue => to_date(p_wf_par_tbl(i).par_value,'YYYY/MM/DD'));
369: IF (l_debug = 'Y') THEN

Line 383: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

379: okc_debug.Log('90: out nocopy of Loop ',2);
380: END IF;
381: end if;
382: --
383: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
384: itemkey => L_KEY,
385: aname => 'P_KEY',
386: avalue => L_KEY);
387: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 387: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

383: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
384: itemkey => L_KEY,
385: aname => 'P_KEY',
386: avalue => L_KEY);
387: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
388: itemkey => L_KEY,
389: aname => 'P_VERSION',
390: avalue => P_VERSION);
391:

Line 400: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,

396: --
397: -- save env / start
398: --
399: save_env(G_WF_NAME, l_key);
400: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
401: itemkey => L_KEY,
402: owner => fnd_global.user_name);
403:
404: IF (l_debug = 'Y') THEN

Line 408: wf_engine.StartProcess( itemtype => G_WF_NAME,

404: IF (l_debug = 'Y') THEN
405: okc_debug.Log('100: WF Owner : '||fnd_global.user_name,2);
406: END IF;
407:
408: wf_engine.StartProcess( itemtype => G_WF_NAME,
409: itemkey => L_KEY);
410:
411: IF (l_debug = 'Y') THEN
412: okc_debug.Log('110: Started WF ',2);

Line 499: l_version := wf_engine.GetItemAttrNumber(p_wf_name,p_key,'P_VERSION');

495: --
496: -- do nothing for previous version
497: --
498: begin
499: l_version := wf_engine.GetItemAttrNumber(p_wf_name,p_key,'P_VERSION');
500: exception
501: when others then
502: l_version := 1;
503: end;

Line 519: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'USER_ID'),

515: --
516: fnd_global.apps_initialize
517: (
518: user_id =>
519: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'USER_ID'),
520: resp_id =>
521: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_ID'),
522: resp_appl_id =>
523: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_APPL_ID')

Line 521: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_ID'),

517: (
518: user_id =>
519: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'USER_ID'),
520: resp_id =>
521: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_ID'),
522: resp_appl_id =>
523: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_APPL_ID')
524: );
525: IF (l_debug = 'Y') THEN

Line 523: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_APPL_ID')

519: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'USER_ID'),
520: resp_id =>
521: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_ID'),
522: resp_appl_id =>
523: wf_engine.GetItemAttrNumber(p_wf_name,p_key,'RESP_APPL_ID')
524: );
525: IF (l_debug = 'Y') THEN
526: okc_debug.Log('100-11: Printing Apps Context in okc_asynch_pvt.set_env after call to fnd_global.apps_initialize...',2);
527: okc_debug.Log('100-12: USER_ID = '|| to_char(fnd_global.user_id),2);

Line 536: l_nls_language := wf_engine.GetItemAttrText(p_wf_name,p_key,'NLS_LANGUAGE');

532:
533: --
534: -- set nls context if different
535: --
536: l_nls_language := wf_engine.GetItemAttrText(p_wf_name,p_key,'NLS_LANGUAGE');
537: l_nls_territory := wf_engine.GetItemAttrText(p_wf_name,p_key,'NLS_TERRITORY');
538: open c1('NLS_LANGUAGE');
539: fetch c1 into L1;
540: close c1;

Line 537: l_nls_territory := wf_engine.GetItemAttrText(p_wf_name,p_key,'NLS_TERRITORY');

533: --
534: -- set nls context if different
535: --
536: l_nls_language := wf_engine.GetItemAttrText(p_wf_name,p_key,'NLS_LANGUAGE');
537: l_nls_territory := wf_engine.GetItemAttrText(p_wf_name,p_key,'NLS_TERRITORY');
538: open c1('NLS_LANGUAGE');
539: fetch c1 into L1;
540: close c1;
541: if (L1<>l_nls_language) then

Line 694: P_VERSION := to_char(wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION'));

690: -- RUN mode - normal process execution
691: --
692: if (funcmode = 'RUN') then
693: begin
694: P_VERSION := to_char(wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION'));
695: IF (l_debug = 'Y') THEN
696: okc_debug.Log('30: P_VERSION : '||P_VERSION,2);
697: END IF;
698: exception

Line 791: P_PROC := wf_engine.GetItemAttrText (itemtype => G_WF_NAME,

787: okc_debug.Log('20: p_attr_name : '||p_attr_name,2);
788: END IF;
789:
790: x_return_status := 'S';
791: P_PROC := wf_engine.GetItemAttrText (itemtype => G_WF_NAME,
792: itemkey => P_KEY,
793: aname => p_attr_name);
794: -- marat start (bug#2477385)
795: okc_wf.init_wf_string( wf_engine.GetItemAttrText ( itemtype => G_WF_NAME,

Line 795: okc_wf.init_wf_string( wf_engine.GetItemAttrText ( itemtype => G_WF_NAME,

791: P_PROC := wf_engine.GetItemAttrText (itemtype => G_WF_NAME,
792: itemkey => P_KEY,
793: aname => p_attr_name);
794: -- marat start (bug#2477385)
795: okc_wf.init_wf_string( wf_engine.GetItemAttrText ( itemtype => G_WF_NAME,
796: itemkey => P_KEY,
797: aname => 'EXTRA_ATTR_TEXT'));
798: -- marat end
799: P_VERSION := wf_engine.GetItemAttrNumber (itemtype => G_WF_NAME,

Line 799: P_VERSION := wf_engine.GetItemAttrNumber (itemtype => G_WF_NAME,

795: okc_wf.init_wf_string( wf_engine.GetItemAttrText ( itemtype => G_WF_NAME,
796: itemkey => P_KEY,
797: aname => 'EXTRA_ATTR_TEXT'));
798: -- marat end
799: P_VERSION := wf_engine.GetItemAttrNumber (itemtype => G_WF_NAME,
800: itemkey => P_KEY,
801: aname => 'P_VERSION');
802: savepoint exec_call_sp;
803: if (P_VERSION in (2,5)) then

Line 824: wf_engine.GetItemAttrText (

820: end if;
821: elsif (P_VERSION = 3) then
822: begin
823: EXECUTE IMMEDIATE P_PROC USING
824: wf_engine.GetItemAttrText (
825: itemtype => G_WF_NAME,
826: itemkey => P_KEY,
827: aname => 'NOTE');
828: EXCEPTION WHEN OTHERS THEN

Line 889: P_SUBJ_FIRST_MSG := wf_engine.GetItemAttrText(itemtype,itemkey,'P_SUBJ_FIRST_MSG');

885: okc_debug.Log('10: Entering ',2);
886: END IF;
887:
888: nl:=fnd_global.NewLine;
889: P_SUBJ_FIRST_MSG := wf_engine.GetItemAttrText(itemtype,itemkey,'P_SUBJ_FIRST_MSG');
890: j := NVL(FND_MSG_PUB.Count_Msg,0);
891:
892: if (j=0) then
893:

Line 903: l_contract_id := (wf_engine.GetItemAttrText (itemtype => itemtype,

899: okc_debug.Log('50: Message Count is Zero ',2);
900: okc_debug.Reset_Indentation;
901: END IF;
902:
903: l_contract_id := (wf_engine.GetItemAttrText (itemtype => itemtype,
904: itemkey => itemkey,
905: aname => 'CONTRACT_ID'));
906: l_proc_name := (wf_engine.GetItemAttrText (itemtype => itemtype,
907: itemkey => itemkey,

Line 906: l_proc_name := (wf_engine.GetItemAttrText (itemtype => itemtype,

902:
903: l_contract_id := (wf_engine.GetItemAttrText (itemtype => itemtype,
904: itemkey => itemkey,
905: aname => 'CONTRACT_ID'));
906: l_proc_name := (wf_engine.GetItemAttrText (itemtype => itemtype,
907: itemkey => itemkey,
908: aname => 'P_PROC_NAME'));
909: IF l_contract_id IS NOT NULL THEN
910: BEGIN

Line 950: wf_engine.SetItemAttrText (itemtype => itemtype,

946: p_token2 => 'PROCESS_NAME',
947: p_token2_value => l_proc_name);
948: END IF;
949:
950: wf_engine.SetItemAttrText (itemtype => itemtype,
951: itemkey => itemkey,
952: aname => 'MESSAGE0',
953: avalue => FND_MSG_PUB.Get(2,p_encoded =>FND_API.G_FALSE ));
954:

Line 955: wf_engine.SetItemAttrText (itemtype => itemtype,

951: itemkey => itemkey,
952: aname => 'MESSAGE0',
953: avalue => FND_MSG_PUB.Get(2,p_encoded =>FND_API.G_FALSE ));
954:
955: wf_engine.SetItemAttrText (itemtype => itemtype,
956: itemkey => itemkey,
957: aname => 'MESSAGE1',
958: avalue => FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
959: --END NPALEPU

Line 970: wf_engine.SetItemAttrText (itemtype => itemtype,

966:
967: end if;
968:
969: if (P_SUBJ_FIRST_MSG = 'T') then
970: wf_engine.SetItemAttrText (itemtype => itemtype,
971: itemkey => itemkey,
972: aname => 'MESSAGE0',
973: avalue => FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
974: i:=2;

Line 976: wf_engine.SetItemAttrText (itemtype => itemtype,

972: aname => 'MESSAGE0',
973: avalue => FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
974: i:=2;
975: else
976: wf_engine.SetItemAttrText (itemtype => itemtype,
977: itemkey => itemkey,
978: aname => 'MESSAGE0',
979: avalue => FND_MSG_PUB.Get(j,p_encoded =>FND_API.G_FALSE ));
980: j:=j-1;

Line 983: text_limit:=text_limit-length(wf_engine.GetItemAttrText (itemtype => itemtype,

979: avalue => FND_MSG_PUB.Get(j,p_encoded =>FND_API.G_FALSE ));
980: j:=j-1;
981: i:=1;
982: end if;
983: text_limit:=text_limit-length(wf_engine.GetItemAttrText (itemtype => itemtype,
984: itemkey => itemkey,
985: aname => 'MESSAGE0'));
986: k:=1; -- msg index
987: LOOP

Line 1003: wf_engine.SetItemAttrText (itemtype => itemtype,

999: end if;
1000: i:=i+1;
1001: if (i>j) then exit; end if;
1002: END LOOP;
1003: wf_engine.SetItemAttrText (itemtype => itemtype,
1004: itemkey => itemkey,
1005: aname => 'MESSAGE'||to_char(k),
1006: avalue => msg_buf);
1007: text_limit:=text_limit-length(msg_buf);

Line 1009: wf_engine.SetItemAttrText (itemtype => itemtype,

1005: aname => 'MESSAGE'||to_char(k),
1006: avalue => msg_buf);
1007: text_limit:=text_limit-length(msg_buf);
1008: if (text_limit<0) then
1009: wf_engine.SetItemAttrText (itemtype => itemtype,
1010: itemkey => itemkey,
1011: aname => 'MESSAGE'||to_char(k),
1012: avalue => '');
1013: exit;

Line 1067: wf_engine.SetItemAttrNumber (itemtype, itemkey, 'P_TIMEOUT_MINUTES', L_TIMEOUT_MINUTES);

1063: /* MSENGUPT: Introduced the following code to re-read and reset the profile option in case of timeouts due to errors */
1064: if (funcmode <> 'RUN') then
1065: l_timeout_minutes := fnd_profile.value('OKC_ALERT_TIMEOUT');
1066: if l_timeout_minutes IS NOT NULL then
1067: wf_engine.SetItemAttrNumber (itemtype, itemkey, 'P_TIMEOUT_MINUTES', L_TIMEOUT_MINUTES);
1068: end if;
1069: end if;
1070: /* End of code insert */
1071:

Line 1080: if (wf_engine.GetItemAttrText(itemtype,itemkey,'P_PROC') is NULL) then

1076: FND_MSG_PUB.initialize;
1077: IF (l_debug = 'Y') THEN
1078: okc_debug.Log('30: ',2);
1079: END IF;
1080: if (wf_engine.GetItemAttrText(itemtype,itemkey,'P_PROC') is NULL) then
1081: IF (l_debug = 'Y') THEN
1082: okc_debug.Log('40 ',2);
1083: END IF;
1084: resultout := 'COMPLETE:S';

Line 1086: if (wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION') = 5) then

1082: okc_debug.Log('40 ',2);
1083: END IF;
1084: resultout := 'COMPLETE:S';
1085: else
1086: if (wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION') = 5) then
1087: wf_engine.SetItemAttrText (
1088: itemtype => itemtype,
1089: itemkey => itemkey,
1090: aname => 'MESSAGE0',

Line 1087: wf_engine.SetItemAttrText (

1083: END IF;
1084: resultout := 'COMPLETE:S';
1085: else
1086: if (wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION') = 5) then
1087: wf_engine.SetItemAttrText (
1088: itemtype => itemtype,
1089: itemkey => itemkey,
1090: aname => 'MESSAGE0',
1091: avalue => '');

Line 1092: wf_engine.SetItemAttrText (

1088: itemtype => itemtype,
1089: itemkey => itemkey,
1090: aname => 'MESSAGE0',
1091: avalue => '');
1092: wf_engine.SetItemAttrText (
1093: itemtype => itemtype,
1094: itemkey => itemkey,
1095: aname => 'MESSAGE1',
1096: avalue => '');

Line 1097: wf_engine.SetItemAttrText (

1093: itemtype => itemtype,
1094: itemkey => itemkey,
1095: aname => 'MESSAGE1',
1096: avalue => '');
1097: wf_engine.SetItemAttrText (
1098: itemtype => itemtype,
1099: itemkey => itemkey,
1100: aname => 'MESSAGE2',
1101: avalue => '');

Line 1102: wf_engine.SetItemAttrText (

1098: itemtype => itemtype,
1099: itemkey => itemkey,
1100: aname => 'MESSAGE2',
1101: avalue => '');
1102: wf_engine.SetItemAttrText (
1103: itemtype => itemtype,
1104: itemkey => itemkey,
1105: aname => 'MESSAGE3',
1106: avalue => '');

Line 1107: wf_engine.SetItemAttrText (

1103: itemtype => itemtype,
1104: itemkey => itemkey,
1105: aname => 'MESSAGE3',
1106: avalue => '');
1107: wf_engine.SetItemAttrText (
1108: itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'MESSAGE4',
1111: avalue => '');

Line 1112: wf_engine.SetItemAttrText (

1108: itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'MESSAGE4',
1111: avalue => '');
1112: wf_engine.SetItemAttrText (
1113: itemtype => itemtype,
1114: itemkey => itemkey,
1115: aname => 'MESSAGE5',
1116: avalue => '');

Line 1117: wf_engine.SetItemAttrText (

1113: itemtype => itemtype,
1114: itemkey => itemkey,
1115: aname => 'MESSAGE5',
1116: avalue => '');
1117: wf_engine.SetItemAttrText (
1118: itemtype => itemtype,
1119: itemkey => itemkey,
1120: aname => 'MESSAGE6',
1121: avalue => '');

Line 1122: wf_engine.SetItemAttrText (

1118: itemtype => itemtype,
1119: itemkey => itemkey,
1120: aname => 'MESSAGE6',
1121: avalue => '');
1122: wf_engine.SetItemAttrText (
1123: itemtype => itemtype,
1124: itemkey => itemkey,
1125: aname => 'MESSAGE7',
1126: avalue => '');

Line 1127: wf_engine.SetItemAttrText (

1123: itemtype => itemtype,
1124: itemkey => itemkey,
1125: aname => 'MESSAGE7',
1126: avalue => '');
1127: wf_engine.SetItemAttrText (
1128: itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'MESSAGE8',
1131: avalue => '');

Line 1132: wf_engine.SetItemAttrText (

1128: itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'MESSAGE8',
1131: avalue => '');
1132: wf_engine.SetItemAttrText (
1133: itemtype => itemtype,
1134: itemkey => itemkey,
1135: aname => 'MESSAGE9',
1136: avalue => '');

Line 1144: (wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT') is not NULL)) then

1140: IF (l_debug = 'Y') THEN
1141: okc_debug.Log('50 ',2);
1142: END IF;
1143: if ((x_return_status = 'S') and
1144: (wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT') is not NULL)) then
1145: --NPALEPU
1146: --14-DEC-2005
1147: --For bug # 4699009
1148: /* load_mess(itemtype,itemkey); */

Line 1152: p_recipient := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');

1148: /* load_mess(itemtype,itemkey); */
1149: load_mess(itemtype,itemkey,x_return_status);
1150: --END NPALEPU
1151: --
1152: p_recipient := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');
1153: IF (l_debug = 'Y') THEN
1154: okc_debug.Log('60 ',2);
1155: END IF;
1156: open pref_csr;

Line 1165: wf_engine.SetItemAttrText (itemtype => itemtype,

1161: okc_debug.Log('70 l_pref : '||l_pref);
1162: END IF;
1163:
1164: if (l_pref='MAILTEXT') then
1165: wf_engine.SetItemAttrText (itemtype => itemtype,
1166: itemkey => itemkey,
1167: aname => 'PREFORMAT',
1168: avalue => '');
1169: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1169: wf_engine.SetItemAttrText (itemtype => itemtype,

1165: wf_engine.SetItemAttrText (itemtype => itemtype,
1166: itemkey => itemkey,
1167: aname => 'PREFORMAT',
1168: avalue => '');
1169: wf_engine.SetItemAttrText (itemtype => itemtype,
1170: itemkey => itemkey,
1171: aname => 'PREFORMAT_',
1172: avalue => '');
1173: end if;

Line 1177: (wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT') is not NULL)) then

1173: end if;
1174: --
1175: resultout := 'COMPLETE:S';
1176: elsif ((x_return_status in ('E','U')) and
1177: (wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT') is not NULL)) then
1178: --NPALEPU
1179: --14-DEC-2005
1180: --For bug # 4699009
1181: /* load_mess(itemtype,itemkey); */

Line 1185: p_recipient := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');

1181: /* load_mess(itemtype,itemkey); */
1182: load_mess(itemtype,itemkey,x_return_status);
1183: --END NPALEPU
1184: --
1185: p_recipient := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');
1186: open pref_csr;
1187: fetch pref_csr into l_pref;
1188: close pref_csr;
1189:

Line 1195: wf_engine.SetItemAttrText (itemtype => itemtype,

1191: okc_debug.Log('80 l_pref : '||l_pref);
1192: END IF;
1193:
1194: if (l_pref='MAILTEXT') then
1195: wf_engine.SetItemAttrText (itemtype => itemtype,
1196: itemkey => itemkey,
1197: aname => 'PREFORMAT',
1198: avalue => '');
1199: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 1199: wf_engine.SetItemAttrText (itemtype => itemtype,

1195: wf_engine.SetItemAttrText (itemtype => itemtype,
1196: itemkey => itemkey,
1197: aname => 'PREFORMAT',
1198: avalue => '');
1199: wf_engine.SetItemAttrText (itemtype => itemtype,
1200: itemkey => itemkey,
1201: aname => 'PREFORMAT_',
1202: avalue => '');
1203: end if;

Line 1610: wf_engine.CreateProcess( ItemType => G_WF_NAME,

1606: --
1607: -- create process
1608: --
1609: select to_char(okc_wf_notify_s1.nextval) into l_key from dual;
1610: wf_engine.CreateProcess( ItemType => G_WF_NAME,
1611: ItemKey => L_KEY,
1612: process => G_PROCESS_NAME);
1613: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
1614: ItemKey => L_KEY,

Line 1613: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,

1609: select to_char(okc_wf_notify_s1.nextval) into l_key from dual;
1610: wf_engine.CreateProcess( ItemType => G_WF_NAME,
1611: ItemKey => L_KEY,
1612: process => G_PROCESS_NAME);
1613: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
1614: ItemKey => L_KEY,
1615: UserKey => L_KEY);
1616: --
1617: -- design time attr !

Line 1620: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1616: --
1617: -- design time attr !
1618: --
1619:
1620: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1621: itemkey => L_KEY,
1622: aname => 'P_RESOLVER',
1623: avalue => P_RESOLVER);
1624: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 1624: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1620: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1621: itemkey => L_KEY,
1622: aname => 'P_RESOLVER',
1623: avalue => P_RESOLVER);
1624: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1625: itemkey => L_KEY,
1626: aname => 'MSG_SUBJ_RESOLVER',
1627: avalue => P_MSG_SUBJ_RESOLVER);
1628: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 1628: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1624: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1625: itemkey => L_KEY,
1626: aname => 'MSG_SUBJ_RESOLVER',
1627: avalue => P_MSG_SUBJ_RESOLVER);
1628: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1629: itemkey => L_KEY,
1630: aname => 'MSG_BODY_RESOLVER',
1631: avalue => P_MSG_BODY_RESOLVER);
1632: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 1632: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1628: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1629: itemkey => L_KEY,
1630: aname => 'MSG_BODY_RESOLVER',
1631: avalue => P_MSG_BODY_RESOLVER);
1632: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1633: itemkey => L_KEY,
1634: aname => 'NOTE',
1635: avalue => P_NOTE);
1636: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 1636: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1632: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1633: itemkey => L_KEY,
1634: aname => 'NOTE',
1635: avalue => P_NOTE);
1636: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1637: itemkey => L_KEY,
1638: aname => 'P_ACCEPT_PROC',
1639: avalue => P_ACCEPT_PROC);
1640: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 1640: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1636: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1637: itemkey => L_KEY,
1638: aname => 'P_ACCEPT_PROC',
1639: avalue => P_ACCEPT_PROC);
1640: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1641: itemkey => L_KEY,
1642: aname => 'P_REJECT_PROC',
1643: avalue => P_REJECT_PROC);
1644: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 1644: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1640: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1641: itemkey => L_KEY,
1642: aname => 'P_REJECT_PROC',
1643: avalue => P_REJECT_PROC);
1644: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1645: itemkey => L_KEY,
1646: aname => 'P_TIMEOUT_PROC',
1647: avalue => NVL(P_TIMEOUT_PROC,P_REJECT_PROC));
1648: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 1648: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

1644: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1645: itemkey => L_KEY,
1646: aname => 'P_TIMEOUT_PROC',
1647: avalue => NVL(P_TIMEOUT_PROC,P_REJECT_PROC));
1648: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1649: itemkey => L_KEY,
1650: aname => 'P_TIMEOUT_MINUTES',
1651: avalue => P_TIMEOUT_MINUTES);
1652: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 1652: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1648: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1649: itemkey => L_KEY,
1650: aname => 'P_TIMEOUT_MINUTES',
1651: avalue => P_TIMEOUT_MINUTES);
1652: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1653: itemkey => L_KEY,
1654: aname => 'P_NTF_TYPE',
1655: avalue => P_NTF_TYPE);
1656: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 1656: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

1652: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1653: itemkey => L_KEY,
1654: aname => 'P_NTF_TYPE',
1655: avalue => P_NTF_TYPE);
1656: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1657: itemkey => L_KEY,
1658: aname => 'CONTRACT_ID',
1659: avalue => P_CONTRACT_ID);
1660: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 1660: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

1656: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1657: itemkey => L_KEY,
1658: aname => 'CONTRACT_ID',
1659: avalue => P_CONTRACT_ID);
1660: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1661: itemkey => L_KEY,
1662: aname => 'TASK_ID',
1663: avalue => P_TASK_ID);
1664: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 1664: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

1660: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1661: itemkey => L_KEY,
1662: aname => 'TASK_ID',
1663: avalue => P_TASK_ID);
1664: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1665: itemkey => L_KEY,
1666: aname => 'EXTRA_ATTR_NUM',
1667: avalue => P_EXTRA_ATTR_NUM);
1668: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 1668: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

1664: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1665: itemkey => L_KEY,
1666: aname => 'EXTRA_ATTR_NUM',
1667: avalue => P_EXTRA_ATTR_NUM);
1668: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1669: itemkey => L_KEY,
1670: aname => 'EXTRA_ATTR_TEXT',
1671: avalue => P_EXTRA_ATTR_TEXT);
1672: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,

Line 1672: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,

1668: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1669: itemkey => L_KEY,
1670: aname => 'EXTRA_ATTR_TEXT',
1671: avalue => P_EXTRA_ATTR_TEXT);
1672: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,
1673: itemkey => L_KEY,
1674: aname => 'EXTRA_ATTR_DATE',
1675: avalue => P_EXTRA_ATTR_DATE);
1676: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 1676: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

1672: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,
1673: itemkey => L_KEY,
1674: aname => 'EXTRA_ATTR_DATE',
1675: avalue => P_EXTRA_ATTR_DATE);
1676: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1677: itemkey => L_KEY,
1678: aname => 'P_VERSION',
1679: avalue => 3);
1680: --

Line 1684: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,

1680: --
1681: -- save env / start
1682: --
1683: save_env(G_WF_NAME, l_key);
1684: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
1685: itemkey => L_KEY,
1686: owner => fnd_global.user_name);
1687: wf_engine.StartProcess( itemtype => G_WF_NAME,
1688: itemkey => L_KEY);

Line 1687: wf_engine.StartProcess( itemtype => G_WF_NAME,

1683: save_env(G_WF_NAME, l_key);
1684: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
1685: itemkey => L_KEY,
1686: owner => fnd_global.user_name);
1687: wf_engine.StartProcess( itemtype => G_WF_NAME,
1688: itemkey => L_KEY);
1689: -- commit;
1690: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1691: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1763: P_PERIOD_DAYS := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PERIOD_DAYS');

1759: -- RUN mode - normal process execution
1760: --
1761: if (funcmode = 'RUN') then
1762: begin
1763: P_PERIOD_DAYS := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PERIOD_DAYS');
1764: P_STOP_DATE := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_STOP_DATE');
1765: exception
1766: when others then
1767: NULL;

Line 1764: P_STOP_DATE := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_STOP_DATE');

1760: --
1761: if (funcmode = 'RUN') then
1762: begin
1763: P_PERIOD_DAYS := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PERIOD_DAYS');
1764: P_STOP_DATE := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_STOP_DATE');
1765: exception
1766: when others then
1767: NULL;
1768: end;

Line 1850: if (sysdate >= wf_engine.GetItemAttrDate(itemtype,itemkey,'P_STOP_DATE')) then

1846: --
1847: -- RUN mode - normal process execution
1848: --
1849: if (funcmode = 'RUN') then
1850: if (sysdate >= wf_engine.GetItemAttrDate(itemtype,itemkey,'P_STOP_DATE')) then
1851: resultout := 'COMPLETE:T';
1852: else
1853: resultout := 'COMPLETE:F';
1854: end if;

Line 1935: EXECUTE IMMEDIATE wf_engine.GetItemAttrText(G_WF_NAME,document_id,'P_DOC_PROC') USING IN OUT document;

1931: END IF;
1932:
1933: savepoint get_doc;
1934: begin
1935: EXECUTE IMMEDIATE wf_engine.GetItemAttrText(G_WF_NAME,document_id,'P_DOC_PROC') USING IN OUT document;
1936: exception
1937: when others then
1938: rollback to get_doc;
1939: end;

Line 2077: wf_engine.CreateProcess( ItemType => G_WF_NAME,

2073: okc_debug.Log('40: G_WF_NAME : '||G_WF_NAME,2);
2074: okc_debug.Log('40: G_PROCESS_NAME : '||G_PROCESS_NAME,2);
2075: END IF;
2076:
2077: wf_engine.CreateProcess( ItemType => G_WF_NAME,
2078: ItemKey => L_KEY,
2079: process => G_PROCESS_NAME);
2080: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
2081: ItemKey => L_KEY,

Line 2080: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,

2076:
2077: wf_engine.CreateProcess( ItemType => G_WF_NAME,
2078: ItemKey => L_KEY,
2079: process => G_PROCESS_NAME);
2080: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
2081: ItemKey => L_KEY,
2082: UserKey => L_KEY);
2083: --
2084: -- design time attr !

Line 2087: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

2083: --
2084: -- design time attr !
2085: --
2086:
2087: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2088: itemkey => L_KEY,
2089: aname => 'P_VERSION',
2090: avalue => 5);
2091: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 2091: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2087: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2088: itemkey => L_KEY,
2089: aname => 'P_VERSION',
2090: avalue => 5);
2091: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2092: itemkey => L_KEY,
2093: aname => 'P_PROC',
2094: avalue => P_PROC);
2095: --NPALEPU,14-DEC-2005

Line 2097: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2093: aname => 'P_PROC',
2094: avalue => P_PROC);
2095: --NPALEPU,14-DEC-2005
2096: --bug # 4699009
2097: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2098: itemkey => L_KEY,
2099: aname => 'P_PROC_NAME',
2100: avalue => P_PROC_NAME);
2101: --END NPALEPU

Line 2102: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2098: itemkey => L_KEY,
2099: aname => 'P_PROC_NAME',
2100: avalue => P_PROC_NAME);
2101: --END NPALEPU
2102: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2103: itemkey => L_KEY,
2104: aname => 'P_S_RECIPIENT',
2105: avalue => P_S_RECIPIENT);
2106: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 2106: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2102: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2103: itemkey => L_KEY,
2104: aname => 'P_S_RECIPIENT',
2105: avalue => P_S_RECIPIENT);
2106: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2107: itemkey => L_KEY,
2108: aname => 'P_E_RECIPIENT',
2109: avalue => P_E_RECIPIENT);
2110: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 2110: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

2106: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2107: itemkey => L_KEY,
2108: aname => 'P_E_RECIPIENT',
2109: avalue => P_E_RECIPIENT);
2110: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2111: itemkey => L_KEY,
2112: aname => 'P_TIMEOUT_MINUTES',
2113: avalue => L_TIMEOUT_MINUTES);
2114: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 2114: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

2110: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2111: itemkey => L_KEY,
2112: aname => 'P_TIMEOUT_MINUTES',
2113: avalue => L_TIMEOUT_MINUTES);
2114: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2115: itemkey => L_KEY,
2116: aname => 'P_LOOPS',
2117: avalue => P_LOOPS);
2118: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 2118: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2114: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2115: itemkey => L_KEY,
2116: aname => 'P_LOOPS',
2117: avalue => P_LOOPS);
2118: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2119: itemkey => L_KEY,
2120: aname => 'P_SUBJ_FIRST_MSG',
2121: avalue => P_SUBJ_FIRST_MSG);
2122: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

Line 2122: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2118: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2119: itemkey => L_KEY,
2120: aname => 'P_SUBJ_FIRST_MSG',
2121: avalue => P_SUBJ_FIRST_MSG);
2122: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2123: itemkey => L_KEY,
2124: aname => 'P_NTF_TYPE',
2125: avalue => P_NTF_TYPE);
2126: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 2126: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

2122: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2123: itemkey => L_KEY,
2124: aname => 'P_NTF_TYPE',
2125: avalue => P_NTF_TYPE);
2126: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2127: itemkey => L_KEY,
2128: aname => 'CONTRACT_ID',
2129: avalue => P_CONTRACT_ID);
2130: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 2130: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

2126: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2127: itemkey => L_KEY,
2128: aname => 'CONTRACT_ID',
2129: avalue => P_CONTRACT_ID);
2130: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2131: itemkey => L_KEY,
2132: aname => 'TASK_ID',
2133: avalue => P_TASK_ID);
2134: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

Line 2134: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

2130: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2131: itemkey => L_KEY,
2132: aname => 'TASK_ID',
2133: avalue => P_TASK_ID);
2134: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2135: itemkey => L_KEY,
2136: aname => 'EXTRA_ATTR_NUM',
2137: avalue => P_EXTRA_ATTR_NUM);
2138: -- marat start (bug#2477385)

Line 2139: wf_engine.SetItemAttrText ( itemtype => G_WF_NAME,

2135: itemkey => L_KEY,
2136: aname => 'EXTRA_ATTR_NUM',
2137: avalue => P_EXTRA_ATTR_NUM);
2138: -- marat start (bug#2477385)
2139: wf_engine.SetItemAttrText ( itemtype => G_WF_NAME,
2140: itemkey => L_KEY,
2141: aname => 'EXTRA_ATTR_TEXT',
2142: avalue => okc_wf.get_wf_string);
2143: -- marat end

Line 2147: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2143: -- marat end
2144: /* - we'll use EXTRA_ATTR_TEXT item attr for sending outcome params to wf process
2145: -- (bug#2477385)
2146: -- below commented out by marat
2147: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2148: itemkey => L_KEY,
2149: aname => 'EXTRA_ATTR_TEXT',
2150: avalue => P_EXTRA_ATTR_TEXT);
2151: -- above commented out by marat

Line 2153: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,

2149: aname => 'EXTRA_ATTR_TEXT',
2150: avalue => P_EXTRA_ATTR_TEXT);
2151: -- above commented out by marat
2152: */
2153: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,
2154: itemkey => L_KEY,
2155: aname => 'EXTRA_ATTR_DATE',
2156: avalue => P_EXTRA_ATTR_DATE);
2157: --

Line 2161: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,

2157: --
2158: -- save env / start
2159: --
2160: save_env(G_WF_NAME, l_key);
2161: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
2162: itemkey => L_KEY,
2163: owner => fnd_global.user_name);
2164:
2165: IF (l_debug = 'Y') THEN

Line 2169: wf_engine.StartProcess( itemtype => G_WF_NAME,

2165: IF (l_debug = 'Y') THEN
2166: okc_debug.Log('50: WF Owner : '||fnd_global.user_name,2);
2167: END IF;
2168:
2169: wf_engine.StartProcess( itemtype => G_WF_NAME,
2170: itemkey => L_KEY);
2171: -- commit;
2172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2173: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2254: where NOTIFICATION_ID=wf_engine.context_nid;

2250: --
2251: if (funcmode = 'RESPOND') then
2252: update wf_notifications
2253: set mail_status=NULL
2254: where NOTIFICATION_ID=wf_engine.context_nid;
2255:
2256: IF (l_debug = 'Y') THEN
2257: okc_debug.Log('100: Leaving ',2);
2258: okc_debug.Reset_Indentation;

Line 2297: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');

2293: itemkey in varchar2,
2294: actid in number,
2295: funcmode in varchar2,
2296: resultout out nocopy varchar2 ) is
2297: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2298: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');
2299: cursor c1(p_name varchar2) is
2300: select user_id from fnd_user
2301: where user_name=p_name;

Line 2298: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');

2294: actid in number,
2295: funcmode in varchar2,
2296: resultout out nocopy varchar2 ) is
2297: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2298: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');
2299: cursor c1(p_name varchar2) is
2300: select user_id from fnd_user
2301: where user_name=p_name;
2302: l_user_id number;

Line 2331: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2327: RESPONSIBILITY_ID=> NULL,
2328: APPLICATION_ID => NULL);
2329: end if;
2330: if (l_p_value is NULL or l_p_value='N') then
2331: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2332: itemkey => itemkey,
2333: aname => '.MAIL_QUERY',
2334: avalue => ' ');
2335: else

Line 2336: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2332: itemkey => itemkey,
2333: aname => '.MAIL_QUERY',
2334: avalue => ' ');
2335: else
2336: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2337: itemkey => itemkey,
2338: aname => '.MAIL_QUERY',
2339: avalue => l_user_name);
2340: end if;

Line 2398: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');

2394: itemkey in varchar2,
2395: actid in number,
2396: funcmode in varchar2,
2397: resultout out nocopy varchar2 ) is
2398: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2399: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');
2400: cursor c1(p_name varchar2) is
2401: select user_id from fnd_user
2402: where user_name=p_name;

Line 2399: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');

2395: actid in number,
2396: funcmode in varchar2,
2397: resultout out nocopy varchar2 ) is
2398: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2399: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');
2400: cursor c1(p_name varchar2) is
2401: select user_id from fnd_user
2402: where user_name=p_name;
2403: l_user_id number;

Line 2432: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2428: RESPONSIBILITY_ID=> NULL,
2429: APPLICATION_ID => NULL);
2430: end if;
2431: if (l_p_value is NULL or l_p_value='N') then
2432: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2433: itemkey => itemkey,
2434: aname => '.MAIL_QUERY',
2435: avalue => ' ');
2436: else

Line 2437: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

2433: itemkey => itemkey,
2434: aname => '.MAIL_QUERY',
2435: avalue => ' ');
2436: else
2437: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2438: itemkey => itemkey,
2439: aname => '.MAIL_QUERY',
2440: avalue => l_user_name);
2441: end if;

Line 2502: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');

2498: actid in number,
2499: funcmode in varchar2,
2500: resultout out nocopy varchar2 ) is
2501:
2502: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2503: -- value NEXT_INFORMED_RECIPIENT used in Contract Approval workflow attribute and messages
2504: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_INFORMED_USERNAME');
2505:
2506: cursor c1(p_name varchar2) is

Line 2504: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_INFORMED_USERNAME');

2500: resultout out nocopy varchar2 ) is
2501:
2502: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2503: -- value NEXT_INFORMED_RECIPIENT used in Contract Approval workflow attribute and messages
2504: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_INFORMED_USERNAME');
2505:
2506: cursor c1(p_name varchar2) is
2507: select user_id from fnd_user
2508: where user_name=p_name;

Line 2541: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2537: APPLICATION_ID => NULL);
2538: end if;
2539: if (l_p_value is NULL or l_p_value='N') then
2540: -- UnMute Recipient
2541: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2542: itemkey => itemkey,
2543: aname => '.MAIL_QUERY',
2544: avalue => ' ');
2545: else

Line 2547: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2543: aname => '.MAIL_QUERY',
2544: avalue => ' ');
2545: else
2546: -- Suppress Recipient (Mute)
2547: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2548: itemkey => itemkey,
2549: aname => '.MAIL_QUERY',
2550: avalue => l_user_name);
2551: end if;

Line 2612: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');

2608: actid in number,
2609: funcmode in varchar2,
2610: resultout out nocopy varchar2 ) is
2611:
2612: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2613: -- value NEXT_PERFORMER_USERNAME used in Contract Approval workflow attribute and messages
2614: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
2615:
2616: cursor c1(p_name varchar2) is

Line 2614: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');

2610: resultout out nocopy varchar2 ) is
2611:
2612: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2613: -- value NEXT_PERFORMER_USERNAME used in Contract Approval workflow attribute and messages
2614: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
2615:
2616: cursor c1(p_name varchar2) is
2617: select user_id from fnd_user
2618: where user_name=p_name;

Line 2651: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2647: APPLICATION_ID => NULL);
2648: end if;
2649: if (l_p_value is NULL or l_p_value='N') then
2650: -- UnMute Recipient
2651: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2652: itemkey => itemkey,
2653: aname => '.MAIL_QUERY',
2654: avalue => ' ');
2655: else

Line 2657: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2653: aname => '.MAIL_QUERY',
2654: avalue => ' ');
2655: else
2656: -- Suppress Recipient (Mute)
2657: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2658: itemkey => itemkey,
2659: aname => '.MAIL_QUERY',
2660: avalue => l_user_name);
2661: end if;

Line 2722: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');

2718: actid in number,
2719: funcmode in varchar2,
2720: resultout out nocopy varchar2 ) is
2721:
2722: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2723: -- value CONTRACT_ADMIN_USERNAME used in Contract Approval workflow attribute and messages
2724: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ADMIN_USERNAME');
2725:
2726: cursor c1(p_name varchar2) is

Line 2724: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ADMIN_USERNAME');

2720: resultout out nocopy varchar2 ) is
2721:
2722: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2723: -- value CONTRACT_ADMIN_USERNAME used in Contract Approval workflow attribute and messages
2724: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ADMIN_USERNAME');
2725:
2726: cursor c1(p_name varchar2) is
2727: select user_id from fnd_user
2728: where user_name=p_name;

Line 2761: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2757: APPLICATION_ID => NULL);
2758: end if;
2759: if (l_p_value is NULL or l_p_value='N') then
2760: -- UnMute Recipient
2761: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2762: itemkey => itemkey,
2763: aname => '.MAIL_QUERY',
2764: avalue => ' ');
2765: else

Line 2767: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2763: aname => '.MAIL_QUERY',
2764: avalue => ' ');
2765: else
2766: -- Suppress Recipient (Mute)
2767: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2768: itemkey => itemkey,
2769: aname => '.MAIL_QUERY',
2770: avalue => l_user_name);
2771: end if;

Line 2832: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');

2828: actid in number,
2829: funcmode in varchar2,
2830: resultout out nocopy varchar2 ) is
2831:
2832: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2833: -- value SIGNATORY_USERNAME used in Contract Approval workflow attribute and messages
2834: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'SIGNATORY_USERNAME');
2835:
2836: cursor c1(p_name varchar2) is

Line 2834: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'SIGNATORY_USERNAME');

2830: resultout out nocopy varchar2 ) is
2831:
2832: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2833: -- value SIGNATORY_USERNAME used in Contract Approval workflow attribute and messages
2834: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'SIGNATORY_USERNAME');
2835:
2836: cursor c1(p_name varchar2) is
2837: select user_id from fnd_user
2838: where user_name=p_name;

Line 2871: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2867: APPLICATION_ID => NULL);
2868: end if;
2869: if (l_p_value is NULL or l_p_value='N') then
2870: -- UnMute Recipient
2871: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2872: itemkey => itemkey,
2873: aname => '.MAIL_QUERY',
2874: avalue => ' ');
2875: else

Line 2877: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2873: aname => '.MAIL_QUERY',
2874: avalue => ' ');
2875: else
2876: -- Suppress Recipient (Mute)
2877: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2878: itemkey => itemkey,
2879: aname => '.MAIL_QUERY',
2880: avalue => l_user_name);
2881: end if;

Line 2956: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP

2952:
2953: if (funcmode = 'RUN') then
2954:
2955: -- UnMute Recipient
2956: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2957: itemkey => itemkey,
2958: aname => '.MAIL_QUERY',
2959: avalue => ' ');
2960: end if;