DBA Data[Home] [Help]

APPS.WF_NOTIFICATION dependencies on WF_ITEM_TYPES

Line 524: WF_ITEM_TYPES IT,

520: select IAS.NOTIFICATION_ID, IAS.ASSIGNED_USER, A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE, nvl(IAS.END_DATE, IAS.BEGIN_DATE) ACT_DATE, IAS.EXECUTION_TIME
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

Line 543: WF_ITEM_TYPES IT,

539: select IAS.NOTIFICATION_ID, IAS.ASSIGNED_USER, A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE, nvl(IAS.END_DATE, IAS.BEGIN_DATE) ACT_DATE, IAS.EXECUTION_TIME
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

Line 9855: l_item_type WF_ITEM_TYPES.NAME%TYPE;

9851: callback varchar2(240);
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