eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ASO_QUOTE_STATUS_PKG

Source


1 PACKAGE ASO_QUOTE_STATUS_PKG AUTHID CURRENT_USER as
2 /* $Header: asotstas.pls 120.2 2005/06/29 12:40:34 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : ASO_QUOTE_STATUS_PKG
5 -- Purpose          :
6 -- History          :
7 --	08-01-2002 hyang - bug 2492841, performance bug
8 --   08-21-2002 hyang - bug 2522266, add back add_language
9 -- NOTE             :
10 -- End of Comments
11 
12 PROCEDURE Insert_Row(
13           px_QUOTE_STATUS_ID   IN OUT NOCOPY /* file.sql.39 change */  NUMBER,
14           p_CREATION_DATE    DATE,
15           p_CREATED_BY    NUMBER,
16           p_LAST_UPDATED_BY    NUMBER,
17           p_LAST_UPDATE_DATE    DATE,
18           p_LAST_UPDATE_LOGIN    NUMBER,
19           p_REQUEST_ID    NUMBER,
20           p_PROGRAM_APPLICATION_ID    NUMBER,
21           p_PROGRAM_ID    NUMBER,
22           p_PROGRAM_UPDATE_DATE    DATE,
23           p_STATUS_CODE    VARCHAR2,
24           p_UPDATE_ALLOWED_FLAG    VARCHAR2,
25           p_AUTO_VERSION_FLAG    VARCHAR2,
26           p_USER_MAINTAINABLE_FLAG    VARCHAR2,
27           p_EFFECTIVE_START_DATE    DATE,
28           p_EFFECTIVE_END_DATE    DATE,
29           p_ALLOW_LOV_TO_FLAG     VARCHAR2,
30           p_ALLOW_LOV_FROM_FLAG   VARCHAR2,
31           p_ALLOW_NEW_TO_FLAG     VARCHAR2,
32           p_ALLOW_NEW_FROM_FLAG   VARCHAR2,
33           p_SEED_TAG              VARCHAR2,
34           p_ENABLED_FLAG          VARCHAR2,
35           p_ATTRIBUTE_CATEGORY    VARCHAR2,
36           p_ATTRIBUTE1    VARCHAR2,
37           p_ATTRIBUTE2    VARCHAR2,
38           p_ATTRIBUTE3    VARCHAR2,
39           p_ATTRIBUTE4    VARCHAR2,
40           p_ATTRIBUTE5    VARCHAR2,
41           p_ATTRIBUTE6    VARCHAR2,
42           p_ATTRIBUTE7    VARCHAR2,
43           p_ATTRIBUTE8    VARCHAR2,
44           p_ATTRIBUTE9    VARCHAR2,
45           p_ATTRIBUTE10    VARCHAR2,
46           p_ATTRIBUTE11    VARCHAR2,
47           p_ATTRIBUTE12    VARCHAR2,
48           p_ATTRIBUTE13    VARCHAR2,
49           p_ATTRIBUTE14    VARCHAR2,
50           p_ATTRIBUTE15    VARCHAR2,
51            p_ATTRIBUTE16    VARCHAR2,
52           p_ATTRIBUTE17    VARCHAR2,
53           p_ATTRIBUTE18    VARCHAR2,
54           p_ATTRIBUTE19    VARCHAR2,
55           p_ATTRIBUTE20    VARCHAR2,
56 	  p_MEANING		VARCHAR2,
57 	  p_DESCRIPTION		VARCHAR2);
58 
59 PROCEDURE Update_Row(
60           p_QUOTE_STATUS_ID    NUMBER,
61           p_CREATION_DATE    DATE,
62           p_CREATED_BY    NUMBER,
63           p_LAST_UPDATED_BY    NUMBER,
64           p_LAST_UPDATE_DATE    DATE,
65           p_LAST_UPDATE_LOGIN    NUMBER,
66           p_REQUEST_ID    NUMBER,
67           p_PROGRAM_APPLICATION_ID    NUMBER,
68           p_PROGRAM_ID    NUMBER,
69           p_PROGRAM_UPDATE_DATE    DATE,
70           p_STATUS_CODE    VARCHAR2,
71           p_UPDATE_ALLOWED_FLAG    VARCHAR2,
72           p_AUTO_VERSION_FLAG    VARCHAR2,
73           p_USER_MAINTAINABLE_FLAG    VARCHAR2,
74           p_EFFECTIVE_START_DATE    DATE,
75           p_EFFECTIVE_END_DATE    DATE,
76           p_ALLOW_LOV_TO_FLAG     VARCHAR2,
77           p_ALLOW_LOV_FROM_FLAG   VARCHAR2,
78           p_ALLOW_NEW_TO_FLAG     VARCHAR2,
79           p_ALLOW_NEW_FROM_FLAG   VARCHAR2,
80           p_SEED_TAG              VARCHAR2,
81           p_ENABLED_FLAG          VARCHAR2,
82           p_ATTRIBUTE_CATEGORY    VARCHAR2,
83           p_ATTRIBUTE1    VARCHAR2,
84           p_ATTRIBUTE2    VARCHAR2,
85           p_ATTRIBUTE3    VARCHAR2,
86           p_ATTRIBUTE4    VARCHAR2,
87           p_ATTRIBUTE5    VARCHAR2,
88           p_ATTRIBUTE6    VARCHAR2,
89           p_ATTRIBUTE7    VARCHAR2,
90           p_ATTRIBUTE8    VARCHAR2,
91           p_ATTRIBUTE9    VARCHAR2,
92           p_ATTRIBUTE10    VARCHAR2,
93           p_ATTRIBUTE11    VARCHAR2,
94           p_ATTRIBUTE12    VARCHAR2,
95           p_ATTRIBUTE13    VARCHAR2,
96           p_ATTRIBUTE14    VARCHAR2,
97           p_ATTRIBUTE15    VARCHAR2,
98           p_ATTRIBUTE16    VARCHAR2,
99           p_ATTRIBUTE17    VARCHAR2,
100           p_ATTRIBUTE18    VARCHAR2,
101           p_ATTRIBUTE19    VARCHAR2,
102           p_ATTRIBUTE20    VARCHAR2,
103 	  p_MEANING		VARCHAR2,
104 	  p_DESCRIPTION		VARCHAR2);
105 
106 PROCEDURE Lock_Row(
107           p_QUOTE_STATUS_ID    NUMBER,
108           p_CREATION_DATE    DATE,
109           p_CREATED_BY    NUMBER,
110           p_LAST_UPDATED_BY    NUMBER,
111           p_LAST_UPDATE_DATE    DATE,
112           p_LAST_UPDATE_LOGIN    NUMBER,
113           p_REQUEST_ID    NUMBER,
114           p_PROGRAM_APPLICATION_ID    NUMBER,
115           p_PROGRAM_ID    NUMBER,
116           p_PROGRAM_UPDATE_DATE    DATE,
117           p_STATUS_CODE    VARCHAR2,
118           p_UPDATE_ALLOWED_FLAG    VARCHAR2,
119           p_AUTO_VERSION_FLAG    VARCHAR2,
120           p_USER_MAINTAINABLE_FLAG    VARCHAR2,
121           p_EFFECTIVE_START_DATE    DATE,
122           p_EFFECTIVE_END_DATE    DATE,
123           p_ALLOW_LOV_TO_FLAG     VARCHAR2,
124           p_ALLOW_LOV_FROM_FLAG   VARCHAR2,
125           p_ALLOW_NEW_TO_FLAG     VARCHAR2,
126           p_ALLOW_NEW_FROM_FLAG   VARCHAR2,
127           p_SEED_TAG              VARCHAR2,
128           p_ENABLED_FLAG          VARCHAR2,
129           p_ATTRIBUTE_CATEGORY    VARCHAR2,
130           p_ATTRIBUTE1    VARCHAR2,
131           p_ATTRIBUTE2    VARCHAR2,
132           p_ATTRIBUTE3    VARCHAR2,
133           p_ATTRIBUTE4    VARCHAR2,
134           p_ATTRIBUTE5    VARCHAR2,
135           p_ATTRIBUTE6    VARCHAR2,
136           p_ATTRIBUTE7    VARCHAR2,
137           p_ATTRIBUTE8    VARCHAR2,
138           p_ATTRIBUTE9    VARCHAR2,
139           p_ATTRIBUTE10    VARCHAR2,
140           p_ATTRIBUTE11    VARCHAR2,
141           p_ATTRIBUTE12    VARCHAR2,
142           p_ATTRIBUTE13    VARCHAR2,
143           p_ATTRIBUTE14    VARCHAR2,
144           p_ATTRIBUTE15    VARCHAR2,
145 	  p_MEANING		VARCHAR2,
146 	  p_DESCRIPTION		VARCHAR2);
147 
148 PROCEDURE Delete_Row(
149     p_QUOTE_STATUS_ID  NUMBER);
150 
151 procedure ADD_LANGUAGE;
152 
153 procedure LOAD_ROW (
154   X_STATUS_CODE   in VARCHAR2,
155   X_MEANING in VARCHAR2,
156   X_DESCRIPTION in VARCHAR2,
157   X_UPDATE_ALLOWED_FLAG  in VARCHAR2,
158   X_AUTO_VERSION_FLAG  in VARCHAR2,
159   X_USER_MAINTAINABLE_FLAG in  VARCHAR2,
160   X_EFFECTIVE_START_DATE IN date,
161   X_EFFECTIVE_END_DATE IN DATE,
162   X_ALLOW_LOV_TO_FLAG     VARCHAR2,
163   X_ALLOW_LOV_FROM_FLAG   VARCHAR2,
164   X_ALLOW_NEW_TO_FLAG     VARCHAR2,
165   X_ALLOW_NEW_FROM_FLAG   VARCHAR2,
166   X_SEED_TAG              VARCHAR2,
167   X_ENABLED_FLAG          VARCHAR2,
168   X_ATTRIBUTE_CATEGORY IN VARCHAR2,
169   X_ATTRIBUTE1  in VARCHAR2,
170   X_ATTRIBUTE2  in VARCHAR2,
171   X_ATTRIBUTE3  in VARCHAR2,
172   X_ATTRIBUTE4  in VARCHAR2,
173   X_ATTRIBUTE5  in VARCHAR2,
174   X_ATTRIBUTE6  in VARCHAR2,
175   X_ATTRIBUTE7  in VARCHAR2,
176   X_ATTRIBUTE8  in VARCHAR2,
177   X_ATTRIBUTE9  in VARCHAR2,
178   X_ATTRIBUTE10  in VARCHAR2,
179   X_ATTRIBUTE11  in VARCHAR2,
180   X_ATTRIBUTE12  in VARCHAR2,
181   X_ATTRIBUTE13  in VARCHAR2,
182   X_ATTRIBUTE14  in VARCHAR2,
183   X_ATTRIBUTE15  in VARCHAR2,
184   X_ATTRIBUTE16  in VARCHAR2,
185   X_ATTRIBUTE17  in VARCHAR2,
186   X_ATTRIBUTE18  in VARCHAR2,
187   X_ATTRIBUTE19  in VARCHAR2,
188   X_ATTRIBUTE20  in VARCHAR2,
189   X_OWNER   in VARCHAR2
190 );
191 procedure TRANSLATE_ROW (
192   X_QUOTE_STATUS_ID in NUMBER,
193   X_DESCRIPTION in VARCHAR2,
194   X_MEANING in VARCHAR2,
195   X_OWNER in VARCHAR2);
196 
197 PROCEDURE LOAD_SEED_ROW (
198   X_UPLOAD_MODE             IN VARCHAR2,
199   X_STATUS_CODE             IN VARCHAR2,
200   X_MEANING                 IN VARCHAR2,
201   X_DESCRIPTION             IN VARCHAR2,
202   X_UPDATE_ALLOWED_FLAG     IN VARCHAR2,
203   X_AUTO_VERSION_FLAG       IN VARCHAR2,
204   X_USER_MAINTAINABLE_FLAG  IN VARCHAR2,
205   X_EFFECTIVE_START_DATE    IN DATE,
206   X_EFFECTIVE_END_DATE      IN DATE,
207   X_ALLOW_LOV_TO_FLAG       IN VARCHAR2,
208   X_ALLOW_LOV_FROM_FLAG     IN VARCHAR2,
209   X_ALLOW_NEW_TO_FLAG       IN VARCHAR2,
210   X_ALLOW_NEW_FROM_FLAG     IN VARCHAR2,
211   X_SEED_TAG                IN VARCHAR2,
212   X_ENABLED_FLAG            IN VARCHAR2,
213   X_ATTRIBUTE_CATEGORY      IN VARCHAR2,
214   X_ATTRIBUTE1              IN VARCHAR2,
215   X_ATTRIBUTE2              IN VARCHAR2,
216   X_ATTRIBUTE3              IN VARCHAR2,
217   X_ATTRIBUTE4              IN VARCHAR2,
218   X_ATTRIBUTE5              IN VARCHAR2,
219   X_ATTRIBUTE6              IN VARCHAR2,
220   X_ATTRIBUTE7              IN VARCHAR2,
221   X_ATTRIBUTE8              IN VARCHAR2,
222   X_ATTRIBUTE9              IN VARCHAR2,
223   X_ATTRIBUTE10             IN VARCHAR2,
224   X_ATTRIBUTE11             IN VARCHAR2,
225   X_ATTRIBUTE12             IN VARCHAR2,
226   X_ATTRIBUTE13             IN VARCHAR2,
227   X_ATTRIBUTE14             IN VARCHAR2,
228   X_ATTRIBUTE15             IN VARCHAR2,
229   X_ATTRIBUTE16             IN VARCHAR2,
230   X_ATTRIBUTE17             IN VARCHAR2,
231   X_ATTRIBUTE18             IN VARCHAR2,
232   X_ATTRIBUTE19             IN VARCHAR2,
233   X_ATTRIBUTE20             IN VARCHAR2,
234   X_OWNER                   IN VARCHAR2);
235 
236 End ASO_QUOTE_STATUS_PKG;
237