APPS.ICX_ITEM_DIAG_PVT dependencies on PO_HEADERS_ALL

Line 1907: update po_headers_all set last_update_date = sysdate

1903: end if;
1904: if p_source_type = 'BLANKET' then
1905: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,p_source_type);
1906:
1907: update po_headers_all set last_update_date = sysdate
1908: where po_header_id in ( select distinct pol.po_header_id from po_attribute_values_tlp po , icx_cat_items_ctx_hdrs_tlp ctx, po_lines_all pol
1909: where po.po_line_id=ctx.po_line_id
1910: and po.po_line_id=pol.po_line_id
1911: and ctx.source_type in ('BLANKET','QUOTATION','GLOBAL_BLANKET')

Line 1916: select min(rowid), max(rowid) into l_min_row_id,l_max_row_id from po_headers_all;

1912: and (po.ip_category_id <> ctx.ip_category_id or pol.unit_price <> ctx.unit_price)
1913: );
1914: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting BPA count='||Sql%ROWCOUNT);
1915:
1916: select min(rowid), max(rowid) into l_min_row_id,l_max_row_id from po_headers_all;
1917: ICX_CAT_POPULATE_PODOCS_PVT.upgradeR12PODocs(sysdate-1,l_min_row_id,l_max_row_id);
1918: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'extracting done for bpa ');
1919:
1920: end if;