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_ATTCHS_PKG

Source


1 package JTF_AMV_ATTCHS_PKG AUTHID CURRENT_USER as
2 /* $Header: jtfvatts.pls 120.3 2005/11/28 08:40:50 vimohan ship $ */
3 procedure Load_Row(
4   X_ATTACHMENT_ID in VARCHAR2,
5   X_OBJECT_VERSION_NUMBER in VARCHAR2,
6   X_OWNER_USER_ID in VARCHAR2,
7   X_ATTACHMENT_USED_BY_ID in VARCHAR2,
8   X_ATTACHMENT_USED_BY in VARCHAR2,
9   X_VERSION in VARCHAR2,
10   X_ENABLED_FLAG in VARCHAR2,
11   X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
12   X_FILE_ID in VARCHAR2,
13   X_FILE_NAME in VARCHAR2,
14   X_FILE_EXTENSION in VARCHAR2,
15   X_KEYWORDS in VARCHAR2,
16   X_DISPLAY_WIDTH in VARCHAR2,
17   X_DISPLAY_HEIGHT in VARCHAR2,
18   X_DISPLAY_LOCATION in VARCHAR2,
19   X_LINK_TO in VARCHAR2,
20   X_LINK_URL in VARCHAR2,
21   X_SEND_FOR_PREVIEW_FLAG in VARCHAR2,
22   X_ATTACHMENT_TYPE in VARCHAR2,
23   X_LANGUAGE_CODE in VARCHAR2,
24   X_APPLICATION_ID in VARCHAR2,
25   X_DESCRIPTION in VARCHAR2,
26   X_DEFAULT_STYLE_SHEET in VARCHAR2,
27   X_DISPLAY_URL in VARCHAR2,
28   X_DISPLAY_RULE_ID in VARCHAR2,
29   X_DISPLAY_PROGRAM in VARCHAR2,
30   X_ATTRIBUTE_CATEGORY in VARCHAR2,
31   X_ATTRIBUTE1 in VARCHAR2,
32   X_ATTRIBUTE2 in VARCHAR2,
33   X_ATTRIBUTE3 in VARCHAR2,
34   X_ATTRIBUTE4 in VARCHAR2,
35   X_ATTRIBUTE5 in VARCHAR2,
36   X_ATTRIBUTE6 in VARCHAR2,
37   X_ATTRIBUTE7 in VARCHAR2,
38   X_ATTRIBUTE8 in VARCHAR2,
39   X_ATTRIBUTE9 in VARCHAR2,
40   X_ATTRIBUTE10 in VARCHAR2,
41   X_ATTRIBUTE11 in VARCHAR2,
42   X_ATTRIBUTE12 in VARCHAR2,
43   X_ATTRIBUTE13 in VARCHAR2,
44   X_ATTRIBUTE14 in VARCHAR2,
45   X_ATTRIBUTE15 in VARCHAR2,
46   X_DISPLAY_TEXT in VARCHAR2 := NULL,
47   X_ALTERNATE_TEXT in VARCHAR2 := NULL,
48   X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
49   X_DOCUMENT_ID in VARCHAR2 := NULL,
50   X_SECURED_FLAG in VARCHAR2 := NULL,
51   x_owner  in  varchar2,
52   X_CUSTOM_MODE varchar2 default NULL,
53   x_last_update_date VARCHAR2 DEFAULT NULL
54 );
55 procedure INSERT_ROW (
56   X_ROWID in out NOCOPY VARCHAR2,
57   X_ATTACHMENT_ID in NUMBER,
58   X_LAST_UPDATE_DATE in DATE,
59   X_LAST_UPDATED_BY in NUMBER,
60   X_CREATION_DATE in DATE,
61   X_CREATED_BY in NUMBER,
62   X_LAST_UPDATE_LOGIN in NUMBER,
63   X_OBJECT_VERSION_NUMBER in NUMBER,
64   X_OWNER_USER_ID in NUMBER,
65   X_ATTACHMENT_USED_BY_ID in NUMBER,
66   X_ATTACHMENT_USED_BY in VARCHAR2,
67   X_VERSION in VARCHAR2,
68   X_ENABLED_FLAG in VARCHAR2,
69   X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
70   X_FILE_ID in NUMBER,
71   X_FILE_NAME in VARCHAR2,
72   X_FILE_EXTENSION in VARCHAR2,
73   X_KEYWORDS in VARCHAR2,
74   X_DISPLAY_WIDTH in NUMBER,
75   X_DISPLAY_HEIGHT in NUMBER,
76   X_DISPLAY_LOCATION in VARCHAR2,
77   X_LINK_TO in VARCHAR2,
78   X_LINK_URL in VARCHAR2,
79   X_SEND_FOR_PREVIEW_FLAG in VARCHAR2,
80   X_ATTACHMENT_TYPE in VARCHAR2,
81   X_LANGUAGE_CODE in VARCHAR2,
82   X_APPLICATION_ID in NUMBER,
83   X_DESCRIPTION in VARCHAR2,
84   X_DEFAULT_STYLE_SHEET in VARCHAR2,
85   X_DISPLAY_URL in VARCHAR2,
86   X_DISPLAY_RULE_ID in NUMBER,
87   X_DISPLAY_PROGRAM in VARCHAR2,
88   X_ATTRIBUTE_CATEGORY in VARCHAR2,
89   X_ATTRIBUTE1 in VARCHAR2,
90   X_ATTRIBUTE2 in VARCHAR2,
91   X_ATTRIBUTE3 in VARCHAR2,
92   X_ATTRIBUTE4 in VARCHAR2,
93   X_ATTRIBUTE5 in VARCHAR2,
94   X_ATTRIBUTE6 in VARCHAR2,
95   X_ATTRIBUTE7 in VARCHAR2,
96   X_ATTRIBUTE8 in VARCHAR2,
97   X_ATTRIBUTE9 in VARCHAR2,
98   X_ATTRIBUTE10 in VARCHAR2,
99   X_ATTRIBUTE11 in VARCHAR2,
100   X_ATTRIBUTE12 in VARCHAR2,
101   X_ATTRIBUTE13 in VARCHAR2,
102   X_ATTRIBUTE14 in VARCHAR2,
103   X_ATTRIBUTE15 in VARCHAR2,
104   X_DISPLAY_TEXT in VARCHAR2 := NULL,
105   X_ALTERNATE_TEXT in VARCHAR2 := NULL,
106   X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
107   X_DOCUMENT_ID in NUMBER := NULL,
108   X_SECURED_FLAG in VARCHAR2 := NULL
109 );
110 procedure UPDATE_ROW (
111   X_ATTACHMENT_ID in NUMBER,
112   X_LAST_UPDATE_DATE in DATE,
113   X_LAST_UPDATED_BY in NUMBER,
114   X_LAST_UPDATE_LOGIN in NUMBER,
115   X_OBJECT_VERSION_NUMBER in NUMBER,
116   X_OWNER_USER_ID in NUMBER,
117   X_ATTACHMENT_USED_BY_ID in NUMBER,
118   X_ATTACHMENT_USED_BY in VARCHAR2,
119   X_VERSION in VARCHAR2,
120   X_ENABLED_FLAG in VARCHAR2,
121   X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
122   X_FILE_ID in NUMBER,
123   X_FILE_NAME in VARCHAR2,
124   X_FILE_EXTENSION in VARCHAR2,
125   X_KEYWORDS in VARCHAR2,
126   X_DISPLAY_WIDTH in NUMBER,
127   X_DISPLAY_HEIGHT in NUMBER,
128   X_DISPLAY_LOCATION in VARCHAR2,
129   X_LINK_TO in VARCHAR2,
130   X_LINK_URL in VARCHAR2,
131   X_SEND_FOR_PREVIEW_FLAG in VARCHAR2,
132   X_ATTACHMENT_TYPE in VARCHAR2,
133   X_LANGUAGE_CODE in VARCHAR2,
134   X_APPLICATION_ID in NUMBER,
135   X_DESCRIPTION in VARCHAR2,
136   X_DEFAULT_STYLE_SHEET in VARCHAR2,
137   X_DISPLAY_URL in VARCHAR2,
138   X_DISPLAY_RULE_ID in NUMBER,
139   X_DISPLAY_PROGRAM in VARCHAR2,
140   X_ATTRIBUTE_CATEGORY in VARCHAR2,
141   X_ATTRIBUTE1 in VARCHAR2,
142   X_ATTRIBUTE2 in VARCHAR2,
143   X_ATTRIBUTE3 in VARCHAR2,
144   X_ATTRIBUTE4 in VARCHAR2,
145   X_ATTRIBUTE5 in VARCHAR2,
146   X_ATTRIBUTE6 in VARCHAR2,
147   X_ATTRIBUTE7 in VARCHAR2,
148   X_ATTRIBUTE8 in VARCHAR2,
149   X_ATTRIBUTE9 in VARCHAR2,
150   X_ATTRIBUTE10 in VARCHAR2,
151   X_ATTRIBUTE11 in VARCHAR2,
152   X_ATTRIBUTE12 in VARCHAR2,
153   X_ATTRIBUTE13 in VARCHAR2,
154   X_ATTRIBUTE14 in VARCHAR2,
155   X_ATTRIBUTE15 in VARCHAR2,
156   X_DISPLAY_TEXT in VARCHAR2 := NULL,
157   X_ALTERNATE_TEXT in VARCHAR2 := NULL,
158   X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
159   X_DOCUMENT_ID in NUMBER := NULL,
160   X_SECURED_FLAG in VARCHAR2 := NULL
161 );
162 
163 procedure LOAD_SEED_ROW(
164 x_upload_mode in varchar2,
165 x_attachment_id in varchar2,
166 x_object_version_number in varchar2,
167 x_owner_user_id in varchar2,
168 x_attachment_used_by_id in varchar2,
169 x_attachment_used_by in varchar2,
170 x_version in varchar2,
171 x_enabled_flag in varchar2,
172 x_can_fulfill_electronic_flag in varchar2,
173 x_file_id in varchar2,
174 x_file_name in varchar2,
175 x_file_extension in varchar2,
176 x_keywords in varchar2,
177 x_display_width in varchar2,
178 x_display_height in varchar2,
179 x_display_location in varchar2,
180 x_link_to in varchar2,
181 x_link_url in varchar2,
182 x_send_for_preview_flag in varchar2,
183 x_attachment_type in varchar2,
184 x_language_code in varchar2,
185 x_application_id in varchar2,
186 x_description in varchar2,
187 x_default_style_sheet in varchar2,
188 x_display_url in varchar2,
189 x_display_rule_id in varchar2,
190 x_display_program in varchar2,
191 x_attribute_category in varchar2,
192 x_attribute1 in varchar2,
193 x_attribute2 in varchar2,
194 x_attribute3 in varchar2,
195 x_attribute4 in varchar2,
196 x_attribute5 in varchar2,
197 x_attribute6 in varchar2,
198 x_attribute7 in varchar2,
199 x_attribute8 in varchar2,
200 x_attribute9 in varchar2,
201 x_attribute10 in varchar2,
202 x_attribute11 in varchar2,
203 x_attribute12 in varchar2,
204 x_attribute13 in varchar2,
205 x_attribute14 in varchar2,
206 x_attribute15 in varchar2,
207 x_display_text in varchar2,
208 x_alternate_text in varchar2,
209 x_attachment_sub_type in varchar2,
210 x_document_id in varchar2,
211 x_secured_flag in varchar2,
212 x_owner in varchar2,
213 x_custom_mode in varchar2,
214 x_last_update_date in varchar2);
215 
216 end JTF_AMV_ATTCHS_PKG;