APPS.PQH_TEM_SHD dependencies on PQH_TRANSACTION_CATEGORIES

Line 334: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;

330: l_language varchar2(30) ;
331:
332: --
333: l_template_id pqh_templates.template_id%type := 0;
334: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
335: --
336: --
337: l_created_by pqh_templates.created_by%TYPE;
338: l_last_updated_by pqh_templates.last_updated_by%TYPE;

Line 347: from pqh_transaction_categories

343: --
344: cursor c1 is select userenv('LANG') from dual ;
345: --
346: Cursor c2 is select transaction_category_id
347: from pqh_transaction_categories
348: where short_name = p_tran_cat_short_name
349: and business_group_id is null;
350: --
351: Cursor c3 is select template_id

Line 483: p_ref_entity=>'PQH_TRANSACTION_CATEGORIES',

479: -- Code Starts Here.
480: --
481: per_ric_pkg.Chk_integrity (
482: p_entity_name=> 'PQH_TEMPLATES',
483: p_ref_entity=>'PQH_TRANSACTION_CATEGORIES',
484: p_ref_column_name=>'TRANSACTION_CATEGORY_ID',
485: p_ref_col_value_number=>l_transaction_category_id,
486: p_ref_col_value_varchar=>NULL,
487: p_ref_col_value_date=>NULL,