APPS.CZ_IMP_SINGLE dependencies on CZ_XFR_TABLES

Line 2665: FROM cz_xfr_fields f, cz_xfr_tables t

2661: END;
2662:
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

Line 3435: sTableName CZ_XFR_TABLES.DST_TABLE%TYPE;

3431:
3432: genRun_ID PLS_INTEGER;
3433: nCommit_size PLS_INTEGER DEFAULT 1;
3434: nMax_err PLS_INTEGER DEFAULT 10000;
3435: sTableName CZ_XFR_TABLES.DST_TABLE%TYPE;
3436: xERROR BOOLEAN:=FALSE;
3437: nRunExploder PLS_INTEGER;
3438: cFound CHAR(1);
3439: dDateFormat VARCHAR2(40);

Line 3461: SELECT DST_TABLE FROM CZ_XFR_TABLES

3457: l_update_model_timestamp BOOLEAN := FALSE;
3458:
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;

Line 3467: SELECT DST_TABLE FROM CZ_XFR_TABLES

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

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

3821: END LOOP;
3822: END LOOP;
3823: END LOOP;
3824:
3825: ----3) Call all the extract procedures in the order specified by ORDER_SEQ field of CZ_XFR_TABLES with XFR_GROUP='EXTRACT'
3826:
3827: OPEN C_EXTRACTION_ORDER;
3828: LOOP
3829: BEGIN

Line 3853: FOR i IN (SELECT src_table FROM cz_xfr_tables

3849:
3850: ----3.5 Gather statistics on IMPORT so that best possible plans are used during key resolution and transfer.
3851:
3852: IF(genStatisticsCz = 1)THEN
3853: FOR i IN (SELECT src_table FROM cz_xfr_tables
3854: WHERE xfr_group='IMPORT'
3855: AND disabled='0') LOOP
3856: fnd_stats.GATHER_TABLE_STATS('CZ',i.src_table);
3857: END LOOP;

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

3856: fnd_stats.GATHER_TABLE_STATS('CZ',i.src_table);
3857: END LOOP;
3858: END IF;
3859:
3860: ----4) Call all the import procedures in the order specified by ORDER_SEQ field of CZ_XFR_TABLES with XFR_GROUP='IMPORT'
3861:
3862: OPEN C_IMPORT_ORDER;
3863: LOOP
3864: BEGIN