APPS.IBC_CITEM_KEYWORDS_PKG dependencies on FND_GLOBAL

Line 14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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;
16:
17:
18:

Line 15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

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;
16:
17:
18:
19: PROCEDURE INSERT_ROW (

Line 53: ,DECODE(p_created_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

49: p_content_item_id
50: ,p_keyword
51: ,DECODE(p_object_version_number,NULL,1,NULL,1,p_object_version_number)
52: ,DECODE(p_creation_date,NULL,SYSDATE,NULL,SYSDATE,p_creation_date)
53: ,DECODE(p_created_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
54: ,DECODE(p_last_update_date,NULL,SYSDATE,NULL,SYSDATE,p_last_update_date)
55: ,DECODE(p_last_updated_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
56: );
57: END IF;

Line 55: ,DECODE(p_last_updated_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

51: ,DECODE(p_object_version_number,NULL,1,NULL,1,p_object_version_number)
52: ,DECODE(p_creation_date,NULL,SYSDATE,NULL,SYSDATE,p_creation_date)
53: ,DECODE(p_created_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
54: ,DECODE(p_last_update_date,NULL,SYSDATE,NULL,SYSDATE,p_last_update_date)
55: ,DECODE(p_last_updated_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
56: );
57: END IF;
58: CLOSE c;
59:

Line 109: ,last_updated_by = DECODE(p_last_updated_by,NULL,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

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
111: AND KEYWORD = p_KEYWORD
112: AND object_version_number = DECODE(px_object_version_number,
113: NULL,