44:
45: fnd_msg_pub.initialize;
46:
47: begin
48: select BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE) into l_type
49: from fnd_form_functions
50: where function_name = p_page_function_name;
51: exception
52: when no_data_found then l_type := null;
243:
244: select parameters into l_parameters from fnd_form_functions
245: where function_id = p_page_id;
246:
247: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || l_new_internal_name);
248:
249: if l_new_internal_name <> p_internal_name then
250: UPDATE fnd_form_functions
251: SET function_name = l_new_internal_name
909: select lower(application_short_name) into l_app_short_name
910: from fnd_application
911: where application_id = p_application_id;
912:
913: l_menu_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, c_PAGE_NAME);
914:
915: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || p_internal_name);
916: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_SOURCE_TYPE, c_MDS);
917: -- This is put back just in case you need to go back to the FND_MENU
911: where application_id = p_application_id;
912:
913: l_menu_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, c_PAGE_NAME);
914:
915: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || p_internal_name);
916: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_SOURCE_TYPE, c_MDS);
917: -- This is put back just in case you need to go back to the FND_MENU
918: -- Will be added only for migrated functions.
919: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_MENU_NAME, l_menu_name);
912:
913: l_menu_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, c_PAGE_NAME);
914:
915: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || p_internal_name);
916: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_SOURCE_TYPE, c_MDS);
917: -- This is put back just in case you need to go back to the FND_MENU
918: -- Will be added only for migrated functions.
919: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_MENU_NAME, l_menu_name);
920:
915: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || p_internal_name);
916: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_SOURCE_TYPE, c_MDS);
917: -- This is put back just in case you need to go back to the FND_MENU
918: -- Will be added only for migrated functions.
919: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_MENU_NAME, l_menu_name);
920:
921: -- Update Form Function
922: BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW (
923: p_FUNCTION_ID => l_function_id,
1068: begin
1069: fnd_msg_pub.initialize;
1070:
1071: begin
1072: select BIS_COMMON_UTILS.getParameterValue(parameters, c_SOURCE_TYPE),
1073: function_id,
1074: parameters
1075: into l_type, l_function_id, l_parameters
1076: from fnd_form_functions
1095: from fnd_application
1096: where application_id = l_application_id;
1097:
1098: if (l_type = c_FND_MENU) then
1099: l_menu_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, c_PAGE_NAME);
1100: -- This is put back just in case you need to go back to the FND_MENU
1101: -- Will be added only for migrated functions.
1102: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_MENU_NAME, l_menu_name);
1103: end if;
1098: if (l_type = c_FND_MENU) then
1099: l_menu_name := BIS_COMMON_UTILS.getParameterValue(l_parameters, c_PAGE_NAME);
1100: -- This is put back just in case you need to go back to the FND_MENU
1101: -- Will be added only for migrated functions.
1102: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_MENU_NAME, l_menu_name);
1103: end if;
1104:
1105: if p_new_page_xml_name is null then
1106: l_page_xml_name := p_page_xml_name;
1107: else
1108: l_page_xml_name := p_new_page_xml_name;
1109: end if;
1110:
1111: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || l_page_xml_name);
1112: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_SOURCE_TYPE, c_MDS);
1113:
1114: -- Update form function
1115: if l_page_function_name <> p_page_function_name then
1108: l_page_xml_name := p_new_page_xml_name;
1109: end if;
1110:
1111: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_PAGE_NAME, c_MDS_PATH_PRE || l_app_short_name || c_MDS_PATH_POST || l_page_xml_name);
1112: l_parameters := BIS_COMMON_UTILS.replaceParameterValue(l_parameters, c_SOURCE_TYPE, c_MDS);
1113:
1114: -- Update form function
1115: if l_page_function_name <> p_page_function_name then
1116: -- Check if new function already exists.
1178: INTO l_custom_view_name,l_parameters
1179: FROM fnd_form_functions_vl
1180: WHERE function_id = p_Function_Id;
1181:
1182: l_tab_id := BIS_COMMON_UTILS.getParameterValue(l_parameters,'pTabId');
1183: IF(l_tab_id IS NOT NULL) THEN
1184: SELECT name
1185: INTO l_tab_name
1186: FROM bsc_tabs_vl
1217:
1218: l_return_value := BIS_PAGE_PUB.c_NON_SIMULATABLE;
1219:
1220: IF(p_parameters IS NOT NULL) THEN
1221: l_region_Code := BIS_COMMON_UTILS.getParameterValue(p_parameters,'pRegionCode');
1222:
1223: IF(l_region_Code IS NOT NULL)THEN
1224: l_return_value := BIS_PAGE_PUB.c_SIMULATABLE;
1225: ELSE