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_MAIN dependencies on CZ_XFR_RUN_RESULTS

Line 278: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_PRICES';

274: PROCEDURE RPT_PRICE ( inRUN_ID IN PLS_INTEGER ) AS
275: x_error BOOLEAN:=FALSE;
276: BEGIN
277: BEGIN
278: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_PRICES';
279:
280: EXCEPTION
281: WHEN NO_DATA_FOUND THEN NULL;
282: END;

Line 291: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

287: FROM CZ_IMP_price
288: WHERE RUN_ID = inRUN_ID
289: GROUP BY DISPOSITION,REC_STATUS;
290:
291: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
292: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
293: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
294:
295: BEGIN

Line 292: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

288: WHERE RUN_ID = inRUN_ID
289: GROUP BY DISPOSITION,REC_STATUS;
290:
291: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
292: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
293: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
294:
295: BEGIN
296:

Line 293: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

289: GROUP BY DISPOSITION,REC_STATUS;
290:
291: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
292: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
293: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
294:
295: BEGIN
296:
297: OPEN c_xfr_run_result;

Line 302: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)

298: LOOP
299: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
300: EXIT WHEN c_xfr_run_result%NOTFOUND;
301:
302: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
303: VALUES(inRUN_ID,'CZ_PRICES',ins_disposition,ins_rec_status,ins_rec_count);
304:
305: END LOOP;
306: CLOSE c_xfr_run_result;

Line 317: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS

313:
314: DECLARE
315: nErrors PLS_INTEGER;
316: CURSOR c_get_nErrors IS
317: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
318: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
319: AND IMP_TABLE='CZ_PRICES';
320: BEGIN
321: OPEN c_get_nErrors;

Line 343: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_PRICE_GROUPS';

339: PROCEDURE RPT_PRICE_GROUP ( inRUN_ID IN PLS_INTEGER ) AS
340: x_error BOOLEAN:=FALSE;
341: BEGIN
342: BEGIN
343: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE='CZ_PRICE_GROUPS';
344:
345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN NULL;
347: END;

Line 356: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

352: FROM CZ_IMP_price_group
353: WHERE RUN_ID = inRUN_ID
354: GROUP BY DISPOSITION,REC_STATUS;
355:
356: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
357: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
358: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
359:
360: BEGIN

Line 357: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

353: WHERE RUN_ID = inRUN_ID
354: GROUP BY DISPOSITION,REC_STATUS;
355:
356: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
357: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
358: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
359:
360: BEGIN
361:

Line 358: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

354: GROUP BY DISPOSITION,REC_STATUS;
355:
356: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
357: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
358: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
359:
360: BEGIN
361:
362: OPEN c_xfr_run_result;

Line 367: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)

363: LOOP
364: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
365: EXIT WHEN c_xfr_run_result%NOTFOUND;
366:
367: INSERT INTO CZ_XFR_RUN_RESULTS(RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
368: VALUES(inRUN_ID,'CZ_PRICE_GROUPS',ins_disposition,ins_rec_status,ins_rec_count);
369:
370: END LOOP;
371: CLOSE c_xfr_run_result;

Line 382: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS

378:
379: DECLARE
380: nErrors PLS_INTEGER;
381: CURSOR c_get_nErrors IS
382: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
383: WHERE REC_STATUS<>'OK' AND RUN_ID=inRUN_ID
384: AND IMP_TABLE='CZ_PRICE_GROUPS';
385: BEGIN
386: OPEN c_get_nErrors;