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_TYPES_PKG dependencies on FND_GLOBAL

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

54: ,DECODE(p_application_id,FND_API.G_MISS_NUM,NULL,p_application_id)
55: ,DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)
56: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
57: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
58: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
59: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
60: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
61: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
62: ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,'Y','T','N',NULL,p_encrypt_flag)

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

56: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
57: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
58: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
59: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
60: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
61: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
62: ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,'Y','T','N',NULL,p_encrypt_flag)
63: ,DECODE(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM,NULL,p_OWNER_FND_USER_ID)
64: );

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

57: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
58: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
59: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
60: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
61: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
62: ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,'Y','T','N',NULL,p_encrypt_flag)
63: ,DECODE(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM,NULL,p_OWNER_FND_USER_ID)
64: );
65:

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

79: p_content_type_code
80: ,p_content_type_name
81: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
82: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
83: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
84: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
85: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
86: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
87: ,L.LANGUAGE_CODE

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

81: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
82: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
83: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
84: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
85: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
86: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
87: ,L.LANGUAGE_CODE
88: ,USERENV('LANG')
89: FROM FND_LANGUAGES L

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

82: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
83: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
84: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
85: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
86: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
87: ,L.LANGUAGE_CODE
88: ,USERENV('LANG')
89: FROM FND_LANGUAGES L
90: WHERE L.INSTALLED_FLAG IN ('I', 'B')

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

191: ,application_id = DECODE(p_application_id,FND_API.G_MISS_NUM,NULL,NULL,application_id,p_application_id)
192: ,request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NULL,request_id,p_request_id)
193: ,object_version_number = NVL(object_version_number,0) + 1
194: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
195: ,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)
196: ,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)
197: ,encrypt_flag = DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,NULL,encrypt_flag,'Y','T','N',NULL,p_encrypt_flag)
198: ,OWNER_FND_USER_ID = DECODE(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM,NULL,NULL,OWNER_FND_USER_ID,p_OWNER_FND_USER_ID)
199: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE

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

192: ,request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NULL,request_id,p_request_id)
193: ,object_version_number = NVL(object_version_number,0) + 1
194: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
195: ,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)
196: ,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)
197: ,encrypt_flag = DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,NULL,encrypt_flag,'Y','T','N',NULL,p_encrypt_flag)
198: ,OWNER_FND_USER_ID = DECODE(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM,NULL,NULL,OWNER_FND_USER_ID,p_OWNER_FND_USER_ID)
199: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
200: AND object_version_number = DECODE(p_object_version_number,

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

211: UPDATE IBC_CONTENT_TYPES_TL SET
212: content_type_name = p_content_type_name
213: ,description = p_description
214: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
215: ,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)
216: ,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)
217: ,source_lang = USERENV('LANG')
218: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
219: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);

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

212: content_type_name = p_content_type_name
213: ,description = p_description
214: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
215: ,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)
216: ,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)
217: ,source_lang = USERENV('LANG')
218: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
219: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
220:

Line 771: X_OWNER_FND_USER_ID => Fnd_Global.user_id,

767: X_ROWID => l_row_id,
768: X_CONTENT_TYPE_CODE => l_CONTENT_TYPE_CODE,
769: X_CONTENT_TYPE_STATUS => i_rec.CONTENT_TYPE_STATUS,
770: X_APPLICATION_ID => i_rec.APPLICATION_ID,
771: X_OWNER_FND_USER_ID => Fnd_Global.user_id,
772: X_REQUEST_ID => NULL,
773: X_OBJECT_VERSION_NUMBER => 1,
774: X_CONTENT_TYPE_NAME => 'Copy Of ' || i_rec.CONTENT_TYPE_NAME,
775: X_DESCRIPTION => i_rec.DESCRIPTION,

Line 777: X_CREATED_BY => Fnd_Global.user_id,

773: X_OBJECT_VERSION_NUMBER => 1,
774: X_CONTENT_TYPE_NAME => 'Copy Of ' || i_rec.CONTENT_TYPE_NAME,
775: X_DESCRIPTION => i_rec.DESCRIPTION,
776: X_CREATION_DATE => SYSDATE,
777: X_CREATED_BY => Fnd_Global.user_id,
778: X_LAST_UPDATE_DATE => SYSDATE,
779: X_LAST_UPDATED_BY => Fnd_Global.user_id,
780: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id,
781: -- x_program_update_date => NULL,

Line 779: X_LAST_UPDATED_BY => Fnd_Global.user_id,

775: X_DESCRIPTION => i_rec.DESCRIPTION,
776: X_CREATION_DATE => SYSDATE,
777: X_CREATED_BY => Fnd_Global.user_id,
778: X_LAST_UPDATE_DATE => SYSDATE,
779: X_LAST_UPDATED_BY => Fnd_Global.user_id,
780: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id,
781: -- x_program_update_date => NULL,
782: -- x_program_application_id =>NULL,
783: -- x_program_id => NULL,

Line 780: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id,

776: X_CREATION_DATE => SYSDATE,
777: X_CREATED_BY => Fnd_Global.user_id,
778: X_LAST_UPDATE_DATE => SYSDATE,
779: X_LAST_UPDATED_BY => Fnd_Global.user_id,
780: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id,
781: -- x_program_update_date => NULL,
782: -- x_program_application_id =>NULL,
783: -- x_program_id => NULL,
784: X_SECURITY_GROUP_ID => NULL);

Line 809: ,X_CREATED_BY => Fnd_Global.user_id

805: ,X_SECURITY_GROUP_ID => NULL
806: ,X_ATTRIBUTE_TYPE_NAME => i_rec.ATTRIBUTE_TYPE_NAME
807: ,X_DESCRIPTION => i_rec.DESCRIPTION
808: ,X_CREATION_DATE => SYSDATE
809: ,X_CREATED_BY => Fnd_Global.user_id
810: ,X_LAST_UPDATE_DATE => SYSDATE
811: ,X_LAST_UPDATED_BY => Fnd_Global.user_id
812: ,X_LAST_UPDATE_LOGIN => Fnd_Global.login_id);
813: END LOOP;

Line 811: ,X_LAST_UPDATED_BY => Fnd_Global.user_id

807: ,X_DESCRIPTION => i_rec.DESCRIPTION
808: ,X_CREATION_DATE => SYSDATE
809: ,X_CREATED_BY => Fnd_Global.user_id
810: ,X_LAST_UPDATE_DATE => SYSDATE
811: ,X_LAST_UPDATED_BY => Fnd_Global.user_id
812: ,X_LAST_UPDATE_LOGIN => Fnd_Global.login_id);
813: END LOOP;
814:
815:

Line 812: ,X_LAST_UPDATE_LOGIN => Fnd_Global.login_id);

808: ,X_CREATION_DATE => SYSDATE
809: ,X_CREATED_BY => Fnd_Global.user_id
810: ,X_LAST_UPDATE_DATE => SYSDATE
811: ,X_LAST_UPDATED_BY => Fnd_Global.user_id
812: ,X_LAST_UPDATE_LOGIN => Fnd_Global.login_id);
813: END LOOP;
814:
815:
816: END;