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