APPS.AP_WEB_ARCHIVE_PURGE_ER dependencies on WF_ITEMS

Line 1437: l_end_date wf_items.end_date%TYPE;

1433: l_report_line_id ap_expense_report_lines_arc.report_line_id%TYPE;
1434: l_childItemKeySeq NUMBER;
1435: l_wf_active BOOLEAN := FALSE;
1436: l_wf_exist BOOLEAN := FALSE;
1437: l_end_date wf_items.end_date%TYPE;
1438: l_child_item_key varchar2(2000);
1439:
1440: BEGIN
1441: -- The where clause in all the delete sqls below make sure that only the records

Line 1628: from wf_items

1624:
1625: begin
1626: select end_date
1627: into l_end_date
1628: from wf_items
1629: where item_type = 'APEXP'
1630: and item_key = to_char(l_report_header_id);
1631: if l_end_date is NULL then
1632: l_wf_active := TRUE;

Line 1676: from wf_items

1672: l_child_item_key := to_char(l_report_header_id) || '-' || to_char(i);
1673: begin
1674: select end_date
1675: into l_end_date
1676: from wf_items
1677: where item_type = 'APEXP'
1678: and item_key = l_child_item_key;
1679: if l_end_date is NULL then
1680: l_wf_active := TRUE;