APPS.IBC_CITEM_VERSION_LABELS_PKG dependencies on IBC_CITEM_VERSION_LABELS

Line 1: PACKAGE BODY Ibc_Citem_Version_Labels_Pkg AS

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:

Line 4: -- Purpose: Table Handler for Ibc_Citem_Version_Labels table.

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:
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------

Line 26: CURSOR C IS SELECT ROWID FROM IBC_CITEM_VERSION_LABELS

22: ,p_last_update_date IN DATE --DEFAULT NULL
23: ,p_last_updated_by IN NUMBER --DEFAULT NULL
24: ,p_last_update_login IN NUMBER --DEFAULT NULL
25: ) IS
26: CURSOR C IS SELECT ROWID FROM IBC_CITEM_VERSION_LABELS
27: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
28: AND LABEL_CODE = p_LABEL_CODE;
29: BEGIN
30: INSERT INTO IBC_CITEM_VERSION_LABELS (

Line 30: INSERT INTO IBC_CITEM_VERSION_LABELS (

26: CURSOR C IS SELECT ROWID FROM IBC_CITEM_VERSION_LABELS
27: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
28: AND LABEL_CODE = p_LABEL_CODE;
29: BEGIN
30: INSERT INTO IBC_CITEM_VERSION_LABELS (
31: CONTENT_ITEM_ID,
32: LABEL_CODE,
33: CITEM_VERSION_ID,
34: OBJECT_VERSION_NUMBER,

Line 72: FROM IBC_CITEM_VERSION_LABELS

68: ) IS
69: CURSOR c IS SELECT
70: CITEM_VERSION_ID,
71: OBJECT_VERSION_NUMBER
72: FROM IBC_CITEM_VERSION_LABELS
73: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
74: AND LABEL_CODE = p_LABEL_CODE
75: FOR UPDATE OF CONTENT_ITEM_ID NOWAIT;
76: recinfo c%ROWTYPE;

Line 108: UPDATE IBC_CITEM_VERSION_LABELS SET

104: ,p_last_update_login IN NUMBER --DEFAULT NULL
105: ,p_object_version_number IN NUMBER --DEFAULT NULL
106: ) IS
107: BEGIN
108: UPDATE IBC_CITEM_VERSION_LABELS SET
109: citem_version_id = DECODE(p_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
110: ,object_version_number = NVL(object_version_number,0) + 1
111: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
112: ,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 135: DELETE FROM IBC_CITEM_VERSION_LABELS

131: p_LABEL_CODE IN VARCHAR2
132: ) IS
133: BEGIN
134:
135: DELETE FROM IBC_CITEM_VERSION_LABELS
136: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
137: AND LABEL_CODE = p_LABEL_CODE;
138:
139: IF (SQL%NOTFOUND) THEN

Line 165: SELECT '1' INTO l_temp FROM IBC_CITEM_VERSION_LABELS

161: FROM IBC_LABELS_B
162: WHERE LABEL_CODE = p_LABEL_CODE;
163:
164:
165: SELECT '1' INTO l_temp FROM IBC_CITEM_VERSION_LABELS
166: WHERE last_updated_by <> 1
167: AND CITEM_VERSION_ID = p_CITEM_VERSION_ID
168: AND CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;
169:

Line 171: Ibc_Citem_Version_Labels_Pkg.LOAD_ROW(

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,

Line 208: FROM IBC_CITEM_VERSION_LABELS

204:
205:
206: -- get updatedby and update_date values if existing in db
207: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
208: FROM IBC_CITEM_VERSION_LABELS
209: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
210: AND LABEL_CODE = p_LABEL_CODE;
211:
212: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

Line 215: Ibc_Citem_Version_Labels_Pkg.UPDATE_ROW (

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

Line 225: Ibc_Citem_Version_Labels_Pkg.INSERT_ROW (

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,

Line 241: END Ibc_Citem_Version_Labels_Pkg;

237: END IF;
238: END LOAD_ROW;
239:
240:
241: END Ibc_Citem_Version_Labels_Pkg;