APPS.CSE_FA_STAGE_PKG dependencies on WF_ENGINE

Line 452: v_request_id := Wf_Engine.GetItemAttrText( itemtype => v_itemtype,

448: IF v_itemtype IS NULL THEN
449: v_itemtype := 'CSEWF';
450: END IF;
451:
452: v_request_id := Wf_Engine.GetItemAttrText( itemtype => v_itemtype,
453: itemkey => v_itemkey,
454: aname => 'CONC_REQUEST_ID',
455: ignore_notfound => FALSE);
456:

Line 521: WF_ENGINE.CreateProcess (

517: l_item_key := l_item_type||'-'||l_item_key_seq;
518:
519: debug('item key : '||l_item_key);
520:
521: WF_ENGINE.CreateProcess (
522: itemtype => l_item_type,
523: itemkey => l_item_key,
524: process => 'CSEPAPRC');
525:

Line 535: WF_ENGINE.SetItemAttrText (

531: AND frt.language = 'US';
532:
533: debug('resp name : '||l_resp_name);
534:
535: WF_ENGINE.SetItemAttrText (
536: itemtype => l_item_type,
537: itemkey => l_item_key,
538: aname => '#FROM_ROLE',
539: avalue => 'Asset Tracking Super User');

Line 543: WF_ENGINE.SetItemAttrText (

539: avalue => 'Asset Tracking Super User');
540:
541: l_message_subject := fnd_message.get_string('CSE', 'CSE_FA_NOTIFICATION_SUBJECT');
542: debug('message subject : '||l_message_subject);
543: WF_ENGINE.SetItemAttrText (
544: itemtype => l_item_type,
545: itemkey => l_item_key,
546: aname => 'MESSAGE_SUBJECT',
547: avalue => l_message_subject);

Line 551: WF_ENGINE.SetItemAttrText (

547: avalue => l_message_subject);
548:
549: l_message_body := fnd_message.get_string('CSE', 'CSE_FA_NOTIFICATION_MSG');
550: debug('message body : '||l_message_body);
551: WF_ENGINE.SetItemAttrText (
552: itemtype => l_item_type,
553: itemkey => l_item_key,
554: aname => 'MESSAGE_BODY',
555: avalue => l_message_body);

Line 557: WF_ENGINE.SetItemAttrText (

553: itemkey => l_item_key,
554: aname => 'MESSAGE_BODY',
555: avalue => l_message_body);
556: debug('request id : '||p_request_id);
557: WF_ENGINE.SetItemAttrText (
558: itemtype => l_item_type,
559: itemkey => l_item_key,
560: aname => 'CONC_REQUEST_ID',
561: avalue => p_request_id);

Line 565: WF_ENGINE.SetItemAttrText (

561: avalue => p_request_id);
562:
563: ib_url(l_ib_url);
564: debug('IB URL : '||l_ib_url);
565: WF_ENGINE.SetItemAttrText (
566: itemtype => l_item_type,
567: itemkey => l_item_key,
568: aname => 'IB_URL',
569: avalue => l_ib_url);

Line 578: WF_ENGINE.SetItemAttrText (

574: WHERE fr.responsibility_key = 'CSE_ASSET_PLANNER'
575: AND frt.responsibility_id = fr.responsibility_id
576: AND frt.language = 'US';
577: debug('SEND_TO : '||l_resp_name);
578: WF_ENGINE.SetItemAttrText (
579: itemtype => l_item_type,
580: itemkey => l_item_key,
581: aname => 'SEND_TO',
582: avalue => l_resp_name);

Line 585: WF_ENGINE.SetItemAttrText (

581: aname => 'SEND_TO',
582: avalue => l_resp_name);
583: debug('ATTACHMENT : ');
584:
585: WF_ENGINE.SetItemAttrText (
586: itemtype => l_item_type,
587: itemkey => l_item_key,
588: aname => 'ATTACHMENT',
589: avalue => 'PLSQLCLOB:CSE_FA_STAGE_PKG.GET_REPORT_CLOB/'||l_item_type||'|'||l_item_key);

Line 592: WF_ENGINE.StartProcess (

588: aname => 'ATTACHMENT',
589: avalue => 'PLSQLCLOB:CSE_FA_STAGE_PKG.GET_REPORT_CLOB/'||l_item_type||'|'||l_item_key);
590:
591: debug('StartProcess : ');
592: WF_ENGINE.StartProcess (
593: itemtype => l_item_type,
594: itemkey => l_item_key);
595:
596: END send_mail;