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_ATTRIBUTES

Line 222: l_column_name pqh_attributes.column_name%TYPE;

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;
226: l_column_type pqh_attributes.column_type%TYPE;

Line 223: l_attribute_name pqh_attributes.attribute_name%TYPE;

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;
226: l_column_type pqh_attributes.column_type%TYPE;
227: l_from_clause_txn pqh_table_route.from_clause%TYPE;

Line 226: l_column_type pqh_attributes.column_type%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;
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;

Line 250: type t_string is table of pqh_attributes_tl.attribute_name%type

246: l_tot_main_rows NUMBER;
247: l_all_main_rows_array DBMS_SQL.VARCHAR2_TABLE;
248: l_legislation_code varchar2(30)
249: := get_legislation_code(fnd_profile.value('PER_BUSINESS_GROUP_ID'));
250: type t_string is table of pqh_attributes_tl.attribute_name%type
251: index by binary_integer;
252: l_change_items t_string;
253: l_chg_items_index integer := 0;
254: l_found boolean := false;

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 281: FROM pqh_attributes_vl att, pqh_txn_category_attributes tca,

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,
282: pqh_attributes_vl at2
283: WHERE att.attribute_id = tca.attribute_id
284: AND att.column_name = at2.column_name(+)
285: AND att.master_table_route_id = at2.master_table_route_id(+)

Line 282: pqh_attributes_vl at2

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,
282: pqh_attributes_vl at2
283: WHERE att.attribute_id = tca.attribute_id
284: AND att.column_name = at2.column_name(+)
285: AND att.master_table_route_id = at2.master_table_route_id(+)
286: AND at2.legislation_code(+) = l_legislation_code

Line 843: FUNCTION get_value_from_array ( p_column_name IN pqh_attributes.column_name%TYPE )

839: || FUNCTION : get_value_from_array
840: ||
841: ------------------------------------------------------------------*/
842: --
843: FUNCTION get_value_from_array ( p_column_name IN pqh_attributes.column_name%TYPE )
844: RETURN VARCHAR2 IS
845:
846: -- local variables
847: --

Line 928: FUNCTION get_value_from_array_purge ( p_column_name IN pqh_attributes.column_name%TYPE )

924: /*----------------------------------------------------------------
925: || FUNCTION : get_value_from_array_purge
926: ||
927: ------------------------------------------------------------------*/
928: FUNCTION get_value_from_array_purge ( p_column_name IN pqh_attributes.column_name%TYPE )
929: RETURN VARCHAR2 IS
930:
931: -- local variables
932: --

Line 1004: l_key_column pqh_attributes.column_name%TYPE;

1000: --
1001: l_proc varchar2(72) := g_package||'replace_where_params';
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: --

Line 1124: l_key_column pqh_attributes.column_name%TYPE;

1120: --
1121: l_proc varchar2(72) := g_package||'replace_where_params_purge';
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:

Line 1451: (p_column_name IN pqh_attributes.column_name%TYPE,

1447: ------------------------------------------------------------------*/
1448:
1449:
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,

Line 1452: p_column_type IN pqh_attributes.column_type%TYPE,

1448:
1449:
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 )

Line 1602: CURSOR c1(p_column_name pqh_attributes.column_name%TYPE ) IS

1598: l_reqd_flag varchar2(1) := 'C';
1599: l_cnt binary_integer := 0;
1600:
1601:
1602: CURSOR c1(p_column_name pqh_attributes.column_name%TYPE ) IS
1603: SELECT tca.form_column_name
1604: FROM pqh_attributes att, pqh_txn_category_attributes tca
1605: WHERE att.attribute_id = tca.attribute_id
1606: AND tca.transaction_category_id = g_txn_category_id

Line 1604: FROM pqh_attributes att, pqh_txn_category_attributes tca

1600:
1601:
1602: CURSOR c1(p_column_name pqh_attributes.column_name%TYPE ) IS
1603: SELECT tca.form_column_name
1604: FROM pqh_attributes att, pqh_txn_category_attributes tca
1605: WHERE att.attribute_id = tca.attribute_id
1606: AND tca.transaction_category_id = g_txn_category_id
1607: AND att.refresh_col_name = p_column_name;
1608: