1 Package ASO_SUP_TEMPLATE_SCOPE_PKG AS
2 /* $Header: asosptss.pls 120.1 2005/06/29 12:38:31 appldev ship $*/
3
4 -- Purpose: To Insert/Update/delete/Lock data for ASO_SUP_TEMPLATE_SCOPE table for HTML Quoting
5 -- File name asosptss.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_TEMPLATE_SCOPE table
20 -- Type : Private
21 -- Pre-reqs : None
22 -- Parameters :
23 -- IN :
24 -- P_SCOPE_TYPE IN VARCHAR2 Required
25 -- P_TEMPLATE_ID IN NUMBER Required
26 -- P_SCOPE_VALUE IN NUMBER Required
27
28
29
30
31 -- IN OUT NOCOPY /* file.sql.39 change */ : PX_TEMPLATE_SCOPE_ID IN OUT NUMBER
32 -- Version :
33 -- Current version 1.0
34 -- Previous version 1.0
35 -- Initial version 1.0
36 -- End of comments
37 --------------------------------------------------------------------------------------
38
39
40 PROCEDURE INSERT_ROW
41 (
42 PX_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
43 PX_TEMPLATE_SCOPE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
44 P_created_by IN NUMBER ,
45 P_creation_date IN DATE ,
46 P_last_updated_by IN NUMBER,
47 P_last_update_date IN DATE,
48 P_last_update_login IN NUMBER,
49 P_TEMPLATE_ID IN NUMBER,
50 P_SCOPE_TYPE IN VARCHAR2,
51 P_SCOPE_VALUE IN NUMBER,
52 P_CONTEXT IN VARCHAR2 DEFAULT NULL,
53 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
54 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
55 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
56 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
57 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
58 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
59 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
60 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
61 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
62 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
63 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
64 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
65 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
66 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
67 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
68 P_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
69 P_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
70 P_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
71 P_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
72 P_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
73 );
74
75
76 --------------------------------------------------------------------------------------
77 -- API Signatures--
78 --------------------------------------------------------------------------------------
79 -- 2.
80 -- Start of comments
81 -- API name : UPDATE_ROW
82 -- Purpose : Procedure to update ASO_SUP_TEMPLATE_SCOPE table
83 -- Type : Private
84 -- Pre-reqs : None
85 -- Parameters :
86 -- IN :
87 -- P_TEMPLATE_SCOPE_ID IN NUMBER Required
88 -- P_SCOPE_TYPE IN VARCHAR2 Required
89 -- P_TEMPLATE_ID IN NUMBER Required
90 -- P_SCOPE_VALUE IN NUMBER Required
91
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_SCOPE_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_TEMPLATE_ID IN NUMBER,
112 P_SCOPE_TYPE IN VARCHAR2,
113 P_SCOPE_VALUE 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 --------------------------------------------------------------------------------------
141 -- API Signatures--
142 --------------------------------------------------------------------------------------
143 -- 3.
144 -- Start of comments
145 -- API name : DELETE_ROW
146 -- Purpose : Procedure to delete from ASO_SUP_TEMPLATE_SCOPE table
147 -- Type : Private
148 -- Pre-reqs : None
149 -- Parameters :
150 -- IN :
151 -- P_TEMPLATE_SCOPE_ID IN NUMBER Required
152
153 -- OUT NOCOPY /* file.sql.39 change */ : None
154 -- Version :
155 -- Current version 1.0
156 -- Previous version 1.0
157 -- Initial version 1.0
158 -- End of comments
159 --------------------------------------------------------------------------------------
160
161 procedure DELETE_ROW (
162 P_TEMPLATE_SCOPE_ID IN NUMBER
163
164 );
165
166
167 --------------------------------------------------------------------------------------
168 -- API Signatures--
169 --------------------------------------------------------------------------------------
170 -- 4.
171 -- Start of comments
172 -- API name : LOCK_ROW
173 -- Purpose : Procedure to Lock ASO_SUP_TEMPLATE_SCOPE table
174 -- Type : Private
175 -- Pre-reqs : None
176 -- Parameters :
177 -- IN :
178 -- P_TEMPLATE_SCOPE_ID IN NUMBER Required
179 -- P_SCOPE_TYPE IN VARCHAR2 Required
180 -- P_TEMPLATE_ID IN NUMBER Required
181 -- P_SCOPE_VALUE IN NUMBER Required
182
183 --
184
185
186 -- OUT NOCOPY /* file.sql.39 change */ :
187
188 -- Version :
189 -- Current version 1.0
190 -- Previous version 1.0
191 -- Initial version 1.0
192 -- End of comments
193 --------------------------------------------------------------------------------------
194 PROCEDURE LOCK_ROW
195 (
196 P_TEMPLATE_SCOPE_ID IN NUMBER,
197 P_created_by IN NUMBER ,
198 P_creation_date IN DATE ,
199 P_last_updated_by IN NUMBER,
200 P_last_update_date IN DATE,
201 P_last_update_login IN NUMBER,
202 P_TEMPLATE_ID IN NUMBER,
203 P_SCOPE_TYPE IN VARCHAR2,
204 P_SCOPE_VALUE IN NUMBER,
205 P_CONTEXT IN VARCHAR2,
206 P_ATTRIBUTE1 IN VARCHAR2,
207 P_ATTRIBUTE2 IN VARCHAR2,
208 P_ATTRIBUTE3 IN VARCHAR2,
209 P_ATTRIBUTE4 IN VARCHAR2,
210 P_ATTRIBUTE5 IN VARCHAR2,
211 P_ATTRIBUTE6 IN VARCHAR2,
212 P_ATTRIBUTE7 IN VARCHAR2,
213 P_ATTRIBUTE8 IN VARCHAR2,
214 P_ATTRIBUTE9 IN VARCHAR2,
215 P_ATTRIBUTE10 IN VARCHAR2,
216 P_ATTRIBUTE11 IN VARCHAR2,
217 P_ATTRIBUTE12 IN VARCHAR2,
218 P_ATTRIBUTE13 IN VARCHAR2,
219 P_ATTRIBUTE14 IN VARCHAR2,
220 P_ATTRIBUTE15 IN VARCHAR2
221 );
222
223
224 END; -- Package Specification ASO_SUP_TEMPLATE_SCOPE_PKG