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

Line 345: pqh_refresh_data.g_refresh_tab.delete;

341: end if; -- p_row_count
342: --
343: -- Building where condition with information entered by the user as criteria, l_where hold where string
344: --
345: pqh_refresh_data.g_refresh_tab.delete;
346:
347: if rec.context_business_group_id is not null then
348: pqh_refresh_data.g_refresh_tab(1).column_name := 'BUSINESS_GROUP_ID';
349: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';

Line 348: pqh_refresh_data.g_refresh_tab(1).column_name := 'BUSINESS_GROUP_ID';

344: --
345: pqh_refresh_data.g_refresh_tab.delete;
346:
347: if rec.context_business_group_id is not null then
348: pqh_refresh_data.g_refresh_tab(1).column_name := 'BUSINESS_GROUP_ID';
349: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
350: pqh_refresh_data.g_refresh_tab(1).txn_val := rec.context_business_group_id ;
351: pqh_refresh_data.g_refresh_tab(1).shadow_val := rec.context_business_group_id ;
352: pqh_refresh_data.g_refresh_tab(1).main_val := rec.context_business_group_id ;

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

345: pqh_refresh_data.g_refresh_tab.delete;
346:
347: if rec.context_business_group_id is not null then
348: pqh_refresh_data.g_refresh_tab(1).column_name := 'BUSINESS_GROUP_ID';
349: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
350: pqh_refresh_data.g_refresh_tab(1).txn_val := rec.context_business_group_id ;
351: pqh_refresh_data.g_refresh_tab(1).shadow_val := rec.context_business_group_id ;
352: pqh_refresh_data.g_refresh_tab(1).main_val := rec.context_business_group_id ;
353: pqh_refresh_data.g_refresh_tab(1).refresh_flag := 'N';

Line 350: pqh_refresh_data.g_refresh_tab(1).txn_val := rec.context_business_group_id ;

346:
347: if rec.context_business_group_id is not null then
348: pqh_refresh_data.g_refresh_tab(1).column_name := 'BUSINESS_GROUP_ID';
349: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
350: pqh_refresh_data.g_refresh_tab(1).txn_val := rec.context_business_group_id ;
351: pqh_refresh_data.g_refresh_tab(1).shadow_val := rec.context_business_group_id ;
352: pqh_refresh_data.g_refresh_tab(1).main_val := rec.context_business_group_id ;
353: pqh_refresh_data.g_refresh_tab(1).refresh_flag := 'N';
354: pqh_refresh_data.g_refresh_tab(1).updt_flag := 'N';

Line 351: pqh_refresh_data.g_refresh_tab(1).shadow_val := rec.context_business_group_id ;

347: if rec.context_business_group_id is not null then
348: pqh_refresh_data.g_refresh_tab(1).column_name := 'BUSINESS_GROUP_ID';
349: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
350: pqh_refresh_data.g_refresh_tab(1).txn_val := rec.context_business_group_id ;
351: pqh_refresh_data.g_refresh_tab(1).shadow_val := rec.context_business_group_id ;
352: pqh_refresh_data.g_refresh_tab(1).main_val := rec.context_business_group_id ;
353: pqh_refresh_data.g_refresh_tab(1).refresh_flag := 'N';
354: pqh_refresh_data.g_refresh_tab(1).updt_flag := 'N';
355: end if;

Line 352: pqh_refresh_data.g_refresh_tab(1).main_val := rec.context_business_group_id ;

348: pqh_refresh_data.g_refresh_tab(1).column_name := 'BUSINESS_GROUP_ID';
349: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
350: pqh_refresh_data.g_refresh_tab(1).txn_val := rec.context_business_group_id ;
351: pqh_refresh_data.g_refresh_tab(1).shadow_val := rec.context_business_group_id ;
352: pqh_refresh_data.g_refresh_tab(1).main_val := rec.context_business_group_id ;
353: pqh_refresh_data.g_refresh_tab(1).refresh_flag := 'N';
354: pqh_refresh_data.g_refresh_tab(1).updt_flag := 'N';
355: end if;
356:

Line 353: pqh_refresh_data.g_refresh_tab(1).refresh_flag := 'N';

349: pqh_refresh_data.g_refresh_tab(1).column_type := 'N';
350: pqh_refresh_data.g_refresh_tab(1).txn_val := rec.context_business_group_id ;
351: pqh_refresh_data.g_refresh_tab(1).shadow_val := rec.context_business_group_id ;
352: pqh_refresh_data.g_refresh_tab(1).main_val := rec.context_business_group_id ;
353: pqh_refresh_data.g_refresh_tab(1).refresh_flag := 'N';
354: pqh_refresh_data.g_refresh_tab(1).updt_flag := 'N';
355: end if;
356:
357: pqh_refresh_data.replace_where_params(rec.where_clause,'N','',l_where);

Line 354: pqh_refresh_data.g_refresh_tab(1).updt_flag := 'N';

350: pqh_refresh_data.g_refresh_tab(1).txn_val := rec.context_business_group_id ;
351: pqh_refresh_data.g_refresh_tab(1).shadow_val := rec.context_business_group_id ;
352: pqh_refresh_data.g_refresh_tab(1).main_val := rec.context_business_group_id ;
353: pqh_refresh_data.g_refresh_tab(1).refresh_flag := 'N';
354: pqh_refresh_data.g_refresh_tab(1).updt_flag := 'N';
355: end if;
356:
357: pqh_refresh_data.replace_where_params(rec.where_clause,'N','',l_where);
358: --;

Line 357: pqh_refresh_data.replace_where_params(rec.where_clause,'N','',l_where);

353: pqh_refresh_data.g_refresh_tab(1).refresh_flag := 'N';
354: pqh_refresh_data.g_refresh_tab(1).updt_flag := 'N';
355: end if;
356:
357: pqh_refresh_data.replace_where_params(rec.where_clause,'N','',l_where);
358: --;
359: l_where := ' Where '||nvl(l_where, '1=1')||' ';
360: --
361: for e_rec in c_sat('CRITERIA', rec.transaction_category_id) loop