58: 'WHERE delinquency_id IN (' || p_del_ids || ')';
59:
60: iex_debug_pub.LogMessage('l_sql_stmt=' || l_sql_stmt);
61:
62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
59:
60: iex_debug_pub.LogMessage('l_sql_stmt=' || l_sql_stmt);
61:
62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
60: iex_debug_pub.LogMessage('l_sql_stmt=' || l_sql_stmt);
61:
62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
61:
62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
69:
62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
69:
70: -- Standard check of p_commit
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
69:
70: -- Standard check of p_commit
71: IF FND_API.To_Boolean(p_commit) THEN
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
69:
70: -- Standard check of p_commit
71: IF FND_API.To_Boolean(p_commit) THEN
72: COMMIT WORK;