1: PACKAGE BODY Ibc_Citem_Version_Labels_Pkg AS
2: /* $Header: ibctcvlb.pls 120.1 2005/07/29 15:07:45 appldev ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Citem_Version_Labels table.
5:
167: AND CITEM_VERSION_ID = p_CITEM_VERSION_ID
168: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;
169:
170: EXCEPTION WHEN no_data_found THEN
171: Ibc_Citem_Version_Labels_Pkg.LOAD_ROW(
172: p_UPLOAD_MODE => p_UPLOAD_MODE,
173: p_CONTENT_ITEM_ID => p_UPLOAD_MODE,
174: p_LABEL_CODE => p_UPLOAD_MODE,
175: p_CITEM_VERSION_ID => p_UPLOAD_MODE,
211:
212: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
213: db_user_id, db_last_update_date, p_upload_mode )) THEN
214: BEGIN
215: Ibc_Citem_Version_Labels_Pkg.UPDATE_ROW (
216: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
217: ,p_label_code => NVL(p_label_code,FND_API.G_MISS_CHAR)
218: ,p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)
219: ,p_last_updated_by => l_user_id
221: ,p_last_update_login => 0
222: ,p_object_version_number => l_object_version_number);
223: EXCEPTION
224: WHEN NO_DATA_FOUND THEN
225: Ibc_Citem_Version_Labels_Pkg.INSERT_ROW (
226: x_rowid => l_row_id,
227: p_CONTENT_ITEM_ID => p_CONTENT_ITEM_ID,
228: p_LABEL_CODE => p_LABEL_CODE,
229: p_CITEM_VERSION_ID => p_CITEM_VERSION_ID,
237: END IF;
238: END LOAD_ROW;
239:
240:
241: END Ibc_Citem_Version_Labels_Pkg;