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

Line 106: l_cursor := DBMS_SQL.OPEN_CURSOR;

102: htp.p('l_sql '||l_sql||'
');
103: *************************************************/
104:
105: -- Now prepare and run the sql query
106: l_cursor := DBMS_SQL.OPEN_CURSOR;
107: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
109: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);

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

103: *************************************************/
104:
105: -- Now prepare and run the sql query
106: l_cursor := DBMS_SQL.OPEN_CURSOR;
107: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
109: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);
111: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_name,400);

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

104:
105: -- Now prepare and run the sql query
106: l_cursor := DBMS_SQL.OPEN_CURSOR;
107: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
109: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);
111: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_name,400);
112: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_description,32000);

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

105: -- Now prepare and run the sql query
106: l_cursor := DBMS_SQL.OPEN_CURSOR;
107: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
109: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);
111: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_name,400);
112: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_description,32000);
113:

Line 110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);

106: l_cursor := DBMS_SQL.OPEN_CURSOR;
107: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
109: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);
111: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_name,400);
112: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_description,32000);
113:
114: l_dummy := DBMS_SQL.EXECUTE(l_cursor);

Line 111: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_name,400);

107: DBMS_SQL.PARSE(l_cursor, l_sql, DBMS_SQL.NATIVE);
108: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
109: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);
111: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_name,400);
112: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_description,32000);
113:
114: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
115:

Line 112: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_description,32000);

108: DBMS_SQL.DEFINE_COLUMN(l_cursor,1, l_score1);
109: DBMS_SQL.DEFINE_COLUMN(l_cursor,2, l_score2);
110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);
111: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_name,400);
112: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_description,32000);
113:
114: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
115:
116: -- Collect the results - folder_id, folder_name and folder_description into

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

110: DBMS_SQL.DEFINE_COLUMN(l_cursor,3, l_folder_id);
111: DBMS_SQL.DEFINE_COLUMN(l_cursor,4, l_folder_name,400);
112: DBMS_SQL.DEFINE_COLUMN(l_cursor,5, l_folder_description,32000);
113:
114: l_dummy := DBMS_SQL.EXECUTE(l_cursor);
115:
116: -- Collect the results - folder_id, folder_name and folder_description into
117: -- the plsql table to send it back to BIS_BUSINESS_VIEWS_CATALOG packkage
118: l_count := 1;

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

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

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

120: l_dummy := DBMS_SQL.FETCH_ROWS(l_cursor);
121: IF (l_dummy = 0) THEN EXIT; END IF;
122: IF (l_count > C_MAX_HITS) THEN EXIT; END IF;
123:
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
125: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
126: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_folder_id);
127: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_name);
128: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_description);

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

121: IF (l_dummy = 0) THEN EXIT; END IF;
122: IF (l_count > C_MAX_HITS) THEN EXIT; END IF;
123:
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
125: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
126: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_folder_id);
127: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_name);
128: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_description);
129:

Line 126: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_folder_id);

122: IF (l_count > C_MAX_HITS) THEN EXIT; END IF;
123:
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
125: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
126: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_folder_id);
127: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_name);
128: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_description);
129:
130:

Line 127: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_name);

123:
124: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
125: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
126: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_folder_id);
127: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_name);
128: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_description);
129:
130:
131: -- Transfer the fetched values from the buffer into the plsql table

Line 128: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_description);

124: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_score1);
125: DBMS_SQL.COLUMN_VALUE(l_cursor, 2, l_score2);
126: DBMS_SQL.COLUMN_VALUE(l_cursor, 3, l_folder_id);
127: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, l_folder_name);
128: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, l_folder_description);
129:
130:
131: -- Transfer the fetched values from the buffer into the plsql table
132: l_results_tbl(l_count).folder_id := l_folder_id;

Line 140: DBMS_SQL.CLOSE_CURSOR(l_cursor);

136: l_count := l_count + 1;
137: END LOOP;
138:
139: -- Close the cursor
140: DBMS_SQL.CLOSE_CURSOR(l_cursor);
141: COMMIT;
142:
143: -- Send this table of results back
144: x_results_tbl := l_results_tbl;