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_UTIL dependencies on DBMS_SQL

Line 300: l_cursor := dbms_sql.open_cursor;

296: end if;
297: end if;
298:
299: -- Open cursor
300: l_cursor := dbms_sql.open_cursor;
301:
302: -- parse the statment
303: BIS_debug_pub.add('sql statement: ' || ' create or replace force view bis_'
304: || substr(replace(p_ind_level_name,' ','_'),1,24)

Line 313: dbms_sql.parse(c => l_cursor

309: BIS_debug_pub.add(l_view_from_stmt);
310: BIS_debug_pub.add(substr(l_view_from_stmt2,1,150));
311: BIS_debug_pub.add(substr(l_view_from_stmt2,151));
312:
313: dbms_sql.parse(c => l_cursor
314: ,statement=> ' create or replace force view bis_'
315: || substr(replace(p_ind_level_name,' ','_'),1,24)
316: || '_v(' || l_level_col_list1
317: || l_level_col_list2

Line 323: ,language_flag => DBMS_SQL.Native);

319: || l_level_select_list1
320: || l_level_select_list2
321: || l_level_select_list3
322: || ' ' || l_view_from_stmt ||' '||l_view_from_stmt2||' '||l_view_from_stmt3
323: ,language_flag => DBMS_SQL.Native);
324:
325: -- Execute the cursor
326: l_sql_result := dbms_sql.execute(l_cursor);
327: -- Close the cursor

Line 326: l_sql_result := dbms_sql.execute(l_cursor);

322: || ' ' || l_view_from_stmt ||' '||l_view_from_stmt2||' '||l_view_from_stmt3
323: ,language_flag => DBMS_SQL.Native);
324:
325: -- Execute the cursor
326: l_sql_result := dbms_sql.execute(l_cursor);
327: -- Close the cursor
328: dbms_sql.close_cursor(l_cursor);
329: -- check for sql execution result
330: BIS_debug_pub.add('The view creation sql execution result is :'

Line 328: dbms_sql.close_cursor(l_cursor);

324:
325: -- Execute the cursor
326: l_sql_result := dbms_sql.execute(l_cursor);
327: -- Close the cursor
328: dbms_sql.close_cursor(l_cursor);
329: -- check for sql execution result
330: BIS_debug_pub.add('The view creation sql execution result is :'
331: || to_char(l_sql_result));
332:

Line 577: l_cursor := dbms_sql.open_cursor;

573:
574: select short_name into l_view_name from bis_target_levels
575: where target_level_id = p_target_level_id;
576: -- open cursor
577: l_cursor := dbms_sql.open_cursor;
578:
579: -- parse statement
580: dbms_sql.parse(c => l_cursor
581: ,statement => 'drop view BIS_'|| l_view_name ||'_V'

Line 580: dbms_sql.parse(c => l_cursor

576: -- open cursor
577: l_cursor := dbms_sql.open_cursor;
578:
579: -- parse statement
580: dbms_sql.parse(c => l_cursor
581: ,statement => 'drop view BIS_'|| l_view_name ||'_V'
582: ,language_flag => DBMS_SQL.Native);
583:
584: -- execuse cursor

Line 582: ,language_flag => DBMS_SQL.Native);

578:
579: -- parse statement
580: dbms_sql.parse(c => l_cursor
581: ,statement => 'drop view BIS_'|| l_view_name ||'_V'
582: ,language_flag => DBMS_SQL.Native);
583:
584: -- execuse cursor
585: l_sql_result := dbms_sql.execute(l_cursor);
586:

Line 585: l_sql_result := dbms_sql.execute(l_cursor);

581: ,statement => 'drop view BIS_'|| l_view_name ||'_V'
582: ,language_flag => DBMS_SQL.Native);
583:
584: -- execuse cursor
585: l_sql_result := dbms_sql.execute(l_cursor);
586:
587: -- close cursor
588: dbms_sql.close_cursor(l_cursor);
589: if nvl(l_sql_result,-1) <> 0 then

Line 588: dbms_sql.close_cursor(l_cursor);

584: -- execuse cursor
585: l_sql_result := dbms_sql.execute(l_cursor);
586:
587: -- close cursor
588: dbms_sql.close_cursor(l_cursor);
589: if nvl(l_sql_result,-1) <> 0 then
590: NULL;
591: -- dbms_output.put_line('Error');
592: else

Line 638: l_cursor := dbms_sql.open_cursor;

634:
635: select level_values_view_name into l_view_name
636: from bis_levels where level_id = p_dim_level_id;
637:
638: l_cursor := dbms_sql.open_cursor;
639:
640: l_select_stmt := 'select value from '|| l_view_name
641: ||' where id = :dim_level_value_id';
642:

Line 643: dbms_sql.parse(c => l_cursor,

639:
640: l_select_stmt := 'select value from '|| l_view_name
641: ||' where id = :dim_level_value_id';
642:
643: dbms_sql.parse(c => l_cursor,
644: statement => l_select_stmt,
645: language_flag => DBMS_SQL.Native);
646:
647: dbms_sql.bind_variable(l_cursor, ':dim_level_value_id',p_dim_level_value_id);

Line 645: language_flag => DBMS_SQL.Native);

641: ||' where id = :dim_level_value_id';
642:
643: dbms_sql.parse(c => l_cursor,
644: statement => l_select_stmt,
645: language_flag => DBMS_SQL.Native);
646:
647: dbms_sql.bind_variable(l_cursor, ':dim_level_value_id',p_dim_level_value_id);
648: dbms_sql.define_column(l_cursor,1,v_value,80);
649: l_sql_result := dbms_sql.execute_and_fetch(l_cursor,TRUE);

Line 647: dbms_sql.bind_variable(l_cursor, ':dim_level_value_id',p_dim_level_value_id);

643: dbms_sql.parse(c => l_cursor,
644: statement => l_select_stmt,
645: language_flag => DBMS_SQL.Native);
646:
647: dbms_sql.bind_variable(l_cursor, ':dim_level_value_id',p_dim_level_value_id);
648: dbms_sql.define_column(l_cursor,1,v_value,80);
649: l_sql_result := dbms_sql.execute_and_fetch(l_cursor,TRUE);
650: dbms_sql.column_value(l_cursor,1,v_value);
651:

Line 648: dbms_sql.define_column(l_cursor,1,v_value,80);

644: statement => l_select_stmt,
645: language_flag => DBMS_SQL.Native);
646:
647: dbms_sql.bind_variable(l_cursor, ':dim_level_value_id',p_dim_level_value_id);
648: dbms_sql.define_column(l_cursor,1,v_value,80);
649: l_sql_result := dbms_sql.execute_and_fetch(l_cursor,TRUE);
650: dbms_sql.column_value(l_cursor,1,v_value);
651:
652: x_dim_level_value_name := v_value;

Line 649: l_sql_result := dbms_sql.execute_and_fetch(l_cursor,TRUE);

645: language_flag => DBMS_SQL.Native);
646:
647: dbms_sql.bind_variable(l_cursor, ':dim_level_value_id',p_dim_level_value_id);
648: dbms_sql.define_column(l_cursor,1,v_value,80);
649: l_sql_result := dbms_sql.execute_and_fetch(l_cursor,TRUE);
650: dbms_sql.column_value(l_cursor,1,v_value);
651:
652: x_dim_level_value_name := v_value;
653:

Line 650: dbms_sql.column_value(l_cursor,1,v_value);

646:
647: dbms_sql.bind_variable(l_cursor, ':dim_level_value_id',p_dim_level_value_id);
648: dbms_sql.define_column(l_cursor,1,v_value,80);
649: l_sql_result := dbms_sql.execute_and_fetch(l_cursor,TRUE);
650: dbms_sql.column_value(l_cursor,1,v_value);
651:
652: x_dim_level_value_name := v_value;
653:
654: dbms_sql.close_cursor(l_cursor);

Line 654: dbms_sql.close_cursor(l_cursor);

650: dbms_sql.column_value(l_cursor,1,v_value);
651:
652: x_dim_level_value_name := v_value;
653:
654: dbms_sql.close_cursor(l_cursor);
655:
656: EXCEPTION
657:
658: WHEN OTHERS THEN

Line 701: l_cursor := DBMS_SQL.OPEN_CURSOR;

697: select level_values_view_name into l_view_name
698: from bis_levels where level_id = p_dim_level_id;
699: --dbms_output.put_line('view name: '||l_view_name);
700:
701: l_cursor := DBMS_SQL.OPEN_CURSOR;
702:
703: l_select_stmt := 'select v.responsibility_id, v.id, f.user_id '
704: ||' from '||l_view_name||' v, fnd_user_responsibility f '
705: ||' where v.responsibility_id = :responsibility_id '

Line 711: DBMS_SQL.PARSE(c => l_cursor,

707: ||' and f.user_id = :user_id '
708: ||' and v.responsibility_id = f.responsibility_id '
709: ||' and f.start_date <= SYSDATE and nvl(f.end_date,SYSDATE) >= SYSDATE ';
710:
711: DBMS_SQL.PARSE(c => l_cursor,
712: statement => l_select_stmt,
713: language_flag => DBMS_SQL.NATIVE);
714:
715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':responsibility_id',p_responsibility_id);

Line 713: language_flag => DBMS_SQL.NATIVE);

709: ||' and f.start_date <= SYSDATE and nvl(f.end_date,SYSDATE) >= SYSDATE ';
710:
711: DBMS_SQL.PARSE(c => l_cursor,
712: statement => l_select_stmt,
713: language_flag => DBMS_SQL.NATIVE);
714:
715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':responsibility_id',p_responsibility_id);
716: DBMS_SQL.BIND_VARIABLE(l_cursor, ':organization_id',p_organization_id);
717: DBMS_SQL.BIND_VARIABLE(l_cursor, ':user_id',p_user_id);

Line 715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':responsibility_id',p_responsibility_id);

711: DBMS_SQL.PARSE(c => l_cursor,
712: statement => l_select_stmt,
713: language_flag => DBMS_SQL.NATIVE);
714:
715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':responsibility_id',p_responsibility_id);
716: DBMS_SQL.BIND_VARIABLE(l_cursor, ':organization_id',p_organization_id);
717: DBMS_SQL.BIND_VARIABLE(l_cursor, ':user_id',p_user_id);
718:
719: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_resp_id);

Line 716: DBMS_SQL.BIND_VARIABLE(l_cursor, ':organization_id',p_organization_id);

712: statement => l_select_stmt,
713: language_flag => DBMS_SQL.NATIVE);
714:
715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':responsibility_id',p_responsibility_id);
716: DBMS_SQL.BIND_VARIABLE(l_cursor, ':organization_id',p_organization_id);
717: DBMS_SQL.BIND_VARIABLE(l_cursor, ':user_id',p_user_id);
718:
719: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_resp_id);
720: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_org_id);

Line 717: DBMS_SQL.BIND_VARIABLE(l_cursor, ':user_id',p_user_id);

713: language_flag => DBMS_SQL.NATIVE);
714:
715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':responsibility_id',p_responsibility_id);
716: DBMS_SQL.BIND_VARIABLE(l_cursor, ':organization_id',p_organization_id);
717: DBMS_SQL.BIND_VARIABLE(l_cursor, ':user_id',p_user_id);
718:
719: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_resp_id);
720: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_org_id);
721: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_user_id);

Line 719: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_resp_id);

715: DBMS_SQL.BIND_VARIABLE(l_cursor, ':responsibility_id',p_responsibility_id);
716: DBMS_SQL.BIND_VARIABLE(l_cursor, ':organization_id',p_organization_id);
717: DBMS_SQL.BIND_VARIABLE(l_cursor, ':user_id',p_user_id);
718:
719: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_resp_id);
720: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_org_id);
721: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_user_id);
722:
723: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);

Line 720: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_org_id);

716: DBMS_SQL.BIND_VARIABLE(l_cursor, ':organization_id',p_organization_id);
717: DBMS_SQL.BIND_VARIABLE(l_cursor, ':user_id',p_user_id);
718:
719: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_resp_id);
720: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_org_id);
721: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_user_id);
722:
723: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
724:

Line 721: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_user_id);

717: DBMS_SQL.BIND_VARIABLE(l_cursor, ':user_id',p_user_id);
718:
719: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_resp_id);
720: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_org_id);
721: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_user_id);
722:
723: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
724:
725: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_resp_id);

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

719: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_resp_id);
720: DBMS_SQL.DEFINE_COLUMN(l_cursor, 2, l_org_id);
721: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_user_id);
722:
723: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
724:
725: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_resp_id);
726: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_org_id);
727: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_user_id);

Line 725: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_resp_id);

721: DBMS_SQL.DEFINE_COLUMN(l_cursor, 3, l_user_id);
722:
723: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
724:
725: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_resp_id);
726: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_org_id);
727: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_user_id);
728:
729: if DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then

Line 726: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_org_id);

722:
723: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
724:
725: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_resp_id);
726: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_org_id);
727: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_user_id);
728:
729: if DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 727: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_user_id);

723: l_sql_result := DBMS_SQL.EXECUTE(l_cursor);
724:
725: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_resp_id);
726: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_org_id);
727: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_user_id);
728:
729: if DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: else

Line 729: if DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then

725: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_resp_id);
726: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_org_id);
727: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_user_id);
728:
729: if DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: else
732: --dbms_output.put_line('resp id : '||to_char(l_resp_id));
733: --dbms_output.put_line('org id : '||to_char(l_org_id));

Line 737: DBMS_SQL.CLOSE_CURSOR(l_cursor);

733: --dbms_output.put_line('org id : '||to_char(l_org_id));
734: --dbms_output.put_line('user id : '||to_char(l_user_id));
735:
736:
737: DBMS_SQL.CLOSE_CURSOR(l_cursor);
738:
739: end if;
740:
741: EXCEPTION