[Home] [Help]
PACKAGE: APPS.ZX_SECURITY
Source
1 PACKAGE zx_security AUTHID CURRENT_USER AS
2 /* $Header: zxifdtaccsecpvts.pls 120.11 2008/02/14 19:25:00 appradha ship $ */
3
4 --
5 -- Global Variables
6 -- Purpose
7 -- Used in security policy functions to determine the correct predicate for a
8 -- single subscriber
9 --
10
11 G_FIRST_PARTY_ORG_ID NUMBER ;
12 G_EFFECTIVE_DATE DATE;
13 G_ICX_SESSION_ID NUMBER;
14
15 FUNCTION get_effective_date RETURN DATE;
16
17 --
18 -- Name
19 -- single_read_access
20 -- Purpose
21 -- Security policy function to control read access to rules and formula setup
22 -- data for a single subscriber
23 -- Arguments
24 -- D1 - Object Schema.
25 -- D2 - Object Name.
26 --
27
28 FUNCTION single_read_access (D1 VARCHAR2, D2 VARCHAR2)
29 RETURN VARCHAR2;
30
31 --
32 -- Name
33 -- single_read_access_for_excp
34 -- Purpose
35 -- Security policy function to control read access to exception setup
36 -- data for a single first party organization
37 --
38 -- Arguments
39 -- D1 - Object Schema.
40 -- D2 - Object Name.
41 --
42
43 FUNCTION single_read_access_for_excp (D1 VARCHAR2, D2 VARCHAR2)
44 RETURN VARCHAR2 ;
45
46 --
47 -- Name
48 -- single_read_access_for_ovrd
49 -- Purpose
50 -- Security policy function to control read access to tax setup data for a
51 -- single first party organization
52 --
53 -- Arguments
54 -- D1 - Object Schema.
55 -- D2 - Object Name.
56 --
57 FUNCTION single_read_access_for_ovrd (D1 VARCHAR2, D2 VARCHAR2)
58 RETURN VARCHAR2;
59
60 --
61 -- Name
62 -- multiple_read_access
63 -- Purpose
64 -- Security policy function to control read access to tax setup data for
65 -- multiple subscribers
66 --
67 -- Arguments
68 -- D1 - Object Schema.
69 -- D2 - Object Name.
70 --
71
72 FUNCTION multiple_read_access (D1 VARCHAR2, D2 VARCHAR2)
73 RETURN VARCHAR2;
74
75 --
76 -- Name
77 -- multiple_read_access_for_excp
78 -- Purpose
79 -- Security policy function to control read access to exception setup data for
80 -- multiple first party organizations
81 --
82 -- Arguments
83 -- D1 - Object Schema.
84 -- D2 - Object Name.
85 --
86
87 FUNCTION multiple_read_access_for_excp (D1 VARCHAR2, D2 VARCHAR2)
88 RETURN VARCHAR2 ;
89 --
90 -- Name
91 -- write_access
92 -- Purpose
93 -- Security policy function to control write access to tax setup data
94 --
95 -- Arguments
96 -- D1 - Object Schema.
97 -- D2 - Object Name.
98 --
99
100 FUNCTION write_access (D1 VARCHAR2, D2 VARCHAR2)
101 RETURN VARCHAR2;
102
103 --
104 -- Name
105 -- write_access_for_excp
106 -- Purpose
107 -- Security policy function to control write access to exception setup data
108 --
109 -- Arguments
110 -- D1 - Object Schema.
111 -- D2 - Object Name.
112 --
113 FUNCTION write_access_for_excp (D1 VARCHAR2, D2 VARCHAR2)
114 RETURN VARCHAR2;
115
116 --
117 -- Name
118 -- first_party_org_access
119 -- Purpose
120 -- Security policy function to control data in zx_exemptions_v
121 --
122 -- Arguments
123 -- D1 - Object Schema.
124 -- D2 - Object Name.
125 --
126 FUNCTION first_party_org_access (D1 VARCHAR2, D2 VARCHAR2)
127 RETURN VARCHAR2;
128
129
130
131 --
132 -- Name
133 -- add_icx_session_id
134 -- Purpose
135 -- Security policy function to control data
136 --
137 -- Arguments
138 -- D1 - Object Schema.
139 -- D2 - Object Name.
140 --
141
142 FUNCTION add_icx_session_id (D1 VARCHAR2, D2 VARCHAR2)
143 RETURN VARCHAR2;
144
145 --
146 -- Name
147 -- single_regime_access
148 -- Purpose
149 -- Security policy function to determince regime applicability process
150 --
151 -- Arguments
152 -- D1 - Object Schema.
153 -- D2 - Object Name.
154 --
155
156 FUNCTION single_regime_access (D1 VARCHAR2, D2 VARCHAR2)
157
158 RETURN VARCHAR2;
159
160
161 --
162 -- Name
163 -- set_security_context
164 -- Purpose
165 -- Sets the global variables G_FIRST_PARTY_ORG_ID and G_EFFECTIVE_DATE
166 --
167
168 PROCEDURE set_security_context(p_legal_entity_id IN NUMBER,
169 p_internal_org_id IN NUMBER,
170 p_effective_date IN DATE,
171 x_return_status OUT NOCOPY VARCHAR2);
172
173 PROCEDURE set_security_context_ui(p_legal_entity_id IN NUMBER,
174 p_internal_org_id IN NUMBER,
175 p_effective_date IN DATE,
176 x_return_status OUT NOCOPY VARCHAR2);
177
178 PROCEDURE set_security_context(p_first_party_org_id IN NUMBER,
179 p_effective_date IN DATE,
180 x_return_status OUT NOCOPY VARCHAR2);
181
182
183 PROCEDURE check_write_access (p_first_party_org_id IN NUMBER,
184 p_tax_regime_code IN VARCHAR2,
185 x_return_status OUT NOCOPY VARCHAR2);
186
187 PROCEDURE name_value (name VARCHAR2, value VARCHAR2);
188
189 END zx_security;