APPS.PQH_REFRESH_DATA dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 225: l_refresh_flag pqh_txn_category_attributes.refresh_flag%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;
228: l_where_clause_txn pqh_table_route.where_clause%TYPE;
229: l_rep_where_clause_txn pqh_table_route.where_clause%TYPE;

Line 266: pqh_txn_category_attributes tca

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
270: AND tr.shadow_table_route_id IS NOT NULL

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 1596: l_form_column_name pqh_txn_category_attributes.form_column_name%TYPE;

1592: */
1593:
1594:
1595: l_proc varchar2(72) := g_package||'count_changed';
1596: l_form_column_name pqh_txn_category_attributes.form_column_name%TYPE;
1597: l_mode_flag varchar2(1) := 'E';
1598: l_reqd_flag varchar2(1) := 'C';
1599: l_cnt binary_integer := 0;
1600:

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:

Line 1669: p_form_column_name OUT NOCOPY pqh_txn_category_attributes.form_column_name%TYPE,

1665: ------------------------------------------------------------------*/
1666:
1667: PROCEDURE get_row_prv_calc
1668: ( p_row IN number,
1669: p_form_column_name OUT NOCOPY pqh_txn_category_attributes.form_column_name%TYPE,
1670: p_mode_flag OUT NOCOPY varchar2,
1671: p_reqd_flag OUT NOCOPY varchar2
1672: ) IS
1673: