1 Package ASO_SUP_TMPL_INSTANCE_PKG AS
2 /* $Header: asosptis.pls 120.1 2005/06/29 12:38:25 appldev ship $*/
3
4 -- Purpose: To Insert/Update/delete/Lock data for ASO_SUP_TMPL_INSTANCE table for HTML Quoting
5 -- File name asosptis.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_INSTANCE 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_TEMPLATE_ID IN NUMBER,
26 -- P_Owner_Table_Name IN VARCHAR2,
27 -- P_Owner_Table_Id IN NUMBER,
28
29
30
31 -- IN OUT NOCOPY /* file.sql.39 change */ : PX_TEMPLATE_SECTION_MAP_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_INSTANCE_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_Owner_Table_Name IN VARCHAR2,
51 P_Owner_Table_Id 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 p_OBJECT_VERSION_NUMBER IN NUMBER
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_INSTANCE table
84 -- Type : Private
85 -- Pre-reqs : None
86 -- Parameters :
87 -- IN :
88 -- P_TEMPLATE_INSTANCE_ID IN NUMBER Required
89 -- P_TEMPLATE_ID IN NUMBER Required
90 -- P_DISPLAY_SEQUENCE IN NUMBER Required
91
92
93
94 -- OUT NOCOPY /* file.sql.39 change */ : None
95 -- Version :
96 -- Current version 1.0
97 -- Previous version 1.0
98 -- Initial version 1.0
99 -- End of comments
100 --------------------------------------------------------------------------------------
101
102
103
104 PROCEDURE UPDATE_ROW
105 (
106 P_TEMPLATE_INSTANCE_ID IN NUMBER,
107 P_last_updated_by IN NUMBER,
108 P_last_update_date IN DATE,
109 P_last_update_login IN NUMBER,
110 P_TEMPLATE_ID IN NUMBER,
111 P_Owner_Table_Name IN VARCHAR2,
112 P_Owner_Table_Id IN NUMBER,
113 P_CONTEXT IN VARCHAR2,
114 P_ATTRIBUTE1 IN VARCHAR2,
115 P_ATTRIBUTE2 IN VARCHAR2,
116 P_ATTRIBUTE3 IN VARCHAR2,
117 P_ATTRIBUTE4 IN VARCHAR2,
118 P_ATTRIBUTE5 IN VARCHAR2,
119 P_ATTRIBUTE6 IN VARCHAR2,
120 P_ATTRIBUTE7 IN VARCHAR2,
121 P_ATTRIBUTE8 IN VARCHAR2,
122 P_ATTRIBUTE9 IN VARCHAR2,
123 P_ATTRIBUTE10 IN VARCHAR2,
124 P_ATTRIBUTE11 IN VARCHAR2,
125 P_ATTRIBUTE12 IN VARCHAR2,
126 P_ATTRIBUTE13 IN VARCHAR2,
127 P_ATTRIBUTE14 IN VARCHAR2,
128 P_ATTRIBUTE15 IN VARCHAR2,
129 P_ATTRIBUTE16 IN VARCHAR2,
130 P_ATTRIBUTE17 IN VARCHAR2,
131 P_ATTRIBUTE18 IN VARCHAR2,
132 P_ATTRIBUTE19 IN VARCHAR2,
133 P_ATTRIBUTE20 IN VARCHAR2,
134 p_OBJECT_VERSION_NUMBER IN NUMBER
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_INSTANCE table
146 -- Type : Private
147 -- Pre-reqs : None
148 -- Parameters :
149 -- IN :
150 -- P_TEMPLATE_INSTANCE_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_INSTANCE_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_INSTANCE table
173 -- Type : Private
174 -- Pre-reqs : None
175 -- Parameters :
176 -- IN :
177 -- P_TEMPLATE_INSTANCE_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_INSTANCE_ID IN NUMBER,
196 --p_OBJECT_VERSION_NUMBER 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_Owner_Table_Name IN VARCHAR2,
204 P_Owner_Table_Id 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
225 END; -- Package Specification ASO_SUP_TMPL_INSTANCE_PKG