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.FND_OAM_DSCRAM_DMLS_PKG dependencies on DBMS_SQL

Line 29: -- into a dbms_sql cursor

25: );
26: TYPE b_dml_cache_type IS TABLE OF b_dml_cache_entry INDEX BY BINARY_INTEGER;
27:
28: -- Package cache of DMLs that have been prepared and parsed
29: -- into a dbms_sql cursor
30: b_dml_cache b_dml_cache_type;
31:
32: -- DML ID of the currently executing DML
33: b_current_dml_id NUMBER := NULL;

Line 59: l_ids DBMS_SQL.NUMBER_TABLE;

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

Line 60: l_priorities DBMS_SQL.NUMBER_TABLE;

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

Line 61: l_weights DBMS_SQL.NUMBER_TABLE;

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

Line 213: IF b_dml_cache(p_dml_id).cursor_id IS NOT NULL AND DBMS_SQL.IS_OPEN(b_dml_cache(p_dml_id).cursor_id) THEN

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

Line 214: DBMS_SQL.CLOSE_CURSOR(b_dml_cache(p_dml_id).cursor_id);

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

Line 601: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

597: END IF;
598: END IF;
599:
600: --got a final stmt, put it into a cursor
601: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
602: BEGIN
603: DBMS_SQL.PARSE(l_cursor_id,
604: l_final_dml_stmt,
605: DBMS_SQL.NATIVE);

Line 603: DBMS_SQL.PARSE(l_cursor_id,

599:
600: --got a final stmt, put it into a cursor
601: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
602: BEGIN
603: DBMS_SQL.PARSE(l_cursor_id,
604: l_final_dml_stmt,
605: DBMS_SQL.NATIVE);
606: EXCEPTION
607: WHEN OTHERS THEN

Line 605: DBMS_SQL.NATIVE);

601: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
602: BEGIN
603: DBMS_SQL.PARSE(l_cursor_id,
604: l_final_dml_stmt,
605: DBMS_SQL.NATIVE);
606: EXCEPTION
607: WHEN OTHERS THEN
608: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
609: x_return_msg := 'DML_ID ('||p_dml_id||'), failed to parse final stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';

Line 608: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

604: l_final_dml_stmt,
605: DBMS_SQL.NATIVE);
606: EXCEPTION
607: WHEN OTHERS THEN
608: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
609: x_return_msg := 'DML_ID ('||p_dml_id||'), failed to parse final stmt: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
610: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
611: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
612: RETURN;

Line 623: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

619: l_has_writable_args,
620: l_return_status,
621: l_return_msg);
622: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
623: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
624: x_return_status := l_return_status;
625: x_return_msg := l_return_msg;
626: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
627: RETURN;

Line 725: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,

721:
722: --cache entry should be valid now, do additional bindings if needed
723: IF p_use_splitting THEN
724: fnd_oam_debug.log(1, l_ctxt, 'Binding lower('||p_rowid_lbound||') and upper('||p_rowid_ubound||') rowids');
725: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
726: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,
727: p_rowid_lbound);
728: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
729: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_UBOUND_NAME,

Line 728: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,

724: fnd_oam_debug.log(1, l_ctxt, 'Binding lower('||p_rowid_lbound||') and upper('||p_rowid_ubound||') rowids');
725: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
726: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,
727: p_rowid_lbound);
728: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
729: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_UBOUND_NAME,
730: p_rowid_ubound);
731: END IF;
732:

Line 741: l_rows_processed := DBMS_SQL.EXECUTE(b_dml_cache(p_dml_id).cursor_id);

737: ELSE
738: --do the execute
739: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');
740: BEGIN
741: l_rows_processed := DBMS_SQL.EXECUTE(b_dml_cache(p_dml_id).cursor_id);
742: EXCEPTION
743: WHEN OTHERS THEN
744: x_return_msg := 'SQL execute error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))';
745: fnd_oam_debug.log(6, l_ctxt, x_return_msg);