[Home] [Help]
PACKAGE: APPS.PQH_PRVCALC
Source
1 Package pqh_prvcalc AUTHID CURRENT_USER as
2 /* $Header: pqprvcal.pkh 115.13 2002/12/03 20:42:30 rpasapul ship $ */
3
4 type t_task_templ is table of pqh_template_attributes.template_id%type
5 index by binary_integer ;
6
7 type t_attid_priv_typ is record (
8 Attribute_id pqh_attributes.attribute_id%type,
9 task_type varchar2(1),
10 mode_flag varchar2(1),
11 reqd_flag varchar2(1) );
12
13 type t_attid_priv is table of t_attid_priv_typ
14 index by binary_integer ;
15
16 type t_attname_priv_typ is record (
17 form_column_name varchar2(100),
18 mode_flag varchar2(1),
19 reqd_flag varchar2(1));
20
21 type t_attname_priv is table of t_attname_priv_typ
22 index by binary_integer ;
23
24 type t_blocks is table of varchar2(40)
25 index by binary_integer;
26
27 -- global variable to hold the result and return onw by one
28 g_result t_attname_priv;
29
30 --
31 -- ----------------------------------------------------------------------------
32 -- |------------------------< domain_result_calc >------------------------|
33 -- ----------------------------------------------------------------------------
34 --
35
36 procedure domain_result_calc (p_domain in pqh_template_attributes.template_id%type,
37 p_result out nocopy t_attid_priv);
38
39 --
40 -- ----------------------------------------------------------------------------
41 -- |------------------------< task_references >------------------------|
42 -- ----------------------------------------------------------------------------
43 --
44
45 procedure task_references(p_task in pqh_template_attributes.template_id%type,
46 p_result_int in out nocopy t_attid_priv);
47
48 --
49 -- ----------------------------------------------------------------------------
50 -- |------------------------< task_result_update >------------------------|
51 -- ----------------------------------------------------------------------------
52 --
53
54 procedure task_result_update(p_task in pqh_template_attributes.template_id%type,
55 p_task_type in varchar2,
56 p_result_int in out nocopy t_attid_priv);
57
58 --
59 -- ----------------------------------------------------------------------------
60 -- |------------------------< attribute_flag_result >------------------------|
61 -- ----------------------------------------------------------------------------
62 --
63
64 procedure attribute_flag_result (p_edit_flag in varchar2,
65 p_view_flag in varchar2,
66 p_result_flag out nocopy varchar2 );
67
68 --
69 -- ----------------------------------------------------------------------------
70 -- |------------------------< task_task_mode_comp_flag >------------------------|
71 -- ----------------------------------------------------------------------------
72 --
73
74 procedure task_task_mode_comp_flag (p_task1_flag in varchar2,
75 p_task2_flag in varchar2 ,
76 p_result_flag out nocopy varchar2 );
77
78 --
79 -- ----------------------------------------------------------------------------
80 -- |------------------------< domain_task_mode_comp_flag >------------------------|
81 -- ----------------------------------------------------------------------------
82 --
83
84 procedure domain_task_mode_comp_flag (p_domain_mode_flag in varchar2,
85 p_task_mode_flag in varchar2,
86 p_result_flag out nocopy varchar2 );
87
88 --
89 -- ----------------------------------------------------------------------------
90 -- |------------------------< priviledge_calc >------------------------|
91 -- ----------------------------------------------------------------------------
92 --
93
94 procedure priviledge_calc (p_domain in pqh_template_attributes.template_id%type,
95 p_tasks in t_task_templ,
96 p_transaction_category_id in number,
97 p_result out nocopy t_attname_priv );
98
99 --
100 -- ----------------------------------------------------------------------------
101 -- |------------------------< template_attrib_reqd_calc >------------------------|
102 -- ----------------------------------------------------------------------------
103 --
104
105 procedure template_attrib_reqd_calc (p_tasks in t_task_templ,
106 p_transaction_category_id in number,
107 p_result out nocopy t_attname_priv);
108
109
110 --
111 -- ----------------------------------------------------------------------------
112 -- |------------------------< get_row_prv >------------------------|
113 -- ----------------------------------------------------------------------------
114 --
115
116 procedure get_row_prv( p_row in number,
117 p_form_column_name out nocopy pqh_txn_category_attributes.form_column_name%type,
118 p_mode_flag out nocopy varchar2,
119 p_reqd_flag out nocopy varchar2);
120
121 --
122 -- ----------------------------------------------------------------------------
123 -- |------------------------< check_priv_calc >------------------------|
124 -- ----------------------------------------------------------------------------
125 --
126
127 procedure check_priv_calc;
128
129 --
130 -- ----------------------------------------------------------------------------
131 -- |------------------------< priviledge_calc_count >------------------------|
132 -- ----------------------------------------------------------------------------
133 --
134
135 procedure priviledge_calc_count (p_domain in pqh_template_attributes.template_id%type,
136 p_tasks in t_task_templ,
137 p_transaction_category_id in number,
138 p_result_count out nocopy number ) ;
139
140 --
141 -- ----------------------------------------------------------------------------
142 -- |------------------------< get_attribute_mode >----------------------------|
143 -- ----------------------------------------------------------------------------
144 --
145
146 function get_attribute_mode(p_form_column_name in varchar2) return varchar2;
147
148 end pqh_prvcalc;