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

Line 14: cur := DBMS_SQL.open_cursor;

10: lp_sql varchar2(4000);
11:
12: BEGIN
13: lp_sql := p_sql;
14: cur := DBMS_SQL.open_cursor;
15: DBMS_SQL.parse(cur, lp_sql, DBMS_SQL.native);
16: DBMS_SQL.close_cursor (cur);
17: lp_sql := upper(lp_sql);
18:

Line 15: DBMS_SQL.parse(cur, lp_sql, DBMS_SQL.native);

11:
12: BEGIN
13: lp_sql := p_sql;
14: cur := DBMS_SQL.open_cursor;
15: DBMS_SQL.parse(cur, lp_sql, DBMS_SQL.native);
16: DBMS_SQL.close_cursor (cur);
17: lp_sql := upper(lp_sql);
18:
19: SELECT instr(lp_sql, ' ID,')

Line 16: DBMS_SQL.close_cursor (cur);

12: BEGIN
13: lp_sql := p_sql;
14: cur := DBMS_SQL.open_cursor;
15: DBMS_SQL.parse(cur, lp_sql, DBMS_SQL.native);
16: DBMS_SQL.close_cursor (cur);
17: lp_sql := upper(lp_sql);
18:
19: SELECT instr(lp_sql, ' ID,')
20: INTO i

Line 39: DBMS_SQL.close_cursor (cur);

35: EXCEPTION
36: WHEN okl_api.g_exception_error THEN
37: RETURN okl_api.g_ret_sts_error;
38: WHEN OTHERS THEN
39: DBMS_SQL.close_cursor (cur);
40: RETURN okl_api.g_ret_sts_error;
41: END parse_sql; /*header is validated only while creating criteria category as no fields except
42: enabled_yn are updatable after that*/
43: