APPS.PQH_PRVCALC dependencies on PQH_TEMPLATE_ATTRIBUTES

Line 161: procedure domain_result_calc (p_domain in pqh_template_attributes.template_id%type,

157: -- ----------------------------------------------------------------------------
158: -- |------------------------< domain_result_calc >------------------------|
159: -- ----------------------------------------------------------------------------
160: --
161: procedure domain_result_calc (p_domain in pqh_template_attributes.template_id%type,
162: p_result out nocopy t_attid_priv)
163: as
164: l_count number := 1;
165: l_result_flag varchar2(1) ;

Line 169: from pqh_template_attributes

165: l_result_flag varchar2(1) ;
166: l_result t_attid_priv;
167: cursor c1(l_template_id number) is
168: select edit_flag,view_flag,attribute_id
169: from pqh_template_attributes
170: where template_id = l_template_id;
171: l_proc varchar2(2000) := g_package||'domain_result_calc' ;
172: begin
173: hr_utility.set_location('Entering'||l_proc,10);

Line 205: procedure task_result_update (p_task in pqh_template_attributes.template_id%type,

201: -- ----------------------------------------------------------------------------
202: -- |------------------------< task_result_update >------------------------|
203: -- ----------------------------------------------------------------------------
204: --
205: procedure task_result_update (p_task in pqh_template_attributes.template_id%type,
206: p_task_type in varchar2,
207: p_result_int in out nocopy t_attid_priv)
208: as
209: l_result_int t_attid_priv := p_result_int;

Line 217: from pqh_template_attributes

213: l_ins_result varchar2(1);
214: l_task_last_count number ;
215: cursor c1(l_task_template_id number) is
216: select edit_flag,view_flag,attribute_id,required_flag
217: from pqh_template_attributes
218: where template_id = l_task_template_id;
219: l_proc varchar2(2000) := g_package||'task_result_update' ;
220: begin
221: -- hr_utility.set_location('Entering'||l_proc,10);

Line 300: procedure task_references(p_task in pqh_template_attributes.template_id%type,

296: -- |------------------------< task_references >------------------------|
297: -- ----------------------------------------------------------------------------
298: --
299:
300: procedure task_references(p_task in pqh_template_attributes.template_id%type,
301: p_result_int in out nocopy t_attid_priv)
302: as
303:
304: l_result_int t_attid_priv := p_result_int;

Line 334: p_domain pqh_template_attributes.template_id%type;

330: raise;
331: end task_references;
332:
333: procedure check_priv_calc is
334: p_domain pqh_template_attributes.template_id%type;
335: p_tasks t_task_templ;
336: p_result t_attname_priv;
337: p_transaction_category_id number;
338: l_proc varchar2(256) := g_package||'check_priv_calc';

Line 364: procedure priviledge_calc_count (p_domain in pqh_template_attributes.template_id%type,

360: p_reqd_flag := g_result(p_row).reqd_flag;
361: hr_utility.set_location('exiting'||l_proc,10000);
362: end get_row_prv;
363:
364: procedure priviledge_calc_count (p_domain in pqh_template_attributes.template_id%type,
365: p_tasks in t_task_templ,
366: p_transaction_category_id in number,
367: p_result_count out nocopy number )
368: is

Line 380: l_task_template_id pqh_template_attributes.template_id%type;

376: l_int_res_count number := 1;
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;

Line 499: procedure priviledge_calc (p_domain in pqh_template_attributes.template_id%type,

495: -- |------------------------< priviledge_calc >------------------------|
496: -- ----------------------------------------------------------------------------
497: --
498:
499: procedure priviledge_calc (p_domain in pqh_template_attributes.template_id%type,
500: p_tasks in t_task_templ,
501: p_transaction_category_id in number,
502: p_result out nocopy t_attname_priv )
503: is

Line 516: l_task_template_id pqh_template_attributes.template_id%type;

512: l_int_res_count number := 1;
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;

Line 641: l_task_template_id pqh_template_attributes.template_id%type;

637: p_result out nocopy t_attname_priv)
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: