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.HR_SUM_STORE dependencies on HRSUMREP

Line 117: hrsumrep.write_stmt_log(p_stmt => 'new stmt is' || l_new_stmt);

113: l_new_stmt := p_stmt;
114: end if;
115:
116: if p_debug = 'Y' then
117: hrsumrep.write_stmt_log(p_stmt => 'new stmt is' || l_new_stmt);
118: hrsumrep.write_stmt_log('ITEM NAME = ' || p_itu_name || ' ' || p_item_name);
119: hr_utility.trace('ITEM NAME = ' || p_itu_name || ' ' || p_item_name);
120: end if;
121:

Line 118: hrsumrep.write_stmt_log('ITEM NAME = ' || p_itu_name || ' ' || p_item_name);

114: end if;
115:
116: if p_debug = 'Y' then
117: hrsumrep.write_stmt_log(p_stmt => 'new stmt is' || l_new_stmt);
118: hrsumrep.write_stmt_log('ITEM NAME = ' || p_itu_name || ' ' || p_item_name);
119: hr_utility.trace('ITEM NAME = ' || p_itu_name || ' ' || p_item_name);
120: end if;
121:
122: hr_utility.trace ('complete convert statement');

Line 158: if hrsumrep.ktyTab.count > 0 then

154: else
155: j := 2;
156: end if;
157: --
158: if hrsumrep.ktyTab.count > 0 then
159: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
160: fnd_message.set_token('NUM',to_char(j));
161: l_error_mesg := fnd_message.get;
162: dbms_sql.define_column(source_cursor,j,l_key_value,80);

Line 159: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop

155: j := 2;
156: end if;
157: --
158: if hrsumrep.ktyTab.count > 0 then
159: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
160: fnd_message.set_token('NUM',to_char(j));
161: l_error_mesg := fnd_message.get;
162: dbms_sql.define_column(source_cursor,j,l_key_value,80);
163: l_error_mesg := null;

Line 170: -- if hrsumrep.ktyTab.count > 0 then

166: end if;
167:
168: else -- if debug
169: j := 2;
170: -- if hrsumrep.ktyTab.count > 0 then
171: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
172: l_columns_required := l_columns_required + nvl(hrsumrep.ktyTab.last,0);
173: hr_utility.trace('l_columns_required after adding is ' || l_columns_required);
174: --for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop

Line 171: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then

167:
168: else -- if debug
169: j := 2;
170: -- if hrsumrep.ktyTab.count > 0 then
171: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
172: l_columns_required := l_columns_required + nvl(hrsumrep.ktyTab.last,0);
173: hr_utility.trace('l_columns_required after adding is ' || l_columns_required);
174: --for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
175: for i in nvl(hrsumrep.ktyTab.first,1)..l_columns_required loop

Line 172: l_columns_required := l_columns_required + nvl(hrsumrep.ktyTab.last,0);

168: else -- if debug
169: j := 2;
170: -- if hrsumrep.ktyTab.count > 0 then
171: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
172: l_columns_required := l_columns_required + nvl(hrsumrep.ktyTab.last,0);
173: hr_utility.trace('l_columns_required after adding is ' || l_columns_required);
174: --for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
175: for i in nvl(hrsumrep.ktyTab.first,1)..l_columns_required loop
176: fnd_message.set_token('NUM',to_char(j));

Line 174: --for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop

170: -- if hrsumrep.ktyTab.count > 0 then
171: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
172: l_columns_required := l_columns_required + nvl(hrsumrep.ktyTab.last,0);
173: hr_utility.trace('l_columns_required after adding is ' || l_columns_required);
174: --for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
175: for i in nvl(hrsumrep.ktyTab.first,1)..l_columns_required loop
176: fnd_message.set_token('NUM',to_char(j));
177: l_error_mesg := fnd_message.get;
178: hr_utility.trace('define col');

Line 175: for i in nvl(hrsumrep.ktyTab.first,1)..l_columns_required loop

171: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
172: l_columns_required := l_columns_required + nvl(hrsumrep.ktyTab.last,0);
173: hr_utility.trace('l_columns_required after adding is ' || l_columns_required);
174: --for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
175: for i in nvl(hrsumrep.ktyTab.first,1)..l_columns_required loop
176: fnd_message.set_token('NUM',to_char(j));
177: l_error_mesg := fnd_message.get;
178: hr_utility.trace('define col');
179: dbms_sql.define_column(source_cursor,j,l_key_value,80);

Line 201: hrsumrep.write_stmt_log(p_stmt => null);

197:
198: if p_debug = 'Y' then
199: hr_utility.trace(' col value');
200: dbms_sql.column_value(source_cursor,1,l_item_value_char);
201: hrsumrep.write_stmt_log(p_stmt => null);
202: hrsumrep.write_stmt_log(p_stmt => '***** PERSON NAME is ' || l_item_value_char);
203: else
204: dbms_sql.column_value(source_cursor,1,l_item_value);
205: end if;

Line 202: hrsumrep.write_stmt_log(p_stmt => '***** PERSON NAME is ' || l_item_value_char);

198: if p_debug = 'Y' then
199: hr_utility.trace(' col value');
200: dbms_sql.column_value(source_cursor,1,l_item_value_char);
201: hrsumrep.write_stmt_log(p_stmt => null);
202: hrsumrep.write_stmt_log(p_stmt => '***** PERSON NAME is ' || l_item_value_char);
203: else
204: dbms_sql.column_value(source_cursor,1,l_item_value);
205: end if;
206:

Line 235: if hrsumrep.ktyTab.count > 0 then

231: j := 2;
232: else
233: j := 3;
234: end if;
235: if hrsumrep.ktyTab.count > 0 then
236: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
237: fnd_message.set_token('NUM',to_char(j));
238: l_error_mesg := fnd_message.get;
239: dbms_sql.column_value(source_cursor,j,l_key_value);

Line 236: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop

232: else
233: j := 3;
234: end if;
235: if hrsumrep.ktyTab.count > 0 then
236: for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
237: fnd_message.set_token('NUM',to_char(j));
238: l_error_mesg := fnd_message.get;
239: dbms_sql.column_value(source_cursor,j,l_key_value);
240: l_error_mesg := null;

Line 247: ,p_key_type_id => hrsumrep.ktyTab(i).key_type_id

243: --
244: hr_summary_api.create_key_value(p_key_value_id => l_key_value_id
245: ,p_business_group_id => p_business_group_id
246: ,p_object_version_number => l_object_version_number
247: ,p_key_type_id => hrsumrep.ktyTab(i).key_type_id
248: ,p_item_value_id => l_item_value_id
249: ,p_name => l_key_value);
250: --
251: --

Line 258: and not hrsumrep.ktyTab(i).key_other then

254: -- that each element in the multi-dimensional matrix has a
255: -- value
256: --
257: if l_key_value = hr_summary_util.OTHER
258: and not hrsumrep.ktyTab(i).key_other then
259: hr_summary_api.create_key_value(p_key_value_id => l_key_value_id
260: ,p_business_group_id => p_business_group_id
261: ,p_object_version_number => l_object_version_number
262: ,p_key_type_id => hrsumrep.ktyTab(i).key_type_id

Line 262: ,p_key_type_id => hrsumrep.ktyTab(i).key_type_id

258: and not hrsumrep.ktyTab(i).key_other then
259: hr_summary_api.create_key_value(p_key_value_id => l_key_value_id
260: ,p_business_group_id => p_business_group_id
261: ,p_object_version_number => l_object_version_number
262: ,p_key_type_id => hrsumrep.ktyTab(i).key_type_id
263: ,p_item_value_id => hr_summary_util.zero_item_value_id
264: ,p_name => l_key_value);
265: hrsumrep.ktyTab(i).key_other := TRUE;
266: end if;

Line 265: hrsumrep.ktyTab(i).key_other := TRUE;

261: ,p_object_version_number => l_object_version_number
262: ,p_key_type_id => hrsumrep.ktyTab(i).key_type_id
263: ,p_item_value_id => hr_summary_util.zero_item_value_id
264: ,p_name => l_key_value);
265: hrsumrep.ktyTab(i).key_other := TRUE;
266: end if;
267: j := j + 1;
268: end loop;
269: end if;

Line 275: -- if hrsumrep.ktyTab.count > 0 then

271: end if; -- p_debug end if
272:
273: If p_debug = 'Y' then
274: j :=2;
275: -- if hrsumrep.ktyTab.count > 0 then
276: hr_utility.trace('col value start');
277: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
278: --l_columns_required := l_columns_required + hrsumrep.ktyTab.count;
279: -- for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop

Line 277: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then

273: If p_debug = 'Y' then
274: j :=2;
275: -- if hrsumrep.ktyTab.count > 0 then
276: hr_utility.trace('col value start');
277: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
278: --l_columns_required := l_columns_required + hrsumrep.ktyTab.count;
279: -- for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
280: hr_utility.trace('col value start loop');
281: -- cater for the situation where an item has no keys

Line 278: --l_columns_required := l_columns_required + hrsumrep.ktyTab.count;

274: j :=2;
275: -- if hrsumrep.ktyTab.count > 0 then
276: hr_utility.trace('col value start');
277: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
278: --l_columns_required := l_columns_required + hrsumrep.ktyTab.count;
279: -- for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
280: hr_utility.trace('col value start loop');
281: -- cater for the situation where an item has no keys
282: if hrsumrep.ktyTab.count = 0 then

Line 279: -- for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop

275: -- if hrsumrep.ktyTab.count > 0 then
276: hr_utility.trace('col value start');
277: if hrsumrep.ktyTab.count > 0 or l_columns_required > 0 then
278: --l_columns_required := l_columns_required + hrsumrep.ktyTab.count;
279: -- for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
280: hr_utility.trace('col value start loop');
281: -- cater for the situation where an item has no keys
282: if hrsumrep.ktyTab.count = 0 then
283: l_start_index :=0;

Line 282: if hrsumrep.ktyTab.count = 0 then

278: --l_columns_required := l_columns_required + hrsumrep.ktyTab.count;
279: -- for i in hrsumrep.ktyTab.first..hrsumrep.ktyTab.last loop
280: hr_utility.trace('col value start loop');
281: -- cater for the situation where an item has no keys
282: if hrsumrep.ktyTab.count = 0 then
283: l_start_index :=0;
284: else
285: l_start_index := hrsumrep.ktyTab.first;
286: end if;

Line 285: l_start_index := hrsumrep.ktyTab.first;

281: -- cater for the situation where an item has no keys
282: if hrsumrep.ktyTab.count = 0 then
283: l_start_index :=0;
284: else
285: l_start_index := hrsumrep.ktyTab.first;
286: end if;
287: -- for i in hrsumrep.ktyTab.first..l_columns_required loop
288: l_concat_debug_string := ' ';
289: for i in l_start_index..(l_columns_required-1) loop

Line 287: -- for i in hrsumrep.ktyTab.first..l_columns_required loop

283: l_start_index :=0;
284: else
285: l_start_index := hrsumrep.ktyTab.first;
286: end if;
287: -- for i in hrsumrep.ktyTab.first..l_columns_required loop
288: l_concat_debug_string := ' ';
289: for i in l_start_index..(l_columns_required-1) loop
290: fnd_message.set_token('NUM',to_char(j));
291: l_error_mesg := fnd_message.get;

Line 295: --hrsumrep.write_stmt_log(ColNameTab(i).Col_Name || ' = ' || l_key_value);

291: l_error_mesg := fnd_message.get;
292: dbms_sql.column_value(source_cursor,j,l_key_value);
293: l_error_mesg := null;
294: if i < ColNameTab.count then
295: --hrsumrep.write_stmt_log(ColNameTab(i).Col_Name || ' = ' || l_key_value);
296: l_concat_debug_string := l_concat_debug_string || ' ' || ColNameTab(i).Col_Name || ' ' || l_key_value
297: || ',';
298: else
299: --hrsumrep.write_stmt_log(hrsumrep.ktytab(i-ColNameTab.count).key_type || ' = ' || l_key_value);

Line 299: --hrsumrep.write_stmt_log(hrsumrep.ktytab(i-ColNameTab.count).key_type || ' = ' || l_key_value);

295: --hrsumrep.write_stmt_log(ColNameTab(i).Col_Name || ' = ' || l_key_value);
296: l_concat_debug_string := l_concat_debug_string || ' ' || ColNameTab(i).Col_Name || ' ' || l_key_value
297: || ',';
298: else
299: --hrsumrep.write_stmt_log(hrsumrep.ktytab(i-ColNameTab.count).key_type || ' = ' || l_key_value);
300: l_concat_debug_string := l_concat_debug_string || ' ' || hrsumrep.ktytab(i-ColNameTab.count).key_type
301: || ' ' || l_key_value || ',';
302: end if;
303: j := j+1;

Line 300: l_concat_debug_string := l_concat_debug_string || ' ' || hrsumrep.ktytab(i-ColNameTab.count).key_type

296: l_concat_debug_string := l_concat_debug_string || ' ' || ColNameTab(i).Col_Name || ' ' || l_key_value
297: || ',';
298: else
299: --hrsumrep.write_stmt_log(hrsumrep.ktytab(i-ColNameTab.count).key_type || ' = ' || l_key_value);
300: l_concat_debug_string := l_concat_debug_string || ' ' || hrsumrep.ktytab(i-ColNameTab.count).key_type
301: || ' ' || l_key_value || ',';
302: end if;
303: j := j+1;
304: end loop;

Line 306: hrsumrep.write_stmt_log(l_concat_debug_string);

302: end if;
303: j := j+1;
304: end loop;
305: if l_concat_debug_string is not null and l_concat_debug_string <> ' ' then
306: hrsumrep.write_stmt_log(l_concat_debug_string);
307: end if;
308: end if;
309: end if;
310:

Line 316: -- hrsumrep.write_error(p_itu_name||': '||z);

312: exit;
313: end if;
314: end loop;
315: --
316: -- hrsumrep.write_error(p_itu_name||': '||z);
317: --
318: hr_utility.set_location('Leaving: hr_sum_store.store_data', 20);
319: --
320: exception when others then

Line 326: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);

322: if l_error_mesg is null then
323: hr_utility.trace('exception in HR_SUM_STORE');
324: hr_utility.trace(SQLCODE);
325: hr_utility.trace(SQLERRM);
326: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
327: null;
328: else
329: hr_utility.trace('error in HR_SUM_STORE');
330: hrsumrep.write_error(null);

Line 330: hrsumrep.write_error(null);

326: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
327: null;
328: else
329: hr_utility.trace('error in HR_SUM_STORE');
330: hrsumrep.write_error(null);
331: hrsumrep.write_error(l_error_mesg);
332: hrsumrep.write_error(sqlerrm);
333: -- hrsumrep.write_stmt_log(p_stmt => p_stmt);
334: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);

Line 331: hrsumrep.write_error(l_error_mesg);

327: null;
328: else
329: hr_utility.trace('error in HR_SUM_STORE');
330: hrsumrep.write_error(null);
331: hrsumrep.write_error(l_error_mesg);
332: hrsumrep.write_error(sqlerrm);
333: -- hrsumrep.write_stmt_log(p_stmt => p_stmt);
334: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
335: end if;

Line 332: hrsumrep.write_error(sqlerrm);

328: else
329: hr_utility.trace('error in HR_SUM_STORE');
330: hrsumrep.write_error(null);
331: hrsumrep.write_error(l_error_mesg);
332: hrsumrep.write_error(sqlerrm);
333: -- hrsumrep.write_stmt_log(p_stmt => p_stmt);
334: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
335: end if;
336: end dynamic_block;

Line 333: -- hrsumrep.write_stmt_log(p_stmt => p_stmt);

329: hr_utility.trace('error in HR_SUM_STORE');
330: hrsumrep.write_error(null);
331: hrsumrep.write_error(l_error_mesg);
332: hrsumrep.write_error(sqlerrm);
333: -- hrsumrep.write_stmt_log(p_stmt => p_stmt);
334: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
335: end if;
336: end dynamic_block;
337: dbms_sql.close_cursor(source_cursor);

Line 334: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);

330: hrsumrep.write_error(null);
331: hrsumrep.write_error(l_error_mesg);
332: hrsumrep.write_error(sqlerrm);
333: -- hrsumrep.write_stmt_log(p_stmt => p_stmt);
334: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
335: end if;
336: end dynamic_block;
337: dbms_sql.close_cursor(source_cursor);
338: end store_data;