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 DBMS_SQL

Line 2993: l_cursor := DBMS_SQL.OPEN_CURSOR;

2989: ' :l_target := '||l_computed_target_short_name||
2990: ' ( l_target_rec ); '||
2991: 'End; ' ;
2992:
2993: l_cursor := DBMS_SQL.OPEN_CURSOR;
2994:
2995: DBMS_SQL.PARSE( c => l_cursor
2996: , statement => l_stmt
2997: , language_flag => DBMS_SQL.NATIVE

Line 2995: DBMS_SQL.PARSE( c => l_cursor

2991: 'End; ' ;
2992:
2993: l_cursor := DBMS_SQL.OPEN_CURSOR;
2994:
2995: DBMS_SQL.PARSE( c => l_cursor
2996: , statement => l_stmt
2997: , language_flag => DBMS_SQL.NATIVE
2998: );
2999: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_target', l_target);

Line 2997: , language_flag => DBMS_SQL.NATIVE

2993: l_cursor := DBMS_SQL.OPEN_CURSOR;
2994:
2995: DBMS_SQL.PARSE( c => l_cursor
2996: , statement => l_stmt
2997: , language_flag => DBMS_SQL.NATIVE
2998: );
2999: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_target', l_target);
3000: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3001: DBMS_SQL.VARIABLE_VALUE(l_cursor, ':l_target', l_target);

Line 2999: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_target', l_target);

2995: DBMS_SQL.PARSE( c => l_cursor
2996: , statement => l_stmt
2997: , language_flag => DBMS_SQL.NATIVE
2998: );
2999: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_target', l_target);
3000: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3001: DBMS_SQL.VARIABLE_VALUE(l_cursor, ':l_target', l_target);
3002:
3003: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

Line 3000: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

2996: , statement => l_stmt
2997: , language_flag => DBMS_SQL.NATIVE
2998: );
2999: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_target', l_target);
3000: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3001: DBMS_SQL.VARIABLE_VALUE(l_cursor, ':l_target', l_target);
3002:
3003: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
3004: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 3001: DBMS_SQL.VARIABLE_VALUE(l_cursor, ':l_target', l_target);

2997: , language_flag => DBMS_SQL.NATIVE
2998: );
2999: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_target', l_target);
3000: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3001: DBMS_SQL.VARIABLE_VALUE(l_cursor, ':l_target', l_target);
3002:
3003: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
3004: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3005: END IF;

Line 3003: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

2999: DBMS_SQL.BIND_VARIABLE(l_cursor, ':l_target', l_target);
3000: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3001: DBMS_SQL.VARIABLE_VALUE(l_cursor, ':l_target', l_target);
3002:
3003: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
3004: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3005: END IF;
3006:
3007: RETURN l_target;

Line 3004: DBMS_SQL.CLOSE_CURSOR(l_cursor);

3000: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3001: DBMS_SQL.VARIABLE_VALUE(l_cursor, ':l_target', l_target);
3002:
3003: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
3004: DBMS_SQL.CLOSE_CURSOR(l_cursor);
3005: END IF;
3006:
3007: RETURN l_target;
3008:

Line 3071: l_level_value DBMS_SQL.VARCHAR2_TABLE;

3067:
3068: l_size NUMBER := 100000;
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';

Line 3072: l_level_id DBMS_SQL.VARCHAR2_TABLE;

3068: l_size NUMBER := 100000;
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);

Line 3078: l_cursor := DBMS_SQL.OPEN_CURSOR;

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:
3078: l_cursor := DBMS_SQL.OPEN_CURSOR;
3079: DBMS_SQL.PARSE( c => l_cursor
3080: , statement => l_query
3081: , language_flag => DBMS_SQL.NATIVE
3082: );

Line 3079: DBMS_SQL.PARSE( c => l_cursor

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:
3078: l_cursor := DBMS_SQL.OPEN_CURSOR;
3079: DBMS_SQL.PARSE( c => l_cursor
3080: , statement => l_query
3081: , language_flag => DBMS_SQL.NATIVE
3082: );
3083: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_level_id, l_size, 1);

Line 3081: , language_flag => DBMS_SQL.NATIVE

3077:
3078: l_cursor := DBMS_SQL.OPEN_CURSOR;
3079: DBMS_SQL.PARSE( c => l_cursor
3080: , statement => l_query
3081: , language_flag => DBMS_SQL.NATIVE
3082: );
3083: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_level_id, l_size, 1);
3084: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_level_value, l_size, 1);
3085: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

Line 3083: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_level_id, l_size, 1);

3079: DBMS_SQL.PARSE( c => l_cursor
3080: , statement => l_query
3081: , language_flag => DBMS_SQL.NATIVE
3082: );
3083: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_level_id, l_size, 1);
3084: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_level_value, l_size, 1);
3085: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3086: LOOP
3087: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

Line 3084: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_level_value, l_size, 1);

3080: , statement => l_query
3081: , language_flag => DBMS_SQL.NATIVE
3082: );
3083: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_level_id, l_size, 1);
3084: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_level_value, l_size, 1);
3085: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3086: LOOP
3087: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
3088: EXIT WHEN l_retrieved = 0;

Line 3085: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

3081: , language_flag => DBMS_SQL.NATIVE
3082: );
3083: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_level_id, l_size, 1);
3084: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_level_value, l_size, 1);
3085: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3086: LOOP
3087: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
3088: EXIT WHEN l_retrieved = 0;
3089: -- retrieve the values into vars

Line 3087: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);

3083: DBMS_SQL.DEFINE_ARRAY(l_cursor, 1, l_level_id, l_size, 1);
3084: DBMS_SQL.DEFINE_ARRAY(l_cursor, 2, l_level_value, l_size, 1);
3085: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
3086: LOOP
3087: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
3088: EXIT WHEN l_retrieved = 0;
3089: -- retrieve the values into vars
3090: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_level_id);
3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_level_value);

Line 3090: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_level_id);

3086: LOOP
3087: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
3088: EXIT WHEN l_retrieved = 0;
3089: -- retrieve the values into vars
3090: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_level_id);
3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_level_value);
3092: --
3093: FOR l_ind1 IN 1..l_level_id.COUNT LOOP
3094: l_rec.id := l_level_id(l_ind1);

Line 3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_level_value);

3087: l_retrieved := DBMS_SQL.FETCH_ROWS(l_cursor);
3088: EXIT WHEN l_retrieved = 0;
3089: -- retrieve the values into vars
3090: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_level_id);
3091: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_level_value);
3092: --
3093: FOR l_ind1 IN 1..l_level_id.COUNT LOOP
3094: l_rec.id := l_level_id(l_ind1);
3095: l_rec.value := l_level_value(l_ind1);

Line 3111: l_cursor := DBMS_SQL.OPEN_CURSOR;

3107: l_cursor INTEGER;
3108: l_date DATE;
3109: l_dummy INTEGER;
3110: BEGIN
3111: l_cursor := DBMS_SQL.OPEN_CURSOR;
3112: DBMS_SQL.PARSE( c => l_cursor
3113: , statement => p_query
3114: , language_flag => DBMS_SQL.NATIVE
3115: );

Line 3112: DBMS_SQL.PARSE( c => l_cursor

3108: l_date DATE;
3109: l_dummy INTEGER;
3110: BEGIN
3111: l_cursor := DBMS_SQL.OPEN_CURSOR;
3112: DBMS_SQL.PARSE( c => l_cursor
3113: , statement => p_query
3114: , language_flag => DBMS_SQL.NATIVE
3115: );
3116:

Line 3114: , language_flag => DBMS_SQL.NATIVE

3110: BEGIN
3111: l_cursor := DBMS_SQL.OPEN_CURSOR;
3112: DBMS_SQL.PARSE( c => l_cursor
3113: , statement => p_query
3114: , language_flag => DBMS_SQL.NATIVE
3115: );
3116:
3117: dbms_sql.define_column(l_cursor, 1, l_date);
3118: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

Line 3117: dbms_sql.define_column(l_cursor, 1, l_date);

3113: , statement => p_query
3114: , language_flag => DBMS_SQL.NATIVE
3115: );
3116:
3117: dbms_sql.define_column(l_cursor, 1, l_date);
3118: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
3119:
3120: loop
3121: if (dbms_sql.fetch_rows(l_cursor) = 0) then

Line 3118: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

3114: , language_flag => DBMS_SQL.NATIVE
3115: );
3116:
3117: dbms_sql.define_column(l_cursor, 1, l_date);
3118: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
3119:
3120: loop
3121: if (dbms_sql.fetch_rows(l_cursor) = 0) then
3122: exit;

Line 3121: if (dbms_sql.fetch_rows(l_cursor) = 0) then

3117: dbms_sql.define_column(l_cursor, 1, l_date);
3118: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
3119:
3120: loop
3121: if (dbms_sql.fetch_rows(l_cursor) = 0) then
3122: exit;
3123: end if;
3124:
3125: dbms_sql.column_value(l_cursor, 1, l_date);

Line 3125: dbms_sql.column_value(l_cursor, 1, l_date);

3121: if (dbms_sql.fetch_rows(l_cursor) = 0) then
3122: exit;
3123: end if;
3124:
3125: dbms_sql.column_value(l_cursor, 1, l_date);
3126: end loop;
3127:
3128: return l_date;
3129: END getDate;