APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_PROPERTY

Line 2268: INSERT INTO CZ_IMP_PROPERTY

2264: -- where CZ_ATTR_NAME = ||'.'||
2265: --
2266: FOR i IN l_attr_name_tbl.FIRST..l_attr_name_tbl.LAST
2267: LOOP
2268: INSERT INTO CZ_IMP_PROPERTY
2269: (DESC_TEXT,NAME,ORIG_SYS_REF,RUN_ID,DATA_TYPE,DEF_VALUE,DEF_NUM_VALUE,SRC_APPLICATION_ID)
2270: VALUES (l_description_tbl(i),
2271: l_attr_name_tbl(i),
2272: l_attr_name_tbl(i)||'-'||TO_CHAR(G_EGO_APPLICATION_ID),

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

2280: COMMIT;
2281:
2282: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2283: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2284: 'CZ_IMP_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2285: fnd_log.LEVEL_STATEMENT);
2286: END IF;
2287:
2288: --

Line 2608: sName CZ_IMP_PROPERTY.ORIG_SYS_REF%TYPE;

2604: DECIMAL_TYPE CONSTANT NUMBER := 2;
2605: TEXT_TYPE CONSTANT NUMBER := 4;
2606:
2607: xERROR BOOLEAN:=FALSE;
2608: sName CZ_IMP_PROPERTY.ORIG_SYS_REF%TYPE;
2609: nType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
2610: sResolve CZ_DB_SETTINGS.VALUE%TYPE;
2611:
2612: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2609: nType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;

2605: TEXT_TYPE CONSTANT NUMBER := 4;
2606:
2607: xERROR BOOLEAN:=FALSE;
2608: sName CZ_IMP_PROPERTY.ORIG_SYS_REF%TYPE;
2609: nType CZ_IMP_PROPERTY.DATA_TYPE%TYPE;
2610: sResolve CZ_DB_SETTINGS.VALUE%TYPE;
2611:
2612: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2613: tabValues tNumber;

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

2612: TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2613: tabValues tNumber;
2614:
2615: CURSOR C_DATATYPE IS
2616: SELECT ORIG_SYS_REF FROM CZ_IMP_PROPERTY WHERE RUN_ID=inRUN_ID AND REC_STATUS IS NULL
2617: FOR UPDATE;
2618:
2619: st_time number;
2620: end_time number;

Line 2638: INSERT INTO CZ_IMP_PROPERTY

2634: st_time := dbms_utility.get_time();
2635: end if;
2636:
2637: FORALL i IN 1..itemCatalogGroupId.COUNT
2638: INSERT INTO CZ_IMP_PROPERTY
2639: (DESC_TEXT,NAME,ORIG_SYS_REF,RUN_ID,DATA_TYPE,SRC_APPLICATION_ID)
2640: SELECT DESCRIPTION, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID, TEXT_TYPE, G_BOM_APPLICATION_ID
2641: FROM CZ_EXV_ITEM_PROPERTIES
2642: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);

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

2728: END;
2729: END IF;
2730:
2731: IF(nType=DECIMAL_TYPE)THEN
2732: UPDATE CZ_IMP_PROPERTY SET DATA_TYPE=DECIMAL_TYPE,DEF_NUM_VALUE=0
2733: WHERE CURRENT OF C_DATATYPE;
2734: END IF;
2735: END LOOP;
2736: CLOSE C_DATATYPE;