APPS.PQH_TCA_SHD dependencies on PQH_ATTRIBUTES

Line 294: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;

290: l_language varchar2(30) ;
291: l_delete_attr_ranges_flag varchar2(30) := 'N';
292: --
293: l_txn_category_attribute_id pqh_txn_category_attributes.txn_category_attribute_id%TYPE := 0 ;
294: l_attribute_id pqh_attributes.attribute_id%TYPE := 0 ;
295: l_transaction_category_id pqh_txn_category_attributes.transaction_category_id%TYPE := 0 ;
296: l_transaction_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;

Line 300: l_created_by pqh_attributes.created_by%TYPE;

296: l_transaction_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
299: --
300: l_created_by pqh_attributes.created_by%TYPE;
301: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
302: l_creation_date pqh_attributes.creation_date%TYPE;
303: l_last_update_date pqh_attributes.last_update_date%TYPE;
304: l_last_update_login pqh_attributes.last_update_login%TYPE;

Line 301: l_last_updated_by pqh_attributes.last_updated_by%TYPE;

297: l_att_master_table_route_id pqh_txn_category_attributes.transaction_table_route_id%TYPE;
298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
299: --
300: l_created_by pqh_attributes.created_by%TYPE;
301: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
302: l_creation_date pqh_attributes.creation_date%TYPE;
303: l_last_update_date pqh_attributes.last_update_date%TYPE;
304: l_last_update_login pqh_attributes.last_update_login%TYPE;
305: --

Line 302: l_creation_date pqh_attributes.creation_date%TYPE;

298: l_flex_value_set_id fnd_flex_value_sets.flex_value_set_id%TYPE;
299: --
300: l_created_by pqh_attributes.created_by%TYPE;
301: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
302: l_creation_date pqh_attributes.creation_date%TYPE;
303: l_last_update_date pqh_attributes.last_update_date%TYPE;
304: l_last_update_login pqh_attributes.last_update_login%TYPE;
305: --
306: cursor c1 is select userenv('LANG') from dual ;

Line 303: l_last_update_date pqh_attributes.last_update_date%TYPE;

299: --
300: l_created_by pqh_attributes.created_by%TYPE;
301: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
302: l_creation_date pqh_attributes.creation_date%TYPE;
303: l_last_update_date pqh_attributes.last_update_date%TYPE;
304: l_last_update_login pqh_attributes.last_update_login%TYPE;
305: --
306: cursor c1 is select userenv('LANG') from dual ;
307: --

Line 304: l_last_update_login pqh_attributes.last_update_login%TYPE;

300: l_created_by pqh_attributes.created_by%TYPE;
301: l_last_updated_by pqh_attributes.last_updated_by%TYPE;
302: l_creation_date pqh_attributes.creation_date%TYPE;
303: l_last_update_date pqh_attributes.last_update_date%TYPE;
304: l_last_update_login pqh_attributes.last_update_login%TYPE;
305: --
306: cursor c1 is select userenv('LANG') from dual ;
307: --
308: --

Line 315: from pqh_attributes

311: cursor csr_attribute_id(p_column_name IN VARCHAR2,
312: p_table_id IN NUMBER,
313: p_legislation_code varchar2) is
314: select attribute_id
315: from pqh_attributes
316: where key_column_name = p_column_name
317: and nvl(master_table_route_id,-999) = nvl(p_table_id, -999)
318: and nvl(legislation_code,'$$$') = nvl(p_legislation_code, '$$$');
319: --