[Home] [Help]
1: PACKAGE BODY Ibc_Content_Items_Pkg AS
2: /* $Header: ibctconb.pls 120.2 2006/11/15 10:10:34 sharma ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Content_Items_Pkg table.
5:
1: PACKAGE BODY Ibc_Content_Items_Pkg AS
2: /* $Header: ibctconb.pls 120.2 2006/11/15 10:10:34 sharma ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Content_Items_Pkg table.
5:
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
15: -- not support for current release. Only in insert_row
16: -- SHARMA 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
17: -- LOAD_SEED_ROW for R12 LCT standards bug 4411674
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBC_CONTENT_ITEMS_PKG';
20: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibctconb.pls';
21:
22: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
23: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
363: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
364: db_user_id, db_last_update_date, p_upload_mode )) THEN
365:
366:
367: Ibc_Content_Items_Pkg.UPDATE_ROW (
368: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
369: ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)
370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
387: );
388: END IF;
389: EXCEPTION
390: WHEN no_data_found THEN
391: Ibc_Content_Items_Pkg.INSERT_ROW (
392: X_ROWID => l_row_id,
393: px_CONTENT_ITEM_ID => lx_CONTENT_ITEM_ID,
394: p_ITEM_REFERENCE_CODE => p_ITEM_REFERENCE_CODE,
395: p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
440: BEGIN
441: IF (p_UPLOAD_MODE = 'NLS') THEN
442: NULL;
443: ELSE
444: IBC_CONTENT_ITEMS_PKG.LOAD_ROW (
445: p_UPLOAD_MODE => p_UPLOAD_MODE,
446: p_CONTENT_ITEM_ID => TO_NUMBER(p_CONTENT_ITEM_ID),
447: p_ITEM_REFERENCE_CODE => p_ITEM_REFERENCE_CODE,
448: p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
464:
465: END LOAD_SEED_ROW;
466:
467:
468: END Ibc_Content_Items_Pkg;