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

Line 157: -- to using DBMS_SQL package.

153: -- BUG1899306
154: --
155: -- Since using object type is a violation of Apps standards, we cannot use
156: -- EXECUTE IMMEDIATE. That's why fetching balance feed informations was modified
157: -- to using DBMS_SQL package.
158: --
159: l_feed_bals dbms_sql.Number_Table;
160: l_feed_ivs dbms_sql.Number_Table;
161: l_feed_scales dbms_sql.Number_Table;

Line 159: l_feed_bals dbms_sql.Number_Table;

155: -- Since using object type is a violation of Apps standards, we cannot use
156: -- EXECUTE IMMEDIATE. That's why fetching balance feed informations was modified
157: -- to using DBMS_SQL package.
158: --
159: l_feed_bals dbms_sql.Number_Table;
160: l_feed_ivs dbms_sql.Number_Table;
161: l_feed_scales dbms_sql.Number_Table;
162: l_stmt_str VARCHAR2(32767);
163: l_cur_hdl NUMBER;

Line 160: l_feed_ivs dbms_sql.Number_Table;

156: -- EXECUTE IMMEDIATE. That's why fetching balance feed informations was modified
157: -- to using DBMS_SQL package.
158: --
159: l_feed_bals dbms_sql.Number_Table;
160: l_feed_ivs dbms_sql.Number_Table;
161: l_feed_scales dbms_sql.Number_Table;
162: l_stmt_str VARCHAR2(32767);
163: l_cur_hdl NUMBER;
164: l_rows_processed NUMBER;

Line 161: l_feed_scales dbms_sql.Number_Table;

157: -- to using DBMS_SQL package.
158: --
159: l_feed_bals dbms_sql.Number_Table;
160: l_feed_ivs dbms_sql.Number_Table;
161: l_feed_scales dbms_sql.Number_Table;
162: l_stmt_str VARCHAR2(32767);
163: l_cur_hdl NUMBER;
164: l_rows_processed NUMBER;
165: l_idx NUMBER := 0;

Line 254: -- BUG1899306: Fetch balance feed informations using DBMS_SQL package.

250: OUT l_feed_scales,
251: IN p_feed_checking_date;
252: ************************************************************************************ */
253: --
254: -- BUG1899306: Fetch balance feed informations using DBMS_SQL package.
255: --
256: l_stmt_str := ' select pbf.balance_type_id,
257: pbf.input_value_id,
258: pbf.scale

Line 264: l_cur_hdl := dbms_sql.open_cursor;

260: where pbf.balance_type_id in (' || l_concat_bal || ')
261: and pbf.input_value_id in (' || l_concat_iv || ')
262: and :b_feed_cheking_date
263: between pbf.effective_start_date and pbf.effective_end_date';
264: l_cur_hdl := dbms_sql.open_cursor;
265: dbms_sql.parse(l_cur_hdl, l_stmt_str, DBMS_SQL.NATIVE);
266: dbms_sql.bind_variable(l_cur_hdl, 'b_feed_cheking_date', p_feed_checking_date);
267: dbms_sql.define_array(l_cur_hdl, 1, l_feed_bals, 10, l_idx);
268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);

Line 265: dbms_sql.parse(l_cur_hdl, l_stmt_str, DBMS_SQL.NATIVE);

261: and pbf.input_value_id in (' || l_concat_iv || ')
262: and :b_feed_cheking_date
263: between pbf.effective_start_date and pbf.effective_end_date';
264: l_cur_hdl := dbms_sql.open_cursor;
265: dbms_sql.parse(l_cur_hdl, l_stmt_str, DBMS_SQL.NATIVE);
266: dbms_sql.bind_variable(l_cur_hdl, 'b_feed_cheking_date', p_feed_checking_date);
267: dbms_sql.define_array(l_cur_hdl, 1, l_feed_bals, 10, l_idx);
268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);
269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);

Line 266: dbms_sql.bind_variable(l_cur_hdl, 'b_feed_cheking_date', p_feed_checking_date);

262: and :b_feed_cheking_date
263: between pbf.effective_start_date and pbf.effective_end_date';
264: l_cur_hdl := dbms_sql.open_cursor;
265: dbms_sql.parse(l_cur_hdl, l_stmt_str, DBMS_SQL.NATIVE);
266: dbms_sql.bind_variable(l_cur_hdl, 'b_feed_cheking_date', p_feed_checking_date);
267: dbms_sql.define_array(l_cur_hdl, 1, l_feed_bals, 10, l_idx);
268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);
269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);
270: l_rows_processed := dbms_sql.execute(l_cur_hdl);

Line 267: dbms_sql.define_array(l_cur_hdl, 1, l_feed_bals, 10, l_idx);

263: between pbf.effective_start_date and pbf.effective_end_date';
264: l_cur_hdl := dbms_sql.open_cursor;
265: dbms_sql.parse(l_cur_hdl, l_stmt_str, DBMS_SQL.NATIVE);
266: dbms_sql.bind_variable(l_cur_hdl, 'b_feed_cheking_date', p_feed_checking_date);
267: dbms_sql.define_array(l_cur_hdl, 1, l_feed_bals, 10, l_idx);
268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);
269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);
270: l_rows_processed := dbms_sql.execute(l_cur_hdl);
271: loop

Line 268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);

264: l_cur_hdl := dbms_sql.open_cursor;
265: dbms_sql.parse(l_cur_hdl, l_stmt_str, DBMS_SQL.NATIVE);
266: dbms_sql.bind_variable(l_cur_hdl, 'b_feed_cheking_date', p_feed_checking_date);
267: dbms_sql.define_array(l_cur_hdl, 1, l_feed_bals, 10, l_idx);
268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);
269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);
270: l_rows_processed := dbms_sql.execute(l_cur_hdl);
271: loop
272: l_rows_processed := dbms_sql.fetch_rows(l_cur_hdl);

Line 269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);

265: dbms_sql.parse(l_cur_hdl, l_stmt_str, DBMS_SQL.NATIVE);
266: dbms_sql.bind_variable(l_cur_hdl, 'b_feed_cheking_date', p_feed_checking_date);
267: dbms_sql.define_array(l_cur_hdl, 1, l_feed_bals, 10, l_idx);
268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);
269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);
270: l_rows_processed := dbms_sql.execute(l_cur_hdl);
271: loop
272: l_rows_processed := dbms_sql.fetch_rows(l_cur_hdl);
273: dbms_sql.column_value(l_cur_hdl, 1, l_feed_bals);

Line 270: l_rows_processed := dbms_sql.execute(l_cur_hdl);

266: dbms_sql.bind_variable(l_cur_hdl, 'b_feed_cheking_date', p_feed_checking_date);
267: dbms_sql.define_array(l_cur_hdl, 1, l_feed_bals, 10, l_idx);
268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);
269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);
270: l_rows_processed := dbms_sql.execute(l_cur_hdl);
271: loop
272: l_rows_processed := dbms_sql.fetch_rows(l_cur_hdl);
273: dbms_sql.column_value(l_cur_hdl, 1, l_feed_bals);
274: dbms_sql.column_value(l_cur_hdl, 2, l_feed_ivs);

Line 272: l_rows_processed := dbms_sql.fetch_rows(l_cur_hdl);

268: dbms_sql.define_array(l_cur_hdl, 2, l_feed_ivs, 10, l_idx);
269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);
270: l_rows_processed := dbms_sql.execute(l_cur_hdl);
271: loop
272: l_rows_processed := dbms_sql.fetch_rows(l_cur_hdl);
273: dbms_sql.column_value(l_cur_hdl, 1, l_feed_bals);
274: dbms_sql.column_value(l_cur_hdl, 2, l_feed_ivs);
275: dbms_sql.column_value(l_cur_hdl, 3, l_feed_scales);
276: exit when l_rows_processed <> 10;

Line 273: dbms_sql.column_value(l_cur_hdl, 1, l_feed_bals);

269: dbms_sql.define_array(l_cur_hdl, 3, l_feed_scales, 10, l_idx);
270: l_rows_processed := dbms_sql.execute(l_cur_hdl);
271: loop
272: l_rows_processed := dbms_sql.fetch_rows(l_cur_hdl);
273: dbms_sql.column_value(l_cur_hdl, 1, l_feed_bals);
274: dbms_sql.column_value(l_cur_hdl, 2, l_feed_ivs);
275: dbms_sql.column_value(l_cur_hdl, 3, l_feed_scales);
276: exit when l_rows_processed <> 10;
277: end loop;

Line 274: dbms_sql.column_value(l_cur_hdl, 2, l_feed_ivs);

270: l_rows_processed := dbms_sql.execute(l_cur_hdl);
271: loop
272: l_rows_processed := dbms_sql.fetch_rows(l_cur_hdl);
273: dbms_sql.column_value(l_cur_hdl, 1, l_feed_bals);
274: dbms_sql.column_value(l_cur_hdl, 2, l_feed_ivs);
275: dbms_sql.column_value(l_cur_hdl, 3, l_feed_scales);
276: exit when l_rows_processed <> 10;
277: end loop;
278: dbms_sql.close_cursor(l_cur_hdl);

Line 275: dbms_sql.column_value(l_cur_hdl, 3, l_feed_scales);

271: loop
272: l_rows_processed := dbms_sql.fetch_rows(l_cur_hdl);
273: dbms_sql.column_value(l_cur_hdl, 1, l_feed_bals);
274: dbms_sql.column_value(l_cur_hdl, 2, l_feed_ivs);
275: dbms_sql.column_value(l_cur_hdl, 3, l_feed_scales);
276: exit when l_rows_processed <> 10;
277: end loop;
278: dbms_sql.close_cursor(l_cur_hdl);
279: --

Line 278: dbms_sql.close_cursor(l_cur_hdl);

274: dbms_sql.column_value(l_cur_hdl, 2, l_feed_ivs);
275: dbms_sql.column_value(l_cur_hdl, 3, l_feed_scales);
276: exit when l_rows_processed <> 10;
277: end loop;
278: dbms_sql.close_cursor(l_cur_hdl);
279: --
280: -- l_feed_bals is not NULL even when no records fetched in above SQL statement.
281: -- So not necessary to check l_feed_bals is NULL or not.
282: --