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_UTIL dependencies on DBMS_SQL

Line 96: 29-Aug-12 velvanop 115.61 Bug 14482456: For Memory issues, used bind parameter in dynamic sql. Used dbms_sql.bind_variable

92: 02-Mar-07 tjesumic 115.53 Date code calcualtion chnaged. TDRASG and TDPRASG calcualted for all type
93: 15-Mar-07 tjesumic 115.55 the lenght is creating issue with japan customer so get_stat lengh changed
94: to lengthb
95: 30-Apr-08 vkodedal 115.60 entries_affected - added one parameter for penserver
96: 29-Aug-12 velvanop 115.61 Bug 14482456: For Memory issues, used bind parameter in dynamic sql. Used dbms_sql.bind_variable
97: to bind the variable
98: --------------------------------------------------------------------------------
99: */
100: -- package locak globals

Line 816: l_cid := DBMS_SQL.OPEN_CURSOR;

812: 'WHERE ext_rslt_dtl_id = :b1'; -- Bug 14482456:
813: -- For Memory issues, used bind parameter in dynamic sql
814: --to_char(p_ext_rslt_dtl_id);
815: --
816: l_cid := DBMS_SQL.OPEN_CURSOR;
817: DBMS_SQL.PARSE(l_cid, l_string, DBMS_SQL.NATIVE);
818: dbms_sql.bind_variable(l_cid, ':b1', to_char(p_ext_rslt_dtl_id));
819: DBMS_SQL.DEFINE_COLUMN(l_cid, 1, l_value, 200);
820: l_res := DBMS_SQL.EXECUTE(l_cid);

Line 817: DBMS_SQL.PARSE(l_cid, l_string, DBMS_SQL.NATIVE);

813: -- For Memory issues, used bind parameter in dynamic sql
814: --to_char(p_ext_rslt_dtl_id);
815: --
816: l_cid := DBMS_SQL.OPEN_CURSOR;
817: DBMS_SQL.PARSE(l_cid, l_string, DBMS_SQL.NATIVE);
818: dbms_sql.bind_variable(l_cid, ':b1', to_char(p_ext_rslt_dtl_id));
819: DBMS_SQL.DEFINE_COLUMN(l_cid, 1, l_value, 200);
820: l_res := DBMS_SQL.EXECUTE(l_cid);
821: l_res := DBMS_SQL.FETCH_ROWS(l_cid);

Line 818: dbms_sql.bind_variable(l_cid, ':b1', to_char(p_ext_rslt_dtl_id));

814: --to_char(p_ext_rslt_dtl_id);
815: --
816: l_cid := DBMS_SQL.OPEN_CURSOR;
817: DBMS_SQL.PARSE(l_cid, l_string, DBMS_SQL.NATIVE);
818: dbms_sql.bind_variable(l_cid, ':b1', to_char(p_ext_rslt_dtl_id));
819: DBMS_SQL.DEFINE_COLUMN(l_cid, 1, l_value, 200);
820: l_res := DBMS_SQL.EXECUTE(l_cid);
821: l_res := DBMS_SQL.FETCH_ROWS(l_cid);
822: DBMS_SQL.COLUMN_VALUE(l_cid, 1, l_value);

Line 819: DBMS_SQL.DEFINE_COLUMN(l_cid, 1, l_value, 200);

815: --
816: l_cid := DBMS_SQL.OPEN_CURSOR;
817: DBMS_SQL.PARSE(l_cid, l_string, DBMS_SQL.NATIVE);
818: dbms_sql.bind_variable(l_cid, ':b1', to_char(p_ext_rslt_dtl_id));
819: DBMS_SQL.DEFINE_COLUMN(l_cid, 1, l_value, 200);
820: l_res := DBMS_SQL.EXECUTE(l_cid);
821: l_res := DBMS_SQL.FETCH_ROWS(l_cid);
822: DBMS_SQL.COLUMN_VALUE(l_cid, 1, l_value);
823: --

Line 820: l_res := DBMS_SQL.EXECUTE(l_cid);

816: l_cid := DBMS_SQL.OPEN_CURSOR;
817: DBMS_SQL.PARSE(l_cid, l_string, DBMS_SQL.NATIVE);
818: dbms_sql.bind_variable(l_cid, ':b1', to_char(p_ext_rslt_dtl_id));
819: DBMS_SQL.DEFINE_COLUMN(l_cid, 1, l_value, 200);
820: l_res := DBMS_SQL.EXECUTE(l_cid);
821: l_res := DBMS_SQL.FETCH_ROWS(l_cid);
822: DBMS_SQL.COLUMN_VALUE(l_cid, 1, l_value);
823: --
824: DBMS_SQL.CLOSE_CURSOR(l_cid);

Line 821: l_res := DBMS_SQL.FETCH_ROWS(l_cid);

817: DBMS_SQL.PARSE(l_cid, l_string, DBMS_SQL.NATIVE);
818: dbms_sql.bind_variable(l_cid, ':b1', to_char(p_ext_rslt_dtl_id));
819: DBMS_SQL.DEFINE_COLUMN(l_cid, 1, l_value, 200);
820: l_res := DBMS_SQL.EXECUTE(l_cid);
821: l_res := DBMS_SQL.FETCH_ROWS(l_cid);
822: DBMS_SQL.COLUMN_VALUE(l_cid, 1, l_value);
823: --
824: DBMS_SQL.CLOSE_CURSOR(l_cid);
825: --

Line 822: DBMS_SQL.COLUMN_VALUE(l_cid, 1, l_value);

818: dbms_sql.bind_variable(l_cid, ':b1', to_char(p_ext_rslt_dtl_id));
819: DBMS_SQL.DEFINE_COLUMN(l_cid, 1, l_value, 200);
820: l_res := DBMS_SQL.EXECUTE(l_cid);
821: l_res := DBMS_SQL.FETCH_ROWS(l_cid);
822: DBMS_SQL.COLUMN_VALUE(l_cid, 1, l_value);
823: --
824: DBMS_SQL.CLOSE_CURSOR(l_cid);
825: --
826: --

Line 824: DBMS_SQL.CLOSE_CURSOR(l_cid);

820: l_res := DBMS_SQL.EXECUTE(l_cid);
821: l_res := DBMS_SQL.FETCH_ROWS(l_cid);
822: DBMS_SQL.COLUMN_VALUE(l_cid, 1, l_value);
823: --
824: DBMS_SQL.CLOSE_CURSOR(l_cid);
825: --
826: --
827: hr_utility.set_location('Exiting'||l_proc, 5);
828: --