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 732: P_VERSION := to_char(wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION'));

728: -- RUN mode - normal process execution
729: --
730: if (funcmode = 'RUN') then
731: begin
732: P_VERSION := to_char(wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION'));
733: IF (l_debug = 'Y') THEN
734: okc_debug.Log('30: P_VERSION : '||P_VERSION,2);
735: END IF;
736: exception

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

825: okc_debug.Log('20: p_attr_name : '||p_attr_name,2);
826: END IF;
827:
828: x_return_status := 'S';
829: P_PROC := wf_engine.GetItemAttrText (itemtype => G_WF_NAME,
830: itemkey => P_KEY,
831: aname => p_attr_name);
832: -- marat start (bug#2477385)
833: okc_wf.init_wf_string( wf_engine.GetItemAttrText ( itemtype => G_WF_NAME,

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

829: P_PROC := wf_engine.GetItemAttrText (itemtype => G_WF_NAME,
830: itemkey => P_KEY,
831: aname => p_attr_name);
832: -- marat start (bug#2477385)
833: okc_wf.init_wf_string( wf_engine.GetItemAttrText ( itemtype => G_WF_NAME,
834: itemkey => P_KEY,
835: aname => 'EXTRA_ATTR_TEXT'));
836: -- marat end
837: P_VERSION := wf_engine.GetItemAttrNumber (itemtype => G_WF_NAME,

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

833: okc_wf.init_wf_string( wf_engine.GetItemAttrText ( itemtype => G_WF_NAME,
834: itemkey => P_KEY,
835: aname => 'EXTRA_ATTR_TEXT'));
836: -- marat end
837: P_VERSION := wf_engine.GetItemAttrNumber (itemtype => G_WF_NAME,
838: itemkey => P_KEY,
839: aname => 'P_VERSION');
840: savepoint exec_call_sp;
841: if (P_VERSION in (2,5)) then

Line 862: wf_engine.GetItemAttrText (

858: end if;
859: elsif (P_VERSION = 3) then
860: begin
861: EXECUTE IMMEDIATE P_PROC USING
862: wf_engine.GetItemAttrText (
863: itemtype => G_WF_NAME,
864: itemkey => P_KEY,
865: aname => 'NOTE');
866: EXCEPTION WHEN OTHERS THEN

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

923: okc_debug.Log('10: Entering ',2);
924: END IF;
925:
926: nl:=fnd_global.NewLine;
927: P_SUBJ_FIRST_MSG := wf_engine.GetItemAttrText(itemtype,itemkey,'P_SUBJ_FIRST_MSG');
928: j := NVL(FND_MSG_PUB.Count_Msg,0);
929:
930: if (j=0) then
931:

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

937: okc_debug.Log('50: Message Count is Zero ',2);
938: okc_debug.Reset_Indentation;
939: END IF;
940:
941: l_contract_id := (wf_engine.GetItemAttrText (itemtype => itemtype,
942: itemkey => itemkey,
943: aname => 'CONTRACT_ID'));
944: l_proc_name := (wf_engine.GetItemAttrText (itemtype => itemtype,
945: itemkey => itemkey,

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

940:
941: l_contract_id := (wf_engine.GetItemAttrText (itemtype => itemtype,
942: itemkey => itemkey,
943: aname => 'CONTRACT_ID'));
944: l_proc_name := (wf_engine.GetItemAttrText (itemtype => itemtype,
945: itemkey => itemkey,
946: aname => 'P_PROC_NAME'));
947: IF l_contract_id IS NOT NULL THEN
948: BEGIN

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

984: p_token2 => 'PROCESS_NAME',
985: p_token2_value => l_proc_name);
986: END IF;
987:
988: wf_engine.SetItemAttrText (itemtype => itemtype,
989: itemkey => itemkey,
990: aname => 'MESSAGE0',
991: avalue => FND_MSG_PUB.Get(2,p_encoded =>FND_API.G_FALSE ));
992:

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

989: itemkey => itemkey,
990: aname => 'MESSAGE0',
991: avalue => FND_MSG_PUB.Get(2,p_encoded =>FND_API.G_FALSE ));
992:
993: wf_engine.SetItemAttrText (itemtype => itemtype,
994: itemkey => itemkey,
995: aname => 'MESSAGE1',
996: avalue => FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
997: --END NPALEPU

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

1004:
1005: end if;
1006:
1007: if (P_SUBJ_FIRST_MSG = 'T') then
1008: wf_engine.SetItemAttrText (itemtype => itemtype,
1009: itemkey => itemkey,
1010: aname => 'MESSAGE0',
1011: avalue => FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
1012: i:=2;

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

1010: aname => 'MESSAGE0',
1011: avalue => FND_MSG_PUB.Get(1,p_encoded =>FND_API.G_FALSE ));
1012: i:=2;
1013: else
1014: wf_engine.SetItemAttrText (itemtype => itemtype,
1015: itemkey => itemkey,
1016: aname => 'MESSAGE0',
1017: avalue => FND_MSG_PUB.Get(j,p_encoded =>FND_API.G_FALSE ));
1018: j:=j-1;

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

1017: avalue => FND_MSG_PUB.Get(j,p_encoded =>FND_API.G_FALSE ));
1018: j:=j-1;
1019: i:=1;
1020: end if;
1021: text_limit:=text_limit-length(wf_engine.GetItemAttrText (itemtype => itemtype,
1022: itemkey => itemkey,
1023: aname => 'MESSAGE0'));
1024: k:=1; -- msg index
1025: LOOP

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

1037: end if;
1038: i:=i+1;
1039: if (i>j) then exit; end if;
1040: END LOOP;
1041: wf_engine.SetItemAttrText (itemtype => itemtype,
1042: itemkey => itemkey,
1043: aname => 'MESSAGE'||to_char(k),
1044: avalue => msg_buf);
1045: text_limit:=text_limit-length(msg_buf);

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

1043: aname => 'MESSAGE'||to_char(k),
1044: avalue => msg_buf);
1045: text_limit:=text_limit-length(msg_buf);
1046: if (text_limit<0) then
1047: wf_engine.SetItemAttrText (itemtype => itemtype,
1048: itemkey => itemkey,
1049: aname => 'MESSAGE'||to_char(k),
1050: avalue => '');
1051: exit;

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

1101: /* MSENGUPT: Introduced the following code to re-read and reset the profile option in case of timeouts due to errors */
1102: if (funcmode <> 'RUN') then
1103: l_timeout_minutes := fnd_profile.value('OKC_ALERT_TIMEOUT');
1104: if l_timeout_minutes IS NOT NULL then
1105: wf_engine.SetItemAttrNumber (itemtype, itemkey, 'P_TIMEOUT_MINUTES', L_TIMEOUT_MINUTES);
1106: end if;
1107: end if;
1108: /* End of code insert */
1109:

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

1114: FND_MSG_PUB.initialize;
1115: IF (l_debug = 'Y') THEN
1116: okc_debug.Log('30: ',2);
1117: END IF;
1118: if (wf_engine.GetItemAttrText(itemtype,itemkey,'P_PROC') is NULL) then
1119: IF (l_debug = 'Y') THEN
1120: okc_debug.Log('40 ',2);
1121: END IF;
1122: resultout := 'COMPLETE:S';

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

1120: okc_debug.Log('40 ',2);
1121: END IF;
1122: resultout := 'COMPLETE:S';
1123: else
1124: if (wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION') = 5) then
1125: wf_engine.SetItemAttrText (
1126: itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'MESSAGE0',

Line 1125: wf_engine.SetItemAttrText (

1121: END IF;
1122: resultout := 'COMPLETE:S';
1123: else
1124: if (wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_VERSION') = 5) then
1125: wf_engine.SetItemAttrText (
1126: itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'MESSAGE0',
1129: avalue => '');

Line 1130: wf_engine.SetItemAttrText (

1126: itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'MESSAGE0',
1129: avalue => '');
1130: wf_engine.SetItemAttrText (
1131: itemtype => itemtype,
1132: itemkey => itemkey,
1133: aname => 'MESSAGE1',
1134: avalue => '');

Line 1135: wf_engine.SetItemAttrText (

1131: itemtype => itemtype,
1132: itemkey => itemkey,
1133: aname => 'MESSAGE1',
1134: avalue => '');
1135: wf_engine.SetItemAttrText (
1136: itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'MESSAGE2',
1139: avalue => '');

Line 1140: wf_engine.SetItemAttrText (

1136: itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'MESSAGE2',
1139: avalue => '');
1140: wf_engine.SetItemAttrText (
1141: itemtype => itemtype,
1142: itemkey => itemkey,
1143: aname => 'MESSAGE3',
1144: avalue => '');

Line 1145: wf_engine.SetItemAttrText (

1141: itemtype => itemtype,
1142: itemkey => itemkey,
1143: aname => 'MESSAGE3',
1144: avalue => '');
1145: wf_engine.SetItemAttrText (
1146: itemtype => itemtype,
1147: itemkey => itemkey,
1148: aname => 'MESSAGE4',
1149: avalue => '');

Line 1150: wf_engine.SetItemAttrText (

1146: itemtype => itemtype,
1147: itemkey => itemkey,
1148: aname => 'MESSAGE4',
1149: avalue => '');
1150: wf_engine.SetItemAttrText (
1151: itemtype => itemtype,
1152: itemkey => itemkey,
1153: aname => 'MESSAGE5',
1154: avalue => '');

Line 1155: wf_engine.SetItemAttrText (

1151: itemtype => itemtype,
1152: itemkey => itemkey,
1153: aname => 'MESSAGE5',
1154: avalue => '');
1155: wf_engine.SetItemAttrText (
1156: itemtype => itemtype,
1157: itemkey => itemkey,
1158: aname => 'MESSAGE6',
1159: avalue => '');

Line 1160: wf_engine.SetItemAttrText (

1156: itemtype => itemtype,
1157: itemkey => itemkey,
1158: aname => 'MESSAGE6',
1159: avalue => '');
1160: wf_engine.SetItemAttrText (
1161: itemtype => itemtype,
1162: itemkey => itemkey,
1163: aname => 'MESSAGE7',
1164: avalue => '');

Line 1165: wf_engine.SetItemAttrText (

1161: itemtype => itemtype,
1162: itemkey => itemkey,
1163: aname => 'MESSAGE7',
1164: avalue => '');
1165: wf_engine.SetItemAttrText (
1166: itemtype => itemtype,
1167: itemkey => itemkey,
1168: aname => 'MESSAGE8',
1169: avalue => '');

Line 1170: wf_engine.SetItemAttrText (

1166: itemtype => itemtype,
1167: itemkey => itemkey,
1168: aname => 'MESSAGE8',
1169: avalue => '');
1170: wf_engine.SetItemAttrText (
1171: itemtype => itemtype,
1172: itemkey => itemkey,
1173: aname => 'MESSAGE9',
1174: avalue => '');

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

1178: IF (l_debug = 'Y') THEN
1179: okc_debug.Log('50 ',2);
1180: END IF;
1181: if ((x_return_status = 'S') and
1182: (wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT') is not NULL)) then
1183: --NPALEPU
1184: --14-DEC-2005
1185: --For bug # 4699009
1186: /* load_mess(itemtype,itemkey); */

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

1186: /* load_mess(itemtype,itemkey); */
1187: load_mess(itemtype,itemkey,x_return_status);
1188: --END NPALEPU
1189: --
1190: p_recipient := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');
1191: IF (l_debug = 'Y') THEN
1192: okc_debug.Log('60 ',2);
1193: END IF;
1194: open pref_csr;

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

1199: okc_debug.Log('70 l_pref : '||l_pref);
1200: END IF;
1201:
1202: if (l_pref='MAILTEXT') then
1203: wf_engine.SetItemAttrText (itemtype => itemtype,
1204: itemkey => itemkey,
1205: aname => 'PREFORMAT',
1206: avalue => '');
1207: wf_engine.SetItemAttrText (itemtype => itemtype,

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

1203: wf_engine.SetItemAttrText (itemtype => itemtype,
1204: itemkey => itemkey,
1205: aname => 'PREFORMAT',
1206: avalue => '');
1207: wf_engine.SetItemAttrText (itemtype => itemtype,
1208: itemkey => itemkey,
1209: aname => 'PREFORMAT_',
1210: avalue => '');
1211: end if;

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

1211: end if;
1212: --
1213: resultout := 'COMPLETE:S';
1214: elsif ((x_return_status in ('E','U')) and
1215: (wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT') is not NULL)) then
1216: --NPALEPU
1217: --14-DEC-2005
1218: --For bug # 4699009
1219: /* load_mess(itemtype,itemkey); */

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

1219: /* load_mess(itemtype,itemkey); */
1220: load_mess(itemtype,itemkey,x_return_status);
1221: --END NPALEPU
1222: --
1223: p_recipient := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');
1224: open pref_csr;
1225: fetch pref_csr into l_pref;
1226: close pref_csr;
1227:

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

1229: okc_debug.Log('80 l_pref : '||l_pref);
1230: END IF;
1231:
1232: if (l_pref='MAILTEXT') then
1233: wf_engine.SetItemAttrText (itemtype => itemtype,
1234: itemkey => itemkey,
1235: aname => 'PREFORMAT',
1236: avalue => '');
1237: wf_engine.SetItemAttrText (itemtype => itemtype,

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

1233: wf_engine.SetItemAttrText (itemtype => itemtype,
1234: itemkey => itemkey,
1235: aname => 'PREFORMAT',
1236: avalue => '');
1237: wf_engine.SetItemAttrText (itemtype => itemtype,
1238: itemkey => itemkey,
1239: aname => 'PREFORMAT_',
1240: avalue => '');
1241: end if;

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

1644: --
1645: -- create process
1646: --
1647: select to_char(okc_wf_notify_s1.nextval) into l_key from dual;
1648: wf_engine.CreateProcess( ItemType => G_WF_NAME,
1649: ItemKey => L_KEY,
1650: process => G_PROCESS_NAME);
1651: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
1652: ItemKey => L_KEY,

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

1647: select to_char(okc_wf_notify_s1.nextval) into l_key from dual;
1648: wf_engine.CreateProcess( ItemType => G_WF_NAME,
1649: ItemKey => L_KEY,
1650: process => G_PROCESS_NAME);
1651: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
1652: ItemKey => L_KEY,
1653: UserKey => L_KEY);
1654: --
1655: -- design time attr !

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

1654: --
1655: -- design time attr !
1656: --
1657:
1658: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1659: itemkey => L_KEY,
1660: aname => 'P_RESOLVER',
1661: avalue => P_RESOLVER);
1662: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

1658: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1659: itemkey => L_KEY,
1660: aname => 'P_RESOLVER',
1661: avalue => P_RESOLVER);
1662: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1663: itemkey => L_KEY,
1664: aname => 'MSG_SUBJ_RESOLVER',
1665: avalue => P_MSG_SUBJ_RESOLVER);
1666: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

1662: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1663: itemkey => L_KEY,
1664: aname => 'MSG_SUBJ_RESOLVER',
1665: avalue => P_MSG_SUBJ_RESOLVER);
1666: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1667: itemkey => L_KEY,
1668: aname => 'MSG_BODY_RESOLVER',
1669: avalue => P_MSG_BODY_RESOLVER);
1670: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

1666: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1667: itemkey => L_KEY,
1668: aname => 'MSG_BODY_RESOLVER',
1669: avalue => P_MSG_BODY_RESOLVER);
1670: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1671: itemkey => L_KEY,
1672: aname => 'NOTE',
1673: avalue => P_NOTE);
1674: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

1670: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1671: itemkey => L_KEY,
1672: aname => 'NOTE',
1673: avalue => P_NOTE);
1674: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1675: itemkey => L_KEY,
1676: aname => 'P_ACCEPT_PROC',
1677: avalue => P_ACCEPT_PROC);
1678: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

1674: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1675: itemkey => L_KEY,
1676: aname => 'P_ACCEPT_PROC',
1677: avalue => P_ACCEPT_PROC);
1678: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1679: itemkey => L_KEY,
1680: aname => 'P_REJECT_PROC',
1681: avalue => P_REJECT_PROC);
1682: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

1678: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1679: itemkey => L_KEY,
1680: aname => 'P_REJECT_PROC',
1681: avalue => P_REJECT_PROC);
1682: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1683: itemkey => L_KEY,
1684: aname => 'P_TIMEOUT_PROC',
1685: avalue => NVL(P_TIMEOUT_PROC,P_REJECT_PROC));
1686: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

1682: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1683: itemkey => L_KEY,
1684: aname => 'P_TIMEOUT_PROC',
1685: avalue => NVL(P_TIMEOUT_PROC,P_REJECT_PROC));
1686: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1687: itemkey => L_KEY,
1688: aname => 'P_TIMEOUT_MINUTES',
1689: avalue => P_TIMEOUT_MINUTES);
1690: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

1686: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1687: itemkey => L_KEY,
1688: aname => 'P_TIMEOUT_MINUTES',
1689: avalue => P_TIMEOUT_MINUTES);
1690: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1691: itemkey => L_KEY,
1692: aname => 'P_NTF_TYPE',
1693: avalue => P_NTF_TYPE);
1694: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

1690: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1691: itemkey => L_KEY,
1692: aname => 'P_NTF_TYPE',
1693: avalue => P_NTF_TYPE);
1694: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1695: itemkey => L_KEY,
1696: aname => 'CONTRACT_ID',
1697: avalue => P_CONTRACT_ID);
1698: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

1694: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1695: itemkey => L_KEY,
1696: aname => 'CONTRACT_ID',
1697: avalue => P_CONTRACT_ID);
1698: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1699: itemkey => L_KEY,
1700: aname => 'TASK_ID',
1701: avalue => P_TASK_ID);
1702: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

1698: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1699: itemkey => L_KEY,
1700: aname => 'TASK_ID',
1701: avalue => P_TASK_ID);
1702: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1703: itemkey => L_KEY,
1704: aname => 'EXTRA_ATTR_NUM',
1705: avalue => P_EXTRA_ATTR_NUM);
1706: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

1702: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1703: itemkey => L_KEY,
1704: aname => 'EXTRA_ATTR_NUM',
1705: avalue => P_EXTRA_ATTR_NUM);
1706: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1707: itemkey => L_KEY,
1708: aname => 'EXTRA_ATTR_TEXT',
1709: avalue => P_EXTRA_ATTR_TEXT);
1710: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,

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

1706: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
1707: itemkey => L_KEY,
1708: aname => 'EXTRA_ATTR_TEXT',
1709: avalue => P_EXTRA_ATTR_TEXT);
1710: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,
1711: itemkey => L_KEY,
1712: aname => 'EXTRA_ATTR_DATE',
1713: avalue => P_EXTRA_ATTR_DATE);
1714: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

1710: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,
1711: itemkey => L_KEY,
1712: aname => 'EXTRA_ATTR_DATE',
1713: avalue => P_EXTRA_ATTR_DATE);
1714: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
1715: itemkey => L_KEY,
1716: aname => 'P_VERSION',
1717: avalue => 3);
1718: --

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

1718: --
1719: -- save env / start
1720: --
1721: save_env(G_WF_NAME, l_key);
1722: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
1723: itemkey => L_KEY,
1724: owner => fnd_global.user_name);
1725: wf_engine.StartProcess( itemtype => G_WF_NAME,
1726: itemkey => L_KEY);

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

1721: save_env(G_WF_NAME, l_key);
1722: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
1723: itemkey => L_KEY,
1724: owner => fnd_global.user_name);
1725: wf_engine.StartProcess( itemtype => G_WF_NAME,
1726: itemkey => L_KEY);
1727: -- commit;
1728: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1729: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1797: -- RUN mode - normal process execution
1798: --
1799: if (funcmode = 'RUN') then
1800: begin
1801: P_PERIOD_DAYS := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PERIOD_DAYS');
1802: P_STOP_DATE := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_STOP_DATE');
1803: exception
1804: when others then
1805: NULL;

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

1798: --
1799: if (funcmode = 'RUN') then
1800: begin
1801: P_PERIOD_DAYS := wf_engine.GetItemAttrNumber(itemtype,itemkey,'P_PERIOD_DAYS');
1802: P_STOP_DATE := wf_engine.GetItemAttrDate(itemtype,itemkey,'P_STOP_DATE');
1803: exception
1804: when others then
1805: NULL;
1806: end;

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

1884: --
1885: -- RUN mode - normal process execution
1886: --
1887: if (funcmode = 'RUN') then
1888: if (sysdate >= wf_engine.GetItemAttrDate(itemtype,itemkey,'P_STOP_DATE')) then
1889: resultout := 'COMPLETE:T';
1890: else
1891: resultout := 'COMPLETE:F';
1892: end if;

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

1969: END IF;
1970:
1971: savepoint get_doc;
1972: begin
1973: EXECUTE IMMEDIATE wf_engine.GetItemAttrText(G_WF_NAME,document_id,'P_DOC_PROC') USING IN OUT document;
1974: exception
1975: when others then
1976: rollback to get_doc;
1977: end;

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

2111: okc_debug.Log('40: G_WF_NAME : '||G_WF_NAME,2);
2112: okc_debug.Log('40: G_PROCESS_NAME : '||G_PROCESS_NAME,2);
2113: END IF;
2114:
2115: wf_engine.CreateProcess( ItemType => G_WF_NAME,
2116: ItemKey => L_KEY,
2117: process => G_PROCESS_NAME);
2118: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
2119: ItemKey => L_KEY,

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

2114:
2115: wf_engine.CreateProcess( ItemType => G_WF_NAME,
2116: ItemKey => L_KEY,
2117: process => G_PROCESS_NAME);
2118: wf_engine.SetItemUserKey ( ItemType => G_WF_NAME,
2119: ItemKey => L_KEY,
2120: UserKey => L_KEY);
2121: --
2122: -- design time attr !

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

2121: --
2122: -- design time attr !
2123: --
2124:
2125: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2126: itemkey => L_KEY,
2127: aname => 'P_VERSION',
2128: avalue => 5);
2129: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

2125: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2126: itemkey => L_KEY,
2127: aname => 'P_VERSION',
2128: avalue => 5);
2129: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2130: itemkey => L_KEY,
2131: aname => 'P_PROC',
2132: avalue => P_PROC);
2133: --NPALEPU,14-DEC-2005

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

2131: aname => 'P_PROC',
2132: avalue => P_PROC);
2133: --NPALEPU,14-DEC-2005
2134: --bug # 4699009
2135: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2136: itemkey => L_KEY,
2137: aname => 'P_PROC_NAME',
2138: avalue => P_PROC_NAME);
2139: --END NPALEPU

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

2136: itemkey => L_KEY,
2137: aname => 'P_PROC_NAME',
2138: avalue => P_PROC_NAME);
2139: --END NPALEPU
2140: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2141: itemkey => L_KEY,
2142: aname => 'P_S_RECIPIENT',
2143: avalue => P_S_RECIPIENT);
2144: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

2140: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2141: itemkey => L_KEY,
2142: aname => 'P_S_RECIPIENT',
2143: avalue => P_S_RECIPIENT);
2144: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2145: itemkey => L_KEY,
2146: aname => 'P_E_RECIPIENT',
2147: avalue => P_E_RECIPIENT);
2148: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

2144: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2145: itemkey => L_KEY,
2146: aname => 'P_E_RECIPIENT',
2147: avalue => P_E_RECIPIENT);
2148: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2149: itemkey => L_KEY,
2150: aname => 'P_TIMEOUT_MINUTES',
2151: avalue => L_TIMEOUT_MINUTES);
2152: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

2148: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2149: itemkey => L_KEY,
2150: aname => 'P_TIMEOUT_MINUTES',
2151: avalue => L_TIMEOUT_MINUTES);
2152: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2153: itemkey => L_KEY,
2154: aname => 'P_LOOPS',
2155: avalue => P_LOOPS);
2156: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

2152: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2153: itemkey => L_KEY,
2154: aname => 'P_LOOPS',
2155: avalue => P_LOOPS);
2156: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2157: itemkey => L_KEY,
2158: aname => 'P_SUBJ_FIRST_MSG',
2159: avalue => P_SUBJ_FIRST_MSG);
2160: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,

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

2156: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2157: itemkey => L_KEY,
2158: aname => 'P_SUBJ_FIRST_MSG',
2159: avalue => P_SUBJ_FIRST_MSG);
2160: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2161: itemkey => L_KEY,
2162: aname => 'P_NTF_TYPE',
2163: avalue => P_NTF_TYPE);
2164: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

2160: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2161: itemkey => L_KEY,
2162: aname => 'P_NTF_TYPE',
2163: avalue => P_NTF_TYPE);
2164: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2165: itemkey => L_KEY,
2166: aname => 'CONTRACT_ID',
2167: avalue => P_CONTRACT_ID);
2168: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

2164: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2165: itemkey => L_KEY,
2166: aname => 'CONTRACT_ID',
2167: avalue => P_CONTRACT_ID);
2168: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2169: itemkey => L_KEY,
2170: aname => 'TASK_ID',
2171: avalue => P_TASK_ID);
2172: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,

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

2168: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2169: itemkey => L_KEY,
2170: aname => 'TASK_ID',
2171: avalue => P_TASK_ID);
2172: wf_engine.SetItemAttrNumber (itemtype => G_WF_NAME,
2173: itemkey => L_KEY,
2174: aname => 'EXTRA_ATTR_NUM',
2175: avalue => P_EXTRA_ATTR_NUM);
2176: -- marat start (bug#2477385)

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

2173: itemkey => L_KEY,
2174: aname => 'EXTRA_ATTR_NUM',
2175: avalue => P_EXTRA_ATTR_NUM);
2176: -- marat start (bug#2477385)
2177: wf_engine.SetItemAttrText ( itemtype => G_WF_NAME,
2178: itemkey => L_KEY,
2179: aname => 'EXTRA_ATTR_TEXT',
2180: avalue => okc_wf.get_wf_string);
2181: -- marat end

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

2181: -- marat end
2182: /* - we'll use EXTRA_ATTR_TEXT item attr for sending outcome params to wf process
2183: -- (bug#2477385)
2184: -- below commented out by marat
2185: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2186: itemkey => L_KEY,
2187: aname => 'EXTRA_ATTR_TEXT',
2188: avalue => P_EXTRA_ATTR_TEXT);
2189: -- above commented out by marat

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

2187: aname => 'EXTRA_ATTR_TEXT',
2188: avalue => P_EXTRA_ATTR_TEXT);
2189: -- above commented out by marat
2190: */
2191: wf_engine.SetItemAttrDate (itemtype => G_WF_NAME,
2192: itemkey => L_KEY,
2193: aname => 'EXTRA_ATTR_DATE',
2194: avalue => P_EXTRA_ATTR_DATE);
2195: --

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

2195: --
2196: -- save env / start
2197: --
2198: save_env(G_WF_NAME, l_key);
2199: wf_engine.SetItemOwner ( itemtype => G_WF_NAME,
2200: itemkey => L_KEY,
2201: owner => fnd_global.user_name);
2202:
2203: IF (l_debug = 'Y') THEN

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

2203: IF (l_debug = 'Y') THEN
2204: okc_debug.Log('50: WF Owner : '||fnd_global.user_name,2);
2205: END IF;
2206:
2207: wf_engine.StartProcess( itemtype => G_WF_NAME,
2208: itemkey => L_KEY);
2209: -- commit;
2210: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2211: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2292: where NOTIFICATION_ID=wf_engine.context_nid;

2288: --
2289: if (funcmode = 'RESPOND') then
2290: update wf_notifications
2291: set mail_status=NULL
2292: where NOTIFICATION_ID=wf_engine.context_nid;
2293:
2294: IF (l_debug = 'Y') THEN
2295: okc_debug.Log('100: Leaving ',2);
2296: okc_debug.Reset_Indentation;

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

2331: itemkey in varchar2,
2332: actid in number,
2333: funcmode in varchar2,
2334: resultout out nocopy varchar2 ) is
2335: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2336: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');
2337: cursor c1(p_name varchar2) is
2338: select user_id from fnd_user
2339: where user_name=p_name;

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

2332: actid in number,
2333: funcmode in varchar2,
2334: resultout out nocopy varchar2 ) is
2335: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2336: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_S_RECIPIENT');
2337: cursor c1(p_name varchar2) is
2338: select user_id from fnd_user
2339: where user_name=p_name;
2340: l_user_id number;

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

2365: RESPONSIBILITY_ID=> NULL,
2366: APPLICATION_ID => NULL);
2367: end if;
2368: if (l_p_value is NULL or l_p_value='N') then
2369: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2370: itemkey => itemkey,
2371: aname => '.MAIL_QUERY',
2372: avalue => ' ');
2373: else

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

2370: itemkey => itemkey,
2371: aname => '.MAIL_QUERY',
2372: avalue => ' ');
2373: else
2374: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2375: itemkey => itemkey,
2376: aname => '.MAIL_QUERY',
2377: avalue => l_user_name);
2378: end if;

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

2432: itemkey in varchar2,
2433: actid in number,
2434: funcmode in varchar2,
2435: resultout out nocopy varchar2 ) is
2436: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2437: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');
2438: cursor c1(p_name varchar2) is
2439: select user_id from fnd_user
2440: where user_name=p_name;

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

2433: actid in number,
2434: funcmode in varchar2,
2435: resultout out nocopy varchar2 ) is
2436: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2437: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_E_RECIPIENT');
2438: cursor c1(p_name varchar2) is
2439: select user_id from fnd_user
2440: where user_name=p_name;
2441: l_user_id number;

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

2466: RESPONSIBILITY_ID=> NULL,
2467: APPLICATION_ID => NULL);
2468: end if;
2469: if (l_p_value is NULL or l_p_value='N') then
2470: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2471: itemkey => itemkey,
2472: aname => '.MAIL_QUERY',
2473: avalue => ' ');
2474: else

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

2471: itemkey => itemkey,
2472: aname => '.MAIL_QUERY',
2473: avalue => ' ');
2474: else
2475: wf_engine.SetItemAttrText (itemtype => G_WF_NAME,
2476: itemkey => itemkey,
2477: aname => '.MAIL_QUERY',
2478: avalue => l_user_name);
2479: end if;

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

2536: actid in number,
2537: funcmode in varchar2,
2538: resultout out nocopy varchar2 ) is
2539:
2540: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2541: -- value NEXT_INFORMED_RECIPIENT used in Contract Approval workflow attribute and messages
2542: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_INFORMED_USERNAME');
2543:
2544: cursor c1(p_name varchar2) is

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

2538: resultout out nocopy varchar2 ) is
2539:
2540: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2541: -- value NEXT_INFORMED_RECIPIENT used in Contract Approval workflow attribute and messages
2542: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_INFORMED_USERNAME');
2543:
2544: cursor c1(p_name varchar2) is
2545: select user_id from fnd_user
2546: where user_name=p_name;

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

2575: APPLICATION_ID => NULL);
2576: end if;
2577: if (l_p_value is NULL or l_p_value='N') then
2578: -- UnMute Recipient
2579: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2580: itemkey => itemkey,
2581: aname => '.MAIL_QUERY',
2582: avalue => ' ');
2583: else

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

2581: aname => '.MAIL_QUERY',
2582: avalue => ' ');
2583: else
2584: -- Suppress Recipient (Mute)
2585: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2586: itemkey => itemkey,
2587: aname => '.MAIL_QUERY',
2588: avalue => l_user_name);
2589: end if;

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

2646: actid in number,
2647: funcmode in varchar2,
2648: resultout out nocopy varchar2 ) is
2649:
2650: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2651: -- value NEXT_PERFORMER_USERNAME used in Contract Approval workflow attribute and messages
2652: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
2653:
2654: cursor c1(p_name varchar2) is

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

2648: resultout out nocopy varchar2 ) is
2649:
2650: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2651: -- value NEXT_PERFORMER_USERNAME used in Contract Approval workflow attribute and messages
2652: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NEXT_PERFORMER_USERNAME');
2653:
2654: cursor c1(p_name varchar2) is
2655: select user_id from fnd_user
2656: where user_name=p_name;

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

2685: APPLICATION_ID => NULL);
2686: end if;
2687: if (l_p_value is NULL or l_p_value='N') then
2688: -- UnMute Recipient
2689: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2690: itemkey => itemkey,
2691: aname => '.MAIL_QUERY',
2692: avalue => ' ');
2693: else

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

2691: aname => '.MAIL_QUERY',
2692: avalue => ' ');
2693: else
2694: -- Suppress Recipient (Mute)
2695: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2696: itemkey => itemkey,
2697: aname => '.MAIL_QUERY',
2698: avalue => l_user_name);
2699: end if;

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

2756: actid in number,
2757: funcmode in varchar2,
2758: resultout out nocopy varchar2 ) is
2759:
2760: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2761: -- value CONTRACT_ADMIN_USERNAME used in Contract Approval workflow attribute and messages
2762: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ADMIN_USERNAME');
2763:
2764: cursor c1(p_name varchar2) is

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

2758: resultout out nocopy varchar2 ) is
2759:
2760: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2761: -- value CONTRACT_ADMIN_USERNAME used in Contract Approval workflow attribute and messages
2762: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'CONTRACT_ADMIN_USERNAME');
2763:
2764: cursor c1(p_name varchar2) is
2765: select user_id from fnd_user
2766: where user_name=p_name;

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

2795: APPLICATION_ID => NULL);
2796: end if;
2797: if (l_p_value is NULL or l_p_value='N') then
2798: -- UnMute Recipient
2799: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2800: itemkey => itemkey,
2801: aname => '.MAIL_QUERY',
2802: avalue => ' ');
2803: else

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

2801: aname => '.MAIL_QUERY',
2802: avalue => ' ');
2803: else
2804: -- Suppress Recipient (Mute)
2805: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2806: itemkey => itemkey,
2807: aname => '.MAIL_QUERY',
2808: avalue => l_user_name);
2809: end if;

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

2866: actid in number,
2867: funcmode in varchar2,
2868: resultout out nocopy varchar2 ) is
2869:
2870: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2871: -- value SIGNATORY_USERNAME used in Contract Approval workflow attribute and messages
2872: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'SIGNATORY_USERNAME');
2873:
2874: cursor c1(p_name varchar2) is

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

2868: resultout out nocopy varchar2 ) is
2869:
2870: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'P_NTF_TYPE');
2871: -- value SIGNATORY_USERNAME used in Contract Approval workflow attribute and messages
2872: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'SIGNATORY_USERNAME');
2873:
2874: cursor c1(p_name varchar2) is
2875: select user_id from fnd_user
2876: where user_name=p_name;

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

2905: APPLICATION_ID => NULL);
2906: end if;
2907: if (l_p_value is NULL or l_p_value='N') then
2908: -- UnMute Recipient
2909: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2910: itemkey => itemkey,
2911: aname => '.MAIL_QUERY',
2912: avalue => ' ');
2913: else

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

2911: aname => '.MAIL_QUERY',
2912: avalue => ' ');
2913: else
2914: -- Suppress Recipient (Mute)
2915: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2916: itemkey => itemkey,
2917: aname => '.MAIL_QUERY',
2918: avalue => l_user_name);
2919: end if;

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

2990:
2991: if (funcmode = 'RUN') then
2992:
2993: -- UnMute Recipient
2994: wf_engine.SetItemAttrText (itemtype => itemtype, -- may need to hard code value OKCAUKAP
2995: itemkey => itemkey,
2996: aname => '.MAIL_QUERY',
2997: avalue => ' ');
2998: end if;