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 665: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

661: FROM cz_imp_localized_texts
662: WHERE RUN_ID = inRUN_ID
663: GROUP BY DISPOSITION,REC_STATUS;
664:
665: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
666: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
667: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
668:
669: BEGIN

Line 666: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

662: WHERE RUN_ID = inRUN_ID
663: GROUP BY DISPOSITION,REC_STATUS;
664:
665: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
666: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
667: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
668:
669: BEGIN
670:

Line 667: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

663: GROUP BY DISPOSITION,REC_STATUS;
664:
665: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
666: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
667: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
668:
669: BEGIN
670:
671: BEGIN

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

668:
669: BEGIN
670:
671: BEGIN
672: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
673: EXCEPTION
674: WHEN NO_DATA_FOUND THEN NULL;
675: END;
676:

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

677: OPEN c_xfr_run_result;
678: LOOP
679: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
680: EXIT WHEN c_xfr_run_result%NOTFOUND;
681: INSERT INTO CZ_XFR_RUN_RESULTS (RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
682: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
683: END LOOP;
684: CLOSE c_xfr_run_result;
685: COMMIT;

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

686:
687: DECLARE
688: nErrors PLS_INTEGER;
689: CURSOR c_get_nErrors IS
690: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
691: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
692: AND IMP_TABLE=v_table_name;
693: BEGIN
694: OPEN c_get_nErrors;

Line 1618: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

1614: FROM cz_imp_devl_project
1615: WHERE RUN_ID = inRUN_ID
1616: GROUP BY DISPOSITION,REC_STATUS;
1617:
1618: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1619: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1620: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1621:
1622: BEGIN

Line 1619: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

1615: WHERE RUN_ID = inRUN_ID
1616: GROUP BY DISPOSITION,REC_STATUS;
1617:
1618: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1619: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1620: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1621:
1622: BEGIN
1623: BEGIN

Line 1620: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

1616: GROUP BY DISPOSITION,REC_STATUS;
1617:
1618: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
1619: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
1620: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1621:
1622: BEGIN
1623: BEGIN
1624: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;

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

1620: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
1621:
1622: BEGIN
1623: BEGIN
1624: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
1625: EXCEPTION
1626: WHEN NO_DATA_FOUND THEN NULL;
1627: END;
1628:

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

1630: LOOP
1631: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
1632: EXIT WHEN c_xfr_run_result%NOTFOUND;
1633:
1634: INSERT INTO CZ_XFR_RUN_RESULTS (RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
1635: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
1636: END LOOP;
1637: CLOSE c_xfr_run_result;
1638: COMMIT;

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

1639:
1640: DECLARE
1641: nErrors PLS_INTEGER;
1642: CURSOR c_get_nErrors IS
1643: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
1644: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
1645: AND IMP_TABLE=v_table_name;
1646: BEGIN
1647: OPEN c_get_nErrors;

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

4661: v_completed VARCHAR2(1) := '1';
4662:
4663: BEGIN
4664: BEGIN
4665: DELETE FROM CZ_XFR_RUN_RESULTS WHERE RUN_ID=inRUN_ID AND IMP_TABLE=v_table_name;
4666:
4667: EXCEPTION
4668: WHEN NO_DATA_FOUND THEN NULL;
4669: END;

Line 4678: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

4674: FROM CZ_IMP_PS_NODES
4675: WHERE RUN_ID = inRUN_ID
4676: GROUP BY DISPOSITION,REC_STATUS;
4677:
4678: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
4679: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
4680: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
4681:
4682: BEGIN

Line 4679: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;

4675: WHERE RUN_ID = inRUN_ID
4676: GROUP BY DISPOSITION,REC_STATUS;
4677:
4678: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
4679: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
4680: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
4681:
4682: BEGIN
4683:

Line 4680: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;

4676: GROUP BY DISPOSITION,REC_STATUS;
4677:
4678: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
4679: ins_rec_status CZ_XFR_RUN_RESULTS.rec_status%TYPE ;
4680: ins_rec_count CZ_XFR_RUN_RESULTS.records%TYPE ;
4681:
4682: BEGIN
4683:
4684: OPEN c_xfr_run_result;

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

4685: LOOP
4686: FETCH c_xfr_run_result INTO ins_disposition,ins_rec_status,ins_rec_count;
4687: EXIT WHEN c_xfr_run_result%NOTFOUND;
4688:
4689: INSERT INTO CZ_XFR_RUN_RESULTS (RUN_ID,IMP_TABLE,DISPOSITION,REC_STATUS,RECORDS)
4690: VALUES(inRUN_ID,v_table_name,ins_disposition,ins_rec_status,ins_rec_count);
4691:
4692: END LOOP;
4693: CLOSE c_xfr_run_result;

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

4700:
4701: DECLARE
4702: nErrors PLS_INTEGER;
4703: CURSOR c_get_nErrors IS
4704: SELECT SUM(NVL(RECORDS,0)) FROM CZ_XFR_RUN_RESULTS
4705: WHERE REC_STATUS<>v_ok AND RUN_ID=inRUN_ID
4706: AND IMP_TABLE=v_table_name;
4707: BEGIN
4708: OPEN c_get_nErrors;