APPS.IBC_CITEM_KEYWORDS_PKG dependencies on IBC_CITEM_KEYWORDS

Line 1: PACKAGE BODY Ibc_Citem_keywords_Pkg AS

1: PACKAGE BODY Ibc_Citem_keywords_Pkg AS
2: /* $Header: ibctkwdb.pls 120.1 2005/05/31 00:04:33 appldev $*/
3:
4: -- Purpose: Table Handler for ibc_citem_keywords table.
5:

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

1: PACKAGE BODY Ibc_Citem_keywords_Pkg AS
2: /* $Header: ibctkwdb.pls 120.1 2005/05/31 00:04:33 appldev $*/
3:
4: -- Purpose: Table Handler for ibc_citem_keywords table.
5:
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBC_CITEM_KEYWORDS_PKG';

7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- Edward Nunez 01/06/2002 Created Package
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IBC_CITEM_KEYWORDS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibctkwdb.pls';
13:
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 29: CURSOR C IS SELECT ROWID FROM IBC_CITEM_KEYWORDS

25: p_CREATED_BY IN NUMBER DEFAULT NULL,
26: p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
27: p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
28: ) IS
29: CURSOR C IS SELECT ROWID FROM IBC_CITEM_KEYWORDS
30: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
31: AND KEYWORD = p_KEYWORD;
32:
33: G_API_NAME CONSTANT VARCHAR2(30) := 'INSERT_ROW';

Line 40: INSERT INTO IBC_CITEM_KEYWORDS(

36:
37: OPEN c;
38: FETCH c INTO X_ROWID;
39: IF (c%NOTFOUND) THEN
40: INSERT INTO IBC_CITEM_KEYWORDS(
41: CONTENT_ITEM_ID,
42: KEYWORD,
43: OBJECT_VERSION_NUMBER,
44: CREATION_DATE,

Line 70: FROM IBC_CITEM_KEYWORDS

66: p_OBJECT_VERSION_NUMBER IN NUMBER
67: ) IS
68: CURSOR c IS SELECT
69: OBJECT_VERSION_NUMBER
70: FROM IBC_CITEM_KEYWORDS
71: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
72: FOR UPDATE OF CONTENT_ITEM_ID NOWAIT;
73: recinfo c%ROWTYPE;
74:

Line 106: UPDATE IBC_CITEM_KEYWORDS SET

102:
103: G_API_NAME CONSTANT VARCHAR2(30) := 'UPDATE_ROW';
104:
105: BEGIN
106: UPDATE IBC_CITEM_KEYWORDS SET
107: object_version_number = NVL(object_version_number,0) + 1
108: ,last_update_date = DECODE(p_last_update_date,NULL,SYSDATE,NULL,SYSDATE,p_last_update_date)
109: ,last_updated_by = DECODE(p_last_updated_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
110: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID

Line 141: DELETE FROM IBC_CITEM_KEYWORDS

137: G_API_NAME CONSTANT VARCHAR2(30) := 'DELETE_ROW';
138:
139: BEGIN
140:
141: DELETE FROM IBC_CITEM_KEYWORDS
142: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID
143: AND KEYWORD = p_KEYWORD;
144:
145: IF (SQL%NOTFOUND) THEN

Line 194: END Ibc_citem_keywords_Pkg;

190: END;
191: END LOAD_ROW;
192:
193:
194: END Ibc_citem_keywords_Pkg;