APPS.CZ_IMP_SINGLE dependencies on CZ_PROPERTIES

Line 2696: l_onl_type cz_properties.data_type%TYPE;

2692: insert_end_time number;
2693: d_str varchar2(255);
2694: l_noupdate cz_xfr_fields.noupdate%TYPE;
2695: l_check_values BOOLEAN :=FALSE;
2696: l_onl_type cz_properties.data_type%TYPE;
2697:
2698: v_settings_id VARCHAR2(40);
2699: v_section_name VARCHAR2(30);
2700:

Line 2737: AND t.dst_table='CZ_PROPERTIES'

2733: BEGIN
2734: SELECT noupdate INTO l_noupdate
2735: FROM cz_xfr_fields f, cz_xfr_tables t
2736: WHERE t.order_seq=f.order_seq
2737: AND t.dst_table='CZ_PROPERTIES'
2738: AND f.xfr_group='IMPORT'
2739: AND t.xfr_group=f.xfr_group
2740: AND f.dst_field='DATA_TYPE'
2741: AND rownum < 2;

Line 2754: FROM cz_properties

2750: EXIT WHEN C_DATATYPE%NOTFOUND;
2751:
2752: BEGIN
2753: SELECT data_type INTO l_onl_type
2754: FROM cz_properties
2755: WHERE orig_sys_ref=sName
2756: AND deleted_flag='0'
2757: AND rownum <2;
2758: nType := l_onl_type;

Line 2996: ELSIF(lower_table_name='cz_properties') THEN

2992: end_time := dbms_utility.get_time();
2993: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2994: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2995: end if;
2996: ELSIF(lower_table_name='cz_properties') THEN
2997: if (CZ_IMP_ALL.get_time) then
2998: st_time := dbms_utility.get_time();
2999: end if;
3000: EXTR_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);

Line 3137: ELSIF(lower_table_name='cz_properties') THEN

3133: end_time := dbms_utility.get_time();
3134: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3135: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3136: end if;
3137: ELSIF(lower_table_name='cz_properties') THEN
3138: if (CZ_IMP_ALL.get_time) then
3139: st_time := dbms_utility.get_time();
3140: end if;
3141: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,

Line 3770: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',

3766:
3767: CURSOR C_EXTRACTION_ORDER IS
3768: SELECT DST_TABLE FROM CZ_XFR_TABLES
3769: WHERE XFR_GROUP='EXTRACT' AND DISABLED='0'
3770: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3771: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS')
3772: ORDER BY ORDER_SEQ;
3773: CURSOR C_IMPORT_ORDER IS
3774: SELECT DST_TABLE FROM CZ_XFR_TABLES

Line 3776: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',

3772: ORDER BY ORDER_SEQ;
3773: CURSOR C_IMPORT_ORDER IS
3774: SELECT DST_TABLE FROM CZ_XFR_TABLES
3775: WHERE XFR_GROUP='IMPORT' AND DISABLED='0'
3776: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3777: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS',
3778: 'CZ_PS_NODES')
3779: ORDER BY ORDER_SEQ;
3780: CURSOR C_BILL_OF_MATERIAL IS