APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_PROPERTY

Line 2330: INSERT INTO CZ_IMP_PROPERTY

2326: -- where CZ_ATTR_NAME = ||'.'||
2327: --
2328: FOR i IN l_attr_name_tbl.FIRST..l_attr_name_tbl.LAST
2329: LOOP
2330: INSERT INTO CZ_IMP_PROPERTY
2331: (DESC_TEXT,NAME,ORIG_SYS_REF,RUN_ID,DATA_TYPE,DEF_VALUE,DEF_NUM_VALUE,SRC_APPLICATION_ID)
2332: VALUES (l_description_tbl(i),
2333: l_attr_name_tbl(i),
2334: l_attr_name_tbl(i)||'-'||TO_CHAR(G_EGO_APPLICATION_ID),

Line 2346: 'CZ_IMP_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',

2342: COMMIT;
2343:
2344: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2345: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2346: 'CZ_IMP_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2347: fnd_log.LEVEL_STATEMENT);
2348: END IF;
2349:
2350: --

Line 2678: sName CZ_IMP_PROPERTY.ORIG_SYS_REF%TYPE;

2674: DECIMAL_TYPE CONSTANT NUMBER := 2;
2675: TEXT_TYPE CONSTANT NUMBER := 4;
2676:
2677: xERROR BOOLEAN:=FALSE;
2678: sName CZ_IMP_PROPERTY.ORIG_SYS_REF%TYPE;
2679: nType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
2680: sResolve CZ_DB_SETTINGS.VALUE%TYPE;
2681:
2682: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2679: nType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;

2675: TEXT_TYPE CONSTANT NUMBER := 4;
2676:
2677: xERROR BOOLEAN:=FALSE;
2678: sName CZ_IMP_PROPERTY.ORIG_SYS_REF%TYPE;
2679: nType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
2680: sResolve CZ_DB_SETTINGS.VALUE%TYPE;
2681:
2682: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2683: tabValues tNumber;

Line 2686: SELECT ORIG_SYS_REF FROM CZ_IMP_PROPERTY WHERE RUN_ID=inRUN_ID AND REC_STATUS IS NULL

2682: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2683: tabValues tNumber;
2684:
2685: CURSOR C_DATATYPE IS
2686: SELECT ORIG_SYS_REF FROM CZ_IMP_PROPERTY WHERE RUN_ID=inRUN_ID AND REC_STATUS IS NULL
2687: FOR UPDATE;
2688:
2689: st_time number;
2690: end_time number;

Line 2708: INSERT INTO CZ_IMP_PROPERTY

2704: st_time := dbms_utility.get_time();
2705: end if;
2706:
2707: FORALL i IN 1..itemCatalogGroupId.COUNT
2708: INSERT INTO CZ_IMP_PROPERTY
2709: (DESC_TEXT,NAME,ORIG_SYS_REF,RUN_ID,DATA_TYPE,SRC_APPLICATION_ID)
2710: SELECT DESCRIPTION, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID, TEXT_TYPE, G_BOM_APPLICATION_ID
2711: FROM CZ_EXV_ITEM_PROPERTIES
2712: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);

Line 2802: UPDATE CZ_IMP_PROPERTY SET DATA_TYPE=DECIMAL_TYPE,DEF_NUM_VALUE=0

2798: END;
2799: END IF;
2800:
2801: IF(nType=DECIMAL_TYPE)THEN
2802: UPDATE CZ_IMP_PROPERTY SET DATA_TYPE=DECIMAL_TYPE,DEF_NUM_VALUE=0
2803: WHERE CURRENT OF C_DATATYPE;
2804: END IF;
2805: END LOOP;
2806: CLOSE C_DATATYPE;