[Home] [Help]
138:
139: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
140: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
141:
142: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
144: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
145:
146: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
139: TYPE typeRefPartNbr IS TABLE OF cz_item_masters.ref_part_nbr%TYPE INDEX BY BINARY_INTEGER;
140: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
141:
142: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
144: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
145:
146: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
140: TYPE typeItemOrigSysRef IS TABLE OF cz_item_masters.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
141:
142: TYPE typeItemTypeId IS TABLE OF cz_item_types.item_type_id%TYPE INDEX BY BINARY_INTEGER;
143: TYPE typeItemTypeName IS TABLE OF cz_item_types.name%TYPE INDEX BY BINARY_INTEGER;
144: TYPE typeTypeOrigSysRef IS TABLE OF cz_item_types.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
145:
146: TYPE typeIntlTextId IS TABLE OF cz_localized_texts.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
147: TYPE typeTextOrigSysRef IS TABLE OF cz_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
148:
722:
723: PROCEDURE hash_catalog_group(j IN PLS_INTEGER) IS
724:
725: catalogId PLS_INTEGER := hashItemTypeId(tabItemMasterTypeId(j));
726: typeName cz_item_types.name%TYPE := hashItemTypeName(tabItemMasterTypeId(j));
727: BEGIN
728:
729: IF(itemCatalogGroupId IS NULL)THEN
730:
1474:
1475: debug('Table cz_localized_texts updates rolled back');
1476:
1477: FOR i IN 1..typeRollback LOOP
1478: UPDATE cz_item_types SET
1479: orig_sys_ref = hashRbTypeOrigSysRef(tabCandidateType(i))
1480: WHERE item_type_id = tabCandidateType(i);
1481: COMMIT;
1482: END LOOP;
1480: WHERE item_type_id = tabCandidateType(i);
1481: COMMIT;
1482: END LOOP;
1483:
1484: debug('Table cz_item_types updates rolled back');
1485:
1486: FOR i IN 1..projRollback LOOP
1487: UPDATE cz_xfr_project_bills SET
1488: organization_id = hashRbOrganizationId(tabCandidateProj(i)),
1670: segmentStart := segmentEnd + 1;
1671:
1672: END LOOP;
1673:
1674: --Update cz_item_types table.
1675:
1676: localCount := tabCandidateType.COUNT;
1677: segmentStart := 1;
1678:
1675:
1676: localCount := tabCandidateType.COUNT;
1677: segmentStart := 1;
1678:
1679: debug('Updating cz_item_types table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1680:
1681: WHILE(segmentStart <= localCount)LOOP
1682:
1683: segmentEnd := segmentStart + textCommitBlockSize - 1;
1684: IF(segmentEnd > localCount)THEN segmentEnd := localCount; END IF;
1685: typeRollback := segmentEnd;
1686:
1687: FORALL i IN segmentStart..segmentEnd
1688: UPDATE cz_item_types SET
1689: orig_sys_ref = NVL(itemtype_origSysRef(orig_sys_ref), orig_sys_ref)
1690: WHERE item_type_id = tabCandidateType(i);
1691:
1692: COMMIT;
1932: BEGIN
1933:
1934: SELECT item_type_id, name, orig_sys_ref
1935: BULK COLLECT INTO tabItemTypeId, tabItemTypeName, tabItemTypeOrigSysRef
1936: FROM cz_item_types
1937: WHERE deleted_flag = FLAG_NOT_DELETED
1938: AND orig_sys_ref IS NOT NULL
1939: AND REPLACE(TRANSLATE(orig_sys_ref, '0123456789', '0000000000'), '0', NULL) IS NULL;
1940: