[Home] [Help]
699: nErrorCount PLS_INTEGER:=0; /*Error index */
700: nInsertCount PLS_INTEGER:=0; /*Inserts */
701: nUpdateCount PLS_INTEGER:=0; /*Updates */
702: nDups PLS_INTEGER:=0; /*Duplicate records */
703: x_usesurr_itemtypeprop PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPE_PROPERTIES',inXFR_GROUP);
704: /*Use surrogates */
705: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
706: /*Use surrogates */
707: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
750: END;
751: /* Check if this is an insert or update */
752: DECLARE
753: CURSOR c_onl_itemtypeprop IS
754: SELECT 'X' FROM CZ_ITEM_TYPE_PROPERTIES
755: WHERE ITEM_TYPE_ID=nOnlItemTypeId AND PROPERTY_ID=nOnlPropertyId;
756: BEGIN
757: OPEN c_onl_itemtypeprop ;
758: FETCH c_onl_itemtypeprop INTO p_onl_itemtypeprop;
826: CLOSE c_imp_itemtypeprop;
827: /* Check if item type's property that's already been imported to CZ
828: has been deleted in APPS */
829: BEGIN
830: UPDATE CZ_ITEM_TYPE_PROPERTIES
831: SET DELETED_FLAG = '1'
832: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE
833: WHERE RUN_ID = inRUN_ID
834: AND DELETED_FLAG = '0')
833: WHERE RUN_ID = inRUN_ID
834: AND DELETED_FLAG = '0')
835: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
836: WHERE RUN_ID = inRUN_ID
837: AND ITEM_TYPE_ID = CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID
838: AND DELETED_FLAG = '0')
839: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES
840: WHERE ORIG_SYS_REF IS NOT NULL
841: AND DELETED_FLAG = '0')
844:
845: UPDATE CZ_ITEM_PROPERTY_VALUES
846: SET DELETED_FLAG = '1'
847: WHERE ITEM_ID IN (SELECT IM.ITEM_ID
848: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP
849: WHERE IM.ITEM_TYPE_ID = IT.ITEM_TYPE_ID
850: AND IT.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
851: AND ITP.DELETED_FLAG = '1'
852: AND CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID = ITP.PROPERTY_ID);