APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_TABLES

Line 2735: FROM cz_xfr_fields f, cz_xfr_tables t

2731: END;
2732:
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

Line 3742: sTableName CZ_XFR_TABLES.DST_TABLE%TYPE;

3738:
3739: genRun_ID PLS_INTEGER;
3740: nCommit_size PLS_INTEGER DEFAULT 1;
3741: nMax_err PLS_INTEGER DEFAULT 10000;
3742: sTableName CZ_XFR_TABLES.DST_TABLE%TYPE;
3743: xERROR BOOLEAN:=FALSE;
3744: nRunExploder PLS_INTEGER;
3745: cFound CHAR(1);
3746: dDateFormat VARCHAR2(40);

Line 3768: SELECT DST_TABLE FROM CZ_XFR_TABLES

3764: l_update_model_timestamp BOOLEAN := FALSE;
3765:
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;

Line 3774: SELECT DST_TABLE FROM CZ_XFR_TABLES

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
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')

Line 4175: ----3) Call all the extract procedures in the order specified by ORDER_SEQ field of CZ_XFR_TABLES with XFR_GROUP='EXTRACT'

4171: END LOOP;
4172: END LOOP;
4173: END LOOP;
4174:
4175: ----3) Call all the extract procedures in the order specified by ORDER_SEQ field of CZ_XFR_TABLES with XFR_GROUP='EXTRACT'
4176:
4177: OPEN C_EXTRACTION_ORDER;
4178: LOOP
4179: BEGIN

Line 4203: FOR i IN (SELECT src_table FROM cz_xfr_tables

4199:
4200: ----3.5 Gather statistics on IMPORT so that best possible plans are used during key resolution and transfer.
4201:
4202: IF(genStatisticsCz = 1)THEN
4203: FOR i IN (SELECT src_table FROM cz_xfr_tables
4204: WHERE xfr_group='IMPORT'
4205: AND disabled='0') LOOP
4206: fnd_stats.GATHER_TABLE_STATS('CZ',i.src_table);
4207: END LOOP;

Line 4210: ----4) Call all the import procedures in the order specified by ORDER_SEQ field of CZ_XFR_TABLES with XFR_GROUP='IMPORT'

4206: fnd_stats.GATHER_TABLE_STATS('CZ',i.src_table);
4207: END LOOP;
4208: END IF;
4209:
4210: ----4) Call all the import procedures in the order specified by ORDER_SEQ field of CZ_XFR_TABLES with XFR_GROUP='IMPORT'
4211:
4212: OPEN C_IMPORT_ORDER;
4213: LOOP
4214: BEGIN