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

Line 13381: v_cursor := DBMS_SQL.OPEN_CURSOR;

13377: x_return_status := FND_API.G_RET_STS_SUCCESS;
13378:
13379: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start');
13380:
13381: v_cursor := DBMS_SQL.OPEN_CURSOR;
13382:
13383: -- clchang updated for sql bind var 05/07/2003
13384: ----v_create_string := vstr1 || l_callback_days || vstr2 || l_callback_days ||
13385: ---- vstr3;

Line 13395: DBMS_SQL.parse(v_cursor, v_create_string, 1);

13391: ', TO_NUMBER(TO_CHAR(SYSDATE + ' || l_callback_days || ',' || '''D''' || ')) FROM DUAL ';
13392: */
13393: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - string='||v_create_string);
13394:
13395: DBMS_SQL.parse(v_cursor, v_create_string, 1);
13396: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13397: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
13398:
13399: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

Line 13396: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);

13392: */
13393: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - string='||v_create_string);
13394:
13395: DBMS_SQL.parse(v_cursor, v_create_string, 1);
13396: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13397: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
13398:
13399: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13400: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

Line 13397: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);

13393: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - string='||v_create_string);
13394:
13395: DBMS_SQL.parse(v_cursor, v_create_string, 1);
13396: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13397: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
13398:
13399: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13400: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13401: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

Line 13399: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

13395: DBMS_SQL.parse(v_cursor, v_create_string, 1);
13396: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13397: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
13398:
13399: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13400: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13401: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
13402: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
13403: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);

Line 13400: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

13396: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13397: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
13398:
13399: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13400: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13401: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
13402: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
13403: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);
13404: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result2='||l_result2);

Line 13401: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

13397: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
13398:
13399: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13400: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13401: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
13402: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
13403: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);
13404: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result2='||l_result2);
13405:

Line 13402: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);

13398:
13399: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13400: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13401: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
13402: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
13403: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);
13404: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result2='||l_result2);
13405:
13406: DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 13406: DBMS_SQL.CLOSE_CURSOR(v_cursor);

13402: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
13403: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);
13404: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result2='||l_result2);
13405:
13406: DBMS_SQL.CLOSE_CURSOR(v_cursor);
13407:
13408: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Close Cursor');
13409:
13410: -- If Weekend => Monday

Line 13422: v_cursor := DBMS_SQL.OPEN_CURSOR;

13418: end if;
13419:
13420: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - callbackdays='||l_callback_days);
13421:
13422: v_cursor := DBMS_SQL.OPEN_CURSOR;
13423: -- clchang updated for sql bind var 05/07/2003
13424: ----v_create_string := vstr4 || l_callback_days || vstr5;
13425: v_create_string := vstr4 || l_correspondence_date || ''',''DD-MON-RR'') + ' || l_callback_days || vstr5;
13426: --v_create_string := 'SELECT SYSDATE + ' || l_callback_days || ' FROM DUAL ';

Line 13430: DBMS_SQL.parse(v_cursor, v_create_string, 1);

13426: --v_create_string := 'SELECT SYSDATE + ' || l_callback_days || ' FROM DUAL ';
13427:
13428: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - createstring='||v_create_string);
13429:
13430: DBMS_SQL.parse(v_cursor, v_create_string, 1);
13431: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13432:
13433: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13434: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

Line 13431: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);

13427:
13428: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - createstring='||v_create_string);
13429:
13430: DBMS_SQL.parse(v_cursor, v_create_string, 1);
13431: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13432:
13433: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13434: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13435: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

Line 13433: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

13429:
13430: DBMS_SQL.parse(v_cursor, v_create_string, 1);
13431: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13432:
13433: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13434: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13435: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
13436: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
13437:

Line 13434: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

13430: DBMS_SQL.parse(v_cursor, v_create_string, 1);
13431: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13432:
13433: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13434: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13435: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
13436: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
13437:
13438: DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 13435: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

13431: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
13432:
13433: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
13434: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13435: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
13436: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
13437:
13438: DBMS_SQL.CLOSE_CURSOR(v_cursor);
13439: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Close Cursor2');

Line 13438: DBMS_SQL.CLOSE_CURSOR(v_cursor);

13434: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
13435: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
13436: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
13437:
13438: DBMS_SQL.CLOSE_CURSOR(v_cursor);
13439: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Close Cursor2');
13440:
13441: x_callback_date := l_result;
13442: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - callback_date='||x_callback_date);

Line 15853: v_cursor := DBMS_SQL.OPEN_CURSOR;

15849: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - final string='||l_query);
15850: end if;
15851: CLOSE C_GET_QUERY;
15852:
15853: v_cursor := DBMS_SQL.OPEN_CURSOR;
15854: v_create_string := l_query;
15855: DBMS_SQL.parse(v_cursor, v_create_string, 1);
15856: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
15857: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

Line 15855: DBMS_SQL.parse(v_cursor, v_create_string, 1);

15851: CLOSE C_GET_QUERY;
15852:
15853: v_cursor := DBMS_SQL.OPEN_CURSOR;
15854: v_create_string := l_query;
15855: DBMS_SQL.parse(v_cursor, v_create_string, 1);
15856: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
15857: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
15858: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
15859: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

Line 15856: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);

15852:
15853: v_cursor := DBMS_SQL.OPEN_CURSOR;
15854: v_create_string := l_query;
15855: DBMS_SQL.parse(v_cursor, v_create_string, 1);
15856: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
15857: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
15858: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
15859: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
15860: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);

Line 15857: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

15853: v_cursor := DBMS_SQL.OPEN_CURSOR;
15854: v_create_string := l_query;
15855: DBMS_SQL.parse(v_cursor, v_create_string, 1);
15856: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
15857: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
15858: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
15859: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
15860: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
15861:

Line 15858: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

15854: v_create_string := l_query;
15855: DBMS_SQL.parse(v_cursor, v_create_string, 1);
15856: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
15857: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
15858: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
15859: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
15860: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
15861:
15862: DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 15859: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

15855: DBMS_SQL.parse(v_cursor, v_create_string, 1);
15856: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
15857: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
15858: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
15859: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
15860: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
15861:
15862: DBMS_SQL.CLOSE_CURSOR(v_cursor);
15863:

Line 15862: DBMS_SQL.CLOSE_CURSOR(v_cursor);

15858: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
15859: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
15860: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
15861:
15862: DBMS_SQL.CLOSE_CURSOR(v_cursor);
15863:
15864: if (l_result > 0) then
15865: l_keep_flag := 1;
15866: else