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.PQH_REFRESH_DATA dependencies on HR_UTILITY

Line 300: -- hr_utility.trace_on;

296: WHERE tr.table_route_id = p_tab_id ;
297:
298: BEGIN
299:
300: -- hr_utility.trace_on;
301: hr_utility.set_location('Entering: '||l_proc, 5);
302:
303: -- populate the local variable l_txn_id and global g_txn_category_id with IN param value
304: -- These variables are passed to some procedures

Line 301: hr_utility.set_location('Entering: '||l_proc, 5);

297:
298: BEGIN
299:
300: -- hr_utility.trace_on;
301: hr_utility.set_location('Entering: '||l_proc, 5);
302:
303: -- populate the local variable l_txn_id and global g_txn_category_id with IN param value
304: -- These variables are passed to some procedures
305:

Line 309: hr_utility.set_location('Transaction Id: '||l_txn_id, 6);

305:
306: l_txn_id := p_txn_id;
307: g_txn_category_id := p_txn_category_id;
308:
309: hr_utility.set_location('Transaction Id: '||l_txn_id, 6);
310: hr_utility.set_location('Transaction Category Id: '||g_txn_category_id, 7);
311: hr_utility.set_location('Refresh Criteria: '||p_refresh_criteria, 8);
312:
313:

Line 310: hr_utility.set_location('Transaction Category Id: '||g_txn_category_id, 7);

306: l_txn_id := p_txn_id;
307: g_txn_category_id := p_txn_category_id;
308:
309: hr_utility.set_location('Transaction Id: '||l_txn_id, 6);
310: hr_utility.set_location('Transaction Category Id: '||g_txn_category_id, 7);
311: hr_utility.set_location('Refresh Criteria: '||p_refresh_criteria, 8);
312:
313:
314: OPEN c1_table_lists;

Line 311: hr_utility.set_location('Refresh Criteria: '||p_refresh_criteria, 8);

307: g_txn_category_id := p_txn_category_id;
308:
309: hr_utility.set_location('Transaction Id: '||l_txn_id, 6);
310: hr_utility.set_location('Transaction Category Id: '||g_txn_category_id, 7);
311: hr_utility.set_location('Refresh Criteria: '||p_refresh_criteria, 8);
312:
313:
314: OPEN c1_table_lists;
315: LOOP

Line 317: hr_utility.set_location('Inside MAIN LOOP of table list c1_table_lists', 9);

313:
314: OPEN c1_table_lists;
315: LOOP
316: -- This is the MAIN LOOP which has table lists to be Refreshed
317: hr_utility.set_location('Inside MAIN LOOP of table list c1_table_lists', 9);
318:
319: -- Initialize all the variables for each table set
320: i := 1; -- for column_name, type and refresh_flag cursor
321: l_select_stmt := '';

Line 341: hr_utility.set_location('Txn Tab Id:'||l_txn_tab_id, 10);

337:
338: FETCH c1_table_lists INTO l_txn_tab_id, l_shd_tab_id, l_mas_tab_id ;
339: EXIT WHEN c1_table_lists%NOTFOUND;
340:
341: hr_utility.set_location('Txn Tab Id:'||l_txn_tab_id, 10);
342: hr_utility.set_location('Shd Tab Id:'||l_shd_tab_id, 11);
343: hr_utility.set_location('Main Tab Id:'||l_mas_tab_id, 12);
344:
345: -- open the column_name cursor and populate the arrys columns 1 , 2 and 3

Line 342: hr_utility.set_location('Shd Tab Id:'||l_shd_tab_id, 11);

338: FETCH c1_table_lists INTO l_txn_tab_id, l_shd_tab_id, l_mas_tab_id ;
339: EXIT WHEN c1_table_lists%NOTFOUND;
340:
341: hr_utility.set_location('Txn Tab Id:'||l_txn_tab_id, 10);
342: hr_utility.set_location('Shd Tab Id:'||l_shd_tab_id, 11);
343: hr_utility.set_location('Main Tab Id:'||l_mas_tab_id, 12);
344:
345: -- open the column_name cursor and populate the arrys columns 1 , 2 and 3
346: OPEN c2_column_names ( l_txn_tab_id , l_mas_tab_id );

Line 343: hr_utility.set_location('Main Tab Id:'||l_mas_tab_id, 12);

339: EXIT WHEN c1_table_lists%NOTFOUND;
340:
341: hr_utility.set_location('Txn Tab Id:'||l_txn_tab_id, 10);
342: hr_utility.set_location('Shd Tab Id:'||l_shd_tab_id, 11);
343: hr_utility.set_location('Main Tab Id:'||l_mas_tab_id, 12);
344:
345: -- open the column_name cursor and populate the arrys columns 1 , 2 and 3
346: OPEN c2_column_names ( l_txn_tab_id , l_mas_tab_id );
347: LOOP

Line 353: hr_utility.set_location('Col Name'||l_column_name, 13);

349:
350: FETCH c2_column_names INTO l_column_name , l_refresh_flag , l_column_type, l_attribute_name;
351: EXIT WHEN c2_column_names%NOTFOUND;
352:
353: hr_utility.set_location('Col Name'||l_column_name, 13);
354: hr_utility.set_location('Refresh Flag'||l_refresh_flag, 14);
355: hr_utility.set_location('Col Type'||l_column_type, 15);
356: hr_utility.set_location('Attr Name'||l_attribute_name, 15);
357:

Line 354: hr_utility.set_location('Refresh Flag'||l_refresh_flag, 14);

350: FETCH c2_column_names INTO l_column_name , l_refresh_flag , l_column_type, l_attribute_name;
351: EXIT WHEN c2_column_names%NOTFOUND;
352:
353: hr_utility.set_location('Col Name'||l_column_name, 13);
354: hr_utility.set_location('Refresh Flag'||l_refresh_flag, 14);
355: hr_utility.set_location('Col Type'||l_column_type, 15);
356: hr_utility.set_location('Attr Name'||l_attribute_name, 15);
357:
358: -- populate the arrys col1 , col2 and col3

Line 355: hr_utility.set_location('Col Type'||l_column_type, 15);

351: EXIT WHEN c2_column_names%NOTFOUND;
352:
353: hr_utility.set_location('Col Name'||l_column_name, 13);
354: hr_utility.set_location('Refresh Flag'||l_refresh_flag, 14);
355: hr_utility.set_location('Col Type'||l_column_type, 15);
356: hr_utility.set_location('Attr Name'||l_attribute_name, 15);
357:
358: -- populate the arrys col1 , col2 and col3
359: g_refresh_tab(i).column_name := l_column_name;

Line 356: hr_utility.set_location('Attr Name'||l_attribute_name, 15);

352:
353: hr_utility.set_location('Col Name'||l_column_name, 13);
354: hr_utility.set_location('Refresh Flag'||l_refresh_flag, 14);
355: hr_utility.set_location('Col Type'||l_column_type, 15);
356: hr_utility.set_location('Attr Name'||l_attribute_name, 15);
357:
358: -- populate the arrys col1 , col2 and col3
359: g_refresh_tab(i).column_name := l_column_name;
360: g_refresh_tab(i).refresh_flag := l_refresh_flag;

Line 380: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,1,50), 16);

376: p_select_stmt => l_select_stmt,
377: p_tot_columns => l_tot_txn_columns );
378:
379:
380: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,1,50), 16);
381: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,51,50), 16);
382: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,101,50), 16);
383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);
384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);

Line 381: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,51,50), 16);

377: p_tot_columns => l_tot_txn_columns );
378:
379:
380: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,1,50), 16);
381: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,51,50), 16);
382: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,101,50), 16);
383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);
384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);
385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);

Line 382: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,101,50), 16);

378:
379:
380: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,1,50), 16);
381: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,51,50), 16);
382: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,101,50), 16);
383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);
384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);
385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);
386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);

Line 383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);

379:
380: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,1,50), 16);
381: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,51,50), 16);
382: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,101,50), 16);
383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);
384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);
385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);
386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);
387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);

Line 384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);

380: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,1,50), 16);
381: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,51,50), 16);
382: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,101,50), 16);
383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);
384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);
385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);
386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);
387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);
388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);

Line 385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);

381: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,51,50), 16);
382: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,101,50), 16);
383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);
384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);
385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);
386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);
387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);
388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);
389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);

Line 386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);

382: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,101,50), 16);
383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);
384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);
385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);
386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);
387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);
388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);
389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);
390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);

Line 387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);

383: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,151,50), 16);
384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);
385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);
386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);
387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);
388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);
389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);
390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);
391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);

Line 388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);

384: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,201,50), 16);
385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);
386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);
387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);
388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);
389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);
390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);
391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);
392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);

Line 389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);

385: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,251,50), 16);
386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);
387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);
388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);
389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);
390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);
391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);
392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);
393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);

Line 390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);

386: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,301,50), 16);
387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);
388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);
389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);
390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);
391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);
392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);
393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);
394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);

Line 391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);

387: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,351,50), 16);
388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);
389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);
390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);
391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);
392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);
393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);
394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);
395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);

Line 392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);

388: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,401,50), 16);
389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);
390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);
391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);
392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);
393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);
394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);
395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);
396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);

Line 393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);

389: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,451,50), 16);
390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);
391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);
392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);
393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);
394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);
395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);
396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);
397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);

Line 394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);

390: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,501,50), 16);
391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);
392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);
393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);
394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);
395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);
396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);
397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);
398: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,901,50), 16);

Line 395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);

391: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,551,50), 16);
392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);
393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);
394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);
395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);
396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);
397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);
398: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,901,50), 16);
399: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,951,50), 16);

Line 396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);

392: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,601,50), 16);
393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);
394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);
395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);
396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);
397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);
398: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,901,50), 16);
399: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,951,50), 16);
400: hr_utility.set_location('Txn Total Columns : '||l_tot_txn_columns, 17);

Line 397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);

393: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,651,50), 16);
394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);
395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);
396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);
397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);
398: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,901,50), 16);
399: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,951,50), 16);
400: hr_utility.set_location('Txn Total Columns : '||l_tot_txn_columns, 17);
401:

Line 398: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,901,50), 16);

394: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,701,50), 16);
395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);
396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);
397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);
398: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,901,50), 16);
399: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,951,50), 16);
400: hr_utility.set_location('Txn Total Columns : '||l_tot_txn_columns, 17);
401:
402:

Line 399: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,951,50), 16);

395: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,751,50), 16);
396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);
397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);
398: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,901,50), 16);
399: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,951,50), 16);
400: hr_utility.set_location('Txn Total Columns : '||l_tot_txn_columns, 17);
401:
402:
403: -- get the FROM and WHERE clause from pqh_table_route for TRANSACTION TABLE

Line 400: hr_utility.set_location('Txn Total Columns : '||l_tot_txn_columns, 17);

396: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,801,50), 16);
397: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,851,50), 16);
398: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,901,50), 16);
399: hr_utility.set_location('Txn Sel : '||substr(l_select_stmt,951,50), 16);
400: hr_utility.set_location('Txn Total Columns : '||l_tot_txn_columns, 17);
401:
402:
403: -- get the FROM and WHERE clause from pqh_table_route for TRANSACTION TABLE
404:

Line 413: hr_utility.set_location('Txn From : '||l_from_clause_txn, 18);

409: EXIT WHEN c3_from_where%NOTFOUND;
410: END LOOP;
411: CLOSE c3_from_where ;
412:
413: hr_utility.set_location('Txn From : '||l_from_clause_txn, 18);
414: hr_utility.set_location('Txn Where : '||l_where_clause_txn, 19);
415:
416: -- replace the WHERE clause txn_id parameter with the actual value
417: -- for TRANSACTION TABLE

Line 414: hr_utility.set_location('Txn Where : '||l_where_clause_txn, 19);

410: END LOOP;
411: CLOSE c3_from_where ;
412:
413: hr_utility.set_location('Txn From : '||l_from_clause_txn, 18);
414: hr_utility.set_location('Txn Where : '||l_where_clause_txn, 19);
415:
416: -- replace the WHERE clause txn_id parameter with the actual value
417: -- for TRANSACTION TABLE
418: replace_where_params

Line 424: hr_utility.set_location('Txn Replaced Where : '||l_rep_where_clause_txn, 20);

420: p_txn_tab_flag => 'Y',
421: p_txn_id => l_txn_id,
422: p_where_clause_out => l_rep_where_clause_txn );
423:
424: hr_utility.set_location('Txn Replaced Where : '||l_rep_where_clause_txn, 20);
425:
426:
427: -- get ALL ROWS for the TRANSACTION TABLE
428: get_all_rows

Line 484: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1,50), 16);

480: p_select_stmt => l_select_stmt,
481: p_tot_columns => l_tot_shd_columns );
482:
483:
484: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1,50), 16);
485: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,51,50), 16);
486: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,101,50), 16);
487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);
488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);

Line 485: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,51,50), 16);

481: p_tot_columns => l_tot_shd_columns );
482:
483:
484: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1,50), 16);
485: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,51,50), 16);
486: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,101,50), 16);
487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);
488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);
489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);

Line 486: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,101,50), 16);

482:
483:
484: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1,50), 16);
485: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,51,50), 16);
486: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,101,50), 16);
487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);
488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);
489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);
490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);

Line 487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);

483:
484: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1,50), 16);
485: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,51,50), 16);
486: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,101,50), 16);
487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);
488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);
489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);
490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);
491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);

Line 488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);

484: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1,50), 16);
485: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,51,50), 16);
486: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,101,50), 16);
487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);
488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);
489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);
490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);
491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);
492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);

Line 489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);

485: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,51,50), 16);
486: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,101,50), 16);
487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);
488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);
489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);
490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);
491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);
492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);
493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);

Line 490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);

486: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,101,50), 16);
487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);
488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);
489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);
490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);
491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);
492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);
493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);
494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);

Line 491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);

487: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,151,50), 16);
488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);
489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);
490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);
491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);
492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);
493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);
494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);
495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);

Line 492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);

488: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,201,50), 16);
489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);
490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);
491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);
492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);
493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);
494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);
495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);
496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);

Line 493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);

489: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,251,50), 16);
490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);
491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);
492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);
493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);
494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);
495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);
496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);
497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);

Line 494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);

490: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,301,50), 16);
491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);
492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);
493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);
494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);
495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);
496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);
497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);
498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);

Line 495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);

491: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,351,50), 16);
492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);
493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);
494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);
495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);
496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);
497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);
498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);
499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);

Line 496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);

492: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,401,50), 16);
493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);
494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);
495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);
496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);
497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);
498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);
499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);
500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);

Line 497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);

493: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,451,50), 16);
494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);
495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);
496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);
497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);
498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);
499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);
500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);
501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);

Line 498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);

494: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,501,50), 16);
495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);
496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);
497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);
498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);
499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);
500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);
501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);
502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);

Line 499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);

495: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,551,50), 16);
496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);
497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);
498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);
499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);
500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);
501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);
502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);
503: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,951,50), 16);

Line 500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);

496: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,601,50), 16);
497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);
498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);
499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);
500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);
501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);
502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);
503: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,951,50), 16);
504: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1001,50), 16);

Line 501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);

497: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,651,50), 16);
498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);
499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);
500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);
501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);
502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);
503: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,951,50), 16);
504: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1001,50), 16);
505: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1051,50), 16);

Line 502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);

498: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,701,50), 16);
499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);
500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);
501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);
502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);
503: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,951,50), 16);
504: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1001,50), 16);
505: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1051,50), 16);
506:

Line 503: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,951,50), 16);

499: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,751,50), 16);
500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);
501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);
502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);
503: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,951,50), 16);
504: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1001,50), 16);
505: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1051,50), 16);
506:
507: -- get the FROM and WHERE clause from pqh_table_route for SHADOW TABLE

Line 504: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1001,50), 16);

500: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,801,50), 16);
501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);
502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);
503: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,951,50), 16);
504: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1001,50), 16);
505: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1051,50), 16);
506:
507: -- get the FROM and WHERE clause from pqh_table_route for SHADOW TABLE
508:

Line 505: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1051,50), 16);

501: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,851,50), 16);
502: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,901,50), 16);
503: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,951,50), 16);
504: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1001,50), 16);
505: hr_utility.set_location('Shd Sel : '||substr(l_select_stmt,1051,50), 16);
506:
507: -- get the FROM and WHERE clause from pqh_table_route for SHADOW TABLE
508:
509: OPEN c3_from_where ( l_shd_tab_id ) ;

Line 517: hr_utility.set_location('Shd From : '||l_from_clause_shd, 18);

513: EXIT WHEN c3_from_where%NOTFOUND;
514: END LOOP;
515: CLOSE c3_from_where ;
516:
517: hr_utility.set_location('Shd From : '||l_from_clause_shd, 18);
518: hr_utility.set_location('Shd Where : '||l_where_clause_shd, 19);
519:
520: -- replace the WHERE clause parameters with the actual value
521: -- for SHADOW TABLE

Line 518: hr_utility.set_location('Shd Where : '||l_where_clause_shd, 19);

514: END LOOP;
515: CLOSE c3_from_where ;
516:
517: hr_utility.set_location('Shd From : '||l_from_clause_shd, 18);
518: hr_utility.set_location('Shd Where : '||l_where_clause_shd, 19);
519:
520: -- replace the WHERE clause parameters with the actual value
521: -- for SHADOW TABLE
522: replace_where_params

Line 528: hr_utility.set_location('Shd Replaced Where : '||l_rep_where_clause_shd, 20);

524: p_txn_tab_flag => 'N',
525: p_txn_id => l_txn_id,
526: p_where_clause_out => l_rep_where_clause_shd );
527:
528: hr_utility.set_location('Shd Replaced Where : '||l_rep_where_clause_shd, 20);
529:
530: -- get ALL ROWS for the SHADOW TABLE
531: -- THERE WILL BE ONLY ONW ROW RETURNED for shadow and main tables as
532: -- the where clause has primary key columns

Line 568: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1,50), 16);

564: p_tot_columns => l_tot_main_columns );
565:
566:
567:
568: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1,50), 16);
569: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,51,50), 16);
570: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,101,50), 16);
571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);
572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);

Line 569: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,51,50), 16);

565:
566:
567:
568: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1,50), 16);
569: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,51,50), 16);
570: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,101,50), 16);
571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);
572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);
573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);

Line 570: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,101,50), 16);

566:
567:
568: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1,50), 16);
569: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,51,50), 16);
570: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,101,50), 16);
571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);
572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);
573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);
574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);

Line 571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);

567:
568: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1,50), 16);
569: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,51,50), 16);
570: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,101,50), 16);
571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);
572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);
573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);
574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);
575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);

Line 572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);

568: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1,50), 16);
569: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,51,50), 16);
570: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,101,50), 16);
571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);
572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);
573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);
574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);
575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);
576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);

Line 573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);

569: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,51,50), 16);
570: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,101,50), 16);
571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);
572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);
573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);
574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);
575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);
576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);
577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);

Line 574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);

570: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,101,50), 16);
571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);
572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);
573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);
574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);
575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);
576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);
577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);
578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);

Line 575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);

571: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,151,50), 16);
572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);
573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);
574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);
575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);
576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);
577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);
578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);
579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);

Line 576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);

572: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,201,50), 16);
573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);
574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);
575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);
576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);
577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);
578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);
579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);
580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);

Line 577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);

573: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,251,50), 16);
574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);
575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);
576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);
577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);
578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);
579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);
580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);
581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);

Line 578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);

574: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,301,50), 16);
575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);
576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);
577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);
578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);
579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);
580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);
581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);
582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);

Line 579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);

575: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,351,50), 16);
576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);
577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);
578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);
579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);
580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);
581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);
582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);
583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);

Line 580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);

576: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,401,50), 16);
577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);
578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);
579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);
580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);
581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);
582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);
583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);
584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);

Line 581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);

577: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,451,50), 16);
578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);
579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);
580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);
581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);
582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);
583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);
584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);
585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);

Line 582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);

578: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,501,50), 16);
579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);
580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);
581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);
582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);
583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);
584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);
585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);
586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);

Line 583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);

579: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,551,50), 16);
580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);
581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);
582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);
583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);
584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);
585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);
586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);
587: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,951,50), 16);

Line 584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);

580: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,601,50), 16);
581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);
582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);
583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);
584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);
585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);
586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);
587: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,951,50), 16);
588: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1001,50), 16);

Line 585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);

581: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,651,50), 16);
582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);
583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);
584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);
585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);
586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);
587: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,951,50), 16);
588: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1001,50), 16);
589: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1051,50), 16);

Line 586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);

582: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,701,50), 16);
583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);
584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);
585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);
586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);
587: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,951,50), 16);
588: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1001,50), 16);
589: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1051,50), 16);
590:

Line 587: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,951,50), 16);

583: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,751,50), 16);
584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);
585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);
586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);
587: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,951,50), 16);
588: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1001,50), 16);
589: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1051,50), 16);
590:
591: -- get the FROM and WHERE clause from pqh_table_route for MAIN TABLE

Line 588: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1001,50), 16);

584: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,801,50), 16);
585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);
586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);
587: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,951,50), 16);
588: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1001,50), 16);
589: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1051,50), 16);
590:
591: -- get the FROM and WHERE clause from pqh_table_route for MAIN TABLE
592:

Line 589: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1051,50), 16);

585: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,851,50), 16);
586: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,901,50), 16);
587: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,951,50), 16);
588: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1001,50), 16);
589: hr_utility.set_location('Main Sel : '||substr(l_select_stmt,1051,50), 16);
590:
591: -- get the FROM and WHERE clause from pqh_table_route for MAIN TABLE
592:
593: OPEN c3_from_where ( l_mas_tab_id ) ;

Line 601: hr_utility.set_location('Main From : '||l_from_clause_main, 18);

597: EXIT WHEN c3_from_where%NOTFOUND;
598: END LOOP;
599: CLOSE c3_from_where ;
600:
601: hr_utility.set_location('Main From : '||l_from_clause_main, 18);
602: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,1,50), 19);
603: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,51,50), 19);
604: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,101,50), 19);
605: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,151,50), 19);

Line 602: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,1,50), 19);

598: END LOOP;
599: CLOSE c3_from_where ;
600:
601: hr_utility.set_location('Main From : '||l_from_clause_main, 18);
602: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,1,50), 19);
603: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,51,50), 19);
604: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,101,50), 19);
605: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,151,50), 19);
606: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,201,50), 19);

Line 603: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,51,50), 19);

599: CLOSE c3_from_where ;
600:
601: hr_utility.set_location('Main From : '||l_from_clause_main, 18);
602: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,1,50), 19);
603: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,51,50), 19);
604: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,101,50), 19);
605: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,151,50), 19);
606: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,201,50), 19);
607: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,251,50), 19);

Line 604: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,101,50), 19);

600:
601: hr_utility.set_location('Main From : '||l_from_clause_main, 18);
602: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,1,50), 19);
603: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,51,50), 19);
604: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,101,50), 19);
605: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,151,50), 19);
606: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,201,50), 19);
607: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,251,50), 19);
608:

Line 605: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,151,50), 19);

601: hr_utility.set_location('Main From : '||l_from_clause_main, 18);
602: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,1,50), 19);
603: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,51,50), 19);
604: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,101,50), 19);
605: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,151,50), 19);
606: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,201,50), 19);
607: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,251,50), 19);
608:
609: -- replace the WHERE clause parameters with the actual value

Line 606: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,201,50), 19);

602: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,1,50), 19);
603: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,51,50), 19);
604: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,101,50), 19);
605: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,151,50), 19);
606: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,201,50), 19);
607: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,251,50), 19);
608:
609: -- replace the WHERE clause parameters with the actual value
610: -- for MAIN TABLE

Line 607: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,251,50), 19);

603: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,51,50), 19);
604: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,101,50), 19);
605: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,151,50), 19);
606: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,201,50), 19);
607: hr_utility.set_location('Main Where : '||substr(l_where_clause_main,251,50), 19);
608:
609: -- replace the WHERE clause parameters with the actual value
610: -- for MAIN TABLE
611: replace_where_params

Line 618: hr_utility.set_location('Man Rep where : '||substr(l_rep_where_clause_main,1,50),30);

614: p_txn_id => l_txn_id,
615: p_where_clause_out => l_rep_where_clause_main );
616:
617:
618: hr_utility.set_location('Man Rep where : '||substr(l_rep_where_clause_main,1,50),30);
619:
620:
621: -- get ALL ROWS for the MAIN TABLE
622: -- THERE WILL BE ONLY ONW ROW RETURNED for shadow and main tables as

Line 713: hr_utility.set_location('Leaving:'||l_proc, 1000);

709: CLOSE c1_table_lists;
710:
711: -- commit the work;
712: -- commit;
713: hr_utility.set_location('Leaving:'||l_proc, 1000);
714: -- hr_utility.trace_off;
715:
716:
717: EXCEPTION

Line 714: -- hr_utility.trace_off;

710:
711: -- commit the work;
712: -- commit;
713: hr_utility.set_location('Leaving:'||l_proc, 1000);
714: -- hr_utility.trace_off;
715:
716:
717: EXCEPTION
718: WHEN OTHERS THEN

Line 720: -- hr_utility.trace_off;

716:
717: EXCEPTION
718: WHEN OTHERS THEN
719: p_items_changed := null;
720: -- hr_utility.trace_off;
721: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
722: hr_utility.set_message_token('ROUTINE', l_proc);
723: hr_utility.set_message_token('REASON', SQLERRM);
724: hr_utility.raise_error;

Line 721: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

717: EXCEPTION
718: WHEN OTHERS THEN
719: p_items_changed := null;
720: -- hr_utility.trace_off;
721: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
722: hr_utility.set_message_token('ROUTINE', l_proc);
723: hr_utility.set_message_token('REASON', SQLERRM);
724: hr_utility.raise_error;
725: END refresh_data;

Line 722: hr_utility.set_message_token('ROUTINE', l_proc);

718: WHEN OTHERS THEN
719: p_items_changed := null;
720: -- hr_utility.trace_off;
721: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
722: hr_utility.set_message_token('ROUTINE', l_proc);
723: hr_utility.set_message_token('REASON', SQLERRM);
724: hr_utility.raise_error;
725: END refresh_data;
726:

Line 723: hr_utility.set_message_token('REASON', SQLERRM);

719: p_items_changed := null;
720: -- hr_utility.trace_off;
721: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
722: hr_utility.set_message_token('ROUTINE', l_proc);
723: hr_utility.set_message_token('REASON', SQLERRM);
724: hr_utility.raise_error;
725: END refresh_data;
726:
727:

Line 724: hr_utility.raise_error;

720: -- hr_utility.trace_off;
721: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
722: hr_utility.set_message_token('ROUTINE', l_proc);
723: hr_utility.set_message_token('REASON', SQLERRM);
724: hr_utility.raise_error;
725: END refresh_data;
726:
727:
728: /*----------------------------------------------------------------

Line 756: hr_utility.set_location('Entering:'||l_proc, 5);

752:
753:
754:
755: BEGIN
756: hr_utility.set_location('Entering:'||l_proc, 5);
757:
758: -- intitalize the out variable
759: p_select_stmt := 'SELECT ';
760: p_tot_columns := 0;

Line 805: hr_utility.set_location('Leaving:'||l_proc, 1000);

801:
802: -- remove the last comma
803: p_select_stmt := rtrim(p_select_stmt,',');
804:
805: hr_utility.set_location('Leaving:'||l_proc, 1000);
806:
807: EXCEPTION
808: WHEN OTHERS THEN
809: p_select_stmt := null;

Line 811: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

807: EXCEPTION
808: WHEN OTHERS THEN
809: p_select_stmt := null;
810: p_tot_columns := null;
811: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
812: hr_utility.set_message_token('ROUTINE', l_proc);
813: hr_utility.set_message_token('REASON', SQLERRM);
814: hr_utility.raise_error;
815: END build_dynamic_select;

Line 812: hr_utility.set_message_token('ROUTINE', l_proc);

808: WHEN OTHERS THEN
809: p_select_stmt := null;
810: p_tot_columns := null;
811: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
812: hr_utility.set_message_token('ROUTINE', l_proc);
813: hr_utility.set_message_token('REASON', SQLERRM);
814: hr_utility.raise_error;
815: END build_dynamic_select;
816:

Line 813: hr_utility.set_message_token('REASON', SQLERRM);

809: p_select_stmt := null;
810: p_tot_columns := null;
811: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
812: hr_utility.set_message_token('ROUTINE', l_proc);
813: hr_utility.set_message_token('REASON', SQLERRM);
814: hr_utility.raise_error;
815: END build_dynamic_select;
816:
817: /*----------------------------------------------------------------

Line 814: hr_utility.raise_error;

810: p_tot_columns := null;
811: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
812: hr_utility.set_message_token('ROUTINE', l_proc);
813: hr_utility.set_message_token('REASON', SQLERRM);
814: hr_utility.raise_error;
815: END build_dynamic_select;
816:
817: /*----------------------------------------------------------------
818: || FUNCTION : ret_value_from_glb_table

Line 827: hr_utility.set_location('Entering:'||l_proc, 5);

823: --
824: l_proc varchar2(72) := g_package||'ret_value_from_glb_table';
825: BEGIN
826: --
827: hr_utility.set_location('Entering:'||l_proc, 5);
828: --
829: return pqh_refresh_data.g_refresh_tab_all(p_index).txn_val;
830: --
831: hr_utility.set_location('Entering:'||l_proc, 5);

Line 831: hr_utility.set_location('Entering:'||l_proc, 5);

827: hr_utility.set_location('Entering:'||l_proc, 5);
828: --
829: return pqh_refresh_data.g_refresh_tab_all(p_index).txn_val;
830: --
831: hr_utility.set_location('Entering:'||l_proc, 5);
832: --
833: exception when others then
834: return null;
835: --

Line 856: hr_utility.set_location('Entering:'||l_proc, 5);

852: l_back VARCHAR2(100);
853:
854:
855: BEGIN
856: hr_utility.set_location('Entering:'||l_proc, 5);
857:
858: hr_utility.set_location('Col Name : '||p_column_name, 6);
859:
860: IF NVL(g_refresh_tab_all.COUNT,0) <> 0 THEN

Line 858: hr_utility.set_location('Col Name : '||p_column_name, 6);

854:
855: BEGIN
856: hr_utility.set_location('Entering:'||l_proc, 5);
857:
858: hr_utility.set_location('Col Name : '||p_column_name, 6);
859:
860: IF NVL(g_refresh_tab_all.COUNT,0) <> 0 THEN
861: -- loop thru the array and get the value in column 3 corresponding to col name
862: FOR i IN NVL(g_refresh_tab_all.FIRST,0)..NVL(g_refresh_tab_all.LAST,-1)

Line 864: hr_utility.set_location('Searching g_refresh_tab_all:'|| UPPER(g_refresh_tab_all(i).column_name)||','|| UPPER(p_column_name),7);

860: IF NVL(g_refresh_tab_all.COUNT,0) <> 0 THEN
861: -- loop thru the array and get the value in column 3 corresponding to col name
862: FOR i IN NVL(g_refresh_tab_all.FIRST,0)..NVL(g_refresh_tab_all.LAST,-1)
863: LOOP
864: hr_utility.set_location('Searching g_refresh_tab_all:'|| UPPER(g_refresh_tab_all(i).column_name)||','|| UPPER(p_column_name),7);
865: IF UPPER(g_refresh_tab_all(i).column_name) = UPPER(p_column_name) THEN
866: hr_utility.set_location('Found match in g_refresh_tab_all',8);
867: l_col_val := 'pqh_refresh_data.ret_value_from_glb_table('
868: || to_char(i)

Line 866: hr_utility.set_location('Found match in g_refresh_tab_all',8);

862: FOR i IN NVL(g_refresh_tab_all.FIRST,0)..NVL(g_refresh_tab_all.LAST,-1)
863: LOOP
864: hr_utility.set_location('Searching g_refresh_tab_all:'|| UPPER(g_refresh_tab_all(i).column_name)||','|| UPPER(p_column_name),7);
865: IF UPPER(g_refresh_tab_all(i).column_name) = UPPER(p_column_name) THEN
866: hr_utility.set_location('Found match in g_refresh_tab_all',8);
867: l_col_val := 'pqh_refresh_data.ret_value_from_glb_table('
868: || to_char(i)
869: || ')';
870: l_col_type := g_refresh_tab_all(i).column_type;

Line 916: hr_utility.set_location('Col Val : '||l_col_val, 10);

912: **/
913:
914: l_col_val := l_front||l_col_val||l_back;
915:
916: hr_utility.set_location('Col Val : '||l_col_val, 10);
917: hr_utility.set_location('Leaving:'||l_proc, 1000);
918:
919: return l_col_val;
920:

Line 917: hr_utility.set_location('Leaving:'||l_proc, 1000);

913:
914: l_col_val := l_front||l_col_val||l_back;
915:
916: hr_utility.set_location('Col Val : '||l_col_val, 10);
917: hr_utility.set_location('Leaving:'||l_proc, 1000);
918:
919: return l_col_val;
920:
921:

Line 941: hr_utility.set_location('Entering:'||l_proc, 5);

937: l_back VARCHAR2(100);
938:
939:
940: BEGIN
941: hr_utility.set_location('Entering:'||l_proc, 5);
942:
943: hr_utility.set_location('Col Name : '||p_column_name, 6);
944:
945: IF NVL(g_refresh_tab.COUNT,0) <> 0 THEN

Line 943: hr_utility.set_location('Col Name : '||p_column_name, 6);

939:
940: BEGIN
941: hr_utility.set_location('Entering:'||l_proc, 5);
942:
943: hr_utility.set_location('Col Name : '||p_column_name, 6);
944:
945: IF NVL(g_refresh_tab.COUNT,0) <> 0 THEN
946: -- loop thru the array and get the value in column 3 corresponding to col name
947: FOR i IN NVL(g_refresh_tab.FIRST,0)..NVL(g_refresh_tab.LAST,-1)

Line 972: hr_utility.set_location('Col Val : '||l_col_val, 10);

968: END IF;
969:
970: l_col_val := l_front||l_col_val||l_back;
971:
972: hr_utility.set_location('Col Val : '||l_col_val, 10);
973: hr_utility.set_location('Leaving:'||l_proc, 1000);
974:
975: return l_col_val;
976:

Line 973: hr_utility.set_location('Leaving:'||l_proc, 1000);

969:
970: l_col_val := l_front||l_col_val||l_back;
971:
972: hr_utility.set_location('Col Val : '||l_col_val, 10);
973: hr_utility.set_location('Leaving:'||l_proc, 1000);
974:
975: return l_col_val;
976:
977:

Line 1015: hr_utility.set_location('Entering:'||l_proc, 5);

1011: i number(10) := 0;
1012: j number(10) := 0;
1013: --
1014: BEGIN
1015: hr_utility.set_location('Entering:'||l_proc, 5);
1016:
1017: -- parse the where_clause and populate the PL/SQL table
1018: parse_string
1019: ( p_string_in => p_where_clause_in,

Line 1040: hr_utility.set_location('Adding row:'||to_char(l_next),10);

1036: END LOOP;
1037: END IF;
1038: If not l_found then
1039: l_next := nvl(g_refresh_tab_all.COUNT,0);
1040: hr_utility.set_location('Adding row:'||to_char(l_next),10);
1041: g_refresh_tab_all(l_next).column_name := g_refresh_tab(i).column_name;
1042: g_refresh_tab_all(l_next).txn_val := g_refresh_tab(i).txn_val;
1043: g_refresh_tab_all(l_next).column_type := g_refresh_tab(i).column_type;
1044: End if;

Line 1055: hr_utility.set_location('Parameter:'||l_atoms_tab(table_row),11);

1051:
1052: FOR table_row IN NVL(l_atoms_tab.FIRST,0)..NVL(l_atoms_tab.LAST,-1)
1053: LOOP
1054: IF substr(NVL (l_atoms_tab(table_row), 'NULL') ,1,1) = '<' THEN
1055: hr_utility.set_location('Parameter:'||l_atoms_tab(table_row),11);
1056: l_key_column := substr(l_atoms_tab(table_row),2,(LENGTH(LTRIM(RTRIM(l_atoms_tab(table_row)))) - 2)) ;
1057: l_key_col_null := l_atoms_tab(table_row -4);
1058:
1059: -- depending on the flag get the param value

Line 1067: hr_utility.set_location(l_key_column||' = '||l_key_val,15);

1063: ELSE
1064: -- this is shadow OR main table
1065: -- for the above key_column name get the value from the array
1066: l_key_val := get_value_from_array(p_column_name => l_key_column);
1067: hr_utility.set_location(l_key_column||' = '||l_key_val,15);
1068: -- if value is null pass the column name
1069: IF RTRIM(l_key_val) IS NULL THEN
1070: l_key_val := l_key_col_null;
1071: END IF;

Line 1089: hr_utility.set_location('Leaving:'||l_proc, 1000);

1085: END LOOP;
1086:
1087: -- assign the out parameter the final where string
1088: p_where_clause_out := l_where_out;
1089: hr_utility.set_location('Leaving:'||l_proc, 1000);
1090:
1091: EXCEPTION
1092: WHEN OTHERS THEN
1093: p_where_clause_out := null;

Line 1094: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1090:
1091: EXCEPTION
1092: WHEN OTHERS THEN
1093: p_where_clause_out := null;
1094: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1095: hr_utility.set_message_token('ROUTINE', l_proc);
1096: hr_utility.set_message_token('REASON', SQLERRM);
1097: hr_utility.raise_error;
1098: END replace_where_params;

Line 1095: hr_utility.set_message_token('ROUTINE', l_proc);

1091: EXCEPTION
1092: WHEN OTHERS THEN
1093: p_where_clause_out := null;
1094: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1095: hr_utility.set_message_token('ROUTINE', l_proc);
1096: hr_utility.set_message_token('REASON', SQLERRM);
1097: hr_utility.raise_error;
1098: END replace_where_params;
1099:

Line 1096: hr_utility.set_message_token('REASON', SQLERRM);

1092: WHEN OTHERS THEN
1093: p_where_clause_out := null;
1094: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1095: hr_utility.set_message_token('ROUTINE', l_proc);
1096: hr_utility.set_message_token('REASON', SQLERRM);
1097: hr_utility.raise_error;
1098: END replace_where_params;
1099:
1100: /*----------------------------------------------------------------

Line 1097: hr_utility.raise_error;

1093: p_where_clause_out := null;
1094: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1095: hr_utility.set_message_token('ROUTINE', l_proc);
1096: hr_utility.set_message_token('REASON', SQLERRM);
1097: hr_utility.raise_error;
1098: END replace_where_params;
1099:
1100: /*----------------------------------------------------------------
1101: || PROCEDURE : replace_where_params_purge

Line 1131: hr_utility.set_location('Entering:'||l_proc, 5);

1127: l_key_col_null VARCHAR2(8000);
1128:
1129:
1130: BEGIN
1131: hr_utility.set_location('Entering:'||l_proc, 5);
1132:
1133: -- parse the where_clause and populate the PL/SQL table
1134: parse_string
1135: ( p_string_in => p_where_clause_in,

Line 1178: hr_utility.set_location('Leaving:'||l_proc, 1000);

1174: END LOOP;
1175:
1176: -- assign the out parameter the final where string
1177: p_where_clause_out := l_where_out;
1178: hr_utility.set_location('Leaving:'||l_proc, 1000);
1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: p_where_clause_out := null;

Line 1183: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: p_where_clause_out := null;
1183: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1184: hr_utility.set_message_token('ROUTINE', l_proc);
1185: hr_utility.set_message_token('REASON', SQLERRM);
1186: hr_utility.raise_error;
1187: END replace_where_params_purge;

Line 1184: hr_utility.set_message_token('ROUTINE', l_proc);

1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: p_where_clause_out := null;
1183: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1184: hr_utility.set_message_token('ROUTINE', l_proc);
1185: hr_utility.set_message_token('REASON', SQLERRM);
1186: hr_utility.raise_error;
1187: END replace_where_params_purge;
1188:

Line 1185: hr_utility.set_message_token('REASON', SQLERRM);

1181: WHEN OTHERS THEN
1182: p_where_clause_out := null;
1183: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1184: hr_utility.set_message_token('ROUTINE', l_proc);
1185: hr_utility.set_message_token('REASON', SQLERRM);
1186: hr_utility.raise_error;
1187: END replace_where_params_purge;
1188:
1189: /*----------------------------------------------------------------

Line 1186: hr_utility.raise_error;

1182: p_where_clause_out := null;
1183: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1184: hr_utility.set_message_token('ROUTINE', l_proc);
1185: hr_utility.set_message_token('REASON', SQLERRM);
1186: hr_utility.raise_error;
1187: END replace_where_params_purge;
1188:
1189: /*----------------------------------------------------------------
1190: || PROCEDURE : get_all_rows

Line 1223: hr_utility.set_location('Entering:'||l_proc, 5);

1219: l_tot_cnt number :=1; -- index of the OUT array p_all_txn_rows
1220:
1221:
1222: BEGIN
1223: hr_utility.set_location('Entering:'||l_proc, 5);
1224:
1225: -- construct the query string
1226: l_qry_string := p_select_stmt||' FROM '||
1227: p_from_clause||' WHERE '||

Line 1230: hr_utility.set_location('Qry Str : ',5);

1226: l_qry_string := p_select_stmt||' FROM '||
1227: p_from_clause||' WHERE '||
1228: p_where_clause ;
1229:
1230: hr_utility.set_location('Qry Str : ',5);
1231:
1232: hr_utility.set_location(substr(l_qry_string,1,50), 10);
1233: hr_utility.set_location(substr(l_qry_string,51,50), 10);
1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);

Line 1232: hr_utility.set_location(substr(l_qry_string,1,50), 10);

1228: p_where_clause ;
1229:
1230: hr_utility.set_location('Qry Str : ',5);
1231:
1232: hr_utility.set_location(substr(l_qry_string,1,50), 10);
1233: hr_utility.set_location(substr(l_qry_string,51,50), 10);
1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);
1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);
1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);

Line 1233: hr_utility.set_location(substr(l_qry_string,51,50), 10);

1229:
1230: hr_utility.set_location('Qry Str : ',5);
1231:
1232: hr_utility.set_location(substr(l_qry_string,1,50), 10);
1233: hr_utility.set_location(substr(l_qry_string,51,50), 10);
1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);
1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);
1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);
1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);

Line 1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);

1230: hr_utility.set_location('Qry Str : ',5);
1231:
1232: hr_utility.set_location(substr(l_qry_string,1,50), 10);
1233: hr_utility.set_location(substr(l_qry_string,51,50), 10);
1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);
1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);
1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);
1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);
1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);

Line 1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);

1231:
1232: hr_utility.set_location(substr(l_qry_string,1,50), 10);
1233: hr_utility.set_location(substr(l_qry_string,51,50), 10);
1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);
1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);
1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);
1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);
1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);
1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);

Line 1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);

1232: hr_utility.set_location(substr(l_qry_string,1,50), 10);
1233: hr_utility.set_location(substr(l_qry_string,51,50), 10);
1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);
1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);
1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);
1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);
1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);
1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);
1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);

Line 1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);

1233: hr_utility.set_location(substr(l_qry_string,51,50), 10);
1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);
1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);
1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);
1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);
1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);
1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);
1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);
1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);

Line 1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);

1234: hr_utility.set_location(substr(l_qry_string,101,50), 10);
1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);
1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);
1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);
1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);
1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);
1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);
1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);
1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);

Line 1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);

1235: hr_utility.set_location(substr(l_qry_string,151,50), 10);
1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);
1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);
1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);
1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);
1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);
1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);
1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);
1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);

Line 1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);

1236: hr_utility.set_location(substr(l_qry_string,201,50), 10);
1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);
1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);
1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);
1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);
1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);
1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);
1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);
1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);

Line 1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);

1237: hr_utility.set_location(substr(l_qry_string,251,50), 10);
1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);
1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);
1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);
1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);
1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);
1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);
1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);
1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);

Line 1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);

1238: hr_utility.set_location(substr(l_qry_string,301,50), 10);
1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);
1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);
1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);
1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);
1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);
1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);
1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);
1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);

Line 1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);

1239: hr_utility.set_location(substr(l_qry_string,351,50), 10);
1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);
1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);
1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);
1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);
1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);
1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);
1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);
1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);

Line 1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);

1240: hr_utility.set_location(substr(l_qry_string,401,50), 10);
1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);
1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);
1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);
1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);
1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);
1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);
1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);
1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);

Line 1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);

1241: hr_utility.set_location(substr(l_qry_string,451,50), 10);
1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);
1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);
1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);
1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);
1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);
1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);
1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);
1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);

Line 1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);

1242: hr_utility.set_location(substr(l_qry_string,501,50), 10);
1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);
1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);
1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);
1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);
1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);
1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);
1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);
1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);

Line 1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);

1243: hr_utility.set_location(substr(l_qry_string,551,50), 10);
1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);
1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);
1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);
1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);
1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);
1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);
1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);
1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);

Line 1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);

1244: hr_utility.set_location(substr(l_qry_string,601,50), 10);
1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);
1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);
1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);
1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);
1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);
1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);
1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);
1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);

Line 1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);

1245: hr_utility.set_location(substr(l_qry_string,651,50), 10);
1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);
1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);
1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);
1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);
1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);
1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);
1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);
1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);

Line 1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);

1246: hr_utility.set_location(substr(l_qry_string,701,50), 10);
1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);
1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);
1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);
1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);
1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);
1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);
1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);
1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);

Line 1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);

1247: hr_utility.set_location(substr(l_qry_string,751,50), 10);
1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);
1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);
1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);
1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);
1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);
1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);
1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);
1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);

Line 1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);

1248: hr_utility.set_location(substr(l_qry_string,801,50), 10);
1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);
1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);
1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);
1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);
1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);
1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);
1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);
1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);

Line 1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);

1249: hr_utility.set_location(substr(l_qry_string,851,50), 10);
1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);
1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);
1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);
1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);
1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);
1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);
1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);
1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);

Line 1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);

1250: hr_utility.set_location(substr(l_qry_string,901,50), 10);
1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);
1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);
1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);
1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);
1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);
1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);
1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);
1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);

Line 1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);

1251: hr_utility.set_location(substr(l_qry_string,951,50), 10);
1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);
1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);
1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);
1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);
1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);
1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);
1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);
1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);

Line 1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);

1252: hr_utility.set_location(substr(l_qry_string,1001,50), 10);
1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);
1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);
1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);
1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);
1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);
1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);
1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);
1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);

Line 1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);

1253: hr_utility.set_location(substr(l_qry_string,1051,50), 10);
1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);
1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);
1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);
1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);
1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);
1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);
1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);
1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);

Line 1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);

1254: hr_utility.set_location(substr(l_qry_string,1101,50), 10);
1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);
1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);
1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);
1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);
1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);
1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);
1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);
1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);

Line 1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);

1255: hr_utility.set_location(substr(l_qry_string,1151,50), 10);
1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);
1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);
1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);
1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);
1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);
1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);
1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);
1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);

Line 1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);

1256: hr_utility.set_location(substr(l_qry_string,1201,50), 10);
1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);
1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);
1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);
1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);
1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);
1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);
1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);
1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);

Line 1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);

1257: hr_utility.set_location(substr(l_qry_string,1251,50), 10);
1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);
1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);
1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);
1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);
1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);
1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);
1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);
1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);

Line 1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);

1258: hr_utility.set_location(substr(l_qry_string,1301,50), 10);
1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);
1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);
1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);
1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);
1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);
1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);
1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);
1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);

Line 1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);

1259: hr_utility.set_location(substr(l_qry_string,1351,50), 10);
1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);
1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);
1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);
1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);
1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);
1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);
1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);
1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);

Line 1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);

1260: hr_utility.set_location(substr(l_qry_string,1401,50), 10);
1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);
1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);
1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);
1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);
1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);
1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);
1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);
1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);

Line 1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);

1261: hr_utility.set_location(substr(l_qry_string,1451,50), 10);
1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);
1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);
1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);
1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);
1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);
1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);
1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);
1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);

Line 1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);

1262: hr_utility.set_location(substr(l_qry_string,1501,50), 10);
1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);
1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);
1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);
1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);
1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);
1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);
1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);
1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);

Line 1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);

1263: hr_utility.set_location(substr(l_qry_string,1551,50), 10);
1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);
1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);
1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);
1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);
1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);
1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);
1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);
1271: hr_utility.set_location(substr(l_qry_string,1951,50), 10);

Line 1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);

1264: hr_utility.set_location(substr(l_qry_string,1601,50), 10);
1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);
1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);
1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);
1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);
1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);
1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);
1271: hr_utility.set_location(substr(l_qry_string,1951,50), 10);
1272: hr_utility.set_location(substr(l_qry_string,2001,50), 10);

Line 1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);

1265: hr_utility.set_location(substr(l_qry_string,1651,50), 10);
1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);
1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);
1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);
1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);
1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);
1271: hr_utility.set_location(substr(l_qry_string,1951,50), 10);
1272: hr_utility.set_location(substr(l_qry_string,2001,50), 10);
1273: hr_utility.set_location(substr(l_qry_string,2051,50), 10);

Line 1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);

1266: hr_utility.set_location(substr(l_qry_string,1701,50), 10);
1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);
1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);
1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);
1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);
1271: hr_utility.set_location(substr(l_qry_string,1951,50), 10);
1272: hr_utility.set_location(substr(l_qry_string,2001,50), 10);
1273: hr_utility.set_location(substr(l_qry_string,2051,50), 10);
1274:

Line 1271: hr_utility.set_location(substr(l_qry_string,1951,50), 10);

1267: hr_utility.set_location(substr(l_qry_string,1751,50), 10);
1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);
1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);
1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);
1271: hr_utility.set_location(substr(l_qry_string,1951,50), 10);
1272: hr_utility.set_location(substr(l_qry_string,2001,50), 10);
1273: hr_utility.set_location(substr(l_qry_string,2051,50), 10);
1274:
1275:

Line 1272: hr_utility.set_location(substr(l_qry_string,2001,50), 10);

1268: hr_utility.set_location(substr(l_qry_string,1801,50), 10);
1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);
1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);
1271: hr_utility.set_location(substr(l_qry_string,1951,50), 10);
1272: hr_utility.set_location(substr(l_qry_string,2001,50), 10);
1273: hr_utility.set_location(substr(l_qry_string,2051,50), 10);
1274:
1275:
1276: -- open the cursor

Line 1273: hr_utility.set_location(substr(l_qry_string,2051,50), 10);

1269: hr_utility.set_location(substr(l_qry_string,1851,50), 10);
1270: hr_utility.set_location(substr(l_qry_string,1901,50), 10);
1271: hr_utility.set_location(substr(l_qry_string,1951,50), 10);
1272: hr_utility.set_location(substr(l_qry_string,2001,50), 10);
1273: hr_utility.set_location(substr(l_qry_string,2051,50), 10);
1274:
1275:
1276: -- open the cursor
1277: c := dbms_sql.open_cursor;

Line 1279: hr_utility.set_location('Opened Cursor : '||c, 10);

1275:
1276: -- open the cursor
1277: c := dbms_sql.open_cursor;
1278:
1279: hr_utility.set_location('Opened Cursor : '||c, 10);
1280:
1281:
1282: -- parse the select stmt for errors
1283: dbms_sql.parse(c,l_qry_string, dbms_sql.native);

Line 1285: hr_utility.set_location('Parsed Query String :', 15);

1281:
1282: -- parse the select stmt for errors
1283: dbms_sql.parse(c,l_qry_string, dbms_sql.native);
1284:
1285: hr_utility.set_location('Parsed Query String :', 15);
1286:
1287: -- for ALL COLUMNS we will LOOP one column at a time and build the
1288: -- total array
1289:

Line 1293: -- hr_utility.set_location('Inside first Loop : ', 16);

1289:
1290: FOR j in 1..p_total_columns
1291: LOOP
1292:
1293: -- hr_utility.set_location('Inside first Loop : ', 16);
1294:
1295: -- define v_tab array to hold all the column values
1296: dbms_sql.define_array(c,j,v_tab,1, indx);
1297:

Line 1298: -- hr_utility.set_location('Defining Array : ', 18);

1294:
1295: -- define v_tab array to hold all the column values
1296: dbms_sql.define_array(c,j,v_tab,1, indx);
1297:
1298: -- hr_utility.set_location('Defining Array : ', 18);
1299:
1300: -- execute the dynamic select for all rows
1301: -- this will fetch the j th column values in the v_tab array
1302: d := dbms_sql.execute(c);

Line 1304: -- hr_utility.set_location('Sql Execute : '||d, 20);

1300: -- execute the dynamic select for all rows
1301: -- this will fetch the j th column values in the v_tab array
1302: d := dbms_sql.execute(c);
1303:
1304: -- hr_utility.set_location('Sql Execute : '||d, 20);
1305:
1306: LOOP
1307: d := dbms_sql.fetch_rows(c);
1308:

Line 1309: -- hr_utility.set_location('Fetched rows : '||d, 25);

1305:
1306: LOOP
1307: d := dbms_sql.fetch_rows(c);
1308:
1309: -- hr_utility.set_location('Fetched rows : '||d, 25);
1310:
1311: EXIT WHEN d <> 1;
1312: l_tot_rows_fetch := l_tot_rows_fetch + 1;
1313: -- associate the fetch value with v_tab

Line 1317: -- hr_utility.set_location('After exec Loop : ', 30);

1313: -- associate the fetch value with v_tab
1314: dbms_sql.column_value(c, j, v_tab);
1315: END LOOP;
1316:
1317: -- hr_utility.set_location('After exec Loop : ', 30);
1318:
1319: -- populate the OUT array with the v_tab values for each column
1320: -- we do this as the v_tab array index resets for each column
1321: -- eg : if we have 5 rows and 10 columns the the index resets fro 1 to 5

Line 1327: -- hr_utility.set_location('Inside v_tab loop : ', 31);

1323:
1324: FOR i in NVL(v_tab.FIRST,0)..NVL(v_tab.LAST,-1)
1325: LOOP
1326:
1327: -- hr_utility.set_location('Inside v_tab loop : ', 31);
1328: -- hr_utility.set_location('Table Val :'||v_tab(i), 32);
1329: -- hr_utility.set_location('Inside v_tab loop : ', 33);
1330:
1331: -- dbms_output.put_line('tab Value :'||i||' '||v_tab(i) );

Line 1328: -- hr_utility.set_location('Table Val :'||v_tab(i), 32);

1324: FOR i in NVL(v_tab.FIRST,0)..NVL(v_tab.LAST,-1)
1325: LOOP
1326:
1327: -- hr_utility.set_location('Inside v_tab loop : ', 31);
1328: -- hr_utility.set_location('Table Val :'||v_tab(i), 32);
1329: -- hr_utility.set_location('Inside v_tab loop : ', 33);
1330:
1331: -- dbms_output.put_line('tab Value :'||i||' '||v_tab(i) );
1332:

Line 1329: -- hr_utility.set_location('Inside v_tab loop : ', 33);

1325: LOOP
1326:
1327: -- hr_utility.set_location('Inside v_tab loop : ', 31);
1328: -- hr_utility.set_location('Table Val :'||v_tab(i), 32);
1329: -- hr_utility.set_location('Inside v_tab loop : ', 33);
1330:
1331: -- dbms_output.put_line('tab Value :'||i||' '||v_tab(i) );
1332:
1333: p_all_txn_rows(l_tot_cnt) := v_tab(i);

Line 1337: -- hr_utility.set_location('After second Loop : ', 35);

1333: p_all_txn_rows(l_tot_cnt) := v_tab(i);
1334: l_tot_cnt := l_tot_cnt + 1;
1335: END LOOP;
1336:
1337: -- hr_utility.set_location('After second Loop : ', 35);
1338:
1339: END LOOP; -- for all columns
1340:
1341:

Line 1346: hr_utility.set_location('Total Rows :'||p_total_rows, 50);

1342: -- compute the total rows OUT variable
1343: p_total_rows := l_tot_rows_fetch/p_total_columns ;
1344:
1345: -- dbms_output.put_line('Total Rows : '||tot_rows);
1346: hr_utility.set_location('Total Rows :'||p_total_rows, 50);
1347:
1348: -- close the cursor
1349: dbms_sql.close_cursor(c);
1350: hr_utility.set_location('Leaving:'||l_proc, 1000);

Line 1350: hr_utility.set_location('Leaving:'||l_proc, 1000);

1346: hr_utility.set_location('Total Rows :'||p_total_rows, 50);
1347:
1348: -- close the cursor
1349: dbms_sql.close_cursor(c);
1350: hr_utility.set_location('Leaving:'||l_proc, 1000);
1351:
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

Line 1354: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1350: hr_utility.set_location('Leaving:'||l_proc, 1000);
1351:
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1355: hr_utility.set_message_token('ROUTINE', l_proc);
1356: hr_utility.set_message_token('REASON', SQLERRM);
1357: hr_utility.raise_error;
1358: END get_all_rows;

Line 1355: hr_utility.set_message_token('ROUTINE', l_proc);

1351:
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1355: hr_utility.set_message_token('ROUTINE', l_proc);
1356: hr_utility.set_message_token('REASON', SQLERRM);
1357: hr_utility.raise_error;
1358: END get_all_rows;
1359:

Line 1356: hr_utility.set_message_token('REASON', SQLERRM);

1352: EXCEPTION
1353: WHEN OTHERS THEN
1354: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1355: hr_utility.set_message_token('ROUTINE', l_proc);
1356: hr_utility.set_message_token('REASON', SQLERRM);
1357: hr_utility.raise_error;
1358: END get_all_rows;
1359:
1360:

Line 1357: hr_utility.raise_error;

1353: WHEN OTHERS THEN
1354: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1355: hr_utility.set_message_token('ROUTINE', l_proc);
1356: hr_utility.set_message_token('REASON', SQLERRM);
1357: hr_utility.raise_error;
1358: END get_all_rows;
1359:
1360:
1361:

Line 1390: hr_utility.set_location('Entering:'||l_proc, 5);

1386: l_proc varchar2(72) := g_package||'compute_updt_flag';
1387:
1388:
1389: BEGIN
1390: hr_utility.set_location('Entering:'||l_proc, 5);
1391:
1392: -- loop thru the g_refresh_tab array
1393: FOR i IN NVL(g_refresh_tab.FIRST,0)..NVL(g_refresh_tab.LAST,-1)
1394: LOOP

Line 1422: hr_utility.set_location('Col Name : '||g_refresh_tab(i).column_name,100);

1418: g_refresh_tab(i).updt_flag := 'N';
1419: END IF;
1420:
1421: /*
1422: hr_utility.set_location('Col Name : '||g_refresh_tab(i).column_name,100);
1423: hr_utility.set_location('Col Type : '||g_refresh_tab(i).column_type,100);
1424: hr_utility.set_location('Refresh Flag : '||g_refresh_tab(i).refresh_flag,100);
1425: hr_utility.set_location('Txn Val : '||g_refresh_tab(i).txn_val,100);
1426: hr_utility.set_location('Shadow Val : '||g_refresh_tab(i).shadow_val,100);

Line 1423: hr_utility.set_location('Col Type : '||g_refresh_tab(i).column_type,100);

1419: END IF;
1420:
1421: /*
1422: hr_utility.set_location('Col Name : '||g_refresh_tab(i).column_name,100);
1423: hr_utility.set_location('Col Type : '||g_refresh_tab(i).column_type,100);
1424: hr_utility.set_location('Refresh Flag : '||g_refresh_tab(i).refresh_flag,100);
1425: hr_utility.set_location('Txn Val : '||g_refresh_tab(i).txn_val,100);
1426: hr_utility.set_location('Shadow Val : '||g_refresh_tab(i).shadow_val,100);
1427: hr_utility.set_location('Pos Val : '||g_refresh_tab(i).main_val,100);

Line 1424: hr_utility.set_location('Refresh Flag : '||g_refresh_tab(i).refresh_flag,100);

1420:
1421: /*
1422: hr_utility.set_location('Col Name : '||g_refresh_tab(i).column_name,100);
1423: hr_utility.set_location('Col Type : '||g_refresh_tab(i).column_type,100);
1424: hr_utility.set_location('Refresh Flag : '||g_refresh_tab(i).refresh_flag,100);
1425: hr_utility.set_location('Txn Val : '||g_refresh_tab(i).txn_val,100);
1426: hr_utility.set_location('Shadow Val : '||g_refresh_tab(i).shadow_val,100);
1427: hr_utility.set_location('Pos Val : '||g_refresh_tab(i).main_val,100);
1428: hr_utility.set_location('Updt Flag : '||g_refresh_tab(i).updt_flag,100);

Line 1425: hr_utility.set_location('Txn Val : '||g_refresh_tab(i).txn_val,100);

1421: /*
1422: hr_utility.set_location('Col Name : '||g_refresh_tab(i).column_name,100);
1423: hr_utility.set_location('Col Type : '||g_refresh_tab(i).column_type,100);
1424: hr_utility.set_location('Refresh Flag : '||g_refresh_tab(i).refresh_flag,100);
1425: hr_utility.set_location('Txn Val : '||g_refresh_tab(i).txn_val,100);
1426: hr_utility.set_location('Shadow Val : '||g_refresh_tab(i).shadow_val,100);
1427: hr_utility.set_location('Pos Val : '||g_refresh_tab(i).main_val,100);
1428: hr_utility.set_location('Updt Flag : '||g_refresh_tab(i).updt_flag,100);
1429: */

Line 1426: hr_utility.set_location('Shadow Val : '||g_refresh_tab(i).shadow_val,100);

1422: hr_utility.set_location('Col Name : '||g_refresh_tab(i).column_name,100);
1423: hr_utility.set_location('Col Type : '||g_refresh_tab(i).column_type,100);
1424: hr_utility.set_location('Refresh Flag : '||g_refresh_tab(i).refresh_flag,100);
1425: hr_utility.set_location('Txn Val : '||g_refresh_tab(i).txn_val,100);
1426: hr_utility.set_location('Shadow Val : '||g_refresh_tab(i).shadow_val,100);
1427: hr_utility.set_location('Pos Val : '||g_refresh_tab(i).main_val,100);
1428: hr_utility.set_location('Updt Flag : '||g_refresh_tab(i).updt_flag,100);
1429: */
1430:

Line 1427: hr_utility.set_location('Pos Val : '||g_refresh_tab(i).main_val,100);

1423: hr_utility.set_location('Col Type : '||g_refresh_tab(i).column_type,100);
1424: hr_utility.set_location('Refresh Flag : '||g_refresh_tab(i).refresh_flag,100);
1425: hr_utility.set_location('Txn Val : '||g_refresh_tab(i).txn_val,100);
1426: hr_utility.set_location('Shadow Val : '||g_refresh_tab(i).shadow_val,100);
1427: hr_utility.set_location('Pos Val : '||g_refresh_tab(i).main_val,100);
1428: hr_utility.set_location('Updt Flag : '||g_refresh_tab(i).updt_flag,100);
1429: */
1430:
1431: END LOOP;

Line 1428: hr_utility.set_location('Updt Flag : '||g_refresh_tab(i).updt_flag,100);

1424: hr_utility.set_location('Refresh Flag : '||g_refresh_tab(i).refresh_flag,100);
1425: hr_utility.set_location('Txn Val : '||g_refresh_tab(i).txn_val,100);
1426: hr_utility.set_location('Shadow Val : '||g_refresh_tab(i).shadow_val,100);
1427: hr_utility.set_location('Pos Val : '||g_refresh_tab(i).main_val,100);
1428: hr_utility.set_location('Updt Flag : '||g_refresh_tab(i).updt_flag,100);
1429: */
1430:
1431: END LOOP;
1432: hr_utility.set_location('Leaving:'||l_proc, 1000);

Line 1432: hr_utility.set_location('Leaving:'||l_proc, 1000);

1428: hr_utility.set_location('Updt Flag : '||g_refresh_tab(i).updt_flag,100);
1429: */
1430:
1431: END LOOP;
1432: hr_utility.set_location('Leaving:'||l_proc, 1000);
1433:
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

Line 1436: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1432: hr_utility.set_location('Leaving:'||l_proc, 1000);
1433:
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1437: hr_utility.set_message_token('ROUTINE', l_proc);
1438: hr_utility.set_message_token('REASON', SQLERRM);
1439: hr_utility.raise_error;
1440: END compute_updt_flag;

Line 1437: hr_utility.set_message_token('ROUTINE', l_proc);

1433:
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1437: hr_utility.set_message_token('ROUTINE', l_proc);
1438: hr_utility.set_message_token('REASON', SQLERRM);
1439: hr_utility.raise_error;
1440: END compute_updt_flag;
1441:

Line 1438: hr_utility.set_message_token('REASON', SQLERRM);

1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1437: hr_utility.set_message_token('ROUTINE', l_proc);
1438: hr_utility.set_message_token('REASON', SQLERRM);
1439: hr_utility.raise_error;
1440: END compute_updt_flag;
1441:
1442:

Line 1439: hr_utility.raise_error;

1435: WHEN OTHERS THEN
1436: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1437: hr_utility.set_message_token('ROUTINE', l_proc);
1438: hr_utility.set_message_token('REASON', SQLERRM);
1439: hr_utility.raise_error;
1440: END compute_updt_flag;
1441:
1442:
1443:

Line 1474: hr_utility.set_location('Entering:'||l_proc, 5);

1470: l_front VARCHAR2(100);
1471: l_back VARCHAR2(100);
1472:
1473: BEGIN
1474: hr_utility.set_location('Entering:'||l_proc, 5);
1475: hr_utility.set_location('p_column_name : '||p_column_name, 5);
1476: hr_utility.set_location('p_column_type : '||p_column_type, 5);
1477: hr_utility.set_location('p_column_val : '||p_column_val, 5);
1478: hr_utility.set_location('from_txn : '||p_from_clause_txn, 5);

Line 1475: hr_utility.set_location('p_column_name : '||p_column_name, 5);

1471: l_back VARCHAR2(100);
1472:
1473: BEGIN
1474: hr_utility.set_location('Entering:'||l_proc, 5);
1475: hr_utility.set_location('p_column_name : '||p_column_name, 5);
1476: hr_utility.set_location('p_column_type : '||p_column_type, 5);
1477: hr_utility.set_location('p_column_val : '||p_column_val, 5);
1478: hr_utility.set_location('from_txn : '||p_from_clause_txn, 5);
1479: hr_utility.set_location('from_shd : '||p_from_clause_shd, 5);

Line 1476: hr_utility.set_location('p_column_type : '||p_column_type, 5);

1472:
1473: BEGIN
1474: hr_utility.set_location('Entering:'||l_proc, 5);
1475: hr_utility.set_location('p_column_name : '||p_column_name, 5);
1476: hr_utility.set_location('p_column_type : '||p_column_type, 5);
1477: hr_utility.set_location('p_column_val : '||p_column_val, 5);
1478: hr_utility.set_location('from_txn : '||p_from_clause_txn, 5);
1479: hr_utility.set_location('from_shd : '||p_from_clause_shd, 5);
1480: hr_utility.set_location('rep__shd : '||p_rep_where_clause_shd, 5);

Line 1477: hr_utility.set_location('p_column_val : '||p_column_val, 5);

1473: BEGIN
1474: hr_utility.set_location('Entering:'||l_proc, 5);
1475: hr_utility.set_location('p_column_name : '||p_column_name, 5);
1476: hr_utility.set_location('p_column_type : '||p_column_type, 5);
1477: hr_utility.set_location('p_column_val : '||p_column_val, 5);
1478: hr_utility.set_location('from_txn : '||p_from_clause_txn, 5);
1479: hr_utility.set_location('from_shd : '||p_from_clause_shd, 5);
1480: hr_utility.set_location('rep__shd : '||p_rep_where_clause_shd, 5);
1481:

Line 1478: hr_utility.set_location('from_txn : '||p_from_clause_txn, 5);

1474: hr_utility.set_location('Entering:'||l_proc, 5);
1475: hr_utility.set_location('p_column_name : '||p_column_name, 5);
1476: hr_utility.set_location('p_column_type : '||p_column_type, 5);
1477: hr_utility.set_location('p_column_val : '||p_column_val, 5);
1478: hr_utility.set_location('from_txn : '||p_from_clause_txn, 5);
1479: hr_utility.set_location('from_shd : '||p_from_clause_shd, 5);
1480: hr_utility.set_location('rep__shd : '||p_rep_where_clause_shd, 5);
1481:
1482: l_col_val := p_column_val;

Line 1479: hr_utility.set_location('from_shd : '||p_from_clause_shd, 5);

1475: hr_utility.set_location('p_column_name : '||p_column_name, 5);
1476: hr_utility.set_location('p_column_type : '||p_column_type, 5);
1477: hr_utility.set_location('p_column_val : '||p_column_val, 5);
1478: hr_utility.set_location('from_txn : '||p_from_clause_txn, 5);
1479: hr_utility.set_location('from_shd : '||p_from_clause_shd, 5);
1480: hr_utility.set_location('rep__shd : '||p_rep_where_clause_shd, 5);
1481:
1482: l_col_val := p_column_val;
1483:

Line 1480: hr_utility.set_location('rep__shd : '||p_rep_where_clause_shd, 5);

1476: hr_utility.set_location('p_column_type : '||p_column_type, 5);
1477: hr_utility.set_location('p_column_val : '||p_column_val, 5);
1478: hr_utility.set_location('from_txn : '||p_from_clause_txn, 5);
1479: hr_utility.set_location('from_shd : '||p_from_clause_shd, 5);
1480: hr_utility.set_location('rep__shd : '||p_rep_where_clause_shd, 5);
1481:
1482: l_col_val := p_column_val;
1483:
1484: -- form the front and back packing string

Line 1506: hr_utility.set_location('Update Statement ',10);

1502: -- construct the updt stmt
1503: l_stmt_str := ''; -- initialize string
1504: l_stmt_str := 'UPDATE '||p_from_clause_txn||l_where_clause ;
1505:
1506: hr_utility.set_location('Update Statement ',10);
1507:
1508: hr_utility.set_location(substr(l_stmt_str,1,50), 10);
1509: hr_utility.set_location(substr(l_stmt_str,51,50), 10);
1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);

Line 1508: hr_utility.set_location(substr(l_stmt_str,1,50), 10);

1504: l_stmt_str := 'UPDATE '||p_from_clause_txn||l_where_clause ;
1505:
1506: hr_utility.set_location('Update Statement ',10);
1507:
1508: hr_utility.set_location(substr(l_stmt_str,1,50), 10);
1509: hr_utility.set_location(substr(l_stmt_str,51,50), 10);
1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);
1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);
1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);

Line 1509: hr_utility.set_location(substr(l_stmt_str,51,50), 10);

1505:
1506: hr_utility.set_location('Update Statement ',10);
1507:
1508: hr_utility.set_location(substr(l_stmt_str,1,50), 10);
1509: hr_utility.set_location(substr(l_stmt_str,51,50), 10);
1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);
1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);
1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);
1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);

Line 1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);

1506: hr_utility.set_location('Update Statement ',10);
1507:
1508: hr_utility.set_location(substr(l_stmt_str,1,50), 10);
1509: hr_utility.set_location(substr(l_stmt_str,51,50), 10);
1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);
1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);
1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);
1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);
1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);

Line 1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);

1507:
1508: hr_utility.set_location(substr(l_stmt_str,1,50), 10);
1509: hr_utility.set_location(substr(l_stmt_str,51,50), 10);
1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);
1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);
1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);
1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);
1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);
1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);

Line 1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);

1508: hr_utility.set_location(substr(l_stmt_str,1,50), 10);
1509: hr_utility.set_location(substr(l_stmt_str,51,50), 10);
1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);
1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);
1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);
1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);
1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);
1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);
1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);

Line 1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);

1509: hr_utility.set_location(substr(l_stmt_str,51,50), 10);
1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);
1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);
1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);
1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);
1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);
1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);
1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);
1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);

Line 1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);

1510: hr_utility.set_location(substr(l_stmt_str,101,50), 10);
1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);
1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);
1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);
1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);
1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);
1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);
1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);
1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);

Line 1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);

1511: hr_utility.set_location(substr(l_stmt_str,151,50), 10);
1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);
1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);
1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);
1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);
1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);
1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);
1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);
1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);

Line 1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);

1512: hr_utility.set_location(substr(l_stmt_str,201,50), 10);
1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);
1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);
1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);
1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);
1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);
1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);
1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);
1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);

Line 1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);

1513: hr_utility.set_location(substr(l_stmt_str,251,50), 10);
1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);
1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);
1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);
1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);
1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);
1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);
1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);
1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);

Line 1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);

1514: hr_utility.set_location(substr(l_stmt_str,301,50), 10);
1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);
1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);
1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);
1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);
1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);
1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);
1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);
1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);

Line 1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);

1515: hr_utility.set_location(substr(l_stmt_str,351,50), 10);
1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);
1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);
1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);
1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);
1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);
1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);
1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);
1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);

Line 1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);

1516: hr_utility.set_location(substr(l_stmt_str,401,50), 10);
1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);
1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);
1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);
1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);
1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);
1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);
1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);
1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);

Line 1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);

1517: hr_utility.set_location(substr(l_stmt_str,451,50), 10);
1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);
1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);
1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);
1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);
1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);
1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);
1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);
1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);

Line 1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);

1518: hr_utility.set_location(substr(l_stmt_str,501,50), 10);
1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);
1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);
1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);
1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);
1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);
1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);
1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);
1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);

Line 1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);

1519: hr_utility.set_location(substr(l_stmt_str,551,50), 10);
1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);
1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);
1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);
1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);
1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);
1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);
1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);
1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);

Line 1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);

1520: hr_utility.set_location(substr(l_stmt_str,601,50), 10);
1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);
1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);
1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);
1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);
1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);
1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);
1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);
1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);

Line 1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);

1521: hr_utility.set_location(substr(l_stmt_str,651,50), 10);
1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);
1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);
1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);
1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);
1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);
1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);
1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);
1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);

Line 1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);

1522: hr_utility.set_location(substr(l_stmt_str,701,50), 10);
1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);
1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);
1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);
1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);
1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);
1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);
1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);
1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);

Line 1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);

1523: hr_utility.set_location(substr(l_stmt_str,751,50), 10);
1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);
1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);
1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);
1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);
1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);
1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);
1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);
1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);

Line 1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);

1524: hr_utility.set_location(substr(l_stmt_str,801,50), 10);
1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);
1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);
1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);
1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);
1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);
1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);
1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);
1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);

Line 1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);

1525: hr_utility.set_location(substr(l_stmt_str,851,50), 10);
1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);
1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);
1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);
1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);
1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);
1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);
1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);
1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);

Line 1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);

1526: hr_utility.set_location(substr(l_stmt_str,901,50), 10);
1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);
1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);
1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);
1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);
1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);
1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);
1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);
1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);

Line 1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);

1527: hr_utility.set_location(substr(l_stmt_str,951,50), 10);
1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);
1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);
1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);
1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);
1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);
1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);
1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);
1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);

Line 1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);

1528: hr_utility.set_location(substr(l_stmt_str,1001,50), 10);
1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);
1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);
1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);
1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);
1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);
1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);
1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);
1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);

Line 1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);

1529: hr_utility.set_location(substr(l_stmt_str,1051,50), 10);
1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);
1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);
1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);
1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);
1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);
1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);
1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);
1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);

Line 1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);

1530: hr_utility.set_location(substr(l_stmt_str,1101,50), 10);
1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);
1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);
1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);
1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);
1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);
1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);
1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);
1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);

Line 1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);

1531: hr_utility.set_location(substr(l_stmt_str,1151,50), 10);
1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);
1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);
1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);
1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);
1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);
1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);
1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);
1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);

Line 1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);

1532: hr_utility.set_location(substr(l_stmt_str,1201,50), 10);
1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);
1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);
1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);
1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);
1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);
1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);
1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);
1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);

Line 1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);

1533: hr_utility.set_location(substr(l_stmt_str,1251,50), 10);
1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);
1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);
1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);
1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);
1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);
1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);
1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);
1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);

Line 1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);

1534: hr_utility.set_location(substr(l_stmt_str,1301,50), 10);
1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);
1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);
1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);
1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);
1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);
1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);
1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);
1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);

Line 1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);

1535: hr_utility.set_location(substr(l_stmt_str,1351,50), 10);
1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);
1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);
1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);
1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);
1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);
1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);
1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);
1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);

Line 1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);

1536: hr_utility.set_location(substr(l_stmt_str,1401,50), 10);
1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);
1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);
1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);
1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);
1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);
1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);
1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);
1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);

Line 1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);

1537: hr_utility.set_location(substr(l_stmt_str,1451,50), 10);
1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);
1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);
1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);
1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);
1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);
1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);
1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);
1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);

Line 1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);

1538: hr_utility.set_location(substr(l_stmt_str,1501,50), 10);
1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);
1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);
1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);
1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);
1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);
1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);
1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);
1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);

Line 1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);

1539: hr_utility.set_location(substr(l_stmt_str,1551,50), 10);
1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);
1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);
1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);
1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);
1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);
1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);
1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);
1547: hr_utility.set_location(substr(l_stmt_str,1951,50), 10);

Line 1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);

1540: hr_utility.set_location(substr(l_stmt_str,1601,50), 10);
1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);
1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);
1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);
1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);
1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);
1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);
1547: hr_utility.set_location(substr(l_stmt_str,1951,50), 10);
1548: hr_utility.set_location(substr(l_stmt_str,2001,50), 10);

Line 1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);

1541: hr_utility.set_location(substr(l_stmt_str,1651,50), 10);
1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);
1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);
1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);
1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);
1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);
1547: hr_utility.set_location(substr(l_stmt_str,1951,50), 10);
1548: hr_utility.set_location(substr(l_stmt_str,2001,50), 10);
1549: hr_utility.set_location(substr(l_stmt_str,2051,50), 10);

Line 1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);

1542: hr_utility.set_location(substr(l_stmt_str,1701,50), 10);
1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);
1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);
1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);
1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);
1547: hr_utility.set_location(substr(l_stmt_str,1951,50), 10);
1548: hr_utility.set_location(substr(l_stmt_str,2001,50), 10);
1549: hr_utility.set_location(substr(l_stmt_str,2051,50), 10);
1550:

Line 1547: hr_utility.set_location(substr(l_stmt_str,1951,50), 10);

1543: hr_utility.set_location(substr(l_stmt_str,1751,50), 10);
1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);
1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);
1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);
1547: hr_utility.set_location(substr(l_stmt_str,1951,50), 10);
1548: hr_utility.set_location(substr(l_stmt_str,2001,50), 10);
1549: hr_utility.set_location(substr(l_stmt_str,2051,50), 10);
1550:
1551:

Line 1548: hr_utility.set_location(substr(l_stmt_str,2001,50), 10);

1544: hr_utility.set_location(substr(l_stmt_str,1801,50), 10);
1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);
1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);
1547: hr_utility.set_location(substr(l_stmt_str,1951,50), 10);
1548: hr_utility.set_location(substr(l_stmt_str,2001,50), 10);
1549: hr_utility.set_location(substr(l_stmt_str,2051,50), 10);
1550:
1551:
1552: -- execute the updt stmt

Line 1549: hr_utility.set_location(substr(l_stmt_str,2051,50), 10);

1545: hr_utility.set_location(substr(l_stmt_str,1851,50), 10);
1546: hr_utility.set_location(substr(l_stmt_str,1901,50), 10);
1547: hr_utility.set_location(substr(l_stmt_str,1951,50), 10);
1548: hr_utility.set_location(substr(l_stmt_str,2001,50), 10);
1549: hr_utility.set_location(substr(l_stmt_str,2051,50), 10);
1550:
1551:
1552: -- execute the updt stmt
1553: EXECUTE IMMEDIATE l_stmt_str

Line 1568: hr_utility.set_location('Leaving:'||l_proc, 1000);

1564: EXECUTE IMMEDIATE l_stmt_str
1565: USING l_col_val ;
1566:
1567:
1568: hr_utility.set_location('Leaving:'||l_proc, 1000);
1569:
1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

Line 1572: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1568: hr_utility.set_location('Leaving:'||l_proc, 1000);
1569:
1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1573: hr_utility.set_message_token('ROUTINE', l_proc);
1574: hr_utility.set_message_token('REASON', SQLERRM);
1575: hr_utility.raise_error;
1576: END update_tables;

Line 1573: hr_utility.set_message_token('ROUTINE', l_proc);

1569:
1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1573: hr_utility.set_message_token('ROUTINE', l_proc);
1574: hr_utility.set_message_token('REASON', SQLERRM);
1575: hr_utility.raise_error;
1576: END update_tables;
1577:

Line 1574: hr_utility.set_message_token('REASON', SQLERRM);

1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1573: hr_utility.set_message_token('ROUTINE', l_proc);
1574: hr_utility.set_message_token('REASON', SQLERRM);
1575: hr_utility.raise_error;
1576: END update_tables;
1577:
1578: -- Procedures for PQHPCTXN form Visual Attribute Implementation

Line 1575: hr_utility.raise_error;

1571: WHEN OTHERS THEN
1572: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1573: hr_utility.set_message_token('ROUTINE', l_proc);
1574: hr_utility.set_message_token('REASON', SQLERRM);
1575: hr_utility.raise_error;
1576: END update_tables;
1577:
1578: -- Procedures for PQHPCTXN form Visual Attribute Implementation
1579:

Line 1611: hr_utility.set_location('Entering:'||l_proc, 5);

1607: AND att.refresh_col_name = p_column_name;
1608:
1609: BEGIN
1610:
1611: hr_utility.set_location('Entering:'||l_proc, 5);
1612:
1613: IF NVL(g_refresh_bak.COUNT,0) <> 0 THEN
1614:
1615: FOR i IN NVL(g_refresh_bak.FIRST,0)..NVL(g_refresh_bak.LAST,-1)

Line 1646: hr_utility.set_location('Total Items Changed : '||p_count,9);

1642:
1643: END IF;
1644:
1645:
1646: hr_utility.set_location('Total Items Changed : '||p_count,9);
1647:
1648: hr_utility.set_location('Leaving:'||l_proc, 10);
1649:
1650:

Line 1648: hr_utility.set_location('Leaving:'||l_proc, 10);

1644:
1645:
1646: hr_utility.set_location('Total Items Changed : '||p_count,9);
1647:
1648: hr_utility.set_location('Leaving:'||l_proc, 10);
1649:
1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN

Line 1654: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1650:
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: p_count := null;
1654: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1655: hr_utility.set_message_token('ROUTINE', l_proc);
1656: hr_utility.set_message_token('REASON', SQLERRM);
1657: hr_utility.raise_error;
1658: END count_changed;

Line 1655: hr_utility.set_message_token('ROUTINE', l_proc);

1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: p_count := null;
1654: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1655: hr_utility.set_message_token('ROUTINE', l_proc);
1656: hr_utility.set_message_token('REASON', SQLERRM);
1657: hr_utility.raise_error;
1658: END count_changed;
1659:

Line 1656: hr_utility.set_message_token('REASON', SQLERRM);

1652: WHEN OTHERS THEN
1653: p_count := null;
1654: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1655: hr_utility.set_message_token('ROUTINE', l_proc);
1656: hr_utility.set_message_token('REASON', SQLERRM);
1657: hr_utility.raise_error;
1658: END count_changed;
1659:
1660:

Line 1657: hr_utility.raise_error;

1653: p_count := null;
1654: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1655: hr_utility.set_message_token('ROUTINE', l_proc);
1656: hr_utility.set_message_token('REASON', SQLERRM);
1657: hr_utility.raise_error;
1658: END count_changed;
1659:
1660:
1661:

Line 1682: hr_utility.set_location('Entering:'||l_proc, 5);

1678: l_proc varchar2(72) := g_package||'get_row_prv_calc';
1679:
1680: BEGIN
1681:
1682: hr_utility.set_location('Entering:'||l_proc, 5);
1683:
1684: p_form_column_name := g_attrib_prv_tab(p_row).form_column_name;
1685: p_mode_flag := 'E';
1686: p_reqd_flag := 'C';

Line 1689: hr_utility.set_location('Leaving:'||l_proc, 10);

1685: p_mode_flag := 'E';
1686: p_reqd_flag := 'C';
1687:
1688:
1689: hr_utility.set_location('Leaving:'||l_proc, 10);
1690:
1691: EXCEPTION
1692: WHEN OTHERS THEN
1693: p_form_column_name := null;

Line 1696: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1692: WHEN OTHERS THEN
1693: p_form_column_name := null;
1694: p_mode_flag := null;
1695: p_reqd_flag := null;
1696: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1697: hr_utility.set_message_token('ROUTINE', l_proc);
1698: hr_utility.set_message_token('REASON', SQLERRM);
1699: hr_utility.raise_error;
1700: END get_row_prv_calc;

Line 1697: hr_utility.set_message_token('ROUTINE', l_proc);

1693: p_form_column_name := null;
1694: p_mode_flag := null;
1695: p_reqd_flag := null;
1696: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1697: hr_utility.set_message_token('ROUTINE', l_proc);
1698: hr_utility.set_message_token('REASON', SQLERRM);
1699: hr_utility.raise_error;
1700: END get_row_prv_calc;
1701:

Line 1698: hr_utility.set_message_token('REASON', SQLERRM);

1694: p_mode_flag := null;
1695: p_reqd_flag := null;
1696: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1697: hr_utility.set_message_token('ROUTINE', l_proc);
1698: hr_utility.set_message_token('REASON', SQLERRM);
1699: hr_utility.raise_error;
1700: END get_row_prv_calc;
1701:
1702: -- Procedure to Parse string into atoms

Line 1699: hr_utility.raise_error;

1695: p_reqd_flag := null;
1696: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1697: hr_utility.set_message_token('ROUTINE', l_proc);
1698: hr_utility.set_message_token('REASON', SQLERRM);
1699: hr_utility.raise_error;
1700: END get_row_prv_calc;
1701:
1702: -- Procedure to Parse string into atoms
1703: