APPS.CZ_IMP_SINGLE dependencies on CZ_PROPERTIES

Line 2626: l_onl_type cz_properties.data_type%TYPE;

2622: insert_end_time number;
2623: d_str varchar2(255);
2624: l_noupdate cz_xfr_fields.noupdate%TYPE;
2625: l_check_values BOOLEAN :=FALSE;
2626: l_onl_type cz_properties.data_type%TYPE;
2627:
2628: v_settings_id VARCHAR2(40);
2629: v_section_name VARCHAR2(30);
2630:

Line 2667: AND t.dst_table='CZ_PROPERTIES'

2663: BEGIN
2664: SELECT noupdate INTO l_noupdate
2665: FROM cz_xfr_fields f, cz_xfr_tables t
2666: WHERE t.order_seq=f.order_seq
2667: AND t.dst_table='CZ_PROPERTIES'
2668: AND f.xfr_group='IMPORT'
2669: AND t.xfr_group=f.xfr_group
2670: AND f.dst_field='DATA_TYPE'
2671: AND rownum < 2;

Line 2684: FROM cz_properties

2680: EXIT WHEN C_DATATYPE%NOTFOUND;
2681:
2682: BEGIN
2683: SELECT data_type INTO l_onl_type
2684: FROM cz_properties
2685: WHERE orig_sys_ref=sName
2686: AND deleted_flag='0'
2687: AND rownum <2;
2688: nType := l_onl_type;

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

2922: end_time := dbms_utility.get_time();
2923: d_str := inRun_Id || ' Extract item types (' || nTop_Id || ') :' || (end_time-st_time)/100.00;
2924: xERROR:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
2925: end if;
2926: ELSIF(lower_table_name='cz_properties') THEN
2927: if (CZ_IMP_ALL.get_time) then
2928: st_time := dbms_utility.get_time();
2929: end if;
2930: EXTR_PROPERTIES(inRun_ID,nOrg_ID,nTop_ID,sExpl_type);

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

3062: end_time := dbms_utility.get_time();
3063: d_str := inRun_Id || ' Populate item type property :' || (end_time-st_time)/100.00;
3064: xERROR:=cz_utils.log_report(d_str,1,'POPULATE',11299,inRun_Id);
3065: end if;
3066: ELSIF(lower_table_name='cz_properties') THEN
3067: if (CZ_IMP_ALL.get_time) then
3068: st_time := dbms_utility.get_time();
3069: end if;
3070: CZ_IMP_IM_MAIN.MAIN_PROPERTY(inRun_ID, commit_size, max_err,

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

3459:
3460: CURSOR C_EXTRACTION_ORDER IS
3461: SELECT DST_TABLE FROM CZ_XFR_TABLES
3462: WHERE XFR_GROUP='EXTRACT' AND DISABLED='0'
3463: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3464: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS')
3465: ORDER BY ORDER_SEQ;
3466: CURSOR C_IMPORT_ORDER IS
3467: SELECT DST_TABLE FROM CZ_XFR_TABLES

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

3465: ORDER BY ORDER_SEQ;
3466: CURSOR C_IMPORT_ORDER IS
3467: SELECT DST_TABLE FROM CZ_XFR_TABLES
3468: WHERE XFR_GROUP='IMPORT' AND DISABLED='0'
3469: AND DST_TABLE IN ('CZ_ITEM_TYPES','CZ_PROPERTIES','CZ_ITEM_TYPE_PROPERTIES',
3470: 'CZ_ITEM_MASTERS','CZ_ITEM_PROPERTY_VALUES','CZ_LOCALIZED_TEXTS','CZ_DEVL_PROJECTS',
3471: 'CZ_PS_NODES')
3472: ORDER BY ORDER_SEQ;
3473: CURSOR C_BILL_OF_MATERIAL IS