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.BIS_TARGET_PVT dependencies on BIS_LOV_PVT

Line 3041: , p_value_id_table BIS_LOV_PVT.Value_Id_Table

3037: --
3038: --
3039: FUNCTION getValue
3040: ( p_id VARCHAR2
3041: , p_value_id_table BIS_LOV_PVT.Value_Id_Table
3042: )
3043: return varchar2
3044: IS
3045: BEGIN

Line 3062: , x_value_id_table OUT NOCOPY BIS_LOV_PVT.Value_Id_Table

3058:
3059: PROCEDURE RetrieveValues
3060: ( p_view_name IN VARCHAR2
3061: , p_where_clause IN VARCHAR2
3062: , x_value_id_table OUT NOCOPY BIS_LOV_PVT.Value_Id_Table
3063: )
3064: IS
3065: l_query VARCHAR2(32000);
3066: l_sql_result INTEGER := 0;

Line 3073: l_rec BIS_LOV_PVT.Value_Id_record;

3069: l_retrieved NUMBER;
3070: l_cursor INTEGER;
3071: l_level_value DBMS_SQL.VARCHAR2_TABLE;
3072: l_level_id DBMS_SQL.VARCHAR2_TABLE;
3073: l_rec BIS_LOV_PVT.Value_Id_record;
3074: BEGIN
3075: l_query := 'select distinct id, value from '||p_view_name||' '||p_where_clause || ' order by id';
3076: --dbms_output.put_line(l_query);
3077: