[Home] [Help]
1038: AND
1039: p_data_source_list(1) IS NOT NULL
1040: THEN
1041:
1042: -- We also have to update the ams_list_src_type_usages table.
1043: -- For CREATE, we have to insert the record in the above table.
1044: -- For UPDATE, we have to update the record in the above table.
1045: -- To be coded when the APIs for ams_list_src_type_usages are available.
1046:
1041:
1042: -- We also have to update the ams_list_src_type_usages table.
1043: -- For CREATE, we have to insert the record in the above table.
1044: -- For UPDATE, we have to update the record in the above table.
1045: -- To be coded when the APIs for ams_list_src_type_usages are available.
1046:
1047: -- The data source list is not null.
1048: -- Currently we support only one data source per rich content.
1049: l_attr_count := l_attr_count + 1;
1132:
1133: ELSE
1134:
1135: -- If this is an update call, check if there was a data source associated
1136: -- with this content item and delete that record from the ams_list_src_type_usages
1137: -- table.
1138: -- To be coded when the APIs for ams_list_src_type_usages are available.
1139:
1140: null;
1134:
1135: -- If this is an update call, check if there was a data source associated
1136: -- with this content item and delete that record from the ams_list_src_type_usages
1137: -- table.
1138: -- To be coded when the APIs for ams_list_src_type_usages are available.
1139:
1140: null;
1141:
1142: END IF;
5679: AND ques.content_item_id = p_section_citem_id ;
5680: --
5681: CURSOR c_data_src_usage_count IS
5682: SELECT count(1)
5683: FROM ams_list_src_type_usages
5684: WHERE list_src_used_by_type = 'CPAGE'
5685: AND list_src_used_by_id = p_section_citem_id ;
5686:
5687: l_data_src_usage_count NUMBER ;
6027: UPDATE ibc_citem_versions_tl
6028: SET attachment_attribute_code = 'QUESTIONS_XML' -- hardcoding as QUESTIONS_XML for Questions Section.
6029: WHERE citem_version_id = l_section_citem_ver_id ;
6030:
6031: -- Delete all the records from ams_list_src_type_usages for this content item
6032:
6033: OPEN c_data_src_usage_count ;
6034: FETCH c_data_src_usage_count INTO l_data_src_usage_count ;
6035: CLOSE c_data_src_usage_count ;
6037: AMS_UTILITY_PVT.debug_message( ' l_data_src_usage_count = ' || l_data_src_usage_count );
6038:
6039: IF l_data_src_usage_count > 0
6040: THEN
6041: DELETE FROM ams_list_src_type_usages
6042: WHERE list_src_used_by_type = 'CPAGE'
6043: AND list_src_used_by_id = p_section_citem_id;
6044: END IF;
6045:
6044: END IF;
6045:
6046: AMS_UTILITY_PVT.debug_message( ' l_data_src_usage_count = ' || l_data_src_usage_count );
6047:
6048: -- Insert into ams_list_src_type_usages the usage record for all the Data Sources
6049: -- being used by this content item.
6050:
6051: IF l_data_src_cnt > 0
6052: THEN
6058: l_data_src_type_code := l_data_src_type_codes(i);
6059:
6060: AMS_UTILITY_PVT.debug_message( ' Adding usage record for : l_data_src_type_code = ' || l_data_src_type_code );
6061:
6062: INSERT INTO ams_list_src_type_usages
6063: (
6064: list_source_type_usage_id
6065: ,last_update_date
6066: ,last_updated_by
6073: ,list_src_used_by_type
6074: ,list_src_used_by_id
6075: )
6076: select
6077: ams_list_src_type_usages_s.NEXTVAL,
6078: SYSDATE,
6079: FND_GLOBAL.USER_ID,
6080: SYSDATE,
6081: FND_GLOBAL.USER_ID,
6081: FND_GLOBAL.USER_ID,
6082: FND_GLOBAL.CONC_LOGIN_ID,
6083: 1,
6084: substr(l_data_src_type_code, 1, 30),
6085: 0, -- sending list_header_id as 0. -- The index AMS.AMS_LIST_SRC_TYPE_USAGES_U2 has to be dropped from the ODF for this to work correctly.
6086: 'CPAGE',
6087: p_section_citem_id
6088: from dual
6089: where not exists
6087: p_section_citem_id
6088: from dual
6089: where not exists
6090: ( select 'x'
6091: from ams_list_src_type_usages
6092: where list_header_id = 0
6093: and source_type_code = l_data_src_type_code
6094: and list_src_used_by_type = 'CPAGE'
6095: and list_src_used_by_id = p_section_citem_id