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

Line 784: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

780: FROM cz_imp_localized_texts
781: WHERE RUN_ID = inRUN_ID
782: GROUP BY DISPOSITION,REC_STATUS;
783:
784: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
785: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
786: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
787:
788: BEGIN

Line 785: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

781: WHERE RUN_ID = inRUN_ID
782: GROUP BY DISPOSITION,REC_STATUS;
783:
784: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
785: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
786: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
787:
788: BEGIN
789:

Line 786: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

782: GROUP BY DISPOSITION,REC_STATUS;
783:
784: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
785: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
786: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
787:
788: BEGIN
789:
790: BEGIN

Line 791: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

787:
788: BEGIN
789:
790: BEGIN
791: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
792: EXCEPTION
793: WHEN NO_DATA_FOUND THEN NULL;
794: END;
795:

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

796: OPEN c_xfr_run_result;
797: LOOP
798: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
799: EXIT WHEN c_xfr_run_result%NOTFOUND;
800: INSERT INTO CZ_XFR_RUN_RESULTS (RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
801: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
802: END LOOP;
803: CLOSE c_xfr_run_result;
804: COMMIT;

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

805:
806: DECLARE
807: nErrors PLS_INTEGER;
808: CURSOR c_get_nErrors IS
809: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
810: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
811: AND IMP_TABLE=v_table_name;
812: BEGIN
813: OPEN c_get_nErrors;

Line 1868: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1864: FROM cz_imp_devl_project
1865: WHERE RUN_ID = inRUN_ID
1866: GROUP BY DISPOSITION,REC_STATUS;
1867:
1868: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1869: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1870: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1871:
1872: BEGIN

Line 1869: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1865: WHERE RUN_ID = inRUN_ID
1866: GROUP BY DISPOSITION,REC_STATUS;
1867:
1868: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1869: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1870: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1871:
1872: BEGIN
1873: BEGIN

Line 1870: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1866: GROUP BY DISPOSITION,REC_STATUS;
1867:
1868: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1869: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1870: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1871:
1872: BEGIN
1873: BEGIN
1874: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

Line 1874: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

1870: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1871:
1872: BEGIN
1873: BEGIN
1874: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1875: EXCEPTION
1876: WHEN NO_DATA_FOUND THEN NULL;
1877: END;
1878:

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

1880: LOOP
1881: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1882: EXIT WHEN c_xfr_run_result%NOTFOUND;
1883:
1884: INSERT INTO CZ_XFR_RUN_RESULTS (RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1885: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1886: END LOOP;
1887: CLOSE c_xfr_run_result;
1888: COMMIT;

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

1889:
1890: DECLARE
1891: nErrors PLS_INTEGER;
1892: CURSOR c_get_nErrors IS
1893: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1894: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1895: AND IMP_TABLE=v_table_name;
1896: BEGIN
1897: OPEN c_get_nErrors;

Line 5117: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

5113: v_completed VARCHAR2(1) := '1';
5114:
5115: BEGIN
5116: BEGIN
5117: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
5118:
5119: EXCEPTION
5120: WHEN NO_DATA_FOUND THEN NULL;
5121: END;

Line 5130: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

5126: FROM CZ_IMP_PS_NODES
5127: WHERE RUN_ID = inRUN_ID
5128: GROUP BY DISPOSITION,REC_STATUS;
5129:
5130: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
5131: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
5132: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
5133:
5134: BEGIN

Line 5131: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

5127: WHERE RUN_ID = inRUN_ID
5128: GROUP BY DISPOSITION,REC_STATUS;
5129:
5130: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
5131: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
5132: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
5133:
5134: BEGIN
5135:

Line 5132: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

5128: GROUP BY DISPOSITION,REC_STATUS;
5129:
5130: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
5131: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
5132: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
5133:
5134: BEGIN
5135:
5136: OPEN c_xfr_run_result;

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

5137: LOOP
5138: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
5139: EXIT WHEN c_xfr_run_result%NOTFOUND;
5140:
5141: INSERT INTO CZ_XFR_RUN_RESULTS (RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
5142: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
5143:
5144: END LOOP;
5145: CLOSE c_xfr_run_result;

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

5152:
5153: DECLARE
5154: nErrors PLS_INTEGER;
5155: CURSOR c_get_nErrors IS
5156: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
5157: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
5158: AND IMP_TABLE=v_table_name;
5159: BEGIN
5160: OPEN c_get_nErrors;