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_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: -- shitij.vatsa 02/11/2003 Added parameter p_subitem_version_id
12: -- to the APIs
13: -- Edward Nunez 12/04/2003 Got rid of handling of ovn in update_row
14: -- Edward Nunez 12/09/2003 Hardcoding 'F' to wd_restricted_flag as it is

Line 63: (px_CONTENT_ITEM_ID = FND_API.G_MISS_NUM))

59:
60: -- Primary key validation check
61:
62: IF ((px_CONTENT_ITEM_ID IS NULL) OR
63: (px_CONTENT_ITEM_ID = FND_API.G_MISS_NUM))
64: THEN
65: OPEN c2;
66: FETCH c2 INTO px_CONTENT_ITEM_ID;
67: CLOSE c2;

Line 96: ,UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,p_item_reference_code))

92: encrypt_flag
93: ) VALUES (
94: px_content_item_id
95: ,p_content_type_code
96: ,UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,p_item_reference_code))
97: ,p_directory_node_id
98: ,DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,p_parent_item_id)
99: ,DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,p_live_citem_version_id)
100: ,DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,p_content_item_status)

Line 98: ,DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,p_parent_item_id)

94: px_content_item_id
95: ,p_content_type_code
96: ,UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,p_item_reference_code))
97: ,p_directory_node_id
98: ,DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,p_parent_item_id)
99: ,DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,p_live_citem_version_id)
100: ,DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,p_content_item_status)
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

Line 99: ,DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,p_live_citem_version_id)

95: ,p_content_type_code
96: ,UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,p_item_reference_code))
97: ,p_directory_node_id
98: ,DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,p_parent_item_id)
99: ,DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,p_live_citem_version_id)
100: ,DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,p_content_item_status)
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

Line 100: ,DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,p_content_item_status)

96: ,UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,p_item_reference_code))
97: ,p_directory_node_id
98: ,DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,p_parent_item_id)
99: ,DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,p_live_citem_version_id)
100: ,DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,p_content_item_status)
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

Line 101: ,DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,p_locked_by_user_id)

97: ,p_directory_node_id
98: ,DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,p_parent_item_id)
99: ,DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,p_live_citem_version_id)
100: ,DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,p_content_item_status)
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)

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

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

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

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

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

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

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

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)
116:

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 115: ,DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,p_encrypt_flag)

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:
119: OPEN c;

Line 127: RAISE FND_API.G_EXC_ERROR;

123: FND_MESSAGE.Set_Name('IBC', 'IBC_ERROR_RETURNED');
124: FND_MESSAGE.Set_token('PKG_NAME' , G_pkg_name);
125: FND_MESSAGE.Set_token('API_NAME' , G_api_name);
126: FND_MSG_PUB.ADD;
127: RAISE FND_API.G_EXC_ERROR;
128: -- RAISE NO_DATA_FOUND;
129: END IF;
130: CLOSE c;
131:

Line 241: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)

237: l_object_version_number NUMBER;
238:
239: BEGIN
240: UPDATE IBC_CONTENT_ITEMS SET
241: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
242: ,item_reference_code = UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,item_reference_code,p_item_reference_code))
243: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)

Line 242: ,item_reference_code = UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,item_reference_code,p_item_reference_code))

238:
239: BEGIN
240: UPDATE IBC_CONTENT_ITEMS SET
241: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
242: ,item_reference_code = UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,item_reference_code,p_item_reference_code))
243: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)
246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)

Line 243: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)

239: BEGIN
240: UPDATE IBC_CONTENT_ITEMS SET
241: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
242: ,item_reference_code = UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,item_reference_code,p_item_reference_code))
243: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)
246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)
247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)

Line 244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)

240: UPDATE IBC_CONTENT_ITEMS SET
241: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
242: ,item_reference_code = UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,item_reference_code,p_item_reference_code))
243: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)
246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)
247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)
248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)

Line 245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)

241: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
242: ,item_reference_code = UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,item_reference_code,p_item_reference_code))
243: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)
246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)
247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)
248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)
249: ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment

Line 246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)

242: ,item_reference_code = UPPER(DECODE(p_item_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,item_reference_code,p_item_reference_code))
243: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)
246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)
247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)
248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)
249: ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
250: ,base_language = DECODE(p_base_language,FND_API.G_MISS_CHAR,NULL,NULL,base_language,p_base_language)

Line 247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)

243: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)
246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)
247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)
248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)
249: ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
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)

Line 248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)

244: ,parent_item_id = DECODE(p_parent_item_id,FND_API.G_MISS_NUM,NULL,NULL,parent_item_id,p_parent_item_id)
245: ,live_citem_version_id = DECODE(p_live_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,live_citem_version_id,p_live_citem_version_id)
246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)
247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)
248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)
249: ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
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)

Line 250: ,base_language = DECODE(p_base_language,FND_API.G_MISS_CHAR,NULL,NULL,base_language,p_base_language)

246: ,content_item_status = DECODE(p_content_item_status,FND_API.G_MISS_CHAR,NULL,NULL,content_item_status,p_content_item_status)
247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)
248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)
249: ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
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)

Line 251: ,translation_required_flag = DECODE(p_translation_required_flag,FND_API.G_MISS_CHAR,NULL,NULL,translation_required_flag,p_translation_required_flag)

247: ,locked_by_user_id = DECODE(p_locked_by_user_id,FND_API.G_MISS_NUM,NULL,NULL,locked_by_user_id,p_locked_by_user_id)
248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)
249: ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
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)

Line 252: ,owner_resource_id = DECODE(p_owner_resource_id,FND_API.G_MISS_NUM,NULL,NULL,owner_resource_id,p_owner_resource_id)

248: -- ,wd_restricted_flag = DECODE(p_wd_restricted_flag,FND_API.G_MISS_CHAR,NULL,NULL,wd_restricted_flag,p_wd_restricted_flag)
249: ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
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

Line 253: ,owner_resource_type = DECODE(p_owner_resource_type,FND_API.G_MISS_CHAR,NULL,NULL,owner_resource_type,p_owner_resource_type)

249: ,wd_restricted_flag ='F' -- p_wd_restricted_flag -- Setting hardcoded to 'F' as it is not being used at the moment
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

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 255: ,request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NULL,request_id,p_request_id)

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

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

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

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,

Line 261: ,encrypt_flag = DECODE(p_encrypt_flag,FND_API.G_MISS_CHAR,NULL,NULL,encrypt_flag,p_encrypt_flag)

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

Line 265: -- FND_API.G_MISS_NUM,

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,
265: -- FND_API.G_MISS_NUM,
266: -- object_version_number,
267: -- NULL,
268: -- object_version_number,
269: -- px_object_version_number);

Line 276: -- (px_object_version_number = FND_API.G_MISS_NUM )

272:
273: -- IF (
274: -- (px_object_version_number IS NULL)
275: -- OR
276: -- (px_object_version_number = FND_API.G_MISS_NUM )
277: -- ) THEN
278: -- OPEN cur_object_version(p_CONTENT_ITEM_ID);
279: -- FETCH cur_object_version INTO l_object_version_number;
280: -- CLOSE cur_object_version;

Line 292: RAISE FND_API.G_EXC_ERROR;

288: FND_MESSAGE.Set_Name('IBC', 'IBC_ERROR_RETURNED');
289: FND_MESSAGE.Set_token('PKG_NAME' , G_pkg_name);
290: FND_MESSAGE.Set_token('API_NAME' , G_api_name);
291: FND_MSG_PUB.ADD;
292: RAISE FND_API.G_EXC_ERROR;
293: -- RAISE NO_DATA_FOUND;
294: END IF;
295:
296: END UPDATE_ROW;

Line 314: RAISE FND_API.G_EXC_ERROR;

310: FND_MESSAGE.Set_Name('IBC', 'IBC_ERROR_RETURNED');
311: FND_MESSAGE.Set_token('PKG_NAME' , G_pkg_name);
312: FND_MESSAGE.Set_token('API_NAME' , G_api_name);
313: FND_MSG_PUB.ADD;
314: RAISE FND_API.G_EXC_ERROR;
315: -- RAISE NO_DATA_FOUND;
316: END IF;
317: END DELETE_ROW;
318:

Line 344: lx_object_version_number NUMBER := FND_API.G_MISS_NUM;

340: BEGIN
341: DECLARE
342: l_user_id NUMBER := 0;
343: l_row_id VARCHAR2(64);
344: lx_object_version_number NUMBER := FND_API.G_MISS_NUM;
345: lx_CONTENT_ITEM_ID NUMBER := p_CONTENT_ITEM_ID;
346: l_last_update_date DATE;
347:
348: db_user_id NUMBER := 0;

Line 368: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)

364: db_user_id, db_last_update_date, p_upload_mode )) THEN
365:
366:
367: Ibc_Content_Items_Pkg.UPDATE_ROW (
368: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
369: ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)
370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)

Line 369: ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)

365:
366:
367: Ibc_Content_Items_Pkg.UPDATE_ROW (
368: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
369: ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)
370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)

Line 370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)

366:
367: Ibc_Content_Items_Pkg.UPDATE_ROW (
368: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
369: ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)
370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)

Line 371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)

367: Ibc_Content_Items_Pkg.UPDATE_ROW (
368: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
369: ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)
370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)

Line 372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)

368: p_content_item_id => NVL(p_content_item_id,FND_API.G_MISS_NUM)
369: ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)
370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)
376: ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)

Line 373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)

369: ,p_item_reference_code => NVL(p_item_reference_code,FND_API.G_MISS_CHAR)
370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)
376: ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)
377: ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)

Line 374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)

370: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)
376: ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)
377: ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)
378: ,p_translation_required_flag => NVL(p_translation_required_flag,FND_API.G_MISS_CHAR)

Line 375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)

371: ,p_directory_node_id => NVL(p_directory_node_id,FND_API.G_MISS_NUM)
372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)
376: ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)
377: ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)
378: ,p_translation_required_flag => NVL(p_translation_required_flag,FND_API.G_MISS_CHAR)
379: ,p_owner_resource_id => l_user_id

Line 376: ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)

372: ,p_parent_item_id => NVL(p_parent_item_id,FND_API.G_MISS_NUM)
373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)
376: ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)
377: ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)
378: ,p_translation_required_flag => NVL(p_translation_required_flag,FND_API.G_MISS_CHAR)
379: ,p_owner_resource_id => l_user_id
380: ,p_owner_resource_type => 'USER'

Line 377: ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)

373: ,p_live_citem_version_id => NVL(p_live_citem_version_id,FND_API.G_MISS_NUM)
374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)
376: ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)
377: ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)
378: ,p_translation_required_flag => NVL(p_translation_required_flag,FND_API.G_MISS_CHAR)
379: ,p_owner_resource_id => l_user_id
380: ,p_owner_resource_type => 'USER'
381: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)

Line 378: ,p_translation_required_flag => NVL(p_translation_required_flag,FND_API.G_MISS_CHAR)

374: ,p_content_item_status => NVL(p_content_item_status,FND_API.G_MISS_CHAR)
375: ,p_locked_by_user_id => NVL(p_locked_by_user_id,FND_API.G_MISS_NUM)
376: ,p_wd_restricted_flag => NVL(p_wd_restricted_flag,FND_API.G_MISS_CHAR)
377: ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)
378: ,p_translation_required_flag => NVL(p_translation_required_flag,FND_API.G_MISS_CHAR)
379: ,p_owner_resource_id => l_user_id
380: ,p_owner_resource_type => 'USER'
381: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)
382: ,p_last_updated_by => l_user_id

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

377: ,p_base_language => NVL(p_base_language,FND_API.G_MISS_CHAR)
378: ,p_translation_required_flag => NVL(p_translation_required_flag,FND_API.G_MISS_CHAR)
379: ,p_owner_resource_id => l_user_id
380: ,p_owner_resource_type => 'USER'
381: ,p_application_id => NVL(p_application_id,FND_API.G_MISS_NUM)
382: ,p_last_updated_by => l_user_id
383: ,p_last_update_date => l_last_update_date
384: ,p_last_update_login => 0
385: ,px_object_version_number => lx_object_version_number

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

382: ,p_last_updated_by => l_user_id
383: ,p_last_update_date => l_last_update_date
384: ,p_last_update_login => 0
385: ,px_object_version_number => lx_object_version_number
386: ,p_encrypt_flag => NVL(p_encrypt_flag,FND_API.G_MISS_CHAR)
387: );
388: END IF;
389: EXCEPTION
390: WHEN no_data_found THEN