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