[Home] [Help]
872: --Bug#2719434: price type of "BULKLOAD" and "CONTRACT" are of both bulkloader
873: -- price type. Verified that there cannot be any extracted price
874: -- of type CONTRACT
875: FORALL i in 1..gRowIds.COUNT
876: INSERT into icx_cat_price_history(rt_item_id, status, price_type, asl_id, supplier_site_id,
877: contract_id, contract_line_id, template_id, template_line_id, mtl_category_id, org_id,
878: active_flag, search_type, unit_price, currency, unit_of_measure, functional_price,
879: supplier_site_code, contract_num, contract_line_num, price_list_id, archived_date,
880: last_update_login, last_updated_by, last_update_date, created_by, creation_date,
1099: -- for ITEM PRICE we clean everything up
1100:
1101: IF (p_batch_type = 'PRICE') THEN
1102: FORALL i in 1..gRowIds.COUNT
1103: INSERT into icx_cat_price_history(rt_item_id, status, price_type, asl_id, supplier_site_id,
1104: contract_id, contract_line_id, template_id, template_line_id, mtl_category_id, org_id,
1105: active_flag, search_type, unit_price, currency, unit_of_measure,
1106: supplier_site_code, contract_num, contract_line_num, price_list_id, archived_date,
1107: last_update_login, last_updated_by, last_update_date, created_by, creation_date,
1158: -- If batch type is ITEM PRICE this means we are deleting the item
1159: -- so we not only delete the lines from item prices we also clean up the history table
1160: IF (p_batch_type = 'ITEM_PRICE') THEN
1161: FORALL i in 1..gRowIds.COUNT
1162: DELETE from icx_cat_price_history
1163: WHERE rt_item_id = gItemIds(i)
1164: AND price_list_id = gPricelistIds(i)
1165: AND org_id = gOrgIds(i)
1166: AND supplier_site_id = gSupplierSiteIds(i)