DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on AK_ATTRIBUTES

Line 9384: -- API name : Copy_AK_Attributes_Metadata

9380: END Synchronize_AK_BSC_Metadata;
9381:
9382:
9383: /************************************************************************************
9384: -- API name : Copy_AK_Attributes_Metadata
9385: -- Type : Private
9386: -- Function :
9387: -- 1. Synchronizes properties in ak_attributes and ak_attributes_tl
9388: ************************************************************************************/

Line 9387: -- 1. Synchronizes properties in ak_attributes and ak_attributes_tl

9383: /************************************************************************************
9384: -- API name : Copy_AK_Attributes_Metadata
9385: -- Type : Private
9386: -- Function :
9387: -- 1. Synchronizes properties in ak_attributes and ak_attributes_tl
9388: ************************************************************************************/
9389:
9390:
9391: PROCEDURE Copy_AK_Attributes_Metadata (

Line 9391: PROCEDURE Copy_AK_Attributes_Metadata (

9387: -- 1. Synchronizes properties in ak_attributes and ak_attributes_tl
9388: ************************************************************************************/
9389:
9390:
9391: PROCEDURE Copy_AK_Attributes_Metadata (
9392: p_commit IN VARCHAR2 := FND_API.G_FALSE
9393: ,p_short_name IN BSC_KPIS_B.short_name%TYPE
9394: ,x_return_status OUT NOCOPY VARCHAR2
9395: ,x_msg_count OUT NOCOPY NUMBER

Line 9427: FROM AK_ATTRIBUTES

9423:
9424: l_Count := 0;
9425: SELECT COUNT(1)
9426: INTO l_Count
9427: FROM AK_ATTRIBUTES
9428: WHERE attribute_code = l_Attribute_Code AND
9429: attribute_application_id = l_Attribute_Application_Id;
9430: IF l_Count = 0 THEN
9431: AK_ATTRIBUTES_PKG.INSERT_ROW (

Line 9431: AK_ATTRIBUTES_PKG.INSERT_ROW (

9427: FROM AK_ATTRIBUTES
9428: WHERE attribute_code = l_Attribute_Code AND
9429: attribute_application_id = l_Attribute_Application_Id;
9430: IF l_Count = 0 THEN
9431: AK_ATTRIBUTES_PKG.INSERT_ROW (
9432: X_ROWID => l_attribute_rowid,
9433: X_ATTRIBUTE_APPLICATION_ID => l_Attribute_Application_Id,
9434: X_ATTRIBUTE_CODE => l_Attribute_Code,
9435: X_ATTRIBUTE_LABEL_LENGTH => BIS_AK_REGION_PUB.c_ATTR_LABEL_LENGTH,

Line 9513: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';

9509: WHEN NO_DATA_FOUND THEN
9510: ROLLBACK TO BscCopyAKAttrMetadata;
9511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9512: IF (x_msg_data IS NOT NULL) THEN
9513: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9514: ELSE
9515: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9516: END IF;
9517: WHEN OTHERS THEN

Line 9515: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';

9511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9512: IF (x_msg_data IS NOT NULL) THEN
9513: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9514: ELSE
9515: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9516: END IF;
9517: WHEN OTHERS THEN
9518: ROLLBACK TO BscCopyAKAttrMetadata;
9519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9521: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';

9517: WHEN OTHERS THEN
9518: ROLLBACK TO BscCopyAKAttrMetadata;
9519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9520: IF (x_msg_data IS NOT NULL) THEN
9521: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9522: ELSE
9523: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9524: END IF;
9525: END Copy_AK_Attributes_Metadata;

Line 9523: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';

9519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9520: IF (x_msg_data IS NOT NULL) THEN
9521: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9522: ELSE
9523: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9524: END IF;
9525: END Copy_AK_Attributes_Metadata;
9526:
9527: /************************************************************************************

Line 9525: END Copy_AK_Attributes_Metadata;

9521: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9522: ELSE
9523: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9524: END IF;
9525: END Copy_AK_Attributes_Metadata;
9526:
9527: /************************************************************************************
9528: -- API name : Migrate_Sim_Data
9529: -- Type : Public

Line 9877: Copy_AK_Attributes_Metadata (

9873: SET
9874: attribute12 = p_Region_Code
9875: WHERE
9876: region_code = p_Region_Code;
9877: Copy_AK_Attributes_Metadata (
9878: p_commit => FND_API.G_FALSE
9879: ,p_short_name => p_Old_Region_Code
9880: ,x_return_status => x_return_status
9881: ,x_msg_count => x_msg_count