APPS.ENI_ITEMS_STAR_PKG dependencies on ENI_ITEM_STAR_VALID_ERR

Line 157: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ENI_ITEM_STAR_VALID_ERR';

153: BIS_COLLECTION_UTILITIES.log(' Product functional area ==> ' || to_char(l_vbh_category_set));
154: BIS_COLLECTION_UTILITIES.log(' Inventory functional area ==> ' || to_char(l_inv_category_set));
155: BIS_COLLECTION_UTILITIES.log(' Purchasing functional area ==> ' || to_char(l_po_category_set));
156:
157: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.ENI_ITEM_STAR_VALID_ERR';
158:
159: BIS_COLLECTION_UTILITIES.log('');
160: BIS_COLLECTION_UTILITIES.log('Validation Checks');
161: BIS_COLLECTION_UTILITIES.log('----------------------');

Line 179: INSERT INTO ENI_ITEM_STAR_VALID_ERR(

175:
176: BIS_COLLECTION_UTILITIES.log(c2.concatenated_segments);
177: retcode := 1;
178:
179: INSERT INTO ENI_ITEM_STAR_VALID_ERR(
180: inventory_item_id,
181: organization_id,
182: item_name,
183: category_set_id,

Line 239: INSERT INTO ENI_ITEM_STAR_VALID_ERR(

235: retcode := 1;
236:
237: FOR c5 in c_item_id(c4.concatenated_segments) LOOP
238:
239: INSERT INTO ENI_ITEM_STAR_VALID_ERR(
240: inventory_item_id,
241: organization_id,
242: item_name,
243: error_message)

Line 444: AND NOT EXISTS(select 'X' from eni_item_star_valid_err

440: AND mic2.organization_id(+) = mti.organization_id
441: AND mic2.inventory_item_id(+) = mti.inventory_item_id
442: AND mic2.category_id = kfv2.category_id (+)
443: and mic2.category_set_id(+) = l_po_category_set
444: AND NOT EXISTS(select 'X' from eni_item_star_valid_err
445: WHERE inventory_item_id = mti.inventory_item_id
446: AND organization_id = mti.organization_id);
447:
448: l_rows_inserted := sql%rowcount;

Line 624: NOT EXISTS(SELECT 'X' FROM eni_item_star_valid_err err

620: mic2.category_set_id(+) = l_po_category_set AND
621: NOT EXISTS(SELECT 'X' FROM eni_oltp_item_star eni
622: WHERE mti.inventory_item_id = eni.inventory_item_id
623: AND mti.organization_id = eni.organization_id) AND
624: NOT EXISTS(SELECT 'X' FROM eni_item_star_valid_err err
625: WHERE mti.inventory_item_id = err.inventory_item_id
626: AND mti.organization_id = err.organization_id
627: );
628: