DBA Data[Home] [Help]

APPS.CZ_IMP_IM_MAIN dependencies on CZ_IMP_IM_MAIN

Line 1: PACKAGE BODY CZ_IMP_IM_MAIN AS

1: PACKAGE BODY CZ_IMP_IM_MAIN AS
2: /* $Header: cziimmnb.pls 120.1 2006/06/22 16:27:25 asiaston ship $ */
3:
4:
5: PROCEDURE CND_ITEM_MASTER ( inRUN_ID IN PLS_INTEGER,

Line 37: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_MASTER:MAX',11276,inRun_Id);

33: x_imp_itemmaster_f:=c_imp_itemmaster%FOUND;
34:
35: EXIT WHEN NOT x_imp_itemmaster_f;
36: IF (FAILED >= MAX_ERR) THEN
37: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_MASTER:MAX',11276,inRun_Id);
38: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
39: END IF;
40:
41: IF (p_imp_itemmaster.DELETED_FLAG IS NULL) THEN

Line 213: 'CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE:MAX',11276,inRun_Id);

209: IF iDeletedFlag.COUNT > 0 THEN
210:
211: IF (FAILED >= MAX_ERR) THEN
212: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,
213: 'CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE:MAX',11276,inRun_Id);
214: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
215: END IF;
216: FOR i IN iDeletedFlag.FIRST..iDeletedFlag.LAST LOOP
217: IF iDeletedFlag(i) IS NULL THEN

Line 295: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_TYPE:MAX',11276,inRun_Id);

291: x_imp_itemtype_f:=c_imp_itemtype%FOUND;
292:
293: EXIT WHEN NOT x_imp_itemtype_f;
294: IF (FAILED >= MAX_ERR) THEN
295: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_TYPE:MAX',11276,inRun_Id);
296: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
297: END IF;
298:
299: IF (p_imp_itemtype.DELETED_FLAG IS NULL) THEN

Line 358: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY:MAX',11276,inRun_Id);

354: x_imp_itemtypeprop_f:=c_imp_itemtypeprop%FOUND;
355:
356: EXIT WHEN NOT x_imp_itemtypeprop_f;
357: IF (FAILED >= MAX_ERR) THEN
358: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY:MAX',11276,inRun_Id);
359: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
360: END IF;
361:
362: IF (p_imp_itemtypeprop.DELETED_FLAG IS NULL) THEN

Line 423: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_PROPERTY:MAX',11276,inRun_Id);

419: x_imp_property_f:=c_imp_property%FOUND;
420:
421: EXIT WHEN NOT x_imp_property_f;
422: IF (FAILED >= MAX_ERR) THEN
423: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_PROPERTY:MAX',11276,inRun_Id);
424: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
425: END IF;
426:
427: IF (p_imp_property.DELETED_FLAG IS NULL) THEN

Line 522: CZ_IMP_IM_MAIN.CND_ITEM_MASTER (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);

518: if (CZ_IMP_ALL.get_time) then
519: st_time := dbms_utility.get_time();
520: end if;
521:
522: CZ_IMP_IM_MAIN.CND_ITEM_MASTER (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
523:
524: if (CZ_IMP_ALL.get_time) then
525: end_time := dbms_utility.get_time();
526: d_str := inRun_id || ' CND item master :' || (end_time-st_time)/100.00;

Line 568: CZ_IMP_IM_MAIN.RPT_ITEM_MASTER (inRUN_ID);

564: /* Return the transferred number of rows and not the number of rows with keys resolved*/
565: INSERTS:=nXfrInsertCount;
566: UPDATES:=nXfrUpdateCount;
567:
568: CZ_IMP_IM_MAIN.RPT_ITEM_MASTER (inRUN_ID);
569: END;
570: END MAIN_ITEM_MASTER ;
571:
572: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 623: CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);

619: if (CZ_IMP_ALL.get_time) then
620: st_time := dbms_utility.get_time();
621: end if;
622:
623: CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
624:
625: if (CZ_IMP_ALL.get_time) then
626: end_time := dbms_utility.get_time();
627: d_str := inRun_id || ' CND item prop val :' || (end_time-st_time)/100.00;

Line 670: CZ_IMP_IM_MAIN.RPT_ITEM_PROPERTY_VALUE(inRUN_ID);

666: /* Return the transferred number of rows and not the number of rows with keys resolved*/
667: INSERTS:=nXfrInsertCount;
668: UPDATES:=nXfrUpdateCount;
669:
670: CZ_IMP_IM_MAIN.RPT_ITEM_PROPERTY_VALUE(inRUN_ID);
671: END;
672: END MAIN_ITEM_PROPERTY_VALUE ;
673:
674: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 724: CZ_IMP_IM_MAIN.CND_ITEM_TYPE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);

720:
721: if (CZ_IMP_ALL.get_time) then
722: st_time := dbms_utility.get_time();
723: end if;
724: CZ_IMP_IM_MAIN.CND_ITEM_TYPE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
725: if (CZ_IMP_ALL.get_time) then
726: end_time := dbms_utility.get_time();
727: d_str := inRun_id || ' CND item type :' || (end_time-st_time)/100.00;
728: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);

Line 769: CZ_IMP_IM_MAIN.RPT_ITEM_TYPE(inRUN_ID);

765: /* Return the transferred number of rows and not the number of rows with keys resolved*/
766: INSERTS:=nXfrInsertCount;
767: UPDATES:=nXfrUpdateCount;
768:
769: CZ_IMP_IM_MAIN.RPT_ITEM_TYPE(inRUN_ID);
770: END;
771: END MAIN_ITEM_TYPE ;
772:
773: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 824: CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);

820: if (CZ_IMP_ALL.get_time) then
821: st_time := dbms_utility.get_time();
822: end if;
823:
824: CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
825:
826: if (CZ_IMP_ALL.get_time) then
827: end_time := dbms_utility.get_time();
828: d_str := inRun_id || ' CND item type prop :' || (end_time-st_time)/100.00;

Line 870: CZ_IMP_IM_MAIN.RPT_ITEM_TYPE_PROPERTY(inRUN_ID);

866: /* Return the transferred number of rows and not the number of rows with keys resolved*/
867: INSERTS:=nXfrInsertCount;
868: UPDATES:=nXfrUpdateCount;
869:
870: CZ_IMP_IM_MAIN.RPT_ITEM_TYPE_PROPERTY(inRUN_ID);
871: END;
872: END MAIN_ITEM_TYPE_PROPERTY ;
873:
874:

Line 928: CZ_IMP_IM_MAIN.CND_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);

924: if (CZ_IMP_ALL.get_time) then
925: st_time := dbms_utility.get_time();
926: end if;
927:
928: CZ_IMP_IM_MAIN.CND_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
929:
930: if (CZ_IMP_ALL.get_time) then
931: end_time := dbms_utility.get_time();
932: d_str := inRun_id || ' CND property :' || (end_time-st_time)/100.00;

Line 974: CZ_IMP_IM_MAIN.RPT_PROPERTY(inRUN_ID);

970: /* Return the transferred number of rows and not the number of rows with keys resolved*/
971: INSERTS:=nXfrInsertCount;
972: UPDATES:=nXfrUpdateCount;
973:
974: CZ_IMP_IM_MAIN.RPT_PROPERTY(inRUN_ID);
975: END ;
976:
977: END MAIN_PROPERTY ;
978:

Line 1333: END CZ_IMP_IM_MAIN;

1329: END;
1330:
1331: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1332:
1333: END CZ_IMP_IM_MAIN;