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.JTF_AMV_ITEMS_PKG

Source


1 package JTF_AMV_ITEMS_PKG as
2 /* $Header: jtfvitms.pls 120.3 2005/11/28 08:42:29 vimohan ship $ */
3 procedure Load_Row(
4   X_ITEM_ID in VARCHAR2,
5   x_object_version_number in varchar2,
6   X_STATUS_CODE in VARCHAR2,
7   X_EFFECTIVE_START_DATE in VARCHAR2,
8   X_EXPIRATION_DATE in VARCHAR2,
9   X_APPLICATION_ID in VARCHAR2,
10   X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
11   X_PRIORITY in VARCHAR2,
12   X_PUBLICATION_DATE in VARCHAR2,
13   X_LANGUAGE_CODE in VARCHAR2,
14   X_ITEM_TYPE in VARCHAR2,
15   X_URL_STRING in VARCHAR2,
16   X_CONTENT_TYPE_ID in VARCHAR2,
17   X_OWNER_ID in VARCHAR2,
18   X_DEFAULT_APPROVER_ID in VARCHAR2,
19   X_ITEM_DESTINATION_TYPE in VARCHAR2,
20   X_ACCESS_NAME in VARCHAR2,
21   X_DELIVERABLE_TYPE_CODE in VARCHAR2,
22   X_APPLICABLE_TO_CODE in VARCHAR2,
23   X_ATTRIBUTE_CATEGORY in VARCHAR2,
24   X_ATTRIBUTE1 in VARCHAR2,
25   X_ATTRIBUTE2 in VARCHAR2,
26   X_ATTRIBUTE3 in VARCHAR2,
27   X_ATTRIBUTE4 in VARCHAR2,
28   X_ATTRIBUTE5 in VARCHAR2,
29   X_ATTRIBUTE6 in VARCHAR2,
30   X_ATTRIBUTE7 in VARCHAR2,
31   X_ATTRIBUTE8 in VARCHAR2,
32   X_ATTRIBUTE9 in VARCHAR2,
33   X_ATTRIBUTE10 in VARCHAR2,
34   X_ATTRIBUTE11 in VARCHAR2,
35   X_ATTRIBUTE12 in VARCHAR2,
36   X_ATTRIBUTE13 in VARCHAR2,
37   X_ATTRIBUTE14 in VARCHAR2,
38   X_ATTRIBUTE15 in VARCHAR2,
39   X_ITEM_NAME in VARCHAR2,
40   X_DESCRIPTION in VARCHAR2,
41   X_TEXT_STRING in VARCHAR2,
42   x_owner  in  varchar2,
43   X_CUSTOM_MODE in varchar2 default NULL,
44   x_last_update_date in varchar2 default NULL
45 ) ;
46 procedure Translate_row (
47   X_ITEM_ID in NUMBER,
48   X_ITEM_NAME in VARCHAR2,
49   X_DESCRIPTION in VARCHAR2,
50   X_TEXT_STRING in VARCHAR2,
51   X_OWNER in VARCHAR2,
52   X_CUSTOM_MODE in VARCHAR2 DEFAULT NULL,
53   X_LAST_UPDATE_DATE in VARCHAR2 DEFAULT NULL
54 ) ;
55 procedure INSERT_ROW (
56   X_ROWID in out NOCOPY VARCHAR2,
57   X_ITEM_ID in NUMBER,
58   X_OBJECT_VERSION_NUMBER in NUMBER,
59   X_CREATION_DATE in DATE,
60   X_CREATED_BY in NUMBER,
61   X_LAST_UPDATE_DATE in DATE,
62   X_LAST_UPDATED_BY in NUMBER,
63   X_LAST_UPDATE_LOGIN in NUMBER,
64   X_APPLICATION_ID in NUMBER,
65   X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
66   X_ITEM_NAME in VARCHAR2,
67   X_DESCRIPTION in VARCHAR2,
68   X_TEXT_STRING in VARCHAR2,
69   X_LANGUAGE_CODE in VARCHAR2,
70   X_STATUS_CODE in VARCHAR2,
71   X_EFFECTIVE_START_DATE in DATE,
72   X_EXPIRATION_DATE in DATE,
73   X_ITEM_TYPE in VARCHAR2,
74   X_URL_STRING in VARCHAR2,
75   X_PUBLICATION_DATE in DATE,
76   X_PRIORITY in VARCHAR2,
77   X_CONTENT_TYPE_ID in NUMBER,
78   X_OWNER_ID in NUMBER,
79   X_DEFAULT_APPROVER_ID in NUMBER,
80   X_ITEM_DESTINATION_TYPE in VARCHAR2,
81   X_ACCESS_NAME in VARCHAR2,
82   X_DELIVERABLE_TYPE_CODE in VARCHAR2,
83   X_APPLICABLE_TO_CODE in VARCHAR2,
84   X_ATTRIBUTE_CATEGORY in VARCHAR2,
85   X_ATTRIBUTE1 in VARCHAR2,
86   X_ATTRIBUTE2 in VARCHAR2,
87   X_ATTRIBUTE3 in VARCHAR2,
88   X_ATTRIBUTE4 in VARCHAR2,
89   X_ATTRIBUTE5 in VARCHAR2,
90   X_ATTRIBUTE6 in VARCHAR2,
91   X_ATTRIBUTE7 in VARCHAR2,
92   X_ATTRIBUTE8 in VARCHAR2,
93   X_ATTRIBUTE9 in VARCHAR2,
94   X_ATTRIBUTE10 in VARCHAR2,
95   X_ATTRIBUTE11 in VARCHAR2,
96   X_ATTRIBUTE12 in VARCHAR2,
97   X_ATTRIBUTE13 in VARCHAR2,
98   X_ATTRIBUTE14 in VARCHAR2,
99   X_ATTRIBUTE15 in VARCHAR2
100 );
101 procedure LOCK_ROW (
102   X_ITEM_ID in NUMBER,
103   X_PRIORITY in VARCHAR2,
104   X_ACCESS_NAME in VARCHAR2,
105   X_DELIVERABLE_TYPE_CODE in VARCHAR2,
106   X_APPLICABLE_TO_CODE in VARCHAR2,
107   X_ITEM_NAME in VARCHAR2,
108   X_DESCRIPTION in VARCHAR2,
109   X_TEXT_STRING in VARCHAR2,
110   X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
111   X_PUBLICATION_DATE in DATE,
112   X_OBJECT_VERSION_NUMBER in NUMBER,
113   X_LANGUAGE_CODE in VARCHAR2,
114   X_APPLICATION_ID in NUMBER,
115   X_STATUS_CODE in VARCHAR2,
116   X_EFFECTIVE_START_DATE in DATE,
117   X_EXPIRATION_DATE in DATE,
118   X_ITEM_TYPE in VARCHAR2,
119   X_URL_STRING in VARCHAR2,
120   X_CONTENT_TYPE_ID in NUMBER,
121   X_OWNER_ID in NUMBER,
122   X_DEFAULT_APPROVER_ID in NUMBER,
123   X_ITEM_DESTINATION_TYPE in VARCHAR2,
124   X_ATTRIBUTE_CATEGORY in VARCHAR2,
125   X_ATTRIBUTE1 in VARCHAR2,
126   X_ATTRIBUTE2 in VARCHAR2,
127   X_ATTRIBUTE3 in VARCHAR2,
128   X_ATTRIBUTE4 in VARCHAR2,
129   X_ATTRIBUTE5 in VARCHAR2,
130   X_ATTRIBUTE6 in VARCHAR2,
131   X_ATTRIBUTE7 in VARCHAR2,
132   X_ATTRIBUTE8 in VARCHAR2,
133   X_ATTRIBUTE9 in VARCHAR2,
134   X_ATTRIBUTE10 in VARCHAR2,
135   X_ATTRIBUTE11 in VARCHAR2,
136   X_ATTRIBUTE12 in VARCHAR2,
137   X_ATTRIBUTE13 in VARCHAR2,
138   X_ATTRIBUTE14 in VARCHAR2,
139   X_ATTRIBUTE15 in VARCHAR2
140 );
141 procedure UPDATE_ROW (
142   X_ITEM_ID in NUMBER,
143   X_OBJECT_VERSION_NUMBER in NUMBER,
144   X_LAST_UPDATE_DATE in DATE,
145   X_LAST_UPDATED_BY in NUMBER,
146   X_LAST_UPDATE_LOGIN in NUMBER,
147   X_APPLICATION_ID in NUMBER,
148   X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
149   X_ITEM_NAME in VARCHAR2,
150   X_DESCRIPTION in VARCHAR2,
151   X_TEXT_STRING in VARCHAR2,
152   X_LANGUAGE_CODE in VARCHAR2,
153   X_STATUS_CODE in VARCHAR2,
154   X_EFFECTIVE_START_DATE in DATE,
155   X_EXPIRATION_DATE in DATE,
156   X_ITEM_TYPE in VARCHAR2,
157   X_URL_STRING in VARCHAR2,
158   X_PUBLICATION_DATE in DATE,
159   X_PRIORITY in VARCHAR2,
160   X_CONTENT_TYPE_ID in NUMBER,
161   X_OWNER_ID in NUMBER,
162   X_DEFAULT_APPROVER_ID in NUMBER,
163   X_ITEM_DESTINATION_TYPE in VARCHAR2,
164   X_ACCESS_NAME in VARCHAR2,
165   X_DELIVERABLE_TYPE_CODE in VARCHAR2,
166   X_APPLICABLE_TO_CODE in VARCHAR2,
167   X_ATTRIBUTE_CATEGORY in VARCHAR2,
168   X_ATTRIBUTE1 in VARCHAR2,
169   X_ATTRIBUTE2 in VARCHAR2,
170   X_ATTRIBUTE3 in VARCHAR2,
171   X_ATTRIBUTE4 in VARCHAR2,
172   X_ATTRIBUTE5 in VARCHAR2,
173   X_ATTRIBUTE6 in VARCHAR2,
174   X_ATTRIBUTE7 in VARCHAR2,
175   X_ATTRIBUTE8 in VARCHAR2,
176   X_ATTRIBUTE9 in VARCHAR2,
177   X_ATTRIBUTE10 in VARCHAR2,
178   X_ATTRIBUTE11 in VARCHAR2,
179   X_ATTRIBUTE12 in VARCHAR2,
180   X_ATTRIBUTE13 in VARCHAR2,
181   X_ATTRIBUTE14 in VARCHAR2,
182   X_ATTRIBUTE15 in VARCHAR2
183 );
184 procedure DELETE_ROW (
185   X_ITEM_ID in NUMBER
186 );
187 procedure ADD_LANGUAGE;
188 
189 procedure LOAD_SEED_ROW(
190   x_upload_mode       in varchar2,
191   x_item_id           in varchar2,
192   x_item_name         in varchar2,
193   x_description       in varchar2,
194   x_text_string       in varchar2,
195   x_owner             in varchar2,
196   x_object_version_number in varchar2,
197   x_status_code           in varchar2,
198   x_effective_start_date  in varchar2,
199   x_expiration_date   in varchar2,
200   x_application_id    in varchar2,
201   x_external_access_flag  in varchar2,
202   x_priority          in varchar2,
203   x_publication_date  in varchar2,
204   x_language_code     in varchar2,
205   x_item_type         in varchar2,
206   x_url_string        in varchar2,
207   x_content_type_id   in varchar2,
208   x_owner_id          in varchar2,
209   x_default_approver_id     in varchar2,
210   x_item_destination_type   in varchar2,
211   x_access_name             in varchar2,
212   x_deliverable_type_code   in varchar2,
213   x_applicable_to_code      in varchar2,
214   x_attribute_category      in varchar2,
215   x_attribute1  in varchar2,
216   x_attribute2  in varchar2,
217   x_attribute3  in varchar2,
218   x_attribute4  in varchar2,
219   x_attribute5  in varchar2,
220   x_attribute6  in varchar2,
221   x_attribute7  in varchar2,
222   x_attribute8  in varchar2,
223   x_attribute9  in varchar2,
224   x_attribute10  in varchar2,
225   x_attribute11  in varchar2,
226   x_attribute12  in varchar2,
227   x_attribute13  in varchar2,
228   x_attribute14  in varchar2,
229   x_attribute15  in varchar2,
230   x_custom_mode             in varchar2,
231   x_last_update_date        in varchar2
232   );
233 
234 end JTF_AMV_ITEMS_PKG;
235