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.WF_NOTIFICATION dependencies on WF_ITEMS

Line 525: WF_ITEMS I

521: from WF_ITEM_ACTIVITY_STATUSES IAS,
522: WF_ACTIVITIES A,
523: WF_PROCESS_ACTIVITIES PA,
524: WF_ITEM_TYPES IT,
525: WF_ITEMS I
526: where IAS.ITEM_TYPE = x_item_type
527: and IAS.ITEM_KEY = x_item_key
528: and IAS.PROCESS_ACTIVITY = x_actid
529: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 544: WF_ITEMS I

540: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
541: WF_ACTIVITIES A,
542: WF_PROCESS_ACTIVITIES PA,
543: WF_ITEM_TYPES IT,
544: WF_ITEMS I
545: where IAS.ITEM_TYPE = x_item_type
546: and IAS.ITEM_KEY = x_item_key
547: and IAS.PROCESS_ACTIVITY = x_actid
548: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 744: from WF_ITEMS

740: j := j+1;
741: begin
742: select OWNER_ROLE, BEGIN_DATE
743: into l_owner_role, l_begin_date
744: from WF_ITEMS
745: where ITEM_TYPE = l_itype
746: and ITEM_KEY = l_ikey;
747: exception
748: when OTHERS then

Line 3191: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

3187: errmsg varchar2(4000);
3188: dummy varchar2(4000);
3189: l_hide_reassign varchar(1);
3190: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3191: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
3192: l_act_id number;
3193: l_wf_owner WF_ITEMS.OWNER_ROLE%TYPE;
3194: l_from_role WF_NOTIFICATIONS.FROM_ROLE%TYPE;
3195:

Line 3193: l_wf_owner WF_ITEMS.OWNER_ROLE%TYPE;

3189: l_hide_reassign varchar(1);
3190: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3191: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
3192: l_act_id number;
3193: l_wf_owner WF_ITEMS.OWNER_ROLE%TYPE;
3194: l_from_role WF_NOTIFICATIONS.FROM_ROLE%TYPE;
3195:
3196: cursor rulecurs is
3197: select WRR.RULE_ID, WRR.ACTION, WRR.ACTION_ARGUMENT, WRR.RULE_COMMENT

Line 3292: from WF_ITEMS

3288: itemtype => msgtype,
3289: itemkey => l_item_key,
3290: actid => l_act_id);
3291: select OWNER_ROLE into l_wf_owner
3292: from WF_ITEMS
3293: where ITEM_TYPE=msgtype
3294: and ITEM_KEY=l_item_key;
3295: l_from_role := Wf_Notification.GetAttrText(nid => Route.nid,
3296: aname=>'#FROM_ROLE',

Line 3624: from wf_items wi,

3620: p_recipient in varchar2)
3621: is
3622: cursor c_notifications is
3623: select wi.item_key, wi.user_key, wn.notification_id
3624: from wf_items wi,
3625: wf_item_activity_statuses wias,
3626: wf_notifications wn
3627: where wi.item_key = wias.item_key
3628: and wi.item_type = wias.item_type

Line 4298: l_item_type WF_ITEMS.ITEM_TYPE%TYPE;

4294: dvalue date;
4295:
4296: --ER 2714169 variables
4297: l_act_id number;
4298: l_item_type WF_ITEMS.ITEM_TYPE%TYPE;
4299: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4300: l_wf_owner WF_LOCAL_ROLES.NAME%TYPE;
4301: hash_from_role WF_LOCAL_ROLES.NAME%TYPE;
4302:

Line 4299: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

4295:
4296: --ER 2714169 variables
4297: l_act_id number;
4298: l_item_type WF_ITEMS.ITEM_TYPE%TYPE;
4299: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
4300: l_wf_owner WF_LOCAL_ROLES.NAME%TYPE;
4301: hash_from_role WF_LOCAL_ROLES.NAME%TYPE;
4302:
4303:

Line 4458: from WF_ITEMS

4454: hash_from_role := Wf_Notification.GetAttrText(nid => ForwardInternal.nid,
4455: aname=>'#FROM_ROLE',
4456: ignore_notfound=>TRUE);
4457: select OWNER_ROLE into l_wf_owner
4458: from WF_ITEMS
4459: where ITEM_TYPE=l_item_type
4460: and ITEM_KEY=l_item_key;
4461:
4462: if new_role in (l_wf_owner, hash_from_role) then

Line 7318: from WF_ITEMS

7314:
7315: -- check if this is item owner
7316: begin
7317: select 1 into ans
7318: from WF_ITEMS
7319: where ITEM_TYPE = itype
7320: and ITEM_KEY = ikey
7321: and OWNER_ROLE = IsValidInfoRole.username;
7322:

Line 8123: WF_ITEMS I

8119: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
8120: from WF_ITEM_ACTIVITY_STATUSES IAS,
8121: WF_ACTIVITIES A,
8122: WF_PROCESS_ACTIVITIES PA,
8123: WF_ITEMS I
8124: where IAS.ITEM_TYPE = l_item_type
8125: and IAS.ITEM_KEY = l_item_key
8126: and IAS.PROCESS_ACTIVITY = l_actid
8127: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 8151: WF_ITEMS I

8147: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
8148: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
8149: WF_ACTIVITIES A,
8150: WF_PROCESS_ACTIVITIES PA,
8151: WF_ITEMS I
8152: where IAS.ITEM_TYPE = l_item_type
8153: and IAS.ITEM_KEY = l_item_key
8154: and IAS.PROCESS_ACTIVITY = l_actid
8155: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 9577: WF_ITEMS I

9573: into l_result_type, p_result_code
9574: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
9575: WF_ACTIVITIES A,
9576: WF_PROCESS_ACTIVITIES PA,
9577: WF_ITEMS I
9578: where IAS.NOTIFICATION_ID = p_nid
9579: and IAS.ITEM_TYPE = I.ITEM_TYPE
9580: and IAS.ITEM_KEY = I.ITEM_KEY
9581: and IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 9593: WF_ITEMS I

9589: into l_result_type, p_result_code
9590: from WF_ITEM_ACTIVITY_STATUSES IAS,
9591: WF_ACTIVITIES A,
9592: WF_PROCESS_ACTIVITIES PA,
9593: WF_ITEMS I
9594: where IAS.NOTIFICATION_ID = p_nid
9595: and IAS.ITEM_TYPE = I.ITEM_TYPE
9596: and IAS.ITEM_KEY = I.ITEM_KEY
9597: and IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 9856: l_item_key WF_ITEMS.ITEM_KEY%TYPE;

9852: context varchar2(2000);
9853: status varchar2(8);
9854: newcomment varchar2(4000);
9855: l_item_type WF_ITEM_TYPES.NAME%TYPE;
9856: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
9857: l_act_id number;
9858:
9859: -- Dynamic sql stuff
9860: sqlbuf varchar2(2000);