1 PACKAGE Ibc_Citem_Versions_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctcivs.pls 120.2 2005/07/29 15:00:21 appldev ship $*/
3
4 -- Purpose: Table Handler for Ibc_Citem_Versions table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Sri Rangarajan 01/06/2002 Created Package
10 -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11 -- shitij.vatsa 02/11/2003 Added parameter p_subitem_version_id
12 -- to the APIs
13 -- shitij.vatsa 05/03/2004 Added a new API
14 -- populate_all_attachments
15 -- Bug Fix:3597752
16 -- Subir Anshumali 06/03/2005 Declared OUT and IN OUT arguments as references using the NOCOPY hint.
17 -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
18 -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
19
20 PROCEDURE INSERT_ROW (
21 x_rowid OUT NOCOPY VARCHAR2
22 ,px_citem_version_id IN OUT NOCOPY NUMBER
23 ,p_content_item_id IN NUMBER
24 ,p_version_number IN NUMBER
25 ,p_citem_version_status IN VARCHAR2
26 ,p_start_date IN DATE
27 ,p_end_date IN DATE
28 ,px_object_version_number IN OUT NOCOPY NUMBER
29 ,p_attribute_file_id IN NUMBER
30 ,p_attachment_attribute_code IN VARCHAR2
31 ,p_attachment_file_id IN NUMBER
32 ,p_content_item_name IN VARCHAR2
33 ,p_attachment_file_name IN VARCHAR2 DEFAULT NULL
34 ,p_description IN VARCHAR2
35 ,p_default_rendition_mime_type IN VARCHAR2 DEFAULT NULL
36 ,p_creation_date IN DATE DEFAULT NULL
37 ,p_created_by IN NUMBER DEFAULT NULL
38 ,p_last_update_date IN DATE DEFAULT NULL
39 ,p_last_updated_by IN NUMBER DEFAULT NULL
40 ,p_last_update_login IN NUMBER DEFAULT NULL
41 ,p_citem_translation_status IN VARCHAR2 DEFAULT NULL
42 );
43
44 PROCEDURE POPULATE_ALL_LANG (
45 p_CITEM_VERSION_ID IN NUMBER,
46 p_CONTENT_ITEM_ID IN NUMBER,
47 p_VERSION_NUMBER IN NUMBER,
48 p_CITEM_VERSION_STATUS IN VARCHAR2,
49 p_START_DATE IN DATE,
50 p_END_DATE IN DATE,
51 p_OBJECT_VERSION_NUMBER IN NUMBER,
52 p_ATTRIBUTE_FILE_ID IN NUMBER,
53 p_ATTACHMENT_ATTRIBUTE_CODE IN VARCHAR2,
54 P_SOURCE_LANG IN VARCHAR2 DEFAULT USERENV('LANG'),
55 p_ATTACHMENT_FILE_ID IN NUMBER,
56 p_CONTENT_ITEM_NAME IN VARCHAR2,
57 p_ATTACHMENT_FILE_NAME IN VARCHAR2,
58 p_DESCRIPTION IN VARCHAR2,
59 p_DEFAULT_RENDITION_MIME_TYPE IN VARCHAR2 DEFAULT NULL,
60 p_CREATION_DATE IN DATE DEFAULT NULL,
61 p_CREATED_BY IN NUMBER DEFAULT NULL,
62 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
63 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
64 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
65 p_CITEM_TRANSLATION_STATUS IN VARCHAR2 DEFAULT NULL
66 );
67
68 PROCEDURE INSERT_BASE_LANG (
69 x_ROWID OUT NOCOPY VARCHAR2,
70 px_CITEM_VERSION_ID IN OUT NOCOPY NUMBER,
71 p_CONTENT_ITEM_ID IN NUMBER,
72 p_VERSION_NUMBER IN NUMBER,
73 p_CITEM_VERSION_STATUS IN VARCHAR2,
74 p_START_DATE IN DATE,
75 p_END_DATE IN DATE,
76 px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
77 p_ATTRIBUTE_FILE_ID IN NUMBER,
78 p_ATTACHMENT_ATTRIBUTE_CODE IN VARCHAR2,
79 P_SOURCE_LANG IN VARCHAR2 DEFAULT USERENV('LANG'),
80 p_ATTACHMENT_FILE_ID IN NUMBER DEFAULT NULL,
81 p_CONTENT_ITEM_NAME IN VARCHAR2,
82 p_ATTACHMENT_FILE_NAME IN VARCHAR2 DEFAULT NULL,
83 p_DESCRIPTION IN VARCHAR2,
84 p_DEFAULT_RENDITION_MIME_TYPE IN VARCHAR2 DEFAULT NULL,
85 p_CREATION_DATE IN DATE DEFAULT NULL,
86 p_CREATED_BY IN NUMBER DEFAULT NULL,
87 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
88 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
89 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
90 p_CITEM_TRANSLATION_STATUS IN VARCHAR2 DEFAULT NULL);
91
92 PROCEDURE LOCK_ROW (
93 p_CITEM_VERSION_ID IN NUMBER,
94 p_CONTENT_ITEM_ID IN NUMBER,
95 p_VERSION_NUMBER IN NUMBER,
96 p_CITEM_VERSION_STATUS IN VARCHAR2,
97 p_START_DATE IN DATE,
98 p_END_DATE IN DATE,
99 p_OBJECT_VERSION_NUMBER IN NUMBER,
100 p_ATTRIBUTE_FILE_ID IN NUMBER,
101 p_ATTACHMENT_FILE_ID IN NUMBER,
102 p_CONTENT_ITEM_NAME IN VARCHAR2,
103 p_ATTACHMENT_FILE_NAME IN VARCHAR2,
104 p_DESCRIPTION IN VARCHAR2);
105
106 PROCEDURE UPDATE_ROW (
107 p_citem_version_id IN NUMBER
108 ,p_content_item_id IN NUMBER DEFAULT NULL
109 ,p_source_lang IN VARCHAR2 DEFAULT USERENV('LANG')
110 ,p_version_number IN NUMBER DEFAULT NULL
111 ,p_citem_version_status IN VARCHAR2 DEFAULT NULL
112 ,p_attachment_attribute_code IN VARCHAR2 DEFAULT NULL
113 ,p_start_date IN DATE DEFAULT NULL
114 ,p_end_date IN DATE DEFAULT NULL
115 ,px_object_version_number IN OUT NOCOPY NUMBER
116 ,p_attribute_file_id IN NUMBER DEFAULT NULL
117 ,p_attachment_file_id IN NUMBER DEFAULT NULL
118 ,p_content_item_name IN VARCHAR2 DEFAULT NULL
119 ,p_attachment_file_name IN VARCHAR2 DEFAULT NULL
120 ,p_description IN VARCHAR2 DEFAULT NULL
121 ,p_default_rendition_mime_type IN VARCHAR2 DEFAULT NULL
122 ,p_last_update_date IN DATE DEFAULT NULL
123 ,p_last_updated_by IN NUMBER DEFAULT NULL
124 ,p_last_update_login IN NUMBER DEFAULT NULL
125 ,p_citem_translation_status IN VARCHAR2 DEFAULT NULL
126 );
127
128 PROCEDURE DELETE_ROW (
129 p_CITEM_VERSION_ID IN NUMBER
130 );
131
132 PROCEDURE ADD_LANGUAGE;
133
134
135 PROCEDURE LOAD_ROW (
136 p_UPLOAD_MODE IN VARCHAR2,
137 p_CITEM_VERSION_ID IN NUMBER,
138 p_CONTENT_ITEM_ID IN NUMBER,
139 p_VERSION_NUMBER IN NUMBER,
140 p_CITEM_VERSION_STATUS IN VARCHAR2,
141 p_START_DATE IN DATE,
142 p_END_DATE IN DATE,
143 p_ATTACHMENT_ATTRIBUTE_CODE IN VARCHAR2,
144 p_ATTRIBUTE_FILE_ID IN NUMBER ,
145 p_ATTACHMENT_FILE_ID IN NUMBER DEFAULT NULL,
146 p_CONTENT_ITEM_NAME IN VARCHAR2,
147 p_ATTACHMENT_FILE_NAME IN VARCHAR2 DEFAULT NULL,
148 p_DESCRIPTION IN VARCHAR2,
149 p_DEFAULT_RENDITION_MIME_TYPE IN VARCHAR2 DEFAULT NULL,
150 p_OWNER IN VARCHAR2,
151 p_CITEM_TRANSLATION_STATUS IN VARCHAR2 DEFAULT NULL,
152 p_LAST_UPDATE_DATE IN VARCHAR2 );
153
154 PROCEDURE LOAD_SEED_ROW (
155 p_UPLOAD_MODE IN VARCHAR2,
156 p_CITEM_VERSION_ID IN NUMBER,
157 p_CONTENT_ITEM_ID IN NUMBER,
158 p_VERSION_NUMBER IN NUMBER,
159 p_CITEM_VERSION_STATUS IN VARCHAR2,
160 p_START_DATE IN DATE,
161 p_END_DATE IN DATE,
162 p_ATTACHMENT_ATTRIBUTE_CODE IN VARCHAR2,
163 p_ATTRIBUTE_FILE_ID IN NUMBER ,
164 p_ATTACHMENT_FILE_ID IN NUMBER DEFAULT NULL,
165 p_CONTENT_ITEM_NAME IN VARCHAR2,
166 p_ATTACHMENT_FILE_NAME IN VARCHAR2 DEFAULT NULL,
167 p_DESCRIPTION IN VARCHAR2,
168 p_DEFAULT_RENDITION_MIME_TYPE IN VARCHAR2 DEFAULT NULL,
169 p_OWNER IN VARCHAR2,
170 p_CITEM_TRANSLATION_STATUS IN VARCHAR2 DEFAULT NULL,
171 p_LAST_UPDATE_DATE IN VARCHAR2 );
172
173 PROCEDURE TRANSLATE_ROW (
174 p_UPLOAD_MODE IN VARCHAR2,
175 p_CITEM_VERSION_ID IN NUMBER,
176 p_ATTACHMENT_ATTRIBUTE_CODE IN VARCHAR2,
177 p_ATTRIBUTE_FILE_ID IN NUMBER,
178 p_ATTACHMENT_FILE_ID IN NUMBER,
179 p_CONTENT_ITEM_NAME IN VARCHAR2,
180 p_ATTACHMENT_FILE_NAME IN VARCHAR2,
181 p_DESCRIPTION IN VARCHAR2,
182 p_DEFAULT_RENDITION_MIME_TYPE IN VARCHAR2 DEFAULT NULL,
183 p_OWNER IN VARCHAR2,
184 p_CITEM_TRANSLATION_STATUS IN VARCHAR2 DEFAULT NULL,
185 p_LAST_UPDATE_DATE IN VARCHAR2 );
186
187 PROCEDURE populate_attachments (
188 p_citem_version_id IN NUMBER
189 ,p_base_lang IN VARCHAR2 DEFAULT USERENV('LANG')
190 );
191
192 PROCEDURE populate_all_attachments (
193 p_citem_version_id IN NUMBER
194 ,p_base_lang IN VARCHAR2 DEFAULT USERENV('LANG')
195 );
196
197 END Ibc_Citem_Versions_Pkg;