APPS.CZ_BOM_SYNCH dependencies on CZ_ITEM_TYPE_PROPERTIES

Line 164: TYPE typePropertyId IS TABLE OF CZ_ITEM_TYPE_PROPERTIES.PROPERTY_ID%TYPE INDEX BY BINARY_INTEGER;

160: TYPE typePubTopItemId IS TABLE OF cz_model_publications.top_item_id%TYPE INDEX BY BINARY_INTEGER;
161: TYPE typePubProductKey IS TABLE OF cz_model_publications.product_key%TYPE INDEX BY BINARY_INTEGER;
162:
163: TYPE typeInventoryItemId IS TABLE OF mtl_system_items.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
164: TYPE typePropertyId IS TABLE OF CZ_ITEM_TYPE_PROPERTIES.PROPERTY_ID%TYPE INDEX BY BINARY_INTEGER;
165:
166: thisVersionString user_source.text%TYPE;
167:
168: nDebug PLS_INTEGER := 1000;

Line 605: SELECT it.property_id FROM cz_item_type_properties it

601: UNION
602: SELECT name, data_type,def_value as property_value,def_num_value as property_num_value,src_application_id
603: FROM cz_properties p
604: WHERE p.property_id IN(
605: SELECT it.property_id FROM cz_item_type_properties it
606: WHERE it.item_type_id IN(SELECT im.item_type_id FROM CZ_ITEM_MASTERS im
607: WHERE im.item_id=tabItemId(j) AND
608: im.deleted_flag=FLAG_NOT_DELETED) AND
609: it.deleted_flag=FLAG_NOT_DELETED

Line 1520: UPDATE CZ_ITEM_TYPE_PROPERTIES SET

1516:
1517: debug('Table cz_item_property_values updates rolled back');
1518:
1519: FOR i IN 1..tabRbItmTypPropItTypeId.count LOOP
1520: UPDATE CZ_ITEM_TYPE_PROPERTIES SET
1521: orig_sys_ref = tabRbItmTypPropOrigSysRef(i)
1522: WHERE item_type_id = tabRbItmTypPropItTypeId(i)
1523: and property_id=tabRbItmTypPropId(i)
1524: and deleted_flag='0';

Line 1528: debug('Table CZ_ITEM_TYPE_PROPERTIES updates rolled back');

1524: and deleted_flag='0';
1525: COMMIT;
1526: END LOOP;
1527:
1528: debug('Table CZ_ITEM_TYPE_PROPERTIES updates rolled back');
1529:
1530: END; --rollback_structure;
1531: ---------------------------------------------------------------------------------------
1532: --build_structure_map->synchronize_structure

Line 1791: --Update CZ_ITEM_TYPE_PROPERTIES table.

1787: COMMIT;
1788: segmentStart := segmentEnd + 1;
1789: END LOOP;
1790:
1791: --Update CZ_ITEM_TYPE_PROPERTIES table.
1792:
1793: localCount := tabCandidateType.COUNT;
1794: segmentStart := 1;
1795:

Line 1796: debug('Updating CZ_ITEM_TYPE_PROPERTIES table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));

1792:
1793: localCount := tabCandidateType.COUNT;
1794: segmentStart := 1;
1795:
1796: debug('Updating CZ_ITEM_TYPE_PROPERTIES table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1797:
1798: WHILE(segmentStart <= localCount)LOOP
1799:
1800: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1807: FROM cz_item_type_properties where item_type_id = tabCandidateType(i)

1803:
1804: for i IN segmentStart..segmentEnd LOOP
1805: select ITEM_TYPE_ID,PROPERTY_ID,ORIG_SYS_REF
1806: BULK COLLECT INTO l_tabRbItmTypPropItTypeId,l_tabRbItmTypPropId,l_tabRbItmTypPropOrigSysRef
1807: FROM cz_item_type_properties where item_type_id = tabCandidateType(i)
1808: and deleted_flag='0';
1809:
1810: loopCount:=tabRbItmTypPropItTypeId.count;
1811: for j in 1..l_tabRbItmTypPropItTypeId.COUNT

Line 1823: UPDATE CZ_ITEM_TYPE_PROPERTIES SET

1819: END LOOP;
1820: END LOOP;
1821:
1822: FORALL i IN segmentStart..segmentEnd
1823: UPDATE CZ_ITEM_TYPE_PROPERTIES SET
1824: orig_sys_ref = NVL(itemTypeProp_origSysRef(orig_sys_ref),orig_sys_ref)
1825: WHERE item_type_id = tabCandidateType(i)
1826: and deleted_flag='0';
1827:

Line 2159: --format of CZ_ITEM_TYPE_PROPERTIES.orig_sys_ref: catalog_group_id:..

2155: v_inv_id_pos INTEGER;
2156: v_catalog_grp_id VARCHAR2(20);
2157:
2158: BEGIN
2159: --format of CZ_ITEM_TYPE_PROPERTIES.orig_sys_ref: catalog_group_id:..
2160: IF (p_orig_sys_ref IS NOT NULL) THEN
2161: v_inv_id_pos := instr(p_orig_sys_ref, ':',1,1);
2162: v_catalog_grp_id := TO_CHAR(catalog_group_id_map(TO_NUMBER(substr(p_orig_sys_ref, 1, v_inv_id_pos - 1))));
2163: RETURN (v_catalog_grp_id ||substr(p_orig_sys_ref,v_inv_id_pos));