141:
142: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
144:
145: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
149: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
142: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
144:
145: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
149: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
150: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
144:
145: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
146: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
149: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
150: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
151: TYPE typeTextOrigSysRef_vc2 IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY VARCHAR2(15); --Bug9941274
733:
734: PROCEDURE hash_catalog_group(j IN PLS_INTEGER) IS
735:
736: catalogId PLS_INTEGER := hashItemTypeId(tabItemMasterTypeId(j));
737: typeName cz_item_types.name%TYPE := hashItemTypeName(tabItemMasterTypeId(j));
738: BEGIN
739:
740: IF(itemCatalogGroupId IS NULL)THEN
741:
1485:
1486: debug('Table cz_localized_texts updates rolled back');
1487:
1488: FOR i IN 1..typeRollback LOOP
1489: UPDATE cz_item_types SET
1490: orig_sys_ref = hashRbTypeOrigSysRef(tabCandidateType(i))
1491: WHERE item_type_id = tabCandidateType(i);
1492: COMMIT;
1493: END LOOP;
1491: WHERE item_type_id = tabCandidateType(i);
1492: COMMIT;
1493: END LOOP;
1494:
1495: debug('Table cz_item_types updates rolled back');
1496:
1497: FOR i IN 1..projRollback LOOP
1498: UPDATE cz_xfr_project_bills SET
1499: organization_id = hashRbOrganizationId(tabCandidateProj(i)),
1681: segmentStart := segmentEnd + 1;
1682:
1683: END LOOP;
1684:
1685: --Update cz_item_types table.
1686:
1687: localCount := tabCandidateType.COUNT;
1688: segmentStart := 1;
1689:
1686:
1687: localCount := tabCandidateType.COUNT;
1688: segmentStart := 1;
1689:
1690: debug('Updating cz_item_types table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1691:
1692: WHILE(segmentStart <= localCount)LOOP
1693:
1694: segmentEnd := segmentStart + textCommitBlockSize - 1;
1695: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1696: typeRollback := segmentEnd;
1697:
1698: FORALL i IN segmentStart..segmentEnd
1699: UPDATE cz_item_types SET
1700: orig_sys_ref = NVL(itemtype_origSysRef(orig_sys_ref), orig_sys_ref)
1701: WHERE item_type_id = tabCandidateType(i);
1702:
1703: COMMIT;
1943: BEGIN
1944:
1945: SELECT item_type_id, name, orig_sys_ref
1946: BULK COLLECT INTO tabItemTypeId, tabItemTypeName, tabItemTypeOrigSysRef
1947: FROM cz_item_types
1948: WHERE deleted_flag = FLAG_NOT_DELETED
1949: AND orig_sys_ref IS NOT NULL
1950: AND REPLACE(TRANSLATE(orig_sys_ref, '0123456789', '0000000000'), '0', NULL) IS NULL;
1951: