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

Line 55: g_cursor := DBMS_SQL.OPEN_CURSOR;

51:
52: BIS_DEBUG_PUB.Add('> init_string_generator');
53: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
54: l_statement := l_statement || '''' || p_View_Name || '''';
55: g_cursor := DBMS_SQL.OPEN_CURSOR;
56: DBMS_SQL.PARSE(g_cursor, l_statement, DBMS_SQL.NATIVE);
57: DBMS_SQL.DEFINE_COLUMN_LONG(g_cursor, 1);
58: l_dummy := DBMS_SQL.EXECUTE(g_cursor);
59: l_dummy := DBMS_SQL.FETCH_ROWS(g_cursor);

Line 56: DBMS_SQL.PARSE(g_cursor, l_statement, DBMS_SQL.NATIVE);

52: BIS_DEBUG_PUB.Add('> init_string_generator');
53: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
54: l_statement := l_statement || '''' || p_View_Name || '''';
55: g_cursor := DBMS_SQL.OPEN_CURSOR;
56: DBMS_SQL.PARSE(g_cursor, l_statement, DBMS_SQL.NATIVE);
57: DBMS_SQL.DEFINE_COLUMN_LONG(g_cursor, 1);
58: l_dummy := DBMS_SQL.EXECUTE(g_cursor);
59: l_dummy := DBMS_SQL.FETCH_ROWS(g_cursor);
60: g_current_posn := 0;

Line 57: DBMS_SQL.DEFINE_COLUMN_LONG(g_cursor, 1);

53: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
54: l_statement := l_statement || '''' || p_View_Name || '''';
55: g_cursor := DBMS_SQL.OPEN_CURSOR;
56: DBMS_SQL.PARSE(g_cursor, l_statement, DBMS_SQL.NATIVE);
57: DBMS_SQL.DEFINE_COLUMN_LONG(g_cursor, 1);
58: l_dummy := DBMS_SQL.EXECUTE(g_cursor);
59: l_dummy := DBMS_SQL.FETCH_ROWS(g_cursor);
60: g_current_posn := 0;
61: BIS_DEBUG_PUB.Add('< init_string_generator');

Line 58: l_dummy := DBMS_SQL.EXECUTE(g_cursor);

54: l_statement := l_statement || '''' || p_View_Name || '''';
55: g_cursor := DBMS_SQL.OPEN_CURSOR;
56: DBMS_SQL.PARSE(g_cursor, l_statement, DBMS_SQL.NATIVE);
57: DBMS_SQL.DEFINE_COLUMN_LONG(g_cursor, 1);
58: l_dummy := DBMS_SQL.EXECUTE(g_cursor);
59: l_dummy := DBMS_SQL.FETCH_ROWS(g_cursor);
60: g_current_posn := 0;
61: BIS_DEBUG_PUB.Add('< init_string_generator');
62:

Line 59: l_dummy := DBMS_SQL.FETCH_ROWS(g_cursor);

55: g_cursor := DBMS_SQL.OPEN_CURSOR;
56: DBMS_SQL.PARSE(g_cursor, l_statement, DBMS_SQL.NATIVE);
57: DBMS_SQL.DEFINE_COLUMN_LONG(g_cursor, 1);
58: l_dummy := DBMS_SQL.EXECUTE(g_cursor);
59: l_dummy := DBMS_SQL.FETCH_ROWS(g_cursor);
60: g_current_posn := 0;
61: BIS_DEBUG_PUB.Add('< init_string_generator');
62:
63:

Line 109: DBMS_SQL.COLUMN_VALUE_LONG( g_cursor

105: l_chunk_size_ret INTEGER;
106: BEGIN
107: BIS_DEBUG_PUB.Add('> String_Generator_Get_String');
108: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
109: DBMS_SQL.COLUMN_VALUE_LONG( g_cursor
110: , 1
111: , p_chunk_size
112: , g_current_posn
113: , x_string

Line 204: DBMS_SQL.CLOSE_CURSOR(g_cursor);

200: x_View_Select_Text_Table(x_View_Select_Text_Table.COUNT + 1):= l_string;
201:
202: END LOOP;
203:
204: DBMS_SQL.CLOSE_CURSOR(g_cursor);
205:
206: BIS_DEBUG_PUB.Add('< create_View_Select_Text_Table');
207:
208:

Line 211: DBMS_SQL.CLOSE_CURSOR(g_cursor);

207:
208:
209: EXCEPTION
210: when FND_API.G_EXC_ERROR then
211: DBMS_SQL.CLOSE_CURSOR(g_cursor);
212:
213: RAISE FND_API.G_EXC_ERROR;
214: when FND_API.G_EXC_UNEXPECTED_ERROR then
215: DBMS_SQL.CLOSE_CURSOR(g_cursor);

Line 215: DBMS_SQL.CLOSE_CURSOR(g_cursor);

211: DBMS_SQL.CLOSE_CURSOR(g_cursor);
212:
213: RAISE FND_API.G_EXC_ERROR;
214: when FND_API.G_EXC_UNEXPECTED_ERROR then
215: DBMS_SQL.CLOSE_CURSOR(g_cursor);
216:
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: when others then
219: DBMS_SQL.CLOSE_CURSOR(g_cursor);

Line 219: DBMS_SQL.CLOSE_CURSOR(g_cursor);

215: DBMS_SQL.CLOSE_CURSOR(g_cursor);
216:
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: when others then
219: DBMS_SQL.CLOSE_CURSOR(g_cursor);
220:
221: BIS_VG_UTIL.Add_Error_Message
222: ( p_error_msg_id => SQLCODE
223: , p_error_description => SQLERRM

Line 445: DBMS_SQL.CLOSE_CURSOR(g_cursor);

441: END IF;
442:
443: END LOOP;
444:
445: DBMS_SQL.CLOSE_CURSOR(g_cursor);
446:
447: BIS_DEBUG_PUB.Add('< valid_view');
448:
449: RETURN l_found;

Line 455: dbms_sql.close_cursor(g_cursor);

451:
452: EXCEPTION
453: when FND_API.G_EXC_ERROR then
454: x_return_status := FND_API.G_RET_STS_ERROR ;
455: dbms_sql.close_cursor(g_cursor);
456: RAISE FND_API.G_EXC_ERROR;
457: when FND_API.G_EXC_UNEXPECTED_ERROR then
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: dbms_sql.close_cursor(g_cursor);

Line 459: dbms_sql.close_cursor(g_cursor);

455: dbms_sql.close_cursor(g_cursor);
456: RAISE FND_API.G_EXC_ERROR;
457: when FND_API.G_EXC_UNEXPECTED_ERROR then
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: dbms_sql.close_cursor(g_cursor);
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: when others then
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
463: dbms_sql.close_cursor(g_cursor);

Line 463: dbms_sql.close_cursor(g_cursor);

459: dbms_sql.close_cursor(g_cursor);
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: when others then
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
463: dbms_sql.close_cursor(g_cursor);
464: BIS_VG_UTIL.Add_Error_Message
465: ( p_error_msg_id => SQLCODE
466: , p_error_description => SQLERRM
467: , p_error_proc_name => G_PKG_NAME||'.valid_view'