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.SR_UWQ_INTEG dependencies on DBMS_SQL

Line 581: v_cursorid := dbms_sql.open_cursor;

577: l_sr_list(l_node_counter).node_type := 10;
578: l_sr_list(l_node_counter).hide_if_empty := '';
579: l_sr_list(l_node_counter).node_depth := l_level+2;
580:
581: v_cursorid := dbms_sql.open_cursor;
582: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
583: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
584: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
585: v_dummy := dbms_sql.execute(v_cursorid);

Line 582: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);

578: l_sr_list(l_node_counter).hide_if_empty := '';
579: l_sr_list(l_node_counter).node_depth := l_level+2;
580:
581: v_cursorid := dbms_sql.open_cursor;
582: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
583: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
584: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
585: v_dummy := dbms_sql.execute(v_cursorid);
586:

Line 583: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863

579: l_sr_list(l_node_counter).node_depth := l_level+2;
580:
581: v_cursorid := dbms_sql.open_cursor;
582: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
583: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
584: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
585: v_dummy := dbms_sql.execute(v_cursorid);
586:
587: loop

Line 584: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);

580:
581: v_cursorid := dbms_sql.open_cursor;
582: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
583: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
584: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
585: v_dummy := dbms_sql.execute(v_cursorid);
586:
587: loop
588: if dbms_sql.fetch_rows(v_cursorid) = 0 then

Line 585: v_dummy := dbms_sql.execute(v_cursorid);

581: v_cursorid := dbms_sql.open_cursor;
582: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
583: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
584: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
585: v_dummy := dbms_sql.execute(v_cursorid);
586:
587: loop
588: if dbms_sql.fetch_rows(v_cursorid) = 0 then
589: exit;

Line 588: if dbms_sql.fetch_rows(v_cursorid) = 0 then

584: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
585: v_dummy := dbms_sql.execute(v_cursorid);
586:
587: loop
588: if dbms_sql.fetch_rows(v_cursorid) = 0 then
589: exit;
590: end if;
591:
592: dbms_sql.column_value(v_cursorid, 1, l_meaning);

Line 592: dbms_sql.column_value(v_cursorid, 1, l_meaning);

588: if dbms_sql.fetch_rows(v_cursorid) = 0 then
589: exit;
590: end if;
591:
592: dbms_sql.column_value(v_cursorid, 1, l_meaning);
593: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
594: l_where_clause := l_cursor_key_col||' = :seedsubbindvalue';
595: l_node_counter := l_node_counter + 1;
596:

Line 593: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);

589: exit;
590: end if;
591:
592: dbms_sql.column_value(v_cursorid, 1, l_meaning);
593: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
594: l_where_clause := l_cursor_key_col||' = :seedsubbindvalue';
595: l_node_counter := l_node_counter + 1;
596:
597: l_bind_list(1).bind_var_name := ':seedsubbindvalue';

Line 618: dbms_sql.close_cursor(v_cursorid);

614: l_sr_list(l_node_counter).bind_vars := return_value;
615:
616: end loop;
617:
618: dbms_sql.close_cursor(v_cursorid);
619:
620: end if;
621:
622: exception

Line 665: v_cursorid := dbms_sql.open_cursor;

661: l_sr_list(l_node_counter).node_depth := 2;
662: return_value := ieu_pub.set_bind_var_data(l_bind_list);
663: l_sr_list(l_node_counter).bind_vars := return_value;
664:
665: v_cursorid := dbms_sql.open_cursor;
666: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
667: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
668: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
669: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);

Line 666: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);

662: return_value := ieu_pub.set_bind_var_data(l_bind_list);
663: l_sr_list(l_node_counter).bind_vars := return_value;
664:
665: v_cursorid := dbms_sql.open_cursor;
666: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
667: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
668: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
669: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
670: v_dummy := dbms_sql.execute(v_cursorid);

Line 667: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863

663: l_sr_list(l_node_counter).bind_vars := return_value;
664:
665: v_cursorid := dbms_sql.open_cursor;
666: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
667: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
668: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
669: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
670: v_dummy := dbms_sql.execute(v_cursorid);
671:

Line 668: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);

664:
665: v_cursorid := dbms_sql.open_cursor;
666: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
667: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
668: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
669: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
670: v_dummy := dbms_sql.execute(v_cursorid);
671:
672: loop

Line 669: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);

665: v_cursorid := dbms_sql.open_cursor;
666: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
667: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
668: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
669: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
670: v_dummy := dbms_sql.execute(v_cursorid);
671:
672: loop
673: if dbms_sql.fetch_rows(v_cursorid) = 0 then

Line 670: v_dummy := dbms_sql.execute(v_cursorid);

666: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
667: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
668: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
669: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
670: v_dummy := dbms_sql.execute(v_cursorid);
671:
672: loop
673: if dbms_sql.fetch_rows(v_cursorid) = 0 then
674: exit;

Line 673: if dbms_sql.fetch_rows(v_cursorid) = 0 then

669: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
670: v_dummy := dbms_sql.execute(v_cursorid);
671:
672: loop
673: if dbms_sql.fetch_rows(v_cursorid) = 0 then
674: exit;
675: end if;
676: dbms_sql.column_value(v_cursorid, 1, l_meaning);
677: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);

Line 676: dbms_sql.column_value(v_cursorid, 1, l_meaning);

672: loop
673: if dbms_sql.fetch_rows(v_cursorid) = 0 then
674: exit;
675: end if;
676: dbms_sql.column_value(v_cursorid, 1, l_meaning);
677: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
678: l_where_clause := l_cursor_key_col||' = :bindvalue';
679: l_node_counter := l_node_counter + 1;
680:

Line 677: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);

673: if dbms_sql.fetch_rows(v_cursorid) = 0 then
674: exit;
675: end if;
676: dbms_sql.column_value(v_cursorid, 1, l_meaning);
677: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
678: l_where_clause := l_cursor_key_col||' = :bindvalue';
679: l_node_counter := l_node_counter + 1;
680:
681: l_bind_list(1).bind_var_name := ':bindvalue';

Line 699: dbms_sql.close_cursor(v_cursorid);

695: return_value := ieu_pub.set_bind_var_data(l_bind_list);
696: l_sr_list(l_node_counter).bind_vars := return_value;
697: end loop;
698:
699: dbms_sql.close_cursor(v_cursorid);
700:
701: end if; -- End of if at cursor_sql is not null
702: end loop; -- End of loop for cur_seed_cursor
703:

Line 773: v_cursorid := dbms_sql.open_cursor;

769: l_sr_list(l_node_counter).node_type := 10;
770: l_sr_list(l_node_counter).hide_if_empty := '';
771: l_sr_list(l_node_counter).node_depth := l_level+2;
772:
773: v_cursorid := dbms_sql.open_cursor;
774: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
775: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
776: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
777: v_dummy := dbms_sql.execute(v_cursorid);

Line 774: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);

770: l_sr_list(l_node_counter).hide_if_empty := '';
771: l_sr_list(l_node_counter).node_depth := l_level+2;
772:
773: v_cursorid := dbms_sql.open_cursor;
774: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
775: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
776: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
777: v_dummy := dbms_sql.execute(v_cursorid);
778:

Line 775: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863

771: l_sr_list(l_node_counter).node_depth := l_level+2;
772:
773: v_cursorid := dbms_sql.open_cursor;
774: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
775: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
776: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
777: v_dummy := dbms_sql.execute(v_cursorid);
778:
779: loop

Line 776: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);

772:
773: v_cursorid := dbms_sql.open_cursor;
774: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
775: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
776: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
777: v_dummy := dbms_sql.execute(v_cursorid);
778:
779: loop
780: if dbms_sql.fetch_rows(v_cursorid) = 0 then

Line 777: v_dummy := dbms_sql.execute(v_cursorid);

773: v_cursorid := dbms_sql.open_cursor;
774: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
775: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
776: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
777: v_dummy := dbms_sql.execute(v_cursorid);
778:
779: loop
780: if dbms_sql.fetch_rows(v_cursorid) = 0 then
781: exit;

Line 780: if dbms_sql.fetch_rows(v_cursorid) = 0 then

776: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
777: v_dummy := dbms_sql.execute(v_cursorid);
778:
779: loop
780: if dbms_sql.fetch_rows(v_cursorid) = 0 then
781: exit;
782: end if;
783:
784: dbms_sql.column_value(v_cursorid, 1, l_meaning);

Line 784: dbms_sql.column_value(v_cursorid, 1, l_meaning);

780: if dbms_sql.fetch_rows(v_cursorid) = 0 then
781: exit;
782: end if;
783:
784: dbms_sql.column_value(v_cursorid, 1, l_meaning);
785: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
786: l_where_clause := l_cursor_key_col||' = :customsubbindvalue';
787: l_node_counter := l_node_counter + 1;
788:

Line 785: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);

781: exit;
782: end if;
783:
784: dbms_sql.column_value(v_cursorid, 1, l_meaning);
785: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
786: l_where_clause := l_cursor_key_col||' = :customsubbindvalue';
787: l_node_counter := l_node_counter + 1;
788:
789: l_bind_list(1).bind_var_name := ':customsubbindvalue';

Line 807: dbms_sql.close_cursor(v_cursorid);

803: return_value := ieu_pub.set_bind_var_data(l_bind_list);
804: l_sr_list(l_node_counter).bind_vars := return_value;
805: end loop;
806:
807: dbms_sql.close_cursor(v_cursorid);
808:
809: end if;
810:
811: exception