eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
APPS.OKC_REPORT_PVT dependencies on DBMS_LOB

Line 94: DBMS_LOB.OPEN(lob_loc => r_clob, open_mode => DBMS_LOB.LOB_READONLY);

90: w_len integer;
91: offset integer := 1;
92: buff varchar2(4000);
93: begin
94: DBMS_LOB.OPEN(lob_loc => r_clob, open_mode => DBMS_LOB.LOB_READONLY);
95: r_len := DBMS_LOB.getlength(lob_loc => r_clob);
96: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob, cache => FALSE, dur => DBMS_LOB.CALL);
97: DBMS_LOB.OPEN(lob_loc => w_clob,open_mode => DBMS_LOB.LOB_READWRITE);
98: buff := '"?" -> '||p_title||'
';


Line 95: r_len := DBMS_LOB.getlength(lob_loc => r_clob);


91: offset integer := 1;

92: buff varchar2(4000);

93: begin

94: DBMS_LOB.OPEN(lob_loc => r_clob, open_mode => DBMS_LOB.LOB_READONLY);

95: r_len := DBMS_LOB.getlength(lob_loc => r_clob);

96: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob, cache => FALSE, dur => DBMS_LOB.CALL);

97: DBMS_LOB.OPEN(lob_loc => w_clob,open_mode => DBMS_LOB.LOB_READWRITE);

98: buff := '"?" -> '||p_title||'
';

99:     DBMS_LOB.writeappend(lob_loc => w_clob, amount => length(buff),buffer => buff);


Line 96: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob, cache => FALSE, dur => DBMS_LOB.CALL);


92: buff varchar2(4000);

93: begin

94: DBMS_LOB.OPEN(lob_loc => r_clob, open_mode => DBMS_LOB.LOB_READONLY);

95: r_len := DBMS_LOB.getlength(lob_loc => r_clob);

96: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob, cache => FALSE, dur => DBMS_LOB.CALL);

97: DBMS_LOB.OPEN(lob_loc => w_clob,open_mode => DBMS_LOB.LOB_READWRITE);

98: buff := '"?" -> '||p_title||'
';

99:     DBMS_LOB.writeappend(lob_loc => w_clob, amount => length(buff),buffer => buff);

100:     buff := NULL;


Line 97: DBMS_LOB.OPEN(lob_loc => w_clob,open_mode => DBMS_LOB.LOB_READWRITE);


93: begin

94: DBMS_LOB.OPEN(lob_loc => r_clob, open_mode => DBMS_LOB.LOB_READONLY);

95: r_len := DBMS_LOB.getlength(lob_loc => r_clob);

96: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob, cache => FALSE, dur => DBMS_LOB.CALL);

97: DBMS_LOB.OPEN(lob_loc => w_clob,open_mode => DBMS_LOB.LOB_READWRITE);

98: buff := '"?" -> '||p_title||'
';

99:     DBMS_LOB.writeappend(lob_loc => w_clob, amount => length(buff),buffer => buff);

100:     buff := NULL;

101:     WHILE (r_len > 0) LOOP


Line 99: DBMS_LOB.writeappend(lob_loc => w_clob, amount => length(buff),buffer => buff);


95: r_len := DBMS_LOB.getlength(lob_loc => r_clob);

96: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob, cache => FALSE, dur => DBMS_LOB.CALL);

97: DBMS_LOB.OPEN(lob_loc => w_clob,open_mode => DBMS_LOB.LOB_READWRITE);

98: buff := '"?" -> '||p_title||'
';

99:     DBMS_LOB.writeappend(lob_loc => w_clob, amount => length(buff),buffer => buff);

100:     buff := NULL;

101:     WHILE (r_len > 0) LOOP

102:       buff := DBMS_LOB.substr(lob_loc => r_clob,amount => least(r_len,800),offset => offset);

103:       buff := EncodeString(buff);


Line 102: buff := DBMS_LOB.substr(lob_loc => r_clob,amount => least(r_len,800),offset => offset);


98: buff := '"?" -> '||p_title||'
';

99:     DBMS_LOB.writeappend(lob_loc => w_clob, amount => length(buff),buffer => buff);

100:     buff := NULL;

101:     WHILE (r_len > 0) LOOP

102:       buff := DBMS_LOB.substr(lob_loc => r_clob,amount => least(r_len,800),offset => offset);

103:       buff := EncodeString(buff);

104:       DBMS_LOB.writeappend(lob_loc => w_clob,amount => length(buff),buffer => buff);

105:       buff := NULL;

106:       r_len := r_len-least(r_len,800);


Line 104: DBMS_LOB.writeappend(lob_loc => w_clob,amount => length(buff),buffer => buff);


100: buff := NULL;

101: WHILE (r_len > 0) LOOP

102: buff := DBMS_LOB.substr(lob_loc => r_clob,amount => least(r_len,800),offset => offset);

103: buff := EncodeString(buff);

104: DBMS_LOB.writeappend(lob_loc => w_clob,amount => length(buff),buffer => buff);

105: buff := NULL;

106: r_len := r_len-least(r_len,800);

107: offset := offset+800;

108: END LOOP;


Line 110: DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer =>buff);


106: r_len := r_len-least(r_len,800);

107: offset := offset+800;

108: END LOOP;

109: buff := '
';

110: DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer =>buff);

111: DBMS_LOB.CLOSE(lob_loc => r_clob);

112: DBMS_LOB.CLOSE(lob_loc => w_clob);

113: return w_clob;

114: end;


Line 111: DBMS_LOB.CLOSE(lob_loc => r_clob);


107: offset := offset+800;

108: END LOOP;

109: buff := '
';

110: DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer =>buff);

111: DBMS_LOB.CLOSE(lob_loc => r_clob);

112: DBMS_LOB.CLOSE(lob_loc => w_clob);

113: return w_clob;

114: end;

115: 


Line 112: DBMS_LOB.CLOSE(lob_loc => w_clob);


108: END LOOP;

109: buff := '
';

110: DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer =>buff);

111: DBMS_LOB.CLOSE(lob_loc => r_clob);

112: DBMS_LOB.CLOSE(lob_loc => w_clob);

113: return w_clob;

114: end;

115: 

116: --


Line 130: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob,cache => FALSE,dur => DBMS_LOB.CALL);


126: w_len integer;

127: offset integer := 1;

128: buff varchar2(4000);

129: begin

130: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob,cache => FALSE,dur => DBMS_LOB.CALL);

131: DBMS_LOB.OPEN(lob_loc =>w_clob, open_mode => DBMS_LOB.LOB_READWRITE);

132: buff := '"?" -> '||p_title||'
';

133:     DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer => buff);

134:     buff := NULL;


Line 131: DBMS_LOB.OPEN(lob_loc =>w_clob, open_mode => DBMS_LOB.LOB_READWRITE);


127: offset integer := 1;

128: buff varchar2(4000);

129: begin

130: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob,cache => FALSE,dur => DBMS_LOB.CALL);

131: DBMS_LOB.OPEN(lob_loc =>w_clob, open_mode => DBMS_LOB.LOB_READWRITE);

132: buff := '"?" -> '||p_title||'
';

133:     DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer => buff);

134:     buff := NULL;

135:     if (p_title is NULL) then


Line 133: DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer => buff);


129: begin

130: DBMS_LOB.CREATETEMPORARY(lob_loc => w_clob,cache => FALSE,dur => DBMS_LOB.CALL);

131: DBMS_LOB.OPEN(lob_loc =>w_clob, open_mode => DBMS_LOB.LOB_READWRITE);

132: buff := '"?" -> '||p_title||'
';

133:     DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer => buff);

134:     buff := NULL;

135:     if (p_title is NULL) then

136:       DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(p_message),buffer =>p_message);

137:     end if;


Line 136: DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(p_message),buffer =>p_message);


132: buff := '"?" -> '||p_title||'
';

133:     DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(buff),buffer => buff);

134:     buff := NULL;

135:     if (p_title is NULL) then

136:       DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(p_message),buffer =>p_message);

137:     end if;

138:     buff := '
';

139: DBMS_LOB.writeappend(lob_loc => w_clob,amount => length(buff),buffer => buff);

140: DBMS_LOB.CLOSE(lob_loc =>w_clob);


Line 139: DBMS_LOB.writeappend(lob_loc => w_clob,amount => length(buff),buffer => buff);


135: if (p_title is NULL) then

136: DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(p_message),buffer =>p_message);

137: end if;

138: buff := '
';

139: DBMS_LOB.writeappend(lob_loc => w_clob,amount => length(buff),buffer => buff);

140: DBMS_LOB.CLOSE(lob_loc =>w_clob);

141: return w_clob;

142: end;

143: 


Line 140: DBMS_LOB.CLOSE(lob_loc =>w_clob);


136: DBMS_LOB.writeappend(lob_loc => w_clob,amount =>length(p_message),buffer =>p_message);

137: end if;

138: buff := '
';

139: DBMS_LOB.writeappend(lob_loc => w_clob,amount => length(buff),buffer => buff);

140: DBMS_LOB.CLOSE(lob_loc =>w_clob);

141: return w_clob;

142: end;

143: 

144: --


Line 1734: if (dbms_lob.istemporary(lob_loc => p_clob) = 1) then


1730: procedure free_temp_clob(

1731: p_clob in out nocopy CLOB

1732: ) is

1733: begin

1734: if (dbms_lob.istemporary(lob_loc => p_clob) = 1) then

1735: dbms_lob.freetemporary(lob_loc => p_clob);

1736: end if;

1737: exception when others then NULL;

1738: end;


Line 1735: dbms_lob.freetemporary(lob_loc => p_clob);


1731: p_clob in out nocopy CLOB

1732: ) is

1733: begin

1734: if (dbms_lob.istemporary(lob_loc => p_clob) = 1) then

1735: dbms_lob.freetemporary(lob_loc => p_clob);

1736: end if;

1737: exception when others then NULL;

1738: end;

1739: 


Line 2130: DBMS_LOB.COPY(dest_lob => p_document,src_lob => c1, amount => dbms_lob.getlength(c1));


2126: open get_htm_text(p_kid,p_vid,p_xid);

2127: fetch get_htm_text into c1;

2128: -- fetch get_htm_text into p_document;

2129: close get_htm_text;

2130: DBMS_LOB.COPY(dest_lob => p_document,src_lob => c1, amount => dbms_lob.getlength(c1));

2131: end;

2132: 

2133: --

2134: -- sample post-report trigger to send message to