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

Line 261: v_query_hdl := DBMS_SQL.open_cursor;

257: PO_UDA_DEFAULTING_PKG.DEBUG('l_sql_query :' || l_sql_query, d_progress);
258:
259: BEGIN
260: d_progress := 130;
261: v_query_hdl := DBMS_SQL.open_cursor;
262: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
263:
264: DBMS_SQL.bind_variable(v_query_hdl,':p_attr_grp_id',p_attr_grp_id );
265: IF p_pk1_value IS NOT NULL THEN

Line 262: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);

258:
259: BEGIN
260: d_progress := 130;
261: v_query_hdl := DBMS_SQL.open_cursor;
262: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
263:
264: DBMS_SQL.bind_variable(v_query_hdl,':p_attr_grp_id',p_attr_grp_id );
265: IF p_pk1_value IS NOT NULL THEN
266: DBMS_SQL.bind_variable(v_query_hdl,':p_pk1_value',p_pk1_value );

Line 264: DBMS_SQL.bind_variable(v_query_hdl,':p_attr_grp_id',p_attr_grp_id );

260: d_progress := 130;
261: v_query_hdl := DBMS_SQL.open_cursor;
262: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
263:
264: DBMS_SQL.bind_variable(v_query_hdl,':p_attr_grp_id',p_attr_grp_id );
265: IF p_pk1_value IS NOT NULL THEN
266: DBMS_SQL.bind_variable(v_query_hdl,':p_pk1_value',p_pk1_value );
267: END IF ;
268: IF p_pk2_value IS NOT NULL THEN

Line 266: DBMS_SQL.bind_variable(v_query_hdl,':p_pk1_value',p_pk1_value );

262: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
263:
264: DBMS_SQL.bind_variable(v_query_hdl,':p_attr_grp_id',p_attr_grp_id );
265: IF p_pk1_value IS NOT NULL THEN
266: DBMS_SQL.bind_variable(v_query_hdl,':p_pk1_value',p_pk1_value );
267: END IF ;
268: IF p_pk2_value IS NOT NULL THEN
269: DBMS_SQL.bind_variable(v_query_hdl,':p_pk2_value',p_pk2_value);
270: END IF ;

Line 269: DBMS_SQL.bind_variable(v_query_hdl,':p_pk2_value',p_pk2_value);

265: IF p_pk1_value IS NOT NULL THEN
266: DBMS_SQL.bind_variable(v_query_hdl,':p_pk1_value',p_pk1_value );
267: END IF ;
268: IF p_pk2_value IS NOT NULL THEN
269: DBMS_SQL.bind_variable(v_query_hdl,':p_pk2_value',p_pk2_value);
270: END IF ;
271: IF p_pk3_value IS NOT NULL THEN
272: DBMS_SQL.bind_variable(v_query_hdl,':p_pk3_value',p_pk3_value);
273: END IF ;

Line 272: DBMS_SQL.bind_variable(v_query_hdl,':p_pk3_value',p_pk3_value);

268: IF p_pk2_value IS NOT NULL THEN
269: DBMS_SQL.bind_variable(v_query_hdl,':p_pk2_value',p_pk2_value);
270: END IF ;
271: IF p_pk3_value IS NOT NULL THEN
272: DBMS_SQL.bind_variable(v_query_hdl,':p_pk3_value',p_pk3_value);
273: END IF ;
274: IF p_pk4_value IS NOT NULL THEN
275: DBMS_SQL.bind_variable(v_query_hdl,':p_pk4_value',p_pk4_value);
276: END IF ;

Line 275: DBMS_SQL.bind_variable(v_query_hdl,':p_pk4_value',p_pk4_value);

271: IF p_pk3_value IS NOT NULL THEN
272: DBMS_SQL.bind_variable(v_query_hdl,':p_pk3_value',p_pk3_value);
273: END IF ;
274: IF p_pk4_value IS NOT NULL THEN
275: DBMS_SQL.bind_variable(v_query_hdl,':p_pk4_value',p_pk4_value);
276: END IF ;
277: IF p_pk5_value IS NOT NULL THEN
278: DBMS_SQL.bind_variable(v_query_hdl,':p_pk5_value',p_pk5_value);
279: END IF ;

Line 278: DBMS_SQL.bind_variable(v_query_hdl,':p_pk5_value',p_pk5_value);

274: IF p_pk4_value IS NOT NULL THEN
275: DBMS_SQL.bind_variable(v_query_hdl,':p_pk4_value',p_pk4_value);
276: END IF ;
277: IF p_pk5_value IS NOT NULL THEN
278: DBMS_SQL.bind_variable(v_query_hdl,':p_pk5_value',p_pk5_value);
279: END IF ;
280:
281: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
282: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);

Line 281: DBMS_SQL.define_column(v_query_hdl, 1, l_check);

277: IF p_pk5_value IS NOT NULL THEN
278: DBMS_SQL.bind_variable(v_query_hdl,':p_pk5_value',p_pk5_value);
279: END IF ;
280:
281: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
282: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
283:
284: d_progress := 140;
285: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN

Line 282: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);

278: DBMS_SQL.bind_variable(v_query_hdl,':p_pk5_value',p_pk5_value);
279: END IF ;
280:
281: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
282: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
283:
284: d_progress := 140;
285: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN
286: d_progress := 150;

Line 285: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN

281: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
282: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
283:
284: d_progress := 140;
285: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN
286: d_progress := 150;
287: PO_UDA_DEFAULTING_PKG.DEBUG('Returning IS_VALID_AG with TRUE', d_progress);
288: IF DBMS_SQL.is_open(v_query_hdl) THEN
289: DBMS_SQL.close_cursor(v_query_hdl);

Line 288: IF DBMS_SQL.is_open(v_query_hdl) THEN

284: d_progress := 140;
285: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN
286: d_progress := 150;
287: PO_UDA_DEFAULTING_PKG.DEBUG('Returning IS_VALID_AG with TRUE', d_progress);
288: IF DBMS_SQL.is_open(v_query_hdl) THEN
289: DBMS_SQL.close_cursor(v_query_hdl);
290: END IF ;
291: RETURN TRUE;
292: END IF;

Line 289: DBMS_SQL.close_cursor(v_query_hdl);

285: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN
286: d_progress := 150;
287: PO_UDA_DEFAULTING_PKG.DEBUG('Returning IS_VALID_AG with TRUE', d_progress);
288: IF DBMS_SQL.is_open(v_query_hdl) THEN
289: DBMS_SQL.close_cursor(v_query_hdl);
290: END IF ;
291: RETURN TRUE;
292: END IF;
293:

Line 294: IF DBMS_SQL.is_open(v_query_hdl) THEN

290: END IF ;
291: RETURN TRUE;
292: END IF;
293:
294: IF DBMS_SQL.is_open(v_query_hdl) THEN
295: DBMS_SQL.close_cursor(v_query_hdl);
296: END IF ;
297:
298:

Line 295: DBMS_SQL.close_cursor(v_query_hdl);

291: RETURN TRUE;
292: END IF;
293:
294: IF DBMS_SQL.is_open(v_query_hdl) THEN
295: DBMS_SQL.close_cursor(v_query_hdl);
296: END IF ;
297:
298:
299: EXCEPTION

Line 303: IF DBMS_SQL.is_open(v_query_hdl) THEN

299: EXCEPTION
300: WHEN OTHERS THEN
301: d_progress := 150;
302:
303: IF DBMS_SQL.is_open(v_query_hdl) THEN
304: DBMS_SQL.close_cursor(v_query_hdl);
305: END IF ;
306:
307: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to run a sql :' || l_sql_query, d_progress);

Line 304: DBMS_SQL.close_cursor(v_query_hdl);

300: WHEN OTHERS THEN
301: d_progress := 150;
302:
303: IF DBMS_SQL.is_open(v_query_hdl) THEN
304: DBMS_SQL.close_cursor(v_query_hdl);
305: END IF ;
306:
307: PO_UDA_DEFAULTING_PKG.DEBUG('Exception while trying to run a sql :' || l_sql_query, d_progress);
308: RAISE;