[Home] [Help]
PACKAGE: APPS.SO_ATT
Source
1 PACKAGE so_att AUTHID CURRENT_USER AS
2 /* $Header: oeatt04s.pls 115.1 99/07/16 08:25:23 porting shi $ */
3 update_doc_flag VARCHAR2 (20) := 'UPDATE';
4 update_ref_flag VARCHAR2 (20) := 'UPDATE';
5
6 PROCEDURE mark_record (
7 p_src_id NUMBER, -- media_id | document_id
8 p_short_long VARCHAR2, -- 'S' | 'L'
9 p_source VARCHAR2,-- 'DOCUMENT' | 'NOTE'
10 p_operation VARCHAR2,-- 'INSERT' | 'UPDATE'
11 p_version VARCHAR2 -- '10SC' | 'R10'
12 );
13
14 PROCEDURE clear_mark (
15 p_short_long VARCHAR2, -- 'S' | 'L'
16 p_source VARCHAR2,-- 'DOCUMENT' | 'NOTE'
17 p_operation VARCHAR2,-- 'INSERT' | 'UPDATE'
18 p_version VARCHAR2 -- '10SC' | 'R10'
19 );
20
21 FUNCTION get_note_name (
22 p_document_id NUMBER
23 ) RETURN VARCHAR2;
24
25 FUNCTION get_note_error (
26 p_msg_name VARCHAR2,
27 p_document_id NUMBER DEFAULT NULL
28 ) RETURN VARCHAR2;
29
30
31 FUNCTION get_document_usage_type (
32 p_note_id NUMBER
33 ) RETURN VARCHAR2;
34
35 FUNCTION get_entity_name (p_header_id IN NUMBER, p_line_id IN NUMBER)
36 RETURN VARCHAR2;
37
38 PROCEDURE get_category_id (
39 p_usage_id NUMBER,
40 p_category_id OUT NUMBER
41 );
42
43 PROCEDURE get_usage_id (
44 p_category_id NUMBER,
45 p_usage_id OUT NUMBER
46 );
47
48 PROCEDURE get_media_id (
49 p_document_id NUMBER,
50 p_media_id OUT NUMBER,
51 p_datatype_id OUT NUMBER
52 );
53
54 FUNCTION get_doc_cat_application(p_document_id IN NUMBER) RETURN NUMBER;
55 FUNCTION get_cat_application(p_category_id IN NUMBER) RETURN NUMBER;
56
57 PROCEDURE get_note_info (
58 p_media_id NUMBER,
59 p_short_long VARCHAR2,
60 p_document_id OUT NUMBER,
61 p_category_id OUT NUMBER,
62 p_usage_id OUT NUMBER,
63 p_usage_type OUT VARCHAR2, -- 'O' | 'S'
64 p_application_id OUT NUMBER
65 );
66
67 PROCEDURE get_note_type_code (
68 p_usage_type VARCHAR2,
69 p_note_type_code OUT VARCHAR2, -- 'SN' | 'OT'
70 p_override_flag OUT VARCHAR2 -- 'Y' | 'N'
71 );
72
73 PROCEDURE insert_document (
74 p_document_id NUMBER,
75 p_app_source_version VARCHAR2
76 );
77
78 PROCEDURE update_document (
79 p_document_id NUMBER,
80 p_app_source_version VARCHAR2
81 );
82
83 PROCEDURE delete_document (
84 p_document_id NUMBER
85 );
86
87
88 PROCEDURE insert_attached_document (
89 p_creation_date DATE,
90 p_created_by NUMBER,
91 p_note_id NUMBER,
92 p_usage_id NUMBER,
93 p_automatically_added_flag VARCHAR2,
94 p_header_id NUMBER,
95 p_line_id NUMBER,
96 p_program_application_id NUMBER,
97 p_program_id NUMBER,
98 p_program_update_date DATE,
99 p_request_id NUMBER,
100 p_sequence_number NUMBER,
101 p_context VARCHAR2,
102 p_attribute1 VARCHAR2,
103 p_attribute2 VARCHAR2,
104 p_attribute3 VARCHAR2,
105 p_attribute4 VARCHAR2,
106 p_attribute5 VARCHAR2,
107 p_attribute6 VARCHAR2,
108 p_attribute7 VARCHAR2,
109 p_attribute8 VARCHAR2,
110 p_attribute9 VARCHAR2,
111 p_attribute10 VARCHAR2,
112 p_attribute11 VARCHAR2,
113 p_attribute12 VARCHAR2,
114 p_attribute13 VARCHAR2,
115 p_attribute14 VARCHAR2,
116 p_attribute15 VARCHAR2,
117 p_app_source_version VARCHAR2,
118 p_attached_document_id IN OUT NUMBER
119 );
120
121 PROCEDURE update_attached_document (
122 p_attached_document_id NUMBER,
123 p_creation_date DATE,
124 p_created_by NUMBER,
125 p_note_id NUMBER,
126 p_usage_id NUMBER,
127 p_automatically_added_flag VARCHAR2,
128 p_header_id NUMBER,
129 p_line_id NUMBER,
130 p_program_application_id NUMBER,
131 p_program_id NUMBER,
132 p_program_update_date DATE,
133 p_request_id NUMBER,
134 p_sequence_number NUMBER,
135 p_context VARCHAR2,
136 p_attribute1 VARCHAR2,
137 p_attribute2 VARCHAR2,
138 p_attribute3 VARCHAR2,
139 p_attribute4 VARCHAR2,
140 p_attribute5 VARCHAR2,
141 p_attribute6 VARCHAR2,
142 p_attribute7 VARCHAR2,
143 p_attribute8 VARCHAR2,
144 p_attribute9 VARCHAR2,
145 p_attribute10 VARCHAR2,
146 p_attribute11 VARCHAR2,
147 p_attribute12 VARCHAR2,
148 p_attribute13 VARCHAR2,
149 p_attribute14 VARCHAR2,
150 p_attribute15 VARCHAR2,
151 p_app_source_version VARCHAR2
152 );
153
154 PROCEDURE delete_attached_document (
155 p_attached_document_id NUMBER
156 );
157
158 PROCEDURE insert_category (
159 p_creation_date DATE,
160 p_created_by NUMBER,
161 p_last_update_date DATE,
162 p_last_updated_by NUMBER,
163 p_last_update_login NUMBER,
164 p_name VARCHAR2,
165 p_description VARCHAR2,
166 p_start_date_active DATE,
167 p_end_date_active DATE,
168 p_context VARCHAR2,
169 p_attribute1 VARCHAR2,
170 p_attribute2 VARCHAR2,
171 p_attribute3 VARCHAR2,
172 p_attribute4 VARCHAR2,
173 p_attribute5 VARCHAR2,
174 p_attribute6 VARCHAR2,
175 p_attribute7 VARCHAR2,
176 p_attribute8 VARCHAR2,
177 p_attribute9 VARCHAR2,
178 p_attribute10 VARCHAR2,
179 p_attribute11 VARCHAR2,
180 p_attribute12 VARCHAR2,
181 p_attribute13 VARCHAR2,
182 p_attribute14 VARCHAR2,
183 p_attribute15 VARCHAR2,
184 p_app_source_version VARCHAR2,
185 p_category_id IN OUT NUMBER
186 );
187
188 PROCEDURE update_category (
189 p_category_id NUMBER,
190 p_creation_date DATE,
191 p_created_by NUMBER,
192 p_last_update_date DATE,
193 p_last_updated_by NUMBER,
194 p_last_update_login NUMBER,
195 p_name VARCHAR2,
196 p_description VARCHAR2,
197 p_start_date_active DATE,
198 p_end_date_active DATE,
199 p_context VARCHAR2,
200 p_attribute1 VARCHAR2,
201 p_attribute2 VARCHAR2,
202 p_attribute3 VARCHAR2,
203 p_attribute4 VARCHAR2,
204 p_attribute5 VARCHAR2,
205 p_attribute6 VARCHAR2,
206 p_attribute7 VARCHAR2,
207 p_attribute8 VARCHAR2,
208 p_attribute9 VARCHAR2,
209 p_attribute10 VARCHAR2,
210 p_attribute11 VARCHAR2,
211 p_attribute12 VARCHAR2,
212 p_attribute13 VARCHAR2,
213 p_attribute14 VARCHAR2,
214 p_attribute15 VARCHAR2,
215 p_app_source_version VARCHAR2
216 );
217
218 PROCEDURE insert_usage (
219 p_creation_date DATE,
220 p_created_by NUMBER,
221 p_last_update_date DATE,
222 p_last_updated_by NUMBER,
223 p_last_update_login NUMBER,
224 p_name VARCHAR2,
225 p_user_name VARCHAR2,
226 p_category_id NUMBER,
227 p_app_source_version VARCHAR2,
228 p_usage_id IN OUT NUMBER
229 );
230
231 PROCEDURE update_usage (
232 p_category_id NUMBER,
233 p_creation_date DATE,
234 p_created_by NUMBER,
235 p_last_update_date DATE,
236 p_last_updated_by NUMBER,
237 p_last_update_login NUMBER,
238 p_name VARCHAR2,
239 p_user_name VARCHAR2,
240 p_app_source_version VARCHAR2
241 );
242
243 END;