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.12020000.2 2012/08/17 14:55:36 smanna 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 524: CZ_IMP_IM_MAIN.CND_ITEM_MASTER (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);

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

Line 571: CZ_IMP_IM_MAIN.RPT_ITEM_MASTER (inRUN_ID);

567: INSERTS:=nXfrInsertCount;
568: UPDATES:=nXfrUpdateCount;
569: NOCHANGE:=nNoChangeCount;
570:
571: CZ_IMP_IM_MAIN.RPT_ITEM_MASTER (inRUN_ID);
572: END;
573: END MAIN_ITEM_MASTER ;
574:
575: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

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

624: if (CZ_IMP_ALL.get_time) then
625: st_time := dbms_utility.get_time();
626: end if;
627:
628: CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
629:
630: if (CZ_IMP_ALL.get_time) then
631: end_time := dbms_utility.get_time();
632: d_str := inRun_id || ' CND item prop val :' || (end_time-st_time)/100.00;

Line 675: CZ_IMP_IM_MAIN.RPT_ITEM_PROPERTY_VALUE(inRUN_ID);

671: /* Return the transferred number of rows and not the number of rows with keys resolved*/
672: INSERTS:=nXfrInsertCount;
673: UPDATES:=nXfrUpdateCount;
674:
675: CZ_IMP_IM_MAIN.RPT_ITEM_PROPERTY_VALUE(inRUN_ID);
676: END;
677: END MAIN_ITEM_PROPERTY_VALUE ;
678:
679: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

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

727:
728: if (CZ_IMP_ALL.get_time) then
729: st_time := dbms_utility.get_time();
730: end if;
731: CZ_IMP_IM_MAIN.CND_ITEM_TYPE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
732: if (CZ_IMP_ALL.get_time) then
733: end_time := dbms_utility.get_time();
734: d_str := inRun_id || ' CND item type :' || (end_time-st_time)/100.00;
735: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);

Line 777: CZ_IMP_IM_MAIN.RPT_ITEM_TYPE(inRUN_ID);

773: INSERTS:=nXfrInsertCount;
774: UPDATES:=nXfrUpdateCount;
775: NOCHANGE:=nNoChangeCount;
776:
777: CZ_IMP_IM_MAIN.RPT_ITEM_TYPE(inRUN_ID);
778: END;
779: END MAIN_ITEM_TYPE ;
780:
781: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

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

828: if (CZ_IMP_ALL.get_time) then
829: st_time := dbms_utility.get_time();
830: end if;
831:
832: CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
833:
834: if (CZ_IMP_ALL.get_time) then
835: end_time := dbms_utility.get_time();
836: d_str := inRun_id || ' CND item type prop :' || (end_time-st_time)/100.00;

Line 878: CZ_IMP_IM_MAIN.RPT_ITEM_TYPE_PROPERTY(inRUN_ID);

874: /* Return the transferred number of rows and not the number of rows with keys resolved*/
875: INSERTS:=nXfrInsertCount;
876: UPDATES:=nXfrUpdateCount;
877:
878: CZ_IMP_IM_MAIN.RPT_ITEM_TYPE_PROPERTY(inRUN_ID);
879: END;
880: END MAIN_ITEM_TYPE_PROPERTY ;
881:
882:

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

934: if (CZ_IMP_ALL.get_time) then
935: st_time := dbms_utility.get_time();
936: end if;
937:
938: CZ_IMP_IM_MAIN.CND_PROPERTY (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
939:
940: if (CZ_IMP_ALL.get_time) then
941: end_time := dbms_utility.get_time();
942: d_str := inRun_id || ' CND property :' || (end_time-st_time)/100.00;

Line 985: CZ_IMP_IM_MAIN.RPT_PROPERTY(inRUN_ID);

981: INSERTS:=nXfrInsertCount;
982: UPDATES:=nXfrUpdateCount;
983: NOCHANGE:=nNoChangeCount;
984:
985: CZ_IMP_IM_MAIN.RPT_PROPERTY(inRUN_ID);
986: END ;
987:
988: END MAIN_PROPERTY ;
989:

Line 1344: END CZ_IMP_IM_MAIN;

1340: END;
1341:
1342: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1343:
1344: END CZ_IMP_IM_MAIN;