APPS.FND_OAM_DSCRAM_PLSQLS_PKG dependencies on DBMS_SQL

Line 28: -- into a dbms_sql cursor

24: );
25: TYPE b_plsql_cache_type IS TABLE OF b_plsql_cache_entry INDEX BY BINARY_INTEGER;
26:
27: -- Package cache of PLSQLs that have been prepared and parsed
28: -- into a dbms_sql cursor
29: b_plsql_cache b_plsql_cache_type;
30:
31: -- PLSQL ID of the currently executing PLSQL
32: b_current_plsql_id NUMBER := NULL;

Line 58: l_ids DBMS_SQL.NUMBER_TABLE;

54: x_return_msg OUT NOCOPY VARCHAR2)
55: IS
56: l_ctxt VARCHAR2(60) := PKG_NAME||'FETCH_PLSQL_IDS';
57:
58: l_ids DBMS_SQL.NUMBER_TABLE;
59: l_priorities DBMS_SQL.NUMBER_TABLE;
60: l_weights DBMS_SQL.NUMBER_TABLE;
61:
62: l_work_queue FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type := FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type();

Line 59: l_priorities DBMS_SQL.NUMBER_TABLE;

55: IS
56: l_ctxt VARCHAR2(60) := PKG_NAME||'FETCH_PLSQL_IDS';
57:
58: l_ids DBMS_SQL.NUMBER_TABLE;
59: l_priorities DBMS_SQL.NUMBER_TABLE;
60: l_weights DBMS_SQL.NUMBER_TABLE;
61:
62: l_work_queue FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type := FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type();
63: k NUMBER;

Line 60: l_weights DBMS_SQL.NUMBER_TABLE;

56: l_ctxt VARCHAR2(60) := PKG_NAME||'FETCH_PLSQL_IDS';
57:
58: l_ids DBMS_SQL.NUMBER_TABLE;
59: l_priorities DBMS_SQL.NUMBER_TABLE;
60: l_weights DBMS_SQL.NUMBER_TABLE;
61:
62: l_work_queue FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type := FND_OAM_DSCRAM_UNITS_PKG.ordered_work_queue_type();
63: k NUMBER;
64: BEGIN

Line 212: IF b_plsql_cache(p_plsql_id).cursor_id IS NOT NULL AND DBMS_SQL.IS_OPEN(b_plsql_cache(p_plsql_id).cursor_id) THEN

208: RETURN;
209: END IF;
210:
211: --now de-allocate the local cursor
212: IF b_plsql_cache(p_plsql_id).cursor_id IS NOT NULL AND DBMS_SQL.IS_OPEN(b_plsql_cache(p_plsql_id).cursor_id) THEN
213: DBMS_SQL.CLOSE_CURSOR(b_plsql_cache(p_plsql_id).cursor_id);
214: END IF;
215:
216: --remove the plsql from the cache

Line 213: DBMS_SQL.CLOSE_CURSOR(b_plsql_cache(p_plsql_id).cursor_id);

209: END IF;
210:
211: --now de-allocate the local cursor
212: IF b_plsql_cache(p_plsql_id).cursor_id IS NOT NULL AND DBMS_SQL.IS_OPEN(b_plsql_cache(p_plsql_id).cursor_id) THEN
213: DBMS_SQL.CLOSE_CURSOR(b_plsql_cache(p_plsql_id).cursor_id);
214: END IF;
215:
216: --remove the plsql from the cache
217: b_plsql_cache.DELETE(p_plsql_id);

Line 574: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

570: END IF;
571: END IF;
572:
573: --got a final stmt, put it into a cursor
574: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
575: BEGIN
576: DBMS_SQL.PARSE(l_cursor_id,
577: l_final_plsql_text,
578: DBMS_SQL.NATIVE);

Line 576: DBMS_SQL.PARSE(l_cursor_id,

572:
573: --got a final stmt, put it into a cursor
574: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
575: BEGIN
576: DBMS_SQL.PARSE(l_cursor_id,
577: l_final_plsql_text,
578: DBMS_SQL.NATIVE);
579: EXCEPTION
580: WHEN OTHERS THEN

Line 578: DBMS_SQL.NATIVE);

574: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
575: BEGIN
576: DBMS_SQL.PARSE(l_cursor_id,
577: l_final_plsql_text,
578: DBMS_SQL.NATIVE);
579: EXCEPTION
580: WHEN OTHERS THEN
581: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
582: x_return_msg := 'PLSQL_ID ('||p_plsql_id||'), failed to parse final stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 581: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

577: l_final_plsql_text,
578: DBMS_SQL.NATIVE);
579: EXCEPTION
580: WHEN OTHERS THEN
581: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
582: x_return_msg := 'PLSQL_ID ('||p_plsql_id||'), failed to parse final stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
583: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
584: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
585: RETURN;

Line 596: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

592: l_has_writable_args,
593: l_return_status,
594: l_return_msg);
595: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
596: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
597: x_return_status := l_return_status;
598: x_return_msg := l_return_msg;
599: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
600: RETURN;

Line 703: l_rows_processed := DBMS_SQL.EXECUTE(b_plsql_cache(p_plsql_id).cursor_id);

699: ELSE
700: --do the execute
701: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');
702: BEGIN
703: l_rows_processed := DBMS_SQL.EXECUTE(b_plsql_cache(p_plsql_id).cursor_id);
704: EXCEPTION
705: WHEN OTHERS THEN
706: x_return_msg := 'SQL execute error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
707: fnd_oam_debug.log(6, l_ctxt, x_return_msg);