APPS.ENI_ITEMS_STAR_PKG dependencies on ENI_ITEM_STAR_VALID_ERR

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

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

Line 182: INSERT INTO ENI_ITEM_STAR_VALID_ERR(

178:
179: -- BIS_COLLECTION_UTILITIES.log(c2.concatenated_segments);
180: retcode := 1;
181:
182: INSERT INTO ENI_ITEM_STAR_VALID_ERR(
183: inventory_item_id,
184: organization_id,
185: item_name,
186: category_set_id,

Line 243: INSERT INTO ENI_ITEM_STAR_VALID_ERR(

239: retcode := 1;
240:
241: FOR c5 in c_item_id(c4.concatenated_segments) LOOP
242:
243: INSERT INTO ENI_ITEM_STAR_VALID_ERR(
244: inventory_item_id,
245: organization_id,
246: item_name,
247: error_message)

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

449: AND mic2.organization_id(+) = mti.organization_id
450: AND mic2.inventory_item_id(+) = mti.inventory_item_id
451: AND mic2.category_id = kfv2.category_id (+)
452: and mic2.category_set_id(+) = l_po_category_set
453: AND NOT EXISTS(select 'X' from eni_item_star_valid_err
454: WHERE inventory_item_id = mti.inventory_item_id
455: AND organization_id = mti.organization_id);
456:
457: l_rows_inserted := sql%rowcount;

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

629: mic2.category_set_id(+) = l_po_category_set AND
630: NOT EXISTS(SELECT 'X' FROM eni_oltp_item_star eni
631: WHERE mti.inventory_item_id = eni.inventory_item_id
632: AND mti.organization_id = eni.organization_id) AND
633: NOT EXISTS(SELECT 'X' FROM eni_item_star_valid_err err
634: WHERE mti.inventory_item_id = err.inventory_item_id
635: AND mti.organization_id = err.organization_id
636: );
637: