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:
45: BEGIN
86: END;
87: DECLARE
88: CURSOR c_onl_pricegroup_prigrid IS
89: SELECT PRICE_GROUP_ID
90: FROM CZ_PRICE_GROUPS
91: WHERE ORIG_SYS_REF=sFSKPRICEGROUP;
92: BEGIN
93: OPEN c_onl_pricegroup_prigrid ;
94: nOnlFSKPriceGroupId:=NULL;
258:
259: /* Check if this is an insert or update */
260: DECLARE
261: CURSOR c_onl_pricegroup_prcgrpid IS
262: SELECT PRICE_GROUP_ID FROM CZ_PRICE_GROUPS
263: WHERE ORIG_SYS_REF=sOrigSysRef;
264: BEGIN
265: OPEN c_onl_pricegroup_prcgrpid ;
266: nPriceGroupId:=NULL;
296: nInsertCount:=nInsertCount+1;
297: nAllocateCounter:=nAllocateCounter+1;
298: IF(nAllocateCounter=nAllocateBlock)THEN
299: nAllocateCounter:=0;
300: SELECT CZ_PRICE_GROUPS_S.NEXTVAL INTO nNextValue FROM DUAL;
301: END IF;
302: END IF;
303: END;
304: END IF;