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

Line 13: -- Liang Xia 03/17/2003 Fixed bug 2852915 DBMS_SQL.VARIABLE_VALUE

9: -- Liang Xia 5/29/2002 created
10: -- Liang Xia 12/6/2002 Fixed GSCC warning: NOCOPY, no G_MISS ..
11: -- Liang Xia 12/13/2002 Shipped dummy procedures for testing Dyanmic Classification,
12: -- Route and Excecute External Procedure/workflow
13: -- Liang Xia 03/17/2003 Fixed bug 2852915 DBMS_SQL.VARIABLE_VALUE
14: -- Liang Xia 7/24/2004 Fixed bug 3764934 Performance ( closing cursor )
15: -- Liang Xia 11/16/2004 Fixed bug 3982076 procedure name 'test' validation
16: -- Liang Xia 04/06/2005 Fixed GSCC sql.46 ( bug 4256769 )
17: -- --------- ------ ------------------------------------------

Line 364: l_Cursor := DBMS_SQL.OPEN_CURSOR;

360: --l_str :='begin api_adm.GetPassword'||G_ADMIN_LINK||'(:a_user,:b_domain,:c_password);end;';
361: --execute immediate l_str using l_user,p_domain,OUT l_pass;
362:
363: --Open the cursor and parse the statement.
364: l_Cursor := DBMS_SQL.OPEN_CURSOR;
365: DBMS_SQL.PARSE(l_Cursor, l_ProcCall, DBMS_SQL.native);
366:
367: if p_param_type = 'IEMNNUMBER' then
368: DBMS_SQL.BIND_VARIABLE(l_Cursor,l_para_out_name,l_result_n);

Line 365: DBMS_SQL.PARSE(l_Cursor, l_ProcCall, DBMS_SQL.native);

361: --execute immediate l_str using l_user,p_domain,OUT l_pass;
362:
363: --Open the cursor and parse the statement.
364: l_Cursor := DBMS_SQL.OPEN_CURSOR;
365: DBMS_SQL.PARSE(l_Cursor, l_ProcCall, DBMS_SQL.native);
366:
367: if p_param_type = 'IEMNNUMBER' then
368: DBMS_SQL.BIND_VARIABLE(l_Cursor,l_para_out_name,l_result_n);
369: elsif p_param_type = 'IEMSVARCHAR2' then

Line 368: DBMS_SQL.BIND_VARIABLE(l_Cursor,l_para_out_name,l_result_n);

364: l_Cursor := DBMS_SQL.OPEN_CURSOR;
365: DBMS_SQL.PARSE(l_Cursor, l_ProcCall, DBMS_SQL.native);
366:
367: if p_param_type = 'IEMNNUMBER' then
368: DBMS_SQL.BIND_VARIABLE(l_Cursor,l_para_out_name,l_result_n);
369: elsif p_param_type = 'IEMSVARCHAR2' then
370: DBMS_SQL.BIND_VARIABLE(l_Cursor,l_para_out_name,l_result_s,500);
371: else
372: raise l_IEM_INVALID_PARAM_TYPE;

Line 370: DBMS_SQL.BIND_VARIABLE(l_Cursor,l_para_out_name,l_result_s,500);

366:
367: if p_param_type = 'IEMNNUMBER' then
368: DBMS_SQL.BIND_VARIABLE(l_Cursor,l_para_out_name,l_result_n);
369: elsif p_param_type = 'IEMSVARCHAR2' then
370: DBMS_SQL.BIND_VARIABLE(l_Cursor,l_para_out_name,l_result_s,500);
371: else
372: raise l_IEM_INVALID_PARAM_TYPE;
373: end if;
374:

Line 376: l_NumRows := DBMS_SQL.EXECUTE(l_Cursor);

372: raise l_IEM_INVALID_PARAM_TYPE;
373: end if;
374:
375: --Execute the procedure.
376: l_NumRows := DBMS_SQL.EXECUTE(l_Cursor);
377:
378: --DBMS_SQL.VARIABLE_VALUE(l_Cursor, ':'||l_para_out_name, l_result);
379: if p_param_type = 'IEMNNUMBER' then
380: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_n);

Line 378: --DBMS_SQL.VARIABLE_VALUE(l_Cursor, ':'||l_para_out_name, l_result);

374:
375: --Execute the procedure.
376: l_NumRows := DBMS_SQL.EXECUTE(l_Cursor);
377:
378: --DBMS_SQL.VARIABLE_VALUE(l_Cursor, ':'||l_para_out_name, l_result);
379: if p_param_type = 'IEMNNUMBER' then
380: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_n);
381: elsif p_param_type = 'IEMSVARCHAR2' then
382: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_s);

Line 380: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_n);

376: l_NumRows := DBMS_SQL.EXECUTE(l_Cursor);
377:
378: --DBMS_SQL.VARIABLE_VALUE(l_Cursor, ':'||l_para_out_name, l_result);
379: if p_param_type = 'IEMNNUMBER' then
380: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_n);
381: elsif p_param_type = 'IEMSVARCHAR2' then
382: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_s);
383: else
384: raise l_IEM_INVALID_PARAM_TYPE;

Line 382: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_s);

378: --DBMS_SQL.VARIABLE_VALUE(l_Cursor, ':'||l_para_out_name, l_result);
379: if p_param_type = 'IEMNNUMBER' then
380: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_n);
381: elsif p_param_type = 'IEMSVARCHAR2' then
382: DBMS_SQL.VARIABLE_VALUE(l_Cursor, l_para_out_name, l_result_s);
383: else
384: raise l_IEM_INVALID_PARAM_TYPE;
385: end if;
386:

Line 395: DBMS_SQL.close_cursor(l_Cursor);

391: else
392: raise l_IEM_INVALID_PARAM_TYPE;
393: end if;
394:
395: DBMS_SQL.close_cursor(l_Cursor);
396:
397: -- Standard Check Of p_commit.
398: IF FND_API.To_Boolean(p_commit) THEN
399: COMMIT WORK;