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_GENERIC_PURGE dependencies on PQH_REFRESH_DATA

Line 218: pqh_refresh_data.replace_where_params_purge

214: --
215: hr_utility.set_location('where_in:'||substr(l_where_clause_in_txn,1,100),1020);
216: hr_utility.set_location('where_in:'||substr(l_where_clause_in_txn,100,100),1021);
217: --
218: pqh_refresh_data.replace_where_params_purge
219: (p_where_clause_in => l_where_clause_in_txn,
220: p_txn_tab_flag => 'N',
221: p_txn_id => '',
222: p_where_clause_out => l_where_clause_out_txn );

Line 227: pqh_refresh_data.get_all_rows

223: --
224: hr_utility.set_location('where_out:'||substr(l_where_clause_out_txn,1,75),1023);
225: hr_utility.set_location('where_out:'||substr(l_where_clause_out_txn,75,75),1024);
226: --
227: pqh_refresh_data.get_all_rows
228: (p_select_stmt => l_select_stmt,
229: p_from_clause => l_from_clause_txn,
230: p_where_clause => l_where_clause_out_txn,
231: p_total_columns => 1,--Since we are selecting only the primary key only

Line 325: pqh_refresh_data.g_refresh_tab.DELETE;

321: l_proc varchar2(72) := g_package||'populate_pltable';
322: i number := 1;
323: BEGIN
324: hr_utility.set_location('entering: ' ||l_proc,1200);
325: pqh_refresh_data.g_refresh_tab.DELETE;
326: --populate the g_refresh_tab to be used in replace_where_params_purge
327: pqh_refresh_data.g_refresh_tab(1).column_name := paramname1;
328: hr_utility.set_location(paramname1||'-'||get_col_type(paramname1,l_master_tab_route_id)||'-'||l_master_tab_route_id,1201);
329: if get_col_type(paramname1,l_master_tab_route_id) = 'D' then

Line 327: pqh_refresh_data.g_refresh_tab(1).column_name := paramname1;

323: BEGIN
324: hr_utility.set_location('entering: ' ||l_proc,1200);
325: pqh_refresh_data.g_refresh_tab.DELETE;
326: --populate the g_refresh_tab to be used in replace_where_params_purge
327: pqh_refresh_data.g_refresh_tab(1).column_name := paramname1;
328: hr_utility.set_location(paramname1||'-'||get_col_type(paramname1,l_master_tab_route_id)||'-'||l_master_tab_route_id,1201);
329: if get_col_type(paramname1,l_master_tab_route_id) = 'D' then
330: pqh_refresh_data.g_refresh_tab(1).txn_val := ' fnd_date.canonical_to_date('''||paramvalue1||''')';
331: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';

Line 330: pqh_refresh_data.g_refresh_tab(1).txn_val := ' fnd_date.canonical_to_date('''||paramvalue1||''')';

326: --populate the g_refresh_tab to be used in replace_where_params_purge
327: pqh_refresh_data.g_refresh_tab(1).column_name := paramname1;
328: hr_utility.set_location(paramname1||'-'||get_col_type(paramname1,l_master_tab_route_id)||'-'||l_master_tab_route_id,1201);
329: if get_col_type(paramname1,l_master_tab_route_id) = 'D' then
330: pqh_refresh_data.g_refresh_tab(1).txn_val := ' fnd_date.canonical_to_date('''||paramvalue1||''')';
331: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
332: else
333: pqh_refresh_data.g_refresh_tab(1).txn_val := paramvalue1;
334: pqh_refresh_data.g_refresh_tab(1).column_type := get_col_type(paramname1,l_master_tab_route_id);

Line 331: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';

327: pqh_refresh_data.g_refresh_tab(1).column_name := paramname1;
328: hr_utility.set_location(paramname1||'-'||get_col_type(paramname1,l_master_tab_route_id)||'-'||l_master_tab_route_id,1201);
329: if get_col_type(paramname1,l_master_tab_route_id) = 'D' then
330: pqh_refresh_data.g_refresh_tab(1).txn_val := ' fnd_date.canonical_to_date('''||paramvalue1||''')';
331: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
332: else
333: pqh_refresh_data.g_refresh_tab(1).txn_val := paramvalue1;
334: pqh_refresh_data.g_refresh_tab(1).column_type := get_col_type(paramname1,l_master_tab_route_id);
335: end if;

Line 333: pqh_refresh_data.g_refresh_tab(1).txn_val := paramvalue1;

329: if get_col_type(paramname1,l_master_tab_route_id) = 'D' then
330: pqh_refresh_data.g_refresh_tab(1).txn_val := ' fnd_date.canonical_to_date('''||paramvalue1||''')';
331: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
332: else
333: pqh_refresh_data.g_refresh_tab(1).txn_val := paramvalue1;
334: pqh_refresh_data.g_refresh_tab(1).column_type := get_col_type(paramname1,l_master_tab_route_id);
335: end if;
336: pqh_refresh_data.g_refresh_tab(2).column_name := paramname2;
337: hr_utility.set_location(paramname2||'-'||get_col_type(paramname2,l_master_tab_route_id)||'-'||l_master_tab_route_id,1202);

Line 334: pqh_refresh_data.g_refresh_tab(1).column_type := get_col_type(paramname1,l_master_tab_route_id);

330: pqh_refresh_data.g_refresh_tab(1).txn_val := ' fnd_date.canonical_to_date('''||paramvalue1||''')';
331: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
332: else
333: pqh_refresh_data.g_refresh_tab(1).txn_val := paramvalue1;
334: pqh_refresh_data.g_refresh_tab(1).column_type := get_col_type(paramname1,l_master_tab_route_id);
335: end if;
336: pqh_refresh_data.g_refresh_tab(2).column_name := paramname2;
337: hr_utility.set_location(paramname2||'-'||get_col_type(paramname2,l_master_tab_route_id)||'-'||l_master_tab_route_id,1202);
338: if get_col_type(paramname2,l_master_tab_route_id) = 'D' then

Line 336: pqh_refresh_data.g_refresh_tab(2).column_name := paramname2;

332: else
333: pqh_refresh_data.g_refresh_tab(1).txn_val := paramvalue1;
334: pqh_refresh_data.g_refresh_tab(1).column_type := get_col_type(paramname1,l_master_tab_route_id);
335: end if;
336: pqh_refresh_data.g_refresh_tab(2).column_name := paramname2;
337: hr_utility.set_location(paramname2||'-'||get_col_type(paramname2,l_master_tab_route_id)||'-'||l_master_tab_route_id,1202);
338: if get_col_type(paramname2,l_master_tab_route_id) = 'D' then
339: pqh_refresh_data.g_refresh_tab(2).txn_val := ' fnd_date.canonical_to_date('''||paramvalue2||''')';
340: pqh_refresh_data.g_refresh_tab(2).column_type := 'N';

Line 339: pqh_refresh_data.g_refresh_tab(2).txn_val := ' fnd_date.canonical_to_date('''||paramvalue2||''')';

335: end if;
336: pqh_refresh_data.g_refresh_tab(2).column_name := paramname2;
337: hr_utility.set_location(paramname2||'-'||get_col_type(paramname2,l_master_tab_route_id)||'-'||l_master_tab_route_id,1202);
338: if get_col_type(paramname2,l_master_tab_route_id) = 'D' then
339: pqh_refresh_data.g_refresh_tab(2).txn_val := ' fnd_date.canonical_to_date('''||paramvalue2||''')';
340: pqh_refresh_data.g_refresh_tab(2).column_type := 'N';
341: else
342: pqh_refresh_data.g_refresh_tab(2).txn_val := paramvalue2;
343: pqh_refresh_data.g_refresh_tab(2).column_type := get_col_type(paramname2,l_master_tab_route_id);

Line 340: pqh_refresh_data.g_refresh_tab(2).column_type := 'N';

336: pqh_refresh_data.g_refresh_tab(2).column_name := paramname2;
337: hr_utility.set_location(paramname2||'-'||get_col_type(paramname2,l_master_tab_route_id)||'-'||l_master_tab_route_id,1202);
338: if get_col_type(paramname2,l_master_tab_route_id) = 'D' then
339: pqh_refresh_data.g_refresh_tab(2).txn_val := ' fnd_date.canonical_to_date('''||paramvalue2||''')';
340: pqh_refresh_data.g_refresh_tab(2).column_type := 'N';
341: else
342: pqh_refresh_data.g_refresh_tab(2).txn_val := paramvalue2;
343: pqh_refresh_data.g_refresh_tab(2).column_type := get_col_type(paramname2,l_master_tab_route_id);
344: end if;

Line 342: pqh_refresh_data.g_refresh_tab(2).txn_val := paramvalue2;

338: if get_col_type(paramname2,l_master_tab_route_id) = 'D' then
339: pqh_refresh_data.g_refresh_tab(2).txn_val := ' fnd_date.canonical_to_date('''||paramvalue2||''')';
340: pqh_refresh_data.g_refresh_tab(2).column_type := 'N';
341: else
342: pqh_refresh_data.g_refresh_tab(2).txn_val := paramvalue2;
343: pqh_refresh_data.g_refresh_tab(2).column_type := get_col_type(paramname2,l_master_tab_route_id);
344: end if;
345: pqh_refresh_data.g_refresh_tab(3).column_name := paramname3;
346: hr_utility.set_location(paramname3||'-'||get_col_type(paramname3,l_master_tab_route_id)||'-'||l_master_tab_route_id,1203);

Line 343: pqh_refresh_data.g_refresh_tab(2).column_type := get_col_type(paramname2,l_master_tab_route_id);

339: pqh_refresh_data.g_refresh_tab(2).txn_val := ' fnd_date.canonical_to_date('''||paramvalue2||''')';
340: pqh_refresh_data.g_refresh_tab(2).column_type := 'N';
341: else
342: pqh_refresh_data.g_refresh_tab(2).txn_val := paramvalue2;
343: pqh_refresh_data.g_refresh_tab(2).column_type := get_col_type(paramname2,l_master_tab_route_id);
344: end if;
345: pqh_refresh_data.g_refresh_tab(3).column_name := paramname3;
346: hr_utility.set_location(paramname3||'-'||get_col_type(paramname3,l_master_tab_route_id)||'-'||l_master_tab_route_id,1203);
347: if get_col_type(paramname3,l_master_tab_route_id) = 'D' then

Line 345: pqh_refresh_data.g_refresh_tab(3).column_name := paramname3;

341: else
342: pqh_refresh_data.g_refresh_tab(2).txn_val := paramvalue2;
343: pqh_refresh_data.g_refresh_tab(2).column_type := get_col_type(paramname2,l_master_tab_route_id);
344: end if;
345: pqh_refresh_data.g_refresh_tab(3).column_name := paramname3;
346: hr_utility.set_location(paramname3||'-'||get_col_type(paramname3,l_master_tab_route_id)||'-'||l_master_tab_route_id,1203);
347: if get_col_type(paramname3,l_master_tab_route_id) = 'D' then
348: pqh_refresh_data.g_refresh_tab(3).txn_val := ' fnd_date.canonical_to_date('''||paramvalue3||''')';
349: pqh_refresh_data.g_refresh_tab(3).column_type := 'N';

Line 348: pqh_refresh_data.g_refresh_tab(3).txn_val := ' fnd_date.canonical_to_date('''||paramvalue3||''')';

344: end if;
345: pqh_refresh_data.g_refresh_tab(3).column_name := paramname3;
346: hr_utility.set_location(paramname3||'-'||get_col_type(paramname3,l_master_tab_route_id)||'-'||l_master_tab_route_id,1203);
347: if get_col_type(paramname3,l_master_tab_route_id) = 'D' then
348: pqh_refresh_data.g_refresh_tab(3).txn_val := ' fnd_date.canonical_to_date('''||paramvalue3||''')';
349: pqh_refresh_data.g_refresh_tab(3).column_type := 'N';
350: else
351: pqh_refresh_data.g_refresh_tab(3).txn_val := paramvalue3;
352: pqh_refresh_data.g_refresh_tab(3).column_type := get_col_type(paramname3,l_master_tab_route_id);

Line 349: pqh_refresh_data.g_refresh_tab(3).column_type := 'N';

345: pqh_refresh_data.g_refresh_tab(3).column_name := paramname3;
346: hr_utility.set_location(paramname3||'-'||get_col_type(paramname3,l_master_tab_route_id)||'-'||l_master_tab_route_id,1203);
347: if get_col_type(paramname3,l_master_tab_route_id) = 'D' then
348: pqh_refresh_data.g_refresh_tab(3).txn_val := ' fnd_date.canonical_to_date('''||paramvalue3||''')';
349: pqh_refresh_data.g_refresh_tab(3).column_type := 'N';
350: else
351: pqh_refresh_data.g_refresh_tab(3).txn_val := paramvalue3;
352: pqh_refresh_data.g_refresh_tab(3).column_type := get_col_type(paramname3,l_master_tab_route_id);
353: end if;

Line 351: pqh_refresh_data.g_refresh_tab(3).txn_val := paramvalue3;

347: if get_col_type(paramname3,l_master_tab_route_id) = 'D' then
348: pqh_refresh_data.g_refresh_tab(3).txn_val := ' fnd_date.canonical_to_date('''||paramvalue3||''')';
349: pqh_refresh_data.g_refresh_tab(3).column_type := 'N';
350: else
351: pqh_refresh_data.g_refresh_tab(3).txn_val := paramvalue3;
352: pqh_refresh_data.g_refresh_tab(3).column_type := get_col_type(paramname3,l_master_tab_route_id);
353: end if;
354: pqh_refresh_data.g_refresh_tab(4).column_name := paramname4;
355: hr_utility.set_location(paramname4||'-'||get_col_type(paramname4,l_master_tab_route_id)||'-'||l_master_tab_route_id,1204);

Line 352: pqh_refresh_data.g_refresh_tab(3).column_type := get_col_type(paramname3,l_master_tab_route_id);

348: pqh_refresh_data.g_refresh_tab(3).txn_val := ' fnd_date.canonical_to_date('''||paramvalue3||''')';
349: pqh_refresh_data.g_refresh_tab(3).column_type := 'N';
350: else
351: pqh_refresh_data.g_refresh_tab(3).txn_val := paramvalue3;
352: pqh_refresh_data.g_refresh_tab(3).column_type := get_col_type(paramname3,l_master_tab_route_id);
353: end if;
354: pqh_refresh_data.g_refresh_tab(4).column_name := paramname4;
355: hr_utility.set_location(paramname4||'-'||get_col_type(paramname4,l_master_tab_route_id)||'-'||l_master_tab_route_id,1204);
356: if get_col_type(paramname4,l_master_tab_route_id) = 'D' then

Line 354: pqh_refresh_data.g_refresh_tab(4).column_name := paramname4;

350: else
351: pqh_refresh_data.g_refresh_tab(3).txn_val := paramvalue3;
352: pqh_refresh_data.g_refresh_tab(3).column_type := get_col_type(paramname3,l_master_tab_route_id);
353: end if;
354: pqh_refresh_data.g_refresh_tab(4).column_name := paramname4;
355: hr_utility.set_location(paramname4||'-'||get_col_type(paramname4,l_master_tab_route_id)||'-'||l_master_tab_route_id,1204);
356: if get_col_type(paramname4,l_master_tab_route_id) = 'D' then
357: pqh_refresh_data.g_refresh_tab(4).txn_val := ' fnd_date.canonical_to_date('''||paramvalue4||''')';
358: pqh_refresh_data.g_refresh_tab(4).column_type := 'N';

Line 357: pqh_refresh_data.g_refresh_tab(4).txn_val := ' fnd_date.canonical_to_date('''||paramvalue4||''')';

353: end if;
354: pqh_refresh_data.g_refresh_tab(4).column_name := paramname4;
355: hr_utility.set_location(paramname4||'-'||get_col_type(paramname4,l_master_tab_route_id)||'-'||l_master_tab_route_id,1204);
356: if get_col_type(paramname4,l_master_tab_route_id) = 'D' then
357: pqh_refresh_data.g_refresh_tab(4).txn_val := ' fnd_date.canonical_to_date('''||paramvalue4||''')';
358: pqh_refresh_data.g_refresh_tab(4).column_type := 'N';
359: else
360: pqh_refresh_data.g_refresh_tab(4).txn_val := paramvalue4;
361: pqh_refresh_data.g_refresh_tab(4).column_type := get_col_type(paramname4,l_master_tab_route_id);

Line 358: pqh_refresh_data.g_refresh_tab(4).column_type := 'N';

354: pqh_refresh_data.g_refresh_tab(4).column_name := paramname4;
355: hr_utility.set_location(paramname4||'-'||get_col_type(paramname4,l_master_tab_route_id)||'-'||l_master_tab_route_id,1204);
356: if get_col_type(paramname4,l_master_tab_route_id) = 'D' then
357: pqh_refresh_data.g_refresh_tab(4).txn_val := ' fnd_date.canonical_to_date('''||paramvalue4||''')';
358: pqh_refresh_data.g_refresh_tab(4).column_type := 'N';
359: else
360: pqh_refresh_data.g_refresh_tab(4).txn_val := paramvalue4;
361: pqh_refresh_data.g_refresh_tab(4).column_type := get_col_type(paramname4,l_master_tab_route_id);
362: end if;

Line 360: pqh_refresh_data.g_refresh_tab(4).txn_val := paramvalue4;

356: if get_col_type(paramname4,l_master_tab_route_id) = 'D' then
357: pqh_refresh_data.g_refresh_tab(4).txn_val := ' fnd_date.canonical_to_date('''||paramvalue4||''')';
358: pqh_refresh_data.g_refresh_tab(4).column_type := 'N';
359: else
360: pqh_refresh_data.g_refresh_tab(4).txn_val := paramvalue4;
361: pqh_refresh_data.g_refresh_tab(4).column_type := get_col_type(paramname4,l_master_tab_route_id);
362: end if;
363: pqh_refresh_data.g_refresh_tab(5).column_name := paramname5;
364: hr_utility.set_location(paramname5||'-'||get_col_type(paramname5,l_master_tab_route_id)||'-'||l_master_tab_route_id,1205);

Line 361: pqh_refresh_data.g_refresh_tab(4).column_type := get_col_type(paramname4,l_master_tab_route_id);

357: pqh_refresh_data.g_refresh_tab(4).txn_val := ' fnd_date.canonical_to_date('''||paramvalue4||''')';
358: pqh_refresh_data.g_refresh_tab(4).column_type := 'N';
359: else
360: pqh_refresh_data.g_refresh_tab(4).txn_val := paramvalue4;
361: pqh_refresh_data.g_refresh_tab(4).column_type := get_col_type(paramname4,l_master_tab_route_id);
362: end if;
363: pqh_refresh_data.g_refresh_tab(5).column_name := paramname5;
364: hr_utility.set_location(paramname5||'-'||get_col_type(paramname5,l_master_tab_route_id)||'-'||l_master_tab_route_id,1205);
365: if get_col_type(paramname5,l_master_tab_route_id) = 'D' then

Line 363: pqh_refresh_data.g_refresh_tab(5).column_name := paramname5;

359: else
360: pqh_refresh_data.g_refresh_tab(4).txn_val := paramvalue4;
361: pqh_refresh_data.g_refresh_tab(4).column_type := get_col_type(paramname4,l_master_tab_route_id);
362: end if;
363: pqh_refresh_data.g_refresh_tab(5).column_name := paramname5;
364: hr_utility.set_location(paramname5||'-'||get_col_type(paramname5,l_master_tab_route_id)||'-'||l_master_tab_route_id,1205);
365: if get_col_type(paramname5,l_master_tab_route_id) = 'D' then
366: pqh_refresh_data.g_refresh_tab(5).txn_val := ' fnd_date.canonical_to_date('''||paramvalue5||''')';
367: pqh_refresh_data.g_refresh_tab(5).column_type := 'N';

Line 366: pqh_refresh_data.g_refresh_tab(5).txn_val := ' fnd_date.canonical_to_date('''||paramvalue5||''')';

362: end if;
363: pqh_refresh_data.g_refresh_tab(5).column_name := paramname5;
364: hr_utility.set_location(paramname5||'-'||get_col_type(paramname5,l_master_tab_route_id)||'-'||l_master_tab_route_id,1205);
365: if get_col_type(paramname5,l_master_tab_route_id) = 'D' then
366: pqh_refresh_data.g_refresh_tab(5).txn_val := ' fnd_date.canonical_to_date('''||paramvalue5||''')';
367: pqh_refresh_data.g_refresh_tab(5).column_type := 'N';
368: else
369: pqh_refresh_data.g_refresh_tab(5).txn_val := paramvalue5;
370: pqh_refresh_data.g_refresh_tab(5).column_type := get_col_type(paramname5,l_master_tab_route_id);

Line 367: pqh_refresh_data.g_refresh_tab(5).column_type := 'N';

363: pqh_refresh_data.g_refresh_tab(5).column_name := paramname5;
364: hr_utility.set_location(paramname5||'-'||get_col_type(paramname5,l_master_tab_route_id)||'-'||l_master_tab_route_id,1205);
365: if get_col_type(paramname5,l_master_tab_route_id) = 'D' then
366: pqh_refresh_data.g_refresh_tab(5).txn_val := ' fnd_date.canonical_to_date('''||paramvalue5||''')';
367: pqh_refresh_data.g_refresh_tab(5).column_type := 'N';
368: else
369: pqh_refresh_data.g_refresh_tab(5).txn_val := paramvalue5;
370: pqh_refresh_data.g_refresh_tab(5).column_type := get_col_type(paramname5,l_master_tab_route_id);
371: end if;

Line 369: pqh_refresh_data.g_refresh_tab(5).txn_val := paramvalue5;

365: if get_col_type(paramname5,l_master_tab_route_id) = 'D' then
366: pqh_refresh_data.g_refresh_tab(5).txn_val := ' fnd_date.canonical_to_date('''||paramvalue5||''')';
367: pqh_refresh_data.g_refresh_tab(5).column_type := 'N';
368: else
369: pqh_refresh_data.g_refresh_tab(5).txn_val := paramvalue5;
370: pqh_refresh_data.g_refresh_tab(5).column_type := get_col_type(paramname5,l_master_tab_route_id);
371: end if;
372: -- display values of g_refresh_tab array
373:

Line 370: pqh_refresh_data.g_refresh_tab(5).column_type := get_col_type(paramname5,l_master_tab_route_id);

366: pqh_refresh_data.g_refresh_tab(5).txn_val := ' fnd_date.canonical_to_date('''||paramvalue5||''')';
367: pqh_refresh_data.g_refresh_tab(5).column_type := 'N';
368: else
369: pqh_refresh_data.g_refresh_tab(5).txn_val := paramvalue5;
370: pqh_refresh_data.g_refresh_tab(5).column_type := get_col_type(paramname5,l_master_tab_route_id);
371: end if;
372: -- display values of g_refresh_tab array
373:
374: FOR i IN 1..5 LOOP

Line 375: If pqh_refresh_data.g_refresh_tab(i).column_name = 'SHORT_NAME' THEN

371: end if;
372: -- display values of g_refresh_tab array
373:
374: FOR i IN 1..5 LOOP
375: If pqh_refresh_data.g_refresh_tab(i).column_name = 'SHORT_NAME' THEN
376: g_short_name:= pqh_refresh_data.g_refresh_tab(i).txn_val;
377: END IF;
378: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_name,10);
379: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_type,11);

Line 376: g_short_name:= pqh_refresh_data.g_refresh_tab(i).txn_val;

372: -- display values of g_refresh_tab array
373:
374: FOR i IN 1..5 LOOP
375: If pqh_refresh_data.g_refresh_tab(i).column_name = 'SHORT_NAME' THEN
376: g_short_name:= pqh_refresh_data.g_refresh_tab(i).txn_val;
377: END IF;
378: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_name,10);
379: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_type,11);
380: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).txn_val,12);

Line 378: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_name,10);

374: FOR i IN 1..5 LOOP
375: If pqh_refresh_data.g_refresh_tab(i).column_name = 'SHORT_NAME' THEN
376: g_short_name:= pqh_refresh_data.g_refresh_tab(i).txn_val;
377: END IF;
378: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_name,10);
379: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_type,11);
380: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).txn_val,12);
381: END LOOP;
382: hr_utility.set_location('leaving: ' ||l_proc,1300);

Line 379: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_type,11);

375: If pqh_refresh_data.g_refresh_tab(i).column_name = 'SHORT_NAME' THEN
376: g_short_name:= pqh_refresh_data.g_refresh_tab(i).txn_val;
377: END IF;
378: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_name,10);
379: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_type,11);
380: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).txn_val,12);
381: END LOOP;
382: hr_utility.set_location('leaving: ' ||l_proc,1300);
383: END populate_pltable;

Line 380: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).txn_val,12);

376: g_short_name:= pqh_refresh_data.g_refresh_tab(i).txn_val;
377: END IF;
378: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_name,10);
379: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).column_type,11);
380: hr_utility.set_location(pqh_refresh_data.g_refresh_tab(i).txn_val,12);
381: END LOOP;
382: hr_utility.set_location('leaving: ' ||l_proc,1300);
383: END populate_pltable;
384: ----------------------------------------------------------------------------------------------

Line 463: pqh_refresh_data.replace_where_params_purge

459: ,p_primary_key_col => c_pk_col_name);
460:
461: l_select_stmt :='select '|| c_pk_col_name ;
462: hr_utility.set_location('Parent key value '||l_parent_pk_value,20);
463: pqh_refresh_data.replace_where_params_purge
464: ( p_where_clause_in => l_where_clause_in_txn,
465: p_txn_tab_flag => 'Y',
466: p_txn_id => l_parent_pk_value,
467: p_where_clause_out => l_where_clause_out_txn );

Line 469: pqh_refresh_data.get_all_rows

465: p_txn_tab_flag => 'Y',
466: p_txn_id => l_parent_pk_value,
467: p_where_clause_out => l_where_clause_out_txn );
468:
469: pqh_refresh_data.get_all_rows
470: (p_select_stmt => l_select_stmt,
471: p_from_clause => l_from_clause_txn,
472: p_where_clause => l_where_clause_out_txn,
473: p_total_columns => 1,

Line 557: pqh_refresh_data.replace_where_params_purge

553: l_select_stmt := ' select object_version_number ' ;
554: l_where_clause_in_txn := ' c_pk_col_name = ' ;
555: l_where_clause_in_txn := replace(l_where_clause_in_txn , 'c_pk_col_name' , l_pk_col_name);
556: --dbms_output.put_line('after ovn where replace' || l_where_clause_in_txn);
557: pqh_refresh_data.replace_where_params_purge
558: ( p_where_clause_in => l_where_clause_in_txn,
559: p_txn_tab_flag => 'Y',
560: p_txn_id => l_pk_value,
561: p_where_clause_out => l_where_clause_out_txn );

Line 563: pqh_refresh_data.get_all_rows

559: p_txn_tab_flag => 'Y',
560: p_txn_id => l_pk_value,
561: p_where_clause_out => l_where_clause_out_txn );
562: --
563: pqh_refresh_data.get_all_rows
564: (p_select_stmt => l_select_stmt,
565: p_from_clause => l_from_clause_txn,
566: p_where_clause => l_where_clause_out_txn,
567: p_total_columns => 1,

Line 583: pqh_refresh_data.replace_where_params_purge

579: hr_utility.set_location('l_dummy_in'||substr(l_dummy_in,51,50),1720);
580: -- l_dummy_in := replace(l_dummy_in, 'R_OBJECT_VERSION_NUMBER' , l_ovn_value(1));
581:
582: l_dummy_in := replace(l_dummy_in, '', g_effective_date);
583: pqh_refresh_data.replace_where_params_purge
584: ( p_where_clause_in => l_dummy_in,
585: p_txn_tab_flag => 'Y',
586: p_txn_id => l_pk_value,
587: p_where_clause_out => l_dummy_out);

Line 675: pqh_refresh_data.get_all_rows

671: CLOSE csr_err_col_name;
672: L_WHERE_CLAUSE := p_pk_col_name || '=' || p_pk_value;
673:
674: l_from_clause := p_from_clause_txn;
675: pqh_refresh_data.get_all_rows
676: (p_select_stmt => l_select,
677: p_from_clause => l_from_clause,
678: p_where_clause => l_where_clause,
679: p_total_columns => l_tot_columns,