[Home] [Help]
803: nErrorCount PLS_INTEGER:=0; /*Error index */
804: nInsertCount PLS_INTEGER:=0; /*Inserts */
805: nUpdateCount PLS_INTEGER:=0; /*Updates */
806: nDups PLS_INTEGER:=0; /*Duplicate records */
807: x_usesurr_itemtypeprop PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPE_PROPERTIES',inXFR_GROUP);
808: /*Use surrogates */
809: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
810: /*Use surrogates */
811: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
854: END;
855: /* Check if this is an insert or update */
856: DECLARE
857: CURSOR c_onl_itemtypeprop IS
858: SELECT 'X' FROM CZ_ITEM_TYPE_PROPERTIES
859: WHERE ITEM_TYPE_ID=nOnlItemTypeId AND PROPERTY_ID=nOnlPropertyId;
860: BEGIN
861: OPEN c_onl_itemtypeprop ;
862: FETCH c_onl_itemtypeprop INTO p_onl_itemtypeprop;
930: CLOSE c_imp_itemtypeprop;
931: /* Check if item type's property that's already been imported to CZ
932: has been deleted in APPS */
933: BEGIN
934: UPDATE CZ_ITEM_TYPE_PROPERTIES
935: SET DELETED_FLAG = '1'
936: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE
937: WHERE RUN_ID = inRUN_ID
938: AND DELETED_FLAG = '0')
937: WHERE RUN_ID = inRUN_ID
938: AND DELETED_FLAG = '0')
939: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
940: WHERE RUN_ID = inRUN_ID
941: AND ITEM_TYPE_ID = CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID
942: AND DELETED_FLAG = '0')
943: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES
944: WHERE ORIG_SYS_REF IS NOT NULL
945: AND DELETED_FLAG = '0')
948:
949: UPDATE CZ_ITEM_PROPERTY_VALUES
950: SET DELETED_FLAG = '1'
951: WHERE ITEM_ID IN (SELECT IM.ITEM_ID
952: FROM CZ_ITEM_MASTERS IM, CZ_ITEM_TYPES IT,CZ_ITEM_TYPE_PROPERTIES ITP
953: WHERE IM.ITEM_TYPE_ID = IT.ITEM_TYPE_ID
954: AND IT.ITEM_TYPE_ID = ITP.ITEM_TYPE_ID
955: AND ITP.DELETED_FLAG = '1'
956: AND CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID = ITP.PROPERTY_ID);