APPS.PQH_PRVCALC dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 352: p_form_column_name out nocopy pqh_txn_category_attributes.form_column_name%type,

348: end loop;
349: end check_priv_calc;
350:
351: procedure get_row_prv( p_row in number,
352: p_form_column_name out nocopy pqh_txn_category_attributes.form_column_name%type,
353: p_mode_flag out nocopy varchar2,
354: p_reqd_flag out nocopy varchar2)
355: is
356: l_proc varchar2(256) := g_package||'get_row_prv';

Line 381: l_form_column_name pqh_txn_category_attributes.form_column_name%type;

377: l_count number := 1;
378: l_task_att_count number ;
379: l_chg_result varchar2(1) := 'Y' ;
380: l_task_template_id pqh_template_attributes.template_id%type;
381: l_form_column_name pqh_txn_category_attributes.form_column_name%type;
382: l_result_flag varchar2(1) ;
383: l_result_task_int t_attid_priv;
384: l_result_domain_int t_attid_priv;
385: cursor c1(p_attribute_id number) is

Line 387: from pqh_txn_category_attributes

383: l_result_task_int t_attid_priv;
384: l_result_domain_int t_attid_priv;
385: cursor c1(p_attribute_id number) is
386: select form_column_name
387: from pqh_txn_category_attributes
388: where attribute_id = p_attribute_id
389: and transaction_category_id = p_transaction_category_id;
390: l_proc varchar2(2000) := g_package||'priviledge_calc_count' ;
391: begin

Line 517: l_form_column_name pqh_txn_category_attributes.form_column_name%type;

513: l_count number := 1;
514: l_task_att_count number ;
515: l_chg_result varchar2(1) := 'Y' ;
516: l_task_template_id pqh_template_attributes.template_id%type;
517: l_form_column_name pqh_txn_category_attributes.form_column_name%type;
518: l_result_flag varchar2(1) ;
519: l_result_task_int t_attid_priv;
520: l_result_domain_int t_attid_priv;
521: cursor c1(p_attribute_id number) is

Line 523: from pqh_txn_category_attributes

519: l_result_task_int t_attid_priv;
520: l_result_domain_int t_attid_priv;
521: cursor c1(p_attribute_id number) is
522: select form_column_name
523: from pqh_txn_category_attributes
524: where attribute_id = p_attribute_id
525: and transaction_category_id = p_transaction_category_id;
526: l_proc varchar2(2000) := g_package||'priviledge_calc' ;
527: begin

Line 642: l_form_column_name pqh_txn_category_attributes.form_column_name%type;

638: as
639: l_task_count number := 1;
640: i binary_integer := 1;
641: l_task_template_id pqh_template_attributes.template_id%type;
642: l_form_column_name pqh_txn_category_attributes.form_column_name%type;
643: l_result_task_int t_attid_priv;
644: l_result t_attname_priv;
645:
646: cursor c1(p_attribute_id number) is

Line 648: from pqh_txn_category_attributes

644: l_result t_attname_priv;
645:
646: cursor c1(p_attribute_id number) is
647: select form_column_name
648: from pqh_txn_category_attributes
649: where attribute_id = p_attribute_id
650: and transaction_category_id = p_transaction_category_id;
651:
652: l_proc varchar2(2000) := g_package||'template_attrib_reqd_calc' ;