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