APPS.ENI_ITEMS_STAR_PKG dependencies on ENI_ITEM_STAR_TEMP

Line 482: select 1 into l_exist_flag from eni_item_star_temp

478:
479: begin
480:
481: -- BIS_COLLECTION_UTILITIES.log(' Checking Temp table for any records ');
482: select 1 into l_exist_flag from eni_item_star_temp
483: where rownum = 1;
484:
485: if l_exist_flag = 1 then
486: -- BIS_COLLECTION_UTILITIES.log('Updating STAR table with records from temp table');

Line 527: FROM eni_item_star_temp

523: , nvl(unit_volume, a.unit_volume)
524: , nvl(weight_uom_code, a.weight_uom_code)
525: , nvl(volume_uom_code, a.volume_uom_code)
526: , nvl(eam_item_type, a.eam_item_type)
527: FROM eni_item_star_temp
528: WHERE a.inventory_item_id = inventory_item_id
529: AND a.organization_id = organization_id )
530: WHERE EXISTS( SELECT 'X' from eni_item_star_temp
531: WHERE a.inventory_item_id = inventory_item_id

Line 530: WHERE EXISTS( SELECT 'X' from eni_item_star_temp

526: , nvl(eam_item_type, a.eam_item_type)
527: FROM eni_item_star_temp
528: WHERE a.inventory_item_id = inventory_item_id
529: AND a.organization_id = organization_id )
530: WHERE EXISTS( SELECT 'X' from eni_item_star_temp
531: WHERE a.inventory_item_id = inventory_item_id
532: AND a.organization_id = organization_id );
533:
534: -- BIS_COLLECTION_UTILITIES.log('Rows updated from temp table:'||sql%rowcount);

Line 537: DELETE FROM eni_item_star_temp;

533:
534: -- BIS_COLLECTION_UTILITIES.log('Rows updated from temp table:'||sql%rowcount);
535:
536: -- BIS_COLLECTION_UTILITIES.log('Deleting from the temp table');
537: DELETE FROM eni_item_star_temp;
538:
539: END IF;
540:
541: EXCEPTION

Line 1001: UPDATE eni_item_star_temp

997: -- TEMP table. To avoid duplicacy there is a insert and an
998: -- update.
999:
1000: IF sql%rowcount = 0 THEN
1001: UPDATE eni_item_star_temp
1002: SET VALUE = c_items_in_master_rec.value
1003: , LAST_UPDATE_DATE = c_items_in_master_rec.last_update_date
1004: WHERE inventory_item_id = p_inventory_item_id
1005: AND organization_id = c_items_in_master_rec.organization_id;

Line 1009: INSERT INTO eni_item_star_temp( inventory_item_id

1005: AND organization_id = c_items_in_master_rec.organization_id;
1006:
1007: IF sql%rowcount = 0 THEN
1008:
1009: INSERT INTO eni_item_star_temp( inventory_item_id
1010: , organization_id
1011: , value
1012: , last_update_date
1013: , item_catalog_group_id

Line 1172: UPDATE eni_item_star_temp

1168: -- is running. This would create duplicate records in the
1169: -- TEMP table. To avoid duplicacy there is a insert and an update.
1170:
1171: IF sql%rowcount = 0 THEN
1172: UPDATE eni_item_star_temp
1173: SET VALUE = DECODE(TO_CHAR(G_INSTALL_PHASE),'0',l_item_number,c_items_in_master_rec.value)
1174: , LAST_UPDATE_DATE = c_items_in_master_rec.last_update_date
1175: , ITEM_CATALOG_GROUP_ID = c_items_in_master_rec.item_catalog_group_id
1176: , PRIMARY_UOM_CODE = c_items_in_master_rec.primary_uom_code

Line 1186: INSERT INTO eni_item_star_temp(

1182: WHERE inventory_item_id = p_inventory_item_id
1183: AND organization_id = c_items_in_master_rec.organization_id;
1184:
1185: IF sql%rowcount = 0 THEN
1186: INSERT INTO eni_item_star_temp(
1187: inventory_item_id
1188: , organization_id
1189: , value
1190: , last_update_date

Line 1240: UPDATE eni_item_star_temp

1236: -- is running. This would create duplicate records in the
1237: -- TEMP table. To avoid duplicacy there is a insert and an update.
1238:
1239: IF sql%rowcount = 0 THEN
1240: UPDATE eni_item_star_temp
1241: SET UNIT_WEIGHT = c_items_in_child_rec.unit_weight
1242: , UNIT_VOLUME = c_items_in_child_rec.unit_volume
1243: , WEIGHT_UOM_CODE = c_items_in_child_rec.weight_uom_code
1244: , VOLUME_UOM_CODE = c_items_in_child_rec.volume_uom_code

Line 1252: INSERT INTO eni_item_star_temp(

1248: WHERE inventory_item_id = p_inventory_item_id
1249: AND organization_id = c_items_in_child_rec.organization_id;
1250:
1251: IF sql%rowcount = 0 THEN
1252: INSERT INTO eni_item_star_temp(
1253: inventory_item_id
1254: , organization_id
1255: , last_update_date
1256: , unit_weight

Line 1503: UPDATE ENI_ITEM_STAR_TEMP

1499: if Sql%Rowcount = 0 then
1500:
1501: -- dbms_output.put_line('before update temp....');
1502:
1503: UPDATE ENI_ITEM_STAR_TEMP
1504: set inv_category_set_id = sync_c1.inv_category_set_id,
1505: inv_category_id = sync_c1.inv_category_id,
1506: inv_concat_seg = sync_c1.inv_concat_seg,
1507: vbh_category_set_id = sync_c1.vbh_category_set_id,

Line 1519: INSERT into ENI_ITEM_STAR_TEMP

1515:
1516: -- dbms_output.put_line('After update temp..'||to_char(sql%rowcount));
1517:
1518: if sql%rowcount = 0 then
1519: INSERT into ENI_ITEM_STAR_TEMP
1520: (inventory_item_id,
1521: organization_id,
1522: inv_category_set_id,
1523: inv_category_id,