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 CUG_TSK_TYP_ATTR_MAPS_VL

Line 154: -- Cursor declaration for all the Task attributes from CUG_TSK_TYP_ATTR_MAPS_VL table

150: lv_task_type_attr_type VARCHAR2(8);
151: lv_task_type_attr_dep_id NUMBER;
152: lv_incident_date DATE;
153:
154: -- Cursor declaration for all the Task attributes from CUG_TSK_TYP_ATTR_MAPS_VL table
155: -- for a given TASK_TYPE_ID, and TASK_ID as input parameter, and ITEMTYPE is the Workflow
156: -- internal Name for Task related workflow.
157:
158: CURSOR c_all_task_attrs IS

Line 160: FROM cug_tsk_typ_attr_maps_vl

156: -- internal Name for Task related workflow.
157:
158: CURSOR c_all_task_attrs IS
159: SELECT task_type_attribute_code
160: FROM cug_tsk_typ_attr_maps_vl
161: WHERE TASK_TYPE_ID = lv_task_type_id;
162:
163: BEGIN
164: lv_itemtype := ITEMTYPE;

Line 185: FROM CUG_TSK_TYP_ATTR_MAPS_VL cttamv,

181:
182: -- Process for Each Attribute one by one in the loop by getting the attribute name and value.
183: SELECT cvals.task_type_attr_value, wiav.name, wiav.type
184: INTO lv_task_type_attr_value, lv_task_type_attr_name, lv_task_type_attr_type
185: FROM CUG_TSK_TYP_ATTR_MAPS_VL cttamv,
186: cug_sr_task_attr_vals_vl cvals,
187: WF_ITEM_ATTRIBUTES_VL wiav,
188: CUG_TSK_TYP_ATTR_DEPS_VL cttadv
189: WHERE cttamv.tsk_typ_attr_map_id = cvals.task_type_attr_map_id