APPS.BIS_BIA_RSG_LOG_MGMNT dependencies on DBMS_LOB

Line 376: l_length := DBMS_LOB.getlength(l_snapshot_log_sql_handle);

372: open c_obj_properties;
373: fetch c_obj_properties into l_mv_log_sql_stored,l_mv_log_status;
374: close c_obj_properties;
375:
376: l_length := DBMS_LOB.getlength(l_snapshot_log_sql_handle);
377:
378: if (nvl(l_log_exist,'N')<>'Y' or l_snapshot_log_sql_handle is null or
379: l_length = 0 ) then
380: WRITELOG('No MV Log found for this object');

Line 629: DBMS_LOB.getlength(l_snapshot_log_sql_handle) = 0 ) then

625: return;
626: end;
627:
628: if (l_snapshot_log_sql_handle is null or
629: DBMS_LOB.getlength(l_snapshot_log_sql_handle) = 0 ) then
630: WRITELOG('Found no MV Log defined for ' || form_triplet(p_base_object_name, P_base_object_schema, P_base_object_type)
631: || ', not need to recreate.');
632: return;
633: else

Line 635: WHILE(l_offset< DBMS_LOB.getlength(l_snapshot_log_sql_handle) )

631: || ', not need to recreate.');
632: return;
633: else
634: WRITELOG('building mv log sql statement array:');
635: WHILE(l_offset< DBMS_LOB.getlength(l_snapshot_log_sql_handle) )
636: LOOP
637: l_index := l_index + 1;
638: DBMS_LOB.READ(l_snapshot_log_sql_handle, l_amount, l_offset, l_output);
639: build_statement(l_output, l_index);

Line 638: DBMS_LOB.READ(l_snapshot_log_sql_handle, l_amount, l_offset, l_output);

634: WRITELOG('building mv log sql statement array:');
635: WHILE(l_offset< DBMS_LOB.getlength(l_snapshot_log_sql_handle) )
636: LOOP
637: l_index := l_index + 1;
638: DBMS_LOB.READ(l_snapshot_log_sql_handle, l_amount, l_offset, l_output);
639: build_statement(l_output, l_index);
640: l_offset := l_offset + l_amount;
641: WRITELOG(l_output);
642: END LOOP;