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.

APPS.IBC_CITEM_VERSIONS_PKG dependencies on FND_API

Line 10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX

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: -- Ed Nunez 08/14/2003 Content Item Name Uniqueness
14: -- Ed Nunez 09/19/2003 Content Item Name accross folder and items

Line 103: -- RAISE Fnd_Api.G_EXC_ERROR;

99: -- Fnd_Message.Set_token('NEW_ITEM_NAME' , p_content_item_name);
100: -- Fnd_Message.Set_token('CONFLICTING_ITEM_NAME' , IBC_UTILITIES_PVT.get_citem_name(l_object_id));
101: -- END IF;
102: -- Fnd_Msg_Pub.ADD;
103: -- RAISE Fnd_Api.G_EXC_ERROR;
104: -- END IF;
105:
106:
107: Ibc_Content_Items_Pkg.UPDATE_ROW (

Line 116: (px_CITEM_VERSION_ID = Fnd_Api.G_MISS_NUM))

112:
113: -- Primary key validation check
114:
115: IF ((px_CITEM_VERSION_ID IS NULL) OR
116: (px_CITEM_VERSION_ID = Fnd_Api.G_MISS_NUM))
117: THEN
118: OPEN c2;
119: FETCH c2 INTO px_CITEM_VERSION_ID;
120: CLOSE c2;

Line 137: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)

133: LAST_UPDATE_DATE,
134: LAST_UPDATED_BY,
135: LAST_UPDATE_LOGIN
136: ) VALUES (
137: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
138: ,DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,p_content_item_id)
139: ,DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,p_version_number)
140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)
141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)

Line 138: ,DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,p_content_item_id)

134: LAST_UPDATED_BY,
135: LAST_UPDATE_LOGIN
136: ) VALUES (
137: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
138: ,DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,p_content_item_id)
139: ,DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,p_version_number)
140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)
141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)

Line 139: ,DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,p_version_number)

135: LAST_UPDATE_LOGIN
136: ) VALUES (
137: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
138: ,DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,p_content_item_id)
139: ,DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,p_version_number)
140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)
141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)

Line 140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)

136: ) VALUES (
137: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
138: ,DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,p_content_item_id)
139: ,DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,p_version_number)
140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)
141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

Line 141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)

137: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
138: ,DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,p_content_item_id)
139: ,DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,p_version_number)
140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)
141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

Line 142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)

138: ,DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,p_content_item_id)
139: ,DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,p_version_number)
140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)
141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)

139: ,DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,p_version_number)
140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)
141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

140: ,DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,p_citem_version_status)
141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

141: ,DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,p_start_date)
142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
149: );

Line 146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

142: ,DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,p_end_date)
143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
149: );
150:

Line 147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

143: ,DECODE(px_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,px_object_version_number)
144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
149: );
150:
151: INSERT INTO IBC_CITEM_VERSIONS_TL (

Line 148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

144: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
145: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
146: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
149: );
150:
151: INSERT INTO IBC_CITEM_VERSIONS_TL (
152: CITEM_VERSION_ID,

Line 169: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)

165: LANGUAGE,
166: SOURCE_LANG,
167: CITEM_TRANSLATION_STATUS
168: ) SELECT
169: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
170: ,DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,p_attribute_file_id)
171: ,DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,p_attachment_attribute_code)
172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)
173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)

Line 170: ,DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,p_attribute_file_id)

166: SOURCE_LANG,
167: CITEM_TRANSLATION_STATUS
168: ) SELECT
169: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
170: ,DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,p_attribute_file_id)
171: ,DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,p_attachment_attribute_code)
172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)
173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)
174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)

Line 171: ,DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,p_attachment_attribute_code)

167: CITEM_TRANSLATION_STATUS
168: ) SELECT
169: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
170: ,DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,p_attribute_file_id)
171: ,DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,p_attachment_attribute_code)
172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)
173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)
174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)

Line 172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)

168: ) SELECT
169: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
170: ,DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,p_attribute_file_id)
171: ,DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,p_attachment_attribute_code)
172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)
173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)
174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)

Line 173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)

169: DECODE(px_citem_version_id,FND_API.G_MISS_NUM,NULL,px_citem_version_id)
170: ,DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,p_attribute_file_id)
171: ,DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,p_attachment_attribute_code)
172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)
173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)
174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

Line 174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)

170: ,DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,p_attribute_file_id)
171: ,DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,p_attachment_attribute_code)
172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)
173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)
174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

Line 175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)

171: ,DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,p_attachment_attribute_code)
172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)
173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)
174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)

172: ,DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,p_content_item_name)
173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)
174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

173: ,DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,p_attachment_file_id)
174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

174: ,DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,p_attachment_file_name)
175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE

Line 179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

175: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE
183: ,USERENV('LANG')

Line 180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

176: ,DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,p_default_rendition_mime_type)
177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE
183: ,USERENV('LANG')
184: ,DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,p_citem_translation_status)

Line 181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

177: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
178: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
179: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE
183: ,USERENV('LANG')
184: ,DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,p_citem_translation_status)
185: FROM FND_LANGUAGES L

Line 184: ,DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,p_citem_translation_status)

180: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
181: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
182: ,L.LANGUAGE_CODE
183: ,USERENV('LANG')
184: ,DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,p_citem_translation_status)
185: FROM FND_LANGUAGES L
186: WHERE L.INSTALLED_FLAG IN ('I', 'B')
187: AND NOT EXISTS
188: (SELECT NULL

Line 211: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,Fnd_Api.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)

207: -- across all versions for that language
208:
209: -- Update Content Item Name for all versions of current language
210: UPDATE IBC_CITEM_VERSIONS_TL
211: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,Fnd_Api.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
212: WHERE citem_version_id IN (SELECT citem_version_id
213: FROM IBC_CITEM_VERSIONS_B verb
214: WHERE verb.content_item_id = p_content_item_id);
215:

Line 290: RAISE Fnd_Api.G_EXC_ERROR;

286: Fnd_Message.Set_token('NEW_ITEM_NAME' , p_content_item_name);
287: Fnd_Message.Set_token('CONFLICTING_ITEM_NAME' , IBC_UTILITIES_PVT.get_citem_name(l_object_id));
288: END IF;
289: Fnd_Msg_Pub.ADD;
290: RAISE Fnd_Api.G_EXC_ERROR;
291: END IF;
292:
293:
294: IF p_version_number > 1 THEN

Line 317: ) SELECT DECODE(p_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,p_CITEM_VERSION_ID),

313: LAST_UPDATE_LOGIN,
314: LANGUAGE,
315: SOURCE_LANG,
316: CITEM_TRANSLATION_STATUS
317: ) SELECT DECODE(p_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,p_CITEM_VERSION_ID),
318: L.attribute_file_id,
319: L.attachment_attribute_code,
320: L.content_item_name,
321: L.attachment_file_id,

Line 325: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

321: L.attachment_file_id,
322: L.attachment_file_name,
323: L.description,
324: L.default_rendition_mime_type,
325: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
326: p_creation_date) ,
327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
328: NULL, Fnd_Global.user_id, p_created_by),
329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

323: L.description,
324: L.default_rendition_mime_type,
325: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
326: p_creation_date) ,
327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
328: NULL, Fnd_Global.user_id, p_created_by),
329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

325: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
326: p_creation_date) ,
327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
328: NULL, Fnd_Global.user_id, p_created_by),
329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
332: NULL, Fnd_Global.user_id, p_last_updated_by),
333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

Line 331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

327: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
328: NULL, Fnd_Global.user_id, p_created_by),
329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
332: NULL, Fnd_Global.user_id, p_last_updated_by),
333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,

Line 333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

329: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
330: p_last_update_date),
331: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
332: NULL, Fnd_Global.user_id, p_last_updated_by),
333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,
336: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
337: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

Line 336: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

332: NULL, Fnd_Global.user_id, p_last_updated_by),
333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,
336: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
337: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
338: FROM ibc_citem_versions_tl L
339: WHERE L.citem_version_id = l_prev_version_id
340: AND NOT EXISTS

Line 337: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

333: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,
336: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
337: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
338: FROM ibc_citem_versions_tl L
339: WHERE L.citem_version_id = l_prev_version_id
340: AND NOT EXISTS
341: (SELECT NULL

Line 368: DECODE(p_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,p_CITEM_VERSION_ID),

364: LANGUAGE,
365: SOURCE_LANG,
366: CITEM_TRANSLATION_STATUS
367: ) SELECT
368: DECODE(p_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,p_CITEM_VERSION_ID),
369: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
370: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),

Line 369: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),

365: SOURCE_LANG,
366: CITEM_TRANSLATION_STATUS
367: ) SELECT
368: DECODE(p_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,p_CITEM_VERSION_ID),
369: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
370: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),

Line 370: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),

366: CITEM_TRANSLATION_STATUS
367: ) SELECT
368: DECODE(p_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,p_CITEM_VERSION_ID),
369: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
370: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),

Line 371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),

367: ) SELECT
368: DECODE(p_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,p_CITEM_VERSION_ID),
369: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
370: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),

Line 372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),

368: DECODE(p_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,p_CITEM_VERSION_ID),
369: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
370: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),

369: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
370: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
377: p_creation_date) ,

Line 374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),

370: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
377: p_creation_date) ,
378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),

371: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
377: p_creation_date) ,
378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
379: NULL, Fnd_Global.user_id, p_created_by),

Line 376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

372: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
373: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
377: p_creation_date) ,
378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
379: NULL, Fnd_Global.user_id, p_created_by),
380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

374: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
375: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
377: p_creation_date) ,
378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
379: NULL, Fnd_Global.user_id, p_created_by),
380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

376: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
377: p_creation_date) ,
378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
379: NULL, Fnd_Global.user_id, p_created_by),
380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
383: NULL, Fnd_Global.user_id, p_last_updated_by),
384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

Line 382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

378: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
379: NULL, Fnd_Global.user_id, p_created_by),
380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
383: NULL, Fnd_Global.user_id, p_last_updated_by),
384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,

Line 384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

380: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
381: p_last_update_date),
382: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
383: NULL, Fnd_Global.user_id, p_last_updated_by),
384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,
387: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
388: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

Line 387: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

383: NULL, Fnd_Global.user_id, p_last_updated_by),
384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,
387: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
388: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
389: FROM FND_LANGUAGES L
390: WHERE L.INSTALLED_FLAG IN ('I', 'B')
391: AND NOT EXISTS

Line 388: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

384: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
385: NULL, Fnd_Global.login_id, p_last_update_login),
386: L.LANGUAGE_CODE,
387: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
388: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
389: FROM FND_LANGUAGES L
390: WHERE L.INSTALLED_FLAG IN ('I', 'B')
391: AND NOT EXISTS
392: (SELECT NULL

Line 470: RAISE Fnd_Api.G_EXC_ERROR;

466: Fnd_Message.Set_token('NEW_ITEM_NAME' , p_content_item_name);
467: Fnd_Message.Set_token('CONFLICTING_ITEM_NAME' , IBC_UTILITIES_PVT.get_citem_name(l_object_id));
468: END IF;
469: Fnd_Msg_Pub.ADD;
470: RAISE Fnd_Api.G_EXC_ERROR;
471: END IF;
472:
473:
474: Ibc_Content_Items_Pkg.UPDATE_ROW (

Line 482: (px_CITEM_VERSION_ID = Fnd_Api.G_MISS_NUM))

478:
479: -- Primary key validation check
480:
481: IF ((px_CITEM_VERSION_ID IS NULL) OR
482: (px_CITEM_VERSION_ID = Fnd_Api.G_MISS_NUM))
483: THEN
484: OPEN c2;
485: FETCH c2 INTO px_CITEM_VERSION_ID;
486: CLOSE c2;

Line 503: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),

499: LAST_UPDATE_DATE,
500: LAST_UPDATED_BY,
501: LAST_UPDATE_LOGIN
502: ) VALUES (
503: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
504: DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,p_CONTENT_ITEM_ID),
505: DECODE(p_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,NULL,p_VERSION_NUMBER),
506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),
507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),

Line 504: DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,p_CONTENT_ITEM_ID),

500: LAST_UPDATED_BY,
501: LAST_UPDATE_LOGIN
502: ) VALUES (
503: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
504: DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,p_CONTENT_ITEM_ID),
505: DECODE(p_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,NULL,p_VERSION_NUMBER),
506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),
507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),
508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),

Line 505: DECODE(p_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,NULL,p_VERSION_NUMBER),

501: LAST_UPDATE_LOGIN
502: ) VALUES (
503: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
504: DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,p_CONTENT_ITEM_ID),
505: DECODE(p_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,NULL,p_VERSION_NUMBER),
506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),
507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),
508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),
509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),

Line 506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),

502: ) VALUES (
503: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
504: DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,p_CONTENT_ITEM_ID),
505: DECODE(p_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,NULL,p_VERSION_NUMBER),
506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),
507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),
508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),
509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),
510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),

503: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
504: DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,p_CONTENT_ITEM_ID),
505: DECODE(p_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,NULL,p_VERSION_NUMBER),
506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),
507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),
508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),
509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),
510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
511: p_creation_date),

Line 508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),

504: DECODE(p_CONTENT_ITEM_ID,Fnd_Api.G_MISS_NUM,NULL,p_CONTENT_ITEM_ID),
505: DECODE(p_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,NULL,p_VERSION_NUMBER),
506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),
507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),
508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),
509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),
510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
511: p_creation_date),
512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),

505: DECODE(p_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,NULL,p_VERSION_NUMBER),
506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),
507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),
508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),
509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),
510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
511: p_creation_date),
512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
513: NULL, Fnd_Global.user_id, p_created_by),

Line 510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

506: DECODE(p_CITEM_VERSION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_VERSION_STATUS),
507: DECODE(p_START_DATE,Fnd_Api.G_MISS_DATE,NULL,p_START_DATE),
508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),
509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),
510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
511: p_creation_date),
512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
513: NULL, Fnd_Global.user_id, p_created_by),
514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

508: DECODE(p_END_DATE,Fnd_Api.G_MISS_DATE,NULL,p_END_DATE),
509: DECODE(px_OBJECT_VERSION_NUMBER,Fnd_Api.G_MISS_NUM,1,px_OBJECT_VERSION_NUMBER),
510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
511: p_creation_date),
512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
513: NULL, Fnd_Global.user_id, p_created_by),
514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

510: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
511: p_creation_date),
512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
513: NULL, Fnd_Global.user_id, p_created_by),
514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
517: NULL, Fnd_Global.user_id, p_last_updated_by),
518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

Line 516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

512: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
513: NULL, Fnd_Global.user_id, p_created_by),
514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
517: NULL, Fnd_Global.user_id, p_last_updated_by),
518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
519: NULL, Fnd_Global.login_id, p_last_update_login)
520: );

Line 518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

514: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
515: p_last_update_date),
516: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
517: NULL, Fnd_Global.user_id, p_last_updated_by),
518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
519: NULL, Fnd_Global.login_id, p_last_update_login)
520: );
521:
522: INSERT INTO IBC_CITEM_VERSIONS_TL (

Line 540: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),

536: LANGUAGE,
537: SOURCE_LANG,
538: CITEM_TRANSLATION_STATUS
539: ) VALUES (
540: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
541: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
542: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),

Line 541: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),

537: SOURCE_LANG,
538: CITEM_TRANSLATION_STATUS
539: ) VALUES (
540: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
541: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
542: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),

Line 542: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),

538: CITEM_TRANSLATION_STATUS
539: ) VALUES (
540: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
541: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
542: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),

Line 543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),

539: ) VALUES (
540: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
541: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
542: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),

Line 544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),

540: DECODE(px_CITEM_VERSION_ID,Fnd_Api.G_MISS_NUM,NULL,px_CITEM_VERSION_ID),
541: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
542: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,

Line 545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),

541: DECODE(p_ATTRIBUTE_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTRIBUTE_FILE_ID),
542: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,
549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),

542: DECODE(p_ATTACHMENT_ATTRIBUTE_CODE,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_ATTRIBUTE_CODE),
543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,
549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),

Line 547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),

543: DECODE(p_CONTENT_ITEM_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_CONTENT_ITEM_NAME),
544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,
549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

Line 548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,

544: DECODE(p_ATTACHMENT_FILE_ID,Fnd_Api.G_MISS_NUM,NULL,p_ATTACHMENT_FILE_ID),
545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,
549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),

Line 549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

545: DECODE(p_ATTACHMENT_FILE_NAME,Fnd_Api.G_MISS_CHAR,NULL,p_ATTACHMENT_FILE_NAME),
546: DECODE(p_DESCRIPTION,Fnd_Api.G_MISS_CHAR,NULL,p_DESCRIPTION),
547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,
549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

Line 551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,

547: DECODE(p_DEFAULT_RENDITION_MIME_TYPE,Fnd_Api.G_MISS_CHAR,NULL,p_DEFAULT_RENDITION_MIME_TYPE),
548: DECODE(p_creation_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,p_creation_date) ,
549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

Line 553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,

549: DECODE(p_created_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
550: NULL, Fnd_Global.user_id, p_created_by),
551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

Line 555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,

551: DECODE(p_last_update_date, Fnd_Api.G_MISS_DATE, SYSDATE, NULL, SYSDATE,
552: p_last_update_date),
553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
558: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
559: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

Line 557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

553: DECODE(p_last_updated_by, Fnd_Api.G_MISS_NUM, Fnd_Global.user_id,
554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
558: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
559: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
560: );
561:

Line 558: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),

554: NULL, Fnd_Global.user_id, p_last_updated_by),
555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
558: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
559: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
560: );
561:
562: OPEN c;

Line 559: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)

555: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
556: NULL, Fnd_Global.login_id, p_last_update_login),
557: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
558: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
559: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
560: );
561:
562: OPEN c;
563: FETCH c INTO x_ROWID;

Line 570: RAISE Fnd_Api.G_EXC_ERROR;

566: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');
567: Fnd_Message.Set_token('PKG_NAME' , G_pkg_name);
568: Fnd_Message.Set_token('API_NAME' , G_api_name);
569: Fnd_Msg_Pub.ADD;
570: RAISE Fnd_Api.G_EXC_ERROR;
571: --RAISE NO_DATA_FOUND;
572: END IF;
573: CLOSE c;
574:

Line 585: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,Fnd_Api.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)

581: -- across all versions for that language
582:
583: -- Update Content Item Name for all versions of current language
584: UPDATE IBC_CITEM_VERSIONS_TL
585: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,Fnd_Api.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
586: WHERE citem_version_id IN (SELECT citem_version_id
587: FROM IBC_CITEM_VERSIONS_B verb
588: WHERE verb.content_item_id = p_content_item_id);
589:

Line 728: RAISE Fnd_Api.G_EXC_ERROR;

724: Fnd_Message.Set_token('NEW_ITEM_NAME' , p_content_item_name);
725: Fnd_Message.Set_token('CONFLICTING_ITEM_NAME' , IBC_UTILITIES_PVT.get_citem_name(l_object_id));
726: END IF;
727: Fnd_Msg_Pub.ADD;
728: RAISE Fnd_Api.G_EXC_ERROR;
729: END IF;
730:
731:
732: Ibc_Content_Items_Pkg.UPDATE_ROW (

Line 739: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)

735: ,p_last_updated_by =>p_last_updated_by);
736:
737:
738: UPDATE IBC_CITEM_VERSIONS_B SET
739: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
740: ,version_number = DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,NULL,version_number,p_version_number)
741: ,citem_version_status = DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_version_status,p_citem_version_status)
742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)
743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)

Line 740: ,version_number = DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,NULL,version_number,p_version_number)

736:
737:
738: UPDATE IBC_CITEM_VERSIONS_B SET
739: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
740: ,version_number = DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,NULL,version_number,p_version_number)
741: ,citem_version_status = DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_version_status,p_citem_version_status)
742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)
743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number

Line 741: ,citem_version_status = DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_version_status,p_citem_version_status)

737:
738: UPDATE IBC_CITEM_VERSIONS_B SET
739: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
740: ,version_number = DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,NULL,version_number,p_version_number)
741: ,citem_version_status = DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_version_status,p_citem_version_status)
742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)
743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number
745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)

738: UPDATE IBC_CITEM_VERSIONS_B SET
739: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
740: ,version_number = DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,NULL,version_number,p_version_number)
741: ,citem_version_status = DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_version_status,p_citem_version_status)
742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)
743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number
745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)

739: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
740: ,version_number = DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,NULL,version_number,p_version_number)
741: ,citem_version_status = DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_version_status,p_citem_version_status)
742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)
743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number
745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

741: ,citem_version_status = DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_version_status,p_citem_version_status)
742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)
743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number
745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
748: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
749:

Line 746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)
743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number
745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
748: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
749:
750: /*AND object_version_number = DECODE(p_object_version_number,

Line 747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

743: ,end_date = DECODE(p_end_date,FND_API.G_MISS_DATE,NULL,NULL,end_date,p_end_date)
744: ,object_version_number = px_object_version_number
745: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
746: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
748: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
749:
750: /*AND object_version_number = DECODE(p_object_version_number,
751: FND_API.G_MISS_NUM,

Line 751: FND_API.G_MISS_NUM,

747: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
748: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
749:
750: /*AND object_version_number = DECODE(p_object_version_number,
751: FND_API.G_MISS_NUM,
752: object_version_number,
753: NULL,
754: object_version_number,
755: p_object_version_number);*/

Line 763: RAISE Fnd_Api.G_EXC_ERROR;

759: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');
760: Fnd_Message.Set_token('PKG_NAME' , G_pkg_name);
761: Fnd_Message.Set_token('API_NAME' , G_api_name);
762: Fnd_Msg_Pub.ADD;
763: RAISE Fnd_Api.G_EXC_ERROR;
764: END IF;
765:
766: --Bug Fix:3589057
767: UPDATE IBC_CITEM_VERSIONS_TL SET

Line 768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)

764: END IF;
765:
766: --Bug Fix:3589057
767: UPDATE IBC_CITEM_VERSIONS_TL SET
768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)

765:
766: --Bug Fix:3589057
767: UPDATE IBC_CITEM_VERSIONS_TL SET
768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
773: ,source_lang = DECODE(p_source_lang,FND_API.G_MISS_CHAR,USERENV('LANG'),NULL,USERENV('LANG'),p_source_lang)

Line 770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

766: --Bug Fix:3589057
767: UPDATE IBC_CITEM_VERSIONS_TL SET
768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
773: ,source_lang = DECODE(p_source_lang,FND_API.G_MISS_CHAR,USERENV('LANG'),NULL,USERENV('LANG'),p_source_lang)
774: ,TEXTIDX = 'X'

Line 771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

767: UPDATE IBC_CITEM_VERSIONS_TL SET
768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
773: ,source_lang = DECODE(p_source_lang,FND_API.G_MISS_CHAR,USERENV('LANG'),NULL,USERENV('LANG'),p_source_lang)
774: ,TEXTIDX = 'X'
775: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID

Line 772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
773: ,source_lang = DECODE(p_source_lang,FND_API.G_MISS_CHAR,USERENV('LANG'),NULL,USERENV('LANG'),p_source_lang)
774: ,TEXTIDX = 'X'
775: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
776: AND P_SOURCE_LANG IN (LANGUAGE, SOURCE_LANG);

Line 773: ,source_lang = DECODE(p_source_lang,FND_API.G_MISS_CHAR,USERENV('LANG'),NULL,USERENV('LANG'),p_source_lang)

769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
772: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
773: ,source_lang = DECODE(p_source_lang,FND_API.G_MISS_CHAR,USERENV('LANG'),NULL,USERENV('LANG'),p_source_lang)
774: ,TEXTIDX = 'X'
775: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
776: AND P_SOURCE_LANG IN (LANGUAGE, SOURCE_LANG);
777:

Line 783: RAISE Fnd_Api.G_EXC_ERROR;

779: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');
780: Fnd_Message.Set_token('PKG_NAME' , G_pkg_name);
781: Fnd_Message.Set_token('API_NAME' , G_api_name);
782: Fnd_Msg_Pub.ADD;
783: RAISE Fnd_Api.G_EXC_ERROR;
784: END IF;
785:
786: --Bug Fix:3589057
787: UPDATE IBC_CITEM_VERSIONS_TL SET

Line 788: attribute_file_id = DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,NULL,attribute_file_id,p_attribute_file_id)

784: END IF;
785:
786: --Bug Fix:3589057
787: UPDATE IBC_CITEM_VERSIONS_TL SET
788: attribute_file_id = DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,NULL,attribute_file_id,p_attribute_file_id)
789: ,attachment_file_id = DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,NULL,attachment_file_id,p_attachment_file_id)
790: ,attachment_file_name = DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,NULL,attachment_file_name,p_attachment_file_name)
791: ,attachment_attribute_code = DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,NULL,attachment_attribute_code,p_attachment_attribute_code)
792: ,default_rendition_mime_type = DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,NULL,default_rendition_mime_type,p_default_rendition_mime_type)

Line 789: ,attachment_file_id = DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,NULL,attachment_file_id,p_attachment_file_id)

785:
786: --Bug Fix:3589057
787: UPDATE IBC_CITEM_VERSIONS_TL SET
788: attribute_file_id = DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,NULL,attribute_file_id,p_attribute_file_id)
789: ,attachment_file_id = DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,NULL,attachment_file_id,p_attachment_file_id)
790: ,attachment_file_name = DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,NULL,attachment_file_name,p_attachment_file_name)
791: ,attachment_attribute_code = DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,NULL,attachment_attribute_code,p_attachment_attribute_code)
792: ,default_rendition_mime_type = DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,NULL,default_rendition_mime_type,p_default_rendition_mime_type)
793: ,citem_translation_status = DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_translation_status,p_citem_translation_status)

Line 790: ,attachment_file_name = DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,NULL,attachment_file_name,p_attachment_file_name)

786: --Bug Fix:3589057
787: UPDATE IBC_CITEM_VERSIONS_TL SET
788: attribute_file_id = DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,NULL,attribute_file_id,p_attribute_file_id)
789: ,attachment_file_id = DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,NULL,attachment_file_id,p_attachment_file_id)
790: ,attachment_file_name = DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,NULL,attachment_file_name,p_attachment_file_name)
791: ,attachment_attribute_code = DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,NULL,attachment_attribute_code,p_attachment_attribute_code)
792: ,default_rendition_mime_type = DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,NULL,default_rendition_mime_type,p_default_rendition_mime_type)
793: ,citem_translation_status = DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_translation_status,p_citem_translation_status)
794: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID

Line 791: ,attachment_attribute_code = DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,NULL,attachment_attribute_code,p_attachment_attribute_code)

787: UPDATE IBC_CITEM_VERSIONS_TL SET
788: attribute_file_id = DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,NULL,attribute_file_id,p_attribute_file_id)
789: ,attachment_file_id = DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,NULL,attachment_file_id,p_attachment_file_id)
790: ,attachment_file_name = DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,NULL,attachment_file_name,p_attachment_file_name)
791: ,attachment_attribute_code = DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,NULL,attachment_attribute_code,p_attachment_attribute_code)
792: ,default_rendition_mime_type = DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,NULL,default_rendition_mime_type,p_default_rendition_mime_type)
793: ,citem_translation_status = DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_translation_status,p_citem_translation_status)
794: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
795: AND P_SOURCE_LANG IN (LANGUAGE);

Line 792: ,default_rendition_mime_type = DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,NULL,default_rendition_mime_type,p_default_rendition_mime_type)

788: attribute_file_id = DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,NULL,attribute_file_id,p_attribute_file_id)
789: ,attachment_file_id = DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,NULL,attachment_file_id,p_attachment_file_id)
790: ,attachment_file_name = DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,NULL,attachment_file_name,p_attachment_file_name)
791: ,attachment_attribute_code = DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,NULL,attachment_attribute_code,p_attachment_attribute_code)
792: ,default_rendition_mime_type = DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,NULL,default_rendition_mime_type,p_default_rendition_mime_type)
793: ,citem_translation_status = DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_translation_status,p_citem_translation_status)
794: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
795: AND P_SOURCE_LANG IN (LANGUAGE);
796:

Line 793: ,citem_translation_status = DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_translation_status,p_citem_translation_status)

789: ,attachment_file_id = DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,NULL,attachment_file_id,p_attachment_file_id)
790: ,attachment_file_name = DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,NULL,attachment_file_name,p_attachment_file_name)
791: ,attachment_attribute_code = DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,NULL,attachment_attribute_code,p_attachment_attribute_code)
792: ,default_rendition_mime_type = DECODE(p_default_rendition_mime_type,FND_API.G_MISS_CHAR,NULL,NULL,default_rendition_mime_type,p_default_rendition_mime_type)
793: ,citem_translation_status = DECODE(p_citem_translation_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_translation_status,p_citem_translation_status)
794: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
795: AND P_SOURCE_LANG IN (LANGUAGE);
796:
797: IF (SQL%NOTFOUND) THEN

Line 802: RAISE Fnd_Api.G_EXC_ERROR;

798: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');
799: Fnd_Message.Set_token('PKG_NAME' , G_pkg_name);
800: Fnd_Message.Set_token('API_NAME' , G_api_name);
801: Fnd_Msg_Pub.ADD;
802: RAISE Fnd_Api.G_EXC_ERROR;
803: END IF;
804:
805:
806: /*

Line 816: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)

812: -- across all versions for that language
813:
814: -- Update Content Item Name for all versions of current language
815: UPDATE IBC_CITEM_VERSIONS_TL
816: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
817: WHERE P_SOURCE_LANG IN (LANGUAGE, SOURCE_LANG)
818: AND EXISTS (SELECT 'X'
819: FROM IBC_CITEM_VERSIONS_B verb
820: WHERE verb.content_item_id = p_content_item_id

Line 858: RAISE Fnd_Api.G_EXC_ERROR;

854: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');
855: Fnd_Message.Set_token('PKG_NAME' , G_pkg_name);
856: Fnd_Message.Set_token('API_NAME' , G_api_name);
857: Fnd_Msg_Pub.ADD;
858: RAISE Fnd_Api.G_EXC_ERROR;
859: --RAISE NO_DATA_FOUND;
860: END IF;
861:
862: DELETE FROM IBC_CITEM_VERSIONS_B

Line 870: RAISE Fnd_Api.G_EXC_ERROR;

866: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');
867: Fnd_Message.Set_token('PKG_NAME' , G_pkg_name);
868: Fnd_Message.Set_token('API_NAME' , G_api_name);
869: Fnd_Msg_Pub.ADD;
870: RAISE Fnd_Api.G_EXC_ERROR;
871: -- RAISE NO_DATA_FOUND;
872: END IF;
873: END DELETE_ROW;
874:

Line 1055: RAISE Fnd_Api.G_EXC_ERROR;

1051: Fnd_Message.Set_token('NEW_ITEM_NAME' , p_content_item_name);
1052: Fnd_Message.Set_token('CONFLICTING_ITEM_NAME' , IBC_UTILITIES_PVT.get_citem_name(l_object_id));
1053: END IF;
1054: Fnd_Msg_Pub.ADD;
1055: RAISE Fnd_Api.G_EXC_ERROR;
1056: END IF;
1057:
1058: SELECT MAX(object_version_number) INTO lx_object_version_number
1059: FROM IBC_CONTENT_ITEMS

Line 1066: p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)

1062: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
1063: db_user_id, db_last_update_date, p_upload_mode )) THEN
1064:
1065: Ibc_Citem_Versions_Pkg.UPDATE_ROW (
1066: p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
1067: ,p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
1068: ,p_version_number => NVL(p_version_number,FND_API.G_MISS_NUM)
1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)
1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)

Line 1067: ,p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)

1063: db_user_id, db_last_update_date, p_upload_mode )) THEN
1064:
1065: Ibc_Citem_Versions_Pkg.UPDATE_ROW (
1066: p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
1067: ,p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
1068: ,p_version_number => NVL(p_version_number,FND_API.G_MISS_NUM)
1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)
1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)
1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)

Line 1068: ,p_version_number => NVL(p_version_number,FND_API.G_MISS_NUM)

1064:
1065: Ibc_Citem_Versions_Pkg.UPDATE_ROW (
1066: p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
1067: ,p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
1068: ,p_version_number => NVL(p_version_number,FND_API.G_MISS_NUM)
1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)
1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)
1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)
1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)

Line 1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)

1065: Ibc_Citem_Versions_Pkg.UPDATE_ROW (
1066: p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
1067: ,p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
1068: ,p_version_number => NVL(p_version_number,FND_API.G_MISS_NUM)
1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)
1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)
1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)
1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)
1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)

Line 1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)

1066: p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
1067: ,p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
1068: ,p_version_number => NVL(p_version_number,FND_API.G_MISS_NUM)
1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)
1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)
1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)
1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)
1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)
1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)

Line 1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)

1067: ,p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
1068: ,p_version_number => NVL(p_version_number,FND_API.G_MISS_NUM)
1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)
1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)
1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)
1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)
1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)
1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)
1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)

Line 1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)

1068: ,p_version_number => NVL(p_version_number,FND_API.G_MISS_NUM)
1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)
1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)
1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)
1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)
1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)
1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)
1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)
1076: ,p_attachment_file_name => NVL(p_attachment_file_name,FND_API.G_MISS_CHAR)

Line 1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)

1069: ,p_citem_version_status => NVL(p_citem_version_status,FND_API.G_MISS_CHAR)
1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)
1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)
1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)
1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)
1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)
1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)
1076: ,p_attachment_file_name => NVL(p_attachment_file_name,FND_API.G_MISS_CHAR)
1077: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)

Line 1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)

1070: ,p_start_date => NVL(p_start_date,FND_API.G_MISS_DATE)
1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)
1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)
1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)
1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)
1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)
1076: ,p_attachment_file_name => NVL(p_attachment_file_name,FND_API.G_MISS_CHAR)
1077: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
1078: ,p_default_rendition_mime_type => NVL(p_default_rendition_mime_type,FND_API.G_MISS_CHAR)

Line 1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)

1071: ,p_end_date => NVL(p_end_date,FND_API.G_MISS_DATE)
1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)
1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)
1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)
1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)
1076: ,p_attachment_file_name => NVL(p_attachment_file_name,FND_API.G_MISS_CHAR)
1077: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
1078: ,p_default_rendition_mime_type => NVL(p_default_rendition_mime_type,FND_API.G_MISS_CHAR)
1079: ,p_last_updated_by => l_user_id

Line 1076: ,p_attachment_file_name => NVL(p_attachment_file_name,FND_API.G_MISS_CHAR)

1072: ,p_attachment_attribute_code => NVL(p_attachment_attribute_code,FND_API.G_MISS_CHAR)
1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)
1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)
1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)
1076: ,p_attachment_file_name => NVL(p_attachment_file_name,FND_API.G_MISS_CHAR)
1077: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
1078: ,p_default_rendition_mime_type => NVL(p_default_rendition_mime_type,FND_API.G_MISS_CHAR)
1079: ,p_last_updated_by => l_user_id
1080: ,p_last_update_date => l_last_update_date

Line 1077: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)

1073: ,p_attribute_file_id => NVL(p_attribute_file_id,FND_API.G_MISS_NUM)
1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)
1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)
1076: ,p_attachment_file_name => NVL(p_attachment_file_name,FND_API.G_MISS_CHAR)
1077: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
1078: ,p_default_rendition_mime_type => NVL(p_default_rendition_mime_type,FND_API.G_MISS_CHAR)
1079: ,p_last_updated_by => l_user_id
1080: ,p_last_update_date => l_last_update_date
1081: ,p_last_update_login => 0

Line 1078: ,p_default_rendition_mime_type => NVL(p_default_rendition_mime_type,FND_API.G_MISS_CHAR)

1074: ,p_attachment_file_id => NVL(p_attachment_file_id,FND_API.G_MISS_NUM)
1075: ,p_content_item_name => NVL(p_content_item_name,FND_API.G_MISS_CHAR)
1076: ,p_attachment_file_name => NVL(p_attachment_file_name,FND_API.G_MISS_CHAR)
1077: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
1078: ,p_default_rendition_mime_type => NVL(p_default_rendition_mime_type,FND_API.G_MISS_CHAR)
1079: ,p_last_updated_by => l_user_id
1080: ,p_last_update_date => l_last_update_date
1081: ,p_last_update_login => 0
1082: ,px_object_version_number => lx_object_version_number

Line 1083: ,p_citem_translation_status => NVL(p_citem_translation_status,FND_API.G_MISS_CHAR)

1079: ,p_last_updated_by => l_user_id
1080: ,p_last_update_date => l_last_update_date
1081: ,p_last_update_login => 0
1082: ,px_object_version_number => lx_object_version_number
1083: ,p_citem_translation_status => NVL(p_citem_translation_status,FND_API.G_MISS_CHAR)
1084: );
1085: END IF;
1086:
1087: EXCEPTION

Line 1189: RAISE Fnd_Api.G_EXC_ERROR;

1185: Fnd_Message.Set_token('NEW_ITEM_NAME' , p_content_item_name);
1186: Fnd_Message.Set_token('CONFLICTING_ITEM_NAME' , IBC_UTILITIES_PVT.get_citem_name(l_object_id));
1187: END IF;
1188: Fnd_Msg_Pub.ADD;
1189: RAISE Fnd_Api.G_EXC_ERROR;
1190: END IF;
1191: */
1192: END LOOP;
1193: