APPS.AD_ZD_PARALLEL_EXEC dependencies on DBMS_LOB

Line 47: --log(x_log_mod, 'STATEMENT', 'SQL(CLOB): '||dbms_lob.substr(x_sql, 3900));

43: L_CUR integer;
44: L_RET integer;
45: begin
46:
47: --log(x_log_mod, 'STATEMENT', 'SQL(CLOB): '||dbms_lob.substr(x_sql, 3900));
48:
49: l_cur := dbms_sql.open_cursor(security_level=>2);
50: dbms_sql.parse(l_cur, x_sql, dbms_sql.native, x_edition_name, null, false);
51: l_ret := dbms_sql.execute(l_cur);

Line 83: and dbms_lob.compare(sql_lob, x_sql_lob) = 0

79: where exists
80: ( select null
81: from ad_zd_ddl_handler
82: where phase = x_phase
83: and dbms_lob.compare(sql_lob, x_sql_lob) = 0
84: and nvl(executed, 'N') <> 'S' );
85: return 'Y';
86:
87: exception

Line 438: l_sql_substr := upper(dbms_lob.substr(job.sql_lob, 10, 1));

434: -- Execute Job
435: sys.dbms_sql.parse(l_cur, job.sql_lob, dbms_sql.native, job.edition_name, null, false);
436: -- Note: explicit execute required for non-DDL statements
437: -- TODO: gross
438: l_sql_substr := upper(dbms_lob.substr(job.sql_lob, 10, 1));
439: if (l_sql_substr is not null and not
440: (instr(l_sql_substr, 'CREATE ') > 0 OR
441: instr(l_sql_substr, 'DROP ') > 0 OR
442: instr(l_sql_substr, 'ALTER ') > 0 OR

Line 460: l_long_error := dbms_lob.substr(l_error, 200, 1)

456:
457: exception
458: when others then
459: l_error := sqlerrm;
460: l_long_error := dbms_lob.substr(l_error, 200, 1)
461: ||' SQL: '||dbms_lob.substr(job.sql_lob, 200, 1);
462:
463: <>
464: case

Line 461: ||' SQL: '||dbms_lob.substr(job.sql_lob, 200, 1);

457: exception
458: when others then
459: l_error := sqlerrm;
460: l_long_error := dbms_lob.substr(l_error, 200, 1)
461: ||' SQL: '||dbms_lob.substr(job.sql_lob, 200, 1);
462:
463: <>
464: case
465: -- If FATAL error, exit worker