eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_PR_XFR dependencies on CZ_PRICES

Line 208: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','DELETED_FLAG',inXFR_GROUP);

204:
205: -- MAKE SURE THAT THE DATA SET EXISTS
206: BEGIN
207: -- GET UPDATE FLAG FOR EACH COLUMN
208: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','DELETED_FLAG',inXFR_GROUP);
209: NOUPDATE_ITEM_PRICE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','ITEM_PRICE',inXFR_GROUP);
210: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATION_DATE',inXFR_GROUP);
211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);
212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);

Line 209: NOUPDATE_ITEM_PRICE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','ITEM_PRICE',inXFR_GROUP);

205: -- MAKE SURE THAT THE DATA SET EXISTS
206: BEGIN
207: -- GET UPDATE FLAG FOR EACH COLUMN
208: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','DELETED_FLAG',inXFR_GROUP);
209: NOUPDATE_ITEM_PRICE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','ITEM_PRICE',inXFR_GROUP);
210: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATION_DATE',inXFR_GROUP);
211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);
212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);
213: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATED_BY',inXFR_GROUP);

Line 210: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATION_DATE',inXFR_GROUP);

206: BEGIN
207: -- GET UPDATE FLAG FOR EACH COLUMN
208: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','DELETED_FLAG',inXFR_GROUP);
209: NOUPDATE_ITEM_PRICE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','ITEM_PRICE',inXFR_GROUP);
210: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATION_DATE',inXFR_GROUP);
211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);
212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);
213: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATED_BY',inXFR_GROUP);
214: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','SECURITY_MASK',inXFR_GROUP);

Line 211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);

207: -- GET UPDATE FLAG FOR EACH COLUMN
208: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','DELETED_FLAG',inXFR_GROUP);
209: NOUPDATE_ITEM_PRICE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','ITEM_PRICE',inXFR_GROUP);
210: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATION_DATE',inXFR_GROUP);
211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);
212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);
213: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATED_BY',inXFR_GROUP);
214: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','SECURITY_MASK',inXFR_GROUP);
215: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CHECKOUT_USER',inXFR_GROUP);

Line 212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);

208: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','DELETED_FLAG',inXFR_GROUP);
209: NOUPDATE_ITEM_PRICE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','ITEM_PRICE',inXFR_GROUP);
210: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATION_DATE',inXFR_GROUP);
211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);
212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);
213: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATED_BY',inXFR_GROUP);
214: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','SECURITY_MASK',inXFR_GROUP);
215: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CHECKOUT_USER',inXFR_GROUP);
216:

Line 213: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATED_BY',inXFR_GROUP);

209: NOUPDATE_ITEM_PRICE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','ITEM_PRICE',inXFR_GROUP);
210: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATION_DATE',inXFR_GROUP);
211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);
212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);
213: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATED_BY',inXFR_GROUP);
214: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','SECURITY_MASK',inXFR_GROUP);
215: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CHECKOUT_USER',inXFR_GROUP);
216:
217: OPEN C_XFR_PRICE ;

Line 214: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','SECURITY_MASK',inXFR_GROUP);

210: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATION_DATE',inXFR_GROUP);
211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);
212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);
213: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATED_BY',inXFR_GROUP);
214: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','SECURITY_MASK',inXFR_GROUP);
215: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CHECKOUT_USER',inXFR_GROUP);
216:
217: OPEN C_XFR_PRICE ;
218: LOOP

Line 215: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CHECKOUT_USER',inXFR_GROUP);

211: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATE_DATE',inXFR_GROUP);
212: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CREATED_BY',inXFR_GROUP);
213: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','LAST_UPDATED_BY',inXFR_GROUP);
214: NOUPDATE_SECURITY_MASK := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','SECURITY_MASK',inXFR_GROUP);
215: NOUPDATE_CHECKOUT_USER := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_PRICES','CHECKOUT_USER',inXFR_GROUP);
216:
217: OPEN C_XFR_PRICE ;
218: LOOP
219: IF (NCOMMITCOUNT>= COMMIT_SIZE) THEN

Line 232: INSERT INTO CZ_PRICES ( ITEM_ID,PRICE_GROUP_ID,ITEM_PRICE,

228: X_XFR_PRICE_F:=C_XFR_PRICE%FOUND;
229: EXIT WHEN (NOT X_XFR_PRICE_F OR NFAILED >= MAX_ERR);
230: IF (P_XFR_PRICE.DISPOSITION = 'I') THEN
231: BEGIN
232: INSERT INTO CZ_PRICES ( ITEM_ID,PRICE_GROUP_ID,ITEM_PRICE,
233: DELETED_FLAG,CREATION_DATE,LAST_UPDATE_DATE,
234: CREATED_BY,LAST_UPDATED_BY,SECURITY_MASK,CHECKOUT_USER)
235: VALUES
236: (P_XFR_PRICE.ITEM_ID,P_XFR_PRICE.PRICE_GROUP_ID,

Line 260: UPDATE CZ_PRICES

256: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE',11276);
257: END ;
258: ELSIF (P_XFR_PRICE.DISPOSITION = 'M') THEN
259: BEGIN
260: UPDATE CZ_PRICES
261: SET
262: ITEM_PRICE= DECODE(NOUPDATE_ITEM_PRICE,0,P_XFR_PRICE.ITEM_PRICE,ITEM_PRICE),
263: CREATION_DATE= DECODE(NOUPDATE_CREATION_DATE,0,SYSDATE,CREATION_DATE),
264: LAST_UPDATE_DATE= DECODE(NOUPDATE_LAST_UPDATE_DATE,0,SYSDATE,LAST_UPDATE_DATE),