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

Line 45: lv_task_number := wf_engine.GetItemAttrText(

41: lv_itemkey := itemkey;
42:
43: -- Get the Service Request Id by using the GetItemAttr function for 'TASK_ID' and then
44: -- execute a SQL query to find out the source_object_id from JTF_TASKS_VL view for the
45: lv_task_number := wf_engine.GetItemAttrText(
46: ITEMTYPE => lv_itemtype,
47: ITEMKEY => lv_itemkey,
48: ANAME => 'TASK_NUMBER' );
49:

Line 170: lv_task_type_attr_dep_id := wf_engine.GetItemAttrText(

166: lv_task_id := TASK_ID;
167: lv_task_type_id:= TASK_TYPE_ID;
168: lv_incident_type_id := INCIDENT_TYPE_ID;
169:
170: lv_task_type_attr_dep_id := wf_engine.GetItemAttrText(
171: ITEMTYPE => lv_itemtype,
172: ITEMKEY => lv_itemkey,
173: ANAME => 'CUG_TASK_DEP_ID' );
174:

Line 201: wf_engine.SetItemAttrText(

197: AND wiav.item_type = 'CUGTASKS';
198:
199:
200: IF (lv_task_type_attr_type = 'ROLE' ) THEN
201: wf_engine.SetItemAttrText(
202: ITEMTYPE => lv_itemtype ,
203: ITEMKEY => lv_itemkey,
204: ANAME =>lv_task_type_attr_name,
205: AVALUE => upper(lv_task_type_attr_value) );

Line 207: wf_engine.SetItemAttrNumber(

203: ITEMKEY => lv_itemkey,
204: ANAME =>lv_task_type_attr_name,
205: AVALUE => upper(lv_task_type_attr_value) );
206: ELSIF (lv_task_type_attr_type = 'NUMBER' ) THEN
207: wf_engine.SetItemAttrNumber(
208: ITEMTYPE => lv_itemtype ,
209: ITEMKEY => lv_itemkey,
210: ANAME =>lv_task_type_attr_name,
211: AVALUE => to_number(lv_task_type_attr_value ) );

Line 214: wf_engine.SetItemAttrDate(

210: ANAME =>lv_task_type_attr_name,
211: AVALUE => to_number(lv_task_type_attr_value ) );
212:
213: ELSIF (lv_task_type_attr_type = 'DATE' ) THEN
214: wf_engine.SetItemAttrDate(
215: ITEMTYPE => lv_itemtype ,
216: ITEMKEY => lv_itemkey,
217: ANAME =>lv_task_type_attr_name,
218: AVALUE =>to_date(lv_task_type_attr_value,'DD-MM-YYYY') );

Line 221: wf_engine.SetItemAttrText(

217: ANAME =>lv_task_type_attr_name,
218: AVALUE =>to_date(lv_task_type_attr_value,'DD-MM-YYYY') );
219:
220: ELSE
221: wf_engine.SetItemAttrText(
222: ITEMTYPE => lv_itemtype ,
223: ITEMKEY => lv_itemkey,
224: ANAME =>lv_task_type_attr_name,
225: AVALUE => lv_task_type_attr_value );

Line 432: wf_engine.SetItemAttrText(

428:
429: -- End of changes by ANEEMUCH 12-May-2002
430:
431: -- Set the value of the incident address in the Workflow Item attribute Incident Address
432: wf_engine.SetItemAttrText(
433: ITEMTYPE => lv_itemtype ,
434: ITEMKEY => lv_itemkey,
435: ANAME =>'CUG_INC_ADDR',
436: AVALUE => lv_incident_address );

Line 566: wf_engine.SetItemAttrText (

562: IF ( length(str_attr_det) <= (4000-length(lv_sr_attrs_det))) THEN
563: lv_sr_attrs_det := lv_sr_attrs_det || str_attr_det;
564: set_Flag := 'N';
565: ELSE
566: wf_engine.SetItemAttrText (
567: ITEMTYPE => lv_itemtype ,
568: ITEMKEY => lv_itemkey,
569: ANAME => lv_wf_item_attr_nm,
570: AVALUE => lv_sr_attrs_det);

Line 586: wf_engine.SetItemAttrText (

582: CLOSE c_get_sr_attr_value;
583: /* Roopa end - to fix bug 2347352 */
584: END LOOP;
585: if (set_Flag = 'N' ) then
586: wf_engine.SetItemAttrText (
587: ITEMTYPE => lv_itemtype ,
588: ITEMKEY => lv_itemkey,
589: ANAME => lv_wf_item_attr_nm,
590: AVALUE => lv_sr_attrs_det);

Line 622: lv_reminder_interval := wf_engine.getItemAttrNumber (

618: lv_itemtype := ITEMTYPE ;
619: lv_itemkey := ITEMKEY;
620:
621: IF ( funcmode = 'RUN' ) THEN
622: lv_reminder_interval := wf_engine.getItemAttrNumber (
623: ITEMTYPE => lv_itemtype,
624: ITEMKEY => lv_itemkey,
625: ANAME => 'CUG_REMINDER_INTERVAL');
626:

Line 630: lv_uom_type := wf_engine.getItemAttrText (

626:
627: if ( lv_reminder_interval is NULL ) then
628:
629: -- Get the UOM Type from the 'Email Notification' workflow
630: lv_uom_type := wf_engine.getItemAttrText (
631: ITEMTYPE => lv_itemtype ,
632: ITEMKEY => lv_itemkey,
633: ANAME => 'CUG_UOM_DUE_DATE');
634:

Line 637: lv_offset_value := wf_engine.getItemAttrText (

633: ANAME => 'CUG_UOM_DUE_DATE');
634:
635: -- Get the Offset Value for the calculation of the due Date from
636: -- 'Email Notification' workflow
637: lv_offset_value := wf_engine.getItemAttrText (
638: ITEMTYPE => lv_itemtype ,
639: ITEMKEY => lv_itemkey,
640: ANAME => 'CUG_OFFSET_DUE_DATE');
641:

Line 654: wf_engine.SetItemAttrNumber(

650: -- Calculate the Reminder Interval and set that Item Attribute
651: -- 'CUG_REMINDER_INTERVAL' in the Workflow.
652:
653: lv_reminder_interval := (lv_conversion_rate * lv_offset_value * 60);
654: wf_engine.SetItemAttrNumber(
655: ITEMTYPE => lv_itemtype ,
656: ITEMKEY => lv_itemkey,
657: ANAME => 'CUG_REMINDER_INTERVAL',
658: AVALUE => lv_reminder_intervaL );

Line 666: wf_engine.SetItemAttrNumber(

662: end if;
663: End if;
664: EXCEPTION
665: When NO_DATA_FOUND Then
666: wf_engine.SetItemAttrNumber(
667: ITEMTYPE => lv_itemtype ,
668: ITEMKEY => lv_itemkey,
669: ANAME => 'CUG_REMINDER_INTERVAL',
670: AVALUE => 0 );

Line 703: lv_task_number := wf_engine.GetItemAttrText(

699: IF ( funcmode = 'RUN' ) THEN
700: -- Get the Service Request Id by using the GetItemAttr function for 'TASK_ID' and then
701: -- execute a SQL query to find out the source_object_id from JTF_TASKS_VL view for the
702:
703: lv_task_number := wf_engine.GetItemAttrText(
704: ITEMTYPE => lv_itemtype,
705: ITEMKEY => lv_itemkey,
706: ANAME => 'TASK_NUMBER' );
707:

Line 801: lv_task_number := wf_engine.GetItemAttrText(

797: IF ( funcmode = 'RUN' ) THEN
798:
799: -- Get the Service Request Id by using the GetItemAttr function for 'TASK_ID' and then
800: -- execute a SQL query to find out the source_object_id from JTF_TASKS_VL view for the
801: lv_task_number := wf_engine.GetItemAttrText(
802: ITEMTYPE => lv_itemtype,
803: ITEMKEY => lv_itemkey,
804: ANAME => 'TASK_NUMBER' );
805: