[Home] [Help]
PACKAGE: APPS.GL_DEFAS_ACCESS_DETAILS_PKG
Source
1 PACKAGE gl_defas_access_details_pkg AS
2 /* $Header: glistdds.pls 120.4 2005/05/05 01:23:16 kvora ship $ */
3 --
4 -- Package
5 -- gl_defas_access_details_pkg
6 -- Purpose
7 -- Server routines related to view gl_defas_norm_assign_v
8 -- History
9 -- 06/07/2002 C Ma Created
10
11 --
12 -- Procedure
13 -- get_query_component
14 -- Purpose
15 -- used to get the parameters to create the record group query
16 -- History
17 -- 06/07/02 C Ma Created
18 -- Notes
19 --
20 PROCEDURE get_query_component( X_Object_Type VARCHAR2,
21 X_Id_Column IN OUT NOCOPY VARCHAR2,
22 X_Name_Column IN OUT NOCOPY VARCHAR2,
23 X_Desc_Column IN OUT NOCOPY VARCHAR2,
24 X_Where_Clause IN OUT NOCOPY VARCHAR2,
25 X_Table_Name IN OUT NOCOPY VARCHAR2);
26 --
27 -- Procedure
28 -- get_object_name
29 -- Purpose
30 -- used to get the object name
31 -- History
32 -- 06/07/02 C Ma Created
33 -- Notes
34 --
35 FUNCTION get_object_name( X_Obj_Type VARCHAR2,
36 X_Obj_Key VARCHAR2) RETURN VARCHAR2;
37
38 --
39 -- Procedure
40 -- get_object_key
41 -- Purpose
42 -- used to get the object key. called by iSetup API.
43 -- History
44 -- 04/07/04 C Ma Created
45 -- Notes
46 --
47 FUNCTION get_object_key( X_Obj_Type VARCHAR2,
48 X_Obj_Name VARCHAR2) RETURN VARCHAR2;
49
50 --
51 -- Procedure
52 -- secure_object
53 -- Purpose
54 -- used to secure an object.called from the API.
55 -- History
56 -- 04/08/04 C Ma Created
57 -- Notes
58 --
59 PROCEDURE secure_object ( X_Obj_Type VARCHAR2,
60 X_Obj_Key VARCHAR2);
61
62
63 --
64 -- Procedure
65 -- Insert_Row
66 -- Purpose
67 -- used to insert a definition access detail record
68 -- History
69 -- 06/07/02 C Ma Created
70 -- Notes
71 --
72 PROCEDURE Insert_Row(
73 X_Rowid IN OUT NOCOPY VARCHAR2,
74 X_Definition_Access_Set_Id NUMBER,
75 X_Object_Type VARCHAR2,
76 X_Object_Key VARCHAR2,
77 X_View_Access_Flag VARCHAR2,
78 X_Use_Access_Flag VARCHAR2,
79 X_Modify_Access_Flag VARCHAR2,
80 X_User_Id NUMBER,
81 X_Login_Id NUMBER,
82 X_Date DATE,
83 X_Status_Code VARCHAR2 DEFAULT NULL,
84 X_Context VARCHAR2 DEFAULT NULL,
85 X_Attribute1 VARCHAR2 DEFAULT NULL,
86 X_Attribute2 VARCHAR2 DEFAULT NULL,
87 X_Attribute3 VARCHAR2 DEFAULT NULL,
88 X_Attribute4 VARCHAR2 DEFAULT NULL,
89 X_Attribute5 VARCHAR2 DEFAULT NULL,
90 X_Attribute6 VARCHAR2 DEFAULT NULL,
91 X_Attribute7 VARCHAR2 DEFAULT NULL,
92 X_Attribute8 VARCHAR2 DEFAULT NULL,
93 X_Attribute9 VARCHAR2 DEFAULT NULL,
94 X_Attribute10 VARCHAR2 DEFAULT NULL,
95 X_Attribute11 VARCHAR2 DEFAULT NULL,
96 X_Attribute12 VARCHAR2 DEFAULT NULL,
97 X_Attribute13 VARCHAR2 DEFAULT NULL,
98 X_Attribute14 VARCHAR2 DEFAULT NULL,
99 X_Attribute15 VARCHAR2 DEFAULT NULL,
100 X_Request_Id NUMBER);
101
102
103 --
104 -- Procedure
105 -- Update_Row
106 -- Purpose
107 -- used to update a definition access detail record
108 -- History
109 -- 06/07/02 C Ma Created
110 -- Notes
111 --
112 PROCEDURE Update_Row(
113 X_Rowid IN OUT NOCOPY VARCHAR2,
114 X_View_Access_Flag VARCHAR2,
115 X_Use_Access_Flag VARCHAR2,
116 X_Modify_Access_Flag VARCHAR2,
117 X_Last_Update_Date DATE,
118 X_Last_Updated_By NUMBER,
119 X_Last_Update_Login NUMBER,
120 X_Request_Id NUMBER,
121 X_Status_Code VARCHAR2,
122 X_Context VARCHAR2 DEFAULT NULL,
123 X_Attribute1 VARCHAR2 DEFAULT NULL,
124 X_Attribute2 VARCHAR2 DEFAULT NULL,
125 X_Attribute3 VARCHAR2 DEFAULT NULL,
126 X_Attribute4 VARCHAR2 DEFAULT NULL,
127 X_Attribute5 VARCHAR2 DEFAULT NULL,
128 X_Attribute6 VARCHAR2 DEFAULT NULL,
129 X_Attribute7 VARCHAR2 DEFAULT NULL,
130 X_Attribute8 VARCHAR2 DEFAULT NULL,
131 X_Attribute9 VARCHAR2 DEFAULT NULL,
132 X_Attribute10 VARCHAR2 DEFAULT NULL,
133 X_Attribute11 VARCHAR2 DEFAULT NULL,
134 X_Attribute12 VARCHAR2 DEFAULT NULL,
135 X_Attribute13 VARCHAR2 DEFAULT NULL,
136 X_Attribute14 VARCHAR2 DEFAULT NULL,
137 X_Attribute15 VARCHAR2 DEFAULT NULL);
138
139 --
140 -- Procedure
141 -- Lock_Row
142 -- Purpose
143 -- used to lock a definition access detail record
144 -- History
145 -- 06/07/02 C Ma Created
146 -- Notes
147 --
148 PROCEDURE Lock_Row(
149 X_Rowid IN OUT NOCOPY VARCHAR2,
150 X_Definition_Access_Set_Id NUMBER,
151 X_Object_Type VARCHAR2,
152 X_Object_Key VARCHAR2,
153 X_View_Access_Flag VARCHAR2,
154 X_Use_Access_Flag VARCHAR2,
155 X_Modify_Access_Flag VARCHAR2,
156 X_Last_Update_Date DATE,
157 X_Last_Updated_By NUMBER,
158 X_Creation_Date DATE,
159 X_Created_By NUMBER,
160 X_Last_Update_Login NUMBER,
161 X_Status_Code VARCHAR2 DEFAULT NULL,
162 X_Context VARCHAR2 DEFAULT NULL,
163 X_Attribute1 VARCHAR2 DEFAULT NULL,
164 X_Attribute2 VARCHAR2 DEFAULT NULL,
165 X_Attribute3 VARCHAR2 DEFAULT NULL,
166 X_Attribute4 VARCHAR2 DEFAULT NULL,
167 X_Attribute5 VARCHAR2 DEFAULT NULL,
168 X_Attribute6 VARCHAR2 DEFAULT NULL,
169 X_Attribute7 VARCHAR2 DEFAULT NULL,
170 X_Attribute8 VARCHAR2 DEFAULT NULL,
171 X_Attribute9 VARCHAR2 DEFAULT NULL,
172 X_Attribute10 VARCHAR2 DEFAULT NULL,
173 X_Attribute11 VARCHAR2 DEFAULT NULL,
174 X_Attribute12 VARCHAR2 DEFAULT NULL,
175 X_Attribute13 VARCHAR2 DEFAULT NULL,
176 X_Attribute14 VARCHAR2 DEFAULT NULL,
177 X_Attribute15 VARCHAR2 DEFAULT NULL,
178 X_Request_Id NUMBER);
179
180
181 --
182 -- Procedure
183 -- Delete_Row
184 -- Purpose
185 -- used to delete a definition access detail record
186 -- History
187 -- 06/07/02 C Ma Created
188 -- Notes
189 --
190 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
191 X_Status_Code VARCHAR2);
192
193 --
194 -- Procedure
195 -- check_unique_name
196 -- Purpose
197 -- check whether the definition has already be included in the set
198 -- History
199 -- 06-07-2001 C Ma Created
200 -- Arguments
201 -- None
202 -- Notes
203 --
204 PROCEDURE check_unique_name(X_Definition_Access_Set_Id NUMBER,
205 X_Object_Type VARCHAR2,
206 X_Object_Key VARCHAR2);
207
208 --
209 -- Function
210 -- Submit_Conc_Request
211 --
212 -- Purpose
213 -- Launch Conversion Rate Change concurrent program for
214 -- Ispeed Daily Rates API
215 --
216 -- History
217 -- 04/16/04 C Ma Created
218 --
219 -- Arguments
220 --
221 --
222 -- Example
223 -- gl_daily_rates_pkg.Submit_Conc_Request(....);
224 --
225 -- Notes
226 --
227 FUNCTION submit_conc_request RETURN NUMBER;
228
229 END gl_defas_access_details_pkg;