APPS.IBC_CITEM_VERSIONS_PKG dependencies on IBC_CITEM_VERSIONS_PKG

Line 1: PACKAGE BODY Ibc_Citem_Versions_Pkg AS

1: PACKAGE BODY Ibc_Citem_Versions_Pkg AS
2: /* $Header: ibctcivb.pls 120.7.12010000.1 2008/07/28 11:02:22 appldev ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Citem_Versions table.
5:

Line 36: G_PKG_NAME CONSTANT VARCHAR2(100) := 'IBC_CITEM_VERSIONS_PKG';

32: -- Sri.Rangarajan 08/20/2005 Added TEXTIDX = 'X' in update_row.Added concurrent request
33: -- to sync Content Text indexes
34:
35:
36: G_PKG_NAME CONSTANT VARCHAR2(100) := 'IBC_CITEM_VERSIONS_PKG';
37:
38:
39: PROCEDURE INSERT_ROW (
40: x_rowid OUT NOCOPY VARCHAR2

Line 1065: Ibc_Citem_Versions_Pkg.UPDATE_ROW (

1061:
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)

Line 1094: Ibc_Citem_Versions_Pkg.INSERT_ROW (

1090: SELECT MAX(object_version_number) INTO lx_object_version_number
1091: FROM IBC_CONTENT_ITEMS
1092: WHERE content_item_id = p_content_item_id;
1093:
1094: Ibc_Citem_Versions_Pkg.INSERT_ROW (
1095: X_ROWID => l_row_id,
1096: px_CITEM_VERSION_ID => lx_CITEM_VERSION_ID,
1097: p_CONTENT_ITEM_ID => p_CONTENT_ITEM_ID,
1098: p_VERSION_NUMBER => p_VERSION_NUMBER,

Line 1396: Ibc_Citem_Versions_Pkg.TRANSLATE_ROW (

1392: p_CITEM_TRANSLATION_STATUS IN VARCHAR2 DEFAULT NULL,
1393: p_LAST_UPDATE_DATE IN VARCHAR2 ) IS
1394: BEGIN
1395: IF (p_UPLOAD_MODE = 'NLS') THEN
1396: Ibc_Citem_Versions_Pkg.TRANSLATE_ROW (
1397: p_UPLOAD_MODE => p_UPLOAD_MODE,
1398: p_CITEM_VERSION_ID => p_CITEM_VERSION_ID,
1399: p_ATTACHMENT_ATTRIBUTE_CODE => p_ATTACHMENT_ATTRIBUTE_CODE,
1400: p_ATTRIBUTE_FILE_ID => p_ATTRIBUTE_FILE_ID,

Line 1411: Ibc_Citem_Versions_Pkg.LOAD_ROW (

1407: p_CITEM_TRANSLATION_STATUS => p_CITEM_TRANSLATION_STATUS,
1408: p_LAST_UPDATE_DATE => p_LAST_UPDATE_DATE );
1409:
1410: ELSE
1411: Ibc_Citem_Versions_Pkg.LOAD_ROW (
1412: p_UPLOAD_MODE => p_UPLOAD_MODE,
1413: p_CITEM_VERSION_ID => p_CITEM_VERSION_ID,
1414: p_CONTENT_ITEM_ID => p_CONTENT_ITEM_ID,
1415: p_VERSION_NUMBER => p_VERSION_NUMBER,

Line 1432: END Ibc_Citem_Versions_Pkg;

1428: p_LAST_UPDATE_DATE => p_LAST_UPDATE_DATE );
1429: END IF;
1430: END;
1431:
1432: END Ibc_Citem_Versions_Pkg;