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.PAY_SE_HCIR dependencies on DBMS_LOB

Line 146: dbms_lob.createtemporary (l_xfdf_string, FALSE , dbms_lob.CALL);

142: l_str12 := '';
143: l_str13 := '';
144: l_str14 := '';
145: l_str15 := '';
146: dbms_lob.createtemporary (l_xfdf_string, FALSE , dbms_lob.CALL);
147: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
148: current_index := 0;
149:
150: IF xml_tab.count > 0 THEN

Line 147: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);

143: l_str13 := '';
144: l_str14 := '';
145: l_str15 := '';
146: dbms_lob.createtemporary (l_xfdf_string, FALSE , dbms_lob.CALL);
147: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
148: current_index := 0;
149:
150: IF xml_tab.count > 0 THEN
151: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

Line 151: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

147: dbms_lob.OPEN (l_xfdf_string, dbms_lob.lob_readwrite);
148: current_index := 0;
149:
150: IF xml_tab.count > 0 THEN
151: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
152: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
153:
154: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
155: LOOP

Line 152: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);

148: current_index := 0;
149:
150: IF xml_tab.count > 0 THEN
151: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
152: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str12), l_str12);
153:
154: FOR table_counter IN xml_tab.FIRST .. xml_tab.LAST
155: LOOP
156: l_str8 := xml_tab (table_counter).tagname;

Line 160: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str14), l_str14);

156: l_str8 := xml_tab (table_counter).tagname;
157: l_str9 := xml_tab (table_counter).tagvalue;
158:
159: IF l_str8 = 'ORG_NAME' THEN
160: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str14), l_str14);
161: END IF;
162:
163: IF l_str9 IS NOT NULL THEN
164: l_str9 := '';

Line 165: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

161: END IF;
162:
163: IF l_str9 IS NOT NULL THEN
164: l_str9 := '';
165: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
166: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
167: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
168: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 166: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

162:
163: IF l_str9 IS NOT NULL THEN
164: l_str9 := '';
165: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
166: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
167: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
168: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 167: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

163: IF l_str9 IS NOT NULL THEN
164: l_str9 := '';
165: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
166: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
167: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
168: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 168: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);

164: l_str9 := '';
165: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
166: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
167: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
168: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
172: ELSE

Line 169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

165: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
166: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
167: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
168: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
172: ELSE
173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

Line 170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

166: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
167: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
168: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
172: ELSE
173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

167: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
168: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
172: ELSE
173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
175: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

Line 173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

169: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
172: ELSE
173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
175: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
176: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
177: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

170: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
172: ELSE
173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
175: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
176: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
177: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
178: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 175: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

171: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
172: ELSE
173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
175: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
176: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
177: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
178: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
179: END IF;

Line 176: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

172: ELSE
173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
175: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
176: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
177: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
178: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
179: END IF;
180:

Line 177: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

173: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
175: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
176: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
177: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
178: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
179: END IF;
180:
181: IF xml_tab.LAST = table_counter THEN

Line 178: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

174: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
175: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
176: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
177: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
178: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
179: END IF;
180:
181: IF xml_tab.LAST = table_counter THEN
182: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);

Line 182: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);

178: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
179: END IF;
180:
181: IF xml_tab.LAST = table_counter THEN
182: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
183: ELSIF xml_tab (table_counter + 1).tagname = 'ORG_NAME' AND l_str8 <> 'REPORT_DATE' THEN
184: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
185: END IF;
186: END LOOP;

Line 184: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);

180:
181: IF xml_tab.LAST = table_counter THEN
182: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
183: ELSIF xml_tab (table_counter + 1).tagname = 'ORG_NAME' AND l_str8 <> 'REPORT_DATE' THEN
184: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
185: END IF;
186: END LOOP;
187:
188: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);

Line 188: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);

184: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str15), l_str15);
185: END IF;
186: END LOOP;
187:
188: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
189: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
190: ELSE
191: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
192: END IF;

Line 189: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

185: END IF;
186: END LOOP;
187:
188: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
189: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
190: ELSE
191: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
192: END IF;
193:

Line 191: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

187:
188: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str13), l_str13);
189: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
190: ELSE
191: dbms_lob.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
192: END IF;
193:
194: p_xfdf_clob := l_xfdf_string;
195: hr_utility.set_location ('Leaving WritetoCLOB ', 20);