APPS.IEX_TRX_GRID_PUB dependencies on DBMS_SQL

Line 149: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

145: ' WHERE delinquency_id IN (' || p_del_ids || ')';
146:
147: iex_debug_pub.LogMessage('l_sql_stmt=' || l_sql_stmt);
148:
149: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
150: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
151: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
152: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
153: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

Line 150: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);

146:
147: iex_debug_pub.LogMessage('l_sql_stmt=' || l_sql_stmt);
148:
149: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
150: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
151: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
152: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
153: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
154:

Line 151: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);

147: iex_debug_pub.LogMessage('l_sql_stmt=' || l_sql_stmt);
148:
149: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
150: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
151: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
152: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
153: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
154:
155: -- Standard check of p_commit

Line 152: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);

148:
149: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
150: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
151: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
152: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
153: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
154:
155: -- Standard check of p_commit
156: IF FND_API.To_Boolean(p_commit) THEN

Line 153: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

149: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
150: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
151: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
152: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
153: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
154:
155: -- Standard check of p_commit
156: IF FND_API.To_Boolean(p_commit) THEN
157: COMMIT WORK;