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_AC_MAIN dependencies on CZ_IMP_AC_MAIN

Line 1: PACKAGE BODY CZ_IMP_AC_MAIN AS

1: PACKAGE BODY CZ_IMP_AC_MAIN AS
2: /* $Header: cziacmnb.pls 115.19 2002/12/03 14:44:34 askhacha ship $ */
3:
4: PROCEDURE CND_CONTACT ( inRUN_ID IN PLS_INTEGER,
5: COMMIT_SIZE IN PLS_INTEGER,

Line 515: CZ_IMP_AC_MAIN.CND_CONTACT (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

511: WHEN OTHERS THEN
512: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CONTACT',11276);
513: END;
514:
515: CZ_IMP_AC_MAIN.CND_CONTACT (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
516: IF (nFailed=MAX_ERR) THEN
517: INSERTS:=0;
518: UPDATES:=0;
519: FAILED:=MAX_ERR;

Line 548: CZ_IMP_AC_MAIN.RPT_CONTACT(inRUN_ID);

544: ELSE
545: FAILED:=nFailed;
546: END IF;
547:
548: CZ_IMP_AC_MAIN.RPT_CONTACT(inRUN_ID);
549: END ;
550: END MAIN_CONTACT ;
551:
552: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 593: CZ_IMP_AC_MAIN.CND_CUSTOMER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

589: WHEN OTHERS THEN
590: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CUSTOMER',11276);
591: END;
592:
593: CZ_IMP_AC_MAIN.CND_CUSTOMER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
594: IF (nFailed=MAX_ERR) THEN
595: INSERTS:=0;
596: UPDATES:=0;
597: FAILED:=MAX_ERR;

Line 607: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);

603: IF(nFailed < MAX_ERR) THEN
604: CZ_IMP_AC_XFR.XFR_CUSTOMER (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
605: /* Report Insert Errors */
606: IF (nXfrInsertCount<> INSERTS) THEN
607: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);
608: END IF;
609: /* Report Update Errors */
610: IF (nXfrUpdateCount<> UPDATES) THEN
611: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);

Line 611: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);

607: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);
608: END IF;
609: /* Report Update Errors */
610: IF (nXfrUpdateCount<> UPDATES) THEN
611: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);
612: END IF;
613: /* Return the transferred number of rows and not the number of rows with keys resolved*/
614: INSERTS:=nXfrInsertCount;
615: UPDATES:=nXfrUpdateCount;

Line 621: CZ_IMP_AC_MAIN.RPT_CUSTOMER(inRUN_ID);

617: ELSE
618: FAILED:=nFailed;
619: END IF;
620:
621: CZ_IMP_AC_MAIN.RPT_CUSTOMER(inRUN_ID);
622: END;
623: END MAIN_CUSTOMER ;
624:
625: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 666: CZ_IMP_AC_MAIN.CND_ADDRESS (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

662: WHEN OTHERS THEN
663: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_ADDRESS',11276);
664: END;
665:
666: CZ_IMP_AC_MAIN.CND_ADDRESS (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
667: IF (nFailed=MAX_ERR) THEN
668: INSERTS:=0;
669: UPDATES:=0;
670: FAILED:=MAX_ERR;

Line 680: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);

676: IF(nFailed < MAX_ERR) THEN
677: CZ_IMP_AC_XFR.XFR_ADDRESS (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
678: /* Report Insert Errors */
679: IF (nXfrInsertCount<> INSERTS) THEN
680: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);
681: END IF;
682: /* Report Update Errors */
683: IF (nXfrUpdateCount<> UPDATES) THEN
684: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);

Line 684: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);

680: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);
681: END IF;
682: /* Report Update Errors */
683: IF (nXfrUpdateCount<> UPDATES) THEN
684: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);
685: END IF;
686: /* Return the transferred number of rows and not the number of rows with keys resolved*/
687: INSERTS:=nXfrInsertCount;
688: UPDATES:=nXfrUpdateCount;

Line 694: CZ_IMP_AC_MAIN.RPT_ADDRESS(inRUN_ID);

690: ELSE
691: FAILED:=nFailed;
692: END IF;
693:
694: CZ_IMP_AC_MAIN.RPT_ADDRESS(inRUN_ID);
695: END;
696: END MAIN_ADDRESS ;
697:
698: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 739: CZ_IMP_AC_MAIN.CND_ADDRESS_USES(inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

735: WHEN OTHERS THEN
736: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_ADDRESS_USES',11276);
737: END;
738:
739: CZ_IMP_AC_MAIN.CND_ADDRESS_USES(inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
740: IF(nFailed=MAX_ERR) THEN
741: INSERTS:=0;
742: UPDATES:=0;
743: FAILED:=MAX_ERR;

Line 753: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);

749: IF(nFailed < MAX_ERR) THEN
750: CZ_IMP_AC_XFR.XFR_ADDRESS_USES(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
751: /* Report Insert Errors */
752: IF(nXfrInsertCount<> INSERTS) THEN
753: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);
754: END IF;
755: /* Report Update Errors */
756: IF(nXfrUpdateCount<> UPDATES) THEN
757: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);

Line 757: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);

753: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);
754: END IF;
755: /* Report Update Errors */
756: IF(nXfrUpdateCount<> UPDATES) THEN
757: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);
758: END IF;
759: /* Return the transferred number of rows and not the number of rows with keys resolved */
760: INSERTS:=nXfrInsertCount;
761: UPDATES:=nXfrUpdateCount;

Line 767: CZ_IMP_AC_MAIN.RPT_ADDRESS_USES(inRUN_ID);

763: ELSE
764: FAILED:=nFailed;
765: END IF;
766:
767: CZ_IMP_AC_MAIN.RPT_ADDRESS_USES(inRUN_ID);
768: END;
769: END MAIN_ADDRESS_USES;
770:
771: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 812: CZ_IMP_AC_MAIN.CND_CUSTOMER_END_USER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

808: WHEN OTHERS THEN
809: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CUSTOMER_END_USER',11276);
810: END;
811:
812: CZ_IMP_AC_MAIN.CND_CUSTOMER_END_USER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
813: IF (nFailed=MAX_ERR) THEN
814: INSERTS:=0;
815: UPDATES:=0;
816: FAILED:=MAX_ERR;

Line 826: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);

822: IF(nFailed < MAX_ERR) THEN
823: CZ_IMP_AC_XFR.XFR_CUSTOMER_END_USER (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
824: /* Report Insert Errors */
825: IF (nXfrInsertCount<> INSERTS) THEN
826: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);
827: END IF;
828: /* Report Update Errors */
829: IF (nXfrUpdateCount<> UPDATES) THEN
830: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);

Line 830: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);

826: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);
827: END IF;
828: /* Report Update Errors */
829: IF (nXfrUpdateCount<> UPDATES) THEN
830: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);
831: END IF;
832: /* Return the transferred number of rows and not the number of rows with keys resolved*/
833: INSERTS:=nXfrInsertCount;
834: UPDATES:=nXfrUpdateCount;

Line 840: CZ_IMP_AC_MAIN.RPT_CUSTOMER_END_USER(inRUN_ID);

836: ELSE
837: FAILED:=nFailed;
838: END IF;
839:
840: CZ_IMP_AC_MAIN.RPT_CUSTOMER_END_USER(inRUN_ID);
841: END;
842: END MAIN_CUSTOMER_END_USER ;
843:
844:

Line 887: CZ_IMP_AC_MAIN.CND_END_USER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

883: WHEN OTHERS THEN
884: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_END_USER',11276);
885: END;
886:
887: CZ_IMP_AC_MAIN.CND_END_USER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
888: IF (nFailed=MAX_ERR) THEN
889: INSERTS:=0;
890: UPDATES:=0;
891: FAILED:=MAX_ERR;

Line 920: CZ_IMP_AC_MAIN.RPT_END_USER(inRUN_ID);

916: ELSE
917: FAILED:=nFailed;
918: END IF;
919:
920: CZ_IMP_AC_MAIN.RPT_END_USER(inRUN_ID);
921: END ;
922: END MAIN_END_USER;
923: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
924:

Line 965: CZ_IMP_AC_MAIN.CND_END_USER_GROUP (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

961: WHEN OTHERS THEN
962: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_END_USER_GROUP',11276);
963: END;
964:
965: CZ_IMP_AC_MAIN.CND_END_USER_GROUP (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
966: IF (nFailed=MAX_ERR) THEN
967: INSERTS:=0;
968: UPDATES:=0;
969: FAILED:=MAX_ERR;

Line 998: CZ_IMP_AC_MAIN.RPT_END_USER_GROUP(inRUN_ID);

994: ELSE
995: FAILED:=nFailed;
996: END IF;
997:
998: CZ_IMP_AC_MAIN.RPT_END_USER_GROUP(inRUN_ID);
999: END ;
1000: END MAIN_END_USER_GROUP;
1001: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1002:

Line 1045: CZ_IMP_AC_MAIN.CND_USER_GROUP(inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

1041: WHEN OTHERS THEN
1042: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_USER_GROUP',11276);
1043: END;
1044:
1045: CZ_IMP_AC_MAIN.CND_USER_GROUP(inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
1046: IF (nFailed=MAX_ERR) THEN
1047: INSERTS:=0;
1048: UPDATES:=0;
1049: FAILED:=MAX_ERR;

Line 1078: CZ_IMP_AC_MAIN.RPT_USER_GROUP(inRUN_ID);

1074: ELSE
1075: FAILED:=nFailed;
1076: END IF;
1077:
1078: CZ_IMP_AC_MAIN.RPT_USER_GROUP(inRUN_ID);
1079: END ;
1080: END MAIN_USER_GROUP;
1081: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1082: PROCEDURE RPT_CONTACT ( inRUN_ID IN PLS_INTEGER ) AS

Line 1601: END CZ_IMP_AC_MAIN;

1597: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);
1598: END;
1599: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1600:
1601: END CZ_IMP_AC_MAIN;
1602: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/