[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
IS SELECT
b.level_id,
b.level_value,
b.level_value_application_id,
b.profile_option_value
FROM fnd_profile_options a, fnd_profile_option_values b
where a.profile_option_name = p_profile_option_name
and a.profile_option_id = b.profile_option_id
and a.application_id = b.application_id
order by b.level_id;
IS SELECT count(*)
FROM fnd_profile_options a
WHERE a.profile_option_name in (p_profile_option_name);
* Compare values for the IBU_A_SR_PRODUCT_SELECTION_OPTION profile
* Oracle iSupport: Enforce Product Selection Option
*/
FUNCTION Eval_SR_Product_Selection (p_appl_index IN OUT NOCOPY NUMBER,
p_applTable IN OUT NOCOPY ApplTable,
p_resp_index IN OUT NOCOPY NUMBER,
p_respTable IN OUT NOCOPY RespTable,
p_site_index IN OUT NOCOPY NUMBER,
p_siteProfilesTable IN OUT NOCOPY ProfileTable)
RETURN BOOLEAN
IS
l_profile_option_id FND_PROFILE_OPTION_VALUES.profile_option_id%TYPE := 0;
OPEN get_profile_option_values('IBU_A_SR_PRODUCT_SELECTION_OPTION');
log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'appl level value customized. Profile option value: ' || l_profile_option_value);
log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'Application Id: ' || to_char(l_level_value));
log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection', 'resp level value customized. Profile option value: ' || l_profile_option_value);
log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection','Resp id: ' || to_char(l_level_value) || ' Resp Appl Id: ' || to_char(l_level_value_appl_id));
log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Eval_SR_Product_Selection','Exception in Eval_SR_Product_Selection');
END Eval_SR_Product_Selection;
* This procedure inserts a new row into CS_CF_SOURCE_CONTEXT_TARGETS
* table for the newly cloned regions
*/
PROCEDURE Insert_New_Target(p_sourceCode IN VARCHAR2,
p_contextType IN VARCHAR2,
p_contextValue1 IN VARCHAR2,
p_contextValue2 IN VARCHAR2,
p_seedTargetValue1 IN VARCHAR2,
p_seedTargetValue2 IN VARCHAR2,
p_custTargetValue1 IN VARCHAR2,
p_custTargetValue2 IN VARCHAR2)
IS
no_row_found EXCEPTION;
u_last_updated_by NUMBER := 0;
u_last_update_date DATE;
u_last_update_login NUMBER := 0;
SELECT source_context_type_id
FROM CS_CF_SOURCE_CXT_TYPES
WHERE SOURCE_CODE = p_sourceCode
AND CONTEXT_TYPE = p_contextType;
SELECT count(*)
FROM CS_CF_SOURCE_CXT_TARGETS
WHERE source_context_type_id = p_contextTypeId
AND context_value1 = p_contextValue1
AND context_value2 = p_contextValue2;
SELECT count(*)
FROM CS_CF_SOURCE_CXT_TARGETS
WHERE source_context_type_id = p_contextTypeId
AND context_value1 = p_contextValue1;
SELECT count(*)
FROM CS_CF_SOURCE_CXT_TARGETS
WHERE source_context_type_id = p_contextTypeId;
SELECT source_context_target_id,
context_value1,
context_value2,
context_value3,
context_value4,
context_value5,
object_version_number,
seed_target_value1,
seed_target_value2,
cust_target_value1,
cust_target_value2,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
additional_info1,
additional_info2,
additional_info3,
additional_info4,
additional_info5,
additional_info6,
additional_info7,
additional_info8,
additional_info9,
additional_info10,
additional_info11,
additional_info12,
additional_info13,
additional_info14,
additional_info15
FROM CS_CF_SOURCE_CXT_TARGETS
WHERE source_context_type_id = p_contextTypeId;
log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Called Inserting new target row for sourceCode: ' || p_sourceCode || ' contextType: ' || p_contextType);
u_last_updated_by,
u_last_update_date,
u_last_update_login,
u_attribute_category,
u_attribute1,
u_attribute2,
u_attribute3,
u_attribute4,
u_attribute5,
u_attribute6,
u_attribute7,
u_attribute8,
u_attribute9,
u_attribute10,
u_attribute11,
u_attribute12,
u_attribute13,
u_attribute14,
u_attribute15,
u_additional_info1,
u_additional_info2,
u_additional_info3,
u_additional_info4,
u_additional_info5,
u_additional_info6,
u_additional_info7,
u_additional_info8,
u_additional_info9,
u_additional_info10,
u_additional_info11,
u_additional_info12,
u_additional_info13,
u_additional_info14,
u_additional_info15;
log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Global context: last_updated_by:' || u_last_updated_by || 'created_by:' || u_created_by);
SELECT cs_cf_source_cxt_targets_s.nextval
INTO l_source_context_target_id
FROM dual;
log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Inserting new target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);
log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );
CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(
X_ROWID => l_rowid,
X_SOURCE_CONTEXT_TARGET_ID => l_source_context_target_id,
X_SOURCE_CONTEXT_TYPE_ID => l_source_context_type_id,
X_CONTEXT_VALUE1 => p_contextValue1,
X_CONTEXT_VALUE2 => p_contextValue2,
X_CONTEXT_VALUE3 => NULL,
X_CONTEXT_VALUE4 => NULL,
X_CONTEXT_VALUE5 => NULL,
X_SEED_TARGET_VALUE1 => p_seedTargetValue1,
X_SEED_TARGET_VALUE2 => p_seedTargetValue2,
X_CUST_TARGET_VALUE1 => p_custTargetValue1,
X_CUST_TARGET_VALUE2 => p_custTargetValue2,
X_OBJECT_VERSION_NUMBER => 1,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL,
X_ADDITIONAL_INFO1 => NULL,
X_ADDITIONAL_INFO2 => NULL,
X_ADDITIONAL_INFO3 => NULL,
X_ADDITIONAL_INFO4 => NULL,
X_ADDITIONAL_INFO5 => NULL,
X_ADDITIONAL_INFO6 => NULL,
X_ADDITIONAL_INFO7 => NULL,
X_ADDITIONAL_INFO8 => NULL,
X_ADDITIONAL_INFO9 => NULL,
X_ADDITIONAL_INFO10 => NULL,
x_ADDITIONAL_INFO11 => NULL,
X_ADDITIONAL_INFO12 => NULL,
X_ADDITIONAL_INFO13 => NULL,
X_ADDITIONAL_INFO14 => NULL,
X_ADDITIONAL_INFO15 => NULL,
X_CREATION_DATE => sysdate,
X_CREATED_BY => l_created_by,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => l_created_by,
X_LAST_UPDATE_LOGIN => 0);
ELSIF (p_contextType = 'GLOBAL' AND (l_count > 0 AND ((u_last_updated_by = u_created_by) OR (u_last_updated_by = -1)))) THEN
-- mkcyee 12/09/2004
-- Update the existing row in place. This is a special
-- case for global regions because there will already be an existing
-- row present after installation.
-- We also keep the last_update_date to be the same because
-- we want future ldt changes to overwrite this row.
log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Updating target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);
log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );
CS_CF_SOURCE_CXT_TARGETS_PKG.UPDATE_ROW(
X_SOURCE_CONTEXT_TARGET_ID => u_source_context_target_id,
X_SOURCE_CONTEXT_TYPE_ID => l_source_context_type_id,
X_CONTEXT_VALUE1 => u_context_value1,
X_CONTEXT_VALUE2 => u_context_value2,
X_CONTEXT_VALUE3 => u_context_value3,
X_CONTEXT_VALUE4 => u_context_value4,
X_CONTEXT_VALUE5 => u_context_value5,
X_SEED_TARGET_VALUE1 => u_seed_target_value1,
X_SEED_TARGET_VALUE2 => u_seed_target_value2,
X_CUST_TARGET_VALUE1 => p_custTargetValue1,
X_CUST_TARGET_VALUE2 => p_custTargetValue2,
X_OBJECT_VERSION_NUMBER => u_object_version_number+1,
X_LAST_UPDATE_DATE => u_last_update_date,
X_LAST_UPDATED_BY => u_last_updated_by,
X_LAST_UPDATE_LOGIN => u_last_update_login,
X_ATTRIBUTE_CATEGORY => u_attribute_category,
X_ATTRIBUTE1 => u_attribute1,
X_ATTRIBUTE2 => u_attribute2,
X_ATTRIBUTE3 => u_attribute3,
X_ATTRIBUTE4 => u_attribute4,
X_ATTRIBUTE5 => u_attribute5,
X_ATTRIBUTE6 => u_attribute6,
X_ATTRIBUTE7 => u_attribute7,
X_ATTRIBUTE8 => u_attribute8,
X_ATTRIBUTE9 => u_attribute9,
X_ATTRIBUTE10 => u_attribute10,
X_ATTRIBUTE11 => u_attribute11,
X_ATTRIBUTE12 => u_attribute12,
X_ATTRIBUTE13 => u_attribute13,
X_ATTRIBUTE14 => u_attribute14,
X_ATTRIBUTE15 => u_attribute15,
X_ADDITIONAL_INFO1 => u_additional_info1,
X_ADDITIONAL_INFO2 => u_additional_info2,
X_ADDITIONAL_INFO3 => u_additional_info3,
X_ADDITIONAL_INFO4 => u_additional_info4,
X_ADDITIONAL_INFO5 => u_additional_info5,
X_ADDITIONAL_INFO6 => u_additional_info6,
X_ADDITIONAL_INFO7 => u_additional_info7,
X_ADDITIONAL_INFO8 => u_additional_info8,
X_ADDITIONAL_INFO9 => u_additional_info9,
X_ADDITIONAL_INFO10 => u_additional_info10,
X_ADDITIONAL_INFO11 => u_additional_info11,
X_ADDITIONAL_INFO12 => u_additional_info12,
X_ADDITIONAL_INFO13 => u_additional_info13,
X_ADDITIONAL_INFO14 => u_additional_info14,
X_ADDITIONAL_INFO15 => u_additional_info15);
log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Unexpected error: There should be at least one entry at the global level for source code ' || p_sourceCode);
log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UPG_UTL_PKG:Insert_New_Target', 'Exception for sourceCode: ' || p_sourceCode || 'contextType: ' || p_contextType);
END Insert_New_Target;
SELECT *
FROM ak_regions
WHERE region_code = p_csr_code
AND region_application_id = p_csr_id;
SELECT count(*)
FROM ak_regions
where region_code = p_region_code
AND region_application_id = p_region_application_id;
AK_REGIONS_PKG.Update_Row(X_REGION_APPLICATION_ID => r_rec.region_application_id,
X_REGION_CODE => r_rec.region_code,
X_DATABASE_OBJECT_NAME => r_rec.database_object_name,
X_REGION_STYLE => r_rec.region_style,
X_NUM_COLUMNS => r_rec.num_columns,
X_ICX_CUSTOM_CALL => r_rec.icx_custom_call,
X_NAME => p_newRegionCode,
X_DESCRIPTION => '',
X_REGION_DEFAULTING_API_PKG => r_rec.region_defaulting_api_pkg,
X_REGION_DEFAULTING_API_PROC => r_rec.region_defaulting_api_proc,
X_REGION_VALIDATION_API_PKG => r_rec.region_validation_api_pkg,
X_REGION_VALIDATION_API_PROC => r_rec.region_validation_api_proc,
X_APPL_MODULE_OBJECT_TYPE => r_rec.applicationmodule_object_type,
X_NUM_ROWS_DISPLAY => r_rec.num_rows_display,
X_REGION_OBJECT_TYPE => r_rec.region_object_type,
X_IMAGE_FILE_NAME => r_rec.image_file_name,
X_ISFORM_FLAG => r_rec.isform_flag,
X_HELP_TARGET => r_rec.help_target,
X_STYLE_SHEET_FILENAME => r_rec.style_sheet_filename,
X_VERSION => r_rec.version,
X_APPLICATIONMODULE_USAGE_NAME => r_rec.applicationmodule_usage_name,
X_ADD_INDEXED_CHILDREN => r_rec.add_indexed_children,
X_STATEFUL_FLAG => r_rec.stateful_flag,
X_FUNCTION_NAME => r_rec.function_name,
X_CHILDREN_VIEW_USAGE_NAME => r_rec.children_view_usage_name,
X_SEARCH_PANEL => r_rec.search_panel,
X_ADVANCED_SEARCH_PANEL => r_rec.advanced_search_panel,
X_CUSTOMIZE_PANEL => r_rec.customize_panel,
X_DEFAULT_SEARCH_PANEL => r_rec.default_search_panel,
X_RESULTS_BASED_SEARCH => r_rec.results_based_search,
X_DISPLAY_GRAPH_TABLE => r_rec.display_graph_table,
X_DISABLE_HEADER => r_rec.disable_header,
X_STANDALONE => r_rec.standalone,
X_AUTO_CUSTOMIZATION_CRITERIA => r_rec.auto_customization_criteria,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => r_rec.last_updated_by,
X_LAST_UPDATE_LOGIN => r_rec.last_update_login,
X_ATTRIBUTE_CATEGORY => r_rec.attribute_category,
X_ATTRIBUTE1 => r_rec.attribute1,
X_ATTRIBUTE2 => r_rec.attribute2,
X_ATTRIBUTE3 => r_rec.attribute3,
X_ATTRIBUTE4 => r_rec.attribute4,
X_ATTRIBUTE5 => r_rec.attribute5,
X_ATTRIBUTE6 => r_rec.attribute6,
X_ATTRIBUTE7 => r_rec.attribute7,
X_ATTRIBUTE8 => r_rec.attribute8,
X_ATTRIBUTE9 => r_rec.attribute9,
X_ATTRIBUTE10 => r_rec.attribute10,
X_ATTRIBUTE11 => r_rec.attribute11,
X_ATTRIBUTE12 => r_rec.attribute12,
X_ATTRIBUTE13 => r_rec.attribute13,
X_ATTRIBUTE14 => r_rec.attribute14,
X_ATTRIBUTE15 => r_rec.attribute15);
* Updates the actual region items in the region
* Assumes all regions and attributes are defined
* under 672.
*/
PROCEDURE UpdateRegionItems(p_regionCode IN VARCHAR2,
p_attributeCode IN VARCHAR2,
p_displayFlag IN VARCHAR2,
p_mandatoryFlag IN VARCHAR2,
p_subRegionCode IN VARCHAR2)
IS
l_displaySequence NUMBER;
l_updateFlag VARCHAR2(1);
SELECT a.display_sequence,
a.node_query_flag,
a.attribute_label_length,
a.bold,
a.italic,
a.vertical_alignment,
a.horizontal_alignment,
a.item_style,
a.object_attribute_flag,
b.attribute_label_long,
b.description,
a.security_code,
a.update_flag,
a.required_flag,
a.display_value_length,
a.lov_region_application_id,
a.lov_region_code,
a.lov_foreign_key_name,
a.lov_attribute_application_id,
a.lov_attribute_code,
a.lov_default_flag,
a.region_defaulting_api_pkg,
a.region_defaulting_api_proc,
a.region_validation_api_pkg,
a.region_validation_api_proc,
a.order_sequence,
a.order_direction,
a.default_value_varchar2,
a.default_value_number,
a.default_value_date,
a.item_name,
a.display_height,
a.submit,
a.encrypt,
a.view_usage_name,
a.view_attribute_name,
a.css_class_name,
a.css_label_class_name,
a.url,
a.poplist_viewobject,
a.poplist_display_attribute,
a.poplist_value_attribute,
a.image_file_name,
a.nested_region_application_id,
a.nested_region_code,
a.menu_name,
a.flexfield_name,
a.flexfield_application_id,
a.tabular_function_code,
a.tip_type,
a.tip_message_name,
a.tip_message_application_id,
a.flex_segment_list,
a.entity_id,
a.anchor,
a.poplist_view_usage_name,
a.attribute_category,
a.attribute1,
a.attribute2,
a.attribute3,
a.attribute4,
a.attribute5,
a.attribute6,
a.attribute7,
a.attribute8,
a.attribute9,
a.attribute10,
a.attribute11,
a.attribute12,
a.attribute13,
a.attribute14,
a.attribute15
INTO
l_displaySequence,
l_nodeQueryFlag,
l_attributeLabelLength,
l_bold,
l_italic,
l_verticalAlignment,
l_horizontalAlignment,
l_itemStyle,
l_objectAttributeFlag,
l_attributeLabelLong,
l_description,
l_securityCode,
l_updateFlag,
l_requiredFlag,
l_displayValueLength,
l_lovRegionApplicationId,
l_lovRegionCode,
l_lovForeignKeyName,
l_lovAttributeApplicationId,
l_lovAttributeCode,
l_lovDefaultFlag,
l_regionDefaultingApiPkg,
l_regionDefaultingApiProc,
l_regionValidationApiPkg,
l_regionValidationApiProc,
l_orderSequence,
l_orderDirection,
l_defaultValueVarchar2,
l_defaultValueNumber,
l_defaultValueDate,
l_itemName,
l_displayHeight,
l_submit,
l_encrypt,
l_viewUsageName,
l_viewAttributeName,
l_cssClassName,
l_cssLabelClassName,
l_url,
l_poplistViewObject,
l_poplistDisplayAttribute,
l_poplistValueAttribute,
l_imageFileName,
l_nestedRegionApplId,
l_nestedRegionCode,
l_menuName,
l_flexfieldName,
l_flexfieldApplicationId,
l_tabularFunctionCode,
l_tipType,
l_tipTypeMessageName,
l_tipMessageApplicationId,
l_flexSegmentList,
l_entityId,
l_anchor,
l_poplistViewUsageName,
l_attributeCategory,
l_attribute1,
l_attribute2,
l_attribute3,
l_attribute4,
l_attribute5,
l_attribute6,
l_attribute7,
l_attribute8,
l_attribute9,
l_attribute10,
l_attribute11,
l_attribute12,
l_attribute13,
l_attribute14,
l_attribute15
FROM ak_region_items a,
ak_region_items_tl b
WHERE a.region_code = b.region_code
AND a.region_application_id = b.region_application_id
AND a.attribute_code = b.attribute_code
AND a.attribute_application_id = b.attribute_application_id
AND b.language = USERENV('LANG')
AND a.region_code = p_regionCode
AND a.region_application_id = 672
AND a.attribute_code = p_attributeCode
and a.attribute_application_id = 672
FOR UPDATE NOWAIT;
AK_REGION_ITEMS_PKG.UPDATE_ROW(
X_REGION_APPLICATION_ID => 672,
X_REGION_CODE => p_regionCode,
X_ATTRIBUTE_APPLICATION_ID => 672,
X_ATTRIBUTE_CODE => p_attributeCode,
X_DISPLAY_SEQUENCE => l_displaySequence,
X_NODE_DISPLAY_FLAG => p_displayFlag,
X_NODE_QUERY_FLAG => l_nodeQueryFlag,
X_ATTRIBUTE_LABEL_LENGTH => l_attributeLabelLength,
X_BOLD => l_bold,
X_ITALIC => l_italic,
X_VERTICAL_ALIGNMENT => l_verticalAlignment,
X_HORIZONTAL_ALIGNMENT => l_horizontalAlignment,
X_ITEM_STYLE => l_itemStyle,
X_OBJECT_ATTRIBUTE_FLAG => l_objectAttributeFlag,
X_ATTRIBUTE_LABEL_LONG => l_attributeLabelLong,
X_DESCRIPTION => l_description,
X_SECURITY_CODE => l_securityCode,
X_UPDATE_FLAG => l_updateFlag,
X_REQUIRED_FLAG => p_mandatoryFlag,
X_DISPLAY_VALUE_LENGTH => l_displayValueLength,
X_LOV_REGION_APPLICATION_ID => l_lovRegionApplicationId,
X_LOV_REGION_CODE => l_lovRegionCode,
X_LOV_FOREIGN_KEY_NAME => l_lovForeignKeyName,
X_LOV_ATTRIBUTE_APPLICATION_ID => l_lovAttributeApplicationId,
X_LOV_ATTRIBUTE_CODE => l_lovAttributeCode,
X_LOV_DEFAULT_FLAG => l_lovDefaultFlag,
X_REGION_DEFAULTING_API_PKG => l_regionDefaultingApiPkg,
X_REGION_DEFAULTING_API_PROC => l_regionDefaultingApiProc,
X_REGION_VALIDATION_API_PKG => l_regionValidationApiPkg,
X_REGION_VALIDATION_API_PROC => l_regionValidationApiProc,
X_ORDER_SEQUENCE => l_orderSequence,
X_ORDER_DIRECTION => l_orderDirection,
X_DEFAULT_VALUE_VARCHAR2 => l_defaultValueVarchar2,
X_DEFAULT_VALUE_NUMBER => l_defaultValueNumber,
X_DEFAULT_VALUE_DATE => l_defaultValueDate,
X_ITEM_NAME => l_itemName,
X_DISPLAY_HEIGHT => l_displayHeight,
X_SUBMIT => l_submit,
X_ENCRYPT => l_encrypt,
X_VIEW_USAGE_NAME => l_viewUsageName,
X_VIEW_ATTRIBUTE_NAME => l_viewAttributeName,
X_CSS_CLASS_NAME => l_cssClassName,
X_CSS_LABEL_CLASS_NAME => l_cssLabelClassName,
X_URL => l_url,
X_POPLIST_VIEWOBJECT => l_poplistViewObject,
X_POPLIST_DISPLAY_ATTRIBUTE => l_poplistDisplayAttribute,
X_POPLIST_VALUE_ATTRIBUTE => l_poplistValueAttribute,
X_IMAGE_FILE_NAME => l_imageFileName,
X_NESTED_REGION_CODE => l_nestedRegionCode,
X_NESTED_REGION_APPL_ID => l_nestedRegionApplId,
X_MENU_NAME => l_menuName,
X_FLEXFIELD_NAME => l_flexfieldName,
X_FLEXFIELD_APPLICATION_ID => l_flexfieldApplicationId,
X_TABULAR_FUNCTION_CODE => l_tabularFunctionCode,
X_TIP_TYPE => l_tipType,
X_TIP_MESSAGE_NAME => l_tipTypeMessageName,
X_TIP_MESSAGE_APPLICATION_ID => l_tipMessageApplicationId,
X_FLEX_SEGMENT_LIST => l_flexSegmentList,
X_ENTITY_ID => l_entityId,
X_ANCHOR => l_anchor,
X_POPLIST_VIEW_USAGE_NAME => l_poplistViewUsageName,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => fnd_load_util.owner_id('ORACLE'),
X_LAST_UPDATE_LOGIN => 0,
X_ATTRIBUTE_CATEGORY => l_attributeCategory,
X_ATTRIBUTE1 => l_attribute1,
X_ATTRIBUTE2 => l_attribute2,
X_ATTRIBUTE3 => l_attribute3,
X_ATTRIBUTE4 => l_attribute4,
X_ATTRIBUTE5 => l_attribute5,
X_ATTRIBUTE6 => l_attribute6,
X_ATTRIBUTE7 => l_attribute7,
X_ATTRIBUTE8 => l_attribute8,
X_ATTRIBUTE9 => l_attribute9,
X_ATTRIBUTE10 => l_attribute10,
X_ATTRIBUTE11 => l_attribute11,
X_ATTRIBUTE12 => l_attribute12,
X_ATTRIBUTE13 => l_attribute13,
X_ATTRIBUTE14 => l_attribute14,
X_ATTRIBUTE15 => l_attribute15);
AK_REGION_ITEMS_PKG.UPDATE_ROW(
X_REGION_APPLICATION_ID => 672,
X_REGION_CODE => p_regionCode,
X_ATTRIBUTE_APPLICATION_ID => 672,
X_ATTRIBUTE_CODE => p_attributeCode,
X_DISPLAY_SEQUENCE => l_displaySequence,
X_NODE_DISPLAY_FLAG => p_displayFlag,
X_NODE_QUERY_FLAG => l_nodeQueryFlag,
X_ATTRIBUTE_LABEL_LENGTH => l_attributeLabelLength,
X_BOLD => l_bold,
X_ITALIC => l_italic,
X_VERTICAL_ALIGNMENT => l_verticalAlignment,
X_HORIZONTAL_ALIGNMENT => l_horizontalAlignment,
X_ITEM_STYLE => l_itemStyle,
X_OBJECT_ATTRIBUTE_FLAG => l_objectAttributeFlag,
X_ATTRIBUTE_LABEL_LONG => l_attributeLabelLong,
X_DESCRIPTION => l_description,
X_SECURITY_CODE => l_securityCode,
X_UPDATE_FLAG => l_updateFlag,
X_REQUIRED_FLAG => p_mandatoryFlag,
X_DISPLAY_VALUE_LENGTH => l_displayValueLength,
X_LOV_REGION_APPLICATION_ID => l_lovRegionApplicationId,
X_LOV_REGION_CODE => l_lovRegionCode,
X_LOV_FOREIGN_KEY_NAME => l_lovForeignKeyName,
X_LOV_ATTRIBUTE_APPLICATION_ID => l_lovAttributeApplicationId,
X_LOV_ATTRIBUTE_CODE => l_lovAttributeCode,
X_LOV_DEFAULT_FLAG => l_lovDefaultFlag,
X_REGION_DEFAULTING_API_PKG => l_regionDefaultingApiPkg,
X_REGION_DEFAULTING_API_PROC => l_regionDefaultingApiProc,
X_REGION_VALIDATION_API_PKG => l_regionValidationApiPkg,
X_REGION_VALIDATION_API_PROC => l_regionValidationApiProc,
X_ORDER_SEQUENCE => l_orderSequence,
X_ORDER_DIRECTION => l_orderDirection,
X_DEFAULT_VALUE_VARCHAR2 => l_defaultValueVarchar2,
X_DEFAULT_VALUE_NUMBER => l_defaultValueNumber,
X_DEFAULT_VALUE_DATE => l_defaultValueDate,
X_ITEM_NAME => l_itemName,
X_DISPLAY_HEIGHT => l_displayHeight,
X_SUBMIT => l_submit,
X_ENCRYPT => l_encrypt,
X_VIEW_USAGE_NAME => l_viewUsageName,
X_VIEW_ATTRIBUTE_NAME => l_viewAttributeName,
X_CSS_CLASS_NAME => l_cssClassName,
X_CSS_LABEL_CLASS_NAME => l_cssLabelClassName,
X_URL => l_url,
X_POPLIST_VIEWOBJECT => l_poplistViewObject,
X_POPLIST_DISPLAY_ATTRIBUTE => l_poplistDisplayAttribute,
X_POPLIST_VALUE_ATTRIBUTE => l_poplistValueAttribute,
X_IMAGE_FILE_NAME => l_imageFileName,
X_NESTED_REGION_CODE => p_subRegionCode,
X_NESTED_REGION_APPL_ID => 672,
X_MENU_NAME => l_menuName,
X_FLEXFIELD_NAME => l_flexfieldName,
X_FLEXFIELD_APPLICATION_ID => l_flexfieldApplicationId,
X_TABULAR_FUNCTION_CODE => l_tabularFunctionCode,
X_TIP_TYPE => l_tipType,
X_TIP_MESSAGE_NAME => l_tipTypeMessageName,
X_TIP_MESSAGE_APPLICATION_ID => l_tipMessageApplicationId,
X_FLEX_SEGMENT_LIST => l_flexSegmentList,
X_ENTITY_ID => l_entityId,
X_ANCHOR => l_anchor,
X_POPLIST_VIEW_USAGE_NAME => l_poplistViewUsageName,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => fnd_load_util.owner_id('ORACLE'),
X_LAST_UPDATE_LOGIN => 0,
X_ATTRIBUTE_CATEGORY => l_attributeCategory,
X_ATTRIBUTE1 => l_attribute1,
X_ATTRIBUTE2 => l_attribute2,
X_ATTRIBUTE3 => l_attribute3,
X_ATTRIBUTE4 => l_attribute4,
X_ATTRIBUTE5 => l_attribute5,
X_ATTRIBUTE6 => l_attribute6,
X_ATTRIBUTE7 => l_attribute7,
X_ATTRIBUTE8 => l_attribute8,
X_ATTRIBUTE9 => l_attribute9,
X_ATTRIBUTE10 => l_attribute10,
X_ATTRIBUTE11 => l_attribute11,
X_ATTRIBUTE12 => l_attribute12,
X_ATTRIBUTE13 => l_attribute13,
X_ATTRIBUTE14 => l_attribute14,
X_ATTRIBUTE15 => l_attribute15);
log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Updating region items for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );
log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);
log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', 'Exception for p_regionCode: ' || p_regionCode || ' p_attributeCode: ' || p_attributeCode );
log_mesg(FND_LOG.LEVEL_UNEXPECTED, 'CS_CF_UTL_UPG_PKG.UpdateRegionItems', ' p_displayFlag: ' || p_displayFlag || ' p_mandatoryFlag: ' || p_mandatoryFlag || ' p_subRegionCode: ' || l_subRegionCode);
END UpdateRegionItems;
SELECT value || ',' into utl_file_dir
FROM v$parameter
WHERE name = 'utl_file_dir';
SELECT count(*) INTO l_count
FROM ak_regions
WHERE region_code in ('IBU_CF_SR_10_'|| p_suffix,
'IBU_CF_SR_20_' || p_suffix,
'IBU_CF_SR_30_' || p_suffix,
'IBU_CF_SR_40_' || p_suffix,
'IBU_CF_SR_50_' || p_suffix,
'IBU_CF_SR_60_' || p_suffix,
'IBU_CF_SR_70_' || p_suffix,
'IBU_CF_SR_80_' || p_suffix,
'IBU_CF_SR_90_' || p_suffix,
'IBU_CF_SR_110_' || p_suffix,
'IBU_CF_SR_120_' || p_suffix,
'IBU_CF_SR_130_' || p_suffix,
'IBU_CF_SR_140_' || p_suffix,
'IBU_CF_SR_150_' || p_suffix,
'IBU_CF_SR_160_' || p_suffix,
'IBU_CF_SR_170_' || p_suffix,
'IBU_CF_SR_180_' || p_suffix,
'IBU_CF_SR_190_' || p_suffix,
'IBU_CF_SR_200_' || p_suffix,
'IBU_CF_SR_210_' || p_suffix,
'IBU_CF_SR_220_' || p_suffix,
'IBU_CF_SR_230_' || p_suffix,
'IBU_CF_SR_240_' || p_suffix,
'IBU_CF_SR_310_' || p_suffix,
'IBU_CF_SR_320_' || p_suffix,
'IBU_CF_SR_410_' || p_suffix,
'IBU_CF_SR_420_' || p_suffix,
'IBU_CF_SR_430_' || p_suffix,
'IBU_CF_SR_440_' || p_suffix,
'IBU_CF_SR_450_' || p_suffix);
SELECT count(*)
FROM cs_cf_flows_b
WHERE flow_id = flowId;
SELECT b.last_updated_by
FROM fnd_profile_options a, fnd_profile_option_values b
WHERE a.profile_option_id = b.profile_option_id
AND a.profile_option_name = 'IBU_REGION_FIELD_CONFIG_OPTION'
AND B.LEVEL_ID = 10001
AND A.APPLICATION_ID = 672
AND A.APPLICATION_ID = B.APPLICATION_ID;
SELECT *
FROM cs_cf_flows_vl
WHERE flow_id = l_flowId;
SELECT *
FROM cs_cf_flow_pages_vl
WHERE flow_id = l_flowId;
CS_CF_FLOWS_PKG.Insert_Row(X_ROWID => l_rowid,
X_FLOW_ID => l_newFlowId,
X_FLOW_TYPE_CODE => l_flow_rec.flow_type_code,
X_FLOW_DISPLAY_NAME => 'Cloned Flow for Flow Id: ' || to_char(p_newFlowId),
X_OBJECT_VERSION_NUMBER => 1,
X_ATTRIBUTE_CATEGORY => l_flow_rec.attribute_category,
X_ATTRIBUTE1 => l_flow_rec.attribute1,
X_ATTRIBUTE2 => l_flow_rec.attribute2,
X_ATTRIBUTE3 => l_flow_rec.attribute3,
X_ATTRIBUTE4 => l_flow_rec.attribute4,
X_ATTRIBUTE5 => l_flow_rec.attribute5,
X_ATTRIBUTE6 => l_flow_rec.attribute6,
X_ATTRIBUTE7 => l_flow_rec.attribute7,
X_ATTRIBUTE8 => l_flow_rec.attribute8,
X_ATTRIBUTE9 => l_flow_rec.attribute9,
X_ATTRIBUTE10 => l_flow_rec.attribute10,
X_ATTRIBUTE11 => l_flow_rec.attribute11,
X_ATTRIBUTE12 => l_flow_rec.attribute12,
X_ATTRIBUTE13 => l_flow_rec.attribute13,
X_ATTRIBUTE14 => l_flow_rec.attribute14,
X_ATTRIBUTE15 => l_flow_rec.attribute15,
X_SEEDED_FLAG => 'N',
X_CREATION_DATE => sysdate,
X_CREATED_BY => l_created_by,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => l_created_by,
X_LAST_UPDATE_LOGIN => 0);
CS_CF_FLOW_PAGES_PKG.INSERT_ROW(X_ROWID => l_rowid,
X_FLOW_ID => l_newFlowId,
X_FLOW_TYPE_PAGE_ID => l_page_rec.flow_type_page_id,
X_ENABLED_FLAG => l_page_rec.enabled_flag,
X_OBJECT_VERSION_NUMBER => 1,
X_ATTRIBUTE_CATEGORY => l_page_rec.attribute_category,
X_ATTRIBUTE1 => l_page_rec.attribute1,
X_ATTRIBUTE2 => l_page_rec.attribute2,
X_ATTRIBUTE3 => l_page_rec.attribute3,
X_ATTRIBUTE4 => l_page_rec.attribute4,
X_ATTRIBUTE5 => l_page_rec.attribute5,
X_ATTRIBUTE6 => l_page_rec.attribute6,
X_ATTRIBUTE7 => l_page_rec.attribute7,
X_ATTRIBUTE8 => l_page_rec.attribute8,
X_ATTRIBUTE9 => l_page_rec.attribute9,
X_ATTRIBUTE10 => l_page_rec.attribute10,
X_ATTRIBUTE11 => l_page_rec.attribute11,
X_ATTRIBUTE12 => l_page_rec.attribute12,
X_ATTRIBUTE13 => l_page_rec.attribute13,
X_ATTRIBUTE14 => l_page_rec.attribute14,
X_ATTRIBUTE15 => l_page_rec.attribute15,
X_PAGE_DISPLAY_NAME => l_page_rec.page_display_name,
X_CREATION_DATE => sysdate,
X_CREATED_BY => l_created_by,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => l_created_by,
X_LAST_UPDATE_LOGIN => 0);