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

Line 2126: v_cursorid := dbms_sql.open_cursor;

2122: l_sr_list(l_node_counter).node_type := 10;
2123: l_sr_list(l_node_counter).hide_if_empty := '';
2124: l_sr_list(l_node_counter).node_depth := l_level+2;
2125:
2126: v_cursorid := dbms_sql.open_cursor;
2127: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2128: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2129: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2130: v_dummy := dbms_sql.execute(v_cursorid);

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

2123: l_sr_list(l_node_counter).hide_if_empty := '';
2124: l_sr_list(l_node_counter).node_depth := l_level+2;
2125:
2126: v_cursorid := dbms_sql.open_cursor;
2127: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2128: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2129: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2130: v_dummy := dbms_sql.execute(v_cursorid);
2131:

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

2124: l_sr_list(l_node_counter).node_depth := l_level+2;
2125:
2126: v_cursorid := dbms_sql.open_cursor;
2127: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2128: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2129: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2130: v_dummy := dbms_sql.execute(v_cursorid);
2131:
2132: loop

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

2125:
2126: v_cursorid := dbms_sql.open_cursor;
2127: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2128: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2129: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2130: v_dummy := dbms_sql.execute(v_cursorid);
2131:
2132: loop
2133: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

2126: v_cursorid := dbms_sql.open_cursor;
2127: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2128: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2129: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2130: v_dummy := dbms_sql.execute(v_cursorid);
2131:
2132: loop
2133: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2134: exit;

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

2129: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2130: v_dummy := dbms_sql.execute(v_cursorid);
2131:
2132: loop
2133: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2134: exit;
2135: end if;
2136:
2137: dbms_sql.column_value(v_cursorid, 1, l_meaning);

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

2133: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2134: exit;
2135: end if;
2136:
2137: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2138: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2139: l_where_clause := l_cursor_key_col||' = :seedsubbindvalue';
2140: l_node_counter := l_node_counter + 1;
2141:

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

2134: exit;
2135: end if;
2136:
2137: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2138: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2139: l_where_clause := l_cursor_key_col||' = :seedsubbindvalue';
2140: l_node_counter := l_node_counter + 1;
2141:
2142: l_bind_list(1).bind_var_name := ':seedsubbindvalue';

Line 2174: dbms_sql.close_cursor(v_cursorid);

2170: l_sr_list(l_node_counter).bind_vars := return_value;
2171:
2172: end loop;
2173:
2174: dbms_sql.close_cursor(v_cursorid);
2175:
2176: end if;
2177:
2178: exception

Line 2231: v_cursorid := dbms_sql.open_cursor;

2227: l_sr_list(l_node_counter).node_depth := 2;
2228: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2229: l_sr_list(l_node_counter).bind_vars := return_value;
2230:
2231: v_cursorid := dbms_sql.open_cursor;
2232: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2233: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2234: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2235: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);

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

2228: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2229: l_sr_list(l_node_counter).bind_vars := return_value;
2230:
2231: v_cursorid := dbms_sql.open_cursor;
2232: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2233: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2234: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2235: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2236: v_dummy := dbms_sql.execute(v_cursorid);

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

2229: l_sr_list(l_node_counter).bind_vars := return_value;
2230:
2231: v_cursorid := dbms_sql.open_cursor;
2232: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2233: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2234: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2235: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2236: v_dummy := dbms_sql.execute(v_cursorid);
2237:

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

2230:
2231: v_cursorid := dbms_sql.open_cursor;
2232: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2233: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2234: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2235: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2236: v_dummy := dbms_sql.execute(v_cursorid);
2237:
2238: loop

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

2231: v_cursorid := dbms_sql.open_cursor;
2232: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2233: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2234: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2235: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2236: v_dummy := dbms_sql.execute(v_cursorid);
2237:
2238: loop
2239: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

2232: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2233: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2234: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2235: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2236: v_dummy := dbms_sql.execute(v_cursorid);
2237:
2238: loop
2239: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2240: exit;

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

2235: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2236: v_dummy := dbms_sql.execute(v_cursorid);
2237:
2238: loop
2239: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2240: exit;
2241: end if;
2242: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2243: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);

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

2238: loop
2239: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2240: exit;
2241: end if;
2242: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2243: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2244: l_where_clause := l_cursor_key_col||' = :bindvalue';
2245: l_node_counter := l_node_counter + 1;
2246:

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

2239: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2240: exit;
2241: end if;
2242: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2243: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2244: l_where_clause := l_cursor_key_col||' = :bindvalue';
2245: l_node_counter := l_node_counter + 1;
2246:
2247: l_bind_list(1).bind_var_name := ':bindvalue';

Line 2265: dbms_sql.close_cursor(v_cursorid);

2261: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2262: l_sr_list(l_node_counter).bind_vars := return_value;
2263: end loop;
2264:
2265: dbms_sql.close_cursor(v_cursorid);
2266:
2267: end if; -- End of if at cursor_sql is not null
2268: end loop; -- End of loop for cur_seed_cursor
2269:

Line 2359: v_cursorid := dbms_sql.open_cursor;

2355: l_sr_list(l_node_counter).node_type := 10;
2356: l_sr_list(l_node_counter).hide_if_empty := '';
2357: l_sr_list(l_node_counter).node_depth := l_level+2;
2358:
2359: v_cursorid := dbms_sql.open_cursor;
2360: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2361: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2362: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2363: v_dummy := dbms_sql.execute(v_cursorid);

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

2356: l_sr_list(l_node_counter).hide_if_empty := '';
2357: l_sr_list(l_node_counter).node_depth := l_level+2;
2358:
2359: v_cursorid := dbms_sql.open_cursor;
2360: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2361: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2362: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2363: v_dummy := dbms_sql.execute(v_cursorid);
2364:

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

2357: l_sr_list(l_node_counter).node_depth := l_level+2;
2358:
2359: v_cursorid := dbms_sql.open_cursor;
2360: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2361: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2362: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2363: v_dummy := dbms_sql.execute(v_cursorid);
2364:
2365: loop

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

2358:
2359: v_cursorid := dbms_sql.open_cursor;
2360: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2361: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2362: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2363: v_dummy := dbms_sql.execute(v_cursorid);
2364:
2365: loop
2366: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

2359: v_cursorid := dbms_sql.open_cursor;
2360: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2361: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2362: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2363: v_dummy := dbms_sql.execute(v_cursorid);
2364:
2365: loop
2366: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2367: exit;

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

2362: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2363: v_dummy := dbms_sql.execute(v_cursorid);
2364:
2365: loop
2366: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2367: exit;
2368: end if;
2369:
2370: dbms_sql.column_value(v_cursorid, 1, l_meaning);

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

2366: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2367: exit;
2368: end if;
2369:
2370: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2371: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2372: l_where_clause := l_cursor_key_col||' = :customsubbindvalue';
2373: l_node_counter := l_node_counter + 1;
2374:

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

2367: exit;
2368: end if;
2369:
2370: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2371: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2372: l_where_clause := l_cursor_key_col||' = :customsubbindvalue';
2373: l_node_counter := l_node_counter + 1;
2374:
2375: l_bind_list(1).bind_var_name := ':customsubbindvalue';

Line 2394: dbms_sql.close_cursor(v_cursorid);

2390: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2391: l_sr_list(l_node_counter).bind_vars := return_value;
2392: end loop;
2393:
2394: dbms_sql.close_cursor(v_cursorid);
2395:
2396: end if;
2397:
2398: exception

Line 2647: v_cursorid := dbms_sql.open_cursor;

2643: l_sr_list(l_node_counter).node_type := 10;
2644: l_sr_list(l_node_counter).hide_if_empty := '';
2645: l_sr_list(l_node_counter).node_depth := l_level+2;
2646:
2647: v_cursorid := dbms_sql.open_cursor;
2648: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2649: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2650: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2651: v_dummy := dbms_sql.execute(v_cursorid);

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

2644: l_sr_list(l_node_counter).hide_if_empty := '';
2645: l_sr_list(l_node_counter).node_depth := l_level+2;
2646:
2647: v_cursorid := dbms_sql.open_cursor;
2648: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2649: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2650: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2651: v_dummy := dbms_sql.execute(v_cursorid);
2652:

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

2645: l_sr_list(l_node_counter).node_depth := l_level+2;
2646:
2647: v_cursorid := dbms_sql.open_cursor;
2648: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2649: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2650: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2651: v_dummy := dbms_sql.execute(v_cursorid);
2652:
2653: loop

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

2646:
2647: v_cursorid := dbms_sql.open_cursor;
2648: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2649: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2650: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2651: v_dummy := dbms_sql.execute(v_cursorid);
2652:
2653: loop
2654: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

2647: v_cursorid := dbms_sql.open_cursor;
2648: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2649: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2650: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2651: v_dummy := dbms_sql.execute(v_cursorid);
2652:
2653: loop
2654: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2655: exit;

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

2650: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2651: v_dummy := dbms_sql.execute(v_cursorid);
2652:
2653: loop
2654: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2655: exit;
2656: end if;
2657:
2658: dbms_sql.column_value(v_cursorid, 1, l_meaning);

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

2654: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2655: exit;
2656: end if;
2657:
2658: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2659: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2660: l_where_clause := l_cursor_key_col||' = :seedsubbindvalue';
2661: l_node_counter := l_node_counter + 1;
2662:

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

2655: exit;
2656: end if;
2657:
2658: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2659: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2660: l_where_clause := l_cursor_key_col||' = :seedsubbindvalue';
2661: l_node_counter := l_node_counter + 1;
2662:
2663: l_bind_list(1).bind_var_name := ':seedsubbindvalue';

Line 2696: dbms_sql.close_cursor(v_cursorid);

2692: l_sr_list(l_node_counter).bind_vars := return_value;
2693:
2694: end loop;
2695:
2696: dbms_sql.close_cursor(v_cursorid);
2697:
2698: end if;
2699:
2700: exception

Line 2754: v_cursorid := dbms_sql.open_cursor;

2750: l_sr_list(l_node_counter).node_depth := 2;
2751: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2752: l_sr_list(l_node_counter).bind_vars := return_value;
2753:
2754: v_cursorid := dbms_sql.open_cursor;
2755: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2756: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2757: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2758: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);

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

2751: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2752: l_sr_list(l_node_counter).bind_vars := return_value;
2753:
2754: v_cursorid := dbms_sql.open_cursor;
2755: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2756: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2757: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2758: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2759: v_dummy := dbms_sql.execute(v_cursorid);

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

2752: l_sr_list(l_node_counter).bind_vars := return_value;
2753:
2754: v_cursorid := dbms_sql.open_cursor;
2755: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2756: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2757: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2758: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2759: v_dummy := dbms_sql.execute(v_cursorid);
2760:

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

2753:
2754: v_cursorid := dbms_sql.open_cursor;
2755: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2756: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2757: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2758: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2759: v_dummy := dbms_sql.execute(v_cursorid);
2760:
2761: loop

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

2754: v_cursorid := dbms_sql.open_cursor;
2755: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2756: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2757: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2758: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2759: v_dummy := dbms_sql.execute(v_cursorid);
2760:
2761: loop
2762: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

2755: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2756: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2757: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2758: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2759: v_dummy := dbms_sql.execute(v_cursorid);
2760:
2761: loop
2762: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2763: exit;

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

2758: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
2759: v_dummy := dbms_sql.execute(v_cursorid);
2760:
2761: loop
2762: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2763: exit;
2764: end if;
2765: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2766: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);

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

2761: loop
2762: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2763: exit;
2764: end if;
2765: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2766: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2767: l_where_clause := l_cursor_key_col||' = :bindvalue';
2768: l_node_counter := l_node_counter + 1;
2769:

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

2762: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2763: exit;
2764: end if;
2765: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2766: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2767: l_where_clause := l_cursor_key_col||' = :bindvalue';
2768: l_node_counter := l_node_counter + 1;
2769:
2770: l_bind_list(1).bind_var_name := ':bindvalue';

Line 2788: dbms_sql.close_cursor(v_cursorid);

2784: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2785: l_sr_list(l_node_counter).bind_vars := return_value;
2786: end loop;
2787:
2788: dbms_sql.close_cursor(v_cursorid);
2789:
2790: end if; -- End of if at cursor_sql is not null
2791: end loop; -- End of loop for cur_seed_cursor
2792:

Line 2884: v_cursorid := dbms_sql.open_cursor;

2880: l_sr_list(l_node_counter).node_type := 10;
2881: l_sr_list(l_node_counter).hide_if_empty := '';
2882: l_sr_list(l_node_counter).node_depth := l_level+2;
2883:
2884: v_cursorid := dbms_sql.open_cursor;
2885: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2886: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2887: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2888: v_dummy := dbms_sql.execute(v_cursorid);

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

2881: l_sr_list(l_node_counter).hide_if_empty := '';
2882: l_sr_list(l_node_counter).node_depth := l_level+2;
2883:
2884: v_cursorid := dbms_sql.open_cursor;
2885: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2886: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2887: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2888: v_dummy := dbms_sql.execute(v_cursorid);
2889:

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

2882: l_sr_list(l_node_counter).node_depth := l_level+2;
2883:
2884: v_cursorid := dbms_sql.open_cursor;
2885: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2886: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2887: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2888: v_dummy := dbms_sql.execute(v_cursorid);
2889:
2890: loop

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

2883:
2884: v_cursorid := dbms_sql.open_cursor;
2885: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2886: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2887: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2888: v_dummy := dbms_sql.execute(v_cursorid);
2889:
2890: loop
2891: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

2884: v_cursorid := dbms_sql.open_cursor;
2885: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
2886: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
2887: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2888: v_dummy := dbms_sql.execute(v_cursorid);
2889:
2890: loop
2891: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2892: exit;

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

2887: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
2888: v_dummy := dbms_sql.execute(v_cursorid);
2889:
2890: loop
2891: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2892: exit;
2893: end if;
2894:
2895: dbms_sql.column_value(v_cursorid, 1, l_meaning);

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

2891: if dbms_sql.fetch_rows(v_cursorid) = 0 then
2892: exit;
2893: end if;
2894:
2895: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2896: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2897: l_where_clause := l_cursor_key_col||' = :customsubbindvalue';
2898: l_node_counter := l_node_counter + 1;
2899:

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

2892: exit;
2893: end if;
2894:
2895: dbms_sql.column_value(v_cursorid, 1, l_meaning);
2896: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
2897: l_where_clause := l_cursor_key_col||' = :customsubbindvalue';
2898: l_node_counter := l_node_counter + 1;
2899:
2900: l_bind_list(1).bind_var_name := ':customsubbindvalue';

Line 2919: dbms_sql.close_cursor(v_cursorid);

2915: return_value := ieu_pub.set_bind_var_data(l_bind_list);
2916: l_sr_list(l_node_counter).bind_vars := return_value;
2917: end loop;
2918:
2919: dbms_sql.close_cursor(v_cursorid);
2920:
2921: end if;
2922:
2923: exception

Line 3174: v_cursorid := dbms_sql.open_cursor;

3170: l_sr_list(l_node_counter).node_type := 10;
3171: l_sr_list(l_node_counter).hide_if_empty := '';
3172: l_sr_list(l_node_counter).node_depth := l_level+2;
3173:
3174: v_cursorid := dbms_sql.open_cursor;
3175: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3176: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3177: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3178: v_dummy := dbms_sql.execute(v_cursorid);

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

3171: l_sr_list(l_node_counter).hide_if_empty := '';
3172: l_sr_list(l_node_counter).node_depth := l_level+2;
3173:
3174: v_cursorid := dbms_sql.open_cursor;
3175: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3176: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3177: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3178: v_dummy := dbms_sql.execute(v_cursorid);
3179:

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

3172: l_sr_list(l_node_counter).node_depth := l_level+2;
3173:
3174: v_cursorid := dbms_sql.open_cursor;
3175: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3176: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3177: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3178: v_dummy := dbms_sql.execute(v_cursorid);
3179:
3180: loop

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

3173:
3174: v_cursorid := dbms_sql.open_cursor;
3175: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3176: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3177: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3178: v_dummy := dbms_sql.execute(v_cursorid);
3179:
3180: loop
3181: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

3174: v_cursorid := dbms_sql.open_cursor;
3175: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3176: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3177: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3178: v_dummy := dbms_sql.execute(v_cursorid);
3179:
3180: loop
3181: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3182: exit;

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

3177: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3178: v_dummy := dbms_sql.execute(v_cursorid);
3179:
3180: loop
3181: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3182: exit;
3183: end if;
3184:
3185: dbms_sql.column_value(v_cursorid, 1, l_meaning);

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

3181: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3182: exit;
3183: end if;
3184:
3185: dbms_sql.column_value(v_cursorid, 1, l_meaning);
3186: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
3187: l_where_clause := l_cursor_key_col||' = :seedsubbindvalue';
3188: l_node_counter := l_node_counter + 1;
3189:

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

3182: exit;
3183: end if;
3184:
3185: dbms_sql.column_value(v_cursorid, 1, l_meaning);
3186: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
3187: l_where_clause := l_cursor_key_col||' = :seedsubbindvalue';
3188: l_node_counter := l_node_counter + 1;
3189:
3190: l_bind_list(1).bind_var_name := ':seedsubbindvalue';

Line 3222: dbms_sql.close_cursor(v_cursorid);

3218: l_sr_list(l_node_counter).bind_vars := return_value;
3219:
3220: end loop;
3221:
3222: dbms_sql.close_cursor(v_cursorid);
3223:
3224: end if;
3225:
3226: exception

Line 3280: v_cursorid := dbms_sql.open_cursor;

3276: l_sr_list(l_node_counter).node_depth := 2;
3277: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3278: l_sr_list(l_node_counter).bind_vars := return_value;
3279:
3280: v_cursorid := dbms_sql.open_cursor;
3281: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3282: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3283: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3284: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);

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

3277: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3278: l_sr_list(l_node_counter).bind_vars := return_value;
3279:
3280: v_cursorid := dbms_sql.open_cursor;
3281: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3282: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3283: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3284: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
3285: v_dummy := dbms_sql.execute(v_cursorid);

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

3278: l_sr_list(l_node_counter).bind_vars := return_value;
3279:
3280: v_cursorid := dbms_sql.open_cursor;
3281: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3282: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3283: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3284: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
3285: v_dummy := dbms_sql.execute(v_cursorid);
3286:

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

3279:
3280: v_cursorid := dbms_sql.open_cursor;
3281: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3282: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3283: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3284: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
3285: v_dummy := dbms_sql.execute(v_cursorid);
3286:
3287: loop

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

3280: v_cursorid := dbms_sql.open_cursor;
3281: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3282: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3283: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3284: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
3285: v_dummy := dbms_sql.execute(v_cursorid);
3286:
3287: loop
3288: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

3281: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3282: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3283: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3284: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
3285: v_dummy := dbms_sql.execute(v_cursorid);
3286:
3287: loop
3288: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3289: exit;

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

3284: dbms_sql.bind_variable(v_cursorid, ':OWNER_ID', p_resource_id);
3285: v_dummy := dbms_sql.execute(v_cursorid);
3286:
3287: loop
3288: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3289: exit;
3290: end if;
3291: dbms_sql.column_value(v_cursorid, 1, l_meaning);
3292: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);

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

3287: loop
3288: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3289: exit;
3290: end if;
3291: dbms_sql.column_value(v_cursorid, 1, l_meaning);
3292: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
3293: l_where_clause := l_cursor_key_col||' = :bindvalue';
3294: l_node_counter := l_node_counter + 1;
3295:

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

3288: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3289: exit;
3290: end if;
3291: dbms_sql.column_value(v_cursorid, 1, l_meaning);
3292: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
3293: l_where_clause := l_cursor_key_col||' = :bindvalue';
3294: l_node_counter := l_node_counter + 1;
3295:
3296: l_bind_list(1).bind_var_name := ':bindvalue';

Line 3314: dbms_sql.close_cursor(v_cursorid);

3310: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3311: l_sr_list(l_node_counter).bind_vars := return_value;
3312: end loop;
3313:
3314: dbms_sql.close_cursor(v_cursorid);
3315:
3316: end if; -- End of if at cursor_sql is not null
3317: end loop; -- End of loop for cur_seed_cursor
3318:

Line 3408: v_cursorid := dbms_sql.open_cursor;

3404: l_sr_list(l_node_counter).node_type := 10;
3405: l_sr_list(l_node_counter).hide_if_empty := '';
3406: l_sr_list(l_node_counter).node_depth := l_level+2;
3407:
3408: v_cursorid := dbms_sql.open_cursor;
3409: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3410: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3411: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3412: v_dummy := dbms_sql.execute(v_cursorid);

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

3405: l_sr_list(l_node_counter).hide_if_empty := '';
3406: l_sr_list(l_node_counter).node_depth := l_level+2;
3407:
3408: v_cursorid := dbms_sql.open_cursor;
3409: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3410: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3411: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3412: v_dummy := dbms_sql.execute(v_cursorid);
3413:

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

3406: l_sr_list(l_node_counter).node_depth := l_level+2;
3407:
3408: v_cursorid := dbms_sql.open_cursor;
3409: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3410: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3411: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3412: v_dummy := dbms_sql.execute(v_cursorid);
3413:
3414: loop

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

3407:
3408: v_cursorid := dbms_sql.open_cursor;
3409: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3410: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3411: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3412: v_dummy := dbms_sql.execute(v_cursorid);
3413:
3414: loop
3415: if dbms_sql.fetch_rows(v_cursorid) = 0 then

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

3408: v_cursorid := dbms_sql.open_cursor;
3409: dbms_sql.parse(v_cursorid, l_cursor_sql, DBMS_SQL.V7);
3410: dbms_sql.define_column(v_cursorid, 1, l_meaning, 360);--5579863
3411: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3412: v_dummy := dbms_sql.execute(v_cursorid);
3413:
3414: loop
3415: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3416: exit;

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

3411: dbms_sql.define_column(v_cursorid, 2, l_id_of_value);
3412: v_dummy := dbms_sql.execute(v_cursorid);
3413:
3414: loop
3415: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3416: exit;
3417: end if;
3418:
3419: dbms_sql.column_value(v_cursorid, 1, l_meaning);

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

3415: if dbms_sql.fetch_rows(v_cursorid) = 0 then
3416: exit;
3417: end if;
3418:
3419: dbms_sql.column_value(v_cursorid, 1, l_meaning);
3420: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
3421: l_where_clause := l_cursor_key_col||' = :customsubbindvalue';
3422: l_node_counter := l_node_counter + 1;
3423:

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

3416: exit;
3417: end if;
3418:
3419: dbms_sql.column_value(v_cursorid, 1, l_meaning);
3420: dbms_sql.column_value(v_cursorid, 2, l_id_of_value);
3421: l_where_clause := l_cursor_key_col||' = :customsubbindvalue';
3422: l_node_counter := l_node_counter + 1;
3423:
3424: l_bind_list(1).bind_var_name := ':customsubbindvalue';

Line 3443: dbms_sql.close_cursor(v_cursorid);

3439: return_value := ieu_pub.set_bind_var_data(l_bind_list);
3440: l_sr_list(l_node_counter).bind_vars := return_value;
3441: end loop;
3442:
3443: dbms_sql.close_cursor(v_cursorid);
3444:
3445: end if;
3446:
3447: exception