[Home] [Help]
PACKAGE: APPS.PO_ATT
Source
1 PACKAGE po_att AS
2 /* $Header: poatt04s.pls 120.0.12010000.1 2008/09/18 12:20:36 appldev noship $ */
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 -- 'PO_10SC' | 'PO_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 -- 'PO_10SC' | 'PO_R10'
19 );
20
21 FUNCTION get_table_name (
22 p_entity_name VARCHAR2
23 ) RETURN VARCHAR2;
24
25 FUNCTION get_table_name (
26 p_document_id NUMBER
27 ) RETURN VARCHAR2;
28
29 FUNCTION get_column_name (
30 p_entity_name VARCHAR2
31 ) RETURN VARCHAR2;
32
33 FUNCTION get_column_name (
34 p_document_id NUMBER
35 ) RETURN VARCHAR2;
36
37 FUNCTION get_entity_name (
38 p_table_name VARCHAR2
39 ) RETURN VARCHAR2;
40
41 PROCEDURE get_category_id (
42 p_usage_id NUMBER,
43 p_category_id OUT NOCOPY NUMBER
44 );
45
46 PROCEDURE get_usage_id (
47 p_category_id NUMBER,
48 p_usage_id OUT NOCOPY NUMBER
49 );
50
51 PROCEDURE get_media_id (
52 p_document_id NUMBER,
53 p_media_id OUT NOCOPY NUMBER,
54 p_datatype_id OUT NOCOPY NUMBER
55 );
56
57 PROCEDURE get_document_id (
58 p_media_id NUMBER,
59 p_datatype_id VARCHAR2,
60 p_document_id OUT NOCOPY NUMBER
61 );
62
63 PROCEDURE get_note_info (
64 p_media_id NUMBER,
65 p_short_long VARCHAR2,
66 p_document_id OUT NOCOPY NUMBER,
67 p_category_id OUT NOCOPY NUMBER,
68 p_usage_id OUT NOCOPY NUMBER,
69 p_note_type OUT NOCOPY VARCHAR2 -- 'O' | 'S'
70 );
71
72 PROCEDURE insert_document (
73 p_note_id NUMBER,
74 p_app_source_version VARCHAR2
75 );
76
77 PROCEDURE update_document (
78 p_note_id NUMBER,
79 p_app_source_version VARCHAR2
80 );
81
82 PROCEDURE delete_document (
83 p_document_id NUMBER
84 );
85
86 PROCEDURE insert_attached_document (
87 p_creation_date DATE,
88 p_created_by NUMBER,
89 p_po_note_id NUMBER,
90 p_table_name VARCHAR2,
91 p_column_name VARCHAR2,
92 p_foreign_id NUMBER,
93 p_sequence_num NUMBER,
94 p_attribute_category VARCHAR2,
95 p_attribute1 VARCHAR2,
96 p_attribute2 VARCHAR2,
97 p_attribute3 VARCHAR2,
98 p_attribute4 VARCHAR2,
99 p_attribute5 VARCHAR2,
100 p_attribute6 VARCHAR2,
101 p_attribute7 VARCHAR2,
102 p_attribute8 VARCHAR2,
103 p_attribute9 VARCHAR2,
104 p_attribute10 VARCHAR2,
105 p_attribute11 VARCHAR2,
106 p_attribute12 VARCHAR2,
107 p_attribute13 VARCHAR2,
108 p_attribute14 VARCHAR2,
109 p_attribute15 VARCHAR2,
110 p_app_source_version VARCHAR2,
111 p_attached_doc_id OUT NOCOPY NUMBER
112 );
113 PROCEDURE insert_attached_document_item (
114 p_creation_date DATE,
115 p_created_by NUMBER,
116 p_po_note_id NUMBER,
117 p_table_name VARCHAR2,
118 p_column_name VARCHAR2,
119 p_foreign_id NUMBER,
120 p_sequence_num NUMBER,
121 p_attribute_category VARCHAR2,
122 p_attribute1 VARCHAR2,
123 p_attribute2 VARCHAR2,
124 p_attribute3 VARCHAR2,
125 p_attribute4 VARCHAR2,
126 p_attribute5 VARCHAR2,
127 p_attribute6 VARCHAR2,
128 p_attribute7 VARCHAR2,
129 p_attribute8 VARCHAR2,
130 p_attribute9 VARCHAR2,
131 p_attribute10 VARCHAR2,
132 p_attribute11 VARCHAR2,
133 p_attribute12 VARCHAR2,
134 p_attribute13 VARCHAR2,
135 p_attribute14 VARCHAR2,
136 p_attribute15 VARCHAR2,
137 p_app_source_version VARCHAR2,
138 p_attached_doc_id OUT NOCOPY NUMBER
139 );
140
141 PROCEDURE update_attached_document (
142 p_attached_doc_id NUMBER,
143 p_creation_date DATE,
144 p_created_by NUMBER,
145 p_po_note_id NUMBER,
146 p_table_name VARCHAR2,
147 p_column_name VARCHAR2,
148 p_foreign_id NUMBER,
149 p_sequence_num NUMBER,
150 p_attribute_category VARCHAR2,
151 p_attribute1 VARCHAR2,
152 p_attribute2 VARCHAR2,
153 p_attribute3 VARCHAR2,
154 p_attribute4 VARCHAR2,
155 p_attribute5 VARCHAR2,
156 p_attribute6 VARCHAR2,
157 p_attribute7 VARCHAR2,
158 p_attribute8 VARCHAR2,
159 p_attribute9 VARCHAR2,
160 p_attribute10 VARCHAR2,
161 p_attribute11 VARCHAR2,
162 p_attribute12 VARCHAR2,
163 p_attribute13 VARCHAR2,
164 p_attribute14 VARCHAR2,
165 p_attribute15 VARCHAR2,
166 p_app_source_version VARCHAR2
167 );
168
169 PROCEDURE delete_attached_document (
170 p_attached_doc_id NUMBER
171 );
172
173 END;