APPS.AP_WEB_EXPENSE_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 3264: UPDATE WF_ITEM_ACTIVITY_STATUSES

3260: -- provide a new interface that will be compatible for both, like us
3261: -- returning a result of 'DEFERED:l_wakeup_time', and they will take care
3262: -- of running the sql statement.
3263:
3264: UPDATE WF_ITEM_ACTIVITY_STATUSES
3265: SET begin_date = l_wakeup_time
3266: WHERE item_type = p_item_type
3267: AND item_key = p_item_key
3268: AND process_activity = p_actid;

Line 3382: UPDATE WF_ITEM_ACTIVITY_STATUSES

3378: -- provide a new interface that will be compatible for both, like us
3379: -- returning a result of 'DEFERED:l_wakeup_time', and they will take care
3380: -- of running the sql statement.
3381: /*
3382: UPDATE WF_ITEM_ACTIVITY_STATUSES
3383: SET begin_date = l_wakeup_time
3384: WHERE item_type = p_item_type
3385: AND item_key = p_item_key
3386: AND process_activity = p_actid;

Line 15086: from wf_item_activity_statuses

15082: --Bug 4425821: Uptake AME parallel approvers
15083: BEGIN
15084: select 'Y'
15085: into l_access_granted
15086: from wf_item_activity_statuses
15087: where item_type = l_item_type
15088: and ((item_key = to_char(p_item_key)) or (item_key like to_char(p_item_key) || '-%'))
15089: and notification_id = p_ntf_id
15090: and rownum = 1;

Line 15094: from wf_item_activity_statuses_h

15090: and rownum = 1;
15091: EXCEPTION WHEN NO_DATA_FOUND THEN
15092: select 'Y'
15093: into l_access_granted
15094: from wf_item_activity_statuses_h
15095: where item_type = l_item_type
15096: and ((item_key = to_char(p_item_key)) or (item_key like to_char(p_item_key) || '-%'))
15097: and notification_id = p_ntf_id
15098: and rownum = 1;

Line 15106: from wf_item_activity_statuses

15102:
15103: BEGIN
15104: select item_key
15105: into l_item_key
15106: from wf_item_activity_statuses
15107: where item_type = l_item_type
15108: and notification_id = p_ntf_id
15109: and rownum = 1;
15110: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 15113: from wf_item_activity_statuses_h

15109: and rownum = 1;
15110: EXCEPTION WHEN NO_DATA_FOUND THEN
15111: select item_key
15112: into l_item_key
15113: from wf_item_activity_statuses_h
15114: where item_type = l_item_type
15115: and notification_id = p_ntf_id
15116: and rownum = 1;
15117: END;

Line 15133: from wf_item_activity_statuses

15129:
15130: BEGIN
15131: select 'Y'
15132: into l_access_granted
15133: from wf_item_activity_statuses
15134: where item_type = l_item_type
15135: and item_key like '%'||to_char(p_item_key)||'%'
15136: and notification_id = p_ntf_id
15137: and rownum = 1;

Line 15141: from wf_item_activity_statuses_h

15137: and rownum = 1;
15138: EXCEPTION WHEN NO_DATA_FOUND THEN
15139: select 'Y'
15140: into l_access_granted
15141: from wf_item_activity_statuses_h
15142: where item_type = l_item_type
15143: and item_key like '%'||to_char(p_item_key)||'%'
15144: and notification_id = p_ntf_id
15145: and rownum = 1;