eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MIGRATION dependencies on AK_REGION_ITEMS

Line 8528: -- Migrate ak region items

8524: );
8525: END IF;
8526: CLOSE h_cursor;
8527:
8528: -- Migrate ak region items
8529: h_sql := 'select attribute_application_id, attribute_code, display_sequence, node_display_flag,'||
8530: ' node_query_flag, attribute_label_long, attribute_label_length, display_value_length,'||
8531: ' item_style, required_flag, nested_region_code, nested_region_application_id,'||
8532: ' attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5,'||

Line 8535: ' from ak_region_items_vl@'||g_db_link||

8531: ' item_style, required_flag, nested_region_code, nested_region_application_id,'||
8532: ' attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5,'||
8533: ' attribute6, attribute7, attribute8, attribute9, attribute10, attribute11, attribute12,'||
8534: ' attribute13, attribute14, attribute15, url, order_sequence, order_direction'||
8535: ' from ak_region_items_vl@'||g_db_link||
8536: ' where region_code = :1 and region_application_id = :2';
8537: OPEN h_cursor FOR h_sql USING p_region_code, h_region_application_id;
8538: LOOP
8539: FETCH h_cursor INTO h_attribute_application_id, h_attribute_code, h_display_sequence, h_node_display_flag,

Line 8840: ,p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE

8836: PROCEDURE Update_AK_Item_Props (
8837: p_commit IN VARCHAR2 := FND_API.G_FALSE
8838: ,p_region_code IN VARCHAR2
8839: ,p_region_application_id IN NUMBER
8840: ,p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
8841: ,p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
8842: ,p_Attribute2 IN AK_REGION_ITEMS.ATTRIBUTE2%TYPE
8843: ,x_return_status OUT NOCOPY VARCHAR2
8844: ,x_msg_count OUT NOCOPY NUMBER

Line 8841: ,p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

8837: p_commit IN VARCHAR2 := FND_API.G_FALSE
8838: ,p_region_code IN VARCHAR2
8839: ,p_region_application_id IN NUMBER
8840: ,p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
8841: ,p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
8842: ,p_Attribute2 IN AK_REGION_ITEMS.ATTRIBUTE2%TYPE
8843: ,x_return_status OUT NOCOPY VARCHAR2
8844: ,x_msg_count OUT NOCOPY NUMBER
8845: ,x_msg_data OUT NOCOPY VARCHAR2

Line 8842: ,p_Attribute2 IN AK_REGION_ITEMS.ATTRIBUTE2%TYPE

8838: ,p_region_code IN VARCHAR2
8839: ,p_region_application_id IN NUMBER
8840: ,p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
8841: ,p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE
8842: ,p_Attribute2 IN AK_REGION_ITEMS.ATTRIBUTE2%TYPE
8843: ,x_return_status OUT NOCOPY VARCHAR2
8844: ,x_msg_count OUT NOCOPY NUMBER
8845: ,x_msg_data OUT NOCOPY VARCHAR2
8846: ) IS

Line 8957: l_Attribute2 ak_region_items.attribute2%TYPE;

8953: l_Dim_Lev_Sht_Name bsc_sys_dim_levels_vl.short_name%TYPE;
8954: l_Dim_Short_Name bsc_sys_dim_groups_vl.short_name%TYPE;
8955: l_Old_Default_Node bsc_kpi_properties.property_value%TYPE ;
8956:
8957: l_Attribute2 ak_region_items.attribute2%TYPE;
8958: l_Item_Att_App_Id ak_region_items.attribute_application_id%TYPE;
8959: l_Item_Att_Code ak_region_items.attribute_code%TYPE;
8960: l_New_Attribute2 ak_region_items.attribute2%TYPE;
8961: l_Region_Att_Id ak_region_items.region_application_id%TYPE;

Line 8958: l_Item_Att_App_Id ak_region_items.attribute_application_id%TYPE;

8954: l_Dim_Short_Name bsc_sys_dim_groups_vl.short_name%TYPE;
8955: l_Old_Default_Node bsc_kpi_properties.property_value%TYPE ;
8956:
8957: l_Attribute2 ak_region_items.attribute2%TYPE;
8958: l_Item_Att_App_Id ak_region_items.attribute_application_id%TYPE;
8959: l_Item_Att_Code ak_region_items.attribute_code%TYPE;
8960: l_New_Attribute2 ak_region_items.attribute2%TYPE;
8961: l_Region_Att_Id ak_region_items.region_application_id%TYPE;
8962: l_Attribute_Code_Tbl BISVIEWER.t_char ;

Line 8959: l_Item_Att_Code ak_region_items.attribute_code%TYPE;

8955: l_Old_Default_Node bsc_kpi_properties.property_value%TYPE ;
8956:
8957: l_Attribute2 ak_region_items.attribute2%TYPE;
8958: l_Item_Att_App_Id ak_region_items.attribute_application_id%TYPE;
8959: l_Item_Att_Code ak_region_items.attribute_code%TYPE;
8960: l_New_Attribute2 ak_region_items.attribute2%TYPE;
8961: l_Region_Att_Id ak_region_items.region_application_id%TYPE;
8962: l_Attribute_Code_Tbl BISVIEWER.t_char ;
8963: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;

Line 8960: l_New_Attribute2 ak_region_items.attribute2%TYPE;

8956:
8957: l_Attribute2 ak_region_items.attribute2%TYPE;
8958: l_Item_Att_App_Id ak_region_items.attribute_application_id%TYPE;
8959: l_Item_Att_Code ak_region_items.attribute_code%TYPE;
8960: l_New_Attribute2 ak_region_items.attribute2%TYPE;
8961: l_Region_Att_Id ak_region_items.region_application_id%TYPE;
8962: l_Attribute_Code_Tbl BISVIEWER.t_char ;
8963: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
8964: l_Region_Code ak_region_items.region_code%TYPE;

Line 8961: l_Region_Att_Id ak_region_items.region_application_id%TYPE;

8957: l_Attribute2 ak_region_items.attribute2%TYPE;
8958: l_Item_Att_App_Id ak_region_items.attribute_application_id%TYPE;
8959: l_Item_Att_Code ak_region_items.attribute_code%TYPE;
8960: l_New_Attribute2 ak_region_items.attribute2%TYPE;
8961: l_Region_Att_Id ak_region_items.region_application_id%TYPE;
8962: l_Attribute_Code_Tbl BISVIEWER.t_char ;
8963: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
8964: l_Region_Code ak_region_items.region_code%TYPE;
8965: l_Retain_Dim_Att2 BIS_STRING_ARRAY;

Line 8964: l_Region_Code ak_region_items.region_code%TYPE;

8960: l_New_Attribute2 ak_region_items.attribute2%TYPE;
8961: l_Region_Att_Id ak_region_items.region_application_id%TYPE;
8962: l_Attribute_Code_Tbl BISVIEWER.t_char ;
8963: l_Attribute_App_Id_Tbl BISVIEWER.t_num ;
8964: l_Region_Code ak_region_items.region_code%TYPE;
8965: l_Retain_Dim_Att2 BIS_STRING_ARRAY;
8966: l_Actual_Data_Source bis_indicators.actual_data_source%TYPE;
8967: l_sql VARCHAR2(32000);
8968: l_Periodicity_Sht_Name bsc_sys_periodicities.short_name%TYPE;

Line 8990: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item.attribute2,i.dataset_id from ak_region_items');

8986:
8987: SAVEPOINT BscSyncAKBscMetadata;
8988: -- DataSet Sync Up
8989: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id, i.comparison_source,i.enable_link, ';
8990: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item.attribute2,i.dataset_id from ak_region_items');
8991: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item, bis_indicators');
8992: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('i,bsc_kpis_b');
8993: l_sql := l_sql || ' k WHERE ak_item.region_code = k.short_name and ak_item.attribute1 = :1 and i.short_name = ak_item.attribute2';
8994: l_sql := l_sql || ' AND k.indicator = :2';

Line 9046: ak_region_items_tl ak_item

9042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9043: END IF;
9044:
9045: UPDATE
9046: ak_region_items_tl ak_item
9047: SET
9048: attribute_label_long = (SELECT
9049: d.name
9050: FROM

Line 9121: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' p.periodicity_id FROM ak_region_items');

9117: CLOSE c_cursor;
9118:
9119: --Periods Sync Up
9120: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id,ak_item.attribute2,';
9121: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' p.periodicity_id FROM ak_region_items');
9122: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');
9123: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k,bsc_sys_periodicities');
9124: l_sql := l_sql || ' p WHERE ak_item.region_code = k.short_name and ak_item.attribute1 = :1 and ak_item.attribute2 LIKE :2';
9125: l_sql := l_sql || ' AND ak_item.attribute2 NOT LIKE :3 AND SUBSTR(ak_item.attribute2,INSTR(ak_item.attribute2,''+'') +1) = p.short_name';

Line 9173: ak_region_items_tl ak_item

9169: l_Retain_Dim_Att2.EXTEND(1);
9170: l_Retain_Dim_Att2(l_Retain_Dim_Att2.LAST) := l_Item_Att_Code;
9171:
9172: UPDATE
9173: ak_region_items_tl ak_item
9174: SET
9175: attribute_label_long = (SELECT
9176: tl.name
9177: FROM

Line 9198: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item.attribute2, d.dim_level_id,g.dim_group_id FROM ak_region_items');

9194: CLOSE c_cursor;
9195:
9196: --Dim Object Sync Up
9197: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id,';
9198: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item.attribute2, d.dim_level_id,g.dim_group_id FROM ak_region_items');
9199: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');
9200: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k , bsc_sys_dim_levels_b');
9201: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' d , bsc_sys_dim_groups_vl');
9202: l_sql := l_sql || ' g WHERE ak_item.region_code = k.short_name AND ak_item.node_query_flag = ''Y'' AND ak_item.attribute2 LIKE ''%+%''';

Line 9206: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item.attribute2, d.dim_level_id,g.dim_group_id FROM ak_region_items');

9202: l_sql := l_sql || ' g WHERE ak_item.region_code = k.short_name AND ak_item.node_query_flag = ''Y'' AND ak_item.attribute2 LIKE ''%+%''';
9203: l_sql := l_sql || ' AND SUBSTR(ak_item.attribute2,INSTR(ak_item.attribute2,''+'') +1) = d.short_name AND';
9204: l_sql := l_sql || ' SUBSTR(ak_item.attribute2,0,INSTR(ak_item.attribute2,''+'') - 1) = g.short_name AND k.indicator = :1 MINUS';
9205: l_sql := l_sql || ' SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id,';
9206: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('ak_item.attribute2, d.dim_level_id,g.dim_group_id FROM ak_region_items');
9207: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' ak_item,bsc_kpis_b');
9208: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' k , bsc_sys_periodicities');
9209: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' p,bsc_sys_dim_levels_b');
9210: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String(' d,bsc_sys_dim_groups_vl');

Line 9272: ak_region_items_tl ak_item

9268: l_Retain_Dim_Att2.EXTEND(1);
9269: l_Retain_Dim_Att2(l_Retain_Dim_Att2.LAST) := l_Item_Att_Code;
9270:
9271: UPDATE
9272: ak_region_items_tl ak_item
9273: SET
9274: attribute_label_long = (SELECT
9275: tl.name
9276: FROM

Line 9301: ak_region_items

9297: attribute_code,attribute_application_id
9298: BULK COLLECT INTO
9299: l_Attribute_Code_Tbl,l_Attribute_App_Id_Tbl
9300: FROM
9301: ak_region_items
9302: WHERE
9303: region_code = p_short_name AND
9304: attribute_code in (SELECT
9305: attribute_code

Line 9307: ak_region_items

9303: region_code = p_short_name AND
9304: attribute_code in (SELECT
9305: attribute_code
9306: FROM
9307: ak_region_items
9308: WHERE
9309: region_code = p_short_name AND
9310: node_query_flag = 'Y' AND
9311: attribute2 like '%+%' AND

Line 9398: l_Attribute_Code ak_region_items.attribute_code%TYPE;

9394: ,x_return_status OUT NOCOPY VARCHAR2
9395: ,x_msg_count OUT NOCOPY NUMBER
9396: ,x_msg_data OUT NOCOPY VARCHAR2
9397: ) IS
9398: l_Attribute_Code ak_region_items.attribute_code%TYPE;
9399: l_Attribute_Application_Id ak_region_items.attribute_application_id%TYPE;
9400: l_Item_Style ak_region_items.item_style%TYPE;
9401: l_Attribute_Category ak_region_items.attribute_category%TYPE;
9402: l_sql VARCHAR2(32000);

Line 9399: l_Attribute_Application_Id ak_region_items.attribute_application_id%TYPE;

9395: ,x_msg_count OUT NOCOPY NUMBER
9396: ,x_msg_data OUT NOCOPY VARCHAR2
9397: ) IS
9398: l_Attribute_Code ak_region_items.attribute_code%TYPE;
9399: l_Attribute_Application_Id ak_region_items.attribute_application_id%TYPE;
9400: l_Item_Style ak_region_items.item_style%TYPE;
9401: l_Attribute_Category ak_region_items.attribute_category%TYPE;
9402: l_sql VARCHAR2(32000);
9403: l_attribute_rowid varchar2(50);

Line 9400: l_Item_Style ak_region_items.item_style%TYPE;

9396: ,x_msg_data OUT NOCOPY VARCHAR2
9397: ) IS
9398: l_Attribute_Code ak_region_items.attribute_code%TYPE;
9399: l_Attribute_Application_Id ak_region_items.attribute_application_id%TYPE;
9400: l_Item_Style ak_region_items.item_style%TYPE;
9401: l_Attribute_Category ak_region_items.attribute_category%TYPE;
9402: l_sql VARCHAR2(32000);
9403: l_attribute_rowid varchar2(50);
9404: l_count NUMBER := 0;

Line 9401: l_Attribute_Category ak_region_items.attribute_category%TYPE;

9397: ) IS
9398: l_Attribute_Code ak_region_items.attribute_code%TYPE;
9399: l_Attribute_Application_Id ak_region_items.attribute_application_id%TYPE;
9400: l_Item_Style ak_region_items.item_style%TYPE;
9401: l_Attribute_Category ak_region_items.attribute_category%TYPE;
9402: l_sql VARCHAR2(32000);
9403: l_attribute_rowid varchar2(50);
9404: l_count NUMBER := 0;
9405: TYPE c_cur_type IS REF CURSOR;

Line 9415: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('from ak_region_items');

9411:
9412: SAVEPOINT BscCopyAKAttrMetadata;
9413: -- DataSet Sync Up
9414: l_sql := 'SELECT attribute_code,attribute_application_id,item_style,attribute_category ';
9415: l_sql := l_sql || BSC_DESIGNER_PVT.Format_DbLink_String('from ak_region_items');
9416: l_sql := l_sql || ' WHERE region_code = :1';
9417:
9418:
9419: OPEN c_cursor FOR l_sql USING p_short_name;