36: nInsertCount PLS_INTEGER:=0; /*Inserts */
37: nUpdateCount PLS_INTEGER:=0; /*Updates */
38: nFailed PLS_INTEGER:=0; /*Failed records */
39: nDups PLS_INTEGER:=0; /*Duplicate records */
40: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
41: x_usesurr_pricegroup PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PRICE_GROUPS',inXFR_GROUP);
42:
43: thisRowId ROWID;
44:
74:
75: DECLARE
76: CURSOR c_onl_itemmaster_itemid IS
77: SELECT ITEM_ID
78: FROM CZ_ITEM_MASTERS
79: WHERE ORIG_SYS_REF=sFSKITEMMASTER;
80: BEGIN
81: OPEN c_onl_itemmaster_itemid;
82: nOnlFSKItemId:=NULL;