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

Line 101: l_cursor := DBMS_SQL.OPEN_CURSOR;

97: htp.p('l_sql '||l_sql||'
');
98: *************************************************/
99:
100: -- Now prepare and run the sql query
101: l_cursor := DBMS_SQL.OPEN_CURSOR;
102: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
103: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);

Line 102: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);

98: *************************************************/
99:
100: -- Now prepare and run the sql query
101: l_cursor := DBMS_SQL.OPEN_CURSOR;
102: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
103: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);
106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);

Line 103: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);

99:
100: -- Now prepare and run the sql query
101: l_cursor := DBMS_SQL.OPEN_CURSOR;
102: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
103: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);
106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);
107: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_name,400);

Line 104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);

100: -- Now prepare and run the sql query
101: l_cursor := DBMS_SQL.OPEN_CURSOR;
102: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
103: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);
106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);
107: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_name,400);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,6, l_folder_description,32000);

Line 105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);

101: l_cursor := DBMS_SQL.OPEN_CURSOR;
102: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
103: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);
106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);
107: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_name,400);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,6, l_folder_description,32000);
109: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

Line 106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);

102: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
103: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);
106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);
107: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_name,400);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,6, l_folder_description,32000);
109: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
110:

Line 107: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_name,400);

103: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);
106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);
107: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_name,400);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,6, l_folder_description,32000);
109: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
110:
111: -- Collect the results - folder_id, folder_name and folder_description into

Line 108: DBMS_SQL.DEFINE_COLUMN(l_cursor,6, l_folder_description,32000);

104: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);
106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);
107: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_name,400);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,6, l_folder_description,32000);
109: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
110:
111: -- Collect the results - folder_id, folder_name and folder_description into
112: -- the plsql table to send it back to BIS_BUSINESS_VIEWS_CATALOG packkage

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

105: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_score3);
106: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_id);
107: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_name,400);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,6, l_folder_description,32000);
109: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
110:
111: -- Collect the results - folder_id, folder_name and folder_description into
112: -- the plsql table to send it back to BIS_BUSINESS_VIEWS_CATALOG packkage
113: l_count := 1;

Line 115: l_dummy := DBMS_SQL.FETCH_ROWS(l_cursor);

111: -- Collect the results - folder_id, folder_name and folder_description into
112: -- the plsql table to send it back to BIS_BUSINESS_VIEWS_CATALOG packkage
113: l_count := 1;
114: LOOP
115: l_dummy := DBMS_SQL.FETCH_ROWS(l_cursor);
116: IF (l_dummy = 0) THEN EXIT; END IF;
117: IF (l_count > C_MAX_HITS) THEN EXIT; END IF;
118:
119: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);

Line 119: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);

115: l_dummy := DBMS_SQL.FETCH_ROWS(l_cursor);
116: IF (l_dummy = 0) THEN EXIT; END IF;
117: IF (l_count > C_MAX_HITS) THEN EXIT; END IF;
118:
119: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
120: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
121: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_score3);
122: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_id);
123: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_name);

Line 120: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);

116: IF (l_dummy = 0) THEN EXIT; END IF;
117: IF (l_count > C_MAX_HITS) THEN EXIT; END IF;
118:
119: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
120: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
121: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_score3);
122: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_id);
123: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_name);
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 6, l_folder_description);

Line 121: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_score3);

117: IF (l_count > C_MAX_HITS) THEN EXIT; END IF;
118:
119: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
120: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
121: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_score3);
122: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_id);
123: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_name);
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 6, l_folder_description);
125:

Line 122: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_id);

118:
119: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
120: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
121: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_score3);
122: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_id);
123: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_name);
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 6, l_folder_description);
125:
126: -- Transfer the fetched values from the buffer into the plsql table

Line 123: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_name);

119: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
120: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
121: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_score3);
122: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_id);
123: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_name);
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 6, l_folder_description);
125:
126: -- Transfer the fetched values from the buffer into the plsql table
127: l_results_tbl(l_count).folder_id := l_folder_id;

Line 124: DBMS_SQL.COLUMN_VALUE(l_cursor, 6, l_folder_description);

120: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
121: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_score3);
122: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_id);
123: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_name);
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 6, l_folder_description);
125:
126: -- Transfer the fetched values from the buffer into the plsql table
127: l_results_tbl(l_count).folder_id := l_folder_id;
128: l_results_tbl(l_count).folder_name := l_folder_name;

Line 134: DBMS_SQL.CLOSE_CURSOR(l_cursor);

130: l_count := l_count + 1;
131: END LOOP;
132:
133: -- Close the cursor
134: DBMS_SQL.CLOSE_CURSOR(l_cursor);
135: COMMIT;
136:
137: -- Send this table of results back
138: x_results_tbl := l_results_tbl;