APPS.AP_WEB_EXPENSE_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 3313: UPDATE WF_ITEM_ACTIVITY_STATUSES

3309: -- provide a new interface that will be compatible for both, like us
3310: -- returning a result of 'DEFERED:l_wakeup_time', and they will take care
3311: -- of running the sql statement.
3312:
3313: UPDATE WF_ITEM_ACTIVITY_STATUSES
3314: SET begin_date = l_wakeup_time
3315: WHERE item_type = p_item_type
3316: AND item_key = p_item_key
3317: AND process_activity = p_actid;

Line 3431: UPDATE WF_ITEM_ACTIVITY_STATUSES

3427: -- provide a new interface that will be compatible for both, like us
3428: -- returning a result of 'DEFERED:l_wakeup_time', and they will take care
3429: -- of running the sql statement.
3430: /*
3431: UPDATE WF_ITEM_ACTIVITY_STATUSES
3432: SET begin_date = l_wakeup_time
3433: WHERE item_type = p_item_type
3434: AND item_key = p_item_key
3435: AND process_activity = p_actid;

Line 16052: from wf_item_activity_statuses

16048: --Bug 4425821: Uptake AME parallel approvers
16049: BEGIN
16050: select 'Y'
16051: into l_access_granted
16052: from wf_item_activity_statuses
16053: where item_type = l_item_type
16054: and ((item_key = to_char(p_item_key)) or (item_key like to_char(p_item_key) || '-%'))
16055: and notification_id = p_ntf_id
16056: and rownum = 1;

Line 16060: from wf_item_activity_statuses_h

16056: and rownum = 1;
16057: EXCEPTION WHEN NO_DATA_FOUND THEN
16058: select 'Y'
16059: into l_access_granted
16060: from wf_item_activity_statuses_h
16061: where item_type = l_item_type
16062: and ((item_key = to_char(p_item_key)) or (item_key like to_char(p_item_key) || '-%'))
16063: and notification_id = p_ntf_id
16064: and rownum = 1;

Line 16072: from wf_item_activity_statuses

16068:
16069: BEGIN
16070: select item_key
16071: into l_item_key
16072: from wf_item_activity_statuses
16073: where item_type = l_item_type
16074: and notification_id = p_ntf_id
16075: and rownum = 1;
16076: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 16079: from wf_item_activity_statuses_h

16075: and rownum = 1;
16076: EXCEPTION WHEN NO_DATA_FOUND THEN
16077: select item_key
16078: into l_item_key
16079: from wf_item_activity_statuses_h
16080: where item_type = l_item_type
16081: and notification_id = p_ntf_id
16082: and rownum = 1;
16083: END;

Line 16099: from wf_item_activity_statuses

16095: -- Modified for CISCO ER 8704387
16096: BEGIN
16097: select 'Y'
16098: into l_access_granted
16099: from wf_item_activity_statuses
16100: where item_type = l_item_type
16101: and ((item_key like '%'||to_char(p_item_key)||'%') or (item_key = l_temp_item_key))
16102: and notification_id = p_ntf_id
16103: and rownum = 1;

Line 16107: from wf_item_activity_statuses_h

16103: and rownum = 1;
16104: EXCEPTION WHEN NO_DATA_FOUND THEN
16105: select 'Y'
16106: into l_access_granted
16107: from wf_item_activity_statuses_h
16108: where item_type = l_item_type
16109: and ((item_key like '%'||to_char(p_item_key)||'%') or (item_key = l_temp_item_key))
16110: and notification_id = p_ntf_id
16111: and rownum = 1;