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);
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);
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);
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:
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
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);