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_ARTWF_PVT dependencies on WF_ENGINE

Line 276: save_threshold WF_ENGINE.threshold%TYPE;

272: and int.org_id = c_org_id -- added for performance
273: and int.article_status in ('PENDING_APPROVAL', 'APPROVED')
274: and artv.article_version_number = int.article_version_number;
275:
276: save_threshold WF_ENGINE.threshold%TYPE;
277: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
278: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
279: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';
280: j NUMBER ;

Line 286: save_threshold := WF_ENGINE.threshold;

282: begin
283: clean;
284: j:=1;
285:
286: save_threshold := WF_ENGINE.threshold;
287:
288: WF_ENGINE.threshold := -1;
289: for cv_imp_rec in cv_import(p_req_id, p_batch_number, p_org_id)
290: loop

Line 288: WF_ENGINE.threshold := -1;

284: j:=1;
285:
286: save_threshold := WF_ENGINE.threshold;
287:
288: WF_ENGINE.threshold := -1;
289: for cv_imp_rec in cv_import(p_req_id, p_batch_number, p_org_id)
290: loop
291: begin
292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');

Line 292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');

288: WF_ENGINE.threshold := -1;
289: for cv_imp_rec in cv_import(p_req_id, p_batch_number, p_org_id)
290: loop
291: begin
292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');
293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);

Line 293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);

289: for cv_imp_rec in cv_import(p_req_id, p_batch_number, p_org_id)
290: loop
291: begin
292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');
293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);

Line 294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);

290: loop
291: begin
292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');
293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);

Line 295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);

291: begin
292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');
293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);

Line 296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);

292: wf_engine.CreateProcess( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLES_AFTER_IMPORT_PROC');
293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);

Line 297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);

293: wf_engine.SetItemUserKey( 'OKCARTAP', cv_imp_rec.ikey, cv_imp_rec.ukey);
294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);

Line 298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);

294: wf_engine.SetItemOwner( 'OKCARTAP', cv_imp_rec.ikey, fnd_global.user_name);
295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);

Line 299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);

295: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'USER_ID', fnd_global.user_id);
296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);

Line 300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);

296: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_ID', fnd_global.resp_id);
297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);

Line 301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);

297: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'RESP_APPL_ID', fnd_global.resp_appl_id);
298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);
305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));

Line 302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);

298: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ORG_ID', cv_imp_rec.org_id);
299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);
305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
306: wf_engine.StartProcess('OKCARTAP' , cv_imp_rec.ikey);

Line 303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);

299: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_ID', cv_imp_rec.article_id);
300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);
305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
306: wf_engine.StartProcess('OKCARTAP' , cv_imp_rec.ikey);
307:

Line 304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);

300: wf_engine.SetItemAttrNumber( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_VERSION_ID', cv_imp_rec.article_version_id);
301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);
305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
306: wf_engine.StartProcess('OKCARTAP' , cv_imp_rec.ikey);
307:
308: IF j = 500 THEN

Line 305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));

301: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ARTICLE_STATUS', cv_imp_rec.article_status);
302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);
305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
306: wf_engine.StartProcess('OKCARTAP' , cv_imp_rec.ikey);
307:
308: IF j = 500 THEN
309: commit;

Line 306: wf_engine.StartProcess('OKCARTAP' , cv_imp_rec.ikey);

302: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'ADOPTION_TYPE', cv_imp_rec.adoption_type);
303: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'GLOBAL_YN', cv_imp_rec.global_yn);
304: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR', fnd_global.user_name);
305: wf_engine.SetItemAttrText( 'OKCARTAP', cv_imp_rec.ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
306: wf_engine.StartProcess('OKCARTAP' , cv_imp_rec.ikey);
307:
308: IF j = 500 THEN
309: commit;
310: j:=0;

Line 333: WF_ENGINE.threshold := save_threshold;

329: p_token2_value => sqlerrm);
330: end;
331: end loop;
332: commit;
333: WF_ENGINE.threshold := save_threshold;
334: end;
335:
336: -- -----------------------------------------------------------------------------
337: -- Function get_intent

Line 351: art_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);

347: is
348: art_id okc_articles_all.article_id%type;
349: art_intent okc_articles_all.article_intent%type;
350: begin
351: art_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
352: select article_intent into art_intent
353: from okc_articles_all
354: where article_id = art_id;
355: return art_intent;

Line 728: operation Wf_Engine.NameTabTyp;

724: hr.organization_id = local_org_id
725: and
726: org_information_context = 'OKC_TERMS_LIBRARY_DETAILS';
727:
728: operation Wf_Engine.NameTabTyp;
729: operation_list Wf_Engine.TextTabTyp;
730: organization Wf_Engine.NameTabTyp;
731: organization_list Wf_Engine.NumTabTyp;
732: notified Wf_Engine.NameTabTyp;

Line 729: operation_list Wf_Engine.TextTabTyp;

725: and
726: org_information_context = 'OKC_TERMS_LIBRARY_DETAILS';
727:
728: operation Wf_Engine.NameTabTyp;
729: operation_list Wf_Engine.TextTabTyp;
730: organization Wf_Engine.NameTabTyp;
731: organization_list Wf_Engine.NumTabTyp;
732: notified Wf_Engine.NameTabTyp;
733: notified_list Wf_Engine.TextTabTyp;

Line 730: organization Wf_Engine.NameTabTyp;

726: org_information_context = 'OKC_TERMS_LIBRARY_DETAILS';
727:
728: operation Wf_Engine.NameTabTyp;
729: operation_list Wf_Engine.TextTabTyp;
730: organization Wf_Engine.NameTabTyp;
731: organization_list Wf_Engine.NumTabTyp;
732: notified Wf_Engine.NameTabTyp;
733: notified_list Wf_Engine.TextTabTyp;
734:

Line 731: organization_list Wf_Engine.NumTabTyp;

727:
728: operation Wf_Engine.NameTabTyp;
729: operation_list Wf_Engine.TextTabTyp;
730: organization Wf_Engine.NameTabTyp;
731: organization_list Wf_Engine.NumTabTyp;
732: notified Wf_Engine.NameTabTyp;
733: notified_list Wf_Engine.TextTabTyp;
734:
735: art_intent varchar2(1);

Line 732: notified Wf_Engine.NameTabTyp;

728: operation Wf_Engine.NameTabTyp;
729: operation_list Wf_Engine.TextTabTyp;
730: organization Wf_Engine.NameTabTyp;
731: organization_list Wf_Engine.NumTabTyp;
732: notified Wf_Engine.NameTabTyp;
733: notified_list Wf_Engine.TextTabTyp;
734:
735: art_intent varchar2(1);
736: counter number;

Line 733: notified_list Wf_Engine.TextTabTyp;

729: operation_list Wf_Engine.TextTabTyp;
730: organization Wf_Engine.NameTabTyp;
731: organization_list Wf_Engine.NumTabTyp;
732: notified Wf_Engine.NameTabTyp;
733: notified_list Wf_Engine.TextTabTyp;
734:
735: art_intent varchar2(1);
736: counter number;
737: begin

Line 740: artv_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);

736: counter number;
737: begin
738: counter := 0;
739: art_intent := get_intent(itemtype, itemkey);
740: artv_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
741: if ( funcmode = 'RUN' ) then
742: for c_rec in c_notified(artv_id, art_intent)
743: loop
744: counter := counter+1;

Line 752: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);

748: organization_list(counter):= c_rec.organization_id;
749: notified(counter):= 'NOTIFIED_LIST$'||counter;
750: notified_list(counter):= c_rec.notified;
751: end loop;
752: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);
753: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);
754: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);
755: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);
756: resultout := 'COMPLETE';

Line 753: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);

749: notified(counter):= 'NOTIFIED_LIST$'||counter;
750: notified_list(counter):= c_rec.notified;
751: end loop;
752: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);
753: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);
754: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);
755: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);
756: resultout := 'COMPLETE';
757: return;

Line 754: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);

750: notified_list(counter):= c_rec.notified;
751: end loop;
752: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);
753: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);
754: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);
755: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);
756: resultout := 'COMPLETE';
757: return;
758: end if;

Line 755: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);

751: end loop;
752: wf_engine.AddItemAttrTextArray( itemtype, itemkey, operation, operation_list);
753: wf_engine.AddItemAttrNumberArray( itemtype, itemkey, organization, organization_list);
754: wf_engine.AddItemAttrTextArray( itemtype, itemkey, notified, notified_list);
755: wf_engine.AddItemAttr(itemtype, itemkey, 'COUNTER$', null, counter, null);
756: resultout := 'COMPLETE';
757: return;
758: end if;
759: exception

Line 778: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false) - 1;

774: resultout out nocopy varchar2)
775: is
776: counter number;
777: begin
778: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false) - 1;
779: if counter > 0 then
780: wf_engine.setItemAttrNumber(itemtype, itemkey, 'COUNTER$', counter);
781: resultout := 'COMPLETE:T';
782: else

Line 780: wf_engine.setItemAttrNumber(itemtype, itemkey, 'COUNTER$', counter);

776: counter number;
777: begin
778: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false) - 1;
779: if counter > 0 then
780: wf_engine.setItemAttrNumber(itemtype, itemkey, 'COUNTER$', counter);
781: resultout := 'COMPLETE:T';
782: else
783: resultout := 'COMPLETE:F';
784: end if;

Line 819: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);

815: valid_notified FND_USER.user_name%TYPE;
816: --end of fix
817:
818: begin
819: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);
820: if counter > 0 then
821: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
822: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
823: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);

Line 821: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);

817:
818: begin
819: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);
820: if counter > 0 then
821: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
822: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
823: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);
824: wf_engine.setItemAttrText(itemtype, itemkey, 'OPERATION$', operation);
825: wf_engine.setItemAttrNumber(itemtype, itemkey, 'ORGANIZATION$', organization);

Line 822: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);

818: begin
819: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);
820: if counter > 0 then
821: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
822: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
823: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);
824: wf_engine.setItemAttrText(itemtype, itemkey, 'OPERATION$', operation);
825: wf_engine.setItemAttrNumber(itemtype, itemkey, 'ORGANIZATION$', organization);
826:

Line 823: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);

819: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);
820: if counter > 0 then
821: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
822: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
823: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);
824: wf_engine.setItemAttrText(itemtype, itemkey, 'OPERATION$', operation);
825: wf_engine.setItemAttrNumber(itemtype, itemkey, 'ORGANIZATION$', organization);
826:
827: --Fix for 6237128.

Line 824: wf_engine.setItemAttrText(itemtype, itemkey, 'OPERATION$', operation);

820: if counter > 0 then
821: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
822: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
823: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);
824: wf_engine.setItemAttrText(itemtype, itemkey, 'OPERATION$', operation);
825: wf_engine.setItemAttrNumber(itemtype, itemkey, 'ORGANIZATION$', organization);
826:
827: --Fix for 6237128.
828: valid_notified := NULL;

Line 825: wf_engine.setItemAttrNumber(itemtype, itemkey, 'ORGANIZATION$', organization);

821: operation := wf_engine.getItemAttrText(itemtype, itemkey, 'OPERATION_LIST$'||counter, false);
822: organization := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORGANIZATION_LIST$'||counter, false);
823: notified := wf_engine.getItemAttrText(itemtype, itemkey, 'NOTIFIED_LIST$'||counter, false);
824: wf_engine.setItemAttrText(itemtype, itemkey, 'OPERATION$', operation);
825: wf_engine.setItemAttrNumber(itemtype, itemkey, 'ORGANIZATION$', organization);
826:
827: --Fix for 6237128.
828: valid_notified := NULL;
829: OPEN c_usr(notified);

Line 837: wf_engine.setItemAttrText(itemtype, itemkey, 'NOTIFIED$', notified);

833: END IF;
834: CLOSE c_usr;
835: --end of fix
836:
837: wf_engine.setItemAttrText(itemtype, itemkey, 'NOTIFIED$', notified);
838: -- bug 3185684
839: fnd_message.set_name('OKC', 'OKC_ART_UNDEFINED_ADMIN');
840: fnd_message.set_token('ORGNAME', organization);
841: wf_engine.setItemAttrText(itemtype, itemkey, 'WARNING', fnd_message.get);

Line 841: wf_engine.setItemAttrText(itemtype, itemkey, 'WARNING', fnd_message.get);

837: wf_engine.setItemAttrText(itemtype, itemkey, 'NOTIFIED$', notified);
838: -- bug 3185684
839: fnd_message.set_name('OKC', 'OKC_ART_UNDEFINED_ADMIN');
840: fnd_message.set_token('ORGNAME', organization);
841: wf_engine.setItemAttrText(itemtype, itemkey, 'WARNING', fnd_message.get);
842: wf_engine.setItemAttrText(itemtype, itemkey, 'WF_ADMINISTRATOR', 'SYSADMIN');
843:
844: resultout := 'COMPLETE:'||operation;
845: else

Line 842: wf_engine.setItemAttrText(itemtype, itemkey, 'WF_ADMINISTRATOR', 'SYSADMIN');

838: -- bug 3185684
839: fnd_message.set_name('OKC', 'OKC_ART_UNDEFINED_ADMIN');
840: fnd_message.set_token('ORGNAME', organization);
841: wf_engine.setItemAttrText(itemtype, itemkey, 'WARNING', fnd_message.get);
842: wf_engine.setItemAttrText(itemtype, itemkey, 'WF_ADMINISTRATOR', 'SYSADMIN');
843:
844: resultout := 'COMPLETE:'||operation;
845: else
846: resultout := 'COMPLETE:UNDEFINED';

Line 880: org_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);

876: approver_role wf_users.name%type;
877: approver_name wf_users.display_name%type;
878: begin
879:
880: org_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
881: if ( funcmode = 'RUN' ) then
882: art_intent := get_intent(itemtype, itemkey);
883: approver_role := get_approver(org_id, art_intent);
884: begin

Line 891: wf_engine.SetItemAttrText( itemtype, itemkey, 'APPROVER_ROLE', approver_role);

887: exception
888: when others then
889: approver_name := null;
890: end;
891: wf_engine.SetItemAttrText( itemtype, itemkey, 'APPROVER_ROLE', approver_role);
892: wf_engine.SetItemAttrText( itemtype, itemkey, 'APPROVER_DISPLAY_NAME', approver_name);
893: resultout := 'COMPLETE';
894: return;
895: end if;

Line 892: wf_engine.SetItemAttrText( itemtype, itemkey, 'APPROVER_DISPLAY_NAME', approver_name);

888: when others then
889: approver_name := null;
890: end;
891: wf_engine.SetItemAttrText( itemtype, itemkey, 'APPROVER_ROLE', approver_role);
892: wf_engine.SetItemAttrText( itemtype, itemkey, 'APPROVER_DISPLAY_NAME', approver_name);
893: resultout := 'COMPLETE';
894: return;
895: end if;
896: exception

Line 987: message_code := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'MESSAGE_CODE', false);

983: approver_name wf_users.display_name%type;
984:
985: begin
986: if ( funcmode = 'RUN' ) then
987: message_code := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'MESSAGE_CODE', false);
988: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
989: article_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
990: article_version_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
991: wf_engine.SetItemAttrText(itemtype, itemkey, 'SUBJECT', message_code);

Line 988: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);

984:
985: begin
986: if ( funcmode = 'RUN' ) then
987: message_code := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'MESSAGE_CODE', false);
988: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
989: article_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
990: article_version_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
991: wf_engine.SetItemAttrText(itemtype, itemkey, 'SUBJECT', message_code);
992: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORGANIZATION_NAME', get_org_name(org_id));

Line 989: article_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);

985: begin
986: if ( funcmode = 'RUN' ) then
987: message_code := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'MESSAGE_CODE', false);
988: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
989: article_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
990: article_version_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
991: wf_engine.SetItemAttrText(itemtype, itemkey, 'SUBJECT', message_code);
992: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORGANIZATION_NAME', get_org_name(org_id));
993:

Line 990: article_version_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);

986: if ( funcmode = 'RUN' ) then
987: message_code := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'MESSAGE_CODE', false);
988: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
989: article_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
990: article_version_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
991: wf_engine.SetItemAttrText(itemtype, itemkey, 'SUBJECT', message_code);
992: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORGANIZATION_NAME', get_org_name(org_id));
993:
994: if message_code in (

Line 991: wf_engine.SetItemAttrText(itemtype, itemkey, 'SUBJECT', message_code);

987: message_code := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'MESSAGE_CODE', false);
988: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
989: article_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
990: article_version_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
991: wf_engine.SetItemAttrText(itemtype, itemkey, 'SUBJECT', message_code);
992: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORGANIZATION_NAME', get_org_name(org_id));
993:
994: if message_code in (
995: 'OKC_ART_ADOPTION_NTF_SUBJECT',

Line 992: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORGANIZATION_NAME', get_org_name(org_id));

988: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
989: article_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
990: article_version_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
991: wf_engine.SetItemAttrText(itemtype, itemkey, 'SUBJECT', message_code);
992: wf_engine.SetItemAttrText(itemtype, itemkey, 'ORGANIZATION_NAME', get_org_name(org_id));
993:
994: if message_code in (
995: 'OKC_ART_ADOPTION_NTF_SUBJECT',
996: 'OKC_ART_ADOPTION_NTF_SUBJECT_A',

Line 999: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_ADOPTION_NTF_DETAILS');

995: 'OKC_ART_ADOPTION_NTF_SUBJECT',
996: 'OKC_ART_ADOPTION_NTF_SUBJECT_A',
997: 'OKC_ART_ADOPTION_NTF_SUBJECT_R'
998: ) then
999: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_ADOPTION_NTF_DETAILS');
1000: for c_adopt_rec in c_adopt(org_id, article_version_id)
1001: loop
1002: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_adopt_rec.article_title);
1003: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_adopt_rec.article_number);

Line 1002: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_adopt_rec.article_title);

998: ) then
999: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_ADOPTION_NTF_DETAILS');
1000: for c_adopt_rec in c_adopt(org_id, article_version_id)
1001: loop
1002: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_adopt_rec.article_title);
1003: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_adopt_rec.article_number);
1004: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_adopt_rec.article_version_number);
1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);
1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);

Line 1003: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_adopt_rec.article_number);

999: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_ADOPTION_NTF_DETAILS');
1000: for c_adopt_rec in c_adopt(org_id, article_version_id)
1001: loop
1002: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_adopt_rec.article_title);
1003: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_adopt_rec.article_number);
1004: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_adopt_rec.article_version_number);
1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);
1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);
1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);

Line 1004: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_adopt_rec.article_version_number);

1000: for c_adopt_rec in c_adopt(org_id, article_version_id)
1001: loop
1002: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_adopt_rec.article_title);
1003: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_adopt_rec.article_number);
1004: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_adopt_rec.article_version_number);
1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);
1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);
1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);
1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);

Line 1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);

1001: loop
1002: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_adopt_rec.article_title);
1003: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_adopt_rec.article_number);
1004: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_adopt_rec.article_version_number);
1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);
1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);
1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);
1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);
1009: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_adopt_rec.provision_meaning);

Line 1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);

1002: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_adopt_rec.article_title);
1003: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_adopt_rec.article_number);
1004: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_adopt_rec.article_version_number);
1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);
1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);
1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);
1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);
1009: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_adopt_rec.provision_meaning);
1010: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_adopt_rec.start_date);

Line 1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);

1003: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_adopt_rec.article_number);
1004: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_adopt_rec.article_version_number);
1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);
1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);
1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);
1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);
1009: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_adopt_rec.provision_meaning);
1010: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_adopt_rec.start_date);
1011: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_adopt_rec.end_date);

Line 1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);

1004: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_adopt_rec.article_version_number);
1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);
1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);
1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);
1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);
1009: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_adopt_rec.provision_meaning);
1010: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_adopt_rec.start_date);
1011: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_adopt_rec.end_date);
1012: end loop;

Line 1009: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_adopt_rec.provision_meaning);

1005: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_adopt_rec.article_description);
1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);
1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);
1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);
1009: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_adopt_rec.provision_meaning);
1010: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_adopt_rec.start_date);
1011: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_adopt_rec.end_date);
1012: end loop;
1013: resultout := 'COMPLETE';

Line 1010: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_adopt_rec.start_date);

1006: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_adopt_rec.type_meaning);
1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);
1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);
1009: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_adopt_rec.provision_meaning);
1010: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_adopt_rec.start_date);
1011: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_adopt_rec.end_date);
1012: end loop;
1013: resultout := 'COMPLETE';
1014:

Line 1011: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_adopt_rec.end_date);

1007: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_adopt_rec.intent_meaning);
1008: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_adopt_rec.global_meaning);
1009: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_adopt_rec.provision_meaning);
1010: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_adopt_rec.start_date);
1011: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_adopt_rec.end_date);
1012: end loop;
1013: resultout := 'COMPLETE';
1014:
1015: elsif message_code in (

Line 1020: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_APPROVAL_NTF_DETAILS');

1016: 'OKC_ART_APPROVAL_NTF_SUBJECT',
1017: 'OKC_ART_APPROVAL_NTF_SUBJECT_A',
1018: 'OKC_ART_APPROVAL_NTF_SUBJECT_R'
1019: ) then
1020: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_APPROVAL_NTF_DETAILS');
1021: for c_approve_rec in c_approve(org_id, article_version_id)
1022: loop
1023: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1024: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);

Line 1023: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);

1019: ) then
1020: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_APPROVAL_NTF_DETAILS');
1021: for c_approve_rec in c_approve(org_id, article_version_id)
1022: loop
1023: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1024: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1025: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);

Line 1024: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);

1020: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_APPROVAL_NTF_DETAILS');
1021: for c_approve_rec in c_approve(org_id, article_version_id)
1022: loop
1023: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1024: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1025: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);

Line 1025: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);

1021: for c_approve_rec in c_approve(org_id, article_version_id)
1022: loop
1023: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1024: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1025: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);

Line 1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);

1022: loop
1023: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1024: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1025: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1030: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);

Line 1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);

1023: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1024: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1025: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1030: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1031: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);

Line 1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);

1024: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1025: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1030: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1031: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1032: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);

Line 1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);

1025: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1030: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1031: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1032: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);
1033: end loop;

Line 1030: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);

1026: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1030: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1031: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1032: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);
1033: end loop;
1034: resultout := 'COMPLETE';

Line 1031: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);

1027: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1030: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1031: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1032: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);
1033: end loop;
1034: resultout := 'COMPLETE';
1035: elsif message_code in (

Line 1032: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);

1028: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1029: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1030: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1031: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1032: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);
1033: end loop;
1034: resultout := 'COMPLETE';
1035: elsif message_code in (
1036: 'OKC_ART_ADOPTED_NTF_SUBJECT',

Line 1039: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_APPROVAL_NTF_DETAILS');

1035: elsif message_code in (
1036: 'OKC_ART_ADOPTED_NTF_SUBJECT',
1037: 'OKC_ART_AVAILABLE_NTF_SUBJECT'
1038: ) then
1039: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_APPROVAL_NTF_DETAILS');
1040: for c_approve_rec in c_approve(org_id, article_version_id)
1041: loop
1042: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1043: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);

Line 1042: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);

1038: ) then
1039: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_APPROVAL_NTF_DETAILS');
1040: for c_approve_rec in c_approve(org_id, article_version_id)
1041: loop
1042: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1043: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1044: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);

Line 1043: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);

1039: wf_engine.SetItemAttrText(itemtype, itemkey, 'FWK_FUNCTION_NAME', 'OKC_ART_APPROVAL_NTF_DETAILS');
1040: for c_approve_rec in c_approve(org_id, article_version_id)
1041: loop
1042: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1043: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1044: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);

Line 1044: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);

1040: for c_approve_rec in c_approve(org_id, article_version_id)
1041: loop
1042: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1043: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1044: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);

Line 1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);

1041: loop
1042: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1043: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1044: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1049: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);

Line 1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);

1042: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TITLE', c_approve_rec.article_title);
1043: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1044: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1049: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1050: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);

Line 1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);

1043: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_NUMBER', c_approve_rec.article_number);
1044: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1049: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1050: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1051: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);

Line 1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);

1044: wf_engine.SetItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_NUMBER', c_approve_rec.article_version_number);
1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1049: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1050: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1051: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);
1052: end loop;

Line 1049: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);

1045: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_DESCRIPTION', c_approve_rec.article_description);
1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1049: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1050: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1051: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);
1052: end loop;
1053: resultout := 'COMPLETE';

Line 1050: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);

1046: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_TYPE', c_approve_rec.type_meaning);
1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1049: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1050: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1051: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);
1052: end loop;
1053: resultout := 'COMPLETE';
1054: end if;

Line 1051: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);

1047: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_INTENT', c_approve_rec.intent_meaning);
1048: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_GLOBAL_YN', c_approve_rec.global_meaning);
1049: wf_engine.SetItemAttrText(itemtype, itemkey, 'ARTICLE_PROVISION_YN', c_approve_rec.provision_meaning);
1050: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_START_DATE', c_approve_rec.start_date);
1051: wf_engine.SetItemAttrDate(itemtype, itemkey, 'ARTICLE_END_DATE', c_approve_rec.end_date);
1052: end loop;
1053: resultout := 'COMPLETE';
1054: end if;
1055: return;

Line 1117: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', true);

1113: resp_id number;
1114: resp_appl_id number;
1115:
1116: begin
1117: org_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ORG_ID', true);
1118: -- get current apps context params
1119: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1120: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
1121: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));

Line 1123: user_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'USER_ID', true);

1119: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1120: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
1121: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
1122: -- get apps context params saved in wf
1123: user_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'USER_ID', true);
1124: resp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_ID', true);
1125: resp_appl_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_APPL_ID', true);
1126: -- set apps context if needed
1127: if ( command = 'SET_CTX' ) then

Line 1124: resp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_ID', true);

1120: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
1121: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
1122: -- get apps context params saved in wf
1123: user_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'USER_ID', true);
1124: resp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_ID', true);
1125: resp_appl_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_APPL_ID', true);
1126: -- set apps context if needed
1127: if ( command = 'SET_CTX' ) then
1128: fnd_global.apps_initialize(user_id, resp_id, resp_appl_id);

Line 1125: resp_appl_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_APPL_ID', true);

1121: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
1122: -- get apps context params saved in wf
1123: user_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'USER_ID', true);
1124: resp_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_ID', true);
1125: resp_appl_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'RESP_APPL_ID', true);
1126: -- set apps context if needed
1127: if ( command = 'SET_CTX' ) then
1128: fnd_global.apps_initialize(user_id, resp_id, resp_appl_id);
1129: mo_global.set_policy_context('S', org_id);

Line 1172: adoption_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', false);

1168: user_id := null;
1169: resp_id := null;
1170: resp_appl_id := null;
1171: if ( command = 'RUN' ) then
1172: adoption_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', false);
1173: global_yn := wf_engine.GetItemAttrText(itemtype, itemkey, 'GLOBAL_YN', false);
1174: if adoption_type in ('AVAILABLE', 'ADOPTED') then
1175: resultout := 'ARTICLES_ADOPTION_PROC'; -- start articles adoption process
1176: else

Line 1173: global_yn := wf_engine.GetItemAttrText(itemtype, itemkey, 'GLOBAL_YN', false);

1169: resp_id := null;
1170: resp_appl_id := null;
1171: if ( command = 'RUN' ) then
1172: adoption_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'ADOPTION_TYPE', false);
1173: global_yn := wf_engine.GetItemAttrText(itemtype, itemkey, 'GLOBAL_YN', false);
1174: if adoption_type in ('AVAILABLE', 'ADOPTED') then
1175: resultout := 'ARTICLES_ADOPTION_PROC'; -- start articles adoption process
1176: else
1177: if global_yn = 'Y' then

Line 1212: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);

1208: org_id number;
1209: begin
1210: if ( funcmode = 'RUN' ) then
1211: article_version_id :=
1212: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
1213: org_id :=
1214: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
1215: adoption_flag :=
1216: wf_engine.getItemAttrText(itemtype, itemkey, 'ADOPTION_YN', false);

Line 1214: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);

1210: if ( funcmode = 'RUN' ) then
1211: article_version_id :=
1212: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
1213: org_id :=
1214: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
1215: adoption_flag :=
1216: wf_engine.getItemAttrText(itemtype, itemkey, 'ADOPTION_YN', false);
1217: OKC_ARTICLE_STATUS_CHANGE_PVT.approve(null,null,
1218: l_return_status, msg_count, msg_data, org_id, adoption_flag, article_version_id);

Line 1216: wf_engine.getItemAttrText(itemtype, itemkey, 'ADOPTION_YN', false);

1212: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
1213: org_id :=
1214: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
1215: adoption_flag :=
1216: wf_engine.getItemAttrText(itemtype, itemkey, 'ADOPTION_YN', false);
1217: OKC_ARTICLE_STATUS_CHANGE_PVT.approve(null,null,
1218: l_return_status, msg_count, msg_data, org_id, adoption_flag, article_version_id);
1219: resultout := 'COMPLETE';
1220: If l_return_status <> 'S' THEN

Line 1257: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);

1253: org_id number;
1254: begin
1255: if ( funcmode = 'RUN' ) then
1256: article_version_id :=
1257: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
1258: org_id :=
1259: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
1260: adoption_flag :=
1261: wf_engine.getItemAttrText(itemtype, itemkey, 'ADOPTION_YN', false);

Line 1259: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);

1255: if ( funcmode = 'RUN' ) then
1256: article_version_id :=
1257: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
1258: org_id :=
1259: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
1260: adoption_flag :=
1261: wf_engine.getItemAttrText(itemtype, itemkey, 'ADOPTION_YN', false);
1262: OKC_ARTICLE_STATUS_CHANGE_PVT.reject(null,null,
1263: l_return_status, msg_count, msg_data, org_id, adoption_flag, article_version_id);

Line 1261: wf_engine.getItemAttrText(itemtype, itemkey, 'ADOPTION_YN', false);

1257: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ARTICLE_VERSION_ID', false);
1258: org_id :=
1259: wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
1260: adoption_flag :=
1261: wf_engine.getItemAttrText(itemtype, itemkey, 'ADOPTION_YN', false);
1262: OKC_ARTICLE_STATUS_CHANGE_PVT.reject(null,null,
1263: l_return_status, msg_count, msg_data, org_id, adoption_flag, article_version_id);
1264: resultout := 'COMPLETE';
1265: If l_return_status <> 'S' THEN

Line 1319: wf_engine.CreateProcess( 'OKCARTAP', c_tab(i).ikey, 'ARTICLES_APPROVAL_ROOT_PROC');

1315: result := 'OK';
1316: for i in 1..write_ptr
1317: loop
1318: begin
1319: wf_engine.CreateProcess( 'OKCARTAP', c_tab(i).ikey, 'ARTICLES_APPROVAL_ROOT_PROC');
1320: wf_engine.SetItemUserKey( 'OKCARTAP', c_tab(i).ikey, c_tab(i).ukey);
1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);
1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);

Line 1320: wf_engine.SetItemUserKey( 'OKCARTAP', c_tab(i).ikey, c_tab(i).ukey);

1316: for i in 1..write_ptr
1317: loop
1318: begin
1319: wf_engine.CreateProcess( 'OKCARTAP', c_tab(i).ikey, 'ARTICLES_APPROVAL_ROOT_PROC');
1320: wf_engine.SetItemUserKey( 'OKCARTAP', c_tab(i).ikey, c_tab(i).ukey);
1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);
1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);

Line 1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);

1317: loop
1318: begin
1319: wf_engine.CreateProcess( 'OKCARTAP', c_tab(i).ikey, 'ARTICLES_APPROVAL_ROOT_PROC');
1320: wf_engine.SetItemUserKey( 'OKCARTAP', c_tab(i).ikey, c_tab(i).ukey);
1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);
1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);

Line 1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);

1318: begin
1319: wf_engine.CreateProcess( 'OKCARTAP', c_tab(i).ikey, 'ARTICLES_APPROVAL_ROOT_PROC');
1320: wf_engine.SetItemUserKey( 'OKCARTAP', c_tab(i).ikey, c_tab(i).ukey);
1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);
1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);
1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);

Line 1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);

1319: wf_engine.CreateProcess( 'OKCARTAP', c_tab(i).ikey, 'ARTICLES_APPROVAL_ROOT_PROC');
1320: wf_engine.SetItemUserKey( 'OKCARTAP', c_tab(i).ikey, c_tab(i).ukey);
1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);
1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);
1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);
1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);

Line 1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);

1320: wf_engine.SetItemUserKey( 'OKCARTAP', c_tab(i).ikey, c_tab(i).ukey);
1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);
1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);
1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);
1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);

Line 1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);

1321: wf_engine.SetItemOwner( 'OKCARTAP', c_tab(i).ikey, fnd_global.user_name);
1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);
1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);
1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);

Line 1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);

1322: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'USER_ID', user_id);
1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);
1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);
1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);

Line 1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);

1323: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_ID', resp_id);
1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);
1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);
1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);

Line 1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);

1324: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'RESP_APPL_ID', resp_appl_id);
1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);
1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);
1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);
1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));

Line 1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);

1325: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ORG_ID', c_tab(i).org_id);
1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);
1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);
1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
1333: wf_engine.StartProcess('OKCARTAP' , c_tab(i).ikey);

Line 1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);

1326: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_ID', c_tab(i).article_id);
1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);
1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
1333: wf_engine.StartProcess('OKCARTAP' , c_tab(i).ikey);
1334: commit;

Line 1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);

1327: wf_engine.SetItemAttrNumber( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_VERSION_ID', c_tab(i).article_version_id);
1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);
1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
1333: wf_engine.StartProcess('OKCARTAP' , c_tab(i).ikey);
1334: commit;
1335: exception

Line 1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));

1328: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ARTICLE_STATUS', c_tab(i).article_status);
1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);
1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
1333: wf_engine.StartProcess('OKCARTAP' , c_tab(i).ikey);
1334: commit;
1335: exception
1336: when others then

Line 1333: wf_engine.StartProcess('OKCARTAP' , c_tab(i).ikey);

1329: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'ADOPTION_TYPE', c_tab(i).adoption_type);
1330: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'GLOBAL_YN', c_tab(i).global_yn);
1331: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR', fnd_global.user_name);
1332: wf_engine.SetItemAttrText( 'OKCARTAP', c_tab(i).ikey, 'REQUESTOR_DISPLAY_NAME', get_display_name(fnd_global.user_name));
1333: wf_engine.StartProcess('OKCARTAP' , c_tab(i).ikey);
1334: commit;
1335: exception
1336: when others then
1337: result := 'NOK';

Line 1832: open approver(wf_engine.CONTEXT_NEW_ROLE);

1828:
1829: begin
1830: if (funcmode = 'TRANSFER') then
1831:
1832: open approver(wf_engine.CONTEXT_NEW_ROLE);
1833: fetch approver into approver_name;
1834: close approver;
1835:
1836: wf_engine.SetItemAttrText( itemtype,

Line 1836: wf_engine.SetItemAttrText( itemtype,

1832: open approver(wf_engine.CONTEXT_NEW_ROLE);
1833: fetch approver into approver_name;
1834: close approver;
1835:
1836: wf_engine.SetItemAttrText( itemtype,
1837: itemkey,
1838: 'APPROVER_ROLE',
1839: wf_engine.CONTEXT_NEW_ROLE);
1840: wf_engine.SetItemAttrText( itemtype,

Line 1839: wf_engine.CONTEXT_NEW_ROLE);

1835:
1836: wf_engine.SetItemAttrText( itemtype,
1837: itemkey,
1838: 'APPROVER_ROLE',
1839: wf_engine.CONTEXT_NEW_ROLE);
1840: wf_engine.SetItemAttrText( itemtype,
1841: itemkey,
1842: 'APPROVER_DISPLAY_NAME',
1843: approver_name);

Line 1840: wf_engine.SetItemAttrText( itemtype,

1836: wf_engine.SetItemAttrText( itemtype,
1837: itemkey,
1838: 'APPROVER_ROLE',
1839: wf_engine.CONTEXT_NEW_ROLE);
1840: wf_engine.SetItemAttrText( itemtype,
1841: itemkey,
1842: 'APPROVER_DISPLAY_NAME',
1843: approver_name);
1844: end if;

Line 1926: itemtype wf_engine.setctx_itemtype%type;

1922: article_id okc_articles_all.article_id%type;
1923: article_version_id okc_article_versions.article_version_id%type;
1924:
1925: requestor_name wf_users.display_name%type;
1926: itemtype wf_engine.setctx_itemtype%type;
1927: itemkey wf_engine.setctx_itemkey%type;
1928: nid number;
1929: begin
1930: start_log('subject');

Line 1927: itemkey wf_engine.setctx_itemkey%type;

1923: article_version_id okc_article_versions.article_version_id%type;
1924:
1925: requestor_name wf_users.display_name%type;
1926: itemtype wf_engine.setctx_itemtype%type;
1927: itemkey wf_engine.setctx_itemkey%type;
1928: nid number;
1929: begin
1930: start_log('subject');
1931: log('subject entry');

Line 1956: value => wf_engine.GetItemAttrText( itemtype, itemkey, 'REQUESTOR_DISPLAY_NAME'));

1952: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_VERSION_NUMBER'));
1953: if message_code in ( 'OKC_ART_ADOPTION_NTF_SUBJECT',
1954: 'OKC_ART_APPROVAL_NTF_SUBJECT') then
1955: fnd_message.set_token( token => 'APPROVERNAME',
1956: value => wf_engine.GetItemAttrText( itemtype, itemkey, 'REQUESTOR_DISPLAY_NAME'));
1957: end if;
1958: if message_code in ( 'OKC_ART_ADOPTED_NTF_SUBJECT',
1959: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then
1960: fnd_message.set_token( token => 'ORGANIZATIONNAME',