APPS.AME_ADMIN_PKG dependencies on WF_ITEMS

Line 3951: wf_items

3947: wf_item_activity_statuses.error_message,
3948: wf_item_activity_statuses.error_stack
3949: from
3950: wf_item_activity_statuses,
3951: wf_items
3952: where
3953: wf_item_activity_statuses.item_type = workflowItemType and
3954: wf_item_activity_statuses.activity_status = 'ERROR' and
3955: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and

Line 3956: wf_item_activity_statuses.item_type = wf_items.item_type and

3952: where
3953: wf_item_activity_statuses.item_type = workflowItemType and
3954: wf_item_activity_statuses.activity_status = 'ERROR' and
3955: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and
3956: wf_item_activity_statuses.item_type = wf_items.item_type and
3957: wf_item_activity_statuses.item_key = wf_items.item_key and
3958: wf_items.end_date is null;
3959: else
3960: open logCursor for

Line 3957: wf_item_activity_statuses.item_key = wf_items.item_key and

3953: wf_item_activity_statuses.item_type = workflowItemType and
3954: wf_item_activity_statuses.activity_status = 'ERROR' and
3955: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and
3956: wf_item_activity_statuses.item_type = wf_items.item_type and
3957: wf_item_activity_statuses.item_key = wf_items.item_key and
3958: wf_items.end_date is null;
3959: else
3960: open logCursor for
3961: select

Line 3958: wf_items.end_date is null;

3954: wf_item_activity_statuses.activity_status = 'ERROR' and
3955: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and
3956: wf_item_activity_statuses.item_type = wf_items.item_type and
3957: wf_item_activity_statuses.item_key = wf_items.item_key and
3958: wf_items.end_date is null;
3959: else
3960: open logCursor for
3961: select
3962: wf_item_activity_statuses.item_key, /* We need to select this column to use the same cursor. */

Line 3968: wf_items

3964: wf_item_activity_statuses.error_message,
3965: wf_item_activity_statuses.error_stack
3966: from
3967: wf_item_activity_statuses,
3968: wf_items
3969: where
3970: wf_item_activity_statuses.item_type = workflowItemType and
3971: wf_item_activity_statuses.item_key = workflowItemKey and
3972: wf_item_activity_statuses.activity_status = 'ERROR' and

Line 3974: wf_item_activity_statuses.item_type = wf_items.item_type and

3970: wf_item_activity_statuses.item_type = workflowItemType and
3971: wf_item_activity_statuses.item_key = workflowItemKey and
3972: wf_item_activity_statuses.activity_status = 'ERROR' and
3973: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and
3974: wf_item_activity_statuses.item_type = wf_items.item_type and
3975: wf_item_activity_statuses.item_key = wf_items.item_key and
3976: wf_items.end_date is null;
3977: end if;
3978: tempIndex := 1;

Line 3975: wf_item_activity_statuses.item_key = wf_items.item_key and

3971: wf_item_activity_statuses.item_key = workflowItemKey and
3972: wf_item_activity_statuses.activity_status = 'ERROR' and
3973: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and
3974: wf_item_activity_statuses.item_type = wf_items.item_type and
3975: wf_item_activity_statuses.item_key = wf_items.item_key and
3976: wf_items.end_date is null;
3977: end if;
3978: tempIndex := 1;
3979: loop

Line 3976: wf_items.end_date is null;

3972: wf_item_activity_statuses.activity_status = 'ERROR' and
3973: wf_item_activity_statuses.error_stack like (wf_core.newline || 'AME_%') and
3974: wf_item_activity_statuses.item_type = wf_items.item_type and
3975: wf_item_activity_statuses.item_key = wf_items.item_key and
3976: wf_items.end_date is null;
3977: end if;
3978: tempIndex := 1;
3979: loop
3980: fetch logCursor into logCursorValues;