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_UTILITY dependencies on FND_TABLE_OF_VARCHAR2_30

Line 2524: , x_region_codes OUT NOCOPY FND_TABLE_OF_VARCHAR2_30

2520: x_region_codes: Table of region Codes containing the above dimension objects
2521: ****************************************************************************************************/
2522: PROCEDURE Is_Dim_Obj_In_AKReport(
2523: p_Short_Names IN VARCHAR2
2524: , x_region_codes OUT NOCOPY FND_TABLE_OF_VARCHAR2_30
2525: , x_Return_Status OUT NOCOPY VARCHAR2
2526: , x_Msg_Count OUT NOCOPY NUMBER
2527: , x_Msg_Data OUT NOCOPY VARCHAR2
2528: ) IS

Line 2541: x_region_codes := FND_TABLE_OF_VARCHAR2_30();

2537: BEGIN
2538: FND_MSG_PUB.Initialize;
2539: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2540: IF (p_Short_Names IS NOT NULL) THEN
2541: x_region_codes := FND_TABLE_OF_VARCHAR2_30();
2542: l_sql := 'SELECT DISTINCT REGION_CODE FROM ak_region_items WHERE node_query_flag = ''Y'' AND node_display_flag = ''N'' AND SUBSTR(attribute2,INSTR(attribute2,''+'') +1 ,LENGTH(attribute2)) IN (' ;
2543: l_short_names := p_Short_Names;
2544: WHILE (BSC_UTILITY.is_more( l_short_names,l_dim_obj_sht_name)) LOOP
2545: l_attr2_sql := l_attr2_sql || '''' || l_dim_obj_sht_name || ''',' ;