APPS.AD_ZD_TABLE dependencies on DBMS_LOB

Line 1051: dbms_lob.createtemporary (l_ev_lob_stmt, false, DBMS_LOB.CALL);

1047:
1048: -- add initial statement or separater as needed
1049: if l_ev_first then
1050: l_ev_first := false;
1051: dbms_lob.createtemporary (l_ev_lob_stmt, false, DBMS_LOB.CALL);
1052: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,
1053: amount => length(l_ev_stmt),
1054: buffer => l_ev_stmt);
1055: else

Line 1052: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,

1048: -- add initial statement or separater as needed
1049: if l_ev_first then
1050: l_ev_first := false;
1051: dbms_lob.createtemporary (l_ev_lob_stmt, false, DBMS_LOB.CALL);
1052: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,
1053: amount => length(l_ev_stmt),
1054: buffer => l_ev_stmt);
1055: else
1056: l_ev_stmt := ', ';

Line 1057: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,

1053: amount => length(l_ev_stmt),
1054: buffer => l_ev_stmt);
1055: else
1056: l_ev_stmt := ', ';
1057: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,
1058: amount => length(l_ev_stmt),
1059: buffer => l_ev_stmt);
1060: end if;
1061:

Line 1064: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,

1060: end if;
1061:
1062: -- add column mapping to EV creation statement
1063: l_ev_stmt := evcrec.table_column_name||' '||evcrec.view_column_name;
1064: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,
1065: amount => length(l_ev_stmt),
1066: buffer => l_ev_stmt);
1067:
1068: end loop;

Line 1071: if (l_ev_lob_stmt is not null and dbms_lob.getlength(l_ev_lob_stmt) > 0 ) then

1067:
1068: end loop;
1069:
1070: -- complete the EV creation statement and execute
1071: if (l_ev_lob_stmt is not null and dbms_lob.getlength(l_ev_lob_stmt) > 0 ) then
1072:
1073: l_ev_stmt := ' from "'||x_table_owner||'"."'||x_table_name||'"';
1074: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,
1075: amount => length(l_ev_stmt),

Line 1074: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,

1070: -- complete the EV creation statement and execute
1071: if (l_ev_lob_stmt is not null and dbms_lob.getlength(l_ev_lob_stmt) > 0 ) then
1072:
1073: l_ev_stmt := ' from "'||x_table_owner||'"."'||x_table_name||'"';
1074: dbms_lob.writeappend(lob_loc => l_ev_lob_stmt,
1075: amount => length(l_ev_stmt),
1076: buffer => l_ev_stmt);
1077:
1078: -- Immediate execute. [patching case]

Line 1080: end if; -- END : If l_ev_lob_stmt is not null and dbms_lob.getlength(l_ev_lob_stmt) > 0

1076: buffer => l_ev_stmt);
1077:
1078: -- Immediate execute. [patching case]
1079: exec(l_ev_lob_stmt, c_module);
1080: end if; -- END : If l_ev_lob_stmt is not null and dbms_lob.getlength(l_ev_lob_stmt) > 0
1081:
1082: if (dbms_lob.isTemporary(l_ev_lob_stmt)=1) then
1083: dbms_lob.freeTemporary(l_ev_lob_stmt);
1084: end if;

Line 1082: if (dbms_lob.isTemporary(l_ev_lob_stmt)=1) then

1078: -- Immediate execute. [patching case]
1079: exec(l_ev_lob_stmt, c_module);
1080: end if; -- END : If l_ev_lob_stmt is not null and dbms_lob.getlength(l_ev_lob_stmt) > 0
1081:
1082: if (dbms_lob.isTemporary(l_ev_lob_stmt)=1) then
1083: dbms_lob.freeTemporary(l_ev_lob_stmt);
1084: end if;
1085:
1086: exception

Line 1083: dbms_lob.freeTemporary(l_ev_lob_stmt);

1079: exec(l_ev_lob_stmt, c_module);
1080: end if; -- END : If l_ev_lob_stmt is not null and dbms_lob.getlength(l_ev_lob_stmt) > 0
1081:
1082: if (dbms_lob.isTemporary(l_ev_lob_stmt)=1) then
1083: dbms_lob.freeTemporary(l_ev_lob_stmt);
1084: end if;
1085:
1086: exception
1087: when others then

Line 1088: if (dbms_lob.isTemporary(l_ev_lob_stmt)=1) then

1084: end if;
1085:
1086: exception
1087: when others then
1088: if (dbms_lob.isTemporary(l_ev_lob_stmt)=1) then
1089: dbms_lob.freeTemporary(l_ev_lob_stmt);
1090: end if;
1091: log(c_module, 'ERROR',
1092: x_table_owner||'.'||x_table_name || ': ' || substr(sqlerrm, 1, 2000));

Line 1089: dbms_lob.freeTemporary(l_ev_lob_stmt);

1085:
1086: exception
1087: when others then
1088: if (dbms_lob.isTemporary(l_ev_lob_stmt)=1) then
1089: dbms_lob.freeTemporary(l_ev_lob_stmt);
1090: end if;
1091: log(c_module, 'ERROR',
1092: x_table_owner||'.'||x_table_name || ': ' || substr(sqlerrm, 1, 2000));
1093: raise;