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_API

Line 10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX

6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- Sri Rangarajan 01/06/2002 Created Package
10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11: -- vicho 11/13/2002 Added Overloaded procedures for OA UI
12: -- shitij.vatsa 02/11/2003 Added parameter p_subitem_version_id
13: -- to the APIs
14: -- vicho 07/24/03 Fixed p_encrypt_flag to type, VARCHAR2

Line 54: ,DECODE(p_application_id,FND_API.G_MISS_NUM,NULL,p_application_id)

50: OWNER_FND_USER_ID
51: ) VALUES (
52: p_content_type_code
53: ,p_content_type_status
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)

Line 55: ,DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id)

51: ) VALUES (
52: p_content_type_code
53: ,p_content_type_status
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)

Line 56: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)

52: p_content_type_code
53: ,p_content_type_status
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)

Line 57: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

53: ,p_content_type_status
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)

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 59: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

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)
63: ,DECODE(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM,NULL,p_OWNER_FND_USER_ID)

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 62: ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,'Y','T','N',NULL,p_encrypt_flag)

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:
66:

Line 63: ,DECODE(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM,NULL,p_OWNER_FND_USER_ID)

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:
66:
67: INSERT INTO IBC_CONTENT_TYPES_TL (

Line 81: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)

77: SOURCE_LANG
78: ) SELECT
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)

Line 82: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

78: ) SELECT
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)

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 84: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

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
88: ,USERENV('LANG')

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 190: content_type_status = DECODE(p_content_type_status,FND_API.G_MISS_CHAR,NULL,NULL,content_type_status,p_content_type_status)

186:
187: ) IS
188: BEGIN
189: UPDATE IBC_CONTENT_TYPES_B SET
190: content_type_status = DECODE(p_content_type_status,FND_API.G_MISS_CHAR,NULL,NULL,content_type_status,p_content_type_status)
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)

Line 191: ,application_id = DECODE(p_application_id,FND_API.G_MISS_NUM,NULL,NULL,application_id,p_application_id)

187: ) IS
188: BEGIN
189: UPDATE IBC_CONTENT_TYPES_B SET
190: content_type_status = DECODE(p_content_type_status,FND_API.G_MISS_CHAR,NULL,NULL,content_type_status,p_content_type_status)
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)

Line 192: ,request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NULL,request_id,p_request_id)

188: BEGIN
189: UPDATE IBC_CONTENT_TYPES_B SET
190: content_type_status = DECODE(p_content_type_status,FND_API.G_MISS_CHAR,NULL,NULL,content_type_status,p_content_type_status)
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)

Line 194: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

190: content_type_status = DECODE(p_content_type_status,FND_API.G_MISS_CHAR,NULL,NULL,content_type_status,p_content_type_status)
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)

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 197: ,encrypt_flag = DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,NULL,encrypt_flag,'Y','T','N',NULL,p_encrypt_flag)

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,
201: FND_API.G_MISS_NUM,

Line 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)

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,
201: FND_API.G_MISS_NUM,
202: object_version_number,

Line 201: FND_API.G_MISS_NUM,

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,
201: FND_API.G_MISS_NUM,
202: object_version_number,
203: NULL,
204: object_version_number,
205: p_object_version_number);

Line 214: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

210:
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

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 384: p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)

380: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
381: db_user_id, db_last_update_date, p_upload_mode )) THEN
382:
383: Ibc_Content_Types_Pkg.UPDATE_ROW (
384: p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
385: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)
386: ,p_content_type_name => NVL(p_content_type_name,FND_API.G_MISS_CHAR)
387: ,p_content_type_status => NVL(p_content_type_status,FND_API.G_MISS_CHAR)
388: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)

Line 385: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)

381: db_user_id, db_last_update_date, p_upload_mode )) THEN
382:
383: Ibc_Content_Types_Pkg.UPDATE_ROW (
384: p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
385: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)
386: ,p_content_type_name => NVL(p_content_type_name,FND_API.G_MISS_CHAR)
387: ,p_content_type_status => NVL(p_content_type_status,FND_API.G_MISS_CHAR)
388: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
389: ,p_last_updated_by => l_user_id

Line 386: ,p_content_type_name => NVL(p_content_type_name,FND_API.G_MISS_CHAR)

382:
383: Ibc_Content_Types_Pkg.UPDATE_ROW (
384: p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
385: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)
386: ,p_content_type_name => NVL(p_content_type_name,FND_API.G_MISS_CHAR)
387: ,p_content_type_status => NVL(p_content_type_status,FND_API.G_MISS_CHAR)
388: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
389: ,p_last_updated_by => l_user_id
390: ,p_last_update_date => l_last_update_date

Line 387: ,p_content_type_status => NVL(p_content_type_status,FND_API.G_MISS_CHAR)

383: Ibc_Content_Types_Pkg.UPDATE_ROW (
384: p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
385: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)
386: ,p_content_type_name => NVL(p_content_type_name,FND_API.G_MISS_CHAR)
387: ,p_content_type_status => NVL(p_content_type_status,FND_API.G_MISS_CHAR)
388: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
389: ,p_last_updated_by => l_user_id
390: ,p_last_update_date => l_last_update_date
391: ,p_last_update_login => 0

Line 388: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)

384: p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
385: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)
386: ,p_content_type_name => NVL(p_content_type_name,FND_API.G_MISS_CHAR)
387: ,p_content_type_status => NVL(p_content_type_status,FND_API.G_MISS_CHAR)
388: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
389: ,p_last_updated_by => l_user_id
390: ,p_last_update_date => l_last_update_date
391: ,p_last_update_login => 0
392: ,p_object_version_number => NULL

Line 394: ,p_OWNER_FND_USER_ID => NVL(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM)

390: ,p_last_update_date => l_last_update_date
391: ,p_last_update_login => 0
392: ,p_object_version_number => NULL
393: ,p_encrypt_flag => NVL(p_encrypt_flag,'N')
394: ,p_OWNER_FND_USER_ID => NVL(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM)
395: );
396: END IF;
397:
398: EXCEPTION

Line 416: p_OWNER_FND_USER_ID => NVL(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM)

412: p_LAST_UPDATE_DATE => l_last_update_date,
413: p_LAST_UPDATED_BY => l_user_id,
414: p_LAST_UPDATE_LOGIN => 0,
415: p_encrypt_flag => NVL(p_encrypt_flag,'N'),
416: p_OWNER_FND_USER_ID => NVL(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM)
417: );
418: END;
419: END LOAD_ROW;
420: