[Home] [Help]
160: --
161: -- Prepare the Attribute Bundle if necessary.
162: IF p_def_disp_template_id IS NOT NULL
163: THEN
164: -- Call the procedure IBC_CITEM_ADMIN_GRP.set_citem_att_bundle.
165: -- prepare the data for insert.
166: --
167: l_attribute_type_codes.extend();
168: l_attribute_type_codes(1) := G_DEFAULT_DISPLAY_TEMPLATE; -- Should be a CONSTANT in package.
180:
181: -- Call the procedure upsert_item. This method allows creation of Content Item from one
182: -- single API.
183:
184: IBC_CITEM_ADMIN_GRP.upsert_item(
185: p_ctype_code => p_content_type_code
186: ,p_citem_name => l_delv_name
187: ,p_citem_description => substr(l_delv_desc,1,2000)
188: ,p_dir_node_id => G_AMS_DIR_NODE_ID
249:
250: l_assoc_objects5.extend();
251: l_assoc_objects5(1) := NULL ;
252:
253: -- Call the procedure IBC_CITEM_ADMIN_GRP.insert_associations.
254:
255: IBC_CITEM_ADMIN_GRP.insert_associations(
256: p_content_item_id => l_citem_id
257: ,p_assoc_type_codes => l_assoc_type_codes
251: l_assoc_objects5(1) := NULL ;
252:
253: -- Call the procedure IBC_CITEM_ADMIN_GRP.insert_associations.
254:
255: IBC_CITEM_ADMIN_GRP.insert_associations(
256: p_content_item_id => l_citem_id
257: ,p_assoc_type_codes => l_assoc_type_codes
258: ,p_assoc_objects1 => l_assoc_objects1
259: ,p_assoc_objects2 => l_assoc_objects2 -- Denormalized Value stored here. This can be debated. Remove if decided against storing it here.
295: IF g_using_locking = FND_API.g_true
296: THEN
297: --
298: -- At this stage we must UNLOCK this content item as we will soon commit this transaction.
299: -- Call the procedure IBC_CITEM_ADMIN_GRP.unlock_item
300: --
301: IBC_CITEM_ADMIN_GRP.unlock_item(
302: p_content_item_id => l_citem_id
303: ,p_commit => g_commit_on_lock_unlock
297: --
298: -- At this stage we must UNLOCK this content item as we will soon commit this transaction.
299: -- Call the procedure IBC_CITEM_ADMIN_GRP.unlock_item
300: --
301: IBC_CITEM_ADMIN_GRP.unlock_item(
302: p_content_item_id => l_citem_id
303: ,p_commit => g_commit_on_lock_unlock
304: ,p_api_version_number => p_api_version
305: ,p_init_msg_list => l_init_msg_list
550: IF g_using_locking = FND_API.g_true
551: THEN
552:
553: -- We have to lock the item first.
554: IBC_CITEM_ADMIN_GRP.lock_item(
555: p_content_item_id => p_citem_id
556: ,p_commit => g_commit_on_lock_unlock
557: ,p_api_version_number => p_api_version
558: ,p_init_msg_list => l_init_msg_list
580: FETCH c_max_version INTO l_citem_ver_id ;
581: CLOSE c_max_version ;
582:
583: -- We must also fetch the object version number.
584: l_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_citem_id );
585:
586: END IF;
587:
588: AMS_Utility_PVT.Debug_Message(' l_content_item_id = ' || l_content_item_id ) ;
638: FETCH c_max_version INTO l_cpnt_citem_ver_id ;
639: CLOSE c_max_version ;
640:
641: -- We must also fetch the object version number.
642: l_cpnt_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( l_content_item_id );
643:
644: --The line below does not work.
645: --The l_cpnt_attrib_types is un-initialized.
646: --Must check the original get_item from IBC API to see if that is working.
654: l_cpnt_obj_ver_num IS NOT NULL
655: THEN
656:
657: -- Approve this component.
658: IBC_CITEM_ADMIN_GRP.approve_item(
659: p_citem_ver_id => l_cpnt_citem_ver_id
660: ,p_commit => FND_API.g_false
661: ,p_api_version_number => p_api_version
662: ,p_init_msg_list => l_init_msg_list
678:
679: END IF ;
680:
681: -- Now approve the main parent component item.
682: IBC_CITEM_ADMIN_GRP.approve_item(
683: p_citem_ver_id => l_citem_ver_id
684: ,p_commit => FND_API.g_false
685: ,p_api_version_number => p_api_version
686: ,p_init_msg_list => l_init_msg_list
699: IF g_using_locking = FND_API.g_true
700: THEN
701:
702: -- unlock the content item.
703: IBC_CITEM_ADMIN_GRP.unlock_item(
704: p_content_item_id => p_citem_id
705: ,p_commit => g_commit_on_lock_unlock
706: ,p_api_version_number => p_api_version
707: ,p_init_msg_list => l_init_msg_list
1163: OPEN c_delv_details;
1164: FETCH c_delv_details INTO l_start_date, l_end_date;
1165: CLOSE c_delv_details;
1166:
1167: -- Call IBC_CITEM_ADMIN_GRP.upsert_item procedure.
1168:
1169: IBC_CITEM_ADMIN_GRP.upsert_item(
1170: p_ctype_code => p_content_type_code
1171: ,p_citem_name => p_content_item_name
1165: CLOSE c_delv_details;
1166:
1167: -- Call IBC_CITEM_ADMIN_GRP.upsert_item procedure.
1168:
1169: IBC_CITEM_ADMIN_GRP.upsert_item(
1170: p_ctype_code => p_content_type_code
1171: ,p_citem_name => p_content_item_name
1172: ,p_citem_description => substr(p_description,1,2000)
1173: ,p_dir_node_id => G_AMS_DIR_NODE_ID
1250: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1251: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1252: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1253:
1254: IBC_CITEM_ADMIN_GRP.insert_components(
1255: p_citem_ver_id => p_parent_citem_ver_id
1256: ,p_content_item_ids => l_citem_ids
1257: ,p_attribute_type_codes => l_citem_attrs
1258: ,p_sort_order => l_dummy_sort_order -- The NULL does not work. -- The new API is supposed to be able to take NULL for this parameter.
1275: IF g_using_locking = FND_API.g_true
1276: THEN
1277:
1278: -- At this stage we must UNLOCK this content item as we will soon commit this transaction.
1279: -- Call the procedure IBC_CITEM_ADMIN_GRP.unlock_content_item
1280: --
1281:
1282: IBC_CITEM_ADMIN_GRP.unlock_item(
1283: p_content_item_id => l_citem_id
1278: -- At this stage we must UNLOCK this content item as we will soon commit this transaction.
1279: -- Call the procedure IBC_CITEM_ADMIN_GRP.unlock_content_item
1280: --
1281:
1282: IBC_CITEM_ADMIN_GRP.unlock_item(
1283: p_content_item_id => l_citem_id
1284: ,p_commit => g_commit_on_lock_unlock
1285: ,p_api_version_number => p_api_version
1286: ,p_init_msg_list => l_init_msg_list
1566: OPEN c_delv_details;
1567: FETCH c_delv_details INTO l_start_date, l_end_date;
1568: CLOSE c_delv_details;
1569:
1570: -- Call IBC_CITEM_ADMIN_GRP.upsert_item procedure.
1571:
1572: IBC_CITEM_ADMIN_GRP.upsert_item(
1573: p_ctype_code => p_content_type_code
1574: ,p_citem_name => p_content_item_name
1568: CLOSE c_delv_details;
1569:
1570: -- Call IBC_CITEM_ADMIN_GRP.upsert_item procedure.
1571:
1572: IBC_CITEM_ADMIN_GRP.upsert_item(
1573: p_ctype_code => p_content_type_code
1574: ,p_citem_name => p_content_item_name
1575: ,p_citem_description => substr(p_description,1,2000)
1576: ,p_dir_node_id => G_AMS_DIR_NODE_ID
1644: AMS_Utility_PVT.Debug_Message( ' l_citem_attrs(1) = ' || l_citem_attrs(1) );
1645: AMS_Utility_PVT.Debug_Message( ' p_api_version = ' || p_api_version );
1646: AMS_Utility_PVT.Debug_Message( ' l_init_msg_list = ' || l_init_msg_list );
1647:
1648: IBC_CITEM_ADMIN_GRP.insert_components(
1649: p_citem_ver_id => p_parent_citem_ver_id
1650: ,p_content_item_ids => l_citem_ids
1651: ,p_attribute_type_codes => l_citem_attrs
1652: ,p_sort_order => l_dummy_sort_order -- The NULL does not work. -- The new API is supposed to be able to take NULL for this parameter.
1669: IF g_using_locking = FND_API.g_true
1670: THEN
1671:
1672: -- At this stage we must UNLOCK this content item as we will soon commit this transaction.
1673: -- Call the procedure IBC_CITEM_ADMIN_GRP.unlock_content_item
1674: --
1675:
1676: IBC_CITEM_ADMIN_GRP.unlock_item(
1677: p_content_item_id => l_citem_id
1672: -- At this stage we must UNLOCK this content item as we will soon commit this transaction.
1673: -- Call the procedure IBC_CITEM_ADMIN_GRP.unlock_content_item
1674: --
1675:
1676: IBC_CITEM_ADMIN_GRP.unlock_item(
1677: p_content_item_id => l_citem_id
1678: ,p_commit => g_commit_on_lock_unlock
1679: ,p_api_version_number => p_api_version
1680: ,p_init_msg_list => l_init_msg_list
1950: -- NOTES
1951: -- 1. The required input is as follows:
1952: -- content_item_id
1953: -- content_item_version_id
1954: -- 2. This procedure calls the get_citem from IBC_CITEM_ADMIN_GRP package.
1955: -- It only sends the useful data back to the caller.
1956: --
1957: -----------------------------------------------------------------------
1958: PROCEDURE get_content_item_data(
2039:
2040: --
2041: -- Call Get_item procedure.
2042:
2043: IBC_CITEM_ADMIN_GRP.get_item(
2044: p_citem_ver_id => p_citem_ver_id
2045: ,p_init_msg_list => FND_API.g_true
2046: ,p_api_version_number => p_api_version
2047: ,x_content_item_id => l_citem_id
2483:
2484: END LOOP;
2485: */
2486:
2487: IBC_CITEM_ADMIN_GRP.upsert_item(
2488: p_ctype_code => G_IBC_IMAGE
2489: ,p_citem_name => p_attach_file_name
2490: ,p_citem_description => p_attach_file_name -- Currently we do not expose the description on the UI, however the IBC_IMAGE type says that DESCRIPTION is a required field. So sending the file name as description.
2491: ,p_dir_node_id => G_AMS_DIR_NODE_ID
2536: l_init_msg_list := FND_API.g_false;
2537:
2538: -- Approve this content item of type IBC_IMAGE.
2539:
2540: IBC_CITEM_ADMIN_GRP.approve_item(
2541: p_citem_ver_id => l_image_citem_ver_id
2542: ,p_commit => FND_API.g_false
2543: ,p_api_version_number => p_api_version
2544: ,p_init_msg_list => l_init_msg_list
2585:
2586: -- Call the procedure upsert_item. This method allows creation of Content Item from one
2587: -- single API.
2588:
2589: IBC_CITEM_ADMIN_GRP.upsert_item(
2590: p_ctype_code => G_CP_IMAGE
2591: ,p_citem_name => p_content_item_name
2592: ,p_citem_description => NULL -- currently we do not expose the description on the UI.
2593: ,p_dir_node_id => G_AMS_DIR_NODE_ID
2661: AMS_UTILITY_PVT.debug_message('parent_ctype_code = ' || p_parent_ctype_code);
2662: AMS_UTILITY_PVT.debug_message('citem_attr = ' || l_citem_attrs(1));
2663: AMS_UTILITY_PVT.debug_message('citem_id = ' || l_citem_ids(1));
2664:
2665: IBC_CITEM_ADMIN_GRP.insert_components(
2666: p_citem_ver_id => p_parent_citem_ver_id
2667: ,p_content_item_ids => l_citem_ids
2668: ,p_attribute_type_codes => l_citem_attrs
2669: ,p_sort_order => l_dummy_sort_order -- The NULL does not work. -- The new API is supposed to be able to take NULL for this parameter.
2691:
2692: IF g_using_locking = FND_API.g_true
2693: THEN
2694:
2695: IBC_CITEM_ADMIN_GRP.unlock_item(
2696: p_content_item_id => l_image_citem_id
2697: ,p_commit => g_commit_on_lock_unlock
2698: ,p_api_version_number => p_api_version
2699: ,p_init_msg_list => l_init_msg_list
2718:
2719: IF g_using_locking = FND_API.g_true
2720: THEN
2721:
2722: IBC_CITEM_ADMIN_GRP.unlock_item(
2723: p_content_item_id => l_citem_id
2724: ,p_commit => g_commit_on_lock_unlock
2725: ,p_api_version_number => p_api_version
2726: ,p_init_msg_list => l_init_msg_list
2976:
2977: -- Call the procedure upsert_item. This method allows creation of Content Item from one
2978: -- single API.
2979:
2980: IBC_CITEM_ADMIN_GRP.upsert_item(
2981: p_ctype_code => G_IBC_IMAGE
2982: ,p_citem_name => p_attach_file_name
2983: ,p_citem_description => p_attach_file_name -- Currently we do not expose the description on the UI, however the IBC_IMAGE type says that DESCRIPTION is a required field. So sending the file name as description.
2984: ,p_dir_node_id => G_AMS_DIR_NODE_ID
3028: l_init_msg_list := FND_API.g_false;
3029:
3030: -- Approve this content item of type IBC_IMAGE.
3031:
3032: IBC_CITEM_ADMIN_GRP.approve_item(
3033: p_citem_ver_id => l_image_citem_ver_id
3034: ,p_commit => FND_API.g_false
3035: ,p_api_version_number => p_api_version
3036: ,p_init_msg_list => l_init_msg_list
3073: END IF;
3074:
3075: -- Update the CP_IMAGE item.
3076:
3077: -- Call the procedure IBC_CITEM_ADMIN_GRP.set_attribute_bundle.
3078:
3079: IF g_using_locking = FND_API.g_true
3080: THEN
3081:
3079: IF g_using_locking = FND_API.g_true
3080: THEN
3081:
3082: -- Note that we have to lock the item first.
3083: IBC_CITEM_ADMIN_GRP.lock_item(
3084: p_content_item_id => p_cp_image_citem_id
3085: ,p_commit => g_commit_on_lock_unlock
3086: ,p_api_version_number => p_api_version
3087: ,p_init_msg_list => l_init_msg_list
3106:
3107: ELSE
3108:
3109: -- We have to get the object version number separately as we are not using locking.
3110: l_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_cp_image_citem_id );
3111:
3112: END IF;
3113:
3114: AMS_Utility_PVT.Debug_Message(' CP IMage citem version id = ' || p_cp_image_citem_ver_id );
3113:
3114: AMS_Utility_PVT.Debug_Message(' CP IMage citem version id = ' || p_cp_image_citem_ver_id );
3115: AMS_Utility_PVT.Debug_Message(' obj ver num = ' || l_obj_ver_num );
3116:
3117: IBC_CITEM_ADMIN_GRP.set_attribute_bundle(
3118: p_citem_ver_id => p_cp_image_citem_ver_id
3119: ,p_attribute_type_codes => l_attribute_type_codes
3120: ,p_attributes => l_attributes -- This has the changed data if IMAGE was created.
3121: ,p_remove_old => FND_API.g_true -- The procedure sets the p_remove_old value to FND_API.g_true by default as well. Sending it in anyway.
3143:
3144: IF g_using_locking = FND_API.g_true
3145: THEN
3146:
3147: IBC_CITEM_ADMIN_GRP.unlock_item(
3148: p_content_item_id => l_image_citem_id
3149: ,p_commit => g_commit_on_lock_unlock
3150: ,p_api_version_number => p_api_version
3151: ,p_init_msg_list => l_init_msg_list
3170:
3171: IF g_using_locking = FND_API.g_true
3172: THEN
3173:
3174: IBC_CITEM_ADMIN_GRP.unlock_item(
3175: p_content_item_id => p_cp_image_citem_id
3176: ,p_commit => g_commit_on_lock_unlock
3177: ,p_api_version_number => p_api_version
3178: ,p_init_msg_list => l_init_msg_list
3245: -- PROCEDURE
3246: -- get_content_item_attrs
3247: --
3248: -- PURPOSE
3249: -- Wrapper on IBC_CITEM_ADMIN_GRP.get_attribute_bundle
3250: --
3251: -- NOTES
3252: -- 1. The required input is as follows:
3253: -- content_item_id
3252: -- 1. The required input is as follows:
3253: -- content_item_id
3254: -- content_type_code
3255: -- content_item_version_id
3256: -- 2. This procedure calls the get_attribute_bundle from IBC_CITEM_ADMIN_GRP package.
3257: -- It only sends the useful data back to the caller.
3258: --
3259: -----------------------------------------------------------------------
3260: PROCEDURE get_content_item_attrs(
3288: --
3289: x_return_status := FND_API.g_ret_sts_success;
3290: --
3291:
3292: IBC_CITEM_ADMIN_GRP.get_attribute_bundle(
3293: p_citem_ver_id => p_citem_ver_id
3294: ,p_init_msg_list => p_init_msg_list
3295: ,p_api_version_number => p_api_version
3296: ,x_attribute_type_codes => l_attribute_type_codes
3476: IF g_using_locking = FND_API.g_true
3477: THEN
3478:
3479: -- We have to lock the item first.
3480: IBC_CITEM_ADMIN_GRP.lock_item(
3481: p_content_item_id => p_citem_id
3482: ,p_commit => g_commit_on_lock_unlock
3483: ,p_api_version_number => p_api_version
3484: ,p_init_msg_list => l_init_msg_list
3503:
3504: ELSE
3505:
3506: -- We have to get the object version number separately as we are not using locking.
3507: l_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_citem_id );
3508:
3509: END IF;
3510:
3511: AMS_Utility_PVT.Debug_Message(' p_citem_version_id = ' || p_citem_version_id );
3630: l_attributes IS NOT NULL
3631: THEN
3632:
3633: -- Set the Attribute Bundle.
3634: IBC_CITEM_ADMIN_GRP.set_attribute_bundle(
3635: p_citem_ver_id => p_citem_version_id
3636: ,p_attribute_type_codes => l_attribute_type_codes
3637: ,p_attributes => l_attributes -- This has the changed data as needed.
3638: ,p_remove_old => FND_API.g_true -- The procedure sets the p_remove_old value to FND_API.g_true by default as well. Sending it in anyway.
3658: IF p_attach_file_id IS NOT NULL
3659: AND
3660: p_attach_file_name IS NOT NULL
3661: THEN
3662: -- Call the procedure IBC_CITEM_ADMIN_GRP.set_attachment.
3663:
3664: IBC_CITEM_ADMIN_GRP.set_attachment(
3665: p_citem_ver_id => p_citem_version_id
3666: ,p_attach_file_id => p_attach_file_id
3660: p_attach_file_name IS NOT NULL
3661: THEN
3662: -- Call the procedure IBC_CITEM_ADMIN_GRP.set_attachment.
3663:
3664: IBC_CITEM_ADMIN_GRP.set_attachment(
3665: p_citem_ver_id => p_citem_version_id
3666: ,p_attach_file_id => p_attach_file_id
3667: ,p_commit => FND_API.g_false -- This is the Default.
3668: ,p_api_version_number => p_api_version
3693: IF g_using_locking = FND_API.g_true
3694: THEN
3695:
3696: -- unlock the content item as the update was successful.
3697: IBC_CITEM_ADMIN_GRP.unlock_item(
3698: p_content_item_id => p_citem_id
3699: ,p_commit => g_commit_on_lock_unlock
3700: ,p_api_version_number => p_api_version
3701: ,p_init_msg_list => l_init_msg_list
3854: IF g_using_locking = FND_API.g_true
3855: THEN
3856:
3857: -- We have to lock the item first.
3858: IBC_CITEM_ADMIN_GRP.lock_item(
3859: p_content_item_id => p_citem_id
3860: ,p_commit => g_commit_on_lock_unlock
3861: ,p_api_version_number => p_api_version
3862: ,p_init_msg_list => l_init_msg_list
3882: FETCH c_max_version INTO l_citem_ver_id;
3883: CLOSE c_max_version;
3884:
3885: -- We must also fetch the object version number.
3886: l_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_citem_id );
3887:
3888: END IF;
3889:
3890: AMS_Utility_PVT.Debug_Message(' l_citem_ver_id = ' || l_citem_ver_id );
3947: IF g_using_locking = FND_API.g_true
3948: THEN
3949:
3950: -- unlock the content item.
3951: IBC_CITEM_ADMIN_GRP.unlock_item(
3952: p_content_item_id => p_citem_id
3953: ,p_commit => g_commit_on_lock_unlock
3954: ,p_api_version_number => p_api_version
3955: ,p_init_msg_list => l_init_msg_list
4134: l_attributes(2) := p_output_type;
4135: --
4136: -- Call upsert_item.
4137:
4138: -- Call IBC_CITEM_ADMIN_GRP.upsert_item procedure.
4139:
4140: IBC_CITEM_ADMIN_GRP.upsert_item(
4141: p_ctype_code => G_IBC_STYLESHEET
4142: ,p_citem_name => p_stylesheet_name
4136: -- Call upsert_item.
4137:
4138: -- Call IBC_CITEM_ADMIN_GRP.upsert_item procedure.
4139:
4140: IBC_CITEM_ADMIN_GRP.upsert_item(
4141: p_ctype_code => G_IBC_STYLESHEET
4142: ,p_citem_name => p_stylesheet_name
4143: ,p_citem_description => substr(p_stylesheet_descr,1,2000)
4144: ,p_dir_node_id => G_AMS_DIR_NODE_ID
4183: END IF;
4184:
4185: -- Approve the above item.
4186:
4187: IBC_CITEM_ADMIN_GRP.approve_item(
4188: p_citem_ver_id => l_citem_ver_id
4189: ,p_commit => FND_API.g_false
4190: ,p_api_version_number => p_api_version
4191: ,p_init_msg_list => l_init_msg_list
4204: IF g_using_locking = FND_API.g_true
4205: THEN
4206:
4207: -- Unlock the Item if success.
4208: IBC_CITEM_ADMIN_GRP.unlock_item(
4209: p_content_item_id => l_citem_id
4210: ,p_commit => g_commit_on_lock_unlock
4211: ,p_api_version_number => p_api_version
4212: ,p_init_msg_list => l_init_msg_list
4435: --
4436: -- Create a new Content Item in IBC Schema for incoming Content Type.
4437: -- Call upsert_item.
4438:
4439: IBC_CITEM_ADMIN_GRP.upsert_item(
4440: p_ctype_code => G_QUESTIONS
4441: ,p_citem_name => p_content_item_name
4442: ,p_citem_description => NULL -- We do not expose the description in the UI for now.
4443: ,p_dir_node_id => G_AMS_DIR_NODE_ID
4498: l_dummy_sort_order.extend();
4499: l_dummy_sort_order(1) := 1;
4500: --
4501:
4502: IBC_CITEM_ADMIN_GRP.insert_components(
4503: p_citem_ver_id => p_parent_citem_ver_id
4504: ,p_content_item_ids => l_citem_ids
4505: ,p_attribute_type_codes => l_citem_attrs
4506: ,p_sort_order => l_dummy_sort_order -- The NULL does not work. -- The new API is supposed to be able to take NULL for this parameter.
4525: THEN
4526:
4527: -- Unlock the content item.
4528:
4529: IBC_CITEM_ADMIN_GRP.unlock_item(
4530: p_content_item_id => l_citem_id
4531: ,p_commit => g_commit_on_lock_unlock
4532: ,p_api_version_number => p_api_version
4533: ,p_init_msg_list => l_init_msg_list
5109: --
5110: -- Create a new Content Item in IBC Schema for incoming Content Type.
5111: -- Call upsert_item.
5112:
5113: IBC_CITEM_ADMIN_GRP.upsert_item(
5114: p_ctype_code => G_SUBMIT_SECTION
5115: ,p_citem_name => p_content_item_name
5116: ,p_citem_description => NULL -- We do not expose the description in the UI for now.
5117: ,p_dir_node_id => G_AMS_DIR_NODE_ID
5177: THEN
5178:
5179: -- We need to lock the content item before we can add components to it.
5180:
5181: IBC_CITEM_ADMIN_GRP.lock_item(
5182: p_content_item_id => p_parent_citem_id
5183: ,p_commit => g_commit_on_lock_unlock
5184: ,p_api_version_number => p_api_version
5185: ,p_init_msg_list => l_init_msg_list
5204:
5205: ELSE
5206:
5207: -- We have to get the object version number separately as we are not using locking.
5208: l_parent_obj_ver_num := IBC_CITEM_ADMIN_GRP.getObjVerNum( p_parent_citem_id );
5209:
5210: END IF;
5211:
5212: AMS_Utility_PVT.Debug_Message(' p_parent_citem_ver_id = ' || p_parent_citem_ver_id );
5217: -- If we use locking, the parent content item and the children content items
5218: -- must all be locked by the same user in order to get the insert_components
5219: -- work correctly.
5220:
5221: IBC_CITEM_ADMIN_GRP.insert_components(
5222: p_citem_ver_id => p_parent_citem_ver_id
5223: ,p_content_item_ids => l_citem_ids
5224: ,p_attribute_type_codes => l_citem_attrs
5225: ,p_sort_order => l_dummy_sort_order -- The NULL does not work. -- The new API is supposed to be able to take NULL for this parameter.
5241: THEN
5242:
5243: -- Unlock the parent content item.
5244:
5245: IBC_CITEM_ADMIN_GRP.unlock_item(
5246: p_content_item_id => p_parent_citem_id
5247: ,p_commit => g_commit_on_lock_unlock
5248: ,p_api_version_number => p_api_version
5249: ,p_init_msg_list => l_init_msg_list
5269: IF g_using_locking = FND_API.g_true
5270: THEN
5271:
5272: -- Unlock the Submit Section content item.
5273: IBC_CITEM_ADMIN_GRP.unlock_item(
5274: p_content_item_id => l_citem_id
5275: ,p_commit => g_commit_on_lock_unlock
5276: ,p_api_version_number => p_api_version
5277: ,p_init_msg_list => l_init_msg_list