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 6327: v_cursor := DBMS_SQL.OPEN_CURSOR;

6323:
6324: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start');
6325:
6326:
6327: v_cursor := DBMS_SQL.OPEN_CURSOR;
6328:
6329: -- clchang updated for sql bind var 05/07/2003
6330: v_create_string := vstr1 || l_callback_days || vstr2 || l_callback_days ||
6331: vstr3;

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

6334: ', TO_NUMBER(TO_CHAR(SYSDATE + ' || l_callback_days || ',' || '''D''' || ')) FROM DUAL ';
6335: */
6336: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - string='||v_create_string);
6337:
6338: DBMS_SQL.parse(v_cursor, v_create_string, 1);
6339: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6340: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
6341:
6342: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

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

6335: */
6336: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - string='||v_create_string);
6337:
6338: DBMS_SQL.parse(v_cursor, v_create_string, 1);
6339: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6340: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
6341:
6342: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6343: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

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

6336: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - string='||v_create_string);
6337:
6338: DBMS_SQL.parse(v_cursor, v_create_string, 1);
6339: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6340: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
6341:
6342: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6343: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6344: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

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

6338: DBMS_SQL.parse(v_cursor, v_create_string, 1);
6339: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6340: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
6341:
6342: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6343: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6344: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
6345: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
6346: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);

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

6339: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6340: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
6341:
6342: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6343: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6344: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
6345: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
6346: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);
6347: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result2='||l_result2);

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

6340: DBMS_SQL.DEFINE_COLUMN(v_cursor, 2, l_result2);
6341:
6342: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6343: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6344: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
6345: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
6346: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);
6347: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result2='||l_result2);
6348:

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

6341:
6342: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6343: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6344: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
6345: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
6346: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);
6347: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result2='||l_result2);
6348:
6349: DBMS_SQL.CLOSE_CURSOR(v_cursor);

Line 6349: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6345: DBMS_SQL.COLUMN_VALUE(v_cursor, 2, l_result2);
6346: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result='||l_result);
6347: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_result2='||l_result2);
6348:
6349: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6350:
6351: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Close Cursor');
6352:
6353: -- If Weekend => Monday

Line 6365: v_cursor := DBMS_SQL.OPEN_CURSOR;

6361: end if;
6362:
6363: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - callbackdays='||l_callback_days);
6364:
6365: v_cursor := DBMS_SQL.OPEN_CURSOR;
6366: -- clchang updated for sql bind var 05/07/2003
6367: v_create_string := vstr4 || l_callback_days || vstr5;
6368: --v_create_string := 'SELECT SYSDATE + ' || l_callback_days || ' FROM DUAL ';
6369:

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

6368: --v_create_string := 'SELECT SYSDATE + ' || l_callback_days || ' FROM DUAL ';
6369:
6370: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - createstring='||v_create_string);
6371:
6372: DBMS_SQL.parse(v_cursor, v_create_string, 1);
6373: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6374:
6375: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6376: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);

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

6369:
6370: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - createstring='||v_create_string);
6371:
6372: DBMS_SQL.parse(v_cursor, v_create_string, 1);
6373: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6374:
6375: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6376: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6377: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

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

6371:
6372: DBMS_SQL.parse(v_cursor, v_create_string, 1);
6373: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6374:
6375: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6376: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6377: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
6378: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
6379:

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

6372: DBMS_SQL.parse(v_cursor, v_create_string, 1);
6373: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6374:
6375: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6376: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6377: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
6378: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
6379:
6380: DBMS_SQL.CLOSE_CURSOR(v_cursor);

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

6373: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
6374:
6375: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
6376: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6377: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
6378: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
6379:
6380: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6381: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Close Cursor2');

Line 6380: DBMS_SQL.CLOSE_CURSOR(v_cursor);

6376: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
6377: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
6378: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
6379:
6380: DBMS_SQL.CLOSE_CURSOR(v_cursor);
6381: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Close Cursor2');
6382:
6383: x_callback_date := l_result;
6384: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - callback_date='||x_callback_date);

Line 8349: v_cursor := DBMS_SQL.OPEN_CURSOR;

8345: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - final string='||l_query);
8346: end if;
8347: CLOSE C_GET_QUERY;
8348:
8349: v_cursor := DBMS_SQL.OPEN_CURSOR;
8350: v_create_string := l_query;
8351: DBMS_SQL.parse(v_cursor, v_create_string, 1);
8352: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
8353: v_numrows := DBMS_SQL.EXECUTE(v_cursor);

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

8347: CLOSE C_GET_QUERY;
8348:
8349: v_cursor := DBMS_SQL.OPEN_CURSOR;
8350: v_create_string := l_query;
8351: DBMS_SQL.parse(v_cursor, v_create_string, 1);
8352: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
8353: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
8354: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
8355: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);

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

8348:
8349: v_cursor := DBMS_SQL.OPEN_CURSOR;
8350: v_create_string := l_query;
8351: DBMS_SQL.parse(v_cursor, v_create_string, 1);
8352: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
8353: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
8354: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
8355: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
8356: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);

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

8349: v_cursor := DBMS_SQL.OPEN_CURSOR;
8350: v_create_string := l_query;
8351: DBMS_SQL.parse(v_cursor, v_create_string, 1);
8352: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
8353: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
8354: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
8355: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
8356: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
8357:

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

8350: v_create_string := l_query;
8351: DBMS_SQL.parse(v_cursor, v_create_string, 1);
8352: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
8353: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
8354: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
8355: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
8356: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
8357:
8358: DBMS_SQL.CLOSE_CURSOR(v_cursor);

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

8351: DBMS_SQL.parse(v_cursor, v_create_string, 1);
8352: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, l_result);
8353: v_numrows := DBMS_SQL.EXECUTE(v_cursor);
8354: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
8355: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
8356: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
8357:
8358: DBMS_SQL.CLOSE_CURSOR(v_cursor);
8359:

Line 8358: DBMS_SQL.CLOSE_CURSOR(v_cursor);

8354: v_numrows := DBMS_SQL.FETCH_ROWS(v_cursor);
8355: DBMS_SQL.COLUMN_VALUE(v_cursor, 1, l_result);
8356: WriteLog (G_PKG_NAME || ' ' || l_api_name || ' - result='||l_result);
8357:
8358: DBMS_SQL.CLOSE_CURSOR(v_cursor);
8359:
8360: if (l_result > 0) then
8361: l_keep_flag := 1;
8362: else