eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_CONTENT_ITEMS_PKG dependencies on FND_GLOBAL

Line 22: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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;
24:
25:
26: PROCEDURE INSERT_ROW (

Line 23: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

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;
24:
25:
26: PROCEDURE INSERT_ROW (
27: x_rowid OUT NOCOPY VARCHAR2

Line 105: ,DECODE(p_owner_resource_id,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_owner_resource_id)

101: ,DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,p_locked_by_user_id)
102: ,'F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
103: ,p_base_language
104: ,p_translation_required_flag
105: ,DECODE(p_owner_resource_id,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_owner_resource_id)
106: ,p_owner_resource_type
107: ,DECODE(p_application_id,FND_API.G_MISS_NUM,FND_GLOBAL.resp_appl_id,NULL,FND_GLOBAL.resp_appl_id,p_application_id)
108: ,DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
109: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)

Line 107: ,DECODE(p_application_id,FND_API.G_MISS_NUM,FND_GLOBAL.resp_appl_id,NULL,FND_GLOBAL.resp_appl_id,p_application_id)

103: ,p_base_language
104: ,p_translation_required_flag
105: ,DECODE(p_owner_resource_id,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_owner_resource_id)
106: ,p_owner_resource_type
107: ,DECODE(p_application_id,FND_API.G_MISS_NUM,FND_GLOBAL.resp_appl_id,NULL,FND_GLOBAL.resp_appl_id,p_application_id)
108: ,DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
109: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
110: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
111: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

Line 111: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

107: ,DECODE(p_application_id,FND_API.G_MISS_NUM,FND_GLOBAL.resp_appl_id,NULL,FND_GLOBAL.resp_appl_id,p_application_id)
108: ,DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
109: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
110: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
111: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
112: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
113: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
114: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
115: ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,p_encrypt_flag)

Line 113: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

109: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
110: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
111: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
112: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
113: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
114: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
115: ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,p_encrypt_flag)
116:
117: );

Line 114: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

110: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
111: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
112: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
113: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
114: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
115: ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,p_encrypt_flag)
116:
117: );
118:

Line 254: ,application_id = DECODE(p_application_id,FND_API.G_MISS_NUM,FND_GLOBAL.resp_appl_id,NULL,application_id,p_application_id)

250: ,base_language = DECODE(p_base_language,FND_API.G_MISS_CHAR,NULL,NULL,base_language,p_base_language)
251: ,translation_required_flag = DECODE(p_translation_required_flag,FND_API.G_MISS_CHAR,NULL,NULL,translation_required_flag,p_translation_required_flag)
252: ,owner_resource_id = DECODE(p_owner_resource_id,FND_API.G_MISS_NUM,NULL,NULL,owner_resource_id,p_owner_resource_id)
253: ,owner_resource_type = DECODE(p_owner_resource_type,FND_API.G_MISS_CHAR,NULL,NULL,owner_resource_type,p_owner_resource_type)
254: ,application_id = DECODE(p_application_id,FND_API.G_MISS_NUM,FND_GLOBAL.resp_appl_id,NULL,application_id,p_application_id)
255: ,request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NULL,request_id,p_request_id)
256: -- ,object_version_number = NVL(object_version_number,0) + 1
257: ,object_version_number = 1
258: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 259: ,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)

255: ,request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NULL,request_id,p_request_id)
256: -- ,object_version_number = NVL(object_version_number,0) + 1
257: ,object_version_number = 1
258: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
259: ,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)
260: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
261: ,encrypt_flag = DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,NULL,encrypt_flag,p_encrypt_flag)
262: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;
263:

Line 260: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

256: -- ,object_version_number = NVL(object_version_number,0) + 1
257: ,object_version_number = 1
258: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
259: ,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)
260: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
261: ,encrypt_flag = DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,NULL,encrypt_flag,p_encrypt_flag)
262: WHERE CONTENT_ITEM_ID = p_CONTENT_ITEM_ID;
263:
264: -- AND object_version_number = DECODE(px_object_version_number,