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 PQH_TABLE_ROUTE

Line 219: l_txn_tab_id pqh_table_route.table_route_id%TYPE;

215: -- local variables
216: --
217: l_proc varchar2(72) := g_package||'refresh_data';
218: l_txn_id number;
219: l_txn_tab_id pqh_table_route.table_route_id%TYPE;
220: l_shd_tab_id pqh_table_route.table_route_id%TYPE;
221: l_mas_tab_id pqh_table_route.table_route_id%TYPE;
222: l_column_name pqh_attributes.column_name%TYPE;
223: l_attribute_name pqh_attributes.attribute_name%TYPE;

Line 220: l_shd_tab_id pqh_table_route.table_route_id%TYPE;

216: --
217: l_proc varchar2(72) := g_package||'refresh_data';
218: l_txn_id number;
219: l_txn_tab_id pqh_table_route.table_route_id%TYPE;
220: l_shd_tab_id pqh_table_route.table_route_id%TYPE;
221: l_mas_tab_id pqh_table_route.table_route_id%TYPE;
222: l_column_name pqh_attributes.column_name%TYPE;
223: l_attribute_name pqh_attributes.attribute_name%TYPE;
224: l_column_prompt varchar2(100);

Line 221: l_mas_tab_id pqh_table_route.table_route_id%TYPE;

217: l_proc varchar2(72) := g_package||'refresh_data';
218: l_txn_id number;
219: l_txn_tab_id pqh_table_route.table_route_id%TYPE;
220: l_shd_tab_id pqh_table_route.table_route_id%TYPE;
221: l_mas_tab_id pqh_table_route.table_route_id%TYPE;
222: l_column_name pqh_attributes.column_name%TYPE;
223: l_attribute_name pqh_attributes.attribute_name%TYPE;
224: l_column_prompt varchar2(100);
225: l_refresh_flag pqh_txn_category_attributes.refresh_flag%TYPE;

Line 227: l_from_clause_txn pqh_table_route.from_clause%TYPE;

223: l_attribute_name pqh_attributes.attribute_name%TYPE;
224: l_column_prompt varchar2(100);
225: l_refresh_flag pqh_txn_category_attributes.refresh_flag%TYPE;
226: l_column_type pqh_attributes.column_type%TYPE;
227: l_from_clause_txn pqh_table_route.from_clause%TYPE;
228: l_where_clause_txn pqh_table_route.where_clause%TYPE;
229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;
230: l_from_clause_shd pqh_table_route.from_clause%TYPE;
231: l_where_clause_shd pqh_table_route.where_clause%TYPE;

Line 228: l_where_clause_txn pqh_table_route.where_clause%TYPE;

224: l_column_prompt varchar2(100);
225: l_refresh_flag pqh_txn_category_attributes.refresh_flag%TYPE;
226: l_column_type pqh_attributes.column_type%TYPE;
227: l_from_clause_txn pqh_table_route.from_clause%TYPE;
228: l_where_clause_txn pqh_table_route.where_clause%TYPE;
229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;
230: l_from_clause_shd pqh_table_route.from_clause%TYPE;
231: l_where_clause_shd pqh_table_route.where_clause%TYPE;
232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;

Line 229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;

225: l_refresh_flag pqh_txn_category_attributes.refresh_flag%TYPE;
226: l_column_type pqh_attributes.column_type%TYPE;
227: l_from_clause_txn pqh_table_route.from_clause%TYPE;
228: l_where_clause_txn pqh_table_route.where_clause%TYPE;
229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;
230: l_from_clause_shd pqh_table_route.from_clause%TYPE;
231: l_where_clause_shd pqh_table_route.where_clause%TYPE;
232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;
233: l_from_clause_main pqh_table_route.from_clause%TYPE;

Line 230: l_from_clause_shd pqh_table_route.from_clause%TYPE;

226: l_column_type pqh_attributes.column_type%TYPE;
227: l_from_clause_txn pqh_table_route.from_clause%TYPE;
228: l_where_clause_txn pqh_table_route.where_clause%TYPE;
229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;
230: l_from_clause_shd pqh_table_route.from_clause%TYPE;
231: l_where_clause_shd pqh_table_route.where_clause%TYPE;
232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;
233: l_from_clause_main pqh_table_route.from_clause%TYPE;
234: l_where_clause_main pqh_table_route.where_clause%TYPE;

Line 231: l_where_clause_shd pqh_table_route.where_clause%TYPE;

227: l_from_clause_txn pqh_table_route.from_clause%TYPE;
228: l_where_clause_txn pqh_table_route.where_clause%TYPE;
229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;
230: l_from_clause_shd pqh_table_route.from_clause%TYPE;
231: l_where_clause_shd pqh_table_route.where_clause%TYPE;
232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;
233: l_from_clause_main pqh_table_route.from_clause%TYPE;
234: l_where_clause_main pqh_table_route.where_clause%TYPE;
235: l_rep_where_clause_main pqh_table_route.where_clause%TYPE;

Line 232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;

228: l_where_clause_txn pqh_table_route.where_clause%TYPE;
229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;
230: l_from_clause_shd pqh_table_route.from_clause%TYPE;
231: l_where_clause_shd pqh_table_route.where_clause%TYPE;
232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;
233: l_from_clause_main pqh_table_route.from_clause%TYPE;
234: l_where_clause_main pqh_table_route.where_clause%TYPE;
235: l_rep_where_clause_main pqh_table_route.where_clause%TYPE;
236: l_select_stmt t_where_clause_typ;

Line 233: l_from_clause_main pqh_table_route.from_clause%TYPE;

229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;
230: l_from_clause_shd pqh_table_route.from_clause%TYPE;
231: l_where_clause_shd pqh_table_route.where_clause%TYPE;
232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;
233: l_from_clause_main pqh_table_route.from_clause%TYPE;
234: l_where_clause_main pqh_table_route.where_clause%TYPE;
235: l_rep_where_clause_main pqh_table_route.where_clause%TYPE;
236: l_select_stmt t_where_clause_typ;
237: l_tot_txn_columns NUMBER;

Line 234: l_where_clause_main pqh_table_route.where_clause%TYPE;

230: l_from_clause_shd pqh_table_route.from_clause%TYPE;
231: l_where_clause_shd pqh_table_route.where_clause%TYPE;
232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;
233: l_from_clause_main pqh_table_route.from_clause%TYPE;
234: l_where_clause_main pqh_table_route.where_clause%TYPE;
235: l_rep_where_clause_main pqh_table_route.where_clause%TYPE;
236: l_select_stmt t_where_clause_typ;
237: l_tot_txn_columns NUMBER;
238: l_tot_txn_rows NUMBER;

Line 235: l_rep_where_clause_main pqh_table_route.where_clause%TYPE;

231: l_where_clause_shd pqh_table_route.where_clause%TYPE;
232: l_rep_where_clause_shd pqh_table_route.where_clause%TYPE;
233: l_from_clause_main pqh_table_route.from_clause%TYPE;
234: l_where_clause_main pqh_table_route.where_clause%TYPE;
235: l_rep_where_clause_main pqh_table_route.where_clause%TYPE;
236: l_select_stmt t_where_clause_typ;
237: l_tot_txn_columns NUMBER;
238: l_tot_txn_rows NUMBER;
239: l_all_txn_rows_array DBMS_SQL.VARCHAR2_TABLE;

Line 265: FROM pqh_attributes att, pqh_table_route tr,

261: CURSOR c1_table_lists IS
262: SELECT DISTINCT tca.transaction_table_route_id,
263: tr.shadow_table_route_id,
264: att.master_table_route_id
265: FROM pqh_attributes att, pqh_table_route tr,
266: pqh_txn_category_attributes tca
267: WHERE tca.transaction_table_route_id = tr.table_route_id
268: AND att.attribute_id = tca.attribute_id
269: AND tca.transaction_category_id = p_txn_category_id

Line 276: CURSOR c2_column_names ( p_txn_tab_id IN pqh_table_route.table_route_id%TYPE,

272: p_refresh_criteria);
273:
274: -- This cursor will get the list of all column_names for the current txn
275: -- and master tables
276: CURSOR c2_column_names ( p_txn_tab_id IN pqh_table_route.table_route_id%TYPE,
277: p_mas_tab_id IN pqh_table_route.table_route_id%TYPE) IS
278: SELECT att.refresh_col_name, nvl(tca.refresh_flag,'N') ,
279: att.column_type,
280: nvl(at2.attribute_name, att.attribute_name) attribute_name

Line 277: p_mas_tab_id IN pqh_table_route.table_route_id%TYPE) IS

273:
274: -- This cursor will get the list of all column_names for the current txn
275: -- and master tables
276: CURSOR c2_column_names ( p_txn_tab_id IN pqh_table_route.table_route_id%TYPE,
277: p_mas_tab_id IN pqh_table_route.table_route_id%TYPE) IS
278: SELECT att.refresh_col_name, nvl(tca.refresh_flag,'N') ,
279: att.column_type,
280: nvl(at2.attribute_name, att.attribute_name) attribute_name
281: FROM pqh_attributes_vl att, pqh_txn_category_attributes tca,

Line 292: -- This cursor will get the FROM and WHERE columns from pqh_table_route

288: AND tca.transaction_table_route_id = p_txn_tab_id
289: AND att.master_table_route_id = p_mas_tab_id
290: ORDER BY tca.refresh_flag DESC, att.attribute_name;
291:
292: -- This cursor will get the FROM and WHERE columns from pqh_table_route
293: CURSOR c3_from_where ( p_tab_id IN pqh_table_route.table_route_id%TYPE ) IS
294: SELECT tr.from_clause, tr.where_clause
295: FROM pqh_table_route tr
296: WHERE tr.table_route_id = p_tab_id ;

Line 293: CURSOR c3_from_where ( p_tab_id IN pqh_table_route.table_route_id%TYPE ) IS

289: AND att.master_table_route_id = p_mas_tab_id
290: ORDER BY tca.refresh_flag DESC, att.attribute_name;
291:
292: -- This cursor will get the FROM and WHERE columns from pqh_table_route
293: CURSOR c3_from_where ( p_tab_id IN pqh_table_route.table_route_id%TYPE ) IS
294: SELECT tr.from_clause, tr.where_clause
295: FROM pqh_table_route tr
296: WHERE tr.table_route_id = p_tab_id ;
297:

Line 295: FROM pqh_table_route tr

291:
292: -- This cursor will get the FROM and WHERE columns from pqh_table_route
293: CURSOR c3_from_where ( p_tab_id IN pqh_table_route.table_route_id%TYPE ) IS
294: SELECT tr.from_clause, tr.where_clause
295: FROM pqh_table_route tr
296: WHERE tr.table_route_id = p_tab_id ;
297:
298: BEGIN
299:

Line 403: -- get the FROM and WHERE clause from pqh_table_route for TRANSACTION TABLE

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:
405: OPEN c3_from_where ( l_txn_tab_id ) ;
406: LOOP
407: -- this gets the from and where clause , one row only

Line 507: -- get the FROM and WHERE clause from pqh_table_route for SHADOW TABLE

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 ) ;
510: LOOP
511: -- this gets the from and where clause , one row only

Line 591: -- get the FROM and WHERE clause from pqh_table_route for MAIN TABLE

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 ) ;
594: LOOP
595: -- this gets the from and where clause , one row only

Line 986: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,

982: ||
983: ------------------------------------------------------------------*/
984:
985: PROCEDURE replace_where_params
986: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
987: p_txn_tab_flag IN VARCHAR2,
988: p_txn_id IN number,
989: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE ) IS
990:

Line 989: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE ) IS

985: PROCEDURE replace_where_params
986: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
987: p_txn_tab_flag IN VARCHAR2,
988: p_txn_id IN number,
989: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE ) IS
990:
991: /*
992: This procedure will replace all the parameters in the where_clause with their actual values.
993: p_txn_tab_flag will be 'Y' for the txn table. In the case of txn table we replace the txn_id

Line 1006: l_where_out pqh_table_route.where_clause%TYPE;

1002: l_atoms_tab atoms_tabtype; -- to hold the where_clause atoms
1003: l_no_atoms number;
1004: l_key_column pqh_attributes.column_name%TYPE;
1005: l_key_val VARCHAR2(8000);
1006: l_where_out pqh_table_route.where_clause%TYPE;
1007: l_key_col_null VARCHAR2(8000);
1008: --
1009: l_found boolean := false;
1010: l_next number(10) := 0;

Line 1105: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,

1101: || PROCEDURE : replace_where_params_purge
1102: ||
1103: ------------------------------------------------------------------*/
1104: PROCEDURE replace_where_params_purge
1105: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
1106: p_txn_tab_flag IN VARCHAR2,
1107: p_txn_id IN number,
1108: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE ) IS
1109:

Line 1108: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE ) IS

1104: PROCEDURE replace_where_params_purge
1105: ( p_where_clause_in IN pqh_table_route.where_clause%TYPE,
1106: p_txn_tab_flag IN VARCHAR2,
1107: p_txn_id IN number,
1108: p_where_clause_out OUT NOCOPY pqh_table_route.where_clause%TYPE ) IS
1109:
1110: /*
1111: This procedure will replace all the parameters in the where_clause with their
1112: actual values.

Line 1126: l_where_out pqh_table_route.where_clause%TYPE;

1122: l_atoms_tab atoms_tabtype; -- to hold the where_clause atoms
1123: l_no_atoms number;
1124: l_key_column pqh_attributes.column_name%TYPE;
1125: l_key_val VARCHAR2(8000);
1126: l_where_out pqh_table_route.where_clause%TYPE;
1127: l_key_col_null VARCHAR2(8000);
1128:
1129:
1130: BEGIN

Line 1195: p_from_clause IN pqh_table_route.from_clause%TYPE,

1191: ||
1192: ------------------------------------------------------------------*/
1193: PROCEDURE get_all_rows
1194: (p_select_stmt IN t_where_clause_typ,
1195: p_from_clause IN pqh_table_route.from_clause%TYPE,
1196: p_where_clause IN pqh_table_route.where_clause%TYPE,
1197: p_total_columns IN NUMBER,
1198: p_total_rows OUT NOCOPY NUMBER,
1199: p_all_txn_rows OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE )

Line 1196: p_where_clause IN pqh_table_route.where_clause%TYPE,

1192: ------------------------------------------------------------------*/
1193: PROCEDURE get_all_rows
1194: (p_select_stmt IN t_where_clause_typ,
1195: p_from_clause IN pqh_table_route.from_clause%TYPE,
1196: p_where_clause IN pqh_table_route.where_clause%TYPE,
1197: p_total_columns IN NUMBER,
1198: p_total_rows OUT NOCOPY NUMBER,
1199: p_all_txn_rows OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE )
1200: IS

Line 1454: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,

1450: PROCEDURE update_tables
1451: (p_column_name IN pqh_attributes.column_name%TYPE,
1452: p_column_type IN pqh_attributes.column_type%TYPE,
1453: p_column_val IN VARCHAR2,
1454: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
1455: p_from_clause_shd IN pqh_table_route.from_clause%TYPE,
1456: p_rep_where_clause_shd IN pqh_table_route.where_clause%TYPE )
1457: IS
1458: /*

Line 1455: p_from_clause_shd IN pqh_table_route.from_clause%TYPE,

1451: (p_column_name IN pqh_attributes.column_name%TYPE,
1452: p_column_type IN pqh_attributes.column_type%TYPE,
1453: p_column_val IN VARCHAR2,
1454: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
1455: p_from_clause_shd IN pqh_table_route.from_clause%TYPE,
1456: p_rep_where_clause_shd IN pqh_table_route.where_clause%TYPE )
1457: IS
1458: /*
1459: This procedure will update the txn and shadow tables with the new value.

Line 1456: p_rep_where_clause_shd IN pqh_table_route.where_clause%TYPE )

1452: p_column_type IN pqh_attributes.column_type%TYPE,
1453: p_column_val IN VARCHAR2,
1454: p_from_clause_txn IN pqh_table_route.from_clause%TYPE,
1455: p_from_clause_shd IN pqh_table_route.from_clause%TYPE,
1456: p_rep_where_clause_shd IN pqh_table_route.where_clause%TYPE )
1457: IS
1458: /*
1459: This procedure will update the txn and shadow tables with the new value.
1460: As the shadow and txn tables are identical, we use the wwhere clause of shadow

Line 1711: (p_string_in IN pqh_table_route.where_clause%TYPE,

1707: ------------------------------------------------------------------*/
1708:
1709:
1710: PROCEDURE parse_string
1711: (p_string_in IN pqh_table_route.where_clause%TYPE,
1712: p_atomics_list_out OUT NOCOPY atoms_tabtype,
1713: p_num_atomics_out IN OUT NOCOPY NUMBER,
1714: p_delimiters_in IN VARCHAR2 := std_delimiters)
1715: