APPS.AD_ZD_SEED dependencies on DBMS_LOB

Line 351: l_ddl_stmt := dbms_lob.substr(l_ddl_stmts(i).ddltext);

347: end if;
348: exec(l_ddl_stmt, c_module);
349:
350: for i in 1 .. l_ddl_stmts.count loop
351: l_ddl_stmt := dbms_lob.substr(l_ddl_stmts(i).ddltext);
352: if i=1 then
353: l_ddl_stmt := regexp_replace(l_ddl_stmt,'\)',',"ZD_EDITION_NAME")', 1, 1);
354: end if;
355: exec(l_ddl_stmt, c_module);

Line 373: l_ddl_stmt := dbms_lob.substr(l_ddl_stmts(i).ddltext);

369: l_ddl_stmt := 'drop index "'||l_ind_owner||'"."'||l_ind_name||'"';
370: exec(l_ddl_stmt,c_module);
371:
372: for i in 1 .. l_ddl_stmts.count loop
373: l_ddl_stmt := dbms_lob.substr(l_ddl_stmts(i).ddltext);
374: if i=1 then
375: l_ddl_stmt := regexp_replace(l_ddl_stmt, '\)\s*([^,)])', ',"ZD_EDITION_NAME") \1', 1, 1);
376: end if;
377: exec(l_ddl_stmt, c_module);

Line 995: l_stmt := dbms_lob.substr(l_ddl_stmts(i).ddltext);

991: end if;
992: exec(l_stmt, c_module, true);
993:
994: for i in 1 .. l_ddl_stmts.count loop
995: l_stmt := dbms_lob.substr(l_ddl_stmts(i).ddltext);
996: if i=1 then
997: l_stmt := regexp_replace(l_stmt, '[, ]*"ZD_EDITION_NAME"[, ]*', '', 1, 1);
998: end if;
999: exec(l_stmt, c_module, true);

Line 1014: l_stmt := dbms_lob.substr(l_ddl_stmts(i).ddltext);

1010: exec(l_stmt, c_module, true);
1011:
1012: for i in 1 .. l_ddl_stmts.count loop
1013: begin
1014: l_stmt := dbms_lob.substr(l_ddl_stmts(i).ddltext);
1015: if i=1 then
1016: l_stmt := regexp_replace(l_stmt, '[, ]*"ZD_EDITION_NAME"[, ]*', '', 1, 1);
1017: end if;
1018: exec(l_stmt, c_module);