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

Line 249: l_cursor := dbms_sql.open_cursor;

245: l_sql := l_sql || l_job_status_clause || l_job_type_clause;
246:
247: wip_ws_util.trace_log('Constructed sql statement = ');
248: wip_ws_util.trace_log(l_sql);
249: l_cursor := dbms_sql.open_cursor;
250: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
251: dbms_sql.bind_variable(l_cursor, ':p_org_id', p_org_id);
252: dbms_sql.bind_variable(l_cursor,':guserid',g_user_id);
253: l_dummy := dbms_sql.execute(l_cursor);

Line 250: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);

246:
247: wip_ws_util.trace_log('Constructed sql statement = ');
248: wip_ws_util.trace_log(l_sql);
249: l_cursor := dbms_sql.open_cursor;
250: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
251: dbms_sql.bind_variable(l_cursor, ':p_org_id', p_org_id);
252: dbms_sql.bind_variable(l_cursor,':guserid',g_user_id);
253: l_dummy := dbms_sql.execute(l_cursor);
254: wip_ws_util.trace_log(' Number of rows inserted = '||sql%rowcount);

Line 251: dbms_sql.bind_variable(l_cursor, ':p_org_id', p_org_id);

247: wip_ws_util.trace_log('Constructed sql statement = ');
248: wip_ws_util.trace_log(l_sql);
249: l_cursor := dbms_sql.open_cursor;
250: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
251: dbms_sql.bind_variable(l_cursor, ':p_org_id', p_org_id);
252: dbms_sql.bind_variable(l_cursor,':guserid',g_user_id);
253: l_dummy := dbms_sql.execute(l_cursor);
254: wip_ws_util.trace_log(' Number of rows inserted = '||sql%rowcount);
255: dbms_sql.close_cursor(l_cursor);

Line 252: dbms_sql.bind_variable(l_cursor,':guserid',g_user_id);

248: wip_ws_util.trace_log(l_sql);
249: l_cursor := dbms_sql.open_cursor;
250: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
251: dbms_sql.bind_variable(l_cursor, ':p_org_id', p_org_id);
252: dbms_sql.bind_variable(l_cursor,':guserid',g_user_id);
253: l_dummy := dbms_sql.execute(l_cursor);
254: wip_ws_util.trace_log(' Number of rows inserted = '||sql%rowcount);
255: dbms_sql.close_cursor(l_cursor);
256:

Line 253: l_dummy := dbms_sql.execute(l_cursor);

249: l_cursor := dbms_sql.open_cursor;
250: dbms_sql.parse(l_cursor, l_sql, dbms_sql.native);
251: dbms_sql.bind_variable(l_cursor, ':p_org_id', p_org_id);
252: dbms_sql.bind_variable(l_cursor,':guserid',g_user_id);
253: l_dummy := dbms_sql.execute(l_cursor);
254: wip_ws_util.trace_log(' Number of rows inserted = '||sql%rowcount);
255: dbms_sql.close_cursor(l_cursor);
256:
257: EXCEPTION

Line 255: dbms_sql.close_cursor(l_cursor);

251: dbms_sql.bind_variable(l_cursor, ':p_org_id', p_org_id);
252: dbms_sql.bind_variable(l_cursor,':guserid',g_user_id);
253: l_dummy := dbms_sql.execute(l_cursor);
254: wip_ws_util.trace_log(' Number of rows inserted = '||sql%rowcount);
255: dbms_sql.close_cursor(l_cursor);
256:
257: EXCEPTION
258: when FND_API.G_EXC_UNEXPECTED_ERROR then
259: wip_ws_util.trace_log('Error message = '||sqlerrm);