743: l_org_id_tbl PO_TBL_NUMBER;
744: l_item_id_tbl PO_TBL_NUMBER;
745:
746: -- flag to indicate whether item exists in some orgs
747: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
748: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
749: l_exist_in_inv_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
750:
751: -- hashtable on item number
744: l_item_id_tbl PO_TBL_NUMBER;
745:
746: -- flag to indicate whether item exists in some orgs
747: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
748: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
749: l_exist_in_inv_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
750:
751: -- hashtable on item number
752: TYPE item_ref_type IS TABLE OF NUMBER INDEX BY VARCHAR2(1000);
745:
746: -- flag to indicate whether item exists in some orgs
747: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
748: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
749: l_exist_in_inv_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
750:
751: -- hashtable on item number
752: TYPE item_ref_type IS TABLE OF NUMBER INDEX BY VARCHAR2(1000);
753: l_item_ref_tbl item_ref_type;
985: -- rows that return errors when creating items
986: l_error_index_tbl DBMS_SQL.NUMBER_TABLE;
987: l_table_name_tbl PO_TBL_VARCHAR30;
988: l_message_name_tbl PO_TBL_VARCHAR30;
989: l_column_name_tbl PO_TBL_VARCHAR100;
990: BEGIN
991: d_position := 0;
992:
993: IF (PO_LOG.d_proc) THEN