APPS.CZ_BOM_SYNCH dependencies on CZ_ITEM_TYPE_PROPERTIES

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

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

Line 610: SELECT it.property_id FROM cz_item_type_properties it

606: UNION
607: SELECT name, data_type,def_value as property_value,def_num_value as property_num_value,src_application_id
608: FROM cz_properties p
609: WHERE p.property_id IN(
610: SELECT it.property_id FROM cz_item_type_properties it
611: WHERE it.item_type_id IN(SELECT im.item_type_id FROM CZ_ITEM_MASTERS im
612: WHERE im.item_id=tabItemId(j) AND
613: im.deleted_flag=FLAG_NOT_DELETED) AND
614: it.deleted_flag=FLAG_NOT_DELETED

Line 1531: UPDATE CZ_ITEM_TYPE_PROPERTIES SET

1527:
1528: debug('Table cz_item_property_values updates rolled back');
1529:
1530: FOR i IN 1..tabRbItmTypPropItTypeId.count LOOP
1531: UPDATE CZ_ITEM_TYPE_PROPERTIES SET
1532: orig_sys_ref = tabRbItmTypPropOrigSysRef(i)
1533: WHERE item_type_id = tabRbItmTypPropItTypeId(i)
1534: and property_id=tabRbItmTypPropId(i)
1535: and deleted_flag='0';

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

1535: and deleted_flag='0';
1536: COMMIT;
1537: END LOOP;
1538:
1539: debug('Table CZ_ITEM_TYPE_PROPERTIES updates rolled back');
1540:
1541: END; --rollback_structure;
1542: ---------------------------------------------------------------------------------------
1543: --build_structure_map->synchronize_structure

Line 1802: --Update CZ_ITEM_TYPE_PROPERTIES table.

1798: COMMIT;
1799: segmentStart := segmentEnd + 1;
1800: END LOOP;
1801:
1802: --Update CZ_ITEM_TYPE_PROPERTIES table.
1803:
1804: localCount := tabCandidateType.COUNT;
1805: segmentStart := 1;
1806:

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

1803:
1804: localCount := tabCandidateType.COUNT;
1805: segmentStart := 1;
1806:
1807: debug('Updating CZ_ITEM_TYPE_PROPERTIES table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1808:
1809: WHILE(segmentStart <= localCount)LOOP
1810:
1811: segmentEnd := segmentStart + CommitBlockSize - 1;

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

1814:
1815: for i IN segmentStart..segmentEnd LOOP
1816: select ITEM_TYPE_ID,PROPERTY_ID,ORIG_SYS_REF
1817: BULK COLLECT INTO l_tabRbItmTypPropItTypeId,l_tabRbItmTypPropId,l_tabRbItmTypPropOrigSysRef
1818: FROM cz_item_type_properties where item_type_id = tabCandidateType(i)
1819: and deleted_flag='0';
1820:
1821: loopCount:=tabRbItmTypPropItTypeId.count;
1822: for j in 1..l_tabRbItmTypPropItTypeId.COUNT

Line 1834: UPDATE CZ_ITEM_TYPE_PROPERTIES SET

1830: END LOOP;
1831: END LOOP;
1832:
1833: FORALL i IN segmentStart..segmentEnd
1834: UPDATE CZ_ITEM_TYPE_PROPERTIES SET
1835: orig_sys_ref = NVL(itemTypeProp_origSysRef(orig_sys_ref),orig_sys_ref)
1836: WHERE item_type_id = tabCandidateType(i)
1837: and deleted_flag='0';
1838:

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

2166: v_inv_id_pos INTEGER;
2167: v_catalog_grp_id VARCHAR2(20);
2168:
2169: BEGIN
2170: --format of CZ_ITEM_TYPE_PROPERTIES.orig_sys_ref: catalog_group_id:..
2171: IF (p_orig_sys_ref IS NOT NULL) THEN
2172: v_inv_id_pos := instr(p_orig_sys_ref, ':',1,1);
2173: v_catalog_grp_id := TO_CHAR(catalog_group_id_map(TO_NUMBER(substr(p_orig_sys_ref, 1, v_inv_id_pos - 1))));
2174: RETURN (v_catalog_grp_id ||substr(p_orig_sys_ref,v_inv_id_pos));