1 Package ASO_SUP_INSTANCE_VALUE_PKG AS
2 /* $Header: asospivs.pls 120.1 2005/06/29 15:58:33 appldev ship $*/
3
4 -- Purpose: To Insert/Update/delete/Lock data for ASO_SUP_INSTANCE_VALUE table for HTML Quoting
5 -- File name aso*.pls
6
7
8 -- MODIFICATION HISTORY
9 -- Person Date Comments
10 -- --------- ------ ------------------------------------------
11 -- Sarala Biswal 01/18/02 Created Package
12
13 --------------------------------------------------------------------------------------
14 -- API Signatures--
15 --------------------------------------------------------------------------------------
16 -- 1.
17 -- Start of comments
18 -- API name : INSERT_ROW
19 -- Purpose : Procedure to insert into ASO_SUP_INSTANCE_VALUE table
20 -- Type : Private
21 -- Pre-reqs : None
22 -- Parameters :
23 -- IN :
24
25 -- P_SECTION_COMPONENT_MAP_ID IN NUMBER Required
26 -- P_Owner_Table_Name IN VARCHAR2 Optional
27 -- P_Owner_Table_Id IN NUMBER Optional
28 -- P_Value IN VARCHAR2 Optional
29 -- P_Value_Type_Qualifier IN VARCHAR2 Optional
30 -- P_Response_id IN NUMBER Optional
31
32
33
34 -- IN OUT NOCOPY /* file.sql.39 change */ : PX_VALUE_ID
35 -- PX_ROWID
36 -- Version :
37 -- Current version 1.0
38 -- Previous version 1.0
39 -- Initial version 1.0
40 -- End of comments
41 --------------------------------------------------------------------------------------
42
43
44 PROCEDURE INSERT_ROW
45 (
46 PX_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
47 PX_INSTANCE_VALUE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
48 P_SECT_COMP_MAP_ID IN NUMBER,
49 P_Template_Instance_ID IN NUMBER,
50 P_created_by IN NUMBER ,
51 P_last_updated_by IN NUMBER,
52 P_last_update_login IN NUMBER,
53 P_creation_date IN DATE DEFAULT SYSDATE,
54 P_last_update_date IN DATE DEFAULT SYSDATE,
55 P_Value IN VARCHAR2 DEFAULT NULL,
56 P_Value_Type_Qualifier IN VARCHAR2 DEFAULT NULL,
57 P_Response_id IN NUMBER DEFAULT NULL,
58 P_CONTEXT IN VARCHAR2 DEFAULT NULL,
59 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
60 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
61 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
62 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
63 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
64 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
65 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
66 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
67 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
68 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
69 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
70 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
71 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
72 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
73 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
74 P_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
75 P_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
76 P_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
77 P_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
78 P_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
79 p_OBJECT_VERSION_NUMBER IN NUMBER
80 );
81
82
83 --------------------------------------------------------------------------------------
84 -- API Signatures--
85 --------------------------------------------------------------------------------------
86 -- 2.
87 -- Start of comments
88 -- API name : UPDATE_ROW
89 -- Purpose : Procedure to update ASO_SUP_INSTANCE_VALUE table
90 -- Type : Private
91 -- Pre-reqs : None
92 -- Parameters :
93 -- IN :
94 -- P_VALUE_ID IN NUMBER Required
95 -- P_SECTION_COMPONENT_MAP_ID IN NUMBER Optional
96 -- P_Owner_Table_Name IN VARCHAR2 Optional
97 -- P_Owner_Table_Id IN NUMBER Optional
98 -- P_Value IN VARCHAR2 Optional
99 -- P_Value_Type_Qualifier IN VARCHAR2 Optional
100 -- P_Response_id IN NUMBER Optional
101
102
103 -- OUT NOCOPY /* file.sql.39 change */ : None
104 -- Version :
105 -- Current version 1.0
106 -- Previous version 1.0
107 -- Initial version 1.0
108 -- End of comments
109 --------------------------------------------------------------------------------------
110
111
112
113 PROCEDURE UPDATE_ROW
114 (
115 P_INSTANCE_VALUE_ID IN NUMBER,
116 P_SECT_COMP_MAP_ID IN NUMBER,
117 P_Template_Instance_ID IN NUMBER,
118 P_last_updated_by IN NUMBER,
119 P_last_update_date IN DATE DEFAULT SYSDATE,
120 P_last_update_login IN NUMBER,
121 P_Value IN VARCHAR2,
122 P_Value_Type_Qualifier IN VARCHAR2,
123 P_Response_id IN NUMBER,
124 P_CONTEXT IN VARCHAR2,
125 P_ATTRIBUTE1 IN VARCHAR2,
126 P_ATTRIBUTE2 IN VARCHAR2,
127 P_ATTRIBUTE3 IN VARCHAR2,
128 P_ATTRIBUTE4 IN VARCHAR2,
129 P_ATTRIBUTE5 IN VARCHAR2,
130 P_ATTRIBUTE6 IN VARCHAR2,
131 P_ATTRIBUTE7 IN VARCHAR2,
132 P_ATTRIBUTE8 IN VARCHAR2,
133 P_ATTRIBUTE9 IN VARCHAR2,
134 P_ATTRIBUTE10 IN VARCHAR2,
135 P_ATTRIBUTE11 IN VARCHAR2,
136 P_ATTRIBUTE12 IN VARCHAR2,
137 P_ATTRIBUTE13 IN VARCHAR2,
138 P_ATTRIBUTE14 IN VARCHAR2,
139 P_ATTRIBUTE15 IN VARCHAR2,
140 P_ATTRIBUTE16 IN VARCHAR2,
141 P_ATTRIBUTE17 IN VARCHAR2,
142 P_ATTRIBUTE18 IN VARCHAR2,
143 P_ATTRIBUTE19 IN VARCHAR2,
144 P_ATTRIBUTE20 IN VARCHAR2,
145 p_OBJECT_VERSION_NUMBER IN NUMBER
146 );
147
148
149
150 --------------------------------------------------------------------------------------
151 -- API Signatures--
152 --------------------------------------------------------------------------------------
153 -- 3.
154 -- Start of comments
155 -- API name : DELETE_ROW
156 -- Purpose : Procedure to delete from ASO_SUP_INSTANCE_VALUE table
157 -- Type : Private
158 -- Pre-reqs : None
159 -- Parameters :
160 -- IN :
161 -- P_VALUE_ID IN NUMBER Required
162
163 -- OUT NOCOPY /* file.sql.39 change */ : None
164 -- Version :
165 -- Current version 1.0
166 -- Previous version 1.0
167 -- Initial version 1.0
168 -- End of comments
169 --------------------------------------------------------------------------------------
170
171 procedure DELETE_ROW (
172 P_INSTANCE_VALUE_ID IN NUMBER
173
174 );
175
176
177 --------------------------------------------------------------------------------------
178 -- API Signatures--
179 --------------------------------------------------------------------------------------
180 -- 4.
181 -- Start of comments
182 -- API name : LOCK_ROW
183 -- Purpose : Procedure to Lock ASO_SUP_INSTANCE_VALUE table
184 -- Type : Private
185 -- Pre-reqs : None
186 -- Parameters :
187 -- IN :
188 -- P_VALUE_ID IN NUMBER Required
189 -- P_SECTION_COMPONENT_MAP_ID IN NUMBER Optional
190 -- P_Owner_Table_Name IN VARCHAR2 Optional
191 -- P_Owner_Table_Id IN NUMBER Optional
192 -- P_Value IN VARCHAR2 Optional
193 -- P_Value_Type_Qualifier IN VARCHAR2 Optional
194 -- P_Response_id IN NUMBER Optional
195 --
196
197
198 -- OUT NOCOPY /* file.sql.39 change */ :
199
200 -- Version :
201 -- Current version 1.0
202 -- Previous version 1.0
203 -- Initial version 1.0
204 -- End of comments
205 --------------------------------------------------------------------------------------
206 PROCEDURE LOCK_ROW
207 (
208 P_INSTANCE_VALUE_ID IN NUMBER,
209 --p_OBJECT_VERSION_NUMBER IN NUMBER,
210 P_SECT_COMP_MAP_ID IN NUMBER,
211 P_Template_Instance_ID IN NUMBER,
212 P_created_by IN NUMBER ,
213 P_creation_date IN DATE ,
214 P_last_updated_by IN NUMBER,
215 P_last_update_date IN DATE,
216 P_last_update_login IN NUMBER,
217 P_Value IN VARCHAR2,
218 P_Value_Type_Qualifier IN VARCHAR2,
219 P_Response_id IN NUMBER,
220 P_CONTEXT IN VARCHAR2,
221 P_ATTRIBUTE1 IN VARCHAR2,
222 P_ATTRIBUTE2 IN VARCHAR2,
223 P_ATTRIBUTE3 IN VARCHAR2,
224 P_ATTRIBUTE4 IN VARCHAR2,
225 P_ATTRIBUTE5 IN VARCHAR2,
226 P_ATTRIBUTE6 IN VARCHAR2,
227 P_ATTRIBUTE7 IN VARCHAR2,
228 P_ATTRIBUTE8 IN VARCHAR2,
229 P_ATTRIBUTE9 IN VARCHAR2,
230 P_ATTRIBUTE10 IN VARCHAR2,
231 P_ATTRIBUTE11 IN VARCHAR2,
232 P_ATTRIBUTE12 IN VARCHAR2,
233 P_ATTRIBUTE13 IN VARCHAR2,
234 P_ATTRIBUTE14 IN VARCHAR2,
235 P_ATTRIBUTE15 IN VARCHAR2
236 );
237
238
239
240 END; -- Package Specification ASO_SUP_INSTANCE_VALUE_PKG