DBA Data[Home] [Help]

APPS.PQH_SAT_SHD dependencies on PQH_SPECIAL_ATTRIBUTES_S

Line 263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;

259: --
260: l_attribute_id pqh_attributes.attribute_id%TYPE ;
261: l_table_route_id pqh_attributes.master_table_route_id%TYPE;
262: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;
264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;
265: --
266: l_created_by pqh_special_attributes.created_by%TYPE;
267: l_last_updated_by pqh_special_attributes.last_updated_by%TYPE;

Line 395: select pqh_special_attributes_s.nextval into l_special_attribute_id from dual;

391: and nvl(last_updated_by, -1) in (l_last_updated_by,-1,0,1);
392:
393: else
394: -- insert
395: select pqh_special_attributes_s.nextval into l_special_attribute_id from dual;
396:
397:
398: insert into pqh_special_attributes
399: ( special_attribute_id,