APPS.WF_NOTIFICATION dependencies on WF_ITEMS

Line 530: WF_ITEMS I

526: from WF_ITEM_ACTIVITY_STATUSES IAS,
527: WF_ACTIVITIES A,
528: WF_PROCESS_ACTIVITIES PA,
529: WF_ITEM_TYPES IT,
530: WF_ITEMS I
531: where IAS.ITEM_TYPE = x_item_type
532: and IAS.ITEM_KEY = x_item_key
533: and IAS.PROCESS_ACTIVITY = x_actid
534: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 549: WF_ITEMS I

545: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
546: WF_ACTIVITIES A,
547: WF_PROCESS_ACTIVITIES PA,
548: WF_ITEM_TYPES IT,
549: WF_ITEMS I
550: where IAS.ITEM_TYPE = x_item_type
551: and IAS.ITEM_KEY = x_item_key
552: and IAS.PROCESS_ACTIVITY = x_actid
553: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 749: from WF_ITEMS

745: j := j+1;
746: begin
747: select OWNER_ROLE, BEGIN_DATE
748: into l_owner_role, l_begin_date
749: from WF_ITEMS
750: where ITEM_TYPE = l_itype
751: and ITEM_KEY = l_ikey;
752: exception
753: when OTHERS then

Line 3510: from wf_items wi,

3506: p_recipient in varchar2)
3507: is
3508: cursor c_notifications is
3509: select wi.item_key, wi.user_key, wn.notification_id
3510: from wf_items wi,
3511: wf_item_activity_statuses wias,
3512: wf_notifications wn
3513: where wi.item_key = wias.item_key
3514: and wi.item_type = wias.item_type

Line 7156: from WF_ITEMS

7152:
7153: -- check if this is item owner
7154: begin
7155: select 1 into ans
7156: from WF_ITEMS
7157: where ITEM_TYPE = itype
7158: and ITEM_KEY = ikey
7159: and OWNER_ROLE = IsValidInfoRole.username;
7160:

Line 7897: WF_ITEMS I

7893: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
7894: from WF_ITEM_ACTIVITY_STATUSES IAS,
7895: WF_ACTIVITIES A,
7896: WF_PROCESS_ACTIVITIES PA,
7897: WF_ITEMS I
7898: where IAS.ITEM_TYPE = l_item_type
7899: and IAS.ITEM_KEY = l_item_key
7900: and IAS.PROCESS_ACTIVITY = l_actid
7901: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 7925: WF_ITEMS I

7921: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
7922: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
7923: WF_ACTIVITIES A,
7924: WF_PROCESS_ACTIVITIES PA,
7925: WF_ITEMS I
7926: where IAS.ITEM_TYPE = l_item_type
7927: and IAS.ITEM_KEY = l_item_key
7928: and IAS.PROCESS_ACTIVITY = l_actid
7929: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 9329: WF_ITEMS I

9325: into l_result_type, p_result_code
9326: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
9327: WF_ACTIVITIES A,
9328: WF_PROCESS_ACTIVITIES PA,
9329: WF_ITEMS I
9330: where IAS.NOTIFICATION_ID = p_nid
9331: and IAS.ITEM_TYPE = I.ITEM_TYPE
9332: and IAS.ITEM_KEY = I.ITEM_KEY
9333: and IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID

Line 9345: WF_ITEMS I

9341: into l_result_type, p_result_code
9342: from WF_ITEM_ACTIVITY_STATUSES IAS,
9343: WF_ACTIVITIES A,
9344: WF_PROCESS_ACTIVITIES PA,
9345: WF_ITEMS I
9346: where IAS.NOTIFICATION_ID = p_nid
9347: and IAS.ITEM_TYPE = I.ITEM_TYPE
9348: and IAS.ITEM_KEY = I.ITEM_KEY
9349: and IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID