APPS.CZ_BOM_SYNCH dependencies on CZ_ITEM_PROPERTY_VALUES

Line 599: FROM cz_properties p, cz_item_property_values v

595: l_attr_id cz_exv_apc_properties.attr_id%TYPE;
596:
597: BEGIN
598: FOR c_prop IN (SELECT name, data_type, property_value, property_num_value , p.src_application_id
599: FROM cz_properties p, cz_item_property_values v
600: WHERE p.deleted_flag = FLAG_NOT_DELETED
601: AND p.orig_sys_ref IS NOT NULL
602: AND v.deleted_flag = FLAG_NOT_DELETED
603: AND v.item_id = tabItemId(j)

Line 616: NOT EXISTS(SELECT NULL FROM cz_item_property_values iv

612: WHERE im.item_id=tabItemId(j) AND
613: im.deleted_flag=FLAG_NOT_DELETED) AND
614: it.deleted_flag=FLAG_NOT_DELETED
615: ) AND
616: NOT EXISTS(SELECT NULL FROM cz_item_property_values iv
617: WHERE iv.property_id=p.property_id AND iv.item_id=tabItemId(j) AND
618: iv.deleted_flag=FLAG_NOT_DELETED) AND
619: p.deleted_flag = FLAG_NOT_DELETED AND
620: p.src_application_id = APC_APPL_ID AND --Bug13829564 checking the data which comes from PIM

Line 1520: UPDATE cz_item_property_values SET

1516: END LOOP;
1517:
1518: debug('Table cz_model_publications updates rolled back');
1519: FOR i IN 1..tabRbItmPropValItemId.count LOOP
1520: UPDATE cz_item_property_values SET
1521: orig_sys_ref = tabRbItmPropValOrigSysRef(i)
1522: WHERE item_id = tabRbItmPropValItemId(i)
1523: and property_id=tabRbItmPropValPropId(i)
1524: and deleted_flag='0';

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

1524: and deleted_flag='0';
1525: COMMIT;
1526: END LOOP;
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)

Line 1759: --Update cz_item_property_values table.

1755: segmentStart := segmentEnd + 1;
1756:
1757: END LOOP;
1758:
1759: --Update cz_item_property_values table.
1760:
1761: localCount := tabCandidateItem.COUNT;
1762: segmentStart := 1;
1763:

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

1760:
1761: localCount := tabCandidateItem.COUNT;
1762: segmentStart := 1;
1763:
1764: debug('Updating cz_item_property_values table, ' || localCount || ' update candidate records, time started: ' || TO_CHAR(SYSDATE,'HH24:MI:SS'));
1765:
1766: WHILE(segmentStart <= localCount)LOOP
1767:
1768: segmentEnd := segmentStart + CommitBlockSize - 1;

Line 1776: FROM cz_item_property_values where item_id = tabCandidateItem(i)

1772: for i IN segmentStart..segmentEnd LOOP
1773:
1774: select ITEM_ID,PROPERTY_ID,ORIG_SYS_REF
1775: BULK COLLECT INTO l_tabRbItmPropValItemId,l_tabRbItmPropValPropId,l_tabRbItmPropValOrigSysRef
1776: FROM cz_item_property_values where item_id = tabCandidateItem(i)
1777: and deleted_flag='0';
1778:
1779: loopCount:=tabRbItmPropValItemId.count;
1780: for j in 1..l_tabRbItmPropValItemId.COUNT

Line 1793: UPDATE cz_item_property_values SET

1789: END LOOP;
1790:
1791: FORALL i IN segmentStart..segmentEnd
1792:
1793: UPDATE cz_item_property_values SET
1794: orig_sys_ref = NVL(itemPropValues_origSysRef(orig_sys_ref),orig_sys_ref)
1795: WHERE item_id = tabCandidateItem(i)
1796: and deleted_flag='0';
1797:

Line 2151: --format of cz_item_property_values.orig_sys_ref: inv_item_id:property_id

2147: v_item_id VARCHAR2(20);
2148: v_org_id VARCHAR2(20);
2149:
2150: BEGIN
2151: --format of cz_item_property_values.orig_sys_ref: inv_item_id:property_id
2152: IF (p_orig_sys_ref IS NOT NULL) THEN
2153: v_inv_id_pos := instr(p_orig_sys_ref, ':',1,1);
2154: v_org_id_pos := instr(p_orig_sys_ref, ':',1,2);
2155: v_item_id := TO_CHAR(component_item_id_map(TO_NUMBER(substr(p_orig_sys_ref, 1, v_inv_id_pos - 1))));