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

Line 396: cid := DBMS_SQL.OPEN_CURSOR;

392: -- the sql tested before the sql executed, though it is duplicate it is necdesery for bug 3691826
393: -- if the sql errors and the column defined with format , try to convert the colum with theformat to sum
394: -- value 3691826
395:
396: cid := DBMS_SQL.OPEN_CURSOR;
397: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
398: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
399: res := DBMS_SQL.EXECUTE(cid);
400: res := DBMS_SQL.FETCH_ROWS(cid);

Line 397: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);

393: -- if the sql errors and the column defined with format , try to convert the colum with theformat to sum
394: -- value 3691826
395:
396: cid := DBMS_SQL.OPEN_CURSOR;
397: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
398: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
399: res := DBMS_SQL.EXECUTE(cid);
400: res := DBMS_SQL.FETCH_ROWS(cid);
401: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);

Line 398: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);

394: -- value 3691826
395:
396: cid := DBMS_SQL.OPEN_CURSOR;
397: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
398: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
399: res := DBMS_SQL.EXECUTE(cid);
400: res := DBMS_SQL.FETCH_ROWS(cid);
401: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
402: DBMS_SQL.CLOSE_CURSOR(cid);

Line 399: res := DBMS_SQL.EXECUTE(cid);

395:
396: cid := DBMS_SQL.OPEN_CURSOR;
397: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
398: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
399: res := DBMS_SQL.EXECUTE(cid);
400: res := DBMS_SQL.FETCH_ROWS(cid);
401: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
402: DBMS_SQL.CLOSE_CURSOR(cid);
403:

Line 400: res := DBMS_SQL.FETCH_ROWS(cid);

396: cid := DBMS_SQL.OPEN_CURSOR;
397: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
398: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
399: res := DBMS_SQL.EXECUTE(cid);
400: res := DBMS_SQL.FETCH_ROWS(cid);
401: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
402: DBMS_SQL.CLOSE_CURSOR(cid);
403:
404:

Line 401: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);

397: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
398: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
399: res := DBMS_SQL.EXECUTE(cid);
400: res := DBMS_SQL.FETCH_ROWS(cid);
401: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
402: DBMS_SQL.CLOSE_CURSOR(cid);
403:
404:
405: exception

Line 402: DBMS_SQL.CLOSE_CURSOR(cid);

398: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
399: res := DBMS_SQL.EXECUTE(cid);
400: res := DBMS_SQL.FETCH_ROWS(cid);
401: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
402: DBMS_SQL.CLOSE_CURSOR(cid);
403:
404:
405: exception
406: when Others then

Line 435: cid := DBMS_SQL.OPEN_CURSOR;

431: -- dbms_output.put_line(l_smart_ttl_string);
432: --
433: -- This is dynamic SQL part
434: --
435: cid := DBMS_SQL.OPEN_CURSOR;
436: --
437: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
438: --
439: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);

Line 437: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);

433: -- This is dynamic SQL part
434: --
435: cid := DBMS_SQL.OPEN_CURSOR;
436: --
437: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
438: --
439: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
440: res := DBMS_SQL.EXECUTE(cid);
441: res := DBMS_SQL.FETCH_ROWS(cid);

Line 439: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);

435: cid := DBMS_SQL.OPEN_CURSOR;
436: --
437: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
438: --
439: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
440: res := DBMS_SQL.EXECUTE(cid);
441: res := DBMS_SQL.FETCH_ROWS(cid);
442: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
443: DBMS_SQL.CLOSE_CURSOR(cid);

Line 440: res := DBMS_SQL.EXECUTE(cid);

436: --
437: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
438: --
439: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
440: res := DBMS_SQL.EXECUTE(cid);
441: res := DBMS_SQL.FETCH_ROWS(cid);
442: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
443: DBMS_SQL.CLOSE_CURSOR(cid);
444: --

Line 441: res := DBMS_SQL.FETCH_ROWS(cid);

437: DBMS_SQL.PARSE(cid, l_smart_ttl_string, DBMS_SQL.NATIVE);
438: --
439: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
440: res := DBMS_SQL.EXECUTE(cid);
441: res := DBMS_SQL.FETCH_ROWS(cid);
442: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
443: DBMS_SQL.CLOSE_CURSOR(cid);
444: --
445: if p_frmt_mask_cd is null then

Line 442: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);

438: --
439: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
440: res := DBMS_SQL.EXECUTE(cid);
441: res := DBMS_SQL.FETCH_ROWS(cid);
442: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
443: DBMS_SQL.CLOSE_CURSOR(cid);
444: --
445: if p_frmt_mask_cd is null then
446: p_smart_total := ltrim(l_smart_total);

Line 443: DBMS_SQL.CLOSE_CURSOR(cid);

439: DBMS_SQL.DEFINE_COLUMN(cid, 1, l_smart_total, 200);
440: res := DBMS_SQL.EXECUTE(cid);
441: res := DBMS_SQL.FETCH_ROWS(cid);
442: DBMS_SQL.COLUMN_VALUE(cid, 1, l_smart_total);
443: DBMS_SQL.CLOSE_CURSOR(cid);
444: --
445: if p_frmt_mask_cd is null then
446: p_smart_total := ltrim(l_smart_total);
447: else