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_CBR_ENGINE dependencies on PQH_TABLE_ROUTE

Line 429: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;

425: --
426: Function GET_TRANSACTION_VALUE (p_entity_id IN number,
427: p_attribute_id IN number) RETURN varchar2 IS
428: l_sel_stmt varchar2(4000);
429: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;
430: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
431: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
432: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;
433: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;

Line 430: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;

426: Function GET_TRANSACTION_VALUE (p_entity_id IN number,
427: p_attribute_id IN number) RETURN varchar2 IS
428: l_sel_stmt varchar2(4000);
429: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;
430: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
431: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
432: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;
433: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;
434: l_selected_value_v varchar2(2000);

Line 431: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;

427: p_attribute_id IN number) RETURN varchar2 IS
428: l_sel_stmt varchar2(4000);
429: l_from_clause PQH_TABLE_ROUTE.FROM_CLAUSE%TYPE;
430: l_where_clause_in PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
431: l_where_clause_out PQH_TABLE_ROUTE.WHERE_CLAUSE%TYPE;
432: l_column_name PQH_ATTRIBUTES.COLUMN_NAME%TYPE;
433: l_column_type PQH_ATTRIBUTES.COLUMN_TYPE%TYPE;
434: l_selected_value_v varchar2(2000);
435: l_selected_value_n number;

Line 438: l_table_route_id PQH_TABLE_ROUTE.TABLE_ROUTE_ID%TYPE;

434: l_selected_value_v varchar2(2000);
435: l_selected_value_n number;
436: l_selected_value_d date;
437: l_proc varchar2(100) := 'get_transaction_value';
438: l_table_route_id PQH_TABLE_ROUTE.TABLE_ROUTE_ID%TYPE;
439: BEGIN
440: hr_utility.set_location('Entering : '||l_proc, 5);
441: if (p_entity_id is not null and p_attribute_id is not null) then
442:

Line 459: from pqh_table_route where table_route_id = l_table_route_id;

455: -- table route is selected, get the details
456:
457: select from_clause, where_clause
458: into l_from_clause, l_where_clause_in
459: from pqh_table_route where table_route_id = l_table_route_id;
460: --broke the set_location for from_clause into two lines kgowripe
461: hr_utility.set_location('from_clause1 is : '||substr(l_from_clause,1,30),30);
462: hr_utility.set_location('from_clause2 is : '||substr(l_from_clause,31,30),31);
463: hr_utility.set_location('where_clause 1is : '||substr(l_where_clause_in,1,40),40);