APPS.JTF_RS_DYNAMIC_GROUPS_PVT dependencies on DBMS_SQL

Line 285: l_cursorid := DBMS_SQL.OPEN_CURSOR;

281: THEN
282: if (instr(ltrim(upper(l_sql_text)),'SELECT') = 1) then
283: --VALIDATE SQL STATEMENT
284: BEGIN
285: l_cursorid := DBMS_SQL.OPEN_CURSOR;
286: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);
287: EXCEPTION
288: WHEN OTHERS THEN
289: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 286: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);

282: if (instr(ltrim(upper(l_sql_text)),'SELECT') = 1) then
283: --VALIDATE SQL STATEMENT
284: BEGIN
285: l_cursorid := DBMS_SQL.OPEN_CURSOR;
286: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);
287: EXCEPTION
288: WHEN OTHERS THEN
289: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');

Line 1062: l_cursorid := DBMS_SQL.OPEN_CURSOR;

1058: THEN
1059: if (instr(ltrim(upper(l_sql_text)),'SELECT') = 1) then
1060: --VALIDATE SQL STATEMENT
1061: BEGIN
1062: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1063: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);
1064:
1065: EXCEPTION
1066: WHEN OTHERS THEN

Line 1063: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);

1059: if (instr(ltrim(upper(l_sql_text)),'SELECT') = 1) then
1060: --VALIDATE SQL STATEMENT
1061: BEGIN
1062: l_cursorid := DBMS_SQL.OPEN_CURSOR;
1063: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);
1064:
1065: EXCEPTION
1066: WHEN OTHERS THEN
1067: -- x_return_status := fnd_api.g_ret_sts_unexp_error;