[Home] [Help]
194: inRun_ID IN PLS_INTEGER DEFAULT NULL, p_rp_folder_id IN NUMBER) IS
195: genRun_ID PLS_INTEGER;
196: nCommit_size PLS_INTEGER DEFAULT 1;
197: nMax_err PLS_INTEGER DEFAULT 10000;
198: sTableName CZ_XFR_TABLES.DST_TABLE%TYPE;
199: sSrcTableName CZ_XFR_TABLES.SRC_TABLE%TYPE;
200: xERROR BOOLEAN:=FALSE;
201: bAutoCreateUsers CZ_DB_SETTINGS.VALUE%TYPE:='NO';
202: bRunExploder CZ_DB_SETTINGS.VALUE%TYPE:='NO';
195: genRun_ID PLS_INTEGER;
196: nCommit_size PLS_INTEGER DEFAULT 1;
197: nMax_err PLS_INTEGER DEFAULT 10000;
198: sTableName CZ_XFR_TABLES.DST_TABLE%TYPE;
199: sSrcTableName CZ_XFR_TABLES.SRC_TABLE%TYPE;
200: xERROR BOOLEAN:=FALSE;
201: bAutoCreateUsers CZ_DB_SETTINGS.VALUE%TYPE:='NO';
202: bRunExploder CZ_DB_SETTINGS.VALUE%TYPE:='NO';
203: outGrp_ID NUMBER;
206: d_str varchar2(255);
207: l_failed NUMBER :=0;
208:
209: CURSOR C_IMPORT_ORDER IS
210: SELECT DST_TABLE,SRC_TABLE FROM CZ_XFR_TABLES
211: WHERE XFR_GROUP='GENERIC' AND DISABLED='0'
212: ORDER BY ORDER_SEQ;
213:
214: v_settings_id VARCHAR2(40);
305: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
306: END;
307:
308: ----3) Call all the import procedures in the order specified by ORDER_SEQ field of
309: ----- CZ_XFR_TABLES with XFR_GROUP='IMPORT'
310:
311: import_before_start;
312:
313: OPEN C_IMPORT_ORDER;
542: and deleted_flag='0';
543:
544: nPriceListId cz_xfr_price_lists.price_list_id%type;
545: sDescription cz_price_groups.desc_text%type;
546: sDisabled cz_xfr_tables.disabled%type;
547: xERROR BOOLEAN := FALSE;
548:
549: begin
550:
549: begin
550:
551: begin
552: select disabled into sDisabled
553: from cz_xfr_tables where dst_table='CZ_PRICE_GROUPS' and xfr_group='IMPORT';
554: exception
555: when others then
556: sDisabled:='1';
557: end;